INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','08:04:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-17 ','08:34:14');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-17','131','0','-129750000','131','0','-129750000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-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-07-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-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-260717-0001','D','2026-07-17','08:34:26','BCA','SALDO AWAL','SALDO AWAL','0','1885905755','1885905755');
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-260717-0001','D','2026-07-17','08:34:26','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-17 ','08:36:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','08:36:58');
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-260717-0001','1','X-00009650','BELI','BELI001','GL BABY PLINTIR TALI AIR SHB','1','1.480','1406000.00' ,'0.00','1406000','','1406000','1406000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-17 08:38:35' WHERE kode_barang='X-00009650' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009650' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009650' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.480',berat_hancur_asli=berat_hancur_asli+'1.480', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260717-0001','2','X-00009651','BELI','BELI001','LT HELLO KITTY MT AD PENUH MRH 3 HTM 3','1','1.200','1740000.00' ,'0.00','1740000','','1740000','4552000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-17 08:38:35' WHERE kode_barang='X-00009651' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009651' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009651' 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='MTLT' 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-260717-0001','3','X-00009652','BELI','BELI001','CN COR BT SHB','1','0.800','760000.00' ,'0.00','760000','','760000','7052000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-17 08:38:35' WHERE kode_barang='X-00009652' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009652' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009652' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.800',berat_hancur_asli=berat_hancur_asli+'0.800', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260717-0001','4','X-00009653','BELI','BELI001','GL PAJERO 17CM KKT PER SHB','1','2.820','2679000.00' ,'0.00','2679000','','2679000','10491000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-17 08:38:35' WHERE kode_barang='X-00009653' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009653' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009653' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.820',berat_hancur_asli=berat_hancur_asli+'2.820', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260717-0001','adminpusat','2026-07-17','2026-07-17','08:38:35','6585000','10491000', 'adminpusat','2026-07-17 08:38:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-17 ','08:45:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','08:52:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','09:03:14');
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-20260717-0001','1','MDAT-ZGAE-36-0','1','0.930','0.930','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-36-0','1','0.930','0.920','1','0.930','0.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-37-0','1','1.260','1.260','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-37-0','1','1.260','1.250','1','1.260','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-38-0','1','0.900','0.900','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-38-0','1','0.900','0.890','1','0.900','0.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-39-0','1','1.020','1.020','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-39-0','1','1.020','1.010','1','1.020','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-40-0','1','1.280','1.280','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-40-0','1','1.280','1.270','1','1.280','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-41-0','1','1.450','1.450','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-41-0','1','1.450','1.440','1','1.450','1.440','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-42-0','1','2.480','2.480','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-42-0','1','2.480','2.470','1','2.480','2.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-43-0','1','1.220','1.220','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-43-0','1','1.220','1.210','1','1.220','1.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-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-20260717-0001','1','MDAT-ZGAE-44-0','1','0.420','0.420','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZGAE-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-07-17 09:27:02' WHERE kode_barang='MDAT-ZGAE-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZGAE-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-07-17 09:27:02','TOKO','BTATMD','MDAT','MDAT-ZGAE-44-0','1','0.420','0.410','1','0.420','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZGAE-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZGAE-44-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:26','10.960','cashier1','2026-07-17 09:27:02');
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-20260717-0001','1','MDCN-ZGAE-45-0','1','1.000','1.000','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-45-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-46-0','1','2.430','2.430','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-46-0','1','2.430','2.420','1','2.430','2.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-47-0','1','1.420','1.420','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-47-0','1','1.420','1.410','1','1.420','1.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-48-0','1','2.030','2.030','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-48-0','1','2.030','2.020','1','2.030','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-49-0','1','1.150','1.150','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-49-0','1','1.150','1.140','1','1.150','1.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-50-0','1','1.100','1.100','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-50-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-51-0','1','0.850','0.850','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-51-0','1','0.850','0.840','1','0.850','0.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-52-0','1','1.400','1.400','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-52-0','1','1.400','1.390','1','1.400','1.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-53-0','1','1.020','1.020','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-53-0','1','1.020','1.010','1','1.020','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-54-0','1','0.860','0.860','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-54-0','1','0.860','0.850','1','0.860','0.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-55-0','1','0.780','0.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-55-0','1','0.780','0.770','1','0.780','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-56-0','1','1.390','1.390','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-56-0','1','1.390','1.380','1','1.390','1.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-57-0','1','1.210','1.210','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-57-0','1','1.210','1.200','1','1.210','1.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-58-0','1','1.950','1.950','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-58-0','1','1.950','1.940','1','1.950','1.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-59-0','1','0.780','0.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-59-0','1','0.780','0.770','1','0.780','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-60-0','1','0.900','0.900','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-60-0','1','0.900','0.890','1','0.900','0.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-61-0','1','2.660','2.660','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-61-0','1','2.660','2.650','1','2.660','2.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-62-0','1','2.600','2.600','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-62-0','1','2.600','2.590','1','2.600','2.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-63-0','1','1.180','1.180','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-63-0','1','1.180','1.170','1','1.180','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-64-0','1','0.780','0.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-64-0','1','0.780','0.770','1','0.780','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-65-0','1','0.760','0.760','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-65-0','1','0.760','0.750','1','0.760','0.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-66-0','1','1.930','1.930','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-66-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-66-0','1','1.930','1.920','1','1.930','1.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-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-20260717-0001','1','MDCN-ZGAE-67-0','1','1.460','1.460','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZGAE-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-07-17 09:27:43' WHERE kode_barang='MDCN-ZGAE-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZGAE-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-07-17 09:27:43','TOKO','BTCNMD','MDCN','MDCN-ZGAE-67-0','1','1.460','1.450','1','1.460','1.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZGAE-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZGAE-67-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:27','31.640','cashier1','2026-07-17 09:27:43');
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-20260717-0001','1','MDGL-ZGAE-68-0','1','5.740','5.740','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-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-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-68-0','1','5.740','5.730','1','5.740','5.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-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-20260717-0001','1','MDGL-ZGAE-69-0','1','7.240','7.240','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-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-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-69-0','1','7.240','7.230','1','7.240','7.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-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-20260717-0001','1','MDGL-ZGAE-70-0','1','5.260','5.260','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-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-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-70-0','1','5.260','5.250','1','5.260','5.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-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-20260717-0001','1','MDGL-ZGAE-71-0','1','3.880','3.880','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-71-0','1','3.880','3.870','1','3.880','3.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-71-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-72-0','1','5.030','5.030','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-72-0','1','5.030','5.020','1','5.030','5.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-72-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-73-0','1','4.830','4.830','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-73-0','1','4.830','4.820','1','4.830','4.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-74-0','1','8.000','8.000','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-74-0','1','8.000','7.990','1','8.000','7.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-75-0','1','6.360','6.360','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-75-0','1','6.360','6.350','1','6.360','6.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-75-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-76-0','1','5.590','5.590','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-76-0','1','5.590','5.580','1','5.590','5.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-76-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGL-ZGAE-77-0','1','4.010','4.010','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZGAE-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-07-17 09:28:20' WHERE kode_barang='MDGL-ZGAE-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZGAE-77-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:20','TOKO','BTGLMD','MDGL','MDGL-ZGAE-77-0','1','4.010','4.000','1','4.010','4.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZGAE-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZGAE-77-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:27','55.940','cashier1','2026-07-17 09:28:20');
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-20260717-0001','1','MDGW-ZGAE-78-0','1','0.750','0.750','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZGAE-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZGAE-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-07-17 09:28:59' WHERE kode_barang='MDGW-ZGAE-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZGAE-78-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:59','TOKO','BTGWMD','MDGW','MDGW-ZGAE-78-0','1','0.750','0.740','1','0.750','0.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGW-ZGAE-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZGAE-78-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDGW-ZGAE-79-0','1','0.630','0.630','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZGAE-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZGAE-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-07-17 09:28:59' WHERE kode_barang='MDGW-ZGAE-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZGAE-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:28:59','TOKO','BTGWMD','MDGW','MDGW-ZGAE-79-0','1','0.630','0.620','1','0.630','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGW-ZGAE-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZGAE-79-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:28','1.380','cashier1','2026-07-17 09:28:59');
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-20260717-0001','1','MTAT-ZGAE-1-0','1','0.500','0.500','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-1-0','1','0.500','0.490','1','0.500','0.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-2-0','1','0.560','0.560','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-2-0','1','0.560','0.550','1','0.560','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-3-0','1','2.280','2.280','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-3-0','1','2.280','2.270','1','2.280','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-4-0','1','1.710','1.710','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-4-0','1','1.710','1.700','1','1.710','1.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-5-0','1','1.010','1.010','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-5-0','1','1.010','1.000','1','1.010','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-6-0','1','0.510','0.510','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-6-0','1','0.510','0.500','1','0.510','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-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-20260717-0001','1','MTAT-ZGAE-7-0','1','0.500','0.500','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZGAE-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-07-17 09:29:27' WHERE kode_barang='MTAT-ZGAE-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZGAE-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-07-17 09:29:27','TOKO','BTATMT','MTAT','MTAT-ZGAE-7-0','1','0.500','0.490','1','0.500','0.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZGAE-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZGAE-7-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:29','7.070','cashier1','2026-07-17 09:29:27');
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-20260717-0001','1','MTCN-ZGAE-8-0','1','1.380','1.380','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-8-0','1','1.380','1.370','1','1.380','1.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-9-0','1','5.530','5.530','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-9-0','1','5.530','5.520','1','5.530','5.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-10-0','1','4.560','4.560','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-10-0','1','4.560','4.550','1','4.560','4.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-11-0','1','3.160','3.160','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-11-0','1','3.160','3.150','1','3.160','3.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-12-0','1','1.230','1.230','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-12-0','1','1.230','1.220','1','1.230','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-13-0','1','1.220','1.220','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-13-0','1','1.220','1.210','1','1.220','1.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-14-0','1','1.000','1.000','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-14-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-15-0','1','1.030','1.030','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-15-0','1','1.030','1.020','1','1.030','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-16-0','1','1.490','1.490','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-16-0','1','1.490','1.480','1','1.490','1.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-17-0','1','1.880','1.880','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-17-0','1','1.880','1.870','1','1.880','1.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-18-0','1','0.910','0.910','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-18-0','1','0.910','0.900','1','0.910','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-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-20260717-0001','1','MTCN-ZGAE-19-0','1','2.940','2.940','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZGAE-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-07-17 09:30:02' WHERE kode_barang='MTCN-ZGAE-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZGAE-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-07-17 09:30:02','TOKO','BTCNMT','MTCN','MTCN-ZGAE-19-0','1','2.940','2.930','1','2.940','2.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZGAE-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZGAE-19-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:29','26.330','cashier1','2026-07-17 09:30:01');
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-20260717-0001','1','MTGL-ZGAE-20-0','1','3.650','3.650','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-20-0','1','3.650','3.640','1','3.650','3.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-ZGAE-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-21-0','1','2.980','2.980','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-21-0','1','2.980','2.970','1','2.980','2.970','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-ZGAE-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-22-0','1','1.870','1.870','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-22-0','1','1.870','1.860','1','1.870','1.860','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-ZGAE-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-23-0','1','4.650','4.650','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-23-0','1','4.650','4.640','1','4.650','4.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-ZGAE-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-24-0','1','3.350','3.350','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-24-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-ZGAE-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-25-0','1','1.910','1.910','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-25-0','1','1.910','1.900','1','1.910','1.900','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-ZGAE-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-26-0','1','4.960','4.960','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-26-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-ZGAE-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-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-20260717-0001','1','MTGL-ZGAE-27-0','1','8.140','8.140','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZGAE-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-07-17 09:30:28' WHERE kode_barang='MTGL-ZGAE-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZGAE-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-07-17 09:30:28','TOKO','BTGLMT','MTGL','MTGL-ZGAE-27-0','1','8.140','8.130','1','8.140','8.130','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-ZGAE-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZGAE-27-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:30','31.510','cashier1','2026-07-17 09:30:28');
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-20260717-0001','1','MTGW-ZGAE-28-0','1','1.300','1.300','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZGAE-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-07-17 09:30:52' WHERE kode_barang='MTGW-ZGAE-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZGAE-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-07-17 09:30:52','TOKO','BTGWMT','MTGW','MTGW-ZGAE-28-0','1','1.300','1.290','1','1.300','1.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZGAE-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-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-20260717-0001','1','MTGW-ZGAE-29-0','1','0.510','0.510','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZGAE-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-07-17 09:30:52' WHERE kode_barang='MTGW-ZGAE-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZGAE-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-07-17 09:30:52','TOKO','BTGWMT','MTGW','MTGW-ZGAE-29-0','1','0.510','0.500','1','0.510','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZGAE-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-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-20260717-0001','1','MTGW-ZGAE-30-0','1','0.950','0.950','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZGAE-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-07-17 09:30:52' WHERE kode_barang='MTGW-ZGAE-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZGAE-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-07-17 09:30:52','TOKO','BTGWMT','MTGW','MTGW-ZGAE-30-0','1','0.950','0.940','1','0.950','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZGAE-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZGAE-30-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:30','2.760','cashier1','2026-07-17 09:30:51');
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-20260717-0001','1','MTKL-ZGAE-31-0','1','4.600','4.600','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZGAE-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-07-17 09:31:52' WHERE kode_barang='MTKL-ZGAE-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZGAE-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-07-17 09:31:52','TOKO','BTKLMT','MTKL','MTKL-ZGAE-31-0','1','4.600','4.590','1','4.600','4.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZGAE-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-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-20260717-0001','1','MTKL-ZGAE-32-0','1','9.930','9.930','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZGAE-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-07-17 09:31:52' WHERE kode_barang='MTKL-ZGAE-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZGAE-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-07-17 09:31:52','TOKO','BTKLMT','MTKL','MTKL-ZGAE-32-0','1','9.930','9.920','1','9.930','9.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZGAE-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-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-20260717-0001','1','MTKL-ZGAE-33-0','1','4.010','4.010','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZGAE-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-07-17 09:31:52' WHERE kode_barang='MTKL-ZGAE-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZGAE-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-07-17 09:31:52','TOKO','BTKLMT','MTKL','MTKL-ZGAE-33-0','1','4.010','4.000','1','4.010','4.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZGAE-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZGAE-33-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:30','18.540','cashier1','2026-07-17 09:31:52');
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-20260717-0001','1','MDKL-ZGAE-80-0','1','10.250','10.250','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-80-0','1','10.250','10.240','1','10.250','10.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-80-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDKL-ZGAE-81-0','1','3.730','3.730','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-81-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-81-0','1','3.730','3.720','1','3.730','3.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-81-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDKL-ZGAE-82-0','1','3.010','3.010','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-82-0','1','3.010','3.000','1','3.010','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-82-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDKL-ZGAE-83-0','1','2.350','2.350','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-83-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-83-0','1','2.350','2.340','1','2.350','2.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-83-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDKL-ZGAE-84-0','1','1.980','1.980','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-84-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-84-0','1','1.980','1.970','1','1.980','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-84-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDKL-ZGAE-85-0','1','1.860','1.860','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZGAE-85-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-85-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-07-17 09:32:51' WHERE kode_barang='MDKL-ZGAE-85-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZGAE-85-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:32:51','TOKO','BTKLMD','MDKL','MDKL-ZGAE-85-0','1','1.860','1.850','1','1.860','1.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZGAE-85-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZGAE-85-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:31','23.180','cashier1','2026-07-17 09:32:51');
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-20260717-0001','1','MTLT-ZGAE-34-0','1','0.950','0.950','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZGAE-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZGAE-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-07-17 09:33:15' WHERE kode_barang='MTLT-ZGAE-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZGAE-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-07-17 09:33:15','TOKO','BTLTMT','MTLT','MTLT-ZGAE-34-0','1','0.950','0.940','1','0.950','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZGAE-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZGAE-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-20260717-0001','1','MTLT-ZGAE-35-0','1','0.780','0.780','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZGAE-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZGAE-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-07-17 09:33:15' WHERE kode_barang='MTLT-ZGAE-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZGAE-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-07-17 09:33:15','TOKO','BTLTMT','MTLT','MTLT-ZGAE-35-0','1','0.780','0.770','1','0.780','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZGAE-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZGAE-35-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:32','1.730','cashier1','2026-07-17 09:33:15');
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-20260717-0001','1','MDLT-ZGAE-86-0','1','1.200','1.200','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-86-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-86-0','1','1.200','1.190','1','1.200','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-86-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-87-0','1','0.550','0.550','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-87-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-87-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-87-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-87-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-87-0','1','0.550','0.540','1','0.550','0.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-87-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-87-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-88-0','1','0.460','0.460','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-88-0','1','0.460','0.450','1','0.460','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-88-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-89-0','1','0.640','0.640','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-89-0','1','0.640','0.630','1','0.640','0.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-89-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-90-0','1','1.170','1.170','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-90-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-90-0','1','1.170','1.160','1','1.170','1.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-90-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-91-0','1','1.260','1.260','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-91-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-91-0','1','1.260','1.250','1','1.260','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-91-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-92-0','1','0.950','0.950','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-92-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-92-0','1','0.950','0.940','1','0.950','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-92-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-93-0','1','1.840','1.840','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-93-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-93-0','1','1.840','1.830','1','1.840','1.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-93-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-94-0','1','1.200','1.200','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-94-0','1','1.200','1.190','1','1.200','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-94-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260717-0001','1','MDLT-ZGAE-95-0','1','0.520','0.520','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZGAE-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-07-17 09:33:53' WHERE kode_barang='MDLT-ZGAE-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZGAE-95-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-17 09:33:53','TOKO','BTLTMD','MDLT','MDLT-ZGAE-95-0','1','0.520','0.510','1','0.520','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZGAE-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZGAE-95-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260717-0001','2026-07-17','09:33','9.790','cashier1','2026-07-17 09:33:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-17 ','09:50:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','09:57:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','10:21:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','10:55:44');
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-260717-0001','sales','1',' EX ','TOKO','BTATMT','MTAT-ZEAH-2-0','AT ITALY DOLLAR BT SHB ','','1.880','1','100.00','3440500','0','0','0','3440500','0','0','0','3440500','2105','00029578','MTAT','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZEAH-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-07-17' AND kode_barang='MTAT-ZEAH-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260717-0001','2026-07-17','1.880','2026-07-17','12:06:14','PLG0019169','3440500','3440500','0','3440500','3440500','sales','2026-07-17 12:06:13','FJ-260717-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-07-17','FJ-260717-0001','2026-07-17','12:06:14','2105','3440500','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-260717-0002','D','2026-07-17','12:06:14','sales','PENJUALAN','FJ-260717-0001','124475150','3440500','127915650');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260717-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260717-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260717-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260717-0002','sales','1',' EX ','TOKO','BTGLMS','MSGL-ZEAE-31-0','GL FANCY DB MN5 16CM KKT PER SHB ','','1.980','1','100.00','2188000','0','0','0','2188000','0','0','0','2188000','2105','00029572','MSGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSGL-ZEAE-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-07-17' AND kode_barang='MSGL-ZEAE-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMS' 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-260717-0002','2026-07-17','1.980','2026-07-17','12:42:46','PLG0019170','2188000','2188000','0','2188000','2188000','sales','2026-07-17 12:42:44','FJ-260717-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-07-17','FJ-260717-0002','2026-07-17','12:42:46','2105','2188000','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-260717-0003','D','2026-07-17','12:42:46','sales','PENJUALAN','FJ-260717-0002','127915650','2188000','130103650');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-17 ','12:43:17');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260717-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260717-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260717-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','12:47:53');
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-00009654','X-00009654','CN COR BT SHB','GR','---','MTCN','BELI','BELI001','2093000','2026-07-17','1.300','1','sales','2026-07-17 13:13:33');
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-00009654','X-00009654');
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-260717-0001','FJ-220420-0013','2103','1','BELI','BELI001','MTCN', 'X-00009654', 'CN COR BT SHB','1.350','1.300','100.00','965500','2093000','1610000','1','2093000','2093000','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-07-17','BELI','BELI001','MTCN','MTCN','100.00','1.300','1.300','1','1.300','1.300','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-260717-0001','2026-07-17','2026-07-17','13:13:32','2103','---','1.300','2093000','2093000','2093000','2093000','2093000','sales','2026-07-17 13:13:33','FB-260717-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260717-0001','MUHIMAH','SHB AGUNG KPS','','','','sales','2026-07-17 13:13:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-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-260717-0004','K','2026-07-17','13:13:32','sales','PEMBELIAN UMUM','FB-260717-0001','130103650','2093000','128010650','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260717-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260717-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-17 ','16:01:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-17 ','16:40:54');