INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-22 ','08:27:50');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-22','127','0','-130100000','127','0','-130100000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-21';
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-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-21' 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-260222-0001','D','2026-02-22','08:28:01','BCA','SALDO AWAL','SALDO AWAL','0','1746795074','1746795074');
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-260222-0001','D','2026-02-22','08:28:01','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-02-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-22 ','08:28:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-22 ','08:31:00');
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-260222-0001','sales','1',' ','TOKO','BTLTMD','MDLT-ZBAI-76-0','LT COR FORTUNE BG ','','0.950','1','100.00','1192500','0','0','0','1192500','0','0','0','1192500','2103','00028452','MDLT','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='MDLT-ZBAI-76-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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-260222-0001','2026-02-22','0.950','2026-02-22','09:24:36','PLG0018123','1192500','1192500','0','1192500','1192500','sales','2026-02-22 09:24:35','FJ-260222-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-22','FJ-260222-0001','2026-02-22','09:24:36','2103','1192500','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-260222-0002','D','2026-02-22','09:24:36','sales','PENJUALAN','FJ-260222-0001','147167556','1192500','148360056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260222-0002','sales','1',' EX ','TOKO','BTATMT','MTAT-YHBH-90-0','AT TINDIK TOGE BL UBS ','','0.780','1','100.00','1661500','0','0','0','1661500','0','0','0','1661500','2602','00026004','MTAT','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YHBH-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='MTAT-YHBH-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260222-0002','2026-02-22','0.780','2026-02-22','09:29:43','PLG0018124','1661500','1661500','0','1661500','1661500','sales','2026-02-22 09:29:42','FJ-260222-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-22','FJ-260222-0002','2026-02-22','09:29:43','2602','1661500','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-260222-0003','D','2026-02-22','09:29:43','sales','PENJUALAN','FJ-260222-0002','148360056','1661500','150021556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0002';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-60-0','1','0.930','0.930','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-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-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-60-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-ZBBX-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-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-20260222-0001','1','MDCN-ZBBX-75-0','1','1.730','1.730','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-75-0','1','1.730','1.720','1','1.730','1.720','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-ZBBX-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-75-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-76-0','1','1.780','1.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-76-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-ZBBX-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-76-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-77-0','1','1.170','1.170','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-77-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-77-0','1','1.170','1.160','1','1.170','1.160','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-ZBBX-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-77-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-78-0','1','0.780','0.780','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-78-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-78-0','1','0.780','0.770','1','0.780','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZBBX-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-78-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-79-0','1','2.160','2.160','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-79-0','1','2.160','2.150','1','2.160','2.150','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-ZBBX-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-79-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDCN-ZBBX-80-0','1','0.840','0.840','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBX-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-22 09:34:09' WHERE kode_barang='MDCN-ZBBX-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBX-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:09','TOKO','BTCNMD','MDCN','MDCN-ZBBX-80-0','1','0.840','0.830','1','0.840','0.830','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-ZBBX-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBX-80-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:31','9.390','cashier1','2026-02-22 09:34: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-20260222-0001','1','MDGL-ZBBX-61-0','1','2.210','2.210','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-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-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-61-0','1','2.210','2.200','1','2.210','2.200','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-ZBBX-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-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-20260222-0001','1','MDGL-ZBBX-62-0','1','2.540','2.540','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-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-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-62-0','1','2.540','2.530','1','2.540','2.530','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-ZBBX-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-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-20260222-0001','1','MDGL-ZBBX-63-0','1','4.860','4.860','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-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-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-63-0','1','4.860','4.850','1','4.860','4.850','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-ZBBX-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-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-20260222-0001','1','MDGL-ZBBX-64-0','1','2.470','2.470','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-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-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-64-0','1','2.470','2.460','1','2.470','2.460','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-ZBBX-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-64-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-65-0','1','2.890','2.890','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-65-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-65-0','1','2.890','2.880','1','2.890','2.880','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-ZBBX-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-65-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-66-0','1','3.290','3.290','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-66-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-66-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-66-0','1','3.290','3.280','1','3.290','3.280','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-ZBBX-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-66-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-67-0','1','5.390','5.390','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-67-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-67-0','1','5.390','5.380','1','5.390','5.380','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-ZBBX-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-67-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-68-0','1','5.500','5.500','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-68-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-68-0','1','5.500','5.490','1','5.500','5.490','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-ZBBX-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-68-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-69-0','1','4.800','4.800','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-69-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-69-0','1','4.800','4.790','1','4.800','4.790','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-ZBBX-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-69-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-70-0','1','5.800','5.800','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-70-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-70-0','1','5.800','5.790','1','5.800','5.790','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-ZBBX-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-70-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-71-0','1','1.510','1.510','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-71-0','1','1.510','1.500','1','1.510','1.500','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-ZBBX-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-71-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-72-0','1','1.700','1.700','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-72-0','1','1.700','1.690','1','1.700','1.690','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-ZBBX-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-72-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-81-0','1','4.800','4.800','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-81-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-81-0','1','4.800','4.790','1','4.800','4.790','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-ZBBX-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-81-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-82-0','1','5.410','5.410','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-82-0','1','5.410','5.400','1','5.410','5.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-ZBBX-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-82-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-83-0','1','1.500','1.500','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-83-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-83-0','1','1.500','1.490','1','1.500','1.490','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-ZBBX-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-83-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-84-0','1','4.890','4.890','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-84-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-84-0','1','4.890','4.880','1','4.890','4.880','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-ZBBX-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-84-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-85-0','1','5.260','5.260','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-85-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-85-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-85-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-85-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-85-0','1','5.260','5.250','1','5.260','5.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZBBX-85-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-85-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-86-0','1','2.210','2.210','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-86-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-86-0','1','2.210','2.200','1','2.210','2.200','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-ZBBX-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-86-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDGL-ZBBX-87-0','1','3.140','3.140','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBX-87-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-87-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-22 09:34:24' WHERE kode_barang='MDGL-ZBBX-87-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBX-87-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:24','TOKO','BTGLMD','MDGL','MDGL-ZBBX-87-0','1','3.140','3.130','1','3.140','3.130','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-ZBBX-87-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBX-87-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:34','70.170','cashier1','2026-02-22 09:34: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-20260222-0001','1','MDGW-ZBBX-88-0','1','1.340','1.340','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBBX-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZBBX-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-02-22 09:34:40' WHERE kode_barang='MDGW-ZBBX-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZBBX-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:40','TOKO','BTGWMD','MDGW','MDGW-ZBBX-88-0','1','1.340','1.330','1','1.340','1.330','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-ZBBX-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZBBX-88-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:34','1.340','cashier1','2026-02-22 09:34:39');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-73-0','1','9.310','9.310','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-73-0','1','9.310','9.300','1','9.310','9.300','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-ZBBX-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-89-0','1','1.030','1.030','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-89-0','1','1.030','1.020','1','1.030','1.020','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-ZBBX-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-89-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-90-0','1','1.040','1.040','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-90-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-90-0','1','1.040','1.030','1','1.040','1.030','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-ZBBX-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-90-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-91-0','1','3.100','3.100','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-91-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-91-0','1','3.100','3.090','1','3.100','3.090','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-ZBBX-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-91-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-92-0','1','4.060','4.060','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-92-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-92-0','1','4.060','4.050','1','4.060','4.050','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-ZBBX-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-92-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-93-0','1','4.060','4.060','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-93-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-93-0','1','4.060','4.050','1','4.060','4.050','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-ZBBX-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-93-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-94-0','1','3.090','3.090','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-94-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-ZBBX-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-94-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-95-0','1','3.080','3.080','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-95-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-95-0','1','3.080','3.070','1','3.080','3.070','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-ZBBX-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-95-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-96-0','1','5.070','5.070','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-96-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-96-0','1','5.070','5.060','1','5.070','5.060','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-ZBBX-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-96-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-97-0','1','5.070','5.070','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-97-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-97-0','1','5.070','5.060','1','5.070','5.060','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-ZBBX-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-97-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-98-0','1','5.900','5.900','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-98-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-98-0','1','5.900','5.890','1','5.900','5.890','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-ZBBX-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-98-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-99-0','1','6.020','6.020','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-99-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-99-0','1','6.020','6.010','1','6.020','6.010','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-ZBBX-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-99-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-100-0','1','7.020','7.020','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-100-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-100-0','1','7.020','7.010','1','7.020','7.010','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-ZBBX-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-100-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-101-0','1','7.060','7.060','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-101-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-101-0','1','7.060','7.050','1','7.060','7.050','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-ZBBX-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-101-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-102-0','1','7.070','7.070','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-102-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-102-0','1','7.070','7.060','1','7.070','7.060','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-ZBBX-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-102-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-103-0','1','7.050','7.050','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-103-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-103-0','1','7.050','7.040','1','7.050','7.040','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-ZBBX-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-103-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-104-0','1','5.110','5.110','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-104-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-104-0','1','5.110','5.100','1','5.110','5.100','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-ZBBX-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-104-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDKL-ZBBX-105-0','1','5.090','5.090','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBX-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-105-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-22 09:34:51' WHERE kode_barang='MDKL-ZBBX-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBX-105-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:34:51','TOKO','BTKLMD','MDKL','MDKL-ZBBX-105-0','1','5.090','5.080','1','5.090','5.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-ZBBX-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBX-105-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:34','89.230','cashier1','2026-02-22 09:34:51');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-106-0','1','1.540','1.540','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-106-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-106-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-106-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-106-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-106-0','1','1.540','1.530','1','1.540','1.530','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-ZBBX-106-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-106-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-107-0','1','1.520','1.520','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-107-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-107-0','1','1.520','1.510','1','1.520','1.510','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-ZBBX-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-107-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-108-0','1','1.530','1.530','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-108-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-108-0','1','1.530','1.520','1','1.530','1.520','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-ZBBX-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-108-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-109-0','1','1.550','1.550','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-109-0','1','1.550','1.540','1','1.550','1.540','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-ZBBX-109-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-109-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-110-0','1','1.560','1.560','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-110-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-110-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-110-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-110-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-110-0','1','1.560','1.550','1','1.560','1.550','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-ZBBX-110-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-110-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-111-0','1','1.550','1.550','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-111-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-111-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-111-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-111-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-111-0','1','1.550','1.540','1','1.550','1.540','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-ZBBX-111-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-111-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-112-0','1','3.040','3.040','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-112-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-112-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-112-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-112-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-112-0','1','3.040','3.030','1','3.040','3.030','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-ZBBX-112-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-112-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-113-0','1','3.080','3.080','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-113-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-113-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-113-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-113-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-113-0','1','3.080','3.070','1','3.080','3.070','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-ZBBX-113-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-113-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-114-0','1','3.050','3.050','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-114-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-114-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-114-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-114-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-114-0','1','3.050','3.040','1','3.050','3.040','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-ZBBX-114-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-114-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-115-0','1','2.960','2.960','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-115-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-115-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-115-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-115-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-115-0','1','2.960','2.950','1','2.960','2.950','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-ZBBX-115-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-115-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-116-0','1','2.980','2.980','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-116-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-116-0','1','2.980','2.970','1','2.980','2.970','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-ZBBX-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-116-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-117-0','1','7.970','7.970','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-117-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-117-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-117-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-117-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-117-0','1','7.970','7.960','1','7.970','7.960','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-ZBBX-117-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-117-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MSKL-ZBBX-118-0','1','8.000','8.000','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZBBX-118-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-118-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-02-22 09:35:09' WHERE kode_barang='MSKL-ZBBX-118-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZBBX-118-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,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-22 09:35:09','TOKO','BTKLMS','MSKL','MSKL-ZBBX-118-0','1','8.000','7.990','1','8.000','7.990','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-ZBBX-118-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZBBX-118-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:34','40.330','cashier1','2026-02-22 09:35:08');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260222-0001','1','MDLT-ZBBX-74-0','1','1.270','1.270','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBBX-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBBX-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-22 09:35:59' WHERE kode_barang='MDLT-ZBBX-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBBX-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-22 09:35:59','TOKO','BTLTMD','MDLT','MDLT-ZBBX-74-0','1','1.270','1.260','1','1.270','1.260','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-ZBBX-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBBX-74-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260222-0001','2026-02-22','09:35','1.270','cashier1','2026-02-22 09:35:58');
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-260222-0003','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-31-0','GL BABY PLINTIR TALI AIR SHB ','','2.040','1','100.00','2560500','0','0','0','2560500','0','0','0','2560500','2401','00027969','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-31-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-22' AND kode_barang='MDGL-ZBAX-31-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-260222-0003','2026-02-22','2.040','2026-02-22','09:42:56','PLG0018125','2560500','2560500','0','2560500','110500','sales','2026-02-22 09:42:56','FJ-260222-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-22','FJ-260222-0003','2026-02-22','09:42:56','2401','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,status_valid) VALUES ('KM-260222-0004','D','2026-02-22','09:42:56','sales','PENJUALAN','FJ-260222-0003','150021556','110500','150132056','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-260222-0001','2026-02-22','2026-02-22 09:42:56','PENJUALAN : FJ-260222-0003','bca','BCA','2450000','2450000','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-260222-0002','D','2026-02-22','09:42:56','BCA','PENJUALAN','FJ-260222-0003','1746795074','2450000','1749245074','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','ZAINAL ABIDIN');
UPDATE tt_jual_head SET dibayar_rp='110500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2450000' WHERE no_faktur_jual='FJ-260222-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0003';
UPDATE tt_hutang_head SET byr_harus_rp='800000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'840000',tgl_lunas='2026-02-22',status='CLOS',total_lunas='840000' WHERE no_hutang='PI26-01652';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'800000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'800000'  WHERE tanggal='2026-02-22';
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-260222-0005','D','2026-02-22','09:48:15','cashier1','HUTANG LUNAS','PI26-01652','150132056','840000','150972056');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-22 ','10:15:42');
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-260222-0004','cashier1','1',' EX ','TOKO','BTCNMD','MDCN-ZBAB-29-0','CN SESER MK ','','1.550','1','100.00','1945500','0','0','0','1945500','0','0','0','1945500','2602','00028093','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAB-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='MDCN-ZBAB-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260222-0004','2026-02-22','1.550','2026-02-22','10:18:59','PLG0018126','1945500','1945500','0','1945500','0','cashier1','2026-02-22 10:18:58','FJ-260222-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-22','FJ-260222-0004','2026-02-22','10:18:59','2602','1945500','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-260222-0002','2026-02-22','2026-02-22 10:18:58','PENJUALAN : FJ-260222-0004','bca','BCA','1945500','1945500','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-260222-0003','D','2026-02-22','10:18:59','BCA','PENJUALAN','FJ-260222-0004','1749245074','1945500','1751190574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','DWI AYU INDRIANI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1945500' WHERE no_faktur_jual='FJ-260222-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0004';
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-00009215','X-00009215','AT TINDIK PLTR SHB','GR','---','MTAT','BELI','BELI001','379000','2026-02-22','0.230','1','sales','2026-02-22 10:21:11');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009215','X-00009215');
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-260222-0001','FJ-230930-0004','2501','1','BELI','BELI001','MTAT', 'X-00009215', 'AT TINDIK PLTR SHB','0.470','0.230','100.00','350500','379000','1647826','1','379000','379000','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-22','BELI','BELI001','MTAT','MTAT','100.00','0.230','0.230','1','0.230','0.230','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-260222-0001','2026-02-22','2026-02-22','10:21:10','2501','---','0.230','379000','379000','379000','379000','379000','sales','2026-02-22 10:21:11','FB-260222-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0001','HOLILA','SURTIKANTI 1/14','','','','sales','2026-02-22 10:21:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-22' 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-260222-0006','K','2026-02-22','10:21:10','sales','PEMBELIAN UMUM','FB-260222-0001','150972056','379000','150593056','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0001';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01689','2502','1','GL HOLLO PAPRAS RANTAS UBS8K','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'600000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'600000'  WHERE tanggal='2026-02-22'
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-01689','2026-02-22','2026-02-22','10:59:58','PLG0018127','2502','90','2026-05-23','sales','2026-02-22 10:59:57','1.960','600000','4.00','72000','672000','0','OPEN','8.16','1','2026-05-23','0','672000')
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-260222-0007','K','2026-02-22','10:59:58','sales','HUTANG','PI26-01689','150593056','600000','149993056','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01689' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01689';
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-260222-0005','sales','1',' ','TOKO','BTCNMT','MTCN-ZBXI-53-0','CN CAP PLAT ANAK TDK BT SHB ','','0.520','1','100.00','1108000','0','0','0','1108000','0','0','0','1108000','2105','00027867','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZBXI-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='MTCN-ZBXI-53-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-260222-0005','2026-02-22','0.520','2026-02-22','11:04:42','PLG0018128','1108000','1108000','0','1108000','0','sales','2026-02-22 11:04:41','FJ-260222-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-22','FJ-260222-0005','2026-02-22','11:04:42','2105','1108000','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-260222-0003','2026-02-22','2026-02-22 11:04:41','PENJUALAN : FJ-260222-0005','mandiri','BCA','1108000','1108000','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-260222-0004','D','2026-02-22','11:04:42','BCA','PENJUALAN','FJ-260222-0005','1751190574','1108000','1752298574','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('mandiri','NAJMI LAYALIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1108000' WHERE no_faktur_jual='FJ-260222-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0005';
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-260222-0006','sales','1',' EX ','TOKO','BTKLMT','MTKL-YHBI-38-0','KL FANCY DB 42CM KKT S SHB','','4.960','1','100.00','10565000','0','0','0','10565000','0','0','0','10565000','2502','00026125','MTKL','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-YHBI-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.960',berat_jual_asli=berat_jual_asli+'4.960',stock_jual='1',berat_akhir=berat_akhir-'4.960',berat_akhir_asli=berat_akhir_asli-'4.960',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='MTKL-YHBI-38-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-260222-0006','2026-02-22','4.960','2026-02-22','11:25:03','PLG0018129','10565000','10565000','0','10565000','10565000','sales','2026-02-22 11:25:03','FJ-260222-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-22','FJ-260222-0006','2026-02-22','11:25:03','2502','10565000','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-260222-0008','D','2026-02-22','11:25:03','sales','PENJUALAN','FJ-260222-0006','149993056','10565000','160558056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260222-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260222-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-22 ','12:16:56');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01690','2104','1','LT COR BT AD PNH 375LOTUS','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'500000'  WHERE tanggal='2026-02-22'
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-01690','2026-02-22','2026-02-22','13:34:26','PLG0018130','2104','90','2026-05-23','sales','2026-02-22 13:34:26','1.440','500000','4.00','60000','560000','0','OPEN','7.79','1','2026-05-23','0','560000')
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-260222-0009','K','2026-02-22','13:34:26','sales','HUTANG','PI26-01690','160558056','500000','160058056','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01690' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01690';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01691','2103','1','LT COR BT AD PNH 375LOTUS','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'500000'  WHERE tanggal='2026-02-22'
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-01691','2026-02-22','2026-02-22','13:43:09','PLG0018131','2103','90','2026-05-23','sales','2026-02-22 13:43:09','1.440','500000','4.00','60000','560000','0','OPEN','7.79','1','2026-05-23','0','560000')
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-260222-0010','K','2026-02-22','13:43:09','sales','HUTANG','PI26-01691','160058056','500000','159558056','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01691' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01691';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01692','2401','1','KL ITALY POLOS PNJG 700HWT KKT PER','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'12000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'12000000'  WHERE tanggal='2026-02-22'
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-01692','2026-02-22','2026-02-22','14:34:49','PLG0018132','2401','90','2026-05-23','sales','2026-02-22 14:34:48','12.020','12000000','2.50','900000','12900000','0','OPEN','18.35','1','2026-05-23','0','12900000')
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-260222-0011','K','2026-02-22','14:34:49','sales','HUTANG','PI26-01692','159558056','12000000','147558056','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01692' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01692';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-02-22 ','14:51:01');
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'500000'  WHERE tanggal='2026-02-22';
UPDATE tt_hutang_head SET status='CANC' where no_hutang='PI26-01690';
INSERT INTO tt_batal_hutang_head SELECT tt_hutang_head.* FROM tt_hutang_head where no_hutang='PI26-01690';
INSERT INTO tt_batal_hutang_detail SELECT tt_hutang_detail.* FROM tt_hutang_detail where no_hutang='PI26-01690';
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-260222-0012','D','2026-02-22','14:52:01','admin','HUTANG BATAL','PI26-01690','147558056','500000','148058056') 
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-22 ','14:56:03');