INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','08:18:01'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-31','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-30'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-30'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-30'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-30' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-30'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-30'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-30'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-30'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-31' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-30' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-10-31'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','08:18:14'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-01','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-01'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-31'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-31'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-31' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-31'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-31'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-31'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-31'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-11-01' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-31' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-01'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','08:18:25'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-01'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-01'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-01' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-02'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','08:21:26'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','08:42:04'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04574'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-1-0','00048819','DP-04574JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','1590000','2026-11-02','1590000','4.140','32.00','25','300000','1200000.00','1','0.14', 'input','2026-11-02 08:55:08','4.140','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04574JOG','1','RS 21','','DP-04574'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-1-0','00048819'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-1-0','PSPLT','TOKO','JOGPSN','32.00','4.140','4.140','1','4.140','4.140','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04574JOG '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0001','1','PSPLT-ZKXB-1-0','1','4.140','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.140',berat_out_asli='4.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.140',berat_akhir_asli =berat_akhir_asli-'4.140' WHERE kode_barang='PSPLT-ZKXB-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261102-0001','2026-11-02','2026-11-02','08:56','4.140','input','2026-11-02 08:56:10','THIFA'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261001-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261001-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-2-0','00048820','CBRE-07088 ','CINCIN CBRE-07088 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','12479500','2026-11-02','12479500','7.330','75.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 09:41:12','7.330','0','86.40','18200.00','','TOKO','FREETAG','','10','','','IDB 50 000 000','1','RS22 9B2 1026','BE-261001-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-2-0','00048820'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-2-0','CBRE','TOKO','SEM-BALIK','75.00','7.330','7.330','1','7.330','7.330','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07088 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-2-0','00048820','RD','9','0.270 ','320','86.4'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261002-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261002-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-3-0','00048821','CBRE-04321 ','CINCIN CBRE-04321 ','','GR','---','DM','CBRE','TOKO','CBRE','7593500','2026-11-02','7593500','4.460','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 09:43:27','4.460','0','136.00','18200.00','','TOKO','FREETAG','','10','','0','IDB 36 000 000','2','RS20 7B2 1026','BE-261002-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-3-0','00048821'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-3-0','CBRE','TOKO','CBRE','75.00','4.460','4.460','1','4.460','4.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04321 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-3-0','00048821','RD','1','0.025 ','320','8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-3-0','00048821','RD','6','0.105 ','320','33.6'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-3-0','00048821','RD','6','0.090 ','320','28.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-3-0','00048821','RD','45','0.205 ','320','65.6'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0001','1','CBRE-ZKXB-3-0','1','4.460','4.460','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-3-0','75.00','1','4.460','4.460','1','4.460','4.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.460',berat_out_asli=berat_out_asli+'4.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0001','2026-11-02','2026-11-02','09:43','4.46','input','2026-11-02 09:43:43'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261005-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261005-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GBRE-ZKXB-4-0','00048822','GBRE-01038 ','GBRE-01038 GIA 2437831787 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','21469000','2026-11-02','21469000','12.610','75.00','75.00','0','2270000.00','1','0.04', 'input','2026-11-02 09:46:19','12.610','0','1034.25','18200.00','0','TOKO','FREETAG','','10','','0','GDB 140 000 000','4','DVVS2 40B9 1026','BE-261005-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZKXB-4-0','00048822'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','GBRE-ZKXB-4-0','GBRE','TOKO','GBRE.BALIK','75.00','12.610','12.610','1','12.610','12.610','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01038 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-4-0','00048822','RD','12','0.040 ','450','18'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-4-0','00048822','RD','124','1.525 ','320','488'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-4-0','00048822','RD','50','0.305 ','450','137.25'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-4-0','00048822','RD','1','0.230 ','1700','391'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0002','1','GBRE-ZKXB-4-0','1','12.610','12.610','TOKO','GBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZKXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','GBRE','GBRE-ZKXB-4-0','75.00','1','12.610','12.610','1','12.610','12.610'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'12.610',berat_out_asli=berat_out_asli+'12.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0002','2026-11-02','2026-11-02','09:46','12.61','input','2026-11-02 09:46:33'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261018-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261018-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-5-0','00048823','CBRE-07089 ','CINCIN CBRE-07089 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','5584500','2026-11-02','5584500','3.280','75.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 09:48:38','3.280','0','155.70','18200.00','','TOKO','FREETAG','','10','','','IDB 31 000 000','1','RS16 7B85 1026','BE-261018-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-5-0','00048823'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-5-0','CBRE','TOKO','SEM-BALIK','75.00','3.280','3.280','1','3.280','3.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07089 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-5-0','00048823','RD','15','0.040 ','320','12.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-5-0','00048823','RD','35','0.130 ','320','41.6'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-5-0','00048823','RD','5','0.055 ','320','17.6'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-5-0','00048823','RD','1','0.135 ','620','83.7'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261018-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261018-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GBRE-ZKXB-6-0','00048824','GBRE-00333 ','GELANG GBRE-00333 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','8785000','2026-11-02','8785000','5.160','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 09:51:24','5.160','0','108.80','18200.00','','TOKO','FREETAG','','10','','0','IDB 38 500 000','3','7B4 1026','BE-261018-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZKXB-6-0','00048824'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','GBRE-ZKXB-6-0','GBRE','TOKO','GBRE.BALIK','75.00','5.160','5.160','1','5.160','5.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00333 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-6-0','00048824','RD','3','0.100 ','320','32'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-6-0','00048824','RD','20','0.240 ','320','76.8'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0003','1','GBRE-ZKXB-6-0','1','5.160','5.160','TOKO','GBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZKXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','GBRE','GBRE-ZKXB-6-0','75.00','1','5.160','5.160','1','5.160','5.160'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.160',berat_out_asli=berat_out_asli+'5.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0003','2026-11-02','2026-11-02','09:51','5.16','input','2026-11-02 09:51:37'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261018-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261018-0001'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZKXB-7-0','00048825','TFC-21451 ','TFC-21451 GIA 7481252994 ','','GR','---','DM','TFC','TOKO','TFC','4541000','2026-11-02','4541000','2.410','83.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 09:55:04','2.410','0','375.00','18200.00','','TOKO','FREETAG','','10','','0','GDB 41 000 000','2','DVS1 11B2 1026','FB-261018-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZKXB-7-0','00048825'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','TFC-ZKXB-7-0','TFC','TOKO','TFC','83.00','2.410','2.410','1','2.410','2.410','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFC'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21451 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-7-0','00048825','RD','1','0.300 ','1250','375'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0004','1','TFC-ZKXB-7-0','1','2.410','2.410','TOKO','TFC','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFC-ZKXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','TFC','TFC-ZKXB-7-0','83.00','1','2.410','2.410','1','2.410','2.410'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFC-ZKXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0004','2026-11-02','2026-11-02','09:55','2.41','input','2026-11-02 09:55:18'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261018-0002'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261018-0002'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZKXB-8-0','00048826','TFC-21521 ','CINCIN TFC-21521 ','','GR','---','DM','TFC','TOKO','SEM-BALIK','16140000','2026-11-02','16140000','9.480','75.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 09:57:26','9.480','0','45.50','18200.00','','TOKO','FREETAG','','10','','','IDB 68 000 000','1','RS13 11B2 1026','FB-261018-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZKXB-8-0','00048826'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','TFC-ZKXB-8-0','TFC','TOKO','SEM-BALIK','75.00','9.480','9.480','1','9.480','9.480','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFC'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21521 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-8-0','00048826','BD','1','0.320 ','70','22.4'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-8-0','00048826','BD','32','0.330 ','70','23.1'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261020-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261020-0003'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-9-0','00048827','CBRE-06455 ','CINCIN CBRE-06455 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4522000','2026-11-02','4522000','2.400','83.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:00:43','2.400','200000','115.50','18200.00','','TOKO','FREETAG','','10','','0','IDB 25 500 000','3','RS145 6B8 1026','BE-261020-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-9-0','00048827'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-9-0','CBRE','TOKO','CBRE.BALIK','83.00','2.400','2.400','1','2.400','2.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06455 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-9-0','00048827','RD','6','0.050 ','420','21'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-9-0','00048827','RD','13','0.225 ','420','94.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0005','1','CBRE-ZKXB-9-0','1','2.400','2.400','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-9-0','83.00','1','2.400','2.400','1','2.400','2.400'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0005','2026-11-02','2026-11-02','10:00','2.4','input','2026-11-02 10:00:58'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261020-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261020-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-10-0','00048828','CBRE-07090 ','CINCIN CBRE-07090 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2864000','2026-11-02','2864000','1.520','83.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 10:02:40','1.520','400000','33.60','18200.00','','TOKO','FREETAG','','10','','','IDB 15 000 000','1','RS15 5B6 1026','BE-261020-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-10-0','00048828'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-10-0','CBRE','TOKO','SEM-BALIK','83.00','1.520','1.520','1','1.520','1.520','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07090 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-10-0','00048828','RD','1','0.070 ','480','33.6'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261020-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261020-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-11-0','00048829','CBRE-03117 ','CINCIN CBRE-03117 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1805000','2026-11-02','1805000','1.060','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:04:15','1.060','0','40.50','18200.00','','TOKO','FREETAG','','10','','0','IDB 10 000 000','3','RS15 2B3 1026','BE-261020-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-11-0','00048829'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-11-0','CBRE','TOKO','CBRE.BALIK','75.00','1.060','1.060','1','1.060','1.060','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03117 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-11-0','00048829','RD','27','0.090 ','450','40.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0006','1','CBRE-ZKXB-11-0','1','1.060','1.060','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-11-0','75.00','1','1.060','1.060','1','1.060','1.060'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.060',berat_out_asli=berat_out_asli+'1.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0006','2026-11-02','2026-11-02','10:04','1.06','input','2026-11-02 10:04:32'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261021-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261021-0001'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZKXB-12-0','00048830','TFC-21522 ','CINCIN TFC-21522 ','','GR','---','DM','TFC','TOKO','SEM-BALIK','6810000','2026-11-02','6810000','4.000','75.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 10:06:47','4.000','0','105.60','18200.00','','TOKO','FREETAG','','10','','','IDB 32 500 000','1','RS15 6B4 1026','FB-261021-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZKXB-12-0','00048830'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','TFC-ZKXB-12-0','TFC','TOKO','SEM-BALIK','75.00','4.000','4.000','1','4.000','4.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFC'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21522 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-12-0','00048830','RD','1','0.050 ','480','24'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-12-0','00048830','RD','2','0.065 ','320','20.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-12-0','00048830','RD','4','0.050 ','320','16'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKXB-12-0','00048830','RD','6','0.140 ','320','44.8'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261022-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261022-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GBRE-ZKXB-13-0','00048831','GBRE-00552 ','GELANG GBRE-00552 ','','GR','---','DM','GBRE','TOKO','GBRE','9789500','2026-11-02','9789500','5.750','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:08:34','5.750','0','172.80','18200.00','0','TOKO','FREETAG','','10','','0','IDB 46 500 000','2','9B0 1026','BE-261022-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZKXB-13-0','00048831'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','GBRE-ZKXB-13-0','GBRE','TOKO','GBRE','75.00','5.750','5.750','1','5.750','5.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00552 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZKXB-13-0','00048831','RD','19','0.540 ','320','172.8'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0007','1','GBRE-ZKXB-13-0','1','5.750','5.750','TOKO','GBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZKXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','GBRE','GBRE-ZKXB-13-0','75.00','1','5.750','5.750','1','5.750','5.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.750',berat_out_asli=berat_out_asli+'5.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0007','2026-11-02','2026-11-02','10:08','5.75','input','2026-11-02 10:08:48'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261024-0005'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261024-0005'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-14-0','00048832','CBRE-05511 ','CINCIN CBRE-05511 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2894500','2026-11-02','2894500','1.700','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:10:58','1.700','0','64.58','18200.00','','TOKO','FREETAG','','10','','0','IDB 16 000 000','3','RS8 4B0 1026','BE-261024-0005',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-14-0','00048832'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-14-0','CBRE','TOKO','CBRE.BALIK','75.00','1.700','1.700','1','1.700','1.700','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05511 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-14-0','00048832','RD','1','0.045 ','475','21.38'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-14-0','00048832','RD','8','0.075 ','320','24'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-14-0','00048832','RD','13','0.060 ','320','19.2'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0008','1','CBRE-ZKXB-14-0','1','1.700','1.700','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-14-0','75.00','1','1.700','1.700','1','1.700','1.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0008','2026-11-02','2026-11-02','10:11','1.7','input','2026-11-02 10:11:12'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261024-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261024-0003'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-15-0','00048833','CBRE-06713 ','CINCIN CBRE-06713 ','','GR','---','DM','CBRE','TOKO','CBRE','2043000','2026-11-02','2043000','1.200','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:12:43','1.200','0','62.00','18200.00','','TOKO','FREETAG','','10','','0','IDB 12 000 000','2','RS11 3B15 1026','BE-261024-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-15-0','00048833'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-15-0','CBRE','TOKO','CBRE','75.00','1.200','1.200','1','1.200','1.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06713 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-15-0','00048833','RD','1','0.100 ','620','62'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0009','1','CBRE-ZKXB-15-0','1','1.200','1.200','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-15-0','75.00','1','1.200','1.200','1','1.200','1.200'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0009','2026-11-02','2026-11-02','10:12','1.2','input','2026-11-02 10:12:56'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261024-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261024-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-16-0','00048834','CBRE-07091 ','CINCIN CBRE-07091 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3592500','2026-11-02','3592500','2.110','75.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 10:14:39','2.110','0','44.80','18200.00','','TOKO','FREETAG','','10','','','IDB 17 000 000','1','RS14 3B55 1026','BE-261024-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-16-0','00048834'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-16-0','CBRE','TOKO','SEM-BALIK','75.00','2.110','2.110','1','2.110','2.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07091 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-16-0','00048834','RD','24','0.140 ','320','44.8'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261024-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261024-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-17-0','00048835','CBRE-02724 ','CINCIN CBRE-02724 ','','GR','---','DM','CBRE','TOKO','CBRE','3337000','2026-11-02','3337000','1.960','75.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:16:57','1.960','0','35.20','18200.00','','TOKO','FREETAG','','10','','0','IDB 15 500 000','2','RS13 3B3 1026','BE-261024-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-17-0','00048835'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-17-0','CBRE','TOKO','CBRE','75.00','1.960','1.960','1','1.960','1.960','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02724 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-17-0','00048835','RD','25','0.110 ','320','35.2'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0010','1','CBRE-ZKXB-17-0','1','1.960','1.960','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-17-0','75.00','1','1.960','1.960','1','1.960','1.960'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0010','2026-11-02','2026-11-02','10:17','1.96','input','2026-11-02 10:17:09'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261029-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261029-0003'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LBRE-ZKXB-18-0','00048836','LBRE-00735 ','LIONTIN LBRE-00735 ','','GR','---','DM','LBRE','TOKO','LBRE','1187500','2026-11-02','1187500','0.630','83.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:38:35','0.630','0','42.75','18200.00','','TOKO','FREETAG','','10','','0','IDB 8 000 000','2','1B95 1026','BE-261029-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZKXB-18-0','00048836'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','LBRE-ZKXB-18-0','LBRE','TOKO','LBRE','83.00','0.630','0.630','1','0.630','0.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00735 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKXB-18-0','00048836','RD','5','0.035 ','450','15.75'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKXB-18-0','00048836','RD','12','0.060 ','450','27'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0011','1','LBRE-ZKXB-18-0','1','0.630','0.630','TOKO','LBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZKXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','LBRE','LBRE-ZKXB-18-0','83.00','1','0.630','0.630','1','0.630','0.630'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.630',berat_out_asli=berat_out_asli+'0.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='LBRE-ZKXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0011','2026-11-02','2026-11-02','10:38','0.63','input','2026-11-02 10:38:53'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261029-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261029-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZKXB-19-0','00048837','CBRE-00276 ','CINCIN CBRE-00276 ','','GR','---','DM','CBRE','TOKO','CBRE','3660500','2026-11-02','3660500','2.150','75.00','75.00','0','2270000.00','1','0.04', 'input','2026-11-02 10:40:35','2.150','0','78.90','18200.00','','TOKO','FREETAG','','10','','0','IDB 20 000 000','2','RS105 3B85 1026','BE-261029-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKXB-19-0','00048837'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CBRE-ZKXB-19-0','CBRE','TOKO','CBRE','75.00','2.150','2.150','1','2.150','2.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00276 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-19-0','00048837','RD','13','0.170 ','320','54.4'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKXB-19-0','00048837','SP','1','0.490 ','50','24.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0012','1','CBRE-ZKXB-19-0','1','2.150','2.150','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','CBRE','CBRE-ZKXB-19-0','75.00','1','2.150','2.150','1','2.150','2.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.150',berat_out_asli=berat_out_asli+'2.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0012','2026-11-02','2026-11-02','10:40','2.15','input','2026-11-02 10:40:48'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261029-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261029-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('ABRE-ZKXB-20-0','00048838','ABRE-01990 ','GIWANG ABRE-01990 ','','GR','---','DM','ABRE','TOKO','ABRE','4861500','2026-11-02','4861500','2.580','83.00','75','0','2270000.00','1','0.04', 'input','2026-11-02 10:42:12','2.580','0','254.55','18200.00','','TOKO','FREETAG','','10','','0','IDB 35 500 000','2','9B05 1026','BE-261029-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZKXB-20-0','00048838'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','ABRE-ZKXB-20-0','ABRE','TOKO','ABRE','83.00','2.580','2.580','1','2.580','2.580','1'); DELETE FROM tp_kode_intern WHERE kode_dept='ABRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01990 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZKXB-20-0','00048838','RD','2','0.240 ','620','148.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZKXB-20-0','00048838','RD','32','0.235 ','450','105.75'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0013','1','ABRE-ZKXB-20-0','1','2.580','2.580','TOKO','ABRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZKXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','SEM-BALIK','ABRE','ABRE-ZKXB-20-0','83.00','1','2.580','2.580','1','2.580','2.580'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.580',berat_out_asli=berat_out_asli+'2.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='ABRE-ZKXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0013','2026-11-02','2026-11-02','10:42','2.58','input','2026-11-02 10:42:25'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261026-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261026-0001'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFGRP-ZKXB-21-0','00048839','TFGRP75-76% ','THIFA GELANG RANTAI PUTIH ','','GR','---','GOLD','TFGRP','TOKO','SEM-EMAS','4969000','2026-11-02','4969000','2.880','76.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 10:44:57','2.880','0','','18200.00','','TOKO','FREETAG','','2','','','','2','','FB-261026-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRP','TFGRP-ZKXB-21-0','00048839'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','TFGRP-ZKXB-21-0','TFGRP','TOKO','SEM-EMAS','76.00','2.880','2.880','1','2.880','2.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRP','TFGRP75-76% '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261026-0002'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261026-0002'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFCMP-ZKXB-22-0','00048840','TFCMP75-76% ','THIFA CINCIN MAS PUTIH ','','GR','---','GOLD','TFCMP','TOKO','SEM-EMAS','1553000','2026-11-02','1553000','0.900','76.00','75','0','2270000.00','1','0.14', 'input','2026-11-02 10:46:14','0.900','0','','18200.00','','TOKO','FREETAG','','2','','','','2','','FB-261026-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'TFCMP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFCMP','TFCMP-ZKXB-22-0','00048840'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','TFCMP-ZKXB-22-0','TFCMP','TOKO','SEM-EMAS','76.00','0.900','0.900','1','0.900','0.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFCMP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFCMP','TFCMP75-76% '); UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2314500',harga_beli ='2314500' WHERE kode_barcode='00001136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4687500',harga_beli ='4687500' WHERE kode_barcode='00001394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='182500',harga_beli ='182500' WHERE kode_barcode='00001984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2652000',harga_beli ='2652000' WHERE kode_barcode='00002031' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5871500',harga_beli ='5871500' WHERE kode_barcode='00002094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2199500',harga_beli ='2199500' WHERE kode_barcode='00003287' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2104000',harga_beli ='2104000' WHERE kode_barcode='00003288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00003289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5106500',harga_beli ='5106500' WHERE kode_barcode='00003290' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18857500',harga_beli ='18857500' WHERE kode_barcode='00003291' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2623500',harga_beli ='2623500' WHERE kode_barcode='00005675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2600000',harga_beli ='2600000' WHERE kode_barcode='00005680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00005686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2552000',harga_beli ='2552000' WHERE kode_barcode='00005694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2528500',harga_beli ='2528500' WHERE kode_barcode='00005695' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7096500',harga_beli ='7096500' WHERE kode_barcode='00006371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='00007446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9733500',harga_beli ='9733500' WHERE kode_barcode='00007503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3511000',harga_beli ='3511000' WHERE kode_barcode='00014815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00015245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00015248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4986500',harga_beli ='4986500' WHERE kode_barcode='00016090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4034000',harga_beli ='4034000' WHERE kode_barcode='00016091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5771000',harga_beli ='5771000' WHERE kode_barcode='00019597' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6891500',harga_beli ='6891500' WHERE kode_barcode='00019598' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8310500',harga_beli ='8310500' WHERE kode_barcode='00019599' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00020277' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00020571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2596000',harga_beli ='2596000' WHERE kode_barcode='00023554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3959500',harga_beli ='3959500' WHERE kode_barcode='00023557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3586000',harga_beli ='3586000' WHERE kode_barcode='00023558' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2054500',harga_beli ='2054500' WHERE kode_barcode='00023559' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1980000',harga_beli ='1980000' WHERE kode_barcode='00023560' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6069500',harga_beli ='6069500' WHERE kode_barcode='00023561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00023565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3249500',harga_beli ='3249500' WHERE kode_barcode='00023566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6443000',harga_beli ='6443000' WHERE kode_barcode='00023567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5117000',harga_beli ='5117000' WHERE kode_barcode='00023569' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2484000',harga_beli ='2484000' WHERE kode_barcode='00023577' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2110500',harga_beli ='2110500' WHERE kode_barcode='00023578' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00023579' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3361500',harga_beli ='3361500' WHERE kode_barcode='00023581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4983000',harga_beli ='4983000' WHERE kode_barcode='00023587' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00023669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9730000',harga_beli ='9730000' WHERE kode_barcode='00023670' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8777500',harga_beli ='8777500' WHERE kode_barcode='00023671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00023673' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5005000',harga_beli ='5005000' WHERE kode_barcode='00023675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6984500',harga_beli ='6984500' WHERE kode_barcode='00023677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6368500',harga_beli ='6368500' WHERE kode_barcode='00023678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6555000',harga_beli ='6555000' WHERE kode_barcode='00023696' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7526500',harga_beli ='7526500' WHERE kode_barcode='00023698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15015000',harga_beli ='15015000' WHERE kode_barcode='00023884' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1531500',harga_beli ='1531500' WHERE kode_barcode='00023899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1531500',harga_beli ='1531500' WHERE kode_barcode='00023900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1457000',harga_beli ='1457000' WHERE kode_barcode='00023902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00023903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4631500',harga_beli ='4631500' WHERE kode_barcode='00023909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7956000',harga_beli ='7956000' WHERE kode_barcode='00023910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9095000',harga_beli ='9095000' WHERE kode_barcode='00023911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00023963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7246000',harga_beli ='7246000' WHERE kode_barcode='00024003' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7937000',harga_beli ='7937000' WHERE kode_barcode='00024088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7078000',harga_beli ='7078000' WHERE kode_barcode='00024116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4221000',harga_beli ='4221000' WHERE kode_barcode='00024117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='50665500',harga_beli ='50665500' WHERE kode_barcode='00024185' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7881000',harga_beli ='7881000' WHERE kode_barcode='00024187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00024190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00024191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10365000',harga_beli ='10365000' WHERE kode_barcode='00024259' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12028000',harga_beli ='12028000' WHERE kode_barcode='00024357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6910000',harga_beli ='6910000' WHERE kode_barcode='00024362' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5584000',harga_beli ='5584000' WHERE kode_barcode='00025021' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00026264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00026265' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12369500',harga_beli ='12369500' WHERE kode_barcode='00048820' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7526500',harga_beli ='7526500' WHERE kode_barcode='00048821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21279500',harga_beli ='21279500' WHERE kode_barcode='00048822' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5535000',harga_beli ='5535000' WHERE kode_barcode='00048823' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8707500',harga_beli ='8707500' WHERE kode_barcode='00048824' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00048825' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15997500',harga_beli ='15997500' WHERE kode_barcode='00048826' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4482000',harga_beli ='4482000' WHERE kode_barcode='00048827' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2839000',harga_beli ='2839000' WHERE kode_barcode='00048828' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1789000',harga_beli ='1789000' WHERE kode_barcode='00048829' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6750000',harga_beli ='6750000' WHERE kode_barcode='00048830' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9703500',harga_beli ='9703500' WHERE kode_barcode='00048831' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2869000',harga_beli ='2869000' WHERE kode_barcode='00048832' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2025000',harga_beli ='2025000' WHERE kode_barcode='00048833' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3561000',harga_beli ='3561000' WHERE kode_barcode='00048834' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3307500',harga_beli ='3307500' WHERE kode_barcode='00048835' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1177000',harga_beli ='1177000' WHERE kode_barcode='00048836' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3628500',harga_beli ='3628500' WHERE kode_barcode='00048837' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4818500',harga_beli ='4818500' WHERE kode_barcode='00048838' LIMIT 1; UPDATE tm_group SET harga='2250000' WHERE kode_group = 'DM' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2250000','input','2026-11-02 13:04:13'); UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15778500',harga_beli ='15778500' WHERE kode_barcode='00001173' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9256500',harga_beli ='9256500' WHERE kode_barcode='00001223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4877000',harga_beli ='4877000' WHERE kode_barcode='00001224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4915500',harga_beli ='4915500' WHERE kode_barcode='00001225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5704000',harga_beli ='5704000' WHERE kode_barcode='00002442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4329500',harga_beli ='4329500' WHERE kode_barcode='00004222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10753000',harga_beli ='10753000' WHERE kode_barcode='00006106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='00006485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12375000',harga_beli ='12375000' WHERE kode_barcode='00034435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5883000',harga_beli ='5883000' WHERE kode_barcode='00038144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='252000500',harga_beli ='252000500' WHERE kode_barcode='00046097' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='252000500',harga_beli ='252000500' WHERE kode_barcode='00046098' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046099' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046101' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='126000500',harga_beli ='126000500' WHERE kode_barcode='00046104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4925000',harga_beli ='4925000' WHERE kode_barcode='00048839' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='00048840' LIMIT 1; UPDATE tm_group SET harga='2250000' WHERE kode_group = 'GOLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2250000','input','2026-11-02 13:04:20'); UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2250000','input','2026-11-02 13:04:27'); UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2250000','input','2026-11-02 13:04:32'); UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2250000','input','2026-11-02 13:04:40'); UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2250000','input','2026-11-02 13:04:47'); UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2250000','input','2026-11-02 13:04:52'); UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00033486' LIMIT 1; UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2250000','input','2026-11-02 13:04:57'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04539'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-23-0','00048841','DP-04539BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','510500','2026-11-02','510500','2.500','17.00','10','430000','1200000.00','1','0.14', 'input','2026-11-02 13:05:59','2.500','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04539BIP','1','RS 13 5','','DP-04539'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-23-0','00048841'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-23-0','PSPLT','TOKO','PSNB','17.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04539BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04531'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-24-0','00048842','DP-04531BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','645000','2026-11-02','645000','3.160','17.00','10','250000','1200000.00','1','0.14', 'input','2026-11-02 13:07:20','3.160','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04531BIP','1','RS 18 5','','DP-04531'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-24-0','00048842'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-24-0','PSPLT','TOKO','PSNB','17.00','3.160','3.160','1','3.160','3.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04531BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04503'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-25-0','00048843','DP-04503BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','559000','2026-11-02','559000','2.740','17.00','10','260000','1200000.00','1','0.14', 'input','2026-11-02 13:08:46','2.740','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04503BIP','1','RS 16','','DP-04503'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-25-0','00048843'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-25-0','PSPLT','TOKO','PSNB','17.00','2.740','2.740','1','2.740','2.740','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04503BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04520'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-26-0','00048844','DP-04520BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','637000','2026-11-02','637000','3.120','17.00','10','420000','1200000.00','1','0.14', 'input','2026-11-02 13:10:26','3.120','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04520BIP','1','RS 17','','DP-04520'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-26-0','00048844'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-26-0','PSPLT','TOKO','PSNB','17.00','3.120','3.120','1','3.120','3.120','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04520BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04511'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-27-0','00048845','DP-04511BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','659000','2026-11-02','659000','3.230','17.00','10','260000','1200000.00','1','0.14', 'input','2026-11-02 13:11:43','3.230','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04511BIP','1','RS 21','','DP-04511'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-27-0','00048845'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-27-0','PSPLT','TOKO','PSNB','17.00','3.230','3.230','1','3.230','3.230','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04511BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04488'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-28-0','00048846','DP-04488BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1248000','2026-11-02','1248000','3.250','32.00','25','260000','1200000.00','1','0.14', 'input','2026-11-02 13:13:01','3.250','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04488BIP','1','RS 10 5','','DP-04488'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-28-0','00048846'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-28-0','PSPLT','TOKO','PSNB','32.00','3.250','3.250','1','3.250','3.250','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04488BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04510'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-29-0','00048847','DP-04510BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','473500','2026-11-02','473500','2.320','17.00','10','430000','1200000.00','1','0.14', 'input','2026-11-02 13:14:22','2.320','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04510BIP','1','RS 18','','DP-04510'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-29-0','00048847'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-29-0','PSPLT','TOKO','PSNB','17.00','2.320','2.320','1','2.320','2.320','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04510BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04508'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-30-0','00048848','DP-04508BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','600000','2026-11-02','600000','2.940','17.00','10','300000','1200000.00','1','0.14', 'input','2026-11-02 13:15:51','2.940','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04508BIP','1','RS 13 5','','DP-04508'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-30-0','00048848'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-30-0','PSPLT','TOKO','PSNB','17.00','2.940','2.940','1','2.940','2.940','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04508BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04489'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-31-0','00048849','DP-04489BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1283000','2026-11-02','1283000','3.340','32.00','25','260000','1200000.00','1','0.14', 'input','2026-11-02 13:17:07','3.340','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04489BIP','1','RS 16 5','','DP-04489'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-31-0','00048849'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-31-0','PSPLT','TOKO','PSNB','32.00','3.340','3.340','1','3.340','3.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04489BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04699'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-32-0','00048850','DP-04699BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','594000','2026-11-02','594000','2.910','17.00','10','260000','1200000.00','1','0.14', 'input','2026-11-02 13:18:37','2.910','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04699BIP','1','RS 22','','DP-04699'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-32-0','00048850'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-32-0','PSPLT','TOKO','PSNB','17.00','2.910','2.910','1','2.910','2.910','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04699BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04446'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-33-0','00048851','DP-04446BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','207500','2026-11-02','207500','2.070','100.00','925','210000','100000.00','1','0.14', 'input','2026-11-02 13:19:55','2.070','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04446BIP','1','RS 15','','DP-04446'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-33-0','00048851'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-33-0','PSPRT','TOKO','PSNB','100.00','2.070','2.070','1','2.070','2.070','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04446BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04673'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-34-0','00048852','DP-04673BIP ','CINCIN PERAK SR05 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','280000','2026-11-02','280000','2.800','100.00','925','410000','100000.00','1','0.14', 'input','2026-11-02 13:21:28','2.800','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04673BIP','1','RS 13 RS 14','','DP-04673'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-34-0','00048852'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-34-0','PSPRT','TOKO','PSNB','100.00','2.800','2.800','1','2.800','2.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04673BIP '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04362'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-35-0','00048853','DP-04362DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','318000','2026-11-02','318000','3.180','100.00','925','210000','100000.00','1','0.14', 'input','2026-11-02 13:29:15','3.180','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04362DU','1','RS 18','','DP-04362'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-35-0','00048853'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-35-0','PSPRT','TOKO','DUPSN','100.00','3.180','3.180','1','3.180','3.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04362DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04525'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZKXB-36-0','00048854','DP-04525DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2629500','2026-11-02','2629500','2.050','57.00','50','390000','2250000.00','1','0.14', 'input','2026-11-02 13:30:23','2.050','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04525DU','1','RS 9','','DP-04525'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZKXB-36-0','00048854'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSGT-ZKXB-36-0','PSGT','TOKO','DUPSN','57.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04525DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04363'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-37-0','00048855','DP-04363DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','159000','2026-11-02','159000','1.590','100.00','925','700000','100000.00','1','0.14', 'input','2026-11-02 13:31:57','1.590','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04363DU','1','RS 9','','DP-04363'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-37-0','00048855'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-37-0','PSPRT','TOKO','DUPSN','100.00','1.590','1.590','1','1.590','1.590','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04363DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04464'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-38-0','00048856','DP-04464DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','379500','2026-11-02','379500','1.860','17.00','10','460000','1200000.00','1','0.14', 'input','2026-11-02 13:33:39','1.860','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04464DU','1','RS 13','','DP-04464'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-38-0','00048856'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-38-0','PSPLT','TOKO','DUPSN','17.00','1.860','1.860','1','1.860','1.860','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04464DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04517'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-39-0','00048857','DP-04517DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','488000','2026-11-02','488000','2.390','17.00','10','750000','1200000.00','1','0.14', 'input','2026-11-02 13:35:22','2.390','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04517DU','1','RS 14','','DP-04517'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-39-0','00048857'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-39-0','PSPLT','TOKO','DUPSN','17.00','2.390','2.390','1','2.390','2.390','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04517DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04521'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-40-0','00048858','DP-04521DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','563500','2026-11-02','563500','2.760','17.00','10','280000','1200000.00','1','0.14', 'input','2026-11-02 13:36:38','2.760','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04521DU','1','RS 14','','DP-04521'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-40-0','00048858'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-40-0','PSPLT','TOKO','DUPSN','17.00','2.760','2.760','1','2.760','2.760','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04521DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04465'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZKXB-41-0','00048859','DP-04465DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','618500','2026-11-02','618500','3.030','17.00','10','260000','1200000.00','1','0.14', 'input','2026-11-02 13:37:53','3.030','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04465DU','1','RS 21','','DP-04465'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXB-41-0','00048859'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLT-ZKXB-41-0','PSPLT','TOKO','DUPSN','17.00','3.030','3.030','1','3.030','3.030','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04465DU '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04548'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-42-0','00048860','DP-04548SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','273000','2026-11-02','273000','2.730','100.00','925','350000','100000.00','1','0.014', 'input','2026-11-02 13:45:01','2.730','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04548SBY','1','RS 14','','DP-04548'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-42-0','00048860'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-42-0','PSPRT','TOKO','SBYPSN','100.00','2.730','2.730','1','2.730','2.730','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04548SBY '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04512'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-43-0','00048861','DP-04512SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','385000','2026-11-02','385000','3.850','100.00','925','210000','100000.00','1','0.014', 'input','2026-11-02 13:46:34','3.850','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04512SBY','1','RS 18 5','','DP-04512'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-43-0','00048861'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-43-0','PSPRT','TOKO','SBYPSN','100.00','3.850','3.850','1','3.850','3.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04512SBY '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03158'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLE-ZKXB-44-0','00048862','DP-03158 ','CINCIN PALADIUM YL10 ','','GR','---','PSPLE','PSPLE','TOKO','PSN','792000','2026-11-02','792000','3.880','17.00','10','250000','1200000.00','1','0.04', 'input','2026-11-02 14:02:50','3.880','0','','18200.00','','TOKO','FREETAG','','10','','','PSN03158','1','RS 23','','DP-03158'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-ZKXB-44-0','00048862'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPLE-ZKXB-44-0','PSPLE','TOKO','PSN','17.00','3.880','3.880','1','3.880','3.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-03158 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-04577'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZKXB-45-0','00048863','DP-04577MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','463000','2026-11-02','463000','4.630','100.00','925','200000','100000.00','1','0.14', 'input','2026-11-02 14:04:22','4.630','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04577MM','1','RS 25','','DP-04577'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXB-45-0','00048863'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','PSPRT-ZKXB-45-0','PSPRT','TOKO','MMPSN','100.00','4.630','4.630','1','4.630','4.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04577MM '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKSE-ZKXB-46-0','00048864','750K-7 ','CINCIN KAWIN SIRKON SR04 ','','GR','---','GOLD','CKSE','TOKO','CKS','1154500','2026-11-02','1154500','1.140','45.00','375','260000','2250000.00','1','0.04', 'input','2026-11-02 14:06:57','1.140','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKSE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKSE','CKSE-ZKXB-46-0','00048864'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CKSE-ZKXB-46-0','CKSE','TOKO','CKS','45.00','1.140','1.140','1','1.140','1.140','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKSE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKSE','750K-7 '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKSE-ZKXB-47-0','00048865','750K-11 ','CINCIN KAWIN SIRKON SR03 ','','GR','---','GOLD','CKSE','TOKO','CKS','1458000','2026-11-02','1458000','1.440','45.00','375','260000','2250000.00','1','0.04', 'input','2026-11-02 14:07:47','1.440','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKSE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKSE','CKSE-ZKXB-47-0','00048865'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CKSE-ZKXB-47-0','CKSE','TOKO','CKS','45.00','1.440','1.440','1','1.440','1.440','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKSE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKSE','750K-11 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZKXB-48-0','00048866','750K-10 ','CINCIN EMAS SR04 ','','GR','---','GOLD','CMMM','TOKO','MMCM','1245500','2026-11-02','1245500','1.230','45.00','375','260000','2250000.00','1','0.14', 'input','2026-11-02 14:11:11','1.230','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZKXB-48-0','00048866'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMMM-ZKXB-48-0','CMMM','TOKO','MMCM','45.00','1.230','1.230','1','1.230','1.230','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','750K-10 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZKXB-49-0','00048867','750K-95 ','CINCIN EMAS SR03 ','','GR','---','GOLD','CMMM','TOKO','MMCM','1488500','2026-11-02','1488500','1.470','45.00','375','260000','2250000.00','1','0.14', 'input','2026-11-02 14:11:42','1.470','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZKXB-49-0','00048867'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMMM-ZKXB-49-0','CMMM','TOKO','MMCM','45.00','1.470','1.470','1','1.470','1.470','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','750K-95 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXCM-ZKXB-50-0','00048868','750K-85 ','CINCIN EMAS ','','GR','---','GOLD','LXCM','TOKO','DUCM','1276000','2026-11-02','1276000','1.260','45.00','375','260000','2250000.00','1','0.014', 'input','2026-11-02 14:14:14','1.260','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZKXB-50-0','00048868'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','LXCM-ZKXB-50-0','LXCM','TOKO','DUCM','45.00','1.260','1.260','1','1.260','1.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','750K-85 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXCM-ZKXB-51-0','00048869','750K-115 ','CINCIN EMAS ','','GR','---','GOLD','LXCM','TOKO','DUCM','1873500','2026-11-02','1873500','1.850','45.00','375','260000','2250000.00','1','0.014', 'input','2026-11-02 14:14:57','1.850','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZKXB-51-0','00048869'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','LXCM-ZKXB-51-0','LXCM','TOKO','DUCM','45.00','1.850','1.850','1','1.850','1.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','750K-115 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXCM-ZKXB-52-0','00048870','900K-85 ','CINCIN EMAS ','','GR','---','GOLD','LXCM','TOKO','DUCM','1357000','2026-11-02','1357000','1.340','45.00','375','480000','2250000.00','1','0.014', 'input','2026-11-02 14:15:59','1.340','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZKXB-52-0','00048870'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','LXCM-ZKXB-52-0','LXCM','TOKO','DUCM','45.00','1.340','1.340','1','1.340','1.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','900K-85 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCM-ZKXB-53-0','00048871','750K-115 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','1357000','2026-11-02','1357000','1.340','45.00','375','260000','2250000.00','1','0.14', 'input','2026-11-02 14:24:21','1.340','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZKXB-53-0','00048871'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','BDCM-ZKXB-53-0','BDCM','TOKO','CMBD','45.00','1.340','1.340','1','1.340','1.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','750K-115 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCM-ZKXB-54-0','00048872','750K-125 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','2015000','2026-11-02','2015000','1.990','45.00','375','260000','2250000.00','1','0.14', 'input','2026-11-02 14:24:51','1.990','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZKXB-54-0','00048872'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','BDCM-ZKXB-54-0','BDCM','TOKO','CMBD','45.00','1.990','1.990','1','1.990','1.990','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','750K-125 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCM-ZKXB-55-0','00048873','900K-105 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','1357000','2026-11-02','1357000','1.340','45.00','375','480000','2250000.00','1','0.14', 'input','2026-11-02 14:25:31','1.340','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZKXB-55-0','00048873'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','BDCM-ZKXB-55-0','BDCM','TOKO','CMBD','45.00','1.340','1.340','1','1.340','1.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','900K-105 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMSBY-ZKXB-56-0','00048874','750K-115 ','CINCIN EMAS SR05 ','','GR','---','GOLD','CMSBY','TOKO','SBYCM','1296000','2026-11-02','1296000','1.280','45.00','375','260000','2250000.00','1','0.014', 'input','2026-11-02 14:27:58','1.280','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMSBY','CMSBY-ZKXB-56-0','00048874'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMSBY-ZKXB-56-0','CMSBY','TOKO','SBYCM','45.00','1.280','1.280','1','1.280','1.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMSBY','750K-115 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMSBY-ZKXB-57-0','00048875','900K-95 ','CINCIN EMAS ','','GR','---','GOLD','CMSBY','TOKO','SBYCM','1347000','2026-11-02','1347000','1.330','45.00','375','480000','2250000.00','1','0.014', 'input','2026-11-02 14:28:32','1.330','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMSBY','CMSBY-ZKXB-57-0','00048875'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMSBY-ZKXB-57-0','CMSBY','TOKO','SBYCM','45.00','1.330','1.330','1','1.330','1.330','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMSBY','900K-95 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMJOG-ZKXB-58-0','00048876','750K-95 ','CINCIN EMAS SR02 ','','GR','---','GOLD','CMJOG','TOKO','JOGCM','1559500','2026-11-02','1559500','1.540','45.00','375','260000','2250000.00','1','0.14', 'input','2026-11-02 14:30:41','1.540','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMJOG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMJOG','CMJOG-ZKXB-58-0','00048876'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMJOG-ZKXB-58-0','CMJOG','TOKO','JOGCM','45.00','1.540','1.540','1','1.540','1.540','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMJOG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMJOG','750K-95 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMJOG-ZKXB-59-0','00048877','850K-8 ','CINCIN EMAS ','','GR','---','GOLD','CMJOG','TOKO','JOGCM','1134000','2026-11-02','1134000','1.120','45.00','375','400000','2250000.00','1','0.14', 'input','2026-11-02 14:31:44','1.120','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMJOG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMJOG','CMJOG-ZKXB-59-0','00048877'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-02','CMJOG-ZKXB-59-0','CMJOG','TOKO','JOGCM','45.00','1.120','1.120','1','1.120','1.120','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMJOG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMJOG','850K-8 '); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0014','1','ABRE-ZKXB-20-0','1','2.580','2.580','TOKO','SEM-BALIK','TOKO','ABRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZKXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','ABRE.BALIK','ABRE','ABRE-ZKXB-20-0','83.00','1','2.580','2.580','1','2.580','2.580'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.580',berat_out_asli=berat_out_asli+'2.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='ABRE-ZKXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0014','2026-11-02','2026-11-02','14:53','2.58','input','2026-11-02 14:53:55'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0015','1','GBRE-ZKXB-4-0','1','12.610','12.610','TOKO','SEM-BALIK','TOKO','GBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GBRE.BALIK' WHERE kode_barang='GBRE-ZKXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'12.610',berat_in_asli=berat_in_asli+'12.610',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'12.610',berat_akhir_asli=berat_akhir_asli+'12.610' WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'12.610',berat_out_asli=berat_out_asli+'12.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0015','2','GBRE-ZKXB-6-0','1','5.160','5.160','TOKO','SEM-BALIK','TOKO','GBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GBRE.BALIK' WHERE kode_barang='GBRE-ZKXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'5.160',berat_in_asli=berat_in_asli+'5.160',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'5.160',berat_akhir_asli=berat_akhir_asli+'5.160' WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.160',berat_out_asli=berat_out_asli+'5.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0015','3','GBRE-ZKXB-13-0','1','5.750','5.750','TOKO','SEM-BALIK','TOKO','GBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GBRE.BALIK' WHERE kode_barang='GBRE-ZKXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','GBRE.BALIK','GBRE','GBRE-ZKXB-13-0','75.00','1','5.750','5.750','1','5.750','5.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.750',berat_out_asli=berat_out_asli+'5.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='GBRE-ZKXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0015','2026-11-02','2026-11-02','14:54','23.52','input','2026-11-02 14:54:21'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0016','1','LBRE-ZKXB-18-0','1','0.630','0.630','TOKO','SEM-BALIK','TOKO','LBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-ZKXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','LBRE.BALIK','LBRE','LBRE-ZKXB-18-0','83.00','1','0.630','0.630','1','0.630','0.630'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.630',berat_out_asli=berat_out_asli+'0.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='LBRE-ZKXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0016','2026-11-02','2026-11-02','14:54','0.63','input','2026-11-02 14:54:46'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','1','CBRE-ZKXB-19-0','1','2.150','2.150','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-19-0','75.00','1','2.150','2.150','1','2.150','2.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.150',berat_out_asli=berat_out_asli+'2.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','2','CBRE-ZKXB-17-0','1','1.960','1.960','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-17-0','75.00','1','1.960','1.960','1','1.960','1.960'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','3','CBRE-ZKXB-11-0','1','1.060','1.060','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.060',berat_in_asli=berat_in_asli+'1.060',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060' WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.060',berat_out_asli=berat_out_asli+'1.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','4','CBRE-ZKXB-3-0','1','4.460','4.460','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-3-0','75.00','1','4.460','4.460','1','4.460','4.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.460',berat_out_asli=berat_out_asli+'4.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','5','CBRE-ZKXB-14-0','1','1.700','1.700','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.700',berat_in_asli=berat_in_asli+'1.700',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.700',berat_akhir_asli=berat_akhir_asli+'1.700' WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','6','CBRE-ZKXB-9-0','1','2.400','2.400','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.400',berat_in_asli=berat_in_asli+'2.400',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.400',berat_akhir_asli=berat_akhir_asli+'2.400' WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','7','CBRE-ZKXB-15-0','1','1.200','1.200','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-15-0','75.00','1','1.200','1.200','1','1.200','1.200'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','8','CBRE-ZKXB-2-0','1','7.330','7.330','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-2-0','75.00','1','7.330','7.330','1','7.330','7.330'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.330',berat_out_asli=berat_out_asli+'7.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','9','CBRE-ZKXB-5-0','1','3.280','3.280','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-5-0','75.00','1','3.280','3.280','1','3.280','3.280'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.280',berat_out_asli=berat_out_asli+'3.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','10','CBRE-ZKXB-10-0','1','1.520','1.520','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-10-0','83.00','1','1.520','1.520','1','1.520','1.520'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0017','11','CBRE-ZKXB-16-0','1','2.110','2.110','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZKXB-16-0','75.00','1','2.110','2.110','1','2.110','2.110'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.110',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='CBRE-ZKXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0017','2026-11-02','2026-11-02','14:56','29.17','input','2026-11-02 14:57:06'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0018','1','TFC-ZKXB-8-0','1','9.480','9.480','TOKO','SEM-BALIK','TOKO','TFC.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZKXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','TFC.BALIK','TFC','TFC-ZKXB-8-0','75.00','1','9.480','9.480','1','9.480','9.480'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.480',berat_out_asli=berat_out_asli+'9.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFC-ZKXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0018','2','TFC-ZKXB-12-0','1','4.000','4.000','TOKO','SEM-BALIK','TOKO','TFC.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZKXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','TFC.BALIK','TFC','TFC-ZKXB-12-0','75.00','1','4.000','4.000','1','4.000','4.000'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.000',berat_out_asli=berat_out_asli+'4.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFC-ZKXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0018','3','TFC-ZKXB-7-0','1','2.410','2.410','TOKO','SEM-BALIK','TOKO','TFC.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZKXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','TFC.BALIK','TFC','TFC-ZKXB-7-0','83.00','1','2.410','2.410','1','2.410','2.410'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFC-ZKXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0018','2026-11-02','2026-11-02','15:00','15.89','input','2026-11-02 15:00:40'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0019','1','TFCMP-ZKXB-22-0','1','0.900','0.900','TOKO','SEM-EMAS','TOKO','CMPTF'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMPTF' WHERE kode_barang='TFCMP-ZKXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','CMPTF','TFCMP','TFCMP-ZKXB-22-0','76.00','1','0.900','0.900','1','0.900','0.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.900',berat_out_asli=berat_out_asli+'0.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFCMP-ZKXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0019','2026-11-02','2026-11-02','15:00','0.9','input','2026-11-02 15:01:04'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261102-0020','1','TFGRP-ZKXB-21-0','1','2.880','2.880','TOKO','SEM-EMAS','TOKO','GLRTF'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GLRTF' WHERE kode_barang='TFGRP-ZKXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-02','TOKO','GLRTF','TFGRP','TFGRP-ZKXB-21-0','76.00','1','2.880','2.880','1','2.880','2.880'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.880',berat_out_asli=berat_out_asli+'2.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='TFGRP-ZKXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261102-0020','2026-11-02','2026-11-02','15:01','2.88','input','2026-11-02 15:01:28'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','15:06:09'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','1','PSPLT-ZKXB-23-0','1','2.500','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PSPLT-ZKXB-23-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','2','PSPLT-ZKXB-24-0','1','3.160','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-24-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-24-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='PSPLT-ZKXB-24-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','3','PSPLT-ZKXB-25-0','1','2.740','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-25-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.740',berat_out_asli='2.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.740',berat_akhir_asli =berat_akhir_asli-'2.740' WHERE kode_barang='PSPLT-ZKXB-25-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','4','PSPLT-ZKXB-26-0','1','3.120','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-26-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.120',berat_out_asli='3.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.120',berat_akhir_asli =berat_akhir_asli-'3.120' WHERE kode_barang='PSPLT-ZKXB-26-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','5','PSPLT-ZKXB-27-0','1','3.230','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.230',berat_out_asli='3.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.230',berat_akhir_asli =berat_akhir_asli-'3.230' WHERE kode_barang='PSPLT-ZKXB-27-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','6','PSPLT-ZKXB-28-0','1','3.250','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.250',berat_out_asli='3.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.250',berat_akhir_asli =berat_akhir_asli-'3.250' WHERE kode_barang='PSPLT-ZKXB-28-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','7','PSPLT-ZKXB-29-0','1','2.320','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-29-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.320',berat_out_asli='2.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.320',berat_akhir_asli =berat_akhir_asli-'2.320' WHERE kode_barang='PSPLT-ZKXB-29-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','8','PSPLT-ZKXB-30-0','1','2.940','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-30-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.940',berat_out_asli='2.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.940',berat_akhir_asli =berat_akhir_asli-'2.940' WHERE kode_barang='PSPLT-ZKXB-30-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','9','PSPLT-ZKXB-31-0','1','3.340','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-31-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-31-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-31-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.340',berat_out_asli='3.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.340',berat_akhir_asli =berat_akhir_asli-'3.340' WHERE kode_barang='PSPLT-ZKXB-31-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','10','PSPLT-ZKXB-32-0','1','2.910','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-32-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-32-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.910',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.910',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='PSPLT-ZKXB-32-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','11','PSPRT-ZKXB-33-0','1','2.070','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-33-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-33-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXB-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.070' WHERE kode_barang='PSPRT-ZKXB-33-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','12','PSPRT-ZKXB-34-0','1','2.800','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-34-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-34-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXB-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='PSPRT-ZKXB-34-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261102-0002','2026-11-02','2026-11-02','15:15','2.800','input','2026-11-02 15:15:01','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','1','PSPRT-ZKXB-35-0','1','3.180','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-35-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-35-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXB-35-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPRT-ZKXB-35-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','2','PSGT-ZKXB-36-0','1','2.050','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXB-36-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKXB-36-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKXB-36-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='PSGT-ZKXB-36-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','3','PSPRT-ZKXB-37-0','1','1.590','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-37-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-37-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXB-37-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.590',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.590',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='PSPRT-ZKXB-37-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','4','PSPLT-ZKXB-38-0','1','1.860','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-38-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-38-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-38-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='PSPLT-ZKXB-38-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','5','PSPLT-ZKXB-39-0','1','2.390','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-39-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-39-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-39-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-39-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-39-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='PSPLT-ZKXB-39-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','6','PSPLT-ZKXB-40-0','1','2.760','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-40-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-40-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-40-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-40-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-40-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.760',berat_out_asli='2.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.760',berat_akhir_asli =berat_akhir_asli-'2.760' WHERE kode_barang='PSPLT-ZKXB-40-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','7','PSPLT-ZKXB-41-0','1','3.030','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-41-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-41-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXB-41-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.030',berat_out_asli='3.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.030',berat_akhir_asli =berat_akhir_asli-'3.030' WHERE kode_barang='PSPLT-ZKXB-41-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261102-0003','2026-11-02','2026-11-02','15:15','3.030','input','2026-11-02 15:15:17','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-02 ','15:19:16');