INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-31 ','08:34:10');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-31','126','0','-160400000','126','0','-160400000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-30';
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-08-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-30' 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-260831-0001','D','2026-08-31','08:34:21','BCA','SALDO AWAL','SALDO AWAL','0','2052763713','2052763713');
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-260831-0001','D','2026-08-31','08:34:21','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-31';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-31 ','08:38:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-08-31 ','08:50: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-00009766','X-00009766','AT COR KLP SLP SHB','GR','---','MTAT','BELI','BELI001','2549500','2026-08-31','1.550','1','sales','2026-08-31 09:09:16');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009766','X-00009766');
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-260831-0001','FJ-240117-0005','2602','1','BELI','BELI001','MTAT', 'X-00009766', 'AT COR KLP SLP SHB','1.650','1.550','100.00','1312000','2549500','1644839','1','2549500','2549500','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-08-31','BELI','BELI001','MTAT','MTAT','100.00','1.550','1.550','1','1.550','1.550','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-260831-0001','2026-08-31','2026-08-31','09:09:16','2602','---','1.550','2549500','2549500','2549500','2549500','2549500','sales','2026-08-31 09:09:16','FB-260831-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0001','FARAH','GEMBONG','','','','sales','2026-08-31 09:09:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0002','K','2026-08-31','09:09:16','sales','PEMBELIAN UMUM','FB-260831-0001','163252610','2549500','160703110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0001';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009767','X-00009767','KL ITALY ST VAR BT 42CM KKT PER UBS','GR','---','MDKL','BELI','BELI001','2099000','2026-08-31','2.170','1','sales','2026-08-31 09:17:06');
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-00009767','X-00009767');
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-260831-0002','FJ-260712-0004','2106','1','BELI','BELI001','MDKL', 'X-00009767', 'KL ITALY ST VAR BT 42CM KKT PER UBS','2.170','2.170','100.00','2507000','2099000','967281','1','2099000','2099000','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-08-31','BELI','BELI001','MDKL','MDKL','100.00','2.170','2.170','1','2.170','2.170','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260831-0002','2026-08-31','2026-08-31','09:17:05','2106','---','2.170','2099000','2099000','2099000','2099000','2099000','sales','2026-08-31 09:17:06','FB-260831-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0002','HANI','SIDOTOPO SKLHN 3/38','','SBY','083123507749','sales','2026-08-31 09:17:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0003','K','2026-08-31','09:17:05','sales','PEMBELIAN UMUM','FB-260831-0002','160703110','2099000','158604110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-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-00009768','X-00009768','AT COR TDK BT LC2','GR','---','MDAT','BELI','BELI001','764000','2026-08-31','0.790','1','sales','2026-08-31 09:21:27');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009768','X-00009768');
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-260831-0003','FJ-260529-0004','2105','1','BELI','BELI001','MDAT', 'X-00009768', 'AT COR TDK BT LC2','0.790','0.790','100.00','897000','764000','967089','1','764000','764000','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-08-31','BELI','BELI001','MDAT','MDAT','100.00','0.790','0.790','1','0.790','0.790','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-260831-0003','2026-08-31','2026-08-31','09:21:26','2105','---','0.790','764000','764000','764000','764000','764000','sales','2026-08-31 09:21:27','FB-260831-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0003','LOUISA','WONOKUSUMO JAYA NO 32','','','','sales','2026-08-31 09:21:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0004','K','2026-08-31','09:21:26','sales','PEMBELIAN UMUM','FB-260831-0003','158604110','764000','157840110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0003';
UPDATE tt_hutang_head SET byr_harus_rp='500000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'560000',tgl_lunas='2026-08-31',status='CLOS',total_lunas='560000' WHERE no_hutang='PI26-01699';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'500000'  WHERE tanggal='2026-08-31';
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-260831-0005','D','2026-08-31','09:47:00','cashier1','HUTANG LUNAS','PI26-01699','157840110','560000','158400110');
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-00009769','X-00009769','AT TINDIK ARESO UBS','GR','---','MDAT','BELI','BELI001','309000','2026-08-31','0.420','1','sales','2026-08-31 10:04:43');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009769','X-00009769');
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-260831-0004','FJ-260821-0001','2106','1','BELI','BELI001','MDAT', 'X-00009769', 'AT TINDIK ARESO UBS','0.420','0.420','100.00','472500','309000','735714','1','309000','309000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260831-0004','2026-08-31','2026-08-31','10:04:43','2106','---','0.420','309000','309000','309000','309000','309000','sales','2026-08-31 10:04:43','FB-260831-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0004','SITI NUR HASANAH','BOLODEWO','','SBY','','sales','2026-08-31 10:04:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0006','K','2026-08-31','10:04:43','sales','PEMBELIAN UMUM','FB-260831-0004','158400110','309000','158091110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-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-00009770','X-00009770','KL LONG LINK 43CM KKT PER UBS','GR','---','MDKL','BELI','BELI001','5708000','2026-08-31','5.900','1','sales','2026-08-31 10:11:17');
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-00009770','X-00009770');
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-260831-0005','FJ-260710-0004','2502','1','BELI','BELI001','MDKL', 'X-00009770', 'KL LONG LINK 43CM KKT PER UBS','5.900','5.900','100.00','6519500','5708000','967458','1','5708000','5708000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.900',berat_beli_asli=berat_beli_asli+'5.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.900',berat_akhir_asli=berat_akhir_asli+'5.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-31' 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-260831-0005','2026-08-31','2026-08-31','10:11:16','2502','---','5.900','5708000','5708000','5708000','5708000','5708000','sales','2026-08-31 10:11:17','FB-260831-0005','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0005','ISTIANI','RANDU AGUNG 1/46','','','','sales','2026-08-31 10:11:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0007','K','2026-08-31','10:11:16','sales','PEMBELIAN UMUM','FB-260831-0005','158091110','5708000','152383110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260831-0001','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZEAI-40-0','GL ITALY ST SRT BL PSR BL SLP 19CM KKT PER SHB ','','2.280','1','100.00','2565000','0','0','0','2565000','0','0','0','2565000','2502','00029682','MDGL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='MDGL-ZEAI-40-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-260831-0001','2026-08-31','2.280','2026-08-31','10:30:15','PLG0019398','2565000','2565000','0','2565000','2565000','sales','2026-08-31 10:30:14','FJ-260831-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-08-31','FJ-260831-0001','2026-08-31','10:30:15','2502','2565000','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-260831-0008','D','2026-08-31','10:30:15','sales','PENJUALAN','FJ-260831-0001','152383110','2565000','154948110');
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-00009771','X-00009771','KL VANESSA DB 43CM KKT PER SHB','GR','---','MTKL','BELI','BELI001','20197000','2026-08-31','13.510','1','sales','2026-08-31 10:34:10');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009771','X-00009771');
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-260831-0006','FJ-220617-0001','2105','1','BELI','BELI001','MTKL', 'X-00009771', 'KL VANESSA DB 43CM KKT PER SHB','13.610','13.510','100.00','9990500','20197000','1494967','1','20197000','20197000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'13.510',berat_beli_asli=berat_beli_asli+'13.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'13.510',berat_akhir_asli=berat_akhir_asli+'13.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTKL' 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-260831-0006','2026-08-31','2026-08-31','10:34:10','2105','---','13.510','20197000','20197000','20197000','20197000','20197000','sales','2026-08-31 10:34:10','FB-260831-0006','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0006','MAISAROH','JOJORAN 1/37F','','','087875807861','sales','2026-08-31 10:34:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0009','K','2026-08-31','10:34:10','sales','PEMBELIAN UMUM','FB-260831-0006','154948110','20197000','134751110','OPEN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','10:36:19');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0006';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009772','X-00009772','AT TINDIK MN HT MK','GR','---','MTAT','BELI','BELI001','478000','2026-08-31','0.320','1','sales','2026-08-31 10:49:45');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009772','X-00009772');
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-260831-0007','FJ-251025-0001','2502','1','BELI','BELI001','MTAT', 'X-00009772', 'AT TINDIK MN HT MK','0.630','0.320','100.00','1096500','478000','1493750','1','478000','478000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260831-0007','2026-08-31','2026-08-31','10:49:45','2502','---','0.320','478000','478000','478000','478000','478000','sales','2026-08-31 10:49:45','FB-260831-0007','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0007','NOVA','BULAK BANTENG MADYA 5/29','','','','sales','2026-08-31 10:49:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0010','K','2026-08-31','10:49:45','sales','PEMBELIAN UMUM','FB-260831-0007','134751110','478000','134273110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','10:57:20');
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-260831-0001','1','X-00009761','BELI','BELI001','CN CAP BANGKOK SHB','1','1.010','1661000.00' ,'0.00','1661000','','1661000','1661000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-31 10:58:03' WHERE kode_barang='X-00009761' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009761' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009761' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.010',berat_hancur_asli=berat_hancur_asli+'1.010', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260831-0001','2','X-00009762','BELI','BELI001','CN SESER MK','1','2.030','1494000.00' ,'0.00','1494000','','1494000','4816000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-31 10:58:03' WHERE kode_barang='X-00009762' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009762' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009762' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.030',berat_hancur_asli=berat_hancur_asli+'2.030', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260831-0001','adminpusat','2026-08-31','2026-08-31','10:58:04','3155000','4816000', 'adminpusat','2026-08-31 10:58:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','11:26:58');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260831-0002','1','X-00009763','BELI','BELI001','LT CAP PLAT TDK BT SHB','1','1.570','2582500.00' ,'0.00','2582500','','2582500','2582500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-31 11:43:06' WHERE kode_barang='X-00009763' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009763' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009763' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.570',berat_hancur_asli=berat_hancur_asli+'1.570', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTLT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260831-0002','2','X-00009764','BELI','BELI001','KL MILANO KC 40CM KKT S UBS','1','5.030','8274000.00' ,'0.00','8274000','','8274000','13439000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-31 11:43:06' WHERE kode_barang='X-00009764' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009764' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009764' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'5.030',berat_hancur_asli=berat_hancur_asli+'5.030', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260831-0002','3','X-00009765','BELI','BELI001','GL BANGKOK TALI AIR SHB','1','5.170','8504500.00' ,'0.00','8504500','','8504500','30217500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-31 11:43:06' WHERE kode_barang='X-00009765' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009765' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009765' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'5.170',berat_hancur_asli=berat_hancur_asli+'5.170', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'5.170',berat_akhir_asli=berat_akhir_asli-'5.170' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-260831-0002','adminpusat','2026-08-31','2026-08-31','11:43:07','19361000','30217500', 'adminpusat','2026-08-31 11:43:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','11:47:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','12:37:09');
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-260831-0002','sales','1',' ','TOKO','BTCNMT','MTCN-ZDBH-93-0','CN COR BT SHB ','','1.210','1','100.00','2263000','0','0','0','2263000','0','0','0','2263000','2501','00029326','MTCN','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZDBH-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='MTCN-ZDBH-93-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-260831-0002','2026-08-31','1.210','2026-08-31','12:44:34','PLG0019399','2263000','2263000','0','2263000','2263000','sales','2026-08-31 12:44:34','FJ-260831-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-08-31','FJ-260831-0002','2026-08-31','12:44:34','2501','2263000','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-260831-0011','D','2026-08-31','12:44:34','sales','PENJUALAN','FJ-260831-0002','134273110','2263000','136536110');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0002';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01644','2026-08-31', '2026-08-31','280800','38000','281500');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'38000' WHERE no_hutang='PI26-01644';
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-260831-0012','D','2026-08-31','13:03:03','cashier1','HUTANG BUNGA','PI26-01644','136536110','38000','136574110');
UPDATE tt_hutang_head SET byr_harus_rp='5000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'5025000',tgl_lunas='2026-08-31',status='CLOS',total_lunas='5025000' WHERE no_hutang='PI26-01843';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-08-31';
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-260831-0013','D','2026-08-31','13:06:24','cashier1','HUTANG LUNAS','PI26-01843','136574110','5025000','141599110');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDAT-ZHBI-1-0','1','1.100','1.100','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-1-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-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-20260831-0001','1','MDAT-ZHBI-2-0','1','0.480','0.480','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-2-0','1','0.480','0.470','1','0.480','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-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-20260831-0001','1','MDAT-ZHBI-3-0','1','0.520','0.520','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-3-0','1','0.520','0.510','1','0.520','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-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-20260831-0001','1','MDAT-ZHBI-4-0','1','0.550','0.550','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-4-0','1','0.550','0.540','1','0.550','0.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-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-20260831-0001','1','MDAT-ZHBI-5-0','1','1.250','1.250','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-5-0','1','1.250','1.240','1','1.250','1.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-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-20260831-0001','1','MDAT-ZHBI-6-0','1','1.110','1.110','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZHBI-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2026-08-31 13:48:19' WHERE kode_barang='MDAT-ZHBI-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-ZHBI-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-08-31 13:48:19','TOKO','BTATMD','MDAT','MDAT-ZHBI-6-0','1','1.110','1.100','1','1.110','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDAT-ZHBI-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZHBI-6-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:47','5.010','cashier1','2026-08-31 13:48:18');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDCN-ZHBI-7-0','1','2.260','2.260','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-7-0','1','2.260','2.250','1','2.260','2.250','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-ZHBI-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-8-0','1','0.800','0.800','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-8-0','1','0.800','0.790','1','0.800','0.790','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-ZHBI-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-9-0','1','1.330','1.330','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-9-0','1','1.330','1.320','1','1.330','1.320','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-ZHBI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-10-0','1','1.750','1.750','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-10-0','1','1.750','1.740','1','1.750','1.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZHBI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-11-0','1','1.580','1.580','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-11-0','1','1.580','1.570','1','1.580','1.570','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-ZHBI-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-12-0','1','5.100','5.100','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-12-0','1','5.100','5.090','1','5.100','5.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZHBI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-13-0','1','3.040','3.040','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-13-0','1','3.040','3.030','1','3.040','3.030','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-ZHBI-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-14-0','1','0.800','0.800','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-14-0','1','0.800','0.790','1','0.800','0.790','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-ZHBI-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-15-0','1','0.830','0.830','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-15-0','1','0.830','0.820','1','0.830','0.820','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-ZHBI-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-16-0','1','1.230','1.230','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-16-0','1','1.230','1.220','1','1.230','1.220','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-ZHBI-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-17-0','1','1.040','1.040','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-17-0','1','1.040','1.030','1','1.040','1.030','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-ZHBI-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-18-0','1','1.100','1.100','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-18-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZHBI-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHBI-19-0','1','0.770','0.770','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHBI-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHBI-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHBI-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHBI-19-0','1','0.770','0.760','1','0.770','0.760','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-ZHBI-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHBI-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-20260831-0001','1','MDCN-ZHCA-1-0','1','1.020','1.020','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZHCA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZHCA-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-08-31 13:48:45' WHERE kode_barang='MDCN-ZHCA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZHCA-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-08-31 13:48:45','TOKO','BTCNMD','MDCN','MDCN-ZHCA-1-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-ZHCA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZHCA-1-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:48','22.650','cashier1','2026-08-31 13:48:45');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDGL-ZHBI-20-0','1','2.370','2.370','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-20-0','1','2.370','2.360','1','2.370','2.360','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-ZHBI-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-21-0','1','2.820','2.820','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-21-0','1','2.820','2.810','1','2.820','2.810','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-ZHBI-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-22-0','1','5.490','5.490','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-22-0','1','5.490','5.480','1','5.490','5.480','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-ZHBI-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-23-0','1','1.080','1.080','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-23-0','1','1.080','1.070','1','1.080','1.070','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-ZHBI-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-24-0','1','4.580','4.580','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-24-0','1','4.580','4.570','1','4.580','4.570','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-ZHBI-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-25-0','1','1.480','1.480','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-25-0','1','1.480','1.470','1','1.480','1.470','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-ZHBI-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-26-0','1','4.590','4.590','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-26-0','1','4.590','4.580','1','4.590','4.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZHBI-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-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-20260831-0001','1','MDGL-ZHBI-27-0','1','8.520','8.520','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZHBI-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-08-31 13:53:20' WHERE kode_barang='MDGL-ZHBI-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZHBI-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-08-31 13:53:20','TOKO','BTGLMD','MDGL','MDGL-ZHBI-27-0','1','8.520','8.510','1','8.520','8.510','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-ZHBI-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZHBI-27-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:53','30.930','cashier1','2026-08-31 13:53:19');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDGW-ZHBI-28-0','1','0.660','0.660','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZHBI-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZHBI-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-08-31 13:53:48' WHERE kode_barang='MDGW-ZHBI-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZHBI-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-08-31 13:53:48','TOKO','BTGWMD','MDGW','MDGW-ZHBI-28-0','1','0.660','0.650','1','0.660','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGW-ZHBI-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZHBI-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-20260831-0001','1','MDGW-ZHBI-29-0','1','1.210','1.210','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZHBI-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZHBI-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-08-31 13:53:48' WHERE kode_barang='MDGW-ZHBI-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZHBI-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-08-31 13:53:48','TOKO','BTGWMD','MDGW','MDGW-ZHBI-29-0','1','1.210','1.200','1','1.210','1.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGW-ZHBI-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZHBI-29-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:53','1.870','cashier1','2026-08-31 13:53:47');
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-00009773','X-00009773','CN KAWIN COR BT SHB','GR','---','MTCN','BELI','BELI001','4573000','2026-08-31','2.780','1','sales','2026-08-31 13:54:07');
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-00009773','X-00009773');
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-260831-0008','FJ-221105-0007','2602','1','BELI','BELI001','MTCN', 'X-00009773', 'CN KAWIN COR BT SHB','2.900','2.780','100.00','1928500','4573000','1644964','1','4573000','4573000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.780',berat_beli_asli=berat_beli_asli+'2.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.780',berat_akhir_asli=berat_akhir_asli+'2.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260831-0008','2026-08-31','2026-08-31','13:54:07','2602','---','2.780','4573000','4573000','4573000','4573000','4573000','sales','2026-08-31 13:54:07','FB-260831-0008','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260831-0008','SARIYAH','KOMSIPO DIPO 3/1','','','082338487941','sales','2026-08-31 13:54:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-31' 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-260831-0014','K','2026-08-31','13:54:07','sales','PEMBELIAN UMUM','FB-260831-0008','141599110','4573000','137026110','OPEN');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTAT-ZHBI-38-0','1','0.500','0.500','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZHBI-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-08-31 13:54:41' WHERE kode_barang='MTAT-ZHBI-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZHBI-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-08-31 13:54:41','TOKO','BTATMT','MTAT','MTAT-ZHBI-38-0','1','0.500','0.490','1','0.500','0.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZHBI-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-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-20260831-0001','1','MTAT-ZHBI-39-0','1','1.000','1.000','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZHBI-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-08-31 13:54:41' WHERE kode_barang='MTAT-ZHBI-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZHBI-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-08-31 13:54:41','TOKO','BTATMT','MTAT','MTAT-ZHBI-39-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZHBI-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-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-20260831-0001','1','MTAT-ZHBI-40-0','1','1.650','1.650','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZHBI-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-08-31 13:54:42' WHERE kode_barang='MTAT-ZHBI-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZHBI-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-08-31 13:54:42','TOKO','BTATMT','MTAT','MTAT-ZHBI-40-0','1','1.650','1.640','1','1.650','1.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZHBI-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-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-20260831-0001','1','MTAT-ZHBI-41-0','1','1.530','1.530','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZHBI-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-08-31 13:54:42' WHERE kode_barang='MTAT-ZHBI-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZHBI-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-08-31 13:54:42','TOKO','BTATMT','MTAT','MTAT-ZHBI-41-0','1','1.530','1.520','1','1.530','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZHBI-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-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-20260831-0001','1','MTAT-ZHBI-42-0','1','0.760','0.760','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-ZHBI-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2026-08-31 13:54:42' WHERE kode_barang='MTAT-ZHBI-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-ZHBI-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-08-31 13:54:42','TOKO','BTATMT','MTAT','MTAT-ZHBI-42-0','1','0.760','0.750','1','0.760','0.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-ZHBI-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZHBI-42-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:54','5.440','cashier1','2026-08-31 13:54:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-43-0','1','0.500','0.500','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-43-0','1','0.500','0.490','1','0.500','0.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-44-0','1','1.350','1.350','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-44-0','1','1.350','1.340','1','1.350','1.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-45-0','1','1.190','1.190','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-45-0','1','1.190','1.180','1','1.190','1.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-46-0','1','1.120','1.120','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-46-0','1','1.120','1.110','1','1.120','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-47-0','1','1.160','1.160','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-47-0','1','1.160','1.150','1','1.160','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-48-0','1','1.860','1.860','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-48-0','1','1.860','1.850','1','1.860','1.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-49-0','1','1.250','1.250','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-49-0','1','1.250','1.240','1','1.250','1.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-50-0','1','2.150','2.150','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-50-0','1','2.150','2.140','1','2.150','2.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-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-20260831-0001','1','MTCN-ZHBI-51-0','1','1.020','1.020','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-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-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-51-0','1','1.020','1.010','1','1.020','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-51-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-52-0','1','1.000','1.000','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-52-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-52-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-52-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-53-0','1','1.660','1.660','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-53-0','1','1.660','1.650','1','1.660','1.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-53-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-54-0','1','1.300','1.300','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-54-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-54-0','1','1.300','1.290','1','1.300','1.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-54-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-55-0','1','1.070','1.070','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-55-0','1','1.070','1.060','1','1.070','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-55-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-56-0','1','2.060','2.060','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-56-0','1','2.060','2.050','1','2.060','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-56-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-57-0','1','1.880','1.880','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-57-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-57-0','1','1.880','1.870','1','1.880','1.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-57-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-58-0','1','1.320','1.320','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-58-0','1','1.320','1.310','1','1.320','1.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-58-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTCN-ZHBI-59-0','1','0.820','0.820','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZHBI-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-08-31 13:55:04' WHERE kode_barang='MTCN-ZHBI-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZHBI-59-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:04','TOKO','BTCNMT','MTCN','MTCN-ZHBI-59-0','1','0.820','0.810','1','0.820','0.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZHBI-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZHBI-59-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:54','22.710','cashier1','2026-08-31 13:55:03');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-60-0','1','13.970','13.970','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-60-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-60-0','1','13.970','13.960','1','13.970','13.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-60-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-61-0','1','5.000','5.000','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-61-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-61-0','1','5.000','4.990','1','5.000','4.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-61-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-62-0','1','3.000','3.000','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-62-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-62-0','1','3.000','2.990','1','3.000','2.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-62-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-63-0','1','3.370','3.370','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-63-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-63-0','1','3.370','3.360','1','3.370','3.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-63-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-64-0','1','2.580','2.580','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-64-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-64-0','1','2.580','2.570','1','2.580','2.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-64-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-65-0','1','17.010','17.010','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-65-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-65-0','1','17.010','17.000','1','17.010','17.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZHBI-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-65-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGL-ZHBI-66-0','1','3.290','3.290','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZHBI-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-66-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-08-31 13:55:32' WHERE kode_barang='MTGL-ZHBI-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZHBI-66-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:32','TOKO','BTGLMT','MTGL','MTGL-ZHBI-66-0','1','3.290','3.280','1','3.290','3.280','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-ZHBI-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZHBI-66-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:55','48.220','cashier1','2026-08-31 13:55:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGW-ZHBI-67-0','1','1.780','1.780','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZHBI-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-08-31 13:55:57' WHERE kode_barang='MTGW-ZHBI-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZHBI-67-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:57','TOKO','BTGWMT','MTGW','MTGW-ZHBI-67-0','1','1.780','1.770','1','1.780','1.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZHBI-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-67-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGW-ZHBI-68-0','1','1.640','1.640','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZHBI-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-08-31 13:55:57' WHERE kode_barang='MTGW-ZHBI-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZHBI-68-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:57','TOKO','BTGWMT','MTGW','MTGW-ZHBI-68-0','1','1.640','1.630','1','1.640','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZHBI-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-68-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTGW-ZHBI-69-0','1','1.230','1.230','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZHBI-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-08-31 13:55:57' WHERE kode_barang='MTGW-ZHBI-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZHBI-69-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:55:57','TOKO','BTGWMT','MTGW','MTGW-ZHBI-69-0','1','1.230','1.220','1','1.230','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZHBI-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZHBI-69-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:55','4.650','cashier1','2026-08-31 13:55:56');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTKL-ZHBI-70-0','1','2.990','2.990','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZHBI-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZHBI-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-08-31 13:56:25' WHERE kode_barang='MTKL-ZHBI-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZHBI-70-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:56:25','TOKO','BTKLMT','MTKL','MTKL-ZHBI-70-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-ZHBI-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZHBI-70-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTKL-ZHBI-71-0','1','3.070','3.070','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZHBI-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZHBI-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-08-31 13:56:25' WHERE kode_barang='MTKL-ZHBI-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZHBI-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:56:25','TOKO','BTKLMT','MTKL','MTKL-ZHBI-71-0','1','3.070','3.060','1','3.070','3.060','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-ZHBI-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZHBI-71-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:56','6.060','cashier1','2026-08-31 13:56:24');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDKL-ZHBI-30-0','1','1.970','1.970','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZHBI-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-08-31 13:56:54' WHERE kode_barang='MDKL-ZHBI-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZHBI-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-08-31 13:56:54','TOKO','BTKLMD','MDKL','MDKL-ZHBI-30-0','1','1.970','1.960','1','1.970','1.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-ZHBI-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-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-20260831-0001','1','MDKL-ZHBI-31-0','1','7.570','7.570','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZHBI-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-08-31 13:56:54' WHERE kode_barang='MDKL-ZHBI-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZHBI-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-08-31 13:56:54','TOKO','BTKLMD','MDKL','MDKL-ZHBI-31-0','1','7.570','7.560','1','7.570','7.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-ZHBI-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-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-20260831-0001','1','MDKL-ZHBI-32-0','1','10.750','10.750','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZHBI-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-08-31 13:56:55' WHERE kode_barang='MDKL-ZHBI-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZHBI-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-08-31 13:56:55','TOKO','BTKLMD','MDKL','MDKL-ZHBI-32-0','1','10.750','10.740','1','10.750','10.740','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-ZHBI-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZHBI-32-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:56','20.290','cashier1','2026-08-31 13:56:54');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTLT-ZHBI-72-0','1','1.060','1.060','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZHBI-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-08-31 13:57:20' WHERE kode_barang='MTLT-ZHBI-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZHBI-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:57:20','TOKO','BTLTMT','MTLT','MTLT-ZHBI-72-0','1','1.060','1.050','1','1.060','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZHBI-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-72-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTLT-ZHBI-73-0','1','1.800','1.800','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZHBI-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-08-31 13:57:20' WHERE kode_barang='MTLT-ZHBI-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZHBI-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:57:20','TOKO','BTLTMT','MTLT','MTLT-ZHBI-73-0','1','1.800','1.790','1','1.800','1.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZHBI-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MTLT-ZHBI-74-0','1','1.740','1.740','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZHBI-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-08-31 13:57:20' WHERE kode_barang='MTLT-ZHBI-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZHBI-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-31 13:57:20','TOKO','BTLTMT','MTLT','MTLT-ZHBI-74-0','1','1.740','1.730','1','1.740','1.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZHBI-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZHBI-74-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:56','4.600','cashier1','2026-08-31 13:57:19');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260831-0001','1','MDLT-ZHBI-33-0','1','1.080','1.080','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZHBI-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-08-31 13:57:47' WHERE kode_barang='MDLT-ZHBI-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZHBI-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-08-31 13:57:47','TOKO','BTLTMD','MDLT','MDLT-ZHBI-33-0','1','1.080','1.070','1','1.080','1.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZHBI-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-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-20260831-0001','1','MDLT-ZHBI-34-0','1','0.910','0.910','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZHBI-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-08-31 13:57:47' WHERE kode_barang='MDLT-ZHBI-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZHBI-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-08-31 13:57:47','TOKO','BTLTMD','MDLT','MDLT-ZHBI-34-0','1','0.910','0.900','1','0.910','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZHBI-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-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-20260831-0001','1','MDLT-ZHBI-35-0','1','1.090','1.090','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZHBI-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-08-31 13:57:47' WHERE kode_barang='MDLT-ZHBI-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZHBI-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-08-31 13:57:47','TOKO','BTLTMD','MDLT','MDLT-ZHBI-35-0','1','1.090','1.080','1','1.090','1.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZHBI-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-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-20260831-0001','1','MDLT-ZHBI-36-0','1','2.310','2.310','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZHBI-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-08-31 13:57:47' WHERE kode_barang='MDLT-ZHBI-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZHBI-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-08-31 13:57:47','TOKO','BTLTMD','MDLT','MDLT-ZHBI-36-0','1','2.310','2.300','1','2.310','2.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZHBI-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-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-20260831-0001','1','MDLT-ZHBI-37-0','1','1.000','1.000','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZHBI-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-08-31 13:57:47' WHERE kode_barang='MDLT-ZHBI-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZHBI-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-08-31 13:57:47','TOKO','BTLTMD','MDLT','MDLT-ZHBI-37-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZHBI-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZHBI-37-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','13:57','6.390','cashier1','2026-08-31 13:57:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','14:04:15');
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-260831-0003','sales','1',' ','TOKO','BTATMD','MDAT-ZHXG-3-0','AT COR KLP KUPU2 BTG ','','3.320','1','100.00','3735000','0','0','0','3735000','0','0','0','3735000','2402','00030988','MDAT','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZHXG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='MDAT-ZHXG-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260831-0003','2026-08-31','3.320','2026-08-31','14:15:00','PLG0019400','3735000','3735000','0','3735000','3735000','sales','2026-08-31 14:15:00','FJ-260831-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-08-31','FJ-260831-0003','2026-08-31','14:15:00','2402','3735000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260831-0015','D','2026-08-31','14:15:00','sales','PENJUALAN','FJ-260831-0003','137026110','3735000','140761110','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3735000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260831-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260831-0004','sales',' 1',' ','TOKO','BTATMD','MDAT-YCAC-14-0','AT COR KLP BT BTG ','','1.200','1','100.00','1350000','0','0','0','1350000','0','0','0','1350000','2402','00024091','MDAT','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-YCAC-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='MDAT-YCAC-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260831-0004','2026-08-31','1.200','2026-08-31','14:15:00','PLG0019401','1350000','1350000','0','1350000','1350000','sales','2026-08-31 14:15:00','FJ-260831-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-08-31','FJ-260831-0004','2026-08-31','14:15:00','2402','1350000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260831-0016','D','2026-08-31','14:15:00','sales','PENJUALAN','FJ-260831-0004','140761110','1350000','142111110','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260831-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-31 ','14:22:18');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260831-0017','K','2026-08-31','14:44:51','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB','142111110','54000','142057110');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260831-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260831-0008';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01725','2026-08-31', '2026-08-31','546000','427000','427000');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'427000' WHERE no_hutang='PI26-01725';
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-260831-0018','D','2026-08-31','15:42:49','cashier1','HUTANG BUNGA','PI26-01725','142057110','427000','142484110');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','15:52:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-31 ','16:34:07');