INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-28 ','08:15:00');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-27';
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-07-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-27' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-07-28';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-28 ','08:15:47');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0001','1','LGM10-ZGBG-8-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-ZGBG-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-ZGBG-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-ZGBG-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-ZGBG-8-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-ZGBG-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-ZGBG-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-260728-0001','2','LGM10-ZGBG-9-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-ZGBG-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-ZGBG-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-ZGBG-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-ZGBG-9-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-ZGBG-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-ZGBG-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-260728-0001','3','LGM10-ZGBG-10-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-ZGBG-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-ZGBG-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-ZGBG-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-ZGBG-10-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-ZGBG-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-ZGBG-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-260728-0001','4','LGM10-ZGBG-11-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-ZGBG-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-ZGBG-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-ZGBG-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-ZGBG-11-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-ZGBG-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-ZGBG-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-260728-0001','5','LGM10-ZGBG-12-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-ZGBG-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-ZGBG-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-ZGBG-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-ZGBG-12-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-ZGBG-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-ZGBG-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-260728-0001','6','LGM5-ZGBG-13-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-ZGBG-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-ZGBG-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-ZGBG-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-ZGBG-13-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-ZGBG-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-ZGBG-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-260728-0001','7','LGM5-ZGBG-14-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-ZGBG-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-ZGBG-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-ZGBG-14-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-ZGBG-14-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-ZGBG-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-ZGBG-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-260728-0001','8','LGM5-ZGBG-15-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-ZGBG-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-ZGBG-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-ZGBG-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-ZGBG-15-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-ZGBG-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-ZGBG-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-260728-0001','9','LGM5-ZGBG-16-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-ZGBG-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-ZGBG-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-ZGBG-16-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-ZGBG-16-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-ZGBG-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-ZGBG-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-260728-0001','10','LGM5-ZGBG-17-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-ZGBG-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-ZGBG-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-ZGBG-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-ZGBG-17-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-ZGBG-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-ZGBG-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-260728-0001','11','LGM3-ZGBG-18-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-18-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','12','LGM3-ZGBG-19-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-19-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','13','LGM3-ZGBG-20-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-20-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-20-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','14','LGM3-ZGBG-21-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-21-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','15','LGM3-ZGBG-22-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-22-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-22-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','16','LGM3-ZGBG-23-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-23-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-23-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','17','LGM3-ZGBG-24-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-24-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-24-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','18','LGM3-ZGBG-25-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-25-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-25-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','19','LGM3-ZGBG-26-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-26-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-26-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','20','LGM3-ZGBG-27-0','1','3.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM3-ZGBG-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM3-ZGBG-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM3-ZGBG-27-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM3-ZGBG-27-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='LGM3' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM3' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM3-ZGBG-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='LGM3-ZGBG-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-260728-0001','21','LGM2-ZGBG-28-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-28-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-28-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','22','LGM2-ZGBG-29-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-29-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-29-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','23','LGM2-ZGBG-30-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-30-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-30-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','24','LGM2-ZGBG-31-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-31-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-31-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','25','LGM2-ZGBG-32-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-32-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-32-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','26','LGM2-ZGBG-33-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-33-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-33-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','27','LGM2-ZGBG-34-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-34-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-34-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','28','LGM2-ZGBG-35-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-35-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-35-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','29','LGM2-ZGBG-36-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-36-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-36-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','30','LGM2-ZGBG-37-0','1','2.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM2-ZGBG-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM2-ZGBG-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM2-ZGBG-37-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM2-ZGBG-37-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='LGM2' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM2' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM2-ZGBG-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='LGM2-ZGBG-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-260728-0001','2026-07-28','2026-07-28','08:25','2.000','input','2026-07-28 08:25:00','ELCO');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-28 ','08:34:01');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03064';
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 ('PSPRE-ZGBH-1-0','00045649','DP-03064 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','352000','2026-07-28','352000','3.520','100.00','925','210000','100000.00','1','0.04', 'input','2026-07-28 09:16:18','3.520','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03064','1','RS 15','','DP-03064');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZGBH-1-0','00045649');
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-07-28','PSPRE-ZGBH-1-0','PSPRE','TOKO','PSN','100.00','3.520','3.520','1','3.520','3.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03064 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03065';
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 ('PSPRE-ZGBH-2-0','00045650','DP-03065 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','141000','2026-07-28','141000','1.410','100.00','925','210000','100000.00','1','0.04', 'input','2026-07-28 09:17:55','1.410','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03065','1','RS 11','','DP-03065');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZGBH-2-0','00045650');
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-07-28','PSPRE-ZGBH-2-0','PSPRE','TOKO','PSN','100.00','1.410','1.410','1','1.410','1.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03065 ');
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-03066';
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 ('PSPRE-ZGBH-3-0','00045651','DP-03066 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','272000','2026-07-28','272000','2.720','100.00','925','200000','100000.00','1','0.04', 'input','2026-07-28 09:19:18','2.720','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03066','1','RS 18','','DP-03066');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZGBH-3-0','00045651');
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-07-28','PSPRE-ZGBH-3-0','PSPRE','TOKO','PSN','100.00','2.720','2.720','1','2.720','2.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03066 ');
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-02881';
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-ZGBH-4-0','00045652','DP-02881MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','5072000','2026-07-28','5072000','2.680','83.00','75','340000','2280000.00','1','0.14', 'input','2026-07-28 09:22:40','2.680','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02881MM','1','RS 16','','DP-02881');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-4-0','00045652');
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-07-28','PSGT-ZGBH-4-0','PSGT','TOKO','MMPSN','83.00','2.680','2.680','1','2.680','2.680','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02881MM ');
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-02781';
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-ZGBH-5-0','00045653','DP-02781MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','5450500','2026-07-28','5450500','2.880','83.00','75','640000','2280000.00','1','0.14', 'input','2026-07-28 09:24:59','2.880','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02781MM','1','RS 15','','DP-02781');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-5-0','00045653');
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-07-28','PSGT-ZGBH-5-0','PSGT','TOKO','MMPSN','83.00','2.880','2.880','1','2.880','2.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02781MM ');
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-02772';
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-ZGBH-6-0','00045654','DP-02772MM ','CINCIN EMAS SR-04 ','','GR','---','PSGT','PSGT','TOKO','MMPSN','3387500','2026-07-28','3387500','1.790','83.00','75','260000','2280000.00','1','0.14', 'input','2026-07-28 09:26:59','1.790','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02772MM','1','RS 17 5','','DP-02772');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-6-0','00045654');
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-07-28','PSGT-ZGBH-6-0','PSGT','TOKO','MMPSN','83.00','1.790','1.790','1','1.790','1.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02772MM ');
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-02825';
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-ZGBH-7-0','00045655','DP-02825MM ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','323000','2026-07-28','323000','3.230','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 09:28:59','3.230','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02825MM','1','RS 13 RS 15','','DP-02825');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-7-0','00045655');
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-07-28','PSPRT-ZGBH-7-0','PSPRT','TOKO','MMPSN','100.00','3.230','3.230','1','3.230','3.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02825MM ');
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-02930';
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-ZGBH-8-0','00045656','DP-02930MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','5564000','2026-07-28','5564000','2.940','83.00','75','320000','2280000.00','1','0.14', 'input','2026-07-28 09:31:03','2.940','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02930MM','1','RS 18','','DP-02930');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-8-0','00045656');
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-07-28','PSGT-ZGBH-8-0','PSGT','TOKO','MMPSN','83.00','2.940','2.940','1','2.940','2.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02930MM ');
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-02790';
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-ZGBH-9-0','00045657','DP-02790MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','3993000','2026-07-28','3993000','2.110','83.00','75','400000','2280000.00','1','0.14', 'input','2026-07-28 09:32:47','2.110','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02790MM','1','RS 10 5','','DP-02790');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-9-0','00045657');
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-07-28','PSGT-ZGBH-9-0','PSGT','TOKO','MMPSN','83.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02790MM ');
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-02882';
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-ZGBH-10-0','00045658','DP-02882MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','4750000','2026-07-28','4750000','2.510','83.00','75','260000','2280000.00','1','0.14', 'input','2026-07-28 09:35:54','2.510','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02882MM','1','RS 16','','DP-02882');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-10-0','00045658');
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-07-28','PSGT-ZGBH-10-0','PSGT','TOKO','MMPSN','83.00','2.510','2.510','1','2.510','2.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02882MM ');
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-02784';
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-ZGBH-11-0','00045659','DP-02784MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','3406500','2026-07-28','3406500','1.800','83.00','75','260000','2280000.00','1','0.14', 'input','2026-07-28 09:37:33','1.800','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02784MM','1','RS 11','','DP-02784');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-11-0','00045659');
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-07-28','PSGT-ZGBH-11-0','PSGT','TOKO','MMPSN','83.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02784MM ');
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-02843';
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-ZGBH-12-0','00045660','DP-02843MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','457000','2026-07-28','457000','4.570','100.00','925','210000','100000.00','1','0.14', 'input','2026-07-28 09:39:13','4.570','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02843MM','1','RS 22','','DP-02843');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-12-0','00045660');
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-07-28','PSPRT-ZGBH-12-0','PSPRT','TOKO','MMPSN','100.00','4.570','4.570','1','4.570','4.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02843MM ');
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-02909';
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-ZGBH-13-0','00045661','DP-02909MM ','CINCIN PERAK SR-01 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','299000','2026-07-28','299000','2.990','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 09:41:29','2.990','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02909MM','1','RS 12 RS 20','','DP-02909');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-13-0','00045661');
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-07-28','PSPRT-ZGBH-13-0','PSPRT','TOKO','MMPSN','100.00','2.990','2.990','1','2.990','2.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02909MM ');
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-02967';
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-ZGBH-14-0','00045662','DP-02967BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','1642000','2026-07-28','1642000','1.600','45.00','375','260000','2280000.00','1','0.14', 'input','2026-07-28 10:21:43','1.600','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02967BIP','1','RS 6','','DP-02967');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-14-0','00045662');
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-07-28','PSGT-ZGBH-14-0','PSGT','TOKO','PSNB','45.00','1.600','1.600','1','1.600','1.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02967BIP ');
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-02856';
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-ZGBH-15-0','00045663','DP-02856BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','533000','2026-07-28','533000','5.330','100.00','925','490000','100000.00','1','0.14', 'input','2026-07-28 10:23:58','5.330','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02856BIP','1','RS 215 RS 18','','DP-02856');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-15-0','00045663');
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-07-28','PSPRT-ZGBH-15-0','PSPRT','TOKO','PSNB','100.00','5.330','5.330','1','5.330','5.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02856BIP ');
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-02811';
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-ZGBH-16-0','00045664','DP-02811BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','1919000','2026-07-28','1919000','1.870','45.00','375','250000','2280000.00','1','0.14', 'input','2026-07-28 10:25:31','1.870','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02811BIP','1','RS 11 5','','DP-02811');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-16-0','00045664');
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-07-28','PSGT-ZGBH-16-0','PSGT','TOKO','PSNB','45.00','1.870','1.870','1','1.870','1.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02811BIP ');
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-02990';
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-ZGBH-17-0','00045665','DP-02990BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','205500','2026-07-28','205500','2.050','100.00','925','200000','100000.00','1','0.14', 'input','2026-07-28 13:11:13','2.050','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02990BIP','1','RS 18 5','','DP-02990');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-17-0','00045665');
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-07-28','PSPRT-ZGBH-17-0','PSPRT','TOKO','PSNB','100.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02990BIP ');
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-03032';
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-ZGBH-18-0','00045666','DP-03032BIP ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','347000','2026-07-28','347000','3.470','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 13:13:11','3.470','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03032BIP','1','RS 19 RS 22','','DP-03032');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-18-0','00045666');
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-07-28','PSPRT-ZGBH-18-0','PSPRT','TOKO','PSNB','100.00','3.470','3.470','1','3.470','3.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03032BIP ');
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-02750';
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-ZGBH-19-0','00045667','DP-02750DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','424500','2026-07-28','424500','2.080','17.00','10','340000','1200000.00','1','0.14', 'input','2026-07-28 13:17:34','2.080','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02750DU','1','RS 14','','DP-02750');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-19-0','00045667');
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-07-28','PSPLT-ZGBH-19-0','PSPLT','TOKO','DUPSN','17.00','2.080','2.080','1','2.080','2.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02750DU ');
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-02958';
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-ZGBH-20-0','00045668','DP-02958DU ','CINCIN PERAK SR-02 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','359000','2026-07-28','359000','3.590','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 13:20:13','3.590','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02958DU','1','RS 13 RS 215','','DP-02958');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-20-0','00045668');
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-07-28','PSPRT-ZGBH-20-0','PSPRT','TOKO','DUPSN','100.00','3.590','3.590','1','3.590','3.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02958DU ');
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-02751';
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-ZGBH-21-0','00045669','DP-02751DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','698000','2026-07-28','698000','3.420','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-28 13:21:51','3.420','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02751DU','1','RS 24','','DP-02751');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-21-0','00045669');
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-07-28','PSPLT-ZGBH-21-0','PSPLT','TOKO','DUPSN','17.00','3.420','3.420','1','3.420','3.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02751DU ');
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-02835';
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-ZGBH-22-0','00045670','DP-02835DU ','CINCIN PERAK CM02 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','364000','2026-07-28','364000','3.640','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 13:23:55','3.640','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02835DU','1','RS 145 RS 18','','DP-02835');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-22-0','00045670');
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-07-28','PSPRT-ZGBH-22-0','PSPRT','TOKO','DUPSN','100.00','3.640','3.640','1','3.640','3.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02835DU ');
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-02898';
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-ZGBH-23-0','00045671','DP-02898DU ','CINCIN PERAK YL-10 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','447000','2026-07-28','447000','4.470','100.00','925','200000','100000.00','1','0.14', 'input','2026-07-28 13:25:45','4.470','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02898DU','1','RS 18','','DP-02898');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-23-0','00045671');
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-07-28','PSPRT-ZGBH-23-0','PSPRT','TOKO','DUPSN','100.00','4.470','4.470','1','4.470','4.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02898DU ');
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-02899';
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-ZGBH-24-0','00045672','DP-02899DU ','CINCIN PERAK YL-10 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','398000','2026-07-28','398000','3.980','100.00','925','200000','100000.00','1','0.14', 'input','2026-07-28 13:27:14','3.980','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02899DU','1','RS 12 5','','DP-02899');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-24-0','00045672');
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-07-28','PSPRT-ZGBH-24-0','PSPRT','TOKO','DUPSN','100.00','3.980','3.980','1','3.980','3.980','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02899DU ');
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-02830';
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-ZGBH-25-0','00045673','DP-02830DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2965500','2026-07-28','2965500','2.890','45.00','375','260000','2280000.00','1','0.14', 'input','2026-07-28 13:28:37','2.890','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02830DU','1','RS 15','','DP-02830');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-25-0','00045673');
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-07-28','PSGT-ZGBH-25-0','PSGT','TOKO','DUPSN','45.00','2.890','2.890','1','2.890','2.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02830DU ');
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-02771';
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-ZGBH-26-0','00045674','DP-02771SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','5961500','2026-07-28','5961500','3.150','83.00','75','400000','2280000.00','1','0.014', 'input','2026-07-28 13:34:03','3.150','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02771SBY','1','RS 10','','DP-02771');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-26-0','00045674');
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-07-28','PSGT-ZGBH-26-0','PSGT','TOKO','SBYPSN','83.00','3.150','3.150','1','3.150','3.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02771SBY ');
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-02745';
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-ZGBH-27-0','00045675','DP-02745SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1051000','2026-07-28','1051000','5.150','17.00','10','260000','1200000.00','1','0.014', 'input','2026-07-28 13:35:32','5.150','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02745SBY','1','RS 19','','DP-02745');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-27-0','00045675');
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-07-28','PSPLT-ZGBH-27-0','PSPLT','TOKO','SBYPSN','17.00','5.150','5.150','1','5.150','5.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02745SBY ');
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-02747';
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-ZGBH-28-0','00045676','DP-02747SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','651000','2026-07-28','651000','3.190','17.00','10','460000','1200000.00','1','0.014', 'input','2026-07-28 13:37:51','3.190','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02747SBY','1','RS 11','','DP-02747');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-28-0','00045676');
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-07-28','PSPLT-ZGBH-28-0','PSPLT','TOKO','SBYPSN','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-02747SBY ');
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-02947';
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-ZGBH-29-0','00045677','DP-02947SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','175000','2026-07-28','175000','1.750','100.00','925','410000','100000.00','1','0.014', 'input','2026-07-28 13:39:40','1.750','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02947SBY','1','RS 15','','DP-02947');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-29-0','00045677');
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-07-28','PSPRT-ZGBH-29-0','PSPRT','TOKO','SBYPSN','100.00','1.750','1.750','1','1.750','1.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02947SBY ');
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-02839';
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-ZGBH-30-0','00045678','DP-02839SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','736500','2026-07-28','736500','3.610','17.00','10','250000','1200000.00','1','0.014', 'input','2026-07-28 13:41:13','3.610','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02839SBY','1','RS 23 5','','DP-02839');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-30-0','00045678');
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-07-28','PSPLT-ZGBH-30-0','PSPLT','TOKO','SBYPSN','17.00','3.610','3.610','1','3.610','3.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02839SBY ');
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-02922';
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-ZGBH-31-0','00045679','DP-02922SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','311000','2026-07-28','311000','3.110','100.00','925','200000','100000.00','1','0.014', 'input','2026-07-28 13:42:50','3.110','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02922SBY','1','RS 21','','DP-02922');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-31-0','00045679');
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-07-28','PSPRT-ZGBH-31-0','PSPRT','TOKO','SBYPSN','100.00','3.110','3.110','1','3.110','3.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02922SBY ');
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-02840';
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-ZGBH-32-0','00045680','DP-02840SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','600000','2026-07-28','600000','2.940','17.00','10','260000','1200000.00','1','0.014', 'input','2026-07-28 13:44:49','2.940','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02840SBY','1','RS 18','','DP-02840');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-32-0','00045680');
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-07-28','PSPLT-ZGBH-32-0','PSPLT','TOKO','SBYPSN','17.00','2.940','2.940','1','2.940','2.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02840SBY ');
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-02908';
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-ZGBH-33-0','00045681','DP-02908SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','218500','2026-07-28','218500','2.180','100.00','925','210000','100000.00','1','0.014', 'input','2026-07-28 13:46:24','2.180','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02908SBY','1','RS 16','','DP-02908');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-33-0','00045681');
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-07-28','PSPRT-ZGBH-33-0','PSPRT','TOKO','SBYPSN','100.00','2.180','2.180','1','2.180','2.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02908SBY ');
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-02864';
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-ZGBH-34-0','00045682','DP-02864SBY ','CINCIN PERAK YL-10 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','457000','2026-07-28','457000','4.570','100.00','925','200000','100000.00','1','0.014', 'input','2026-07-28 13:47:58','4.570','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02864SBY','1','RS 20 5','','DP-02864');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-34-0','00045682');
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-07-28','PSPRT-ZGBH-34-0','PSPRT','TOKO','SBYPSN','100.00','4.570','4.570','1','4.570','4.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02864SBY ');
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-03054';
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-ZGBH-35-0','00045683','DP-03054SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1494000','2026-07-28','1494000','3.890','32.00','25','260000','1200000.00','1','0.014', 'input','2026-07-28 13:49:55','3.890','0','','18100.00','','TOKO','FREETAG','','10','','','PSN03054SBY','1','RS 17','','DP-03054');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-35-0','00045683');
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-07-28','PSPLT-ZGBH-35-0','PSPLT','TOKO','SBYPSN','32.00','3.890','3.890','1','3.890','3.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03054SBY ');
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-02861';
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-ZGBH-36-0','00045684','DP-02861SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','299000','2026-07-28','299000','2.990','100.00','925','210000','100000.00','1','0.014', 'input','2026-07-28 13:54:16','2.990','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02861SBY','1','RS 18','','DP-02861');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-36-0','00045684');
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-07-28','PSPRT-ZGBH-36-0','PSPRT','TOKO','SBYPSN','100.00','2.990','2.990','1','2.990','2.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02861SBY ');
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-02874';
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-ZGBH-37-0','00045685','DP-02874SBY ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','644000','2026-07-28','644000','6.440','100.00','925','520000','100000.00','1','0.014', 'input','2026-07-28 13:56:28','6.440','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02874SBY','1','RS 15 RS 18','','DP-02874');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-37-0','00045685');
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-07-28','PSPRT-ZGBH-37-0','PSPRT','TOKO','SBYPSN','100.00','6.440','6.440','1','6.440','6.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02874SBY ');
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-02890';
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-ZGBH-38-0','00045686','DP-02890SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','333000','2026-07-28','333000','3.330','100.00','925','210000','100000.00','1','0.014', 'input','2026-07-28 13:58:21','3.330','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02890SBY','1','RS 16 5','','DP-02890');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-38-0','00045686');
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-07-28','PSPRT-ZGBH-38-0','PSPRT','TOKO','SBYPSN','100.00','3.330','3.330','1','3.330','3.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02890SBY ');
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-02928';
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-ZGBH-39-0','00045687','DP-02928SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','411500','2026-07-28','411500','4.110','100.00','925','210000','100000.00','1','0.014', 'input','2026-07-28 13:59:56','4.110','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02928SBY','1','RS 26','','DP-02928');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-39-0','00045687');
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-07-28','PSPRT-ZGBH-39-0','PSPRT','TOKO','SBYPSN','100.00','4.110','4.110','1','4.110','4.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02928SBY ');
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-02913';
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-ZGBH-40-0','00045688','DP-02913SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','316000','2026-07-28','316000','3.160','100.00','925','200000','100000.00','1','0.014', 'input','2026-07-28 14:01:18','3.160','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02913SBY','1','RS 17','','DP-02913');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-40-0','00045688');
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-07-28','PSPRT-ZGBH-40-0','PSPRT','TOKO','SBYPSN','100.00','3.160','3.160','1','3.160','3.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02913SBY ');
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-02805';
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-ZGBH-41-0','00045689','DP-02805SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','3898500','2026-07-28','3898500','2.060','83.00','75','530000','2280000.00','1','0.014', 'input','2026-07-28 14:03:15','2.060','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02805SBY','1','RS 13 5','','DP-02805');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-41-0','00045689');
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-07-28','PSGT-ZGBH-41-0','PSGT','TOKO','SBYPSN','83.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02805SBY ');
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-02906';
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-ZGBH-42-0','00045690','DP-02906SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','239000','2026-07-28','239000','2.390','100.00','925','210000','100000.00','1','0.014', 'input','2026-07-28 14:04:42','2.390','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02906SBY','1','RS 17','','DP-02906');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-42-0','00045690');
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-07-28','PSPRT-ZGBH-42-0','PSPRT','TOKO','SBYPSN','100.00','2.390','2.390','1','2.390','2.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02906SBY ');
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-02895';
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-ZGBH-43-0','00045691','DP-02895SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','838500','2026-07-28','838500','4.110','17.00','10','260000','1200000.00','1','0.014', 'input','2026-07-28 14:06:15','4.110','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02895SBY','1','RS 20','','DP-02895');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-43-0','00045691');
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-07-28','PSPLT-ZGBH-43-0','PSPLT','TOKO','SBYPSN','17.00','4.110','4.110','1','4.110','4.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02895SBY ');
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-02837';
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-ZGBH-44-0','00045692','DP-02837SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','2755500','2026-07-28','2755500','2.120','57.00','50','320000','2280000.00','1','0.014', 'input','2026-07-28 14:07:43','2.120','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02837SBY','1','RS 12','','DP-02837');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-44-0','00045692');
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-07-28','PSGT-ZGBH-44-0','PSGT','TOKO','SBYPSN','57.00','2.120','2.120','1','2.120','2.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02837SBY ');
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-02929';
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-ZGBH-45-0','00045693','DP-02929SBY ','CINCIN EMAS SR-04 ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','2011000','2026-07-28','2011000','1.960','45.00','375','260000','2280000.00','1','0.014', 'input','2026-07-28 14:09:18','1.960','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02929SBY','1','RS 11 5','','DP-02929');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-45-0','00045693');
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-07-28','PSGT-ZGBH-45-0','PSGT','TOKO','SBYPSN','45.00','1.960','1.960','1','1.960','1.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02929SBY ');
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-02850';
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-ZGBH-46-0','00045694','DP-02850SBY ','CINCIN PERAK SR-01 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','312000','2026-07-28','312000','3.120','100.00','925','410000','100000.00','1','0.014', 'input','2026-07-28 14:11:25','3.120','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02850SBY','1','RS 12 RS 22','','DP-02850');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-46-0','00045694');
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-07-28','PSPRT-ZGBH-46-0','PSPRT','TOKO','SBYPSN','100.00','3.120','3.120','1','3.120','3.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02850SBY ');
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-02834';
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-ZGBH-47-0','00045695','DP-02834MM ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','380000','2026-07-28','380000','3.800','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-28 14:45:06','3.800','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02834MM','1','RS 16 RS 19','','DP-02834');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-47-0','00045695');
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-07-28','PSPRT-ZGBH-47-0','PSPRT','TOKO','MMPSN','100.00','3.800','3.800','1','3.800','3.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02834MM ');
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-02831';
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-ZGBH-48-0','00045696','DP-02831DU ','CINCIN PALADIUM YL-10 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','716500','2026-07-28','716500','3.510','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-28 15:14:31','3.510','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02831DU','1','RS 22','','DP-02831');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-48-0','00045696');
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-07-28','PSPLT-ZGBH-48-0','PSPLT','TOKO','DUPSN','17.00','3.510','3.510','1','3.510','3.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02831DU ');
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-02822';
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-ZGBH-49-0','00045697','DP-02822SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','899000','2026-07-28','899000','2.340','32.00','25','300000','1200000.00','1','0.014', 'input','2026-07-28 16:26:08','2.340','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02822SBY','1','RS 11 5','','DP-02822');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGBH-49-0','00045697');
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-07-28','PSPLT-ZGBH-49-0','PSPLT','TOKO','SBYPSN','32.00','2.340','2.340','1','2.340','2.340','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02822SBY ');
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-02865';
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-ZGBH-50-0','00045698','DP-02865SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','157000','2026-07-28','157000','1.570','100.00','925','340000','100000.00','1','0.014', 'input','2026-07-28 16:27:46','1.570','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02865SBY','1','RS 8','','DP-02865');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-50-0','00045698');
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-07-28','PSPRT-ZGBH-50-0','PSPRT','TOKO','SBYPSN','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02865SBY ');
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-02847';
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-ZGBH-51-0','00045699','DP-02847SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','293000','2026-07-28','293000','2.930','100.00','925','200000','100000.00','1','0.014', 'input','2026-07-28 16:29:16','2.930','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02847SBY','1','RS 20','','DP-02847');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-51-0','00045699');
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-07-28','PSPRT-ZGBH-51-0','PSPRT','TOKO','SBYPSN','100.00','2.930','2.930','1','2.930','2.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02847SBY ');
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-02891';
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-ZGBH-52-0','00045700','DP-02891SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','289000','2026-07-28','289000','2.890','100.00','925','200000','100000.00','1','0.014', 'input','2026-07-28 16:30:45','2.890','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02891SBY','1','RS 21','','DP-02891');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGBH-52-0','00045700');
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-07-28','PSPRT-ZGBH-52-0','PSPRT','TOKO','SBYPSN','100.00','2.890','2.890','1','2.890','2.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02891SBY ');
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-02770';
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-ZGBH-53-0','00045701','DP-02770SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','7286000','2026-07-28','7286000','3.850','83.00','75','250000','2280000.00','1','0.014', 'input','2026-07-28 16:32:17','3.850','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02770SBY','1','RS 18 5','','DP-02770');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGBH-53-0','00045701');
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-07-28','PSGT-ZGBH-53-0','PSGT','TOKO','SBYPSN','83.00','3.850','3.850','1','3.850','3.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02770SBY ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0002','1','PSPRT-ZGBG-1-0','1','3.020','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-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-ZGBG-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','2','PSPRT-ZGBG-2-0','1','1.830','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-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-ZGBG-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.830',berat_out_asli='1.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.830',berat_akhir_asli =berat_akhir_asli-'1.830' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','3','PSGT-ZGBG-3-0','1','2.680','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBG-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBG-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBG-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBG-3-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-ZGBG-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.680',berat_out_asli='2.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.680',berat_akhir_asli =berat_akhir_asli-'2.680' WHERE kode_barang='PSGT-ZGBG-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-260728-0002','4','PSPRT-ZGBG-4-0','1','3.180','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-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-ZGBG-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','5','PSPRT-ZGBG-5-0','1','2.080','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-5-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-ZGBG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','6','PSPRT-ZGBG-6-0','1','1.970','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-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-ZGBG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','7','PSPRT-ZGBG-7-0','1','2.630','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-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-ZGBG-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.630',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.630',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='PSPRT-ZGBG-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-260728-0002','8','PSGT-ZGBH-14-0','1','1.600','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-14-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-ZGBH-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='PSGT-ZGBH-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-260728-0002','9','PSPRT-ZGBH-15-0','1','5.330','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-15-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-ZGBH-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.330',berat_out_asli='5.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.330',berat_akhir_asli =berat_akhir_asli-'5.330' WHERE kode_barang='PSPRT-ZGBH-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-260728-0002','10','PSGT-ZGBH-16-0','1','1.870','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-16-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-ZGBH-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.870',berat_out_asli='1.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.870',berat_akhir_asli =berat_akhir_asli-'1.870' WHERE kode_barang='PSGT-ZGBH-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-260728-0002','11','PSPRT-ZGBH-17-0','1','2.050','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-17-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-ZGBH-17-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='PSPRT-ZGBH-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-260728-0002','12','PSPRT-ZGBH-18-0','1','3.470','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-18-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-ZGBH-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.470',berat_out_asli='3.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.470',berat_akhir_asli =berat_akhir_asli-'3.470' WHERE kode_barang='PSPRT-ZGBH-18-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-260728-0002','2026-07-28','2026-07-28','16:36','3.470','input','2026-07-28 16:36:40','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0003','1','PSPLT-ZGBH-19-0','1','2.080','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-19-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-ZGBH-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PSPLT-ZGBH-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-260728-0003','2','PSPRT-ZGBH-20-0','1','3.590','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-20-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-ZGBH-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.590',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.590',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='PSPRT-ZGBH-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-260728-0003','3','PSPLT-ZGBH-21-0','1','3.420','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-21-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-ZGBH-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.420',berat_out_asli='3.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.420',berat_akhir_asli =berat_akhir_asli-'3.420' WHERE kode_barang='PSPLT-ZGBH-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-260728-0003','4','PSPRT-ZGBH-22-0','1','3.640','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-22-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-ZGBH-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.640',berat_out_asli='3.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.640',berat_akhir_asli =berat_akhir_asli-'3.640' WHERE kode_barang='PSPRT-ZGBH-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-260728-0003','5','PSPRT-ZGBH-23-0','1','4.470','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-23-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-ZGBH-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.470',berat_out_asli='4.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.470',berat_akhir_asli =berat_akhir_asli-'4.470' WHERE kode_barang='PSPRT-ZGBH-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-260728-0003','6','PSPRT-ZGBH-24-0','1','3.980','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-24-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-ZGBH-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.980',berat_out_asli='3.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.980',berat_akhir_asli =berat_akhir_asli-'3.980' WHERE kode_barang='PSPRT-ZGBH-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-260728-0003','7','PSGT-ZGBH-25-0','1','2.890','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZGBH-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.890',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.890',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='PSGT-ZGBH-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-260728-0003','8','PSPLT-ZGBH-48-0','1','3.510','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-48-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-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='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-ZGBH-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.510',berat_out_asli='3.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.510',berat_akhir_asli =berat_akhir_asli-'3.510' WHERE kode_barang='PSPLT-ZGBH-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-260728-0003','2026-07-28','2026-07-28','16:36','3.510','input','2026-07-28 16:36:59','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','1','PSGT-ZGBH-26-0','1','3.150','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-26-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='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='PSGT-ZGBH-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.150',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.150',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='PSGT-ZGBH-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-260728-0004','2','PSPLT-ZGBH-27-0','1','5.150','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZGBH-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.150',berat_out_asli='5.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.150',berat_akhir_asli =berat_akhir_asli-'5.150' WHERE kode_barang='PSPLT-ZGBH-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-260728-0004','3','PSPLT-ZGBH-28-0','1','3.190','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZGBH-28-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-ZGBH-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-260728-0004','4','PSPRT-ZGBH-29-0','1','1.750','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-29-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='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='PSPRT-ZGBH-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.750',berat_out_asli='1.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.750',berat_akhir_asli =berat_akhir_asli-'1.750' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','5','PSPLT-ZGBH-30-0','1','3.610','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-30-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZGBH-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.610',berat_out_asli='3.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.610',berat_akhir_asli =berat_akhir_asli-'3.610' WHERE kode_barang='PSPLT-ZGBH-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-260728-0004','6','PSPRT-ZGBH-31-0','1','3.110','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-31-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='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='PSPRT-ZGBH-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.110',berat_out_asli='3.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.110',berat_akhir_asli =berat_akhir_asli-'3.110' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','7','PSPLT-ZGBH-32-0','1','2.940','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-32-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-32-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZGBH-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.940',berat_out_asli='2.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.940',berat_akhir_asli =berat_akhir_asli-'2.940' WHERE kode_barang='PSPLT-ZGBH-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-260728-0004','8','PSPRT-ZGBH-33-0','1','2.180','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-33-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-33-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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='PSPRT-ZGBH-33-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='PSPRT-ZGBH-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-260728-0004','9','PSPRT-ZGBH-34-0','1','4.570','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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='PSPRT-ZGBH-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.570',berat_out_asli='4.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.570',berat_akhir_asli =berat_akhir_asli-'4.570' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','10','PSPLT-ZGBH-35-0','1','3.890','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-35-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-ZGBH-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.890',berat_out_asli='3.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.890',berat_akhir_asli =berat_akhir_asli-'3.890' WHERE kode_barang='PSPLT-ZGBH-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-260728-0004','11','PSPRT-ZGBH-36-0','1','2.990','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-36-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='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='PSPRT-ZGBH-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.990',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.990',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','12','PSPRT-ZGBH-37-0','1','6.440','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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='PSPRT-ZGBH-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.440',berat_out_asli='6.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.440',berat_akhir_asli =berat_akhir_asli-'6.440' WHERE kode_barang='PSPRT-ZGBH-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','13','PSPRT-ZGBH-38-0','1','3.330','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-38-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-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='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='PSPRT-ZGBH-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.330',berat_out_asli='3.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.330',berat_akhir_asli =berat_akhir_asli-'3.330' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','14','PSPRT-ZGBH-39-0','1','4.110','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-39-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-39-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-39-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-39-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='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='PSPRT-ZGBH-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.110' WHERE kode_barang='PSPRT-ZGBH-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','15','PSPRT-ZGBH-40-0','1','3.160','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-40-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-40-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-40-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-40-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='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='PSPRT-ZGBH-40-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='PSPRT-ZGBH-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-260728-0004','16','PSGT-ZGBH-41-0','1','2.060','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-41-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-41-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-41-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-41-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='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='PSGT-ZGBH-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='PSGT-ZGBH-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-260728-0004','17','PSPRT-ZGBH-42-0','1','2.390','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-42-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-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='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='PSPRT-ZGBH-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','18','PSPLT-ZGBH-43-0','1','4.110','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-43-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-43-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-43-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-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='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-ZGBH-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.110' WHERE kode_barang='PSPLT-ZGBH-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-260728-0004','19','PSGT-ZGBH-44-0','1','2.120','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-44-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-44-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='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='PSGT-ZGBH-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.120',berat_out_asli='2.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.120',berat_akhir_asli =berat_akhir_asli-'2.120' WHERE kode_barang='PSGT-ZGBH-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-260728-0004','20','PSGT-ZGBH-45-0','1','1.960','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-45-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-45-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='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='PSGT-ZGBH-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='PSGT-ZGBH-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','21','PSPRT-ZGBH-46-0','1','3.120','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-46-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-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='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='PSPRT-ZGBH-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.120',berat_out_asli='3.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.120',berat_akhir_asli =berat_akhir_asli-'3.120' WHERE kode_barang='PSPRT-ZGBH-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-260728-0004','22','PSPLT-ZGBH-49-0','1','2.340','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-49-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-49-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-49-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-49-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-ZGBH-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='PSPLT-ZGBH-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','23','PSPRT-ZGBH-50-0','1','1.570','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-50-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-50-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='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='PSPRT-ZGBH-50-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='PSPRT-ZGBH-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','24','PSPRT-ZGBH-51-0','1','2.930','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-51-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-51-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-51-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-51-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='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='PSPRT-ZGBH-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.930' WHERE kode_barang='PSPRT-ZGBH-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','25','PSPRT-ZGBH-52-0','1','2.890','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-52-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-52-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='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='PSPRT-ZGBH-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.890',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.890',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='PSPRT-ZGBH-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260728-0004','26','PSGT-ZGBH-53-0','1','3.850','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-53-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGBH-53-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-53-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-53-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='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='PSGT-ZGBH-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.850',berat_out_asli='3.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.850',berat_akhir_asli =berat_akhir_asli-'3.850' WHERE kode_barang='PSGT-ZGBH-53-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-260728-0004','2026-07-28','2026-07-28','16:37','3.850','input','2026-07-28 16:37:14','THIFA');