INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','08:08:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-03';
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-06-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-03' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-06-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','08:10:56');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0001','1','CBRE-ZFXC-6-0','1','2.450','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFXC-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFXC-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFXC-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFXC-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFXC-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.450',berat_out_asli='2.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.450',berat_akhir_asli =berat_akhir_asli-'2.450' WHERE kode_barang='CBRE-ZFXC-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0001','2','CBRE-ZFXC-7-0','1','2.370','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFXC-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFXC-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFXC-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFXC-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFXC-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.370' WHERE kode_barang='CBRE-ZFXC-7-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-260604-0001','2026-06-04','2026-06-04','08:21','2.370','input','2026-06-04 08:21:12','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0002','1','ABRE-ZFXC-4-0','1','2.180','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZFXC-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZFXC-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZFXC-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZFXC-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZFXC-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='ABRE-ZFXC-4-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-260604-0002','2026-06-04','2026-06-04','08:21','2.180','input','2026-06-04 08:21:28','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0003','1','CBRE-ZFXC-5-0','1','1.290','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFXC-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFXC-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFXC-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFXC-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFXC-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.290',berat_out_asli='1.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.290',berat_akhir_asli =berat_akhir_asli-'1.290' WHERE kode_barang='CBRE-ZFXC-5-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-260604-0003','2026-06-04','2026-06-04','08:21','1.290','input','2026-06-04 08:21:39','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0004','1','LMK-ZFXC-3-0','1','1.610','TOKO','LMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LMK-ZFXC-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMK-ZFXC-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMK-ZFXC-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMK-ZFXC-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMK-ZFXC-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='LMK-ZFXC-3-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-260604-0004','2026-06-04','2026-06-04','08:21','1.610','input','2026-06-04 08:21:53','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0005','1','TFC-ZFXC-8-0','1','2.420','TOKO','TFC');
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFC-ZFXC-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFC-ZFXC-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFC';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFC';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFC-ZFXC-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.420',berat_out_asli='2.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.420',berat_akhir_asli =berat_akhir_asli-'2.420' WHERE kode_barang='TFC-ZFXC-8-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-260604-0005','2026-06-04','2026-06-04','08:22','2.420','input','2026-06-04 08:22:07','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','08:29:42');
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-02200';
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-ZFXD-1-0','00043943','DP-02200MM ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','332000','2026-06-04','332000','3.320','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 10:08:11','3.320','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02200MM','1','RS 13 RS 14','','DP-02200');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-1-0','00043943');
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-06-04','PSPRT-ZFXD-1-0','PSPRT','TOKO','MMPSN','100.00','3.320','3.320','1','3.320','3.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02200MM ');
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-02170';
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-ZFXD-2-0','00043944','DP-02170BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','3462000','2026-06-04','3462000','3.140','45.00','375','550000','2450000.00','1','0.14', 'input','2026-06-04 10:10:26','3.140','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02170BIP','1','RS 15','','DP-02170');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZFXD-2-0','00043944');
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-06-04','PSGT-ZFXD-2-0','PSGT','TOKO','PSNB','45.00','3.140','3.140','1','3.140','3.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02170BIP ');
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-02204';
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-ZFXD-3-0','00043945','DP-02204BIP ','CINCIN PERAK SR-04 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','305000','2026-06-04','305000','3.050','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 10:12:22','3.050','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02204BIP','1','RS 10 5 RS 16','','DP-02204');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-3-0','00043945');
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-06-04','PSPRT-ZFXD-3-0','PSPRT','TOKO','PSNB','100.00','3.050','3.050','1','3.050','3.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02204BIP ');
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-02207';
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-ZFXD-4-0','00043946','DP-02207BIP ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','329000','2026-06-04','329000','3.290','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 10:14:18','3.290','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02207BIP','1','RS 10 5 RS 16','','DP-02207');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-4-0','00043946');
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-06-04','PSPRT-ZFXD-4-0','PSPRT','TOKO','PSNB','100.00','3.290','3.290','1','3.290','3.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02207BIP ');
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-02211';
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-ZFXD-5-0','00043947','DP-02211BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','443000','2026-06-04','443000','2.170','17.00','10','340000','1200000.00','1','0.14', 'input','2026-06-04 10:16:03','2.170','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02211BIP','1','RS 10 5','','DP-02211');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-5-0','00043947');
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-06-04','PSPLT-ZFXD-5-0','PSPLT','TOKO','PSNB','17.00','2.170','2.170','1','2.170','2.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02211BIP ');
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-02225';
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-ZFXD-6-0','00043948','DP-02225BIP ','CINCIN PERAK SR-04 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','320000','2026-06-04','320000','3.200','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 10:17:47','3.200','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02225BIP','1','RS 10 RS 20','','DP-02225');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-6-0','00043948');
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-06-04','PSPRT-ZFXD-6-0','PSPRT','TOKO','PSNB','100.00','3.200','3.200','1','3.200','3.200','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02225BIP ');
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-02228';
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-ZFXD-7-0','00043949','DP-02228BIP ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','309000','2026-06-04','309000','3.090','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 10:19:22','3.090','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02228BIP','1','RS 8 RS 16','','DP-02228');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-7-0','00043949');
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-06-04','PSPRT-ZFXD-7-0','PSPRT','TOKO','PSNB','100.00','3.090','3.090','1','3.090','3.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02228BIP ');
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-02219';
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-ZFXD-8-0','00043950','DP-02219DU ','CINCIN PERAK YL-10 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','531000','2026-06-04','531000','5.310','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-04 10:20:45','5.310','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02219DU','1','RS 24','','DP-02219');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-8-0','00043950');
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-06-04','PSPRT-ZFXD-8-0','PSPRT','TOKO','DUPSN','100.00','5.310','5.310','1','5.310','5.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02219DU ');
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-02244';
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-ZFXD-9-0','00043951','DP-02244DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1213500','2026-06-04','1213500','3.160','32.00','25','520000','1200000.00','1','0.14', 'input','2026-06-04 10:22:27','3.160','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02244DU','1','RS 16 5','','DP-02244');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-9-0','00043951');
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-06-04','PSPLT-ZFXD-9-0','PSPLT','TOKO','DUPSN','32.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-02244DU ');
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-02237';
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-ZFXD-10-0','00043952','DP-02237DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','412000','2026-06-04','412000','4.120','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 10:24:09','4.120','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02237DU','1','RS 18','','DP-02237');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-10-0','00043952');
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-06-04','PSPRT-ZFXD-10-0','PSPRT','TOKO','DUPSN','100.00','4.120','4.120','1','4.120','4.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02237DU ');
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 ('PBDG-ZFXD-11-0','00043953','750K-95-2639 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','107000','2026-06-04','107000','1.070','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:09:08','1.070','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-11-0','00043953');
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-06-04','PBDG-ZFXD-11-0','PBDG','TOKO','PBDG','100.00','1.070','1.070','1','1.070','1.070','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-95-2639 ');
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 ('PBDG-ZFXD-12-0','00043954','750K-16-2640 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','308000','2026-06-04','308000','3.080','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-04 11:09:56','3.080','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-12-0','00043954');
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-06-04','PBDG-ZFXD-12-0','PBDG','TOKO','PBDG','100.00','3.080','3.080','1','3.080','3.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-16-2640 ');
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 ('PBDG-ZFXD-13-0','00043955','750K-12-2641 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','102000','2026-06-04','102000','1.020','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:10:18','1.020','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-13-0','00043955');
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-06-04','PBDG-ZFXD-13-0','PBDG','TOKO','PBDG','100.00','1.020','1.020','1','1.020','1.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-12-2641 ');
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 ('PBDG-ZFXD-14-0','00043956','750K-125-2642 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','205500','2026-06-04','205500','2.050','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:10:59','2.050','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-14-0','00043956');
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-06-04','PBDG-ZFXD-14-0','PBDG','TOKO','PBDG','100.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-125-2642 ');
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 ('PBDG-ZFXD-15-0','00043957','750K-9-2643 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','165000','2026-06-04','165000','1.650','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:11:38','1.650','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-15-0','00043957');
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-06-04','PBDG-ZFXD-15-0','PBDG','TOKO','PBDG','100.00','1.650','1.650','1','1.650','1.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-9-2643 ');
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 ('PBDG-ZFXD-16-0','00043958','750K-135-2644 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','140000','2026-06-04','140000','1.400','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:12:17','1.400','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-16-0','00043958');
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-06-04','PBDG-ZFXD-16-0','PBDG','TOKO','PBDG','100.00','1.400','1.400','1','1.400','1.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-135-2644 ');
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 ('PBDG-ZFXD-17-0','00043959','750K-105-2645 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','237000','2026-06-04','237000','2.370','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:13:02','2.370','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-17-0','00043959');
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-06-04','PBDG-ZFXD-17-0','PBDG','TOKO','PBDG','100.00','2.370','2.370','1','2.370','2.370','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-105-2645 ');
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 ('PBDG-ZFXD-18-0','00043960','750K-10-2646 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','158000','2026-06-04','158000','1.580','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:13:41','1.580','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-18-0','00043960');
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-06-04','PBDG-ZFXD-18-0','PBDG','TOKO','PBDG','100.00','1.580','1.580','1','1.580','1.580','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-10-2646 ');
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 ('PBDG-ZFXD-19-0','00043961','750K-17-2647 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','241000','2026-06-04','241000','2.410','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-04 11:14:20','2.410','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-19-0','00043961');
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-06-04','PBDG-ZFXD-19-0','PBDG','TOKO','PBDG','100.00','2.410','2.410','1','2.410','2.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-17-2647 ');
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 ('PBDG-ZFXD-20-0','00043962','750K-17-2648 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','285000','2026-06-04','285000','2.850','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-04 11:14:58','2.850','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-20-0','00043962');
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-06-04','PBDG-ZFXD-20-0','PBDG','TOKO','PBDG','100.00','2.850','2.850','1','2.850','2.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-17-2648 ');
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 ('PBDG-ZFXD-21-0','00043963','750K-165-2649 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','147000','2026-06-04','147000','1.470','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:15:21','1.470','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-21-0','00043963');
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-06-04','PBDG-ZFXD-21-0','PBDG','TOKO','PBDG','100.00','1.470','1.470','1','1.470','1.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-165-2649 ');
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 ('PBDG-ZFXD-22-0','00043964','750K-145-2650 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','172000','2026-06-04','172000','1.720','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:15:46','1.720','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-22-0','00043964');
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-06-04','PBDG-ZFXD-22-0','PBDG','TOKO','PBDG','100.00','1.720','1.720','1','1.720','1.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-145-2650 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','11:16:06');
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 ('PBDG-ZFXD-23-0','00043965','800K-12-2651 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','272000','2026-06-04','272000','2.720','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:16:28','2.720','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-23-0','00043965');
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-06-04','PBDG-ZFXD-23-0','PBDG','TOKO','PBDG','100.00','2.720','2.720','1','2.720','2.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-12-2651 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','11:16:59');
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 ('PBDG-ZFXD-24-0','00043966','800K-13-2652 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','279000','2026-06-04','279000','2.790','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-04 11:17:05','2.790','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-24-0','00043966');
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-06-04','PBDG-ZFXD-24-0','PBDG','TOKO','PBDG','100.00','2.790','2.790','1','2.790','2.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-13-2652 ');
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 ('PBDG-ZFXD-25-0','00043967','850K-105-2653 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','205500','2026-06-04','205500','2.050','100.00','925','290000','100000.00','1','0.14', 'input','2026-06-04 11:17:57','2.050','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-25-0','00043967');
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-06-04','PBDG-ZFXD-25-0','PBDG','TOKO','PBDG','100.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-105-2653 ');
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 ('PBDG-ZFXD-26-0','00043968','850K-11-2654 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','154000','2026-06-04','154000','1.540','100.00','925','340000','100000.00','1','0.14', 'input','2026-06-04 11:18:37','1.540','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-26-0','00043968');
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-06-04','PBDG-ZFXD-26-0','PBDG','TOKO','PBDG','100.00','1.540','1.540','1','1.540','1.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-11-2654 ');
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 ('PBDG-ZFXD-27-0','00043969','850K-11-2655 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','142000','2026-06-04','142000','1.420','100.00','925','400000','100000.00','1','0.14', 'input','2026-06-04 11:19:15','1.420','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-27-0','00043969');
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-06-04','PBDG-ZFXD-27-0','PBDG','TOKO','PBDG','100.00','1.420','1.420','1','1.420','1.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-11-2655 ');
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 ('PBDG-ZFXD-28-0','00043970','850K-95-2656 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','303000','2026-06-04','303000','3.030','100.00','925','280000','100000.00','1','0.14', 'input','2026-06-04 11:19:57','3.030','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-28-0','00043970');
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-06-04','PBDG-ZFXD-28-0','PBDG','TOKO','PBDG','100.00','3.030','3.030','1','3.030','3.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-95-2656 ');
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 ('PBDG-ZFXD-29-0','00043971','850K-11-2657 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','113500','2026-06-04','113500','1.130','100.00','925','350000','100000.00','1','0.14', 'input','2026-06-04 11:20:38','1.130','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-29-0','00043971');
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-06-04','PBDG-ZFXD-29-0','PBDG','TOKO','PBDG','100.00','1.130','1.130','1','1.130','1.130','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-11-2657 ');
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 ('PBDG-ZFXD-30-0','00043972','850K-115-2658 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','144000','2026-06-04','144000','1.440','100.00','925','380000','100000.00','1','0.14', 'input','2026-06-04 11:21:17','1.440','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-30-0','00043972');
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-06-04','PBDG-ZFXD-30-0','PBDG','TOKO','PBDG','100.00','1.440','1.440','1','1.440','1.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-115-2658 ');
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 ('PBDG-ZFXD-31-0','00043973','850K-11-2659 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','157000','2026-06-04','157000','1.570','100.00','925','340000','100000.00','1','0.14', 'input','2026-06-04 11:21:40','1.570','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-31-0','00043973');
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-06-04','PBDG-ZFXD-31-0','PBDG','TOKO','PBDG','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-11-2659 ');
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 ('PBDG-ZFXD-32-0','00043974','850K-16-2660 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','287000','2026-06-04','287000','2.870','100.00','925','290000','100000.00','1','0.14', 'input','2026-06-04 11:22:06','2.870','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-32-0','00043974');
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-06-04','PBDG-ZFXD-32-0','PBDG','TOKO','PBDG','100.00','2.870','2.870','1','2.870','2.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-16-2660 ');
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 ('PBDG-ZFXD-33-0','00043975','900K-115-2661 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','198000','2026-06-04','198000','1.980','100.00','925','370000','100000.00','1','0.14', 'input','2026-06-04 11:22:50','1.980','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-33-0','00043975');
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-06-04','PBDG-ZFXD-33-0','PBDG','TOKO','PBDG','100.00','1.980','1.980','1','1.980','1.980','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-115-2661 ');
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 ('PBDG-ZFXD-34-0','00043976','900K-10-2662 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','147000','2026-06-04','147000','1.470','100.00','925','390000','100000.00','1','0.14', 'input','2026-06-04 11:23:32','1.470','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-34-0','00043976');
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-06-04','PBDG-ZFXD-34-0','PBDG','TOKO','PBDG','100.00','1.470','1.470','1','1.470','1.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-10-2662 ');
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 ('PBDG-ZFXD-35-0','00043977','900K-135-2663 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','168000','2026-06-04','168000','1.680','100.00','925','390000','100000.00','1','0.14', 'input','2026-06-04 11:24:08','1.680','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-35-0','00043977');
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-06-04','PBDG-ZFXD-35-0','PBDG','TOKO','PBDG','100.00','1.680','1.680','1','1.680','1.680','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-135-2663 ');
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 ('PBDG-ZFXD-36-0','00043978','950K-11-2664 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','169000','2026-06-04','169000','1.690','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-04 11:24:53','1.690','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-36-0','00043978');
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-06-04','PBDG-ZFXD-36-0','PBDG','TOKO','PBDG','100.00','1.690','1.690','1','1.690','1.690','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','950K-11-2664 ');
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 ('PBDG-ZFXD-37-0','00043979','950K-125-2665 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','433000','2026-06-04','433000','4.330','100.00','925','340000','100000.00','1','0.14', 'input','2026-06-04 11:25:39','4.330','0','','17950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFXD-37-0','00043979');
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-06-04','PBDG-ZFXD-37-0','PBDG','TOKO','PBDG','100.00','4.330','4.330','1','4.330','4.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','950K-125-2665 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-04 ','13:10:35');
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-02243';
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-ZFXD-38-0','00043980','DP-02243DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','643000','2026-06-04','643000','6.430','100.00','925','450000','100000.00','1','0.14', 'input','2026-06-04 14:10:11','6.430','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02243DU','1','RS 21 5','','DP-02243');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-38-0','00043980');
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-06-04','PSPRT-ZFXD-38-0','PSPRT','TOKO','DUPSN','100.00','6.430','6.430','1','6.430','6.430','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02243DU ');
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 ('CBRE-ZFXD-39-0','00043981','CBRE-07049 ','CINCIN CBRE-07049 ','','GR','---','DM','CBRE','TOKO','CBRE','6121000','2026-06-04','6121000','3.010','83.00','75','0','2450000.00','1','0.04', 'input','2026-06-04 14:55:25','3.010','837000','179.60','17950.00','','TOKO','FREETAG','','10','','','IDR 42 500 000','1','RS 14 0626','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZFXD-39-0','00043981');
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-06-04','CBRE-ZFXD-39-0','CBRE','TOKO','CBRE','83.00','3.010','3.010','1','3.010','3.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07049 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFXD-39-0','00043981','SP','1','1.870 ','50','93.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFXD-39-0','00043981','RD','17','0.205 ','420','86.1');
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-02266';
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-ZFXD-40-0','00043982','DP-02266DU ','CINCIN PALADIUM YL-01 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1317500','2026-06-04','1317500','3.430','32.00','25','250000','1200000.00','1','0.14', 'input','2026-06-04 15:56:08','3.430','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02266DU','1','RS 20','','DP-02266');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-40-0','00043982');
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-06-04','PSPLT-ZFXD-40-0','PSPLT','TOKO','DUPSN','32.00','3.430','3.430','1','3.430','3.430','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02266DU ');
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-02205';
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-ZFXD-41-0','00043983','DP-02205DU ','CINCIN PALADIUM YL-10 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','824500','2026-06-04','824500','4.040','17.00','10','250000','1200000.00','1','0.14', 'input','2026-06-04 16:15:16','4.040','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02205DU','1','RS 18','','DP-02205');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-41-0','00043983');
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-06-04','PSPLT-ZFXD-41-0','PSPLT','TOKO','DUPSN','17.00','4.040','4.040','1','4.040','4.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02205DU ');
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-02265';
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-ZFXD-42-0','00043984','DP-02265DU ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','181000','2026-06-04','181000','1.810','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-04 16:16:46','1.810','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02265DU','1','RS 15','','DP-02265');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-42-0','00043984');
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-06-04','PSPRT-ZFXD-42-0','PSPRT','TOKO','DUPSN','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02265DU ');
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-02100';
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-ZFXD-43-0','00043985','DP-02100BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','651000','2026-06-04','651000','3.190','17.00','10','900000','1200000.00','1','0.14', 'input','2026-06-04 16:51:31','3.190','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02100BIP','1','RS 12 5','','DP-02100');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-43-0','00043985');
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-06-04','PSPLT-ZFXD-43-0','PSPLT','TOKO','PSNB','17.00','3.190','3.190','1','3.190','3.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02100BIP ');
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-02210';
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-ZFXD-44-0','00043986','DP-02210BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','484000','2026-06-04','484000','2.370','17.00','10','250000','1200000.00','1','0.14', 'input','2026-06-04 16:53:06','2.370','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02210BIP','1','RS 19','','DP-02210');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-44-0','00043986');
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-06-04','PSPLT-ZFXD-44-0','PSPLT','TOKO','PSNB','17.00','2.370','2.370','1','2.370','2.370','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02210BIP ');
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-02214';
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-ZFXD-45-0','00043987','DP-02214BIP ','CINCIN PALADIUM YL-10 ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','769500','2026-06-04','769500','3.770','17.00','10','250000','1200000.00','1','0.14', 'input','2026-06-04 16:54:33','3.770','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02214BIP','1','RS 17 5','','DP-02214');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-45-0','00043987');
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-06-04','PSPLT-ZFXD-45-0','PSPLT','TOKO','PSNB','17.00','3.770','3.770','1','3.770','3.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02214BIP ');
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-02152';
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-ZFXD-46-0','00043988','DP-02152DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','204000','2026-06-04','204000','2.040','100.00','925','350000','100000.00','1','0.14', 'input','2026-06-04 16:56:08','2.040','0','','17950.00','','TOKO','FREETAG','','2','','','PSN02152DU','1','RS 14 5','','DP-02152');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFXD-46-0','00043988');
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-06-04','PSPRT-ZFXD-46-0','PSPRT','TOKO','DUPSN','100.00','2.040','2.040','1','2.040','2.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02152DU ');
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-02188';
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-ZFXD-47-0','00043989','DP-02188DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','328500','2026-06-04','328500','1.610','17.00','10','330000','1200000.00','1','0.14', 'input','2026-06-04 16:57:40','1.610','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02188DU','1','RS 15 5','','DP-02188');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-47-0','00043989');
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-06-04','PSPLT-ZFXD-47-0','PSPLT','TOKO','DUPSN','17.00','1.610','1.610','1','1.610','1.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02188DU ');
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-02251';
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-ZFXD-48-0','00043990','DP-02251SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1004000','2026-06-04','1004000','4.920','17.00','10','260000','1200000.00','1','0.014', 'input','2026-06-04 16:59:25','4.920','0','','17950.00','','TOKO','FREETAG','','10','','','PSN02251SBY','1','RS 28 5','','DP-02251');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFXD-48-0','00043990');
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-06-04','PSPLT-ZFXD-48-0','PSPLT','TOKO','SBYPSN','17.00','4.920','4.920','1','4.920','4.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02251SBY ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','1','PSPRT-ZFXC-1-0','1','2.020','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXC-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXC-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXC-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXC-1-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-ZFXC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='PSPRT-ZFXC-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','2','PSPRT-ZFXC-2-0','1','5.090','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXC-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXC-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXC-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXC-2-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-ZFXC-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.090',berat_out_asli='5.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.090',berat_akhir_asli =berat_akhir_asli-'5.090' WHERE kode_barang='PSPRT-ZFXC-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','3','PSGT-ZFXD-2-0','1','3.140','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXD-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZFXD-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXD-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZFXD-2-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='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='PSGT-ZFXD-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.140',berat_out_asli='3.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.140',berat_akhir_asli =berat_akhir_asli-'3.140' WHERE kode_barang='PSGT-ZFXD-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','4','PSPRT-ZFXD-3-0','1','3.050','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-3-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-ZFXD-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.050',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.050',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='PSPRT-ZFXD-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','5','PSPRT-ZFXD-4-0','1','3.290','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-4-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-ZFXD-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.290',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.290',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='PSPRT-ZFXD-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','6','PSPLT-ZFXD-5-0','1','2.170','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-5-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-ZFXD-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PSPLT-ZFXD-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','7','PSPRT-ZFXD-6-0','1','3.200','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-6-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-ZFXD-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.200',berat_out_asli='3.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.200',berat_akhir_asli =berat_akhir_asli-'3.200' WHERE kode_barang='PSPRT-ZFXD-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','8','PSPRT-ZFXD-7-0','1','3.090','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-7-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-ZFXD-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.090',berat_out_asli='3.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.090',berat_akhir_asli =berat_akhir_asli-'3.090' WHERE kode_barang='PSPRT-ZFXD-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','9','PSPLT-ZFXD-43-0','1','3.190','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-43-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-43-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-43-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-43-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-ZFXD-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.190',berat_out_asli='3.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.190',berat_akhir_asli =berat_akhir_asli-'3.190' WHERE kode_barang='PSPLT-ZFXD-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','10','PSPLT-ZFXD-44-0','1','2.370','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-44-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-44-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-ZFXD-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.370' WHERE kode_barang='PSPLT-ZFXD-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0006','11','PSPLT-ZFXD-45-0','1','3.770','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-45-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-45-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-ZFXD-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.770',berat_out_asli='3.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.770',berat_akhir_asli =berat_akhir_asli-'3.770' WHERE kode_barang='PSPLT-ZFXD-45-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-260604-0006','2026-06-04','2026-06-04','17:05','3.770','input','2026-06-04 17:05:12','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','1','PBDG-ZFXD-11-0','1','1.070','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.070',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.070',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='PBDG-ZFXD-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','2','PBDG-ZFXD-12-0','1','3.080','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.080',berat_out_asli='3.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.080',berat_akhir_asli =berat_akhir_asli-'3.080' WHERE kode_barang='PBDG-ZFXD-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','3','PBDG-ZFXD-13-0','1','1.020','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.020' WHERE kode_barang='PBDG-ZFXD-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','4','PBDG-ZFXD-14-0','1','2.050','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-14-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='PBDG-ZFXD-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','5','PBDG-ZFXD-15-0','1','1.650','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.650',berat_out_asli='1.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.650',berat_akhir_asli =berat_akhir_asli-'1.650' WHERE kode_barang='PBDG-ZFXD-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','6','PBDG-ZFXD-16-0','1','1.400','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='PBDG-ZFXD-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','7','PBDG-ZFXD-17-0','1','2.370','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.370' WHERE kode_barang='PBDG-ZFXD-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','8','PBDG-ZFXD-18-0','1','1.580','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.580',berat_out_asli='1.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.580',berat_akhir_asli =berat_akhir_asli-'1.580' WHERE kode_barang='PBDG-ZFXD-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','9','PBDG-ZFXD-19-0','1','2.410','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='PBDG-ZFXD-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','10','PBDG-ZFXD-20-0','1','2.850','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.850',berat_out_asli='2.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.850',berat_akhir_asli =berat_akhir_asli-'2.850' WHERE kode_barang='PBDG-ZFXD-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','11','PBDG-ZFXD-21-0','1','1.470','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.470',berat_out_asli='1.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.470',berat_akhir_asli =berat_akhir_asli-'1.470' WHERE kode_barang='PBDG-ZFXD-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','12','PBDG-ZFXD-22-0','1','1.720','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.720',berat_out_asli='1.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.720',berat_akhir_asli =berat_akhir_asli-'1.720' WHERE kode_barang='PBDG-ZFXD-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','13','PBDG-ZFXD-23-0','1','2.720','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.720',berat_out_asli='2.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.720',berat_akhir_asli =berat_akhir_asli-'2.720' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','14','PBDG-ZFXD-24-0','1','2.790','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.790',berat_out_asli='2.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.790',berat_akhir_asli =berat_akhir_asli-'2.790' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','15','PBDG-ZFXD-25-0','1','2.050','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-25-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='PBDG-ZFXD-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-260604-0007','16','PBDG-ZFXD-26-0','1','1.540','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','17','PBDG-ZFXD-27-0','1','1.420','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.420',berat_out_asli='1.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.420',berat_akhir_asli =berat_akhir_asli-'1.420' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','18','PBDG-ZFXD-28-0','1','3.030','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-28-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='PBDG-ZFXD-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-260604-0007','19','PBDG-ZFXD-29-0','1','1.130','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-29-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.130',berat_out_asli='1.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.130',berat_akhir_asli =berat_akhir_asli-'1.130' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','20','PBDG-ZFXD-30-0','1','1.440','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-30-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.440',berat_out_asli='1.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.440',berat_akhir_asli =berat_akhir_asli-'1.440' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','21','PBDG-ZFXD-31-0','1','1.570','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-31-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','22','PBDG-ZFXD-32-0','1','2.870','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-32-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-32-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.870',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.870',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','23','PBDG-ZFXD-33-0','1','1.980','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-33-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-33-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.980' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','24','PBDG-ZFXD-34-0','1','1.470','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.470',berat_out_asli='1.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.470',berat_akhir_asli =berat_akhir_asli-'1.470' WHERE kode_barang='PBDG-ZFXD-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0007','25','PBDG-ZFXD-35-0','1','1.680','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','26','PBDG-ZFXD-36-0','1','1.690','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-36-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.690',berat_out_asli='1.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.690',berat_akhir_asli =berat_akhir_asli-'1.690' WHERE kode_barang='PBDG-ZFXD-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-260604-0007','27','PBDG-ZFXD-37-0','1','4.330','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZFXD-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZFXD-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZFXD-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZFXD-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZFXD-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.330',berat_out_asli='4.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.330',berat_akhir_asli =berat_akhir_asli-'4.330' WHERE kode_barang='PBDG-ZFXD-37-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-260604-0007','2026-06-04','2026-06-04','17:05','4.330','input','2026-06-04 17:05:27','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','1','PSPRT-ZFXD-8-0','1','5.310','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-8-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-ZFXD-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.310',berat_out_asli='5.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.310',berat_akhir_asli =berat_akhir_asli-'5.310' WHERE kode_barang='PSPRT-ZFXD-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','2','PSPLT-ZFXD-9-0','1','3.160','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-9-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-ZFXD-9-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-ZFXD-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','3','PSPRT-ZFXD-10-0','1','4.120','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-10-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-ZFXD-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.120',berat_out_asli='4.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.120',berat_akhir_asli =berat_akhir_asli-'4.120' WHERE kode_barang='PSPRT-ZFXD-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','4','PSPRT-ZFXD-38-0','1','6.430','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-38-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-38-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-ZFXD-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.430',berat_out_asli='6.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.430',berat_akhir_asli =berat_akhir_asli-'6.430' WHERE kode_barang='PSPRT-ZFXD-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-260604-0008','5','PSPLT-ZFXD-40-0','1','3.430','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-40-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-40-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-40-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-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-ZFXD-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.430',berat_out_asli='3.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.430',berat_akhir_asli =berat_akhir_asli-'3.430' WHERE kode_barang='PSPLT-ZFXD-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-260604-0008','6','PSPLT-ZFXD-41-0','1','4.040','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-41-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-41-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-41-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-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-ZFXD-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.040',berat_out_asli='4.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.040',berat_akhir_asli =berat_akhir_asli-'4.040' WHERE kode_barang='PSPLT-ZFXD-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','7','PSPRT-ZFXD-42-0','1','1.810','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-42-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-42-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-ZFXD-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='PSPRT-ZFXD-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','8','PSPRT-ZFXD-46-0','1','2.040','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXD-46-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFXD-46-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXD-46-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFXD-46-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-ZFXD-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.040',berat_out_asli='2.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.040',berat_akhir_asli =berat_akhir_asli-'2.040' WHERE kode_barang='PSPRT-ZFXD-46-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0008','9','PSPLT-ZFXD-47-0','1','1.610','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-47-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-47-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-47-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-47-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-ZFXD-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='PSPLT-ZFXD-47-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-260604-0008','2026-06-04','2026-06-04','17:05','1.610','input','2026-06-04 17:05:43','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260604-0009','1','PSPLT-ZFXD-48-0','1','4.920','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-48-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-48-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFXD-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.920',berat_out_asli='4.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.920',berat_akhir_asli =berat_akhir_asli-'4.920' WHERE kode_barang='PSPLT-ZFXD-48-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-260604-0009','2026-06-04','2026-06-04','17:06','4.920','input','2026-06-04 17:06:00','THIFA');