INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250921-0001','1','D2D-YHAI-165-0','1','0.620','TOKO','PMBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PMBK-D';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PMBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D2D-YHAI-165-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.620',berat_out_asli='0.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.620',berat_akhir_asli =berat_akhir_asli-'0.620' WHERE kode_barang='D2D-YHAI-165-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-250921-0001','2025-09-21','2025-09-21','09:33','0.620','irgosa','250921');