INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-08 ','08:35:42'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-08','121','0','-177500000','121','0','-177500000'); 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'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0001','D','2026-10-08','08:35:50','','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0001','D','2026-10-08','08:35:50','BCA','SALDO AWAL','SALDO AWAL','0','1366639582','1366639582'); UPDATE tp_system SET tgl_system='2026-10-08'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-08 ','08:36:11'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','08:41:40'); INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261008-0001','1','X-00009896','BELI','BELI001','AT JEPSI PLS MK','1','0.260','371000.00' ,'0.00','371000','','371000','371000','RONGSOK'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-08 08:42:27' WHERE kode_barang='X-00009896' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009896' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009896' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.260',berat_hancur_asli=berat_hancur_asli+'0.260', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261008-0001','2','X-00009897','BELI','BELI001','LT COR BOROBUDUR LC2','1','4.720','4505000.00' ,'0.00','4505000','','4505000','5247000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-08 08:42:27' WHERE kode_barang='X-00009897' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009897' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009897' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.720',berat_hancur_asli=berat_hancur_asli+'4.720', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.720',berat_akhir_asli=berat_akhir_asli-'4.720' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDLT' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261008-0001','3','X-00009898','BELI','BELI001','KL RANGKAIAN PJG 60CM KKT PER LC2','1','13.870','13238500.00' ,'0.00','13238500','','13238500','22990500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-08 08:42:27' WHERE kode_barang='X-00009898' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009898' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009898' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'13.870',berat_hancur_asli=berat_hancur_asli+'13.870', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'13.870',berat_akhir_asli=berat_akhir_asli-'13.870' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261008-0001','4','X-00009899','BELI','BELI001','CN COR BT SHB','1','1.350','1288500.00' ,'0.00','1288500','','1288500','37517500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-08 08:42:27' WHERE kode_barang='X-00009899' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009899' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009899' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.350',berat_hancur_asli=berat_hancur_asli+'1.350', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-261008-0001','adminpusat','2026-10-08','2026-10-08','08:42:28','19403000','37517500', 'adminpusat','2026-10-08 08:42:27'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0002','D','2026-10-08','08:53:55','cashier1','PEMASUKAN','TERIMA DARI PUSAT PAK BUDI','82266586','40000000','122266586'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-08 ','08:58:00'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MDCN-ZJXF-101-0','1','1.250','1.250','TOKO','BCNMD','TOKO','BTCNMD'); DELETE FROM tm_barang WHERE kode_barang='MDCN-ZJXF-101-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZJXF-101-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-10-08 09:05:40' WHERE kode_barang='MDCN-ZJXF-101-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZJXF-101-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:05:40','TOKO','BTCNMD','MDCN','MDCN-ZJXF-101-0','1','1.250','1.240','1','1.250','1.240','100.00'); DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZJXF-101-0'; DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZJXF-101-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','09:05','1.250','cashier1','2026-10-08 09:05:40'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXE-1-0','1','0.700','0.700','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXE-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXE-1-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXE-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXE-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXE-1-0','1','0.700','0.690','1','0.700','0.690','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXE-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXE-1-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-1-0','1','0.730','0.730','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-1-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-1-0','1','0.730','0.720','1','0.730','0.720','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-1-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-2-0','1','0.650','0.650','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-2-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-2-0','1','0.650','0.640','1','0.650','0.640','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-2-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-3-0','1','0.730','0.730','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-3-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-3-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-3-0','1','0.730','0.720','1','0.730','0.720','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-3-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-4-0','1','0.730','0.730','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-4-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-4-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-4-0','1','0.730','0.720','1','0.730','0.720','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-4-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-5-0','1','0.520','0.520','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-5-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-5-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-5-0','1','0.520','0.510','1','0.520','0.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-5-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-6-0','1','1.070','1.070','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-6-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-6-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-6-0','1','1.070','1.060','1','1.070','1.060','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-6-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-7-0','1','2.240','2.240','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-7-0','1','2.240','2.230','1','2.240','2.230','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-7-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-8-0','1','0.650','0.650','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-8-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-8-0','1','0.650','0.640','1','0.650','0.640','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-8-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-9-0','1','1.520','1.520','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-9-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-9-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-9-0','1','1.520','1.510','1','1.520','1.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-9-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-10-0','1','1.340','1.340','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-10-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-10-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-10-0','1','1.340','1.330','1','1.340','1.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-10-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-11-0','1','1.010','1.010','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-11-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-11-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-11-0','1','1.010','1.000','1','1.010','1.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-11-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-12-0','1','1.540','1.540','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-12-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-12-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-12-0','1','1.540','1.530','1','1.540','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-12-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-13-0','1','1.180','1.180','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-13-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-13-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-13-0','1','1.180','1.170','1','1.180','1.170','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-13-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-14-0','1','1.420','1.420','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-14-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-14-0','1','1.420','1.410','1','1.420','1.410','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-14-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-15-0','1','2.100','2.100','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-15-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-15-0','1','2.100','2.090','1','2.100','2.090','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-15-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-16-0','1','1.600','1.600','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-16-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-16-0','1','1.600','1.590','1','1.600','1.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-16-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-17-0','1','1.270','1.270','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-17-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-17-0','1','1.270','1.260','1','1.270','1.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-17-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-18-0','1','1.300','1.300','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-18-0','1','1.300','1.290','1','1.300','1.290','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-18-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-19-0','1','1.970','1.970','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-19-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-19-0','1','1.970','1.960','1','1.970','1.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-19-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-20-0','1','2.160','2.160','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-20-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-20-0','1','2.160','2.150','1','2.160','2.150','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-20-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-21-0','1','2.010','2.010','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-21-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-21-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-21-0','1','2.010','2.000','1','2.010','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-21-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-22-0','1','1.650','1.650','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-22-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-22-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-22-0','1','1.650','1.640','1','1.650','1.640','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-22-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-23-0','1','1.560','1.560','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-23-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-23-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-23-0','1','1.560','1.550','1','1.560','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-23-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-24-0','1','1.770','1.770','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-24-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-24-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-24-0','1','1.770','1.760','1','1.770','1.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-24-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-25-0','1','2.200','2.200','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-25-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-25-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-25-0','1','2.200','2.190','1','2.200','2.190','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-25-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-26-0','1','1.680','1.680','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-26-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-26-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-26-0','1','1.680','1.670','1','1.680','1.670','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-26-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-27-0','1','1.510','1.510','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-27-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-27-0','1','1.510','1.500','1','1.510','1.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-27-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-28-0','1','0.580','0.580','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-28-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-28-0','1','0.580','0.570','1','0.580','0.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-28-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-29-0','1','0.600','0.600','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-29-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-29-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-29-0','1','0.600','0.590','1','0.600','0.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-29-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-30-0','1','0.620','0.620','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-30-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-30-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-30-0','1','0.620','0.610','1','0.620','0.610','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-30-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-31-0','1','0.600','0.600','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-31-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-31-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-31-0','1','0.600','0.590','1','0.600','0.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-31-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-32-0','1','0.650','0.650','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-32-0','1','0.650','0.640','1','0.650','0.640','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-32-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-33-0','1','0.600','0.600','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-33-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-33-0','1','0.600','0.590','1','0.600','0.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-33-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-34-0','1','0.630','0.630','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-34-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-34-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-34-0','1','0.630','0.620','1','0.630','0.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-34-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-35-0','1','0.570','0.570','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-35-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-35-0','1','0.570','0.560','1','0.570','0.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-35-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-36-0','1','0.970','0.970','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-36-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-36-0','1','0.970','0.960','1','0.970','0.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-36-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-37-0','1','0.960','0.960','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-37-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-37-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-37-0','1','0.960','0.950','1','0.960','0.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-37-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-38-0','1','1.210','1.210','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-38-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-38-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-38-0','1','1.210','1.200','1','1.210','1.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-38-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-39-0','1','1.160','1.160','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-39-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-39-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-39-0','1','1.160','1.150','1','1.160','1.150','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-39-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-40-0','1','1.020','1.020','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-40-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-40-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-40-0','1','1.020','1.010','1','1.020','1.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-40-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-41-0','1','1.540','1.540','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-41-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-41-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-41-0','1','1.540','1.530','1','1.540','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-41-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-42-0','1','2.200','2.200','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-42-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-42-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-42-0','1','2.200','2.190','1','2.200','2.190','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-42-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-43-0','1','1.710','1.710','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-43-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-43-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-43-0','1','1.710','1.700','1','1.710','1.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-43-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-44-0','1','1.960','1.960','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-44-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-44-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-44-0','1','1.960','1.950','1','1.960','1.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-44-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-45-0','1','1.960','1.960','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-45-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-45-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-45-0','1','1.960','1.950','1','1.960','1.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-45-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-46-0','1','1.820','1.820','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-46-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-46-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-46-0','1','1.820','1.810','1','1.820','1.810','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-46-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-47-0','1','2.510','2.510','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-47-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-47-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-47-0','1','2.510','2.500','1','2.510','2.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-47-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-48-0','1','2.050','2.050','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-48-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-48-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-48-0','1','2.050','2.040','1','2.050','2.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-48-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-49-0','1','2.070','2.070','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-49-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-49-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-49-0','1','2.070','2.060','1','2.070','2.060','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-49-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-50-0','1','1.470','1.470','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-50-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-50-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-50-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-50-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-50-0','1','1.470','1.460','1','1.470','1.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-50-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-50-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-51-0','1','1.630','1.630','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-51-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-51-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-51-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-51-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-51-0','1','1.630','1.620','1','1.630','1.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-51-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-51-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-52-0','1','1.770','1.770','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-52-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-52-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-52-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-52-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-52-0','1','1.770','1.760','1','1.770','1.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-52-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-52-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-53-0','1','1.470','1.470','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-53-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-53-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-53-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-53-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-53-0','1','1.470','1.460','1','1.470','1.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-53-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-53-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-54-0','1','1.360','1.360','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-54-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-54-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-54-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-54-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-54-0','1','1.360','1.350','1','1.360','1.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-54-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-54-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-55-0','1','1.350','1.350','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-55-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-55-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-55-0','1','1.350','1.340','1','1.350','1.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-55-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-56-0','1','1.540','1.540','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-56-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-56-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-56-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-56-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-56-0','1','1.540','1.530','1','1.540','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-56-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-56-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-57-0','1','1.530','1.530','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-57-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-57-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-57-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-57-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-57-0','1','1.530','1.520','1','1.530','1.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-57-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-57-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-58-0','1','1.330','1.330','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-58-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-58-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-58-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-58-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-58-0','1','1.330','1.320','1','1.330','1.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-58-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-58-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTAT-ZJXF-59-0','1','1.330','1.330','TOKO','BKATMT','TOKO','BTATMT'); DELETE FROM tm_barang WHERE kode_barang='MTAT-ZJXF-59-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-59-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-10-08 09:06:09' WHERE kode_barang='MTAT-ZJXF-59-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZJXF-59-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:06:09','TOKO','BTATMT','MTAT','MTAT-ZJXF-59-0','1','1.330','1.320','1','1.330','1.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZJXF-59-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZJXF-59-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','09:05','81.580','cashier1','2026-10-08 09:06:09'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-60-0','1','1.110','1.110','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-60-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-60-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-60-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-60-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-60-0','1','1.110','1.100','1','1.110','1.100','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-60-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-60-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-61-0','1','1.150','1.150','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-61-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-61-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-61-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-61-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-61-0','1','1.150','1.140','1','1.150','1.140','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-61-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-61-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-62-0','1','0.730','0.730','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-62-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-62-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-62-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-62-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-62-0','1','0.730','0.720','1','0.730','0.720','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-62-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-62-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-63-0','1','1.980','1.980','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-63-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-63-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-63-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-63-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-63-0','1','1.980','1.970','1','1.980','1.970','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-63-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-63-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-64-0','1','2.010','2.010','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-64-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-64-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-64-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-64-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-64-0','1','2.010','2.000','1','2.010','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-64-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-64-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-65-0','1','2.370','2.370','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-65-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-65-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-65-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-65-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-65-0','1','2.370','2.360','1','2.370','2.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-65-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-65-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-66-0','1','1.600','1.600','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-66-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-66-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-66-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-66-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-66-0','1','1.600','1.590','1','1.600','1.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-66-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-66-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-67-0','1','1.320','1.320','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-67-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-67-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-67-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-67-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-67-0','1','1.320','1.310','1','1.320','1.310','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-67-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-67-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-68-0','1','2.300','2.300','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-68-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-68-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-68-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-68-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-68-0','1','2.300','2.290','1','2.300','2.290','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-68-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-68-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-69-0','1','2.210','2.210','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-69-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-69-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-69-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-69-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-69-0','1','2.210','2.200','1','2.210','2.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-69-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-69-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-70-0','1','2.150','2.150','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-70-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-70-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-70-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-70-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-70-0','1','2.150','2.140','1','2.150','2.140','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-70-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-70-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-71-0','1','1.210','1.210','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-71-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-71-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-71-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-71-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-71-0','1','1.210','1.200','1','1.210','1.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-71-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-71-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-72-0','1','1.260','1.260','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-72-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-72-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-72-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-72-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-72-0','1','1.260','1.250','1','1.260','1.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-72-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-72-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-73-0','1','1.610','1.610','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-73-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-73-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-73-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-73-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-73-0','1','1.610','1.600','1','1.610','1.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-73-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-73-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-74-0','1','1.830','1.830','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-74-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-74-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-74-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-74-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-74-0','1','1.830','1.820','1','1.830','1.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-74-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-74-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-75-0','1','1.830','1.830','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-75-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-75-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-75-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-75-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-75-0','1','1.830','1.820','1','1.830','1.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-75-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-75-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-76-0','1','1.800','1.800','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-76-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-76-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-76-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-76-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-76-0','1','1.800','1.790','1','1.800','1.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-76-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-76-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-77-0','1','2.410','2.410','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-77-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-77-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-77-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-77-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-77-0','1','2.410','2.400','1','2.410','2.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-77-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-77-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-78-0','1','1.910','1.910','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-78-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-78-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-78-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-78-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-78-0','1','1.910','1.900','1','1.910','1.900','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-78-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-78-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-79-0','1','1.430','1.430','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-79-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-79-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-79-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-79-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-79-0','1','1.430','1.420','1','1.430','1.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-79-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-79-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-80-0','1','1.300','1.300','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-80-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-80-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-80-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-80-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-80-0','1','1.300','1.290','1','1.300','1.290','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-80-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-80-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-81-0','1','1.370','1.370','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-81-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-81-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-81-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-81-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-81-0','1','1.370','1.360','1','1.370','1.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-81-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-81-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-82-0','1','1.370','1.370','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-82-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-82-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-82-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-82-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-82-0','1','1.370','1.360','1','1.370','1.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-82-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-82-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-83-0','1','1.380','1.380','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-83-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-83-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-83-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-83-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-83-0','1','1.380','1.370','1','1.380','1.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-83-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-83-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-84-0','1','1.520','1.520','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-84-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-84-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-84-0','1','1.520','1.510','1','1.520','1.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-84-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-85-0','1','1.600','1.600','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-85-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-85-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-85-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-85-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-85-0','1','1.600','1.590','1','1.600','1.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-85-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-85-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-86-0','1','1.150','1.150','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-86-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-86-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-86-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-86-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-86-0','1','1.150','1.140','1','1.150','1.140','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-86-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-86-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-87-0','1','1.060','1.060','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-87-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-87-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-87-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-87-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-87-0','1','1.060','1.050','1','1.060','1.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-87-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-87-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-88-0','1','1.460','1.460','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-88-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-88-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-88-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-88-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-88-0','1','1.460','1.450','1','1.460','1.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-88-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-88-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-89-0','1','1.680','1.680','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-89-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-89-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-89-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-89-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-89-0','1','1.680','1.670','1','1.680','1.670','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-89-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-89-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-90-0','1','1.480','1.480','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-90-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-90-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-90-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-90-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-90-0','1','1.480','1.470','1','1.480','1.470','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-90-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-90-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-91-0','1','1.510','1.510','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-91-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-91-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-91-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-91-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-91-0','1','1.510','1.500','1','1.510','1.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-91-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-91-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-92-0','1','1.320','1.320','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-92-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-92-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-92-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-92-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-92-0','1','1.320','1.310','1','1.320','1.310','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-92-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-92-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-93-0','1','1.120','1.120','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-93-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-93-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-93-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-93-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-93-0','1','1.120','1.110','1','1.120','1.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-93-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-93-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-94-0','1','1.240','1.240','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-94-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-94-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-94-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-94-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-94-0','1','1.240','1.230','1','1.240','1.230','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-94-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-94-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-95-0','1','1.450','1.450','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-95-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-95-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-95-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-95-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-95-0','1','1.450','1.440','1','1.450','1.440','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-95-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-95-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-96-0','1','1.460','1.460','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-96-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-96-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-96-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-96-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-96-0','1','1.460','1.450','1','1.460','1.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-96-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-96-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-97-0','1','1.440','1.440','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-97-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-97-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-97-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-97-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-97-0','1','1.440','1.430','1','1.440','1.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-97-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-97-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-98-0','1','1.460','1.460','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-98-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-98-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-98-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-98-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-98-0','1','1.460','1.450','1','1.460','1.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-98-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-98-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-99-0','1','1.350','1.350','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-99-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-99-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-99-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-99-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-99-0','1','1.350','1.340','1','1.350','1.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-99-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-99-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261008-0001','1','MTGW-ZJXF-100-0','1','1.120','1.120','TOKO','BKGWMT','TOKO','BTGWMT'); DELETE FROM tm_barang WHERE kode_barang='MTGW-ZJXF-100-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-100-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-10-08 09:07:02' WHERE kode_barang='MTGW-ZJXF-100-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZJXF-100-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-08 09:07:02','TOKO','BTGWMT','MTGW','MTGW-ZJXF-100-0','1','1.120','1.110','1','1.120','1.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZJXF-100-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZJXF-100-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261008-0001','2026-10-08','09:06','63.060','cashier1','2026-10-08 09:07:01'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','09:08:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-08 ','11:20:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','13:13:51'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0001','sales','1',' ','TOKO','BTATMT','MTAT-ZEBI-60-0','AT ANAK COR CAT BT SHB ','','1.120','1','100.00','2061000','0','0','0','2061000','0','0','0','2061000','2106','00029770','MTAT','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZEBI-60-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MTAT-ZEBI-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0001','2026-10-08','1.120','2026-10-08','13:22:04','PLG0019562','2061000','2061000','0','2061000','2061000','sales','2026-10-08 13:22:02','FJ-261008-0001'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0001','2026-10-08','13:22:04','2106','2061000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261008-0003','D','2026-10-08','13:22:04','sales','PENJUALAN','FJ-261008-0001','122266586','2061000','124327586'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0002','sales','1',' EX ','TOKO','BTKLMT','MTKL-ZCAD-19-0','KL SAPPHIRE PLS 44CM KKT S LL ','','4.080','1','100.00','7507500','0','0','0','7507500','0','0','0','7507500','2105','00029003','MTKL','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-ZCAD-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.080',berat_jual_asli=berat_jual_asli+'4.080',stock_jual='1',berat_akhir=berat_akhir-'4.080',berat_akhir_asli=berat_akhir_asli-'4.080',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MTKL-ZCAD-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0002','2026-10-08','4.080','2026-10-08','14:39:33','PLG0019563','7507500','7507500','0','7507500','7507500','sales','2026-10-08 14:39:32','FJ-261008-0002'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0002','2026-10-08','14:39:33','2105','7507500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0004','D','2026-10-08','14:39:33','sales','PENJUALAN','FJ-261008-0002','124327586','7507500','131835086','OPEN'); UPDATE tt_jual_head SET dibayar_rp='7507500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0002' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0003','sales',' 1',' ','TOKO','BTLTMT','MTLT-ZFXH-116-0','LT COR BT SLP SHB ','','1.180','1','100.00','2171500','0','0','0','2171500','0','0','0','2171500','2105','00030151','MTLT','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTLT-ZFXH-116-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MTLT-ZFXH-116-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0003','2026-10-08','1.180','2026-10-08','14:39:33','PLG0019564','2171500','2171500','0','2171500','2171500','sales','2026-10-08 14:39:32','FJ-261008-0002'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0003','2026-10-08','14:39:33','2105','2171500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0005','D','2026-10-08','14:39:33','sales','PENJUALAN','FJ-261008-0003','131835086','2171500','134006586','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2171500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-08 ','14:41:26'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0003'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0004','sales','1',' ','TOKO','BTGLMD','MDGL-ZJXB-5-0','GL RANGKAIAN VAR PAJERO PRMD 18CM KKT PER SHB ','','3.110','1','100.00','3452500','0','0','0','3452500','0','0','0','3452500','2105','00031532','MDGL','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZJXB-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MDGL-ZJXB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0004','2026-10-08','3.110','2026-10-08','14:46:05','PLG0019565','3452500','3452500','0','3452500','3452500','sales','2026-10-08 14:46:05','FJ-261008-0004'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0004','2026-10-08','14:46:05','2105','3452500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0006','D','2026-10-08','14:46:05','sales','PENJUALAN','FJ-261008-0004','134006586','3452500','137459086','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3452500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0004' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0005','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZIAH-29-0','CN COR BT SHB ','','1.020','1','100.00','1132500','0','0','0','1132500','0','0','0','1132500','2105','00031466','MDCN','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZIAH-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MDCN-ZIAH-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0005','2026-10-08','1.020','2026-10-08','14:46:05','PLG0019566','1132500','1132500','0','1132500','1132500','sales','2026-10-08 14:46:05','FJ-261008-0004'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0005','2026-10-08','14:46:05','2105','1132500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0007','D','2026-10-08','14:46:05','sales','PENJUALAN','FJ-261008-0005','137459086','1132500','138591586','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1132500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0005' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0006','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZCBG-8-0','CN COR TDK BT LC2 ','','1.580','1','100.00','1754000','0','0','0','1754000','0','0','0','1754000','2106','00029024','MDCN','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZCBG-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MDCN-ZCBG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0006','2026-10-08','1.580','2026-10-08','14:48:29','PLG0019567','1754000','1754000','0','1754000','1754000','sales','2026-10-08 14:48:29','FJ-261008-0006'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0006','2026-10-08','14:48:29','2106','1754000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0008','D','2026-10-08','14:48:29','sales','PENJUALAN','FJ-261008-0006','138591586','1754000','140345586','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1754000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0006' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261008-0007','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZEAI-38-0','CN PLINTIR SUSUN SHB ','','1.340','1','100.00','1487500','0','0','0','1487500','0','0','0','1487500','2106','00029680','MDCN','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAI-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-10-08' AND kode_barang='MDCN-ZEAI-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261008-0007','2026-10-08','1.340','2026-10-08','14:48:29','PLG0019568','1487500','1487500','0','1487500','1487500','sales','2026-10-08 14:48:29','FJ-261008-0006'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-08','FJ-261008-0007','2026-10-08','14:48:29','2106','1487500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261008-0009','D','2026-10-08','14:48:29','sales','PENJUALAN','FJ-261008-0007','140345586','1487500','141833086','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1487500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261008-0007' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261008-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261008-0007'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-08 ','15:35:04');