INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-16 ','08:15:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-16 ','08:32:08');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-16','148','0','51200000','148','0','51200000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-15';
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-05-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-15' 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-260516-0001','D','2026-05-16','08:32:18','BCA','SALDO AWAL','SALDO AWAL','0','2025700276','2025700276');
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-260516-0001','D','2026-05-16','08:32:18','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-16 ','08:32:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-16 ','08:39:38');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260516-0001','1','X-00009470','BELI','BELI001','GW COR TDK BT SMBR PTH LC2','1','0.800','780500.00' ,'0.00','780500','','780500','780500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-16 08:41:15' WHERE kode_barang='X-00009470' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009470' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009470' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.800',berat_hancur_asli=berat_hancur_asli+'0.800', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGW' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260516-0001','adminpusat','2026-05-16','2026-05-16','08:41:16','780500','780500', 'adminpusat','2026-05-16 08:41:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-05-16 ','08:50:44');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDCN-ZEAB-3-0','1','1.020','1.020','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZEAB-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-05-16 09:26:21' WHERE kode_barang='MDCN-ZEAB-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZEAB-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 09:26:21','TOKO','BTCNMD','MDCN','MDCN-ZEAB-3-0','1','1.020','1.010','1','1.020','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZEAB-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-3-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDCN-ZEAB-4-0','1','1.010','1.010','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZEAB-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-05-16 09:26:21' WHERE kode_barang='MDCN-ZEAB-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZEAB-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 09:26:21','TOKO','BTCNMD','MDCN','MDCN-ZEAB-4-0','1','1.010','1.000','1','1.010','1.000','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-ZEAB-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-4-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDCN-ZEAB-5-0','1','1.160','1.160','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZEAB-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-05-16 09:26:21' WHERE kode_barang='MDCN-ZEAB-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZEAB-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 09:26:21','TOKO','BTCNMD','MDCN','MDCN-ZEAB-5-0','1','1.160','1.150','1','1.160','1.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-ZEAB-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-5-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDCN-ZEAB-6-0','1','0.970','0.970','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZEAB-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-05-16 09:26:21' WHERE kode_barang='MDCN-ZEAB-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZEAB-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 09:26:21','TOKO','BTCNMD','MDCN','MDCN-ZEAB-6-0','1','0.970','0.960','1','0.970','0.960','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-ZEAB-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZEAB-6-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','09:25','4.160','cashier1','2026-05-16 09:26:20');
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-00009471','X-00009471','GW COR DB SHB','GR','---','MTGW','BELI','BELI001','2444500','2026-05-16','1.470','1','sales','2026-05-16 10:05:18');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009471','X-00009471');
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-260516-0001','FJ-260508-0002','2103','1','BELI','BELI001','MTGW', 'X-00009471', 'GW COR DB SHB','1.470','1.470','100.00','2778500','2444500','1662925','1','2444500','2444500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MTGW','MTGW','100.00','1.470','1.470','1','1.470','1.470','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-260516-0001','2026-05-16','2026-05-16','10:05:17','2103','---','1.470','2444500','2444500','2444500','2444500','2444500','sales','2026-05-16 10:05:18','FB-260516-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0001','WIRDA','MORO KREMBANGAN 5/5','','','','sales','2026-05-16 10:05:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0002','K','2026-05-16','10:05:17','sales','PEMBELIAN UMUM','FB-260516-0001','152156064','2444500','149711564','OPEN');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009472','X-00009472','LT CAP PLAT TDK BT SHB','GR','---','MTLT','BELI','BELI001','2610500','2026-05-16','1.570','1','sales','2026-05-16 10:05:18');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTLT','X-00009472','X-00009472');
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-260516-0002','FJ-260403-0008','2103','2','BELI','BELI001','MTLT', 'X-00009472', 'LT CAP PLAT TDK BT SHB','1.570','1.570','100.00','3077500','2610500','1662739','1','2610500','2610500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MTLT','MTLT','100.00','1.570','1.570','1','1.570','1.570','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-260516-0002','2026-05-16','2026-05-16','10:05:18','2103','---','1.570','2610500','2610500','2610500','2610500','2610500','sales','2026-05-16 10:05:18','FB-260516-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0002','FIRDA','MOROKREMBANGAN 5/5','','','','sales','2026-05-16 10:05:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0003','K','2026-05-16','10:05:18','sales','PEMBELIAN UMUM','FB-260516-0002','149711564','2610500','147101064','OPEN');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260516-0001','sales','1',' EX ','TOKO','BTKLMD','MDKL-ZBBC-4-0','KL FANCY 42CM KKT PER SHB ','','2.990','1','100.00','3394000','0','0','0','3394000','0','0','0','3394000','2103','00028746','MDKL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZBBC-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-05-16' AND kode_barang='MDKL-ZBBC-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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-260516-0001','2026-05-16','2.990','2026-05-16','10:10:24','PLG0018800','3394000','3394000','0','3394000','3394000','sales','2026-05-16 10:10:23','FJ-260516-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-05-16','FJ-260516-0001','2026-05-16','10:10:24','2103','3394000','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-260516-0004','D','2026-05-16','10:10:24','sales','PENJUALAN','FJ-260516-0001','147101064','3394000','150495064');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260516-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0002';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009473','X-00009473','CN COR BT SHB','GR','---','MDCN','BELI','BELI001','1961500','2026-05-16','2.010','1','sales','2026-05-16 10:25:22');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009473','X-00009473');
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-260516-0003','FJ-250309-0007','2403','1','BELI','BELI001','MDCN', 'X-00009473', 'CN COR BT SHB','2.060','2.010','100.00','1499000','1961500','975871','1','1961500','1961500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MDCN','MDCN','100.00','2.010','2.010','1','2.010','2.010','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-260516-0003','2026-05-16','2026-05-16','10:25:21','2403','---','2.010','1961500','1961500','1961500','1961500','1961500','sales','2026-05-16 10:25:22','FB-260516-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0003','FARA','KEMAYORAN BD DAYA G1/54B','','','081331918055','sales','2026-05-16 10:25:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0005','K','2026-05-16','10:25:21','sales','PEMBELIAN UMUM','FB-260516-0003','150495064','1961500','148533564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-16 ','10:27:38');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTGL-ZEAB-1-0','1','6.260','6.260','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZEAB-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZEAB-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-05-16 10:40:22' WHERE kode_barang='MTGL-ZEAB-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZEAB-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:40:22','TOKO','BTGLMT','MTGL','MTGL-ZEAB-1-0','1','6.260','6.250','1','6.260','6.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZEAB-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZEAB-1-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTGL-ZEAB-2-0','1','6.760','6.760','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZEAB-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZEAB-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-05-16 10:40:22' WHERE kode_barang='MTGL-ZEAB-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZEAB-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:40:22','TOKO','BTGLMT','MTGL','MTGL-ZEAB-2-0','1','6.760','6.750','1','6.760','6.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZEAB-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZEAB-2-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','10:38','13.020','cashier1','2026-05-16 10:40:22');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-1-0','1','2.450','2.450','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-1-0','1','2.450','2.440','1','2.450','2.440','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-1-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-2-0','1','2.300','2.300','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-2-0','1','2.300','2.290','1','2.300','2.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-2-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-3-0','1','4.790','4.790','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-3-0','1','4.790','4.780','1','4.790','4.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-3-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-4-0','1','1.530','1.530','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-4-0','1','1.530','1.520','1','1.530','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-4-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-5-0','1','11.180','11.180','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-5-0','1','11.180','11.170','1','11.180','11.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-5-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-6-0','1','5.970','5.970','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-6-0','1','5.970','5.960','1','5.970','5.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-6-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-7-0','1','4.980','4.980','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-7-0','1','4.980','4.970','1','4.980','4.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-7-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-8-0','1','3.970','3.970','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-8-0','1','3.970','3.960','1','3.970','3.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-8-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-9-0','1','6.880','6.880','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-9-0','1','6.880','6.870','1','6.880','6.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-9-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-10-0','1','8.000','8.000','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-10-0','1','8.000','7.990','1','8.000','7.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-10-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-11-0','1','2.020','2.020','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-11-0','1','2.020','2.010','1','2.020','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-11-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-12-0','1','2.450','2.450','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-12-0','1','2.450','2.440','1','2.450','2.440','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-12-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-13-0','1','2.460','2.460','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-13-0','1','2.460','2.450','1','2.460','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-13-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-14-0','1','2.460','2.460','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-14-0','1','2.460','2.450','1','2.460','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-14-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-15-0','1','2.450','2.450','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-15-0','1','2.450','2.440','1','2.450','2.440','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-15-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-16-0','1','2.300','2.300','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-16-0','1','2.300','2.290','1','2.300','2.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-16-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-17-0','1','2.270','2.270','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-17-0','1','2.270','2.260','1','2.270','2.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-17-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-18-0','1','3.120','3.120','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-18-0','1','3.120','3.110','1','3.120','3.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-18-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-19-0','1','2.730','2.730','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-19-0','1','2.730','2.720','1','2.730','2.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-19-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-20-0','1','3.470','3.470','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-20-0','1','3.470','3.460','1','3.470','3.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-20-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-22-0','1','3.000','3.000','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-22-0','1','3.000','2.990','1','3.000','2.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-22-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-23-0','1','4.010','4.010','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-23-0','1','4.010','4.000','1','4.010','4.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-23-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-24-0','1','3.040','3.040','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-24-0','1','3.040','3.030','1','3.040','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-24-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-25-0','1','3.500','3.500','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:42' WHERE kode_barang='MTKL-ZEAC-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:42','TOKO','BTKLMT','MTKL','MTKL-ZEAC-25-0','1','3.500','3.490','1','3.500','3.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-25-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-26-0','1','8.340','8.340','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-26-0','1','8.340','8.330','1','8.340','8.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-26-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-27-0','1','2.980','2.980','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-27-0','1','2.980','2.970','1','2.980','2.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-28-0','1','1.540','1.540','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-28-0','1','1.540','1.530','1','1.540','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-28-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-29-0','1','2.410','2.410','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-29-0','1','2.410','2.400','1','2.410','2.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-29-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-30-0','1','1.730','1.730','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-30-0','1','1.730','1.720','1','1.730','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-31-0','1','2.180','2.180','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-31-0','1','2.180','2.170','1','2.180','2.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-31-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-32-0','1','3.560','3.560','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-32-0','1','3.560','3.550','1','3.560','3.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-32-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-33-0','1','2.090','2.090','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-33-0','1','2.090','2.080','1','2.090','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-33-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-34-0','1','2.490','2.490','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-34-0','1','2.490','2.480','1','2.490','2.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-34-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-35-0','1','2.990','2.990','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-35-0','1','2.990','2.980','1','2.990','2.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-35-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-36-0','1','2.430','2.430','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-36-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-36-0','1','2.430','2.420','1','2.430','2.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-36-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-37-0','1','5.030','5.030','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-37-0','1','5.030','5.020','1','5.030','5.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-37-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-38-0','1','2.510','2.510','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-38-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-38-0','1','2.510','2.500','1','2.510','2.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-38-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-39-0','1','3.580','3.580','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-39-0','1','3.580','3.570','1','3.580','3.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-39-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-40-0','1','1.940','1.940','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-40-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-40-0','1','1.940','1.930','1','1.940','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-40-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-41-0','1','4.530','4.530','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-41-0','1','4.530','4.520','1','4.530','4.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-41-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-42-0','1','5.830','5.830','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-42-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-42-0','1','5.830','5.820','1','5.830','5.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-42-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-43-0','1','6.020','6.020','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-43-0','1','6.020','6.010','1','6.020','6.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-43-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-44-0','1','20.030','20.030','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-44-0','1','20.030','20.020','1','20.030','20.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-44-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-45-0','1','8.000','8.000','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-45-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-45-0','1','8.000','7.990','1','8.000','7.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-45-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-46-0','1','7.900','7.900','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-46-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-46-0','1','7.900','7.890','1','7.900','7.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-46-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-47-0','1','10.960','10.960','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-47-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-47-0','1','10.960','10.950','1','10.960','10.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-47-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-48-0','1','12.500','12.500','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-48-0','1','12.500','12.490','1','12.500','12.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-48-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-49-0','1','10.010','10.010','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-49-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-49-0','1','10.010','10.000','1','10.010','10.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-49-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-50-0','1','9.920','9.920','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-50-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-50-0','1','9.920','9.910','1','9.920','9.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-50-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MTKL-ZEAC-51-0','1','3.700','3.700','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZEAC-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-05-16 10:41:43' WHERE kode_barang='MTKL-ZEAC-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZEAC-51-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 10:41:43','TOKO','BTKLMT','MTKL','MTKL-ZEAC-51-0','1','3.700','3.690','1','3.700','3.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZEAC-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZEAC-51-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','10:40','236.530','cashier1','2026-05-16 10:41: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-260516-0002','sales','1',' ','TOKO','BTCNMD','MDCN-ZDAA-4-0','CN COR BT SHB ','','0.930','1','100.00','1056000','0','0','0','1056000','0','0','0','1056000','2105','00029150','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZDAA-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-05-16' AND kode_barang='MDCN-ZDAA-4-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-260516-0002','2026-05-16','0.930','2026-05-16','11:06:33','PLG0018801','1056000','1056000','0','1056000','1056000','sales','2026-05-16 11:06:32','FJ-260516-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-05-16','FJ-260516-0002','2026-05-16','11:06:33','2105','1056000','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-260516-0006','D','2026-05-16','11:06:33','sales','PENJUALAN','FJ-260516-0002','148533564','1056000','149589564');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260516-0002';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009474','X-00009474','GL VIGARU ENGKEL 16CM KKT PER SHB','GR','---','MTGL','BELI','BELI001','3875000','2026-05-16','2.500','1','sales','2026-05-16 11:11:42');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009474','X-00009474');
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-260516-0004','FJ-250316-0018','2103','1','BELI','BELI001','MTGL', 'X-00009474', 'GL VIGARU ENGKEL 16CM KKT PER SHB','2.600','2.500','100.00','3133000','3875000','1550000','1','3875000','3875000','RUSAK ADA HILANG');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MTGL','MTGL','100.00','2.500','2.500','1','2.500','2.500','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-260516-0004','2026-05-16','2026-05-16','11:11:42','2103','---','2.500','3875000','3875000','3875000','3875000','3875000','sales','2026-05-16 11:11:42','FB-260516-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0004','NADIRA AYU','GEMBONG 2 DKA 35','','','p083802059533','sales','2026-05-16 11:11:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0007','K','2026-05-16','11:11:42','sales','PEMBELIAN UMUM','FB-260516-0004','149589564','3875000','145714564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0004';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260516-0003','sales','1',' ','TOKO','BTATMT','MTAT-YCXE-54-0','AT JODHA BT SHB ','','2.230','1','100.00','4215000','0','0','0','4215000','0','0','0','4215000','2403','00023723','MTAT','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YCXE-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-05-16' AND kode_barang='MTAT-YCXE-54-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-260516-0003','2026-05-16','2.230','2026-05-16','11:18:00','PLG0018802','4215000','4215000','0','4215000','4215000','sales','2026-05-16 11:17:59','FJ-260516-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-05-16','FJ-260516-0003','2026-05-16','11:18:00','2403','4215000','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-260516-0008','D','2026-05-16','11:18:00','sales','PENJUALAN','FJ-260516-0003','145714564','4215000','149929564');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260516-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-16 ','11:42:14');
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-00009475','X-00009475','KL FANCY VAR BT 42CM KKT S SHB','GR','---','MDKL','BELI','BELI001','3367000','2026-05-16','3.450','1','sales','2026-05-16 12:20:39');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009475','X-00009475');
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-260516-0005','FJ-251211-0003','2502','1','BELI','BELI001','MDKL', 'X-00009475', 'KL FANCY VAR BT 42CM KKT S SHB','3.450','3.450','100.00','3502000','3367000','975942','1','3367000','3367000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MDKL','MDKL','100.00','3.450','3.450','1','3.450','3.450','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-260516-0005','2026-05-16','2026-05-16','12:20:39','2502','---','3.450','3367000','3367000','3367000','3367000','3367000','sales','2026-05-16 12:20:39','FB-260516-0005','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0005','ALFAN','BANGKALAN MDR','','','','sales','2026-05-16 12:20:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0009','K','2026-05-16','12:20:39','sales','PEMBELIAN UMUM','FB-260516-0005','149929564','3367000','146562564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0005';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI25-01530','2026-05-16', '2026-05-16','476000','206000','415500');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'206000' WHERE no_hutang='PI25-01530';
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-260516-0010','D','2026-05-16','12:38:40','cashier1','HUTANG BUNGA','PI25-01530','146562564','206000','146768564');
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI25-01624','2026-05-16', '2026-05-16','282600','218000','218000');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'218000' WHERE no_hutang='PI25-01624';
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-260516-0011','D','2026-05-16','12:42:22','cashier1','HUTANG BUNGA','PI25-01624','146768564','218000','146986564');
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-260516-0004','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAI-165-0','GL ANAK MARCOPOLO 3WRN 15CM UBS ','','4.320','1','100.00','4903500','0','0','0','4903500','0','0','0','4903500','2502','00028541','MDGL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAI-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.320',berat_jual_asli=berat_jual_asli+'4.320',stock_jual='1',berat_akhir=berat_akhir-'4.320',berat_akhir_asli=berat_akhir_asli-'4.320',stock_akhir='0' WHERE tanggal='2026-05-16' AND kode_barang='MDGL-ZBAI-165-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-260516-0004','2026-05-16','4.320','2026-05-16','12:43:16','PLG0018803','4903500','4903500','0','4903500','4903500','sales','2026-05-16 12:43:15','FJ-260516-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-05-16','FJ-260516-0004','2026-05-16','12:43:16','2502','4903500','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-260516-0012','D','2026-05-16','12:43:16','sales','PENJUALAN','FJ-260516-0004','146986564','4903500','151890064');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260516-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-00009476','X-00009476','KL FANCY 42CM KKT PER SHB','GR','---','MDKL','BELI','BELI001','2918000','2026-05-16','2.990','1','sales','2026-05-16 13:04:10');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009476','X-00009476');
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-260516-0006','FJ-260516-0001','2602','1','BELI','BELI001','MDKL', 'X-00009476', 'KL FANCY 42CM KKT PER SHB','2.990','2.990','100.00','3394000','2918000','975920','1','2918000','2918000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.990',berat_beli_asli=berat_beli_asli+'2.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.990',berat_akhir_asli=berat_akhir_asli+'2.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDKL' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260516-0006','2026-05-16','2026-05-16','13:04:10','2602','---','2.990','2918000','2918000','2918000','2918000','2918000','sales','2026-05-16 13:04:10','FB-260516-0006','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0006','FIRDA','MORO KREMBANGAN 5/5','','','','sales','2026-05-16 13:04:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0013','K','2026-05-16','13:04:10','sales','PEMBELIAN UMUM','FB-260516-0006','151890064','2918000','148972064','OPEN');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009477','X-00009477','CN COR TDK BT SHB','GR','---','MTCN','BELI','BELI001','4074000','2026-05-16','2.450','1','sales','2026-05-16 13:06:02');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009477','X-00009477');
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-260516-0007','FJ-260115-0001','2602','1','BELI','BELI001','MTCN', 'X-00009477', 'CN COR TDK BT SHB','2.450','2.450','100.00','4716500','4074000','1662857','1','4074000','4074000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-16','BELI','BELI001','MTCN','MTCN','100.00','2.450','2.450','1','2.450','2.450','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-260516-0007','2026-05-16','2026-05-16','13:06:02','2602','---','2.450','4074000','4074000','4074000','4074000','4074000','sales','2026-05-16 13:06:02','FB-260516-0007','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0007','WIRDA','MOROKREMBANGAN 5/5','','','08313631958','sales','2026-05-16 13:06:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0014','K','2026-05-16','13:06:02','sales','PEMBELIAN UMUM','FB-260516-0007','148972064','4074000','144898064','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0007';
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-260516-0005','sales','1',' ','TOKO','BTCNMT','MTCN-YCXE-77-0','CN CAP BANGKOK LBG SHB ','','0.910','1','100.00','1720000','0','0','0','1720000','0','0','0','1720000','2403','00023746','MTCN','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YCXE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-05-16' AND kode_barang='MTCN-YCXE-77-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-260516-0005','2026-05-16','0.910','2026-05-16','13:54:37','PLG0018804','1720000','1720000','0','1720000','1720000','sales','2026-05-16 13:54:37','FJ-260516-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-05-16','FJ-260516-0005','2026-05-16','13:54:37','2403','1720000','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-260516-0015','D','2026-05-16','13:54:37','sales','PENJUALAN','FJ-260516-0005','144898064','1720000','146618064');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260516-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260516-0005';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009478','X-00009478','GL TALI MN BUNGA SHB','GR','---','MTGL','BELI','BELI001','1178000','2026-05-16','0.760','1','sales','2026-05-16 14:31:28');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009478','X-00009478');
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-260516-0008','FJ-251031-0001','2502','1','BELI','BELI001','MTGL', 'X-00009478', 'GL TALI MN BUNGA SHB','0.760','0.760','100.00','1384500','1178000','1550000','1','1178000','1178000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.760',berat_beli_asli=berat_beli_asli+'0.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.760',berat_akhir_asli=berat_akhir_asli+'0.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260516-0008','2026-05-16','2026-05-16','14:31:27','2502','---','0.760','1178000','1178000','1178000','1178000','1178000','sales','2026-05-16 14:31:28','FB-260516-0008','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260516-0008','PEPY VITRI AYU','LAMONGAN','','','081239206662','sales','2026-05-16 14:31:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-16' 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-260516-0016','K','2026-05-16','14:31:27','sales','PEMBELIAN UMUM','FB-260516-0008','146618064','1178000','145440064','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260516-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260516-0008';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-8-0','1','5.020','5.020','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:09' WHERE kode_barang='MDGL-ZEAB-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:09','TOKO','BTGLMD','MDGL','MDGL-ZEAB-8-0','1','5.020','5.010','1','5.020','5.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZEAB-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-8-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-9-0','1','5.550','5.550','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-9-0','1','5.550','5.540','1','5.550','5.540','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-ZEAB-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-9-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-10-0','1','6.170','6.170','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-10-0','1','6.170','6.160','1','6.170','6.160','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-ZEAB-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-10-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-11-0','1','4.940','4.940','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-11-0','1','4.940','4.930','1','4.940','4.930','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-ZEAB-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-11-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-12-0','1','4.740','4.740','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-12-0','1','4.740','4.730','1','4.740','4.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZEAB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-12-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-13-0','1','4.570','4.570','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-13-0','1','4.570','4.560','1','4.570','4.560','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-ZEAB-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-13-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAB-14-0','1','5.000','5.000','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAB-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAB-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAB-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAB-14-0','1','5.000','4.990','1','5.000','4.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZEAB-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAB-14-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDGL-ZEAE-30-0','1','7.990','7.990','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAE-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZEAE-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-05-16 16:27:10' WHERE kode_barang='MDGL-ZEAE-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZEAE-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:10','TOKO','BTGLMD','MDGL','MDGL-ZEAE-30-0','1','7.990','7.980','1','7.990','7.980','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-ZEAE-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZEAE-30-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','16:22','43.980','cashier1','2026-05-16 16:27: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-20260516-0001','1','MSGL-ZEAE-31-0','1','1.980','1.980','TOKO','BGLMS','TOKO','BTGLMS');
DELETE FROM tm_barang WHERE kode_barang='MSGL-ZEAE-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMS',tgl_last_beli='2026-05-16 16:27:25' WHERE kode_barang='MSGL-ZEAE-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSGL-ZEAE-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:25','TOKO','BTGLMS','MSGL','MSGL-ZEAE-31-0','1','1.980','1.970','1','1.980','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSGL-ZEAE-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-31-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MSGL-ZEAE-32-0','1','3.010','3.010','TOKO','BGLMS','TOKO','BTGLMS');
DELETE FROM tm_barang WHERE kode_barang='MSGL-ZEAE-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMS',tgl_last_beli='2026-05-16 16:27:25' WHERE kode_barang='MSGL-ZEAE-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSGL-ZEAE-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:25','TOKO','BTGLMS','MSGL','MSGL-ZEAE-32-0','1','3.010','3.000','1','3.010','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSGL-ZEAE-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-32-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MSGL-ZEAE-33-0','1','1.970','1.970','TOKO','BGLMS','TOKO','BTGLMS');
DELETE FROM tm_barang WHERE kode_barang='MSGL-ZEAE-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMS',tgl_last_beli='2026-05-16 16:27:25' WHERE kode_barang='MSGL-ZEAE-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSGL-ZEAE-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:25','TOKO','BTGLMS','MSGL','MSGL-ZEAE-33-0','1','1.970','1.960','1','1.970','1.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSGL-ZEAE-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-33-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MSGL-ZEAE-34-0','1','9.650','9.650','TOKO','BGLMS','TOKO','BTGLMS');
DELETE FROM tm_barang WHERE kode_barang='MSGL-ZEAE-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMS',tgl_last_beli='2026-05-16 16:27:25' WHERE kode_barang='MSGL-ZEAE-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSGL-ZEAE-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:25','TOKO','BTGLMS','MSGL','MSGL-ZEAE-34-0','1','9.650','9.640','1','9.650','9.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSGL-ZEAE-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSGL-ZEAE-34-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','16:27','16.610','cashier1','2026-05-16 16:27:25');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-1-0','1','2.830','2.830','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-1-0','1','2.830','2.820','1','2.830','2.820','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-ZEAE-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-1-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-2-0','1','4.870','4.870','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-2-0','1','4.870','4.860','1','4.870','4.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZEAE-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-2-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-3-0','1','10.950','10.950','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-3-0','1','10.950','10.940','1','10.950','10.940','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-ZEAE-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-3-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-4-0','1','10.970','10.970','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-4-0','1','10.970','10.960','1','10.970','10.960','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-ZEAE-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-4-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-5-0','1','10.170','10.170','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-5-0','1','10.170','10.160','1','10.170','10.160','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-ZEAE-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-5-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-6-0','1','20.050','20.050','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-6-0','1','20.050','20.040','1','20.050','20.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-ZEAE-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-6-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-7-0','1','30.340','30.340','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-7-0','1','30.340','30.330','1','30.340','30.330','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-ZEAE-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-7-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-8-0','1','29.080','29.080','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-8-0','1','29.080','29.070','1','29.080','29.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-ZEAE-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-8-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-9-0','1','2.460','2.460','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-9-0','1','2.460','2.450','1','2.460','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZEAE-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-9-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-10-0','1','2.940','2.940','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-10-0','1','2.940','2.930','1','2.940','2.930','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-ZEAE-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-10-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-11-0','1','3.570','3.570','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-11-0','1','3.570','3.560','1','3.570','3.560','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-ZEAE-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-11-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-12-0','1','3.290','3.290','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-12-0','1','3.290','3.280','1','3.290','3.280','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-ZEAE-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-12-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-13-0','1','5.160','5.160','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-13-0','1','5.160','5.150','1','5.160','5.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZEAE-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-13-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-14-0','1','2.510','2.510','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-14-0','1','2.510','2.500','1','2.510','2.500','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-ZEAE-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-14-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-15-0','1','9.210','9.210','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-15-0','1','9.210','9.200','1','9.210','9.200','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-ZEAE-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-15-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-16-0','1','8.490','8.490','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-16-0','1','8.490','8.480','1','8.490','8.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZEAE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-16-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-17-0','1','5.050','5.050','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-17-0','1','5.050','5.040','1','5.050','5.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-ZEAE-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-17-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-18-0','1','3.030','3.030','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-18-0','1','3.030','3.020','1','3.030','3.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-ZEAE-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-18-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-19-0','1','3.010','3.010','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-19-0','1','3.010','3.000','1','3.010','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZEAE-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-19-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-20-0','1','3.570','3.570','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-20-0','1','3.570','3.560','1','3.570','3.560','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-ZEAE-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-20-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-21-0','1','2.710','2.710','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-21-0','1','2.710','2.700','1','2.710','2.700','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-ZEAE-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-21-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-22-0','1','2.440','2.440','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-22-0','1','2.440','2.430','1','2.440','2.430','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-ZEAE-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-22-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-23-0','1','2.510','2.510','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-23-0','1','2.510','2.500','1','2.510','2.500','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-ZEAE-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-23-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-24-0','1','2.600','2.600','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-24-0','1','2.600','2.590','1','2.600','2.590','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-ZEAE-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-24-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-25-0','1','2.260','2.260','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-25-0','1','2.260','2.250','1','2.260','2.250','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-ZEAE-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-25-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-26-0','1','2.120','2.120','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-26-0','1','2.120','2.110','1','2.120','2.110','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-ZEAE-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-26-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-27-0','1','2.500','2.500','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-27-0','1','2.500','2.490','1','2.500','2.490','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-ZEAE-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-28-0','1','2.440','2.440','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-28-0','1','2.440','2.430','1','2.440','2.430','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-ZEAE-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-28-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MDKL-ZEAE-29-0','1','2.530','2.530','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZEAE-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-05-16 16:27:47' WHERE kode_barang='MDKL-ZEAE-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZEAE-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:27:47','TOKO','BTKLMD','MDKL','MDKL-ZEAE-29-0','1','2.530','2.520','1','2.530','2.520','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-ZEAE-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZEAE-29-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','16:27','193.660','cashier1','2026-05-16 16:27:47');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260516-0001','1','MSKL-ZEAE-35-0','1','2.820','2.820','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-ZEAE-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-ZEAE-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2026-05-16 16:28:10' WHERE kode_barang='MSKL-ZEAE-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-ZEAE-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-16 16:28:10','TOKO','BTKLMS','MSKL','MSKL-ZEAE-35-0','1','2.820','2.810','1','2.820','2.810','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-ZEAE-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-ZEAE-35-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260516-0001','2026-05-16','16:27','2.820','cashier1','2026-05-16 16:28:09');