INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-04 ','08:31:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-04 ','08:33:49');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-04','105','0','-299000000','105','0','-299000000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-03';
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='2025-12-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-03' 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-251204-0001','D','2025-12-04','08:33:57','BCA','SALDO AWAL','SALDO AWAL','0','1437669157','1437669157');
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-251204-0001','D','2025-12-04','08:33:57','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-12-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-04 ','08:34:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-04 ','08:34:22');
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-251204-0001','1','X-00009024','BELI','BELI001','CN COR TDK BT SHB','1','1.950','1701000.00' ,'0.00','1701000','','1701000','1701000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-12-04 08:37:02' WHERE kode_barang='X-00009024' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009024' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009024' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.950',berat_hancur_asli=berat_hancur_asli+'1.950', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-251204-0001','2','X-00009025','BELI','BELI001','CN CAP RANTAI SHB','1','0.970','1485000.00' ,'0.00','1485000','','1485000','4887000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-12-04 08:37:02' WHERE kode_barang='X-00009025' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009025' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009025' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.970',berat_hancur_asli=berat_hancur_asli+'0.970', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' 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-251204-0001','adminpusat','2025-12-04','2025-12-04','08:37:02','3186000','4887000', 'adminpusat','2025-12-04 08:37:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-04 ','08:40:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-12-04 ','08:53:35');
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-251204-0001','sales','1',' ','TOKO','BTATMT','MTAT-XKBH-5-0','AT JEPSI POLOS MK ','','0.560','1','100.00','974500','0','0','0','974500','0','0','0','974500','2503','00022201','MTAT','209000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-XKBH-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='MTAT-XKBH-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251204-0001','2025-12-04','0.560','2025-12-04','09:23:13','PLG0017635','974500','974500','0','974500','974500','sales','2025-12-04 09:23:12','FJ-251204-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('2025-12-04','FJ-251204-0001','2025-12-04','09:23:13','2503','974500','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-251204-0002','D','2025-12-04','09:23:13','sales','PENJUALAN','FJ-251204-0001','246023625','974500','246998125','OPEN');
UPDATE tt_jual_head SET dibayar_rp='974500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251204-0001' 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-251204-0002','sales',' 1',' ','TOKO','BTGLMT','MTGL-YCXF-98-0','GL CASTELI VIGARU MN3 16CM KKT PER SHB ','','2.500','1','100.00','4350000','0','0','0','4350000','0','0','0','4350000','2503','00023912','MTGL','209000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-YCXF-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='MTGL-YCXF-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251204-0002','2025-12-04','2.500','2025-12-04','09:23:13','PLG0017636','4350000','4350000','0','4350000','4350000','sales','2025-12-04 09:23:12','FJ-251204-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('2025-12-04','FJ-251204-0002','2025-12-04','09:23:13','2503','4350000','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-251204-0003','D','2025-12-04','09:23:13','sales','PENJUALAN','FJ-251204-0002','246998125','4350000','251348125','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251204-0002' 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-251204-0003','sales',' 1',' ','TOKO','BTGLMT','MTGL-YCXF-125-0','GL BANGKOK TALI AIR ANAK SHB ','','2.560','1','100.00','4454500','0','0','0','4454500','0','0','0','4454500','2503','00023939','MTGL','209000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-YCXF-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='MTGL-YCXF-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251204-0003','2025-12-04','2.560','2025-12-04','09:23:13','PLG0017637','4454500','4454500','0','4454500','4454500','sales','2025-12-04 09:23:12','FJ-251204-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('2025-12-04','FJ-251204-0003','2025-12-04','09:23:13','2503','4454500','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-251204-0004','D','2025-12-04','09:23:13','sales','PENJUALAN','FJ-251204-0003','251348125','4454500','255802625','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4454500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251204-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-04 ','09:24:42');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251204-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251204-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251204-0003';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDAT-YLXA-57-0','1','0.520','0.520','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-57-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-YLXA-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-58-0','1','0.480','0.480','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-58-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-YLXA-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-59-0','1','1.000','1.000','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-59-0','1','1.000','0.990','1','1.000','0.990','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-YLXA-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-59-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDAT-YLXA-60-0','1','0.980','0.980','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-60-0','1','0.980','0.970','1','0.980','0.970','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-YLXA-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-61-0','1','0.970','0.970','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-61-0','1','0.970','0.960','1','0.970','0.960','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-YLXA-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-62-0','1','1.270','1.270','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-62-0','1','1.270','1.260','1','1.270','1.260','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-YLXA-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-63-0','1','1.310','1.310','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-63-0','1','1.310','1.300','1','1.310','1.300','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-YLXA-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-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-20251204-0001','1','MDAT-YLXA-64-0','1','0.820','0.820','TOKO','BATMD','TOKO','BTATMD');
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMD',tgl_last_beli='2025-12-04 09:28:30' WHERE kode_barang='MDAT-YLXA-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDAT-YLXA-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 ('2025-12-04 09:28:30','TOKO','BTATMD','MDAT','MDAT-YLXA-64-0','1','0.820','0.810','1','0.820','0.810','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-YLXA-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-YLXA-64-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:28','7.350','cashier1','2025-12-04 09:28:30');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDCN-YLXA-65-0','1','0.920','0.920','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2025-12-04 09:28:51' WHERE kode_barang='MDCN-YLXA-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-YLXA-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 ('2025-12-04 09:28:51','TOKO','BTCNMD','MDCN','MDCN-YLXA-65-0','1','0.920','0.910','1','0.920','0.910','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-YLXA-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-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-20251204-0001','1','MDCN-YLXA-66-0','1','0.660','0.660','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-66-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2025-12-04 09:28:51' WHERE kode_barang='MDCN-YLXA-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-YLXA-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 ('2025-12-04 09:28:51','TOKO','BTCNMD','MDCN','MDCN-YLXA-66-0','1','0.660','0.650','1','0.660','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-YLXA-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-66-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDCN-YLXA-67-0','1','1.520','1.520','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2025-12-04 09:28:51' WHERE kode_barang='MDCN-YLXA-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-YLXA-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 ('2025-12-04 09:28:51','TOKO','BTCNMD','MDCN','MDCN-YLXA-67-0','1','1.520','1.510','1','1.520','1.510','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-YLXA-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-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-20251204-0001','1','MDCN-YLXA-68-0','1','2.870','2.870','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2025-12-04 09:28:51' WHERE kode_barang='MDCN-YLXA-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-YLXA-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 ('2025-12-04 09:28:51','TOKO','BTCNMD','MDCN','MDCN-YLXA-68-0','1','2.870','2.860','1','2.870','2.860','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-YLXA-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-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-20251204-0001','1','MDCN-YLXA-69-0','1','1.880','1.880','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2025-12-04 09:28:51' WHERE kode_barang='MDCN-YLXA-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-YLXA-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 ('2025-12-04 09:28:51','TOKO','BTCNMD','MDCN','MDCN-YLXA-69-0','1','1.880','1.870','1','1.880','1.870','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-YLXA-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-YLXA-69-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:28','7.850','cashier1','2025-12-04 09:28:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MSCN-YLXB-1-0','1','0.840','0.840','TOKO','BCNMS','TOKO','BTCNMS');
DELETE FROM tm_barang WHERE kode_barang='MSCN-YLXB-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSCN-YLXB-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMS',tgl_last_beli='2025-12-04 09:29:09' WHERE kode_barang='MSCN-YLXB-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSCN-YLXB-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 ('2025-12-04 09:29:09','TOKO','BTCNMS','MSCN','MSCN-YLXB-1-0','1','0.840','0.830','1','0.840','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSCN-YLXB-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSCN-YLXB-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-20251204-0001','1','MSCN-YLXB-2-0','1','1.480','1.480','TOKO','BCNMS','TOKO','BTCNMS');
DELETE FROM tm_barang WHERE kode_barang='MSCN-YLXB-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSCN-YLXB-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMS',tgl_last_beli='2025-12-04 09:29:09' WHERE kode_barang='MSCN-YLXB-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSCN-YLXB-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 ('2025-12-04 09:29:09','TOKO','BTCNMS','MSCN','MSCN-YLXB-2-0','1','1.480','1.470','1','1.480','1.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSCN-YLXB-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSCN-YLXB-2-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:28','2.320','cashier1','2025-12-04 09:29:08');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDGL-YLXA-70-0','1','4.800','4.800','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-YLXA-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2025-12-04 09:29:25' WHERE kode_barang='MDGL-YLXA-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-YLXA-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 ('2025-12-04 09:29:25','TOKO','BTGLMD','MDGL','MDGL-YLXA-70-0','1','4.800','4.790','1','4.800','4.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-YLXA-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-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-20251204-0001','1','MDGL-YLXA-71-0','1','3.580','3.580','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-YLXA-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2025-12-04 09:29:25' WHERE kode_barang='MDGL-YLXA-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-YLXA-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 ('2025-12-04 09:29:25','TOKO','BTGLMD','MDGL','MDGL-YLXA-71-0','1','3.580','3.570','1','3.580','3.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-YLXA-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-71-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDGL-YLXA-72-0','1','5.600','5.600','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-YLXA-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2025-12-04 09:29:25' WHERE kode_barang='MDGL-YLXA-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-YLXA-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 ('2025-12-04 09:29:25','TOKO','BTGLMD','MDGL','MDGL-YLXA-72-0','1','5.600','5.590','1','5.600','5.590','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-YLXA-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-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-20251204-0001','1','MDGL-YLXA-73-0','1','13.900','13.900','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-YLXA-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2025-12-04 09:29:25' WHERE kode_barang='MDGL-YLXA-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-YLXA-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 ('2025-12-04 09:29:25','TOKO','BTGLMD','MDGL','MDGL-YLXA-73-0','1','13.900','13.890','1','13.900','13.890','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-YLXA-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-73-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:29','27.880','cashier1','2025-12-04 09:29:25');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTAT-YLXB-5-0','1','1.970','1.970','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-5-0','1','1.970','1.960','1','1.970','1.960','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-YLXB-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-6-0','1','1.980','1.980','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-6-0','1','1.980','1.970','1','1.980','1.970','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-YLXB-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-6-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTAT-YLXB-7-0','1','1.050','1.050','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-7-0','1','1.050','1.040','1','1.050','1.040','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-YLXB-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-8-0','1','1.120','1.120','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-8-0','1','1.120','1.110','1','1.120','1.110','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-YLXB-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-9-0','1','1.350','1.350','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-9-0','1','1.350','1.340','1','1.350','1.340','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-YLXB-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-10-0','1','1.350','1.350','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-10-0','1','1.350','1.340','1','1.350','1.340','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-YLXB-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-11-0','1','1.560','1.560','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-11-0','1','1.560','1.550','1','1.560','1.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-YLXB-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-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-20251204-0001','1','MTAT-YLXB-12-0','1','2.280','2.280','TOKO','BKATMT','TOKO','BTATMT');
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLXB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTATMT',tgl_last_beli='2025-12-04 09:29:55' WHERE kode_barang='MTAT-YLXB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTAT-YLXB-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 ('2025-12-04 09:29:55','TOKO','BTATMT','MTAT','MTAT-YLXB-12-0','1','2.280','2.270','1','2.280','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTAT-YLXB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXB-12-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:29','12.660','cashier1','2025-12-04 09:29:55');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTCN-YLXB-13-0','1','0.700','0.700','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-13-0','1','0.700','0.690','1','0.700','0.690','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-YLXB-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-14-0','1','0.580','0.580','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-14-0','1','0.580','0.570','1','0.580','0.570','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-YLXB-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-15-0','1','2.940','2.940','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-15-0','1','2.940','2.930','1','2.940','2.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-16-0','1','1.050','1.050','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-16-0','1','1.050','1.040','1','1.050','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-17-0','1','1.030','1.030','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-17-0','1','1.030','1.020','1','1.030','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-18-0','1','1.810','1.810','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-18-0','1','1.810','1.800','1','1.810','1.800','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-YLXB-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-19-0','1','3.220','3.220','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-19-0','1','3.220','3.210','1','3.220','3.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-20-0','1','2.540','2.540','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-20-0','1','2.540','2.530','1','2.540','2.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-21-0','1','1.180','1.180','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-21-0','1','1.180','1.170','1','1.180','1.170','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-YLXB-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-22-0','1','3.770','3.770','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-22-0','1','3.770','3.760','1','3.770','3.760','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-YLXB-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-23-0','1','1.020','1.020','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-23-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-YLXB-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-24-0','1','1.240','1.240','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-24-0','1','1.240','1.230','1','1.240','1.230','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-YLXB-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-25-0','1','1.040','1.040','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-25-0','1','1.040','1.030','1','1.040','1.030','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-YLXB-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-26-0','1','1.220','1.220','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-26-0','1','1.220','1.210','1','1.220','1.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-YLXB-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-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-20251204-0001','1','MTCN-YLXB-27-0','1','2.660','2.660','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-27-0','1','2.660','2.650','1','2.660','2.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-YLXB-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTCN-YLXB-28-0','1','2.190','2.190','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-YLXB-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2025-12-04 09:30:16' WHERE kode_barang='MTCN-YLXB-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-YLXB-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 ('2025-12-04 09:30:16','TOKO','BTCNMT','MTCN','MTCN-YLXB-28-0','1','2.190','2.180','1','2.190','2.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-YLXB-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXB-28-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:29','28.190','cashier1','2025-12-04 09:30:16');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTGL-YLXB-29-0','1','3.070','3.070','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-29-0','1','3.070','3.060','1','3.070','3.060','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-YLXB-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-29-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTGL-YLXB-30-0','1','2.970','2.970','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-30-0','1','2.970','2.960','1','2.970','2.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-YLXB-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-31-0','1','3.510','3.510','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-31-0','1','3.510','3.500','1','3.510','3.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-YLXB-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-32-0','1','4.470','4.470','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-32-0','1','4.470','4.460','1','4.470','4.460','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-YLXB-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-32-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTGL-YLXB-33-0','1','6.480','6.480','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-33-0','1','6.480','6.470','1','6.480','6.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-YLXB-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-34-0','1','3.030','3.030','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-34-0','1','3.030','3.020','1','3.030','3.020','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-YLXB-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-35-0','1','3.010','3.010','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-35-0','1','3.010','3.000','1','3.010','3.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-YLXB-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-36-0','1','5.000','5.000','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-36-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-YLXB-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-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-20251204-0001','1','MTGL-YLXB-37-0','1','9.170','9.170','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-YLXB-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2025-12-04 09:30:40' WHERE kode_barang='MTGL-YLXB-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-YLXB-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 ('2025-12-04 09:30:40','TOKO','BTGLMT','MTGL','MTGL-YLXB-37-0','1','9.170','9.160','1','9.170','9.160','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-YLXB-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXB-37-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:30','40.710','cashier1','2025-12-04 09:30:39');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTGW-YLXB-38-0','1','0.780','0.780','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-YLXB-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2025-12-04 09:30:58' WHERE kode_barang='MTGW-YLXB-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-YLXB-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 ('2025-12-04 09:30:58','TOKO','BTGWMT','MTGW','MTGW-YLXB-38-0','1','0.780','0.770','1','0.780','0.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-YLXB-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-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-20251204-0001','1','MTGW-YLXB-39-0','1','0.720','0.720','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-YLXB-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2025-12-04 09:30:58' WHERE kode_barang='MTGW-YLXB-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-YLXB-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 ('2025-12-04 09:30:58','TOKO','BTGWMT','MTGW','MTGW-YLXB-39-0','1','0.720','0.710','1','0.720','0.710','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-YLXB-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-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-20251204-0001','1','MTGW-YLXB-40-0','1','0.920','0.920','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-YLXB-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2025-12-04 09:30:58' WHERE kode_barang='MTGW-YLXB-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-YLXB-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 ('2025-12-04 09:30:58','TOKO','BTGWMT','MTGW','MTGW-YLXB-40-0','1','0.920','0.910','1','0.920','0.910','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-YLXB-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-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-20251204-0001','1','MTGW-YLXB-41-0','1','1.320','1.320','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-YLXB-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2025-12-04 09:30:58' WHERE kode_barang='MTGW-YLXB-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-YLXB-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 ('2025-12-04 09:30:58','TOKO','BTGWMT','MTGW','MTGW-YLXB-41-0','1','1.320','1.310','1','1.320','1.310','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-YLXB-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXB-41-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:30','3.740','cashier1','2025-12-04 09:30:57');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTKL-YLXB-42-0','1','4.940','4.940','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-YLXB-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2025-12-04 09:31:20' WHERE kode_barang='MTKL-YLXB-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-YLXB-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 ('2025-12-04 09:31:20','TOKO','BTKLMT','MTKL','MTKL-YLXB-42-0','1','4.940','4.930','1','4.940','4.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-YLXB-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-42-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTKL-YLXB-43-0','1','4.180','4.180','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-YLXB-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2025-12-04 09:31:20' WHERE kode_barang='MTKL-YLXB-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-YLXB-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 ('2025-12-04 09:31:20','TOKO','BTKLMT','MTKL','MTKL-YLXB-43-0','1','4.180','4.170','1','4.180','4.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-YLXB-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-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-20251204-0001','1','MTKL-YLXB-44-0','1','16.720','16.720','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-YLXB-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2025-12-04 09:31:20' WHERE kode_barang='MTKL-YLXB-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-YLXB-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 ('2025-12-04 09:31:20','TOKO','BTKLMT','MTKL','MTKL-YLXB-44-0','1','16.720','16.710','1','16.720','16.710','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-YLXB-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-YLXB-44-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:31','25.840','cashier1','2025-12-04 09:31:20');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDKL-YLXA-74-0','1','1.730','1.730','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-YLXA-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2025-12-04 09:31:40' WHERE kode_barang='MDKL-YLXA-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-YLXA-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 ('2025-12-04 09:31:40','TOKO','BTKLMD','MDKL','MDKL-YLXA-74-0','1','1.730','1.720','1','1.730','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-YLXA-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDKL-YLXA-75-0','1','1.960','1.960','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-YLXA-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2025-12-04 09:31:40' WHERE kode_barang='MDKL-YLXA-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-YLXA-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:31:40','TOKO','BTKLMD','MDKL','MDKL-YLXA-75-0','1','1.960','1.950','1','1.960','1.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-YLXA-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-75-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDKL-YLXA-76-0','1','3.020','3.020','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-YLXA-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2025-12-04 09:31:40' WHERE kode_barang='MDKL-YLXA-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-YLXA-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:31:40','TOKO','BTKLMD','MDKL','MDKL-YLXA-76-0','1','3.020','3.010','1','3.020','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-YLXA-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YLXA-76-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:31','6.710','cashier1','2025-12-04 09:31:39');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MSKL-YLXB-3-0','1','3.000','3.000','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-YLXB-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-YLXB-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2025-12-04 09:32:07' WHERE kode_barang='MSKL-YLXB-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-YLXB-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 ('2025-12-04 09:32:07','TOKO','BTKLMS','MSKL','MSKL-YLXB-3-0','1','3.000','2.990','1','3.000','2.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSKL-YLXB-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-YLXB-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-20251204-0001','1','MSKL-YLXB-4-0','1','7.170','7.170','TOKO','BKLMS','TOKO','BTKLMS');
DELETE FROM tm_barang WHERE kode_barang='MSKL-YLXB-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSKL-YLXB-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMS',tgl_last_beli='2025-12-04 09:32:07' WHERE kode_barang='MSKL-YLXB-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSKL-YLXB-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 ('2025-12-04 09:32:07','TOKO','BTKLMS','MSKL','MSKL-YLXB-4-0','1','7.170','7.160','1','7.170','7.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSKL-YLXB-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSKL-YLXB-4-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:31','10.170','cashier1','2025-12-04 09:32:07');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MTLT-YLXB-45-0','1','1.310','1.310','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-YLXB-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2025-12-04 09:32:36' WHERE kode_barang='MTLT-YLXB-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-YLXB-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 ('2025-12-04 09:32:36','TOKO','BTLTMT','MTLT','MTLT-YLXB-45-0','1','1.310','1.300','1','1.310','1.300','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-YLXB-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-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-20251204-0001','1','MTLT-YLXB-46-0','1','3.300','3.300','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-YLXB-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2025-12-04 09:32:36' WHERE kode_barang='MTLT-YLXB-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-YLXB-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 ('2025-12-04 09:32:36','TOKO','BTLTMT','MTLT','MTLT-YLXB-46-0','1','3.300','3.290','1','3.300','3.290','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-YLXB-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-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-20251204-0001','1','MTLT-YLXB-47-0','1','5.880','5.880','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-YLXB-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2025-12-04 09:32:36' WHERE kode_barang='MTLT-YLXB-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-YLXB-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 ('2025-12-04 09:32:36','TOKO','BTLTMT','MTLT','MTLT-YLXB-47-0','1','5.880','5.870','1','5.880','5.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-YLXB-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXB-47-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:32','10.490','cashier1','2025-12-04 09:32:35');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDLT-YLXA-77-0','1','1.270','1.270','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-YLXA-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2025-12-04 09:32:55' WHERE kode_barang='MDLT-YLXA-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-YLXA-77-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:32:55','TOKO','BTLTMD','MDLT','MDLT-YLXA-77-0','1','1.270','1.260','1','1.270','1.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-YLXA-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-77-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDLT-YLXA-78-0','1','1.200','1.200','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-YLXA-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2025-12-04 09:32:55' WHERE kode_barang='MDLT-YLXA-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-YLXA-78-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:32:55','TOKO','BTLTMD','MDLT','MDLT-YLXA-78-0','1','1.200','1.190','1','1.200','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-YLXA-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-78-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDLT-YLXA-79-0','1','1.510','1.510','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-YLXA-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2025-12-04 09:32:55' WHERE kode_barang='MDLT-YLXA-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-YLXA-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:32:55','TOKO','BTLTMD','MDLT','MDLT-YLXA-79-0','1','1.510','1.500','1','1.510','1.500','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-YLXA-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-79-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251204-0001','1','MDLT-YLXA-80-0','1','2.230','2.230','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-YLXA-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2025-12-04 09:32:55' WHERE kode_barang='MDLT-YLXA-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-YLXA-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-04 09:32:55','TOKO','BTLTMD','MDLT','MDLT-YLXA-80-0','1','2.230','2.220','1','2.230','2.220','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-YLXA-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-80-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251204-0001','2025-12-04','09:32','6.210','cashier1','2025-12-04 09:32:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-04 ','09:46:14');
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-251204-0004','sales','1',' EX ','TOKO','BTCNMT','MTCN-YHBH-117-0','CN ANAK CAP PLAT BT SHB ','','0.500','1','100.00','870000','0','0','0','870000','0','0','0','870000','2106','00026031','MTCN','209000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YHBH-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='MTCN-YHBH-117-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-251204-0004','2025-12-04','0.500','2025-12-04','10:08:26','PLG0017638','870000','870000','0','870000','870000','sales','2025-12-04 10:08:26','FJ-251204-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-04','FJ-251204-0004','2025-12-04','10:08:26','2106','870000','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-251204-0005','D','2025-12-04','10:08:26','sales','PENJUALAN','FJ-251204-0004','255802625','870000','256672625');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251204-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-04 ','13:56:30');
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-251204-0006','K','2025-12-04','14:16:57','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','256672625','51000','256621625');
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-251204-0007','K','2025-12-04','14:17:37','cashier1','PENGELUARAN','SUMBANGAN JUMAT MANIS ','256621625','5000','256616625');
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-251204-0005','sales','1',' ','TOKO','BTGLMT','MTGL-XCAI-165-0','GL ITALY ST SRT BT VC MRH 18CM KKT PER MK ','','3.310','1','100.00','5759500','0','0','0','5793500','34000','0','0','5793500','2503','00019562','MTGL','209000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-XCAI-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='MTGL-XCAI-165-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251204-0005','2025-12-04','3.310','2025-12-04','15:03:56','PLG0017639','5793500','5793500','0','5793500','5793500','sales','2025-12-04 15:03:55','FJ-251204-0005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-04','FJ-251204-0005','2025-12-04','15:03:56','2503','5793500','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-251204-0008','D','2025-12-04','15:03:56','sales','PENJUALAN','FJ-251204-0005','256616625','5793500','262410125');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251204-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251204-0005';