INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-14 ','08:15:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-14 ','08:36:04');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-14','123','0','-159400000','123','0','-159400000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-13';
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-02-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-13' 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-260214-0001','D','2026-02-14','08:36:14','','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260214-0001','D','2026-02-14','08:36:14','BCA','SALDO AWAL','SALDO AWAL','0','1705469574','1705469574');
UPDATE tp_system SET tgl_system='2026-02-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-14 ','08:37:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-14 ','08:37:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-14 ','08:40:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-14 ','08:41:04');
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-260214-0001','1','X-00009196','BELI','BELI001','GW CAP BT SHB','1','0.740','1386500.00' ,'0.00','1386500','','1386500','1386500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-14 08:41:52' WHERE kode_barang='X-00009196' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009196' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009196' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.740',berat_hancur_asli=berat_hancur_asli+'0.740', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGW' 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-260214-0001','adminpusat','2026-02-14','2026-02-14','08:41:52','1386500','1386500', 'adminpusat','2026-02-14 08:41: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-20260214-0001','1','MDAT-ZBAB-5-0','1','1.420','1.420','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBAB-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-02-14 09:43:01' WHERE kode_barang='MDAT-ZBAB-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZBAB-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-02-14 09:43:01','TOKO','BTATMD','MDAT','MDAT-ZBAB-5-0','1','1.420','1.410','1','1.420','1.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-ZBAB-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-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-20260214-0001','1','MDAT-ZBAB-6-0','1','0.490','0.490','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBAB-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-02-14 09:43:01' WHERE kode_barang='MDAT-ZBAB-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZBAB-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-02-14 09:43:01','TOKO','BTATMD','MDAT','MDAT-ZBAB-6-0','1','0.490','0.480','1','0.490','0.480','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-ZBAB-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-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-20260214-0001','1','MDAT-ZBAB-7-0','1','1.060','1.060','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBAB-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-02-14 09:43:01' WHERE kode_barang='MDAT-ZBAB-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZBAB-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-02-14 09:43:01','TOKO','BTATMD','MDAT','MDAT-ZBAB-7-0','1','1.060','1.050','1','1.060','1.050','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-ZBAB-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-7-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDAT-ZBAB-8-0','1','2.340','2.340','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBAB-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-02-14 09:43:01' WHERE kode_barang='MDAT-ZBAB-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZBAB-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-02-14 09:43:01','TOKO','BTATMD','MDAT','MDAT-ZBAB-8-0','1','2.340','2.330','1','2.340','2.330','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-ZBAB-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZBAB-8-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:42','5.310','cashier1','2026-02-14 09:43: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-20260214-0001','1','MDCN-ZBAB-9-0','1','0.820','0.820','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-9-0','1','0.820','0.810','1','0.820','0.810','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-ZBAB-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-10-0','1','0.930','0.930','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-10-0','1','0.930','0.920','1','0.930','0.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-ZBAB-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-11-0','1','1.320','1.320','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-11-0','1','1.320','1.310','1','1.320','1.310','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-ZBAB-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-12-0','1','1.320','1.320','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-12-0','1','1.320','1.310','1','1.320','1.310','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-ZBAB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-13-0','1','1.780','1.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-13-0','1','1.780','1.770','1','1.780','1.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-ZBAB-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-14-0','1','0.710','0.710','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-14-0','1','0.710','0.700','1','0.710','0.700','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-ZBAB-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-15-0','1','1.760','1.760','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-15-0','1','1.760','1.750','1','1.760','1.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-ZBAB-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-16-0','1','0.810','0.810','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-16-0','1','0.810','0.800','1','0.810','0.800','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-ZBAB-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-17-0','1','1.710','1.710','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-17-0','1','1.710','1.700','1','1.710','1.700','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-ZBAB-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-18-0','1','1.540','1.540','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-18-0','1','1.540','1.530','1','1.540','1.530','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-ZBAB-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-19-0','1','1.120','1.120','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-19-0','1','1.120','1.110','1','1.120','1.110','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-ZBAB-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-19-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDCN-ZBAB-20-0','1','1.570','1.570','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-20-0','1','1.570','1.560','1','1.570','1.560','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-ZBAB-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-21-0','1','2.120','2.120','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-21-0','1','2.120','2.110','1','2.120','2.110','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-ZBAB-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-22-0','1','1.810','1.810','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-22-0','1','1.810','1.800','1','1.810','1.800','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-ZBAB-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-23-0','1','2.020','2.020','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-23-0','1','2.020','2.010','1','2.020','2.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-ZBAB-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-24-0','1','2.850','2.850','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-24-0','1','2.850','2.840','1','2.850','2.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-ZBAB-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-25-0','1','2.410','2.410','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-25-0','1','2.410','2.400','1','2.410','2.400','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-ZBAB-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-26-0','1','4.940','4.940','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-26-0','1','4.940','4.930','1','4.940','4.930','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-ZBAB-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-27-0','1','3.340','3.340','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-27-0','1','3.340','3.330','1','3.340','3.330','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-ZBAB-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDCN-ZBAB-28-0','1','4.080','4.080','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-28-0','1','4.080','4.070','1','4.080','4.070','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-ZBAB-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-29-0','1','1.550','1.550','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-29-0','1','1.550','1.540','1','1.550','1.540','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-ZBAB-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-30-0','1','2.700','2.700','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-30-0','1','2.700','2.690','1','2.700','2.690','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-ZBAB-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDCN-ZBAB-31-0','1','1.860','1.860','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-31-0','1','1.860','1.850','1','1.860','1.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-ZBAB-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-32-0','1','1.060','1.060','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-32-0','1','1.060','1.050','1','1.060','1.050','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-ZBAB-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-33-0','1','1.460','1.460','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-33-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-ZBAB-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-33-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDCN-ZBAB-34-0','1','3.540','3.540','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-34-0','1','3.540','3.530','1','3.540','3.530','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-ZBAB-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-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-20260214-0001','1','MDCN-ZBAB-35-0','1','1.750','1.750','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-35-0','1','1.750','1.740','1','1.750','1.740','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-ZBAB-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-35-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDCN-ZBAB-36-0','1','1.980','1.980','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-14 09:43:25' WHERE kode_barang='MDCN-ZBAB-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBAB-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-02-14 09:43:25','TOKO','BTCNMD','MDCN','MDCN-ZBAB-36-0','1','1.980','1.970','1','1.980','1.970','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-ZBAB-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBAB-36-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:43','54.860','cashier1','2026-02-14 09:43:24');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MSCN-ZBAB-1-0','1','1.120','1.120','TOKO','BCNMS','TOKO','BTCNMS');
DELETE FROM tm_barang WHERE kode_barang='MSCN-ZBAB-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSCN-ZBAB-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMS',tgl_last_beli='2026-02-14 09:43:48' WHERE kode_barang='MSCN-ZBAB-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSCN-ZBAB-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-02-14 09:43:48','TOKO','BTCNMS','MSCN','MSCN-ZBAB-1-0','1','1.120','1.110','1','1.120','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSCN-ZBAB-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSCN-ZBAB-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-20260214-0001','1','MSCN-ZBAB-2-0','1','1.240','1.240','TOKO','BCNMS','TOKO','BTCNMS');
DELETE FROM tm_barang WHERE kode_barang='MSCN-ZBAB-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSCN-ZBAB-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMS',tgl_last_beli='2026-02-14 09:43:48' WHERE kode_barang='MSCN-ZBAB-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSCN-ZBAB-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-02-14 09:43:48','TOKO','BTCNMS','MSCN','MSCN-ZBAB-2-0','1','1.240','1.230','1','1.240','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSCN-ZBAB-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSCN-ZBAB-2-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:43','2.360','cashier1','2026-02-14 09:43:48');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDGL-ZBAB-37-0','1','3.020','3.020','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-37-0','1','3.020','3.010','1','3.020','3.010','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-ZBAB-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-38-0','1','6.770','6.770','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-38-0','1','6.770','6.760','1','6.770','6.760','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-ZBAB-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-39-0','1','2.530','2.530','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-39-0','1','2.530','2.520','1','2.530','2.520','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-ZBAB-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-40-0','1','1.840','1.840','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-40-0','1','1.840','1.830','1','1.840','1.830','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-ZBAB-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-41-0','1','1.410','1.410','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-41-0','1','1.410','1.400','1','1.410','1.400','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-ZBAB-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-42-0','1','2.530','2.530','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-42-0','1','2.530','2.520','1','2.530','2.520','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-ZBAB-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-43-0','1','3.060','3.060','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-43-0','1','3.060','3.050','1','3.060','3.050','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-ZBAB-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-44-0','1','5.380','5.380','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-44-0','1','5.380','5.370','1','5.380','5.370','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-ZBAB-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-44-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDGL-ZBAB-45-0','1','4.020','4.020','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-45-0','1','4.020','4.010','1','4.020','4.010','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-ZBAB-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-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-20260214-0001','1','MDGL-ZBAB-46-0','1','3.910','3.910','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAB-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-14 09:44:09' WHERE kode_barang='MDGL-ZBAB-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBAB-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-02-14 09:44:09','TOKO','BTGLMD','MDGL','MDGL-ZBAB-46-0','1','3.910','3.900','1','3.910','3.900','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-ZBAB-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAB-46-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:43','34.470','cashier1','2026-02-14 09:44:09');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MSGL-ZBAB-3-0','1','2.410','2.410','TOKO','BGLMS','TOKO','BTGLMS');
DELETE FROM tm_barang WHERE kode_barang='MSGL-ZBAB-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSGL-ZBAB-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMS',tgl_last_beli='2026-02-14 09:44:30' WHERE kode_barang='MSGL-ZBAB-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSGL-ZBAB-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-02-14 09:44:30','TOKO','BTGLMS','MSGL','MSGL-ZBAB-3-0','1','2.410','2.400','1','2.410','2.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSGL-ZBAB-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZBAB-3-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:44','2.410','cashier1','2026-02-14 09:44:29');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDGW-ZBAB-47-0','1','0.950','0.950','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAB-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZBAB-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-02-14 09:44:48' WHERE kode_barang='MDGW-ZBAB-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZBAB-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-02-14 09:44:48','TOKO','BTGWMD','MDGW','MDGW-ZBAB-47-0','1','0.950','0.940','1','0.950','0.940','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-ZBAB-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZBAB-47-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:44','0.950','cashier1','2026-02-14 09:44:48');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTAT-ZBAC-1-0','1','0.510','0.510','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-1-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-ZBAC-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-2-0','1','0.500','0.500','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-2-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-ZBAC-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-3-0','1','0.590','0.590','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-3-0','1','0.590','0.580','1','0.590','0.580','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-ZBAC-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-4-0','1','0.500','0.500','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-4-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-ZBAC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-5-0','1','0.510','0.510','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-5-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-ZBAC-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-6-0','1','1.000','1.000','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-6-0','1','1.000','0.990','1','1.000','0.990','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-ZBAC-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-7-0','1','0.630','0.630','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-7-0','1','0.630','0.620','1','0.630','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZBAC-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-7-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTAT-ZBAC-8-0','1','1.610','1.610','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-8-0','1','1.610','1.600','1','1.610','1.600','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-ZBAC-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-9-0','1','1.290','1.290','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:11' WHERE kode_barang='MTAT-ZBAC-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:11','TOKO','BTATMT','MTAT','MTAT-ZBAC-9-0','1','1.290','1.280','1','1.290','1.280','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-ZBAC-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-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-20260214-0001','1','MTAT-ZBAC-10-0','1','1.920','1.920','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZBAC-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-02-14 09:45:12' WHERE kode_barang='MTAT-ZBAC-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZBAC-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-02-14 09:45:12','TOKO','BTATMT','MTAT','MTAT-ZBAC-10-0','1','1.920','1.910','1','1.920','1.910','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-ZBAC-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZBAC-10-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:44','9.060','cashier1','2026-02-14 09:45:11');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTCN-ZBAC-11-0','1','0.540','0.540','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-11-0','1','0.540','0.530','1','0.540','0.530','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-ZBAC-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-12-0','1','0.760','0.760','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-12-0','1','0.760','0.750','1','0.760','0.750','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-ZBAC-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-13-0','1','1.200','1.200','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-13-0','1','1.200','1.190','1','1.200','1.190','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-ZBAC-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-14-0','1','0.990','0.990','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-14-0','1','0.990','0.980','1','0.990','0.980','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-ZBAC-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-15-0','1','1.440','1.440','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-15-0','1','1.440','1.430','1','1.440','1.430','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-ZBAC-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-16-0','1','1.030','1.030','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-16-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-ZBAC-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-17-0','1','1.050','1.050','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-17-0','1','1.050','1.040','1','1.050','1.040','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-ZBAC-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-18-0','1','1.260','1.260','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-18-0','1','1.260','1.250','1','1.260','1.250','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-ZBAC-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-19-0','1','1.360','1.360','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-19-0','1','1.360','1.350','1','1.360','1.350','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-ZBAC-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-19-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTCN-ZBAC-20-0','1','3.000','3.000','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-20-0','1','3.000','2.990','1','3.000','2.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-ZBAC-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-21-0','1','6.610','6.610','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-21-0','1','6.610','6.600','1','6.610','6.600','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-ZBAC-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-22-0','1','2.260','2.260','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-22-0','1','2.260','2.250','1','2.260','2.250','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-ZBAC-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-23-0','1','1.600','1.600','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-23-0','1','1.600','1.590','1','1.600','1.590','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-ZBAC-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-24-0','1','1.020','1.020','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-24-0','1','1.020','1.010','1','1.020','1.010','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-ZBAC-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-25-0','1','0.990','0.990','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-25-0','1','0.990','0.980','1','0.990','0.980','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-ZBAC-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-26-0','1','1.070','1.070','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-26-0','1','1.070','1.060','1','1.070','1.060','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-ZBAC-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-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-20260214-0001','1','MTCN-ZBAC-27-0','1','1.210','1.210','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-27-0','1','1.210','1.200','1','1.210','1.200','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-ZBAC-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTCN-ZBAC-28-0','1','1.060','1.060','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBAC-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-14 09:45:34' WHERE kode_barang='MTCN-ZBAC-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBAC-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-02-14 09:45:34','TOKO','BTCNMT','MTCN','MTCN-ZBAC-28-0','1','1.060','1.050','1','1.060','1.050','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-ZBAC-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBAC-28-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:45','28.450','cashier1','2026-02-14 09:45:33');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGL-ZBAC-29-0','1','1.980','1.980','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-29-0','1','1.980','1.970','1','1.980','1.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-ZBAC-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-30-0','1','3.850','3.850','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-30-0','1','3.850','3.840','1','3.850','3.840','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-ZBAC-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGL-ZBAC-31-0','1','5.710','5.710','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-31-0','1','5.710','5.700','1','5.710','5.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-32-0','1','5.670','5.670','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-32-0','1','5.670','5.660','1','5.670','5.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-33-0','1','9.950','9.950','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-33-0','1','9.950','9.940','1','9.950','9.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-33-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGL-ZBAC-34-0','1','5.590','5.590','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-34-0','1','5.590','5.580','1','5.590','5.580','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-ZBAC-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-35-0','1','5.000','5.000','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-35-0','1','5.000','4.990','1','5.000','4.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-35-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGL-ZBAC-36-0','1','2.000','2.000','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-36-0','1','2.000','1.990','1','2.000','1.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-37-0','1','3.050','3.050','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-37-0','1','3.050','3.040','1','3.050','3.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-38-0','1','3.480','3.480','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-38-0','1','3.480','3.470','1','3.480','3.470','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-ZBAC-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-39-0','1','4.060','4.060','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-39-0','1','4.060','4.050','1','4.060','4.050','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-ZBAC-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-40-0','1','4.130','4.130','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-40-0','1','4.130','4.120','1','4.130','4.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-41-0','1','3.340','3.340','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-41-0','1','3.340','3.330','1','3.340','3.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-42-0','1','11.510','11.510','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-42-0','1','11.510','11.500','1','11.510','11.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-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-20260214-0001','1','MTGL-ZBAC-43-0','1','13.300','13.300','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBAC-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-14 09:46:00' WHERE kode_barang='MTGL-ZBAC-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBAC-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-02-14 09:46:00','TOKO','BTGLMT','MTGL','MTGL-ZBAC-43-0','1','13.300','13.290','1','13.300','13.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBAC-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBAC-43-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:45','82.620','cashier1','2026-02-14 09:46:00');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGW-ZBAC-44-0','1','1.180','1.180','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-44-0','1','1.180','1.170','1','1.180','1.170','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-ZBAC-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-44-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTGW-ZBAC-45-0','1','1.080','1.080','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-45-0','1','1.080','1.070','1','1.080','1.070','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-ZBAC-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-46-0','1','0.600','0.600','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-46-0','1','0.600','0.590','1','0.600','0.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZBAC-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-47-0','1','0.640','0.640','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-47-0','1','0.640','0.630','1','0.640','0.630','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-ZBAC-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-48-0','1','0.880','0.880','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-48-0','1','0.880','0.870','1','0.880','0.870','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-ZBAC-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-49-0','1','0.870','0.870','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-49-0','1','0.870','0.860','1','0.870','0.860','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-ZBAC-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-50-0','1','1.300','1.300','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-50-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-ZBAC-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-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-20260214-0001','1','MTGW-ZBAC-51-0','1','2.340','2.340','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBAC-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-14 09:46:27' WHERE kode_barang='MTGW-ZBAC-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBAC-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-02-14 09:46:27','TOKO','BTGWMT','MTGW','MTGW-ZBAC-51-0','1','2.340','2.330','1','2.340','2.330','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-ZBAC-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBAC-51-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:46','8.890','cashier1','2026-02-14 09:46:26');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTKL-ZBAC-52-0','1','4.950','4.950','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-52-0','1','4.950','4.940','1','4.950','4.940','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-ZBAC-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-53-0','1','1.500','1.500','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-53-0','1','1.500','1.490','1','1.500','1.490','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-ZBAC-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-54-0','1','1.510','1.510','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-54-0','1','1.510','1.500','1','1.510','1.500','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-ZBAC-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-55-0','1','2.180','2.180','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-55-0','1','2.180','2.170','1','2.180','2.170','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-ZBAC-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-56-0','1','3.900','3.900','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-56-0','1','3.900','3.890','1','3.900','3.890','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-ZBAC-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-57-0','1','3.350','3.350','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-57-0','1','3.350','3.340','1','3.350','3.340','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-ZBAC-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-58-0','1','3.010','3.010','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-58-0','1','3.010','3.000','1','3.010','3.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-ZBAC-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-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-20260214-0001','1','MTKL-ZBAC-59-0','1','4.980','4.980','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBAC-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-14 09:46:48' WHERE kode_barang='MTKL-ZBAC-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBAC-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-02-14 09:46:48','TOKO','BTKLMT','MTKL','MTKL-ZBAC-59-0','1','4.980','4.970','1','4.980','4.970','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-ZBAC-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBAC-59-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:46','25.380','cashier1','2026-02-14 09:46:47');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDKL-ZBAB-48-0','1','2.160','2.160','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-48-0','1','2.160','2.150','1','2.160','2.150','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-ZBAB-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-49-0','1','3.460','3.460','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-49-0','1','3.460','3.450','1','3.460','3.450','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-ZBAB-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-50-0','1','3.090','3.090','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-50-0','1','3.090','3.080','1','3.090','3.080','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-ZBAB-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-51-0','1','3.720','3.720','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-51-0','1','3.720','3.710','1','3.720','3.710','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-ZBAB-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-52-0','1','2.490','2.490','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-52-0','1','2.490','2.480','1','2.490','2.480','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-ZBAB-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-53-0','1','4.930','4.930','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-53-0','1','4.930','4.920','1','4.930','4.920','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-ZBAB-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-54-0','1','2.870','2.870','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-54-0','1','2.870','2.860','1','2.870','2.860','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-ZBAB-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-55-0','1','2.960','2.960','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-55-0','1','2.960','2.950','1','2.960','2.950','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-ZBAB-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-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-20260214-0001','1','MDKL-ZBAB-56-0','1','2.910','2.910','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-14 09:47:15' WHERE kode_barang='MDKL-ZBAB-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBAB-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-02-14 09:47:15','TOKO','BTKLMD','MDKL','MDKL-ZBAB-56-0','1','2.910','2.900','1','2.910','2.900','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-ZBAB-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBAB-56-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:46','28.590','cashier1','2026-02-14 09:47: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-20260214-0001','1','MSKL-ZBAB-4-0','1','2.950','2.950','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBAB-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBAB-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-14 09:47:35' WHERE kode_barang='MSKL-ZBAB-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBAB-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-02-14 09:47:35','TOKO','BTKLMS','MSKL','MSKL-ZBAB-4-0','1','2.950','2.940','1','2.950','2.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSKL-ZBAB-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBAB-4-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:47','2.950','cashier1','2026-02-14 09:47:35');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MTLT-ZBAC-60-0','1','0.880','0.880','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZBAC-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-02-14 09:48:01' WHERE kode_barang='MTLT-ZBAC-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZBAC-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-02-14 09:48:01','TOKO','BTLTMT','MTLT','MTLT-ZBAC-60-0','1','0.880','0.870','1','0.880','0.870','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-ZBAC-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-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-20260214-0001','1','MTLT-ZBAC-61-0','1','0.710','0.710','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZBAC-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-02-14 09:48:01' WHERE kode_barang='MTLT-ZBAC-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZBAC-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-02-14 09:48:01','TOKO','BTLTMT','MTLT','MTLT-ZBAC-61-0','1','0.710','0.700','1','0.710','0.700','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-ZBAC-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-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-20260214-0001','1','MTLT-ZBAC-62-0','1','1.260','1.260','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZBAC-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-02-14 09:48:01' WHERE kode_barang='MTLT-ZBAC-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZBAC-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-02-14 09:48:01','TOKO','BTLTMT','MTLT','MTLT-ZBAC-62-0','1','1.260','1.250','1','1.260','1.250','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-ZBAC-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-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-20260214-0001','1','MTLT-ZBAC-63-0','1','1.610','1.610','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZBAC-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-02-14 09:48:01' WHERE kode_barang='MTLT-ZBAC-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZBAC-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-02-14 09:48:01','TOKO','BTLTMT','MTLT','MTLT-ZBAC-63-0','1','1.610','1.600','1','1.610','1.600','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-ZBAC-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-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-20260214-0001','1','MTLT-ZBAC-64-0','1','1.770','1.770','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZBAC-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-02-14 09:48:01' WHERE kode_barang='MTLT-ZBAC-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZBAC-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-02-14 09:48:01','TOKO','BTLTMT','MTLT','MTLT-ZBAC-64-0','1','1.770','1.760','1','1.770','1.760','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-ZBAC-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZBAC-64-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:47','6.230','cashier1','2026-02-14 09:48:00');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260214-0001','1','MDLT-ZBAB-57-0','1','0.790','0.790','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAB-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-14 09:48:24' WHERE kode_barang='MDLT-ZBAB-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBAB-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-02-14 09:48:24','TOKO','BTLTMD','MDLT','MDLT-ZBAB-57-0','1','0.790','0.780','1','0.790','0.780','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-ZBAB-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-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-20260214-0001','1','MDLT-ZBAB-58-0','1','1.050','1.050','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAB-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-14 09:48:24' WHERE kode_barang='MDLT-ZBAB-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBAB-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-02-14 09:48:24','TOKO','BTLTMD','MDLT','MDLT-ZBAB-58-0','1','1.050','1.040','1','1.050','1.040','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-ZBAB-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-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-20260214-0001','1','MDLT-ZBAB-59-0','1','2.180','2.180','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAB-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-14 09:48:24' WHERE kode_barang='MDLT-ZBAB-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBAB-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-02-14 09:48:24','TOKO','BTLTMD','MDLT','MDLT-ZBAB-59-0','1','2.180','2.170','1','2.180','2.170','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-ZBAB-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-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-20260214-0001','1','MDLT-ZBAB-60-0','1','1.320','1.320','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAB-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-14 09:48:24' WHERE kode_barang='MDLT-ZBAB-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBAB-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-02-14 09:48:24','TOKO','BTLTMD','MDLT','MDLT-ZBAB-60-0','1','1.320','1.310','1','1.320','1.310','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-ZBAB-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBAB-60-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260214-0001','2026-02-14','09:48','5.340','cashier1','2026-02-14 09:48:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-14 ','10:18:12');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260214-0001','sales','1',' EX ','TOKO','BTCNMT','MTCN-VEAC-28-0','CN COR TDK BT SHB','','3.140','1','100.00','6688500','0','0','0','6688500','0','0','0','6688500','2402','00009414','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-VEAC-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTCN-VEAC-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-260214-0001','2026-02-14','3.140','2026-02-14','10:19:27','PLG0018066','6688500','6688500','0','6688500','6688500','sales','2026-02-14 10:19:26','FJ-260214-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-02-14','FJ-260214-0001','2026-02-14','10:19:27','2402','6688500','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-260214-0002','D','2026-02-14','10:19:27','sales','PENJUALAN','FJ-260214-0001','182095056','6688500','188783556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-14 ','10:30:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-14 ','10:46:37');
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-00009197','X-00009197','GW CAP BT SHB','GR','---','MTGW','BELI','BELI001','2061000','2026-02-14','1.100','1','sales','2026-02-14 11:13:03');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009197','X-00009197');
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-260214-0001','FJ-250313-0003','2106','1','BELI','BELI001','MTGW', 'X-00009197', 'GW CAP BT SHB','1.100','1.100','100.00','1314500','2061000','1873636','1','2061000','2061000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGW' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260214-0001','2026-02-14','2026-02-14','11:13:03','2106','---','1.100','2061000','2061000','2061000','2061000','2061000','sales','2026-02-14 11:13:03','FB-260214-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260214-0001','IBU ANDRE','BLK BNTG KIDUL 8/42','','','','sales','2026-02-14 11:13:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-14' 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-260214-0003','K','2026-02-14','11:13:03','sales','PEMBELIAN UMUM','FB-260214-0001','188783556','2061000','186722556','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260214-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260214-0001';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009198','X-00009198','GL MDL ROLEX CHANEL AD PNH','GR','---','MTGL','BELI','BELI001','18600000','2026-02-14','11.280','1','sales','2026-02-14 11:46:09');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009198','X-00009198');
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-260214-0002','-','2103','1','BELI','BELI001','MTGL', 'X-00009198', 'GL MDL ROLEX CHANEL AD PNH','11.900','11.280','100.00','4641000','18600000','1648936','1','18600000','18600000','RONGSOK');
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-02-14','BELI','BELI001','MTGL','MTGL','100.00','11.280','11.280','1','11.280','11.280','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-260214-0002','2026-02-14','2026-02-14','11:46:08','2103','---','11.280','18600000','18600000','18600000','18600000','18600000','sales','2026-02-14 11:46:09','FB-260214-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260214-0002','-','-','','','','sales','2026-02-14 11:46:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-14' 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-260214-0004','K','2026-02-14','11:46:08','sales','PEMBELIAN UMUM','FB-260214-0002','186722556','18600000','168122556','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260214-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260214-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-14 ','11:53:02');
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-260214-0002','sales','1',' ','TOKO','BTCNMD','MDCN-YKXD-177-0','CN COR TDK BT SHB ','','0.730','1','100.00','916500','0','0','0','916500','0','0','0','916500','2403','00026683','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-177-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-YKXD-177-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0002','2026-02-14','0.730','2026-02-14','11:53:55','PLG0018067','916500','916500','0','916500','916500','sales','2026-02-14 11:53:55','FJ-260214-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-02-14','FJ-260214-0002','2026-02-14','11:53:55','2403','916500','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-260214-0005','D','2026-02-14','11:53:55','sales','PENJUALAN','FJ-260214-0002','168122556','916500','169039056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-14 ','12:22:25');
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-260214-0003','sales','1',' ','TOKO','BTGLMT','MTGL-ZBXI-93-0','GL HL RT ANAK MN1 1BEL 13CM KKT PER SHB ','','2.860','1','100.00','6092000','0','0','0','6092000','0','0','0','6092000','2404','00027907','MTGL','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZBXI-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTGL-ZBXI-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0003','2026-02-14','2.860','2026-02-14','12:35:42','PLG0018068','6092000','6092000','0','6092000','5000000','sales','2026-02-14 12:35:41','FJ-260214-0003');
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-02-14','FJ-260214-0003','2026-02-14','12:35:42','2404','6092000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260214-0006','D','2026-02-14','12:35:42','sales','PENJUALAN','FJ-260214-0003','169039056','5000000','174039056','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0001','2026-02-14','2026-02-14 12:35:41','PENJUALAN : FJ-260214-0003','bca','BCA','1092000','1092000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0002','D','2026-02-14','12:35:42','BCA','PENJUALAN','FJ-260214-0003','1705469574','1092000','1706561574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','SITI SUBAIDAH');
UPDATE tt_jual_head SET dibayar_rp='5000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1092000' WHERE no_faktur_jual='FJ-260214-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260214-0004','sales','1',' ','TOKO','BTCNMD','MDCN-ZBAX-15-0','CN PLINTIR TALI AIR SHB ','','1.340','1','100.00','1682000','0','0','0','1682000','0','0','0','1682000','2403','00027953','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAX-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-ZBAX-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0004','2026-02-14','1.340','2026-02-14','12:57:08','PLG0018069','1682000','1682000','0','1682000','1682000','sales','2026-02-14 12:57:07','FJ-260214-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-14','FJ-260214-0004','2026-02-14','12:57:08','2403','1682000','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-260214-0007','D','2026-02-14','12:57:08','sales','PENJUALAN','FJ-260214-0004','174039056','1682000','175721056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0004';
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-260214-0005','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZBAB-45-0','GL CAP HOLO 17CM KKT PER MK ','','4.020','1','100.00','5045500','0','0','0','5045500','0','0','0','5045500','2106','00028109','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAB-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDGL-ZBAB-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0005','2026-02-14','4.020','2026-02-14','13:26:58','PLG0018070','5045500','5045500','0','5045500','5045500','sales','2026-02-14 13:26:58','FJ-260214-0005');
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-02-14','FJ-260214-0005','2026-02-14','13:26:58','2106','5045500','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-260214-0008','D','2026-02-14','13:26:58','sales','PENJUALAN','FJ-260214-0005','175721056','5045500','180766556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-14 ','13:42:36');
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-260214-0006','sales','1',' ','TOKO','BTKLMT','MTKL-ZAAC-18-0','KL VALENTINE DB 41CM KKT S SHB ','','6.010','1','100.00','12801500','0','0','0','12801500','0','0','0','12801500','2502','00027644','MTKL','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-ZAAC-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.010',berat_jual_asli=berat_jual_asli+'6.010',stock_jual='1',berat_akhir=berat_akhir-'6.010',berat_akhir_asli=berat_akhir_asli-'6.010',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTKL-ZAAC-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0006','2026-02-14','6.010','2026-02-14','13:58:50','PLG0018071','12801500','12801500','0','12801500','10801500','sales','2026-02-14 13:58:49','FJ-260214-0006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-14','FJ-260214-0006','2026-02-14','13:58:50','2502','12801500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260214-0009','D','2026-02-14','13:58:50','sales','PENJUALAN','FJ-260214-0006','180766556','10801500','191568056','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0002','2026-02-14','2026-02-14 13:58:49','PENJUALAN : FJ-260214-0006','bca','BCA','2000000','2000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0003','D','2026-02-14','13:58:50','BCA','PENJUALAN','FJ-260214-0006','1706561574','2000000','1708561574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','KHUSNUL HOTIMAH');
UPDATE tt_jual_head SET dibayar_rp='10801500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2000000' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0006';
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-260214-0007','sales','1',' ','TOKO','BTCNMD','MDCN-ZAAB-6-0','CN PLINTIR SHB ','','0.980','1','100.00','1230000','0','0','0','1230000','0','0','0','1230000','2502','00027480','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZAAB-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-ZAAB-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0007','2026-02-14','0.980','2026-02-14','14:11:25','PLG0018072','1230000','1230000','0','1230000','1230000','sales','2026-02-14 14:11:25','FJ-260214-0007');
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-02-14','FJ-260214-0007','2026-02-14','14:11:25','2502','1230000','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-260214-0010','D','2026-02-14','14:11:25','sales','PENJUALAN','FJ-260214-0007','191568056','1230000','192798056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0007';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260214-0011','K','2026-02-14','14:18:09','cashier1','PENGELUARAN','BELI AIR MINUM 2 GALON CLUB ','192798056','34000','192764056');
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-260214-0008','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZBAB-46-0','GL CAP HOLO 17CM KKT PER SHB ','','3.910','1','100.00','4907500','0','0','0','4907500','0','0','0','4907500','2501','00028110','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAB-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDGL-ZBAB-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0008','2026-02-14','3.910','2026-02-14','14:31:58','PLG0018073','4907500','4907500','0','4907500','4907500','sales','2026-02-14 14:31:58','FJ-260214-0008');
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-02-14','FJ-260214-0008','2026-02-14','14:31:58','2501','4907500','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-260214-0012','D','2026-02-14','14:31:58','sales','PENJUALAN','FJ-260214-0008','192764056','4907500','197671556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0008';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01682','2103','1','KL SATELIT PASIRAN KKT PER 8K LC2','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'4000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'4000000'  WHERE tanggal='2026-02-14'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01682','2026-02-14','2026-02-14','14:36:45','PLG0018074','2103','90','2026-05-15','sales','2026-02-14 14:36:45','16.450','4000000','3.00','360000','4360000','0','OPEN','22.95','1','2026-05-15','0','4360000')
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-260214-0013','K','2026-02-14','14:36:45','sales','HUTANG','PI26-01682','197671556','4000000','193671556','OPEN') 
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-00009199','X-00009199','GW COR DB MHL SHB','GR','---','MTGW','BELI','BELI001','4478500','2026-02-14','2.390','1','sales','2026-02-14 14:50:34');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009199','X-00009199');
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-260214-0003','FJ-260201-0001','2502','1','BELI','BELI001','MTGW', 'X-00009199', 'GW COR DB MHL SHB','2.390','2.390','100.00','5091000','4478500','1873849','1','4478500','4478500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.390',berat_beli_asli=berat_beli_asli+'2.390',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.390',berat_akhir_asli=berat_akhir_asli+'2.390',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGW' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260214-0003','2026-02-14','2026-02-14','14:50:34','2502','---','2.390','4478500','4478500','4478500','4478500','4478500','sales','2026-02-14 14:50:34','FB-260214-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260214-0003','ASKIYA','DKH BLK BANTENG PRINTIS UTAMA 1/13','','','087853730422','sales','2026-02-14 14:50:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-14' 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-260214-0014','K','2026-02-14','14:50:34','sales','PEMBELIAN UMUM','FB-260214-0003','193671556','4478500','189193056','OPEN');
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-260214-0009','sales','1',' EX ','TOKO','BTGWMT','MTGW-ZBAC-46-0','GW CAP TDK BT SHB ','','0.600','1','100.00','1278000','0','0','0','1278000','0','0','0','1278000','2502','00028170','MTGW','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGW-ZBAC-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTGW-ZBAC-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMT' 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-260214-0009','2026-02-14','0.600','2026-02-14','14:51:21','PLG0018075','1278000','1278000','0','1278000','1278000','sales','2026-02-14 14:51:20','FJ-260214-0009');
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-02-14','FJ-260214-0009','2026-02-14','14:51:21','2502','1278000','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-260214-0015','D','2026-02-14','14:51:21','sales','PENJUALAN','FJ-260214-0009','189193056','1278000','190471056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260214-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260214-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260214-0010','sales','1',' EX ','TOKO','BTCNMT','MTCN-YLCX-64-0','CN ANAK COR TDK BT SHB ','','0.710','1','100.00','1512500','0','0','0','1512500','0','0','0','1512500','2404','00027087','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YLCX-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTCN-YLCX-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-260214-0010','2026-02-14','0.710','2026-02-14','14:56:59','PLG0018076','1512500','1512500','0','1512500','1512500','sales','2026-02-14 14:56:59','FJ-260214-0010');
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-02-14','FJ-260214-0010','2026-02-14','14:56:59','2404','1512500','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-260214-0016','D','2026-02-14','14:56:59','sales','PENJUALAN','FJ-260214-0010','190471056','1512500','191983556');
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-260214-0011','sales','1',' ','TOKO','BTCNMT','MTCN-YLCX-65-0','CN ANAK COR TDK BT SHB ','','0.720','1','100.00','1534000','0','0','0','1534000','0','0','0','1534000','2404','00027088','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YLCX-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MTCN-YLCX-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-260214-0011','2026-02-14','0.720','2026-02-14','14:57:40','PLG0018077','1534000','1534000','0','1534000','1534000','sales','2026-02-14 14:57:39','FJ-260214-0011');
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-02-14','FJ-260214-0011','2026-02-14','14:57:40','2404','1534000','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-260214-0017','D','2026-02-14','14:57:40','sales','PENJUALAN','FJ-260214-0011','191983556','1534000','193517556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0011';
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-260214-0012','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-43-0','GL RANGKAIAN COR MN HT5 18CM KKT PER SHB ','','8.520','1','100.00','10693000','0','0','0','10693000','0','0','0','10693000','2106','00027981','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.520',berat_jual_asli=berat_jual_asli+'8.520',stock_jual='1',berat_akhir=berat_akhir-'8.520',berat_akhir_asli=berat_akhir_asli-'8.520',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDGL-ZBAX-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0012','2026-02-14','8.520','2026-02-14','15:03:47','PLG0018078','10693000','10693000','0','10693000','0','sales','2026-02-14 15:03:46','FJ-260214-0012');
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-02-14','FJ-260214-0012','2026-02-14','15:03:47','2106','10693000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0003','2026-02-14','2026-02-14 15:03:46','PENJUALAN : FJ-260214-0012','bca','BCA','10693000','10693000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0004','D','2026-02-14','15:03:47','BCA','PENJUALAN','FJ-260214-0012','1708561574','10693000','1719254574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','FITRIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10693000' WHERE no_faktur_jual='FJ-260214-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0012';
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-260214-0013','sales','1',' EX ','TOKO','BTCNMD','MDCN-YKXD-163-0','CN SESER MK','','2.040','1','100.00','2560500','0','0','0','2560500','0','0','0','2560500','2502','00026669','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-163-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-YKXD-163-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0013','2026-02-14','2.040','2026-02-14','15:12:26','PLG0018079','2560500','2560500','0','2560500','2560500','sales','2026-02-14 15:12:25','FJ-260214-0013');
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-02-14','FJ-260214-0013','2026-02-14','15:12:26','2502','2560500','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-260214-0018','D','2026-02-14','15:12:26','sales','PENJUALAN','FJ-260214-0013','193517556','2560500','196078056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0013';
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-260214-0014','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-38-0','GL PAJERO MN LM5 16CM KKT PER SHB ','','5.120','1','100.00','6426000','0','0','0','6426000','0','0','0','6426000','2501','00027976','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDGL-ZBAX-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0014','2026-02-14','5.120','2026-02-14','15:39:27','PLG0018080','6426000','6426000','0','6426000','6426000','sales','2026-02-14 15:39:26','FJ-260214-0014');
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-02-14','FJ-260214-0014','2026-02-14','15:39:27','2501','6426000','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-260214-0019','D','2026-02-14','15:39:27','sales','PENJUALAN','FJ-260214-0014','196078056','6426000','202504056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0014';
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-260214-0015','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-49-0','GL CAP PLAT DOLLAR 19CM KKT PER SHB ','','9.110','1','100.00','11433500','0','0','0','11433500','0','0','0','11433500','2401','00027987','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.110',berat_jual_asli=berat_jual_asli+'9.110',stock_jual='1',berat_akhir=berat_akhir-'9.110',berat_akhir_asli=berat_akhir_asli-'9.110',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDGL-ZBAX-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0015','2026-02-14','9.110','2026-02-14','15:44:23','PLG0018081','11433500','11433500','0','11433500','1433500','sales','2026-02-14 15:44:23','FJ-260214-0015');
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-02-14','FJ-260214-0015','2026-02-14','15:44:23','2401','11433500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260214-0020','D','2026-02-14','15:44:23','sales','PENJUALAN','FJ-260214-0015','202504056','1433500','203937556','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0004','2026-02-14','2026-02-14 15:44:23','PENJUALAN : FJ-260214-0015','bca','BCA','10000000','10000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0005','D','2026-02-14','15:44:23','BCA','PENJUALAN','FJ-260214-0015','1719254574','10000000','1729254574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','FITRIA');
UPDATE tt_jual_head SET dibayar_rp='1433500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10000000' WHERE no_faktur_jual='FJ-260214-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0015';
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-260214-0016','sales','1',' ','TOKO','BTATMD','MDAT-ZBXF-17-0','AT ITALY BT MK ','','1.350','1','100.00','1694500','0','0','0','1694500','0','0','0','1694500','2103','00027663','MDAT','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZBXF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDAT-ZBXF-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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-260214-0016','2026-02-14','1.350','2026-02-14','15:53:12','PLG0018082','1694500','1694500','0','1694500','0','sales','2026-02-14 15:53:12','FJ-260214-0016');
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-02-14','FJ-260214-0016','2026-02-14','15:53:12','2103','1694500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0005','2026-02-14','2026-02-14 15:53:12','PENJUALAN : FJ-260214-0016','bca','BCA','1694500','1694500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0006','D','2026-02-14','15:53:12','BCA','PENJUALAN','FJ-260214-0016','1729254574','1694500','1730949074','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','FITRIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1694500' WHERE no_faktur_jual='FJ-260214-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260214-0017','sales','1',' ','TOKO','BTCNMD','MDCN-ZBAX-16-0','CN PLINTIR TALI AIR SHB ','','1.320','1','100.00','1657000','0','0','0','1657000','0','0','0','1657000','2502','00027954','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAX-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-ZBAX-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0017','2026-02-14','1.320','2026-02-14','15:54:28','PLG0018083','1657000','1657000','0','1657000','343000','sales','2026-02-14 15:54:27','FJ-260214-0017');
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-02-14','FJ-260214-0017','2026-02-14','15:54:28','2502','1657000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260214-0021','D','2026-02-14','15:54:28','sales','PENJUALAN','FJ-260214-0017','203937556','343000','204280556','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0006','2026-02-14','2026-02-14 15:54:27','PENJUALAN : FJ-260214-0017','bca','BCA','1314000','1314000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0007','D','2026-02-14','15:54:28','BCA','PENJUALAN','FJ-260214-0017','1730949074','1314000','1732263074','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','FITRIA');
UPDATE tt_jual_head SET dibayar_rp='343000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1314000' WHERE no_faktur_jual='FJ-260214-0017' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260214-0018','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZBXF-154-0','CN COR TDK BT MK ','','2.140','1','100.00','2686000','0','0','0','2686000','0','0','0','2686000','2502','00027800','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='MDCN-ZBXF-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260214-0018','2026-02-14','2.140','2026-02-14','15:54:28','PLG0018084','2686000','2686000','0','2686000','0','sales','2026-02-14 15:54:27','FJ-260214-0017');
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-02-14','FJ-260214-0018','2026-02-14','15:54:28','2502','2686000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260214-0007','2026-02-14','2026-02-14 15:54:27','PENJUALAN : FJ-260214-0018','bca','BCA','2686000','2686000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0008','D','2026-02-14','15:54:28','BCA','PENJUALAN','FJ-260214-0018','1732263074','2686000','1734949074','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','FITRIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2686000' WHERE no_faktur_jual='FJ-260214-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0018';
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01682' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01682';