INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','08:10:47'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-08','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-07'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-07'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-07'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-07' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-07'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-07'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-07'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-07'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-08' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-07' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-10-08'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','08:53:56'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTKL-ZJXG-95-0','00031751','00031751','KL ITALY ST VAR BT 42CM KKT PER BLT MK ','KL ITALY ST VAR BT 42CM KKT PER BLT SHB','','','5943500','5943500',' 0','0','adminpusat','2026-10-08 08:54:23'); UPDATE tm_barang SET nama_barang='KL ITALY ST VAR BT 42CM KKT PER BLT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTKL-ZJXG-95-0' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MDKL-ZJXG-39-0','00031695','00031695','KL FANCY 42CM KKT PER SHB ','KL FANCY 42CM KKT PER SHB','','','3297000','3297000',' 0','0','adminpusat','2026-10-08 08:56:42'); UPDATE tm_barang SET nama_barang='KL FANCY 42CM KKT PER SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDKL-ZJXG-39-0' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','09:39:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','10:41:46'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','11:45:42'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0001','1','MDAT-ZJXG-1-0','1','1.180','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-1-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.180',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.180',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','2','MDAT-ZJXG-2-0','1','0.800','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-2-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.800',berat_out_asli='0.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.800',berat_akhir_asli =berat_akhir_asli-'0.790' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','3','MDAT-ZJXG-3-0','1','1.540','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-3-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.530' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','4','MDAT-ZJXG-4-0','1','1.450','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-4-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.450',berat_out_asli='1.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.450',berat_akhir_asli =berat_akhir_asli-'1.440' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','5','MDAT-ZJXG-5-0','1','1.200','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-5-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-5-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.200',berat_out_asli='1.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.200',berat_akhir_asli =berat_akhir_asli-'1.190' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','6','MDAT-ZJXG-6-0','1','1.060','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-6-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-6-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.060',berat_out_asli='1.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.060',berat_akhir_asli =berat_akhir_asli-'1.050' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','7','MDAT-ZJXG-7-0','1','1.820','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-7-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-7-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.820',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.820',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','8','MDAT-ZJXG-8-0','1','1.270','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-8-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-8-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.270',berat_out_asli='1.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.270',berat_akhir_asli =berat_akhir_asli-'1.260' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','9','MDAT-ZJXG-9-0','1','0.500','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-9-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-9-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.490' WHERE kode_barang='MDAT-ZJXG-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-261008-0001','10','MDAT-ZJXG-10-0','1','0.420','TOKO','BATMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJXG-10-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJXG-10-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZJXG-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.420',berat_out_asli='0.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.420',berat_akhir_asli =berat_akhir_asli-'0.410' WHERE kode_barang='MDAT-ZJXG-10-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-261008-0001','2026-10-08','2026-10-08','11:46','0.420','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0002','1','MDCN-ZJXG-11-0','1','2.500','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-11-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-11-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.490' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','2','MDCN-ZJXG-12-0','1','1.020','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-12-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-12-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.010' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','3','MDCN-ZJXG-13-0','1','1.370','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-13-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-13-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.370',berat_out_asli='1.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.370',berat_akhir_asli =berat_akhir_asli-'1.360' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','4','MDCN-ZJXG-14-0','1','2.050','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-14-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-14-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.040' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','5','MDCN-ZJXG-15-0','1','0.720','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-15-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-15-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.720',berat_out_asli='0.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.720',berat_akhir_asli =berat_akhir_asli-'0.710' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','6','MDCN-ZJXG-16-0','1','1.680','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-16-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-16-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.670' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','7','MDCN-ZJXG-17-0','1','1.130','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-17-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-17-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.130',berat_out_asli='1.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.130',berat_akhir_asli =berat_akhir_asli-'1.120' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','8','MDCN-ZJXG-18-0','1','1.510','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-18-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-18-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.510',berat_out_asli='1.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.510',berat_akhir_asli =berat_akhir_asli-'1.500' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','9','MDCN-ZJXG-19-0','1','1.950','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-19-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-19-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','10','MDCN-ZJXG-20-0','1','2.100','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-20-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-20-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','11','MDCN-ZJXG-21-0','1','1.740','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-21-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-21-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.740',berat_out_asli='1.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.740',berat_akhir_asli =berat_akhir_asli-'1.730' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','12','MDCN-ZJXG-22-0','1','1.550','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-22-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-22-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.550',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.550',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','13','MDCN-ZJXG-23-0','1','0.900','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-23-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-23-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.900',berat_out_asli='0.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.900',berat_akhir_asli =berat_akhir_asli-'0.890' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','14','MDCN-ZJXG-24-0','1','0.830','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-24-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-24-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.830',berat_out_asli='0.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.830',berat_akhir_asli =berat_akhir_asli-'0.820' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','15','MDCN-ZJXG-25-0','1','0.870','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-25-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-25-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.870',berat_out_asli='0.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.870',berat_akhir_asli =berat_akhir_asli-'0.860' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','16','MDCN-ZJXG-26-0','1','0.900','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-26-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-26-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.900',berat_out_asli='0.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.900',berat_akhir_asli =berat_akhir_asli-'0.890' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','17','MDCN-ZJXG-27-0','1','1.080','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-27-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-27-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MDCN-ZJXG-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-261008-0002','18','MDCN-ZJXG-28-0','1','1.250','TOKO','BCNMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXG-28-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZJXG-28-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BCNMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BCNMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDCN-ZJXG-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.240' WHERE kode_barang='MDCN-ZJXG-28-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-261008-0002','2026-10-08','2026-10-08','11:46','1.250','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0003','1','MDGL-ZJXG-29-0','1','3.810','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-29-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-29-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.810',berat_out_asli='3.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.810',berat_akhir_asli =berat_akhir_asli-'3.800' WHERE kode_barang='MDGL-ZJXG-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-261008-0003','2','MDGL-ZJXG-30-0','1','2.620','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-30-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-30-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.620',berat_out_asli='2.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.620',berat_akhir_asli =berat_akhir_asli-'2.610' WHERE kode_barang='MDGL-ZJXG-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-261008-0003','3','MDGL-ZJXG-31-0','1','4.340','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-31-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-31-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-31-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.340',berat_out_asli='4.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.340',berat_akhir_asli =berat_akhir_asli-'4.330' WHERE kode_barang='MDGL-ZJXG-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-261008-0003','4','MDGL-ZJXG-32-0','1','3.380','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-32-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-32-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.380',berat_out_asli='3.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.380',berat_akhir_asli =berat_akhir_asli-'3.370' WHERE kode_barang='MDGL-ZJXG-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-261008-0003','5','MDGL-ZJXG-33-0','1','4.920','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-33-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-33-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.920',berat_out_asli='4.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.920',berat_akhir_asli =berat_akhir_asli-'4.910' WHERE kode_barang='MDGL-ZJXG-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-261008-0003','6','MDGL-ZJXG-34-0','1','11.080','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXG-34-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXG-34-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZJXG-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='11.080',berat_out_asli='11.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.080',berat_akhir_asli =berat_akhir_asli-'11.070' WHERE kode_barang='MDGL-ZJXG-34-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261008-0003','2026-10-08','2026-10-08','11:46','11.080','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0004','1','MSGL-ZJXG-51-0','1','1.500','TOKO','BGLMS'); DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZJXG-51-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MSGL-ZJXG-51-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MS' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MS' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MSGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMS'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMS'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MSGL-ZJXG-51-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.500',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.500',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='MSGL-ZJXG-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-261008-0004','2','MSGL-ZJXG-52-0','1','15.050','TOKO','BGLMS'); DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZJXG-52-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MSGL-ZJXG-52-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MS' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MS' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MSGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMS'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMS'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MSGL-ZJXG-52-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='15.050',berat_out_asli='15.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'15.050',berat_akhir_asli =berat_akhir_asli-'15.040' WHERE kode_barang='MSGL-ZJXG-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-261008-0004','3','MSGL-ZJXG-53-0','1','9.690','TOKO','BGLMS'); DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZJXG-53-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MSGL-ZJXG-53-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MS' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MS' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MSGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMS'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMS'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MSGL-ZJXG-53-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='9.690',berat_out_asli='9.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.690',berat_akhir_asli =berat_akhir_asli-'9.680' WHERE kode_barang='MSGL-ZJXG-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) VALUES ('EX-261008-0004','2026-10-08','2026-10-08','11:46','9.690','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0005','1','MDGW-ZJXG-35-0','1','2.050','TOKO','BGWMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZJXG-35-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZJXG-35-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGW' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGWMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGWMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGW-ZJXG-35-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.040' WHERE kode_barang='MDGW-ZJXG-35-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-261008-0005','2026-10-08','2026-10-08','11:46','2.050','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','1','MTAT-ZJXG-54-0','1','1.460','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-54-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-54-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-54-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='MTAT-ZJXG-54-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','2','MTAT-ZJXG-55-0','1','1.220','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-55-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-55-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-55-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='MTAT-ZJXG-55-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','3','MTAT-ZJXG-56-0','1','1.660','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-56-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-56-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-56-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.660',berat_out_asli='1.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.660',berat_akhir_asli =berat_akhir_asli-'1.650' WHERE kode_barang='MTAT-ZJXG-56-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','4','MTAT-ZJXG-57-0','1','2.120','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-57-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-57-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-57-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.120',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.120',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='MTAT-ZJXG-57-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','5','MTAT-ZJXG-58-0','1','1.440','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-58-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-58-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-58-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.440',berat_out_asli='1.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.440',berat_akhir_asli =berat_akhir_asli-'1.430' WHERE kode_barang='MTAT-ZJXG-58-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','6','MTAT-ZJXG-59-0','1','0.770','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-59-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-59-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-59-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.770',berat_out_asli='0.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.770',berat_akhir_asli =berat_akhir_asli-'0.760' WHERE kode_barang='MTAT-ZJXG-59-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','7','MTAT-ZJXG-60-0','1','0.580','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-60-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-60-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-60-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.580',berat_out_asli='0.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.580',berat_akhir_asli =berat_akhir_asli-'0.570' WHERE kode_barang='MTAT-ZJXG-60-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','8','MTAT-ZJXG-61-0','1','0.600','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-61-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-61-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-61-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.600',berat_out_asli='0.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.600',berat_akhir_asli =berat_akhir_asli-'0.590' WHERE kode_barang='MTAT-ZJXG-61-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0006','9','MTAT-ZJXG-62-0','1','0.510','TOKO','BKATMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXG-62-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZJXG-62-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZJXG-62-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.510',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.510',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='MTAT-ZJXG-62-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-261008-0006','2026-10-08','2026-10-08','11:46','0.510','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','1','MTCN-ZJXG-63-0','1','3.730','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-63-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-63-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-63-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.730',berat_out_asli='3.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.730',berat_akhir_asli =berat_akhir_asli-'3.720' WHERE kode_barang='MTCN-ZJXG-63-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','2','MTCN-ZJXG-64-0','1','0.520','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-64-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-64-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-64-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.520',berat_out_asli='0.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.520',berat_akhir_asli =berat_akhir_asli-'0.510' WHERE kode_barang='MTCN-ZJXG-64-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','3','MTCN-ZJXG-65-0','1','0.990','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-65-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-65-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-65-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.990',berat_out_asli='0.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.990',berat_akhir_asli =berat_akhir_asli-'0.980' WHERE kode_barang='MTCN-ZJXG-65-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','4','MTCN-ZJXG-66-0','1','1.010','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-66-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-66-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-66-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.010',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.010',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='MTCN-ZJXG-66-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','5','MTCN-ZJXG-67-0','1','0.990','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-67-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-67-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-67-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.990',berat_out_asli='0.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.990',berat_akhir_asli =berat_akhir_asli-'0.980' WHERE kode_barang='MTCN-ZJXG-67-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','6','MTCN-ZJXG-68-0','1','2.880','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-68-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-68-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-68-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.880',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.880',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='MTCN-ZJXG-68-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','7','MTCN-ZJXG-69-0','1','1.230','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-69-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-69-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-69-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.230',berat_out_asli='1.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.230',berat_akhir_asli =berat_akhir_asli-'1.220' WHERE kode_barang='MTCN-ZJXG-69-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','8','MTCN-ZJXG-70-0','1','1.900','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-70-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-70-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-70-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.890' WHERE kode_barang='MTCN-ZJXG-70-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','9','MTCN-ZJXG-71-0','1','1.050','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-71-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-71-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-71-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.050',berat_out_asli='1.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.050',berat_akhir_asli =berat_akhir_asli-'1.040' WHERE kode_barang='MTCN-ZJXG-71-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','10','MTCN-ZJXG-72-0','1','0.930','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-72-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-72-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-72-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.930',berat_out_asli='0.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.930',berat_akhir_asli =berat_akhir_asli-'0.920' WHERE kode_barang='MTCN-ZJXG-72-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','11','MTCN-ZJXG-73-0','1','1.730','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-73-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-73-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-73-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.730',berat_out_asli='1.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.730',berat_akhir_asli =berat_akhir_asli-'1.720' WHERE kode_barang='MTCN-ZJXG-73-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','12','MTCN-ZJXG-74-0','1','2.900','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-74-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-74-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-74-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='MTCN-ZJXG-74-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','13','MTCN-ZJXG-75-0','1','2.140','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-75-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-75-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-75-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='MTCN-ZJXG-75-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0007','14','MTCN-ZJXG-76-0','1','2.960','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXG-76-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXG-76-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZJXG-76-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.960',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.960',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='MTCN-ZJXG-76-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-261008-0007','2026-10-08','2026-10-08','11:46','2.960','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','1','MTGL-ZJXG-77-0','1','3.000','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-77-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-77-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-77-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='MTGL-ZJXG-77-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','2','MTGL-ZJXG-78-0','1','3.510','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-78-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-78-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-78-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.510',berat_out_asli='3.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.510',berat_akhir_asli =berat_akhir_asli-'3.500' WHERE kode_barang='MTGL-ZJXG-78-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','3','MTGL-ZJXG-79-0','1','4.940','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-79-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-79-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-79-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.940',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.940',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='MTGL-ZJXG-79-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','4','MTGL-ZJXG-80-0','1','3.000','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-80-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-80-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-80-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='MTGL-ZJXG-80-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','5','MTGL-ZJXG-81-0','1','5.290','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-81-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-81-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-81-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.290',berat_out_asli='5.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.290',berat_akhir_asli =berat_akhir_asli-'5.280' WHERE kode_barang='MTGL-ZJXG-81-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','6','MTGL-ZJXG-82-0','1','4.040','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-82-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-82-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-82-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.040',berat_out_asli='4.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.040',berat_akhir_asli =berat_akhir_asli-'4.030' WHERE kode_barang='MTGL-ZJXG-82-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','7','MTGL-ZJXG-83-0','1','3.720','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-83-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-83-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-83-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.720',berat_out_asli='3.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.720',berat_akhir_asli =berat_akhir_asli-'3.710' WHERE kode_barang='MTGL-ZJXG-83-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','8','MTGL-ZJXG-84-0','1','10.390','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-84-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-84-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-84-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='10.390',berat_out_asli='10.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.390',berat_akhir_asli =berat_akhir_asli-'10.380' WHERE kode_barang='MTGL-ZJXG-84-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','9','MTGL-ZJXG-85-0','1','10.900','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-85-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-85-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-85-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='10.900',berat_out_asli='10.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.900',berat_akhir_asli =berat_akhir_asli-'10.890' WHERE kode_barang='MTGL-ZJXG-85-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0008','10','MTGL-ZJXG-86-0','1','10.690','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXG-86-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXG-86-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXG-86-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='10.690',berat_out_asli='10.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.690',berat_akhir_asli =berat_akhir_asli-'10.680' WHERE kode_barang='MTGL-ZJXG-86-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-261008-0008','2026-10-08','2026-10-08','11:47','10.690','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0009','1','MTGW-ZJXG-87-0','1','0.500','TOKO','BKGWMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXG-87-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZJXG-87-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZJXG-87-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.490' WHERE kode_barang='MTGW-ZJXG-87-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0009','2','MTGW-ZJXG-88-0','1','1.320','TOKO','BKGWMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXG-88-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZJXG-88-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZJXG-88-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.320',berat_out_asli='1.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.320',berat_akhir_asli =berat_akhir_asli-'1.310' WHERE kode_barang='MTGW-ZJXG-88-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-261008-0009','2026-10-08','2026-10-08','11:47','1.320','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','1','MTKL-ZJXG-89-0','1','4.030','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-89-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-89-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-89-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.030',berat_out_asli='4.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.030',berat_akhir_asli =berat_akhir_asli-'4.020' WHERE kode_barang='MTKL-ZJXG-89-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','2','MTKL-ZJXG-90-0','1','5.040','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-90-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-90-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-90-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.040',berat_out_asli='5.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.040',berat_akhir_asli =berat_akhir_asli-'5.030' WHERE kode_barang='MTKL-ZJXG-90-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','3','MTKL-ZJXG-91-0','1','7.100','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-91-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-91-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-91-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='7.100',berat_out_asli='7.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.100',berat_akhir_asli =berat_akhir_asli-'7.090' WHERE kode_barang='MTKL-ZJXG-91-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','4','MTKL-ZJXG-92-0','1','3.040','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-92-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-92-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-92-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.040',berat_out_asli='3.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.040',berat_akhir_asli =berat_akhir_asli-'3.030' WHERE kode_barang='MTKL-ZJXG-92-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','5','MTKL-ZJXG-93-0','1','3.390','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-93-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-93-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-93-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.380' WHERE kode_barang='MTKL-ZJXG-93-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','6','MTKL-ZJXG-94-0','1','2.950','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-94-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-94-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-94-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.940' WHERE kode_barang='MTKL-ZJXG-94-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0010','7','MTKL-ZJXG-95-0','1','3.230','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-95-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-95-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-95-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.230',berat_out_asli='3.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.230',berat_akhir_asli =berat_akhir_asli-'3.220' WHERE kode_barang='MTKL-ZJXG-95-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-261008-0010','2026-10-08','2026-10-08','11:47','3.230','adminpusat','261008'); INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261008-0011','2026-10-08','2026-10-08','11:47','','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0012','1','MDKL-ZJXG-36-0','1','5.900','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-36-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-36-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-36-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.900',berat_out_asli='5.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.900',berat_akhir_asli =berat_akhir_asli-'5.890' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','2','MDKL-ZJXG-37-0','1','5.070','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-37-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-37-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-37-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.070',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.070',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','3','MDKL-ZJXG-38-0','1','13.340','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-38-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-38-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-38-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='13.340',berat_out_asli='13.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.340',berat_akhir_asli =berat_akhir_asli-'13.330' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','4','MDKL-ZJXG-39-0','1','2.970','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-39-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-39-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-39-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.970',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.970',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','5','MDKL-ZJXG-40-0','1','2.500','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-40-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-40-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-40-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.490' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','6','MDKL-ZJXG-41-0','1','1.950','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-41-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-41-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-41-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','7','MDKL-ZJXG-42-0','1','2.070','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-42-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-42-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-42-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','8','MDKL-ZJXG-43-0','1','2.170','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-43-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-43-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-43-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','9','MDKL-ZJXG-44-0','1','2.710','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-44-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-44-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-44-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.710',berat_out_asli='2.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.710',berat_akhir_asli =berat_akhir_asli-'2.700' WHERE kode_barang='MDKL-ZJXG-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-261008-0012','10','MDKL-ZJXG-45-0','1','2.450','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXG-45-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXG-45-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZJXG-45-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.450',berat_out_asli='2.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.450',berat_akhir_asli =berat_akhir_asli-'2.440' WHERE kode_barang='MDKL-ZJXG-45-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261008-0012','2026-10-08','2026-10-08','11:47','2.450','adminpusat','261008'); INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261008-0013','2026-10-08','2026-10-08','11:47','','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0014','1','MTKL-ZJXG-100-0','1','13.630','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXG-100-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXG-100-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKMF'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKMF'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZJXG-100-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='13.630',berat_out_asli='13.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.630',berat_akhir_asli =berat_akhir_asli-'13.620' WHERE kode_barang='MTKL-ZJXG-100-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-261008-0014','2026-10-08','2026-10-08','11:47','13.630','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0015','1','MDLT-ZJXG-46-0','1','1.150','TOKO','BLTMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZJXG-46-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZJXG-46-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-ZJXG-46-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.150',berat_out_asli='1.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.150',berat_akhir_asli =berat_akhir_asli-'1.140' WHERE kode_barang='MDLT-ZJXG-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-261008-0015','2','MDLT-ZJXG-47-0','1','1.090','TOKO','BLTMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZJXG-47-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZJXG-47-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-ZJXG-47-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.090',berat_out_asli='1.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.090',berat_akhir_asli =berat_akhir_asli-'1.080' WHERE kode_barang='MDLT-ZJXG-47-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0015','3','MDLT-ZJXG-48-0','1','0.970','TOKO','BLTMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZJXG-48-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZJXG-48-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-ZJXG-48-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.970',berat_out_asli='0.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.970',berat_akhir_asli =berat_akhir_asli-'0.960' WHERE kode_barang='MDLT-ZJXG-48-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0015','4','MDLT-ZJXG-49-0','1','8.880','TOKO','BLTMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZJXG-49-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZJXG-49-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-ZJXG-49-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='8.880',berat_out_asli='8.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.880',berat_akhir_asli =berat_akhir_asli-'8.870' WHERE kode_barang='MDLT-ZJXG-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-261008-0015','5','MDLT-ZJXG-50-0','1','1.930','TOKO','BLTMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZJXG-50-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZJXG-50-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-ZJXG-50-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.920' WHERE kode_barang='MDLT-ZJXG-50-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-261008-0015','2026-10-08','2026-10-08','11:47','1.930','adminpusat','261008'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0016','1','MTLT-ZJXG-96-0','1','1.330','TOKO','BKLTMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZJXG-96-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-ZJXG-96-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-ZJXG-96-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.330',berat_out_asli='1.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.330',berat_akhir_asli =berat_akhir_asli-'1.320' WHERE kode_barang='MTLT-ZJXG-96-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0016','2','MTLT-ZJXG-97-0','1','1.570','TOKO','BKLTMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZJXG-97-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-ZJXG-97-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-ZJXG-97-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='MTLT-ZJXG-97-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0016','3','MTLT-ZJXG-98-0','1','0.750','TOKO','BKLTMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZJXG-98-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-ZJXG-98-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-ZJXG-98-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.750',berat_out_asli='0.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.750',berat_akhir_asli =berat_akhir_asli-'0.740' WHERE kode_barang='MTLT-ZJXG-98-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261008-0016','4','MTLT-ZJXG-99-0','1','1.120','TOKO','BKLTMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZJXG-99-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-ZJXG-99-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-ZJXG-99-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.120',berat_out_asli='1.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.120',berat_akhir_asli =berat_akhir_asli-'1.110' WHERE kode_barang='MTLT-ZJXG-99-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-261008-0016','2026-10-08','2026-10-08','11:48','1.120','adminpusat','261008');