INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-03-10 ','08:29:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-10','140','0','-67050000','140','0','-67050000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-09' 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-260310-0001','D','2026-03-10','08:29:33','','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260310-0001','D','2026-03-10','08:29:33','BCA','SALDO AWAL','SALDO AWAL','0','1850079247','1850079247');
UPDATE tp_system SET tgl_system='2026-03-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-03-10 ','08:29:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-03-10 ','08:40:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-03-10 ','08:42:09');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0001','1','MTGL-YFAA-40-0','TOKO','BTGLMT','GL CATENA CDY 16CM KKT PER SHB ','1','1.940','RETUR BARANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 08:42:49',status_delete='1.930' WHERE kode_barang='MTGL-YFAA-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAA-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAA-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.940,berat_hancur_asli=berat_hancur_asli+1.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YFAA-40-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260310-0001','2026-03-10','admin','2026-03-10','08:42:49','admin','2026-03-10 08:42:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','08:49:35');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009271','X-00009271','CN PLINTIR SHB','GR','---','MTCN','BELI','BELI001','3429000','2026-03-10','1.830','1','sales','2026-03-10 09:50:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009271','X-00009271');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260310-0001','FJ-250115-0011','2403','1','BELI','BELI001','MTCN', 'X-00009271', 'CN PLINTIR SHB','1.880','1.830','100.00','2002500','3429000','1873770','1','3429000','3429000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-10','BELI','BELI001','MTCN','MTCN','100.00','1.830','1.830','1','1.830','1.830','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260310-0001','2026-03-10','2026-03-10','09:50:46','2403','---','1.830','3429000','3429000','3429000','3429000','3429000','sales','2026-03-10 09:50:46','FB-260310-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260310-0001','PIPIT','KEDINDING LOR PALEM 2/22','','','083853056520','sales','2026-03-10 09:50:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260310-0002','K','2026-03-10','09:50:46','sales','PEMBELIAN UMUM','FB-260310-0001','192453416','3429000','189024416','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260310-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260310-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','09:58:49');
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-260310-0002','1','X-00009267','BELI','BELI001','AT CAP VARIASI BT MK','1','1.740','3260500.00' ,'0.00','3260500','','3260500','3260500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-03-10 09:59:18' WHERE kode_barang='X-00009267' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009267' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009267' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.740',berat_hancur_asli=berat_hancur_asli+'1.740', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-260310-0002','2','X-00009268','BELI','BELI001','KL BAMBU 65CM KKT PER SHB','1','17.940','33619500.00' ,'0.00','33619500','','33619500','40140500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-03-10 09:59:18' WHERE kode_barang='X-00009268' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009268' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009268' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'17.940',berat_hancur_asli=berat_hancur_asli+'17.940', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'17.940',berat_akhir_asli=berat_akhir_asli-'17.940' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260310-0002','3','X-00009269','BELI','BELI001','AT TINDIK ARESO UBS','1','0.420','453000.00' ,'0.00','453000','','453000','74213000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-03-10 09:59:18' WHERE kode_barang='X-00009269' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009269' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009269' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.420',berat_hancur_asli=berat_hancur_asli+'0.420', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' 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-260310-0002','4','X-00009270','BELI','BELI001','AT TINDIK BTR SHB','1','0.280','460000.00' ,'0.00','460000','','460000','75126000','RUSAK ADA HILANG');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-03-10 09:59:18' WHERE kode_barang='X-00009270' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009270' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009270' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.280',berat_hancur_asli=berat_hancur_asli+'0.280', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-260310-0002','adminpusat','2026-03-10','2026-03-10','09:59:18','37793000','75126000', 'adminpusat','2026-03-10 09:59:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','10:14:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-03-10 ','10:45:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','10:59:16');
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-260310-0001','sales','1',' ','TOKO','BTCNMT','MTCN-ZBXI-64-0','CN COR ANAK BT SHB ','','0.720','1','100.00','1534000','0','0','0','1534000','0','0','0','1534000','2602','00027878','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZBXI-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MTCN-ZBXI-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260310-0001','2026-03-10','0.720','2026-03-10','11:15:36','PLG0018299','1534000','1534000','0','1534000','1534000','sales','2026-03-10 11:15:35','FJ-260310-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0001','2026-03-10','11:15:36','2602','1534000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260310-0003','D','2026-03-10','11:15:36','sales','PENJUALAN','FJ-260310-0001','189024416','1534000','190558416','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1534000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260310-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-260310-0002','sales',' 1',' ','TOKO','BTCNMT','MTCN-ZBXI-59-0','CN COR ANAK TDK BT SHB ','','0.670','1','100.00','1427500','0','0','0','1427500','0','0','0','1427500','2602','00027873','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZBXI-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MTCN-ZBXI-59-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-260310-0002','2026-03-10','0.670','2026-03-10','11:15:36','PLG0018300','1427500','1427500','0','1427500','1427500','sales','2026-03-10 11:15:35','FJ-260310-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0002','2026-03-10','11:15:36','2602','1427500','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-260310-0004','D','2026-03-10','11:15:36','sales','PENJUALAN','FJ-260310-0002','190558416','1427500','191985916','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1427500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260310-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-03-10 ','11:21:48');
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-260310-0003','sales','1',' ','TOKO','BTGLMT','MTGL-YCAD-63-0','GL CATENA CASTELI BTR 16CM KKT PER SHB ','','2.150','1','100.00','4579500','0','0','0','4579500','0','0','0','4579500','2403','00024223','MTGL','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-YCAD-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MTGL-YCAD-63-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-260310-0003','2026-03-10','2.150','2026-03-10','11:44:45','PLG0018301','4579500','4579500','0','4579500','4579500','sales','2026-03-10 11:44:45','FJ-260310-0003');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0003','2026-03-10','11:44:45','2403','4579500','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-260310-0005','D','2026-03-10','11:44:45','sales','PENJUALAN','FJ-260310-0003','191985916','4579500','196565416');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260310-0004','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-37-0','GL PAJERO MN LM5 16CM KKT PER SHB ','','5.020','1','100.00','6300500','0','0','0','6300500','0','0','0','6300500','2106','00027975','MDGL','176000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.020',berat_jual_asli=berat_jual_asli+'5.020',stock_jual='1',berat_akhir=berat_akhir-'5.020',berat_akhir_asli=berat_akhir_asli-'5.020',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MDGL-ZBAX-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260310-0004','2026-03-10','5.020','2026-03-10','12:06:28','PLG0018302','6300500','6300500','0','6300500','6300500','sales','2026-03-10 12:06:27','FJ-260310-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0004','2026-03-10','12:06:28','2106','6300500','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-260310-0006','D','2026-03-10','12:06:28','sales','PENJUALAN','FJ-260310-0004','196565416','6300500','202865916');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','12:15:32');
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-260310-0005','sales','1',' ','TOKO','BTLTMD','MDLT-ZBAI-108-0','LT COR FORTUNE LC2 ','','4.400','1','100.00','5522000','0','0','0','5522000','0','0','0','5522000','2403','00028484','MDLT','176000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.400',berat_jual_asli=berat_jual_asli+'4.400',stock_jual='1',berat_akhir=berat_akhir-'4.400',berat_akhir_asli=berat_akhir_asli-'4.400',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MDLT-ZBAI-108-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260310-0005','2026-03-10','4.400','2026-03-10','12:19:54','PLG0018303','5522000','5522000','0','5522000','5522000','sales','2026-03-10 12:19:54','FJ-260310-0005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0005','2026-03-10','12:19:54','2403','5522000','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-260310-0007','D','2026-03-10','12:19:54','sales','PENJUALAN','FJ-260310-0005','202865916','5522000','208387916');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','12:34:05');
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-260310-0006','sales','1',' EX ','TOKO','BTATMT','MTAT-ZBAC-7-0','AT TINDIK TOGE SHB ','','0.630','1','100.00','1342000','0','0','0','1342000','0','0','0','1342000','2105','00028131','MTAT','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-03-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZBAC-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-03-10' AND kode_barang='MTAT-ZBAC-7-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-260310-0006','2026-03-10','0.630','2026-03-10','13:29:24','PLG0018304','1342000','1342000','0','1342000','1342000','sales','2026-03-10 13:29:24','FJ-260310-0006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-10','FJ-260310-0006','2026-03-10','13:29:24','2105','1342000','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-260310-0008','D','2026-03-10','13:29:24','sales','PENJUALAN','FJ-260310-0006','208387916','1342000','209729916');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260310-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260310-0006';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009272','X-00009272','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','1443000','2026-03-10','1.750','1','sales','2026-03-10 13:40:22');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009272','X-00009272');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260310-0002','FJ-250907-0005','2103','1','BELI','BELI001','MDCN', 'X-00009272', 'CN COR TDK BT SHB','1.750','1.750','100.00','1479000','1443000','824571','1','1443000','1443000','RONGSOK');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-10','BELI','BELI001','MDCN','MDCN','100.00','1.750','1.750','1','1.750','1.750','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260310-0002','2026-03-10','2026-03-10','13:40:22','2103','---','1.750','1443000','1443000','1443000','1443000','1443000','sales','2026-03-10 13:40:22','FB-260310-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260310-0002','SYAKIRA','JL KALIANYAR KALIMER 1/6','','','081232633371','sales','2026-03-10 13:40:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260310-0009','K','2026-03-10','13:40:22','sales','PEMBELIAN UMUM','FB-260310-0002','209729916','1443000','208286916','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260310-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260310-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','15:22:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-03-10 ','15:29:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-03-10 ','15:42:59');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','1','MDAT-XKXH-123-0','TOKO','BTATMD','AT COR FORTUNE LC2 ','1','10.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='10.110' WHERE kode_barang='MDAT-XKXH-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-123-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.120,berat_hancur_asli=berat_hancur_asli+10.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-123-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','2','MDAT-XKXH-113-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.590' WHERE kode_barang='MDAT-XKXH-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-113-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','3','MDAT-XKXH-106-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.350' WHERE kode_barang='MDAT-XKXH-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-106-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.360,berat_hancur_asli=berat_hancur_asli+1.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-106-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','4','MDAT-XKXH-114-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.270' WHERE kode_barang='MDAT-XKXH-114-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-114-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-114-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.280,berat_hancur_asli=berat_hancur_asli+1.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-114-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','5','MDAT-XKXH-109-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.490' WHERE kode_barang='MDAT-XKXH-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-109-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','6','MDAT-XKXH-108-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.370' WHERE kode_barang='MDAT-XKXH-108-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-108-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-108-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.380,berat_hancur_asli=berat_hancur_asli+1.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-108-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','7','MDAT-XKXH-120-0','TOKO','BTATMD','AT COR KLP BT MK ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='2.060' WHERE kode_barang='MDAT-XKXH-120-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-120-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-120-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-120-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','8','MDAT-XGXD-7-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.410' WHERE kode_barang='MDAT-XGXD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XGXD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XGXD-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.420,berat_hancur_asli=berat_hancur_asli+1.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XGXD-7-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','9','MDAT-XKXH-121-0','TOKO','BTATMD','AT COR KLP BT MN BT MK ','1','1.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.620' WHERE kode_barang='MDAT-XKXH-121-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-121-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-121-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.630,berat_hancur_asli=berat_hancur_asli+1.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-121-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','10','MDAT-XKXH-112-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.170' WHERE kode_barang='MDAT-XKXH-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-112-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.180,berat_hancur_asli=berat_hancur_asli+1.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-112-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','11','MDAT-XKXD-58-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.030' WHERE kode_barang='MDAT-XKXD-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXD-58-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXD-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.040,berat_hancur_asli=berat_hancur_asli+1.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXD-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','12','MDAT-WHXE-8-0','TOKO','BTATMD','AT COR KLP BT SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.370' WHERE kode_barang='MDAT-WHXE-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-WHXE-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-WHXE-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.380,berat_hancur_asli=berat_hancur_asli+1.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-WHXE-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','13','MDAT-XHBI-1-0','TOKO','BTATMD','AT COR KLP BT UBS ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.430' WHERE kode_barang='MDAT-XHBI-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XHBI-1-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XHBI-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.440,berat_hancur_asli=berat_hancur_asli+1.440, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XHBI-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','14','MDAT-XLXC-2-0','TOKO','BTATMD','AT COR KAWAT BT MK ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.490' WHERE kode_barang='MDAT-XLXC-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XLXC-2-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XLXC-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XLXC-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','15','MDAT-YBBH-12-0','TOKO','BTATMD','AT CAP KAWAT BT MK ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.760' WHERE kode_barang='MDAT-YBBH-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBH-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBH-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.770,berat_hancur_asli=berat_hancur_asli+1.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YBBH-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','16','MDAT-XKXH-104-0','TOKO','BTATMD','AT CAP TDK BT SMBR PTH UBS ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='2.030' WHERE kode_barang='MDAT-XKXH-104-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-104-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-104-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.040,berat_hancur_asli=berat_hancur_asli+2.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-104-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','17','MDAT-XJAF-26-0','TOKO','BTATMD','AT TUSUK ITALY VC MRH MK ','1','1.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.270' WHERE kode_barang='MDAT-XJAF-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-26-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.280,berat_hancur_asli=berat_hancur_asli+1.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-26-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','18','MDAT-XJAF-14-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.400' WHERE kode_barang='MDAT-XJAF-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.410,berat_hancur_asli=berat_hancur_asli+1.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','19','MDAT-YBBF-5-0','TOKO','BTATMD','AT VAR BT BL CK SHB ','1','2.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='2.660' WHERE kode_barang='MDAT-YBBF-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBF-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBF-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.670,berat_hancur_asli=berat_hancur_asli+2.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YBBF-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','20','MDAT-YBBF-4-0','TOKO','BTATMD','AT VAR BT BL CK SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='2.100' WHERE kode_barang='MDAT-YBBF-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBF-4-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBF-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YBBF-4-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','21','MDAT-XJAF-10-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.330' WHERE kode_barang='MDAT-XJAF-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-10-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-10-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','22','MDAT-XJAF-20-0','TOKO','BTATMD','AT ITALY BT MK ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.330' WHERE kode_barang='MDAT-XJAF-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-20-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0003','23','MDAT-XIAD-9-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:48:11',status_delete='1.030' WHERE kode_barang='MDAT-XIAD-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XIAD-9-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XIAD-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.040,berat_hancur_asli=berat_hancur_asli+1.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XIAD-9-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260310-0003','2026-03-10','admin','2026-03-10','15:48:11','admin','2026-03-10 15:48:11');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','1','MDGL-XCAB-82-0','TOKO','BTGLMD','GL PIPA FORTUNE LC2 ','1','36.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='36.860' WHERE kode_barang='MDGL-XCAB-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XCAB-82-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XCAB-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+36.870,berat_hancur_asli=berat_hancur_asli+36.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XCAB-82-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','2','MDGL-YCAC-65-0','TOKO','BTGLMD','GL KRC PLINTIR SMBR PTH 3 UBS ','1','7.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='7.790' WHERE kode_barang='MDGL-YCAC-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YCAC-65-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YCAC-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.800,berat_hancur_asli=berat_hancur_asli+7.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YCAC-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','3','MDGL-XDXD-13-0','TOKO','BTGLMD','GL PIPA KERONCONG LC2 ','1','12.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='12.790' WHERE kode_barang='MDGL-XDXD-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XDXD-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XDXD-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+12.800,berat_hancur_asli=berat_hancur_asli+12.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XDXD-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','4','MDGL-XGXD-70-0','TOKO','BTGLMD','GL PIPA TDK BT LC2 ','1','11.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='11.070' WHERE kode_barang='MDGL-XGXD-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XGXD-70-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XGXD-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.080,berat_hancur_asli=berat_hancur_asli+11.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XGXD-70-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','5','MDGL-WHXG-14-0','TOKO','BTGLMD','GL PIPA BT UBS ','1','8.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='8.310' WHERE kode_barang='MDGL-WHXG-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-WHXG-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-WHXG-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.320,berat_hancur_asli=berat_hancur_asli+8.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-WHXG-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','6','MDGL-YBBG-12-0','TOKO','BTGLMD','GL RANG VAR BT 17CM KKT PER MK ','1','4.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='4.140' WHERE kode_barang='MDGL-YBBG-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBG-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBG-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.150,berat_hancur_asli=berat_hancur_asli+4.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBG-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','7','MDGL-YBBG-10-0','TOKO','BTGLMD','GL RANG VAR BT 17CM KKT PER MK ','1','3.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='3.830' WHERE kode_barang='MDGL-YBBG-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBG-10-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBG-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.840,berat_hancur_asli=berat_hancur_asli+3.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBG-10-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','8','MDGL-YBBG-11-0','TOKO','BTGLMD','GL RANG VAR BT 17CM KKT PER MK ','1','3.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='3.690' WHERE kode_barang='MDGL-YBBG-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBG-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBG-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.700,berat_hancur_asli=berat_hancur_asli+3.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBG-11-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','9','MDGL-YBBG-9-0','TOKO','BTGLMD','GL RANG VAR BT 17CM KKT PER MK ','1','4.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='4.040' WHERE kode_barang='MDGL-YBBG-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBG-9-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBG-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.050,berat_hancur_asli=berat_hancur_asli+4.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBG-9-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','10','MDGL-YFBX-27-0','TOKO','BTGLMD','GL PIPA BT UBS ','1','18.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='18.560' WHERE kode_barang='MDGL-YFBX-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YFBX-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YFBX-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+18.570,berat_hancur_asli=berat_hancur_asli+18.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YFBX-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','11','MDGL-WHXG-22-0','TOKO','BTGLMD','GL PIPA BT WRN SMBR PTH UBS ','1','10.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='10.030' WHERE kode_barang='MDGL-WHXG-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-WHXG-22-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-WHXG-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.040,berat_hancur_asli=berat_hancur_asli+10.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-WHXG-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','12','MDGL-YABE-33-0','TOKO','BTGLMD','GL PIPA BT UBS ','1','19.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='19.790' WHERE kode_barang='MDGL-YABE-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-33-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.800,berat_hancur_asli=berat_hancur_asli+19.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','13','MDGL-YABE-51-0','TOKO','BTGLMD','GL PLAT SMBR PTH UBS ','1','10.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='10.490' WHERE kode_barang='MDGL-YABE-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-51-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.500,berat_hancur_asli=berat_hancur_asli+10.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-51-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','14','MDGL-VDBI-31-0','TOKO','BTGLMD','GL PIPA TDK BT SMBR PTH UBS','1','10.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='10.040' WHERE kode_barang='MDGL-VDBI-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-VDBI-31-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-VDBI-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.050,berat_hancur_asli=berat_hancur_asli+10.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-VDBI-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','15','MDGL-YABE-23-0','TOKO','BTGLMD','GL KERONCONG ANAK PLTR 4 SHB','1','6.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='6.130' WHERE kode_barang='MDGL-YABE-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-23-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.140,berat_hancur_asli=berat_hancur_asli+6.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','16','MDGL-XKAA-46-0','TOKO','BTGLMD','GL RANGKAIAN COR BT 17CM UBS ','1','7.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='7.490' WHERE kode_barang='MDGL-XKAA-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XKAA-46-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XKAA-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.500,berat_hancur_asli=berat_hancur_asli+7.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XKAA-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','17','MDGL-YABE-12-0','TOKO','BTGLMD','GL RANGKAIAN VAR 17CM KKT PER SHB','1','3.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='3.480' WHERE kode_barang='MDGL-YABE-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.490,berat_hancur_asli=berat_hancur_asli+3.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','18','MDGL-YABE-21-0','TOKO','BTGLMD','GL RANGKAIAN VAR BT 18CM KKT PER MK','1','5.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='5.290' WHERE kode_barang='MDGL-YABE-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-21-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.300,berat_hancur_asli=berat_hancur_asli+5.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','19','MDGL-XKAA-39-0','TOKO','BTGLMD','GL RANGKAIAN VAR SMBR PTH 18CM KKT PER UBS ','1','6.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='6.250' WHERE kode_barang='MDGL-XKAA-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XKAA-39-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XKAA-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.260,berat_hancur_asli=berat_hancur_asli+6.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XKAA-39-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','20','MDGL-XKAA-40-0','TOKO','BTGLMD','GL RANGKAIAN VAR SMBR PTH 17CM KKT PER UBS ','1','5.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='5.480' WHERE kode_barang='MDGL-XKAA-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XKAA-40-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XKAA-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.490,berat_hancur_asli=berat_hancur_asli+5.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XKAA-40-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','21','MDGL-YKAI-2-0','TOKO','BTGLMD','GL FANCY DB MN 12 17CM KKT PER UBS ','1','7.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='7.250' WHERE kode_barang='MDGL-YKAI-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKAI-2-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YKAI-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.260,berat_hancur_asli=berat_hancur_asli+7.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YKAI-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','22','MDGL-XKAA-42-0','TOKO','BTGLMD','GL FANCY VAR BT MN6 16CM KKT S UBS ','1','10.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='10.050' WHERE kode_barang='MDGL-XKAA-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XKAA-42-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XKAA-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.060,berat_hancur_asli=berat_hancur_asli+10.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XKAA-42-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','23','MDGL-YABE-22-0','TOKO','BTGLMD','GL MOCCA VAR BT 18CM KKT PER MK','1','4.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='4.540' WHERE kode_barang='MDGL-YABE-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-22-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.550,berat_hancur_asli=berat_hancur_asli+4.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','24','MDGL-YABE-14-0','TOKO','BTGLMD','GL FANCY VAR 16CM KKT PER SHB ','1','3.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='3.050' WHERE kode_barang='MDGL-YABE-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.060,berat_hancur_asli=berat_hancur_asli+3.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','25','MDGL-YDAF-3-0','TOKO','BTGLMD','GL RANG VAR MN 4 19CM KKT PER UBS ','1','4.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='3.990' WHERE kode_barang='MDGL-YDAF-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YDAF-3-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YDAF-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.000,berat_hancur_asli=berat_hancur_asli+4.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YDAF-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','26','MDGL-YFBX-8-0','TOKO','BTGLMD','GL BTR SMBR PTH 17CM KKT PER UBS ','1','4.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='4.650' WHERE kode_barang='MDGL-YFBX-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YFBX-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YFBX-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.660,berat_hancur_asli=berat_hancur_asli+4.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YFBX-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','27','MDGL-XIAD-75-0','TOKO','BTGLMD','GL ITALY ST SRT BTR MN CAT 19CM KKT PER SHB ','1','2.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.860' WHERE kode_barang='MDGL-XIAD-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XIAD-75-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XIAD-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.870,berat_hancur_asli=berat_hancur_asli+2.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XIAD-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','28','MDGL-XEBD-49-0','TOKO','BTGLMD','GL ITALY ST SRT BTR 18CM KKT PER SHB ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.930' WHERE kode_barang='MDGL-XEBD-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XEBD-49-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XEBD-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XEBD-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','29','MDGL-YBBF-67-0','TOKO','BTGLMD','GL ITALY ST SRT VAR TDK BT 19CM KKT PER SHB ','1','2.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.310' WHERE kode_barang='MDGL-YBBF-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBF-67-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBF-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.320,berat_hancur_asli=berat_hancur_asli+2.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBF-67-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','30','MDGL-XFBG-25-0','TOKO','BTGLMD','GL ITALY ST SRT BTR 19CM KKT PER SHB','1','2.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.440' WHERE kode_barang='MDGL-XFBG-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XFBG-25-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XFBG-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.450,berat_hancur_asli=berat_hancur_asli+2.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XFBG-25-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','31','MDGL-XFBG-27-0','TOKO','BTGLMD','GL ITALY ST SRT BTR 19CM KKT PER SHB ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.900' WHERE kode_barang='MDGL-XFBG-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-XFBG-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-XFBG-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.910,berat_hancur_asli=berat_hancur_asli+2.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-XFBG-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','32','MDGL-YBBF-66-0','TOKO','BTGLMD','GL ITALY ST SRT VAR TDK BT 19CM KKT PER SHB ','1','2.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.010' WHERE kode_barang='MDGL-YBBF-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBF-66-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBF-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.020,berat_hancur_asli=berat_hancur_asli+2.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBF-66-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0004','33','MDGL-YBBF-74-0','TOKO','BTGLMD','GL ITALY ST VAR 17CM KKT PER SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 15:55:45',status_delete='2.100' WHERE kode_barang='MDGL-YBBF-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YBBF-74-0';
DELETE FROM tm_barang WHERE kode_barang='MDGL-YBBF-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YBBF-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260310-0004','2026-03-10','admin','2026-03-10','15:55:45','admin','2026-03-10 15:55:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-03-10 ','15:58:06');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','1','MTLT-WCBI-46-0','TOKO','BTLTMT','LT COR TDK BT SMBR PTH BG3 ','1','1.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.820' WHERE kode_barang='MTLT-WCBI-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WCBI-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WCBI-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.830,berat_hancur_asli=berat_hancur_asli+1.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WCBI-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','2','MTLT-XLBG-79-0','TOKO','BTLTMT','LT CAP PLAT TDK BT SHB ','1','1.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.560' WHERE kode_barang='MTLT-XLBG-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XLBG-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XLBG-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.570,berat_hancur_asli=berat_hancur_asli+1.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XLBG-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','3','MTLT-WCBI-49-0','TOKO','BTLTMT','LT COR TDK BT SMBR PTH BG3 ','1','2.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='2.460' WHERE kode_barang='MTLT-WCBI-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WCBI-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WCBI-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.470,berat_hancur_asli=berat_hancur_asli+2.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WCBI-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','4','MTLT-WCBI-35-0','TOKO','BTLTMT','LT COR TDK BT SMBR PTH BG3 ','1','1.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.780' WHERE kode_barang='MTLT-WCBI-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WCBI-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WCBI-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.790,berat_hancur_asli=berat_hancur_asli+1.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WCBI-35-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','5','MTLT-XBAE-37-0','TOKO','BTLTMT','LT CAP PLAT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.160' WHERE kode_barang='MTLT-XBAE-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBAE-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBAE-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.170,berat_hancur_asli=berat_hancur_asli+1.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBAE-37-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','6','MTLT-WACX-232-0','TOKO','BTLTMT','LT COR BT MK','1','0.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='0.940' WHERE kode_barang='MTLT-WACX-232-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-232-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-232-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.950,berat_hancur_asli=berat_hancur_asli+0.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-232-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','7','MTLT-WFXC-120-0','TOKO','BTLTMT','LT COR TDK BT SMBR PTH BG3 ','1','0.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='0.740' WHERE kode_barang='MTLT-WFXC-120-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WFXC-120-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WFXC-120-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.750,berat_hancur_asli=berat_hancur_asli+0.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WFXC-120-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','8','MTLT-XBBG-87-0','TOKO','BTLTMT','LT COR BT HURUF J SHB ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.390' WHERE kode_barang='MTLT-XBBG-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.400,berat_hancur_asli=berat_hancur_asli+1.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','9','MTLT-XBBG-90-0','TOKO','BTLTMT','LT COR BT HURUF P SHB ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.090' WHERE kode_barang='MTLT-XBBG-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','10','MTLT-XBBG-83-0','TOKO','BTLTMT','LT COR BT HURUF C SHB ','1','0.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='0.960' WHERE kode_barang='MTLT-XBBG-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-83-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','11','MTLT-XBBG-89-0','TOKO','BTLTMT','LT COR BT HURUF O SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='0.990' WHERE kode_barang='MTLT-XBBG-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-89-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','12','MTLT-WABX-79-0','TOKO','BTLTMT','LT COR BT HURUF P BT SHB','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.190' WHERE kode_barang='MTLT-WABX-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WABX-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WABX-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.200,berat_hancur_asli=berat_hancur_asli+1.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WABX-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','13','MTLT-WAXI-95-0','TOKO','BTLTMT','LT COR BT HURUF K SHB ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.590' WHERE kode_barang='MTLT-WAXI-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WAXI-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WAXI-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WAXI-95-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','14','MTLT-ULBD-110-0','TOKO','BTLTMT','LT COR HURUF T BT SHB ','1','1.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.170' WHERE kode_barang='MTLT-ULBD-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-ULBD-110-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-ULBD-110-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.180,berat_hancur_asli=berat_hancur_asli+1.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-ULBD-110-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','15','MTLT-VGXA-91-0','TOKO','BTLTMT','LT COR HURUF E BT SHB ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.050' WHERE kode_barang='MTLT-VGXA-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-VGXA-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-VGXA-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.060,berat_hancur_asli=berat_hancur_asli+1.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-VGXA-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','16','MTLT-VIXH-97-0','TOKO','BTLTMT','LT COR BT HURUF L SHB ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.250' WHERE kode_barang='MTLT-VIXH-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-VIXH-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-VIXH-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.260,berat_hancur_asli=berat_hancur_asli+1.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-VIXH-97-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','17','MTLT-XBBG-88-0','TOKO','BTLTMT','LT COR BT HURUF L SHB ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.210' WHERE kode_barang='MTLT-XBBG-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-88-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-88-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-88-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','18','MTLT-XBBG-82-0','TOKO','BTLTMT','LT COR BT HURUF B SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.340' WHERE kode_barang='MTLT-XBBG-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XBBG-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XBBG-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XBBG-82-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','19','MTLT-WACX-222-0','TOKO','BTLTMT','LT COR BT MK','1','1.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.130' WHERE kode_barang='MTLT-WACX-222-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-222-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-222-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.140,berat_hancur_asli=berat_hancur_asli+1.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-222-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','20','MTLT-WGBX-150-0','TOKO','BTLTMT','LT COR BT SHB ','1','3.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='3.410' WHERE kode_barang='MTLT-WGBX-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WGBX-150-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WGBX-150-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.420,berat_hancur_asli=berat_hancur_asli+3.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WGBX-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','21','MTLT-VJXF-125-0','TOKO','BTLTMT','LT COR BT MK','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.150' WHERE kode_barang='MTLT-VJXF-125-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-VJXF-125-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-VJXF-125-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-VJXF-125-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','22','MTLT-XACA-231-0','TOKO','BTLTMT','LT COR BT HURUF C SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.060' WHERE kode_barang='MTLT-XACA-231-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-231-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-231-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.070,berat_hancur_asli=berat_hancur_asli+1.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-231-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','23','MTLT-WIAE-64-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.280' WHERE kode_barang='MTLT-WIAE-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WIAE-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WIAE-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.290,berat_hancur_asli=berat_hancur_asli+1.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WIAE-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','24','MTLT-XACA-239-0','TOKO','BTLTMT','LT COR BT MK ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.350' WHERE kode_barang='MTLT-XACA-239-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-239-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-239-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.360,berat_hancur_asli=berat_hancur_asli+1.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-239-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','25','MTLT-WACX-234-0','TOKO','BTLTMT','LT COR BT MK','1','1.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.130' WHERE kode_barang='MTLT-WACX-234-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-234-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-234-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.140,berat_hancur_asli=berat_hancur_asli+1.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-234-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','26','MTLT-XACA-230-0','TOKO','BTLTMT','LT COR BT SHB ','1','2.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='2.380' WHERE kode_barang='MTLT-XACA-230-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-230-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-230-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.390,berat_hancur_asli=berat_hancur_asli+2.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-230-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','27','MTLT-XCBA-139-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.340' WHERE kode_barang='MTLT-XCBA-139-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XCBA-139-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XCBA-139-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XCBA-139-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','28','MTLT-WACX-235-0','TOKO','BTLTMT','LT COR BT SHB','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.250' WHERE kode_barang='MTLT-WACX-235-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-235-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-235-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.260,berat_hancur_asli=berat_hancur_asli+1.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-235-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','29','MTLT-WIAE-62-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.400' WHERE kode_barang='MTLT-WIAE-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WIAE-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WIAE-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.410,berat_hancur_asli=berat_hancur_asli+1.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WIAE-62-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','30','MTLT-XIXE-91-0','TOKO','BTLTMT','LT COR BT SHB ','1','2.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='2.270' WHERE kode_barang='MTLT-XIXE-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XIXE-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XIXE-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.280,berat_hancur_asli=berat_hancur_asli+2.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XIXE-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','31','MTLT-WACX-242-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.930' WHERE kode_barang='MTLT-WACX-242-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-242-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-242-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.940,berat_hancur_asli=berat_hancur_asli+1.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-242-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','32','MTLT-WIAE-65-0','TOKO','BTLTMT','LT COR BT MK','1','1.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.900' WHERE kode_barang='MTLT-WIAE-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WIAE-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WIAE-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.910,berat_hancur_asli=berat_hancur_asli+1.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WIAE-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','33','MTLT-XACA-241-0','TOKO','BTLTMT','LT COR BT MK ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.190' WHERE kode_barang='MTLT-XACA-241-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-241-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-241-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.200,berat_hancur_asli=berat_hancur_asli+1.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-241-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','34','MTLT-WACX-223-0','TOKO','BTLTMT','LT COR BT MK','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.150' WHERE kode_barang='MTLT-WACX-223-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-223-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-223-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-223-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','35','MTLT-XACA-234-0','TOKO','BTLTMT','LT COR BT MK ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.920' WHERE kode_barang='MTLT-XACA-234-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-234-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-234-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.930,berat_hancur_asli=berat_hancur_asli+1.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-234-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','36','MTLT-WACX-243-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.410' WHERE kode_barang='MTLT-WACX-243-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-WACX-243-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-WACX-243-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.420,berat_hancur_asli=berat_hancur_asli+1.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-WACX-243-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','37','MTLT-XACA-227-0','TOKO','BTLTMT','LT COR BT SHB ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='2.250' WHERE kode_barang='MTLT-XACA-227-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-227-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-227-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.260,berat_hancur_asli=berat_hancur_asli+2.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-227-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','38','MTLT-XACA-243-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.340' WHERE kode_barang='MTLT-XACA-243-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-243-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-243-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-243-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','39','MTLT-XCBA-137-0','TOKO','BTLTMT','LT COR BT SHB ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.430' WHERE kode_barang='MTLT-XCBA-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XCBA-137-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XCBA-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.440,berat_hancur_asli=berat_hancur_asli+1.440, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XCBA-137-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','40','MTLT-XACA-232-0','TOKO','BTLTMT','LT COR BT MK ','1','1.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.200' WHERE kode_barang='MTLT-XACA-232-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-XACA-232-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-XACA-232-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.210,berat_hancur_asli=berat_hancur_asli+1.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-XACA-232-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260310-0005','41','MTLT-VHCA-71-0','TOKO','BTLTMT','LT COR HURUF M BT SHB ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-03-10 16:06:11',status_delete='1.050' WHERE kode_barang='MTLT-VHCA-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTLT-VHCA-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTLT-VHCA-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.060,berat_hancur_asli=berat_hancur_asli+1.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMT' AND kode_barang='MTLT-VHCA-71-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260310-0005','2026-03-10','admin','2026-03-10','16:06:11','admin','2026-03-10 16:06:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-03-10 ','16:07:40');