INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','08:36:30'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-17','117','0','-185900000','117','0','-185900000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-16'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-16'; 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-16' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-16'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-16'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-16'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-16'; 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-17' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-16' 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-261017-0001','D','2026-10-17','08:36:38','BCA','SALDO AWAL','SALDO AWAL','0','1375292082','1375292082'); 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-261017-0001','D','2026-10-17','08:36:38','','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-17'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','08:36:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-17 ','08:48:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-17 ','09:03:40'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009931','X-00009931','AT TUSUK ITALY BL SLP','GR','---','MTAT','BELI','BELI001','1780500','2026-10-17','1.100','1','sales','2026-10-17 09:04:25'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009931','X-00009931'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0001','FJ-260704-0001','2402','1','BELI','BELI001','MTAT', 'X-00009931', 'AT TUSUK ITALY BL SLP','1.100','1.100','100.00','2035000','1780500','1618636','1','1780500','1780500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0001','2026-10-17','2026-10-17','09:04:25','2402','---','1.100','1780500','1780500','1780500','1780500','1780500','sales','2026-10-17 09:04:25','FB-261017-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0001','FITRI','KEDUNGMANGU TIMUR','','','','sales','2026-10-17 09:04:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0002','K','2026-10-17','09:04:25','sales','PEMBELIAN UMUM','FB-261017-0001','160783086','1780500','159002586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0001'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009932','X-00009932','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','696500','2026-10-17','0.730','1','sales','2026-10-17 09:42:19'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009932','X-00009932'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0002','FJ-260319-0001','2502','1','BELI','BELI001','MDCN', 'X-00009932', 'CN COR TDK BT SHB','0.730','0.730','100.00','916500','696500','954110','1','696500','696500','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-10-17','BELI','BELI001','MDCN','MDCN','100.00','0.730','0.730','1','0.730','0.730','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0002','2026-10-17','2026-10-17','09:42:19','2502','---','0.730','696500','696500','696500','696500','696500','sales','2026-10-17 09:42:19','FB-261017-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0002','NUR HALIMAH','SIDODADI 9','','','','sales','2026-10-17 09:42:19'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0003','K','2026-10-17','09:42:19','sales','PEMBELIAN UMUM','FB-261017-0002','159002586','696500','158306086','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-17 ','11:05:06'); 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-261017-0001','1','X-00009926','BELI','BELI001','GL FANCY DB MN7 17CM KKT S SHB','1','9.930','16076500.00' ,'0.00','16076500','','16076500','16076500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-17 11:05:23' WHERE kode_barang='X-00009926' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009926' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009926' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'9.930',berat_hancur_asli=berat_hancur_asli+'9.930', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'9.930',berat_akhir_asli=berat_akhir_asli-'9.930' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-261017-0001','2','X-00009927','BELI','BELI001','AT ITALY TDK BT SHB','1','1.380','1973000.00' ,'0.00','1973000','','1973000','34126000','RONGSOK'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-17 11:05:23' WHERE kode_barang='X-00009927' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009927' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009927' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.380',berat_hancur_asli=berat_hancur_asli+'1.380', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380' 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-261017-0001','3','X-00009928','BELI','BELI001','KL VALENTINE 42CM KKT S SHB','1','3.000','4290000.00' ,'0.00','4290000','','4290000','40389000','RONGSOK'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-17 11:05:23' WHERE kode_barang='X-00009928' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009928' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009928' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.000',berat_hancur_asli=berat_hancur_asli+'3.000', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' 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-261017-0001','4','X-00009929','BELI','BELI001','LT COR DOLLAR LC2','1','1.200','1145000.00' ,'0.00','1145000','','1145000','45824000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-17 11:05:23' WHERE kode_barang='X-00009929' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009929' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009929' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.200',berat_hancur_asli=berat_hancur_asli+'1.200', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200' 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-261017-0001','5','X-00009930','BELI','BELI001','AT ANAK COR CAT BT SHB','1','1.120','1813000.00' ,'0.00','1813000','','1813000','48782000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-17 11:05:23' WHERE kode_barang='X-00009930' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009930' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009930' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.120',berat_hancur_asli=berat_hancur_asli+'1.120', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-261017-0001','adminpusat','2026-10-17','2026-10-17','11:05:23','25297500','48782000', 'adminpusat','2026-10-17 11:05:23'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009933','X-00009933','AT ITALY KUPU BT SHB','GR','---','MDAT','BELI','BELI001','819000','2026-10-17','1.170','1','sales','2026-10-17 11:29:52'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009933','X-00009933'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0003','FJ-260117-0001','2103','1','BELI','BELI001','MDAT', 'X-00009933', 'AT ITALY KUPU BT SHB','1.270','1.170','100.00','1410000','819000','700000','1','819000','819000','RUSAK ADA HILANG'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-10-17','BELI','BELI001','MDAT','MDAT','100.00','1.170','1.170','1','1.170','1.170','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0003','2026-10-17','2026-10-17','11:29:52','2103','---','1.170','819000','819000','819000','819000','819000','sales','2026-10-17 11:29:52','FB-261017-0003','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0003','MIGA','WONOSARI 1/12-B','','','082338391473','sales','2026-10-17 11:29:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0004','K','2026-10-17','11:29:52','sales','PEMBELIAN UMUM','FB-261017-0003','158306086','819000','157487086','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','11:30:55'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-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-261017-0001','sales','1',' ','TOKO','BTGLMT','MTGL-ZJXB-11-0','GL VANESSA VAR 18CM KKT PER SHB ','','3.650','1','100.00','6716000','0','0','0','6716000','0','0','0','6716000','2502','00031538','MTGL','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZJXB-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.650',berat_jual_asli=berat_jual_asli+'3.650',stock_jual='1',berat_akhir=berat_akhir-'3.650',berat_akhir_asli=berat_akhir_asli-'3.650',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='MTGL-ZJXB-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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-261017-0001','2026-10-17','3.650','2026-10-17','11:50:28','PLG0019602','6716000','6716000','0','6716000','6716000','sales','2026-10-17 11:50:27','FJ-261017-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-17','FJ-261017-0001','2026-10-17','11:50:28','2502','6716000','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-261017-0005','D','2026-10-17','11:50:28','sales','PENJUALAN','FJ-261017-0001','157487086','6716000','164203086'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','11:54:24'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261017-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261017-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261017-0001'; INSERT INTO tm_credit_card(id_card,nama_customer,no_ktp,alamat1,alamat2,kota,no_telp,tgl_daftar,tgl_valid_until,tgl_last_gesek) VALUES ('5379412176402153','BCA','', ' ' , ' ' , ' ' ,'','2026-10-17 12:03:12','','2026-10-17 12:03:12'); 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-261017-0002','sales','1',' ','TOKO','BTGLMT','MTGL-ZAXI-46-0','GL BANGKOK TMBL SHB ','','5.260','1','100.00','9678500','0','0','0','9678500','0','0','0','9678500','2402','00027333','MTGL','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZAXI-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.260',berat_jual_asli=berat_jual_asli+'5.260',stock_jual='1',berat_akhir=berat_akhir-'5.260',berat_akhir_asli=berat_akhir_asli-'5.260',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='MTGL-ZAXI-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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-261017-0002','2026-10-17','5.260','2026-10-17','12:03:34','PLG0019603','9678500','9678500','0','9678500','9328500','sales','2026-10-17 12:03:32','FJ-261017-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-17','FJ-261017-0002','2026-10-17','12:03:34','2402','9678500','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-261017-0006','D','2026-10-17','12:03:34','sales','PENJUALAN','FJ-261017-0002','164203086','9328500','173531586','OPEN'); INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-261017-0001','2026-10-17','2026-10-17 12:03:32','PENJUALAN : FJ-261017-0002','5379412176402153','BCA','350000','350000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261017-0002','D','2026-10-17','12:03:34','BCA','PENJUALAN','FJ-261017-0002','1375292082','350000','1375642082','DEBET'); UPDATE tt_jual_head SET dibayar_rp='9328500',debet_rp='350000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261017-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261017-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261017-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261017-0002'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009934','X-00009934','GW CAP TDK BT LC2','GR','---','MDGW','BELI','BELI001','897000','2026-10-17','0.940','1','sales','2026-10-17 12:18:08'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGW'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGW','X-00009934','X-00009934'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0004','FJ-260627-0005','2103','1','BELI','BELI001','MDGW', 'X-00009934', 'GW CAP TDK BT LC2','0.940','0.940','100.00','1048500','897000','954255','1','897000','897000','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-10-17','BELI','BELI001','MDGW','MDGW','100.00','0.940','0.940','1','0.940','0.940','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0004','2026-10-17','2026-10-17','12:18:08','2103','---','0.940','897000','897000','897000','897000','897000','sales','2026-10-17 12:18:08','FB-261017-0004','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0004','VIRA','SIDOTOPO LOR 7A','','','','sales','2026-10-17 12:18:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0007','K','2026-10-17','12:18:08','sales','PEMBELIAN UMUM','FB-261017-0004','173531586','897000','172634586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0004'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-17 ','13:01:39'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009935','X-00009935','AT CAP KAWAT BTR BT SHB','GR','---','MDAT','BELI','BELI001','1477000','2026-10-17','1.800','1','sales','2026-10-17 13:35:50'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009935','X-00009935'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0005','FJ-251127-0004','2403','1','BELI','BELI001','MDAT', 'X-00009935', 'AT CAP KAWAT BTR BT SHB','1.800','1.800','100.00','1809000','1477000','820556','1','1477000','1477000','RUSAK BIASA'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.800',berat_beli_asli=berat_beli_asli+'1.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.800',berat_akhir_asli=berat_akhir_asli+'1.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0005','2026-10-17','2026-10-17','13:35:50','2403','---','1.800','1477000','1477000','1477000','1477000','1477000','sales','2026-10-17 13:35:50','FB-261017-0005','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0005','SILVI','TMBK SEGARAN WTN 1/108','','','081803222924','sales','2026-10-17 13:35:50'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0008','K','2026-10-17','13:35:50','sales','PEMBELIAN UMUM','FB-261017-0005','172634586','1477000','171157586','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','13:36:52'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0005'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009936','X-00009936','CN COR EROPA SHB','GR','---','MDCN','BELI','BELI001','4715000','2026-10-17','4.940','1','sales','2026-10-17 13:47:39'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009936','X-00009936'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0006','FJ-260713-0002','2105','1','BELI','BELI001','MDCN', 'X-00009936', 'CN COR EROPA SHB','4.940','4.940','100.00','5459000','4715000','954453','1','4715000','4715000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.940',berat_beli_asli=berat_beli_asli+'4.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.940',berat_akhir_asli=berat_akhir_asli+'4.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0006','2026-10-17','2026-10-17','13:47:38','2105','---','4.940','4715000','4715000','4715000','4715000','4715000','sales','2026-10-17 13:47:39','FB-261017-0006','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0006','SOFIA','JATI PURWO 5/4','','','','sales','2026-10-17 13:47:39'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0009','K','2026-10-17','13:47:38','sales','PEMBELIAN UMUM','FB-261017-0006','171157586','4715000','166442586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0006'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009937','X-00009937','CN COR BT SHB','GR','---','MTCN','BELI','BELI001','7091000','2026-10-17','4.380','1','sales','2026-10-17 14:26:54'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009937','X-00009937'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0007','FJ-260725-0002','2105','1','BELI','BELI001','MTCN', 'X-00009937', 'CN COR BT SHB','4.380','4.380','100.00','8015500','7091000','1618950','1','7091000','7091000','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-10-17','BELI','BELI001','MTCN','MTCN','100.00','4.380','4.380','1','4.380','4.380','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261017-0007','2026-10-17','2026-10-17','14:26:54','2105','---','4.380','7091000','7091000','7091000','7091000','7091000','sales','2026-10-17 14:26:54','FB-261017-0007','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0007','IBU FARHAN','MRUTU KALIANYAR 4/58','','','','sales','2026-10-17 14:26:54'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; 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 ('KK-261017-0010','K','2026-10-17','14:26:54','sales','PEMBELIAN UMUM','FB-261017-0007','166442586','7091000','159351586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0007'; INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01869','2502','1','CN COR PLINTIR SSN T8K','0','1','0','','') UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'1800000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'1800000' WHERE tanggal='2026-10-17' INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01869','2026-10-17','2026-10-17','14:48:01','PLG0019604','2502','90','2027-01-15','sales','2026-10-17 14:48:01','3.710','1800000','3.00','162000','1962000','0','OPEN','14.37','1','2027-01-15','0','1962000') 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 ('KK-261017-0011','K','2026-10-17','14:48:01','sales','HUTANG','PI26-01869','159351586','1800000','157551586','OPEN') UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01869' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01869'; 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-20261017-0001','1','MTGL-ZJAF-1-0','1','10.370','10.370','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-1-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-1-0','1','10.370','10.360','1','10.370','10.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-2-0','1','4.630','4.630','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-2-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-2-0','1','4.630','4.620','1','4.630','4.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-3-0','1','24.360','24.360','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-3-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-3-0','1','24.360','24.350','1','24.360','24.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-4-0','1','2.510','2.510','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-4-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-4-0','1','2.510','2.500','1','2.510','2.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-5-0','1','1.670','1.670','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-5-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-5-0','1','1.670','1.660','1','1.670','1.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-6-0','1','4.830','4.830','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-6-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-6-0','1','4.830','4.820','1','4.830','4.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-7-0','1','2.430','2.430','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-7-0','1','2.430','2.420','1','2.430','2.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-8-0','1','1.970','1.970','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-8-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-8-0','1','1.970','1.960','1','1.970','1.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-9-0','1','2.470','2.470','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-9-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-9-0','1','2.470','2.460','1','2.470','2.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-10-0','1','2.740','2.740','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-10-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-10-0','1','2.740','2.730','1','2.740','2.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-11-0','1','2.000','2.000','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-11-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-11-0','1','2.000','1.990','1','2.000','1.990','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-12-0','1','2.940','2.940','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-12-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-12-0','1','2.940','2.930','1','2.940','2.930','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-13-0','1','2.930','2.930','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-13-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-13-0','1','2.930','2.920','1','2.930','2.920','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-14-0','1','3.330','3.330','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-14-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-14-0','1','3.330','3.320','1','3.330','3.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-15-0','1','2.250','2.250','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-15-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-15-0','1','2.250','2.240','1','2.250','2.240','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-16-0','1','2.210','2.210','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-16-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-16-0','1','2.210','2.200','1','2.210','2.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-17-0','1','3.930','3.930','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-17-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-17-0','1','3.930','3.920','1','3.930','3.920','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-18-0','1','3.330','3.330','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-18-0','1','3.330','3.320','1','3.330','3.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-19-0','1','2.380','2.380','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-19-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-19-0','1','2.380','2.370','1','2.380','2.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-20-0','1','5.570','5.570','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-20-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:58' WHERE kode_barang='MTGL-ZJAF-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:58','TOKO','BTGLMT','MTGL','MTGL-ZJAF-20-0','1','5.570','5.560','1','5.570','5.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-21-0','1','3.520','3.520','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-21-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-21-0','1','3.520','3.510','1','3.520','3.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-22-0','1','3.350','3.350','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-22-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-22-0','1','3.350','3.340','1','3.350','3.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-23-0','1','3.170','3.170','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-23-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-23-0','1','3.170','3.160','1','3.170','3.160','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-24-0','1','3.120','3.120','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-24-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-24-0','1','3.120','3.110','1','3.120','3.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-25-0','1','4.510','4.510','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-25-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-25-0','1','4.510','4.500','1','4.510','4.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-26-0','1','5.470','5.470','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-26-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-26-0','1','5.470','5.460','1','5.470','5.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-27-0','1','3.670','3.670','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-27-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-27-0','1','3.670','3.660','1','3.670','3.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-28-0','1','4.330','4.330','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-28-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-28-0','1','4.330','4.320','1','4.330','4.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-29-0','1','4.740','4.740','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-29-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-29-0','1','4.740','4.730','1','4.740','4.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-30-0','1','4.710','4.710','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-30-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-30-0','1','4.710','4.700','1','4.710','4.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-31-0','1','10.490','10.490','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-31-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-31-0','1','10.490','10.480','1','10.490','10.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-32-0','1','5.350','5.350','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-32-0','1','5.350','5.340','1','5.350','5.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-33-0','1','4.520','4.520','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-33-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-33-0','1','4.520','4.510','1','4.520','4.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-34-0','1','2.110','2.110','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-34-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-34-0','1','2.110','2.100','1','2.110','2.100','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-35-0','1','2.130','2.130','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-35-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-35-0','1','2.130','2.120','1','2.130','2.120','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-36-0','1','1.790','1.790','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-36-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-36-0','1','1.790','1.780','1','1.790','1.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-37-0','1','1.510','1.510','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-37-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-37-0','1','1.510','1.500','1','1.510','1.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-38-0','1','1.560','1.560','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-38-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-38-0','1','1.560','1.550','1','1.560','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-39-0','1','1.650','1.650','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-39-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-39-0','1','1.650','1.640','1','1.650','1.640','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-40-0','1','5.050','5.050','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-40-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-40-0','1','5.050','5.040','1','5.050','5.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-41-0','1','5.300','5.300','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-41-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-41-0','1','5.300','5.290','1','5.300','5.290','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-42-0','1','5.360','5.360','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-42-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-42-0','1','5.360','5.350','1','5.360','5.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-43-0','1','5.150','5.150','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-43-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-43-0','1','5.150','5.140','1','5.150','5.140','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-44-0','1','5.240','5.240','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-44-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-44-0','1','5.240','5.230','1','5.240','5.230','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-45-0','1','3.950','3.950','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-45-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-45-0','1','3.950','3.940','1','3.950','3.940','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-46-0','1','5.130','5.130','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-46-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-46-0','1','5.130','5.120','1','5.130','5.120','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-47-0','1','3.430','3.430','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-47-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-47-0','1','3.430','3.420','1','3.430','3.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-48-0','1','4.960','4.960','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-48-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-48-0','1','4.960','4.950','1','4.960','4.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-49-0','1','4.610','4.610','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-49-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-49-0','1','4.610','4.600','1','4.610','4.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-50-0','1','5.000','5.000','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-50-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-50-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-50-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-50-0','1','5.000','4.990','1','5.000','4.990','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-50-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-51-0','1','5.370','5.370','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-51-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-51-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-51-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-51-0','1','5.370','5.360','1','5.370','5.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-51-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-52-0','1','3.640','3.640','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-52-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-52-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-52-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-52-0','1','3.640','3.630','1','3.640','3.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-52-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-53-0','1','3.220','3.220','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-53-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-53-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-53-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-53-0','1','3.220','3.210','1','3.220','3.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-53-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-54-0','1','5.120','5.120','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-54-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-54-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-54-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-54-0','1','5.120','5.110','1','5.120','5.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-54-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-55-0','1','4.260','4.260','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-55-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-55-0','1','4.260','4.250','1','4.260','4.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-56-0','1','4.860','4.860','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-56-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-56-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-56-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-56-0','1','4.860','4.850','1','4.860','4.850','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-56-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-57-0','1','3.970','3.970','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-57-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-57-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-57-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-57-0','1','3.970','3.960','1','3.970','3.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-57-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-58-0','1','3.340','3.340','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-58-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-58-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-58-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-58-0','1','3.340','3.330','1','3.340','3.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-58-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-59-0','1','3.080','3.080','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-59-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-59-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-59-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-59-0','1','3.080','3.070','1','3.080','3.070','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-59-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-59-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-20261017-0001','1','MTGL-ZJAF-60-0','1','4.830','4.830','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-60-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-60-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-60-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-60-0','1','4.830','4.820','1','4.830','4.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-60-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-61-0','1','3.740','3.740','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-61-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-61-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-61-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-61-0','1','3.740','3.730','1','3.740','3.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-61-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-62-0','1','3.550','3.550','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-62-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-62-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-62-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-62-0','1','3.550','3.540','1','3.550','3.540','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-62-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-63-0','1','4.630','4.630','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-63-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-63-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-63-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-63-0','1','4.630','4.620','1','4.630','4.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-63-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-64-0','1','5.430','5.430','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-64-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-64-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-64-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-64-0','1','5.430','5.420','1','5.430','5.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-64-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-65-0','1','4.200','4.200','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-65-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-65-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-65-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-65-0','1','4.200','4.190','1','4.200','4.190','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-65-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-66-0','1','4.610','4.610','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-66-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-66-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-66-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-66-0','1','4.610','4.600','1','4.610','4.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-66-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-67-0','1','3.130','3.130','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-67-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-67-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-67-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-67-0','1','3.130','3.120','1','3.130','3.120','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-67-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-68-0','1','3.120','3.120','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-68-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-68-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-68-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-68-0','1','3.120','3.110','1','3.120','3.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-68-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-69-0','1','2.970','2.970','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-69-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-69-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-69-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-69-0','1','2.970','2.960','1','2.970','2.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-69-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAF-70-0','1','4.050','4.050','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAF-70-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-70-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAF-70-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAF-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAF-70-0','1','4.050','4.040','1','4.050','4.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAF-70-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAF-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-20261017-0001','1','MTGL-ZJAG-1-0','1','5.100','5.100','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-1-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-1-0','1','5.100','5.090','1','5.100','5.090','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-2-0','1','3.830','3.830','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-2-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-2-0','1','3.830','3.820','1','3.830','3.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-3-0','1','4.120','4.120','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-3-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-3-0','1','4.120','4.110','1','4.120','4.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-4-0','1','4.330','4.330','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-4-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-4-0','1','4.330','4.320','1','4.330','4.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-5-0','1','5.620','5.620','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-5-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-5-0','1','5.620','5.610','1','5.620','5.610','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-6-0','1','8.360','8.360','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-6-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-6-0','1','8.360','8.350','1','8.360','8.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-7-0','1','4.880','4.880','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-7-0','1','4.880','4.870','1','4.880','4.870','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-8-0','1','5.220','5.220','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-8-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-8-0','1','5.220','5.210','1','5.220','5.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-9-0','1','4.720','4.720','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-9-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-9-0','1','4.720','4.710','1','4.720','4.710','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-10-0','1','4.770','4.770','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-10-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-10-0','1','4.770','4.760','1','4.770','4.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-11-0','1','3.460','3.460','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-11-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-11-0','1','3.460','3.450','1','3.460','3.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-12-0','1','3.080','3.080','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-12-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-12-0','1','3.080','3.070','1','3.080','3.070','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-13-0','1','3.040','3.040','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-13-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-13-0','1','3.040','3.030','1','3.040','3.030','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-14-0','1','4.670','4.670','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-14-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-14-0','1','4.670','4.660','1','4.670','4.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-15-0','1','3.010','3.010','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-15-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-15-0','1','3.010','3.000','1','3.010','3.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-16-0','1','1.700','1.700','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-16-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-16-0','1','1.700','1.690','1','1.700','1.690','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-17-0','1','2.580','2.580','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-17-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-17-0','1','2.580','2.570','1','2.580','2.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-18-0','1','2.180','2.180','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-18-0','1','2.180','2.170','1','2.180','2.170','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-19-0','1','3.430','3.430','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-19-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-19-0','1','3.430','3.420','1','3.430','3.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-20-0','1','4.610','4.610','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-20-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-20-0','1','4.610','4.600','1','4.610','4.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-21-0','1','4.730','4.730','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-21-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-21-0','1','4.730','4.720','1','4.730','4.720','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-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-20261017-0001','1','MTGL-ZJAG-22-0','1','5.220','5.220','TOKO','BKGLMT','TOKO','BTGLMT'); DELETE FROM tm_barang WHERE kode_barang='MTGL-ZJAG-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-22-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-10-17 15:31:59' WHERE kode_barang='MTGL-ZJAG-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZJAG-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-17 15:31:59','TOKO','BTGLMT','MTGL','MTGL-ZJAG-22-0','1','5.220','5.210','1','5.220','5.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZJAG-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAG-22-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261017-0001','2026-10-17','15:31','387.510','cashier1','2026-10-17 15:31:59'); INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01819','2026-10-17', '2026-10-17','87000','87000','87000'); UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'87000' WHERE no_hutang='PI26-01819'; 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-261017-0012','D','2026-10-17','15:52:03','cashier1','HUTANG BUNGA','PI26-01819','157551586','87000','157638586'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-17 ','15:58:41'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-17 ','16:04:08');