INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','08:17:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-15 ','08:32:34');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-15','136','0','35100000','136','0','35100000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-14';
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-04-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-14' 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-260415-0001','D','2026-04-15','08:32:53','','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-260415-0001','D','2026-04-15','08:32:53','BCA','SALDO AWAL','SALDO AWAL','0','2093396747','2093396747');
UPDATE tp_system SET tgl_system='2026-04-15';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-15 ','08:33:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','08:38:10');
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-260415-0001','1','X-00009400','BELI','BELI001','CN PLINTIR SHB','1','1.400','2438500.00' ,'0.00','2438500','','2438500','2438500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-15 08:44:04' WHERE kode_barang='X-00009400' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009400' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009400' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260415-0001','2','X-00009401','BELI','BELI001','CN COR TDK BT SHB','1','1.450','2341500.00' ,'0.00','2341500','','2341500','7218500','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-15 08:44:04' WHERE kode_barang='X-00009401' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009401' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009401' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.450',berat_hancur_asli=berat_hancur_asli+'1.450', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260415-0001','3','X-00009402','BELI','BELI001','GL BABY PLINTIR TALI AIR 1 BEL SHB','1','2.370','2404000.00' ,'0.00','2404000','','2404000','11964000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-15 08:44:04' WHERE kode_barang='X-00009402' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009402' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009402' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.370',berat_hancur_asli=berat_hancur_asli+'2.370', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260415-0001','4','X-00009403','BELI','BELI001','GW COR TDK BT LC2','1','0.620','628500.00' ,'0.00','628500','','628500','14996500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-15 08:44:04' WHERE kode_barang='X-00009403' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009403' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009403' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.620',berat_hancur_asli=berat_hancur_asli+'0.620', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGW' 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-260415-0001','5','X-00009404','BELI','BELI001','CN CAP TDK BT DAUN SHB','1','0.630','509000.00' ,'0.00','509000','','509000','16134000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-15 08:44:04' WHERE kode_barang='X-00009404' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009404' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009404' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.630',berat_hancur_asli=berat_hancur_asli+'0.630', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260415-0001','adminpusat','2026-04-15','2026-04-15','08:44:05','8321500','16134000', 'adminpusat','2026-04-15 08:44:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-04-15 ','09:07:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','09:13:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','11:06:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','11:44:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','11:49:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','12:46:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','13:01:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-04-15 ','14:31:18');
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-260415-0001','sales','1',' EX ','TOKO','BTLTMT','MTLT-YFAH-189-0','LT COR FORTUNE BG3 ','','1.130','1','100.00','2237500','0','0','0','2237500','0','0','0','2237500','2501','00025271','MTLT','238000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-04-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTLT-YFAH-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-04-15' AND kode_barang='MTLT-YFAH-189-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMT' 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-260415-0001','2026-04-15','1.130','2026-04-15','14:35:43','PLG0018650','2237500','2237500','0','2237500','2237500','sales','2026-04-15 14:35:43','FJ-260415-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-04-15','FJ-260415-0001','2026-04-15','14:35:43','2501','2237500','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-260415-0002','D','2026-04-15','14:35:43','sales','PENJUALAN','FJ-260415-0001','168198170','2237500','170435670');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260415-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260415-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260415-0001';
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-260415-0002','1','MTAT-XEBD-99-0','TOKO','BTATMT','AT JODHA BT SHB ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.060' WHERE kode_barang='MTAT-XEBD-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XEBD-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XEBD-99-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 ='BTATMT' AND kode_barang='MTAT-XEBD-99-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-260415-0002','2','MTAT-VLBI-40-0','TOKO','BTATMT','AT PARWATI BTR SHB ','1','5.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='5.270' WHERE kode_barang='MTAT-VLBI-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-VLBI-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-VLBI-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.280,berat_hancur_asli=berat_hancur_asli+5.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-VLBI-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-260415-0002','3','MTAT-YAXF-2-0','TOKO','BTATMT','AT JEPSI MN HT MK ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.500' WHERE kode_barang='MTAT-YAXF-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXF-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXF-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.510,berat_hancur_asli=berat_hancur_asli+1.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXF-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-260415-0002','4','MTAT-XJAE-61-0','TOKO','BTATMT','AT JEPSI SLP KEMBANG SHB ','1','1.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.560' WHERE kode_barang='MTAT-XJAE-61-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-61-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-61-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 ='BTATMT' AND kode_barang='MTAT-XJAE-61-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-260415-0002','5','MTAT-YABH-35-0','TOKO','BTATMT','AT JEPSI PLS MK ','1','1.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.000' WHERE kode_barang='MTAT-YABH-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.010,berat_hancur_asli=berat_hancur_asli+1.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260415-0002','6','MTAT-YABH-40-0','TOKO','BTATMT','AT JEPSI DEWI 3 MN GANDUL MK ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.510' WHERE kode_barang='MTAT-YABH-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.520,berat_hancur_asli=berat_hancur_asli+1.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260415-0002','7','MTAT-XKBH-7-0','TOKO','BTATMT','AT JEPSI POLOS MK ','1','0.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='0.540' WHERE kode_barang='MTAT-XKBH-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.550,berat_hancur_asli=berat_hancur_asli+0.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-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-260415-0002','8','MTAT-VCAX-2-0','TOKO','BTATMT','AT TINDIK TALI AIR SHB ','1','0.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='0.550' WHERE kode_barang='MTAT-VCAX-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-VCAX-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-VCAX-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.560,berat_hancur_asli=berat_hancur_asli+0.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-VCAX-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-260415-0002','9','MTAT-XJAE-56-0','TOKO','BTATMT','AT TINDIK PLS SHB ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='0.510' WHERE kode_barang='MTAT-XJAE-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-56-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJAE-56-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-260415-0002','10','MTAT-XLBG-19-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='0.510' WHERE kode_barang='MTAT-XLBG-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-19-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-260415-0002','11','MTAT-XJAE-67-0','TOKO','BTATMT','AT COR KAWAT BT SHB ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.420' WHERE kode_barang='MTAT-XJAE-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-67-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.430,berat_hancur_asli=berat_hancur_asli+1.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJAE-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-260415-0002','12','MTAT-WKBA-17-0','TOKO','BTATMT','AT COR KAWAT BT SHB ','1','1.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.560' WHERE kode_barang='MTAT-WKBA-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WKBA-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WKBA-17-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 ='BTATMT' AND kode_barang='MTAT-WKBA-17-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-260415-0002','13','MTAT-WHAE-3-0','TOKO','BTATMT','AT ANAK CAT SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.060' WHERE kode_barang='MTAT-WHAE-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WHAE-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WHAE-3-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 ='BTATMT' AND kode_barang='MTAT-WHAE-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-260415-0002','14','MTAT-WIXD-19-0','TOKO','BTATMT','AT ANAK CAT SHB ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.010' WHERE kode_barang='MTAT-WIXD-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-19-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-260415-0002','15','MTAT-XCBA-58-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.060' WHERE kode_barang='MTAT-XCBA-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XCBA-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XCBA-58-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 ='BTATMT' AND kode_barang='MTAT-XCBA-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-260415-0002','16','MTAT-XBBF-13-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.060' WHERE kode_barang='MTAT-XBBF-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XBBF-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XBBF-13-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 ='BTATMT' AND kode_barang='MTAT-XBBF-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-260415-0002','17','MTAT-XBBF-22-0','TOKO','BTATMT','AT COR ANAK CAT BT MK ','1','1.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.560' WHERE kode_barang='MTAT-XBBF-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XBBF-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XBBF-22-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 ='BTATMT' AND kode_barang='MTAT-XBBF-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-260415-0002','18','MTAT-XBBF-21-0','TOKO','BTATMT','AT COR ANAK CAT BT MK ','1','1.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.550' WHERE kode_barang='MTAT-XBBF-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XBBF-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XBBF-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.560,berat_hancur_asli=berat_hancur_asli+1.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XBBF-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-260415-0002','19','MTAT-WEAB-50-0','TOKO','BTATMT','AT ANAK CAT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='0.850' WHERE kode_barang='MTAT-WEAB-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WEAB-50-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WEAB-50-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.860,berat_hancur_asli=berat_hancur_asli+0.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WEAB-50-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-260415-0002','20','MTAT-UDAF-123-0','TOKO','BTATMT','AT CAT ANK SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.030' WHERE kode_barang='MTAT-UDAF-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-UDAF-123-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-UDAF-123-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 ='BTATMT' AND kode_barang='MTAT-UDAF-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-260415-0002','21','MTAT-XBBF-17-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.020' WHERE kode_barang='MTAT-XBBF-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XBBF-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XBBF-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XBBF-17-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-260415-0002','22','MTAT-XCBA-67-0','TOKO','BTATMT','AT CAP KWT BTR BLB BT SHB ','1','2.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.230' WHERE kode_barang='MTAT-XCBA-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XCBA-67-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XCBA-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.240,berat_hancur_asli=berat_hancur_asli+2.240, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XCBA-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-260415-0002','23','MTAT-WIXD-24-0','TOKO','BTATMT','AT COR KAWAT BT SHB ','1','1.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.690' WHERE kode_barang='MTAT-WIXD-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.700,berat_hancur_asli=berat_hancur_asli+1.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-24-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-260415-0002','24','MTAT-YABH-24-0','TOKO','BTATMT','AT COR KLP TDK BT SHB ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.040' WHERE kode_barang='MTAT-YABH-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-24-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-260415-0002','25','MTAT-WIXD-23-0','TOKO','BTATMT','AT COR KLP BT AD MERAH SHB ','1','3.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='3.270' WHERE kode_barang='MTAT-WIXD-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.280,berat_hancur_asli=berat_hancur_asli+3.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-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-260415-0002','26','MTAT-WKBA-6-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.790' WHERE kode_barang='MTAT-WKBA-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WKBA-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WKBA-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.800,berat_hancur_asli=berat_hancur_asli+1.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WKBA-6-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-260415-0002','27','MTAT-XACA-14-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.370' WHERE kode_barang='MTAT-XACA-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-14-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 ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','28','MTAT-XABD-2-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.280' WHERE kode_barang='MTAT-XABD-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XABD-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XABD-2-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 ='BTATMT' AND kode_barang='MTAT-XABD-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-260415-0002','29','MTAT-VKXC-7-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.160' WHERE kode_barang='MTAT-VKXC-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-VKXC-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-VKXC-7-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 ='BTATMT' AND kode_barang='MTAT-VKXC-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-260415-0002','30','MTAT-XACA-6-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.200' WHERE kode_barang='MTAT-XACA-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.210,berat_hancur_asli=berat_hancur_asli+2.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-6-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-260415-0002','31','MTAT-XACA-11-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.410' WHERE kode_barang='MTAT-XACA-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-11-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 ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','32','MTAT-WACX-45-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.770' WHERE kode_barang='MTAT-WACX-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WACX-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WACX-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.780,berat_hancur_asli=berat_hancur_asli+1.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WACX-45-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-260415-0002','33','MTAT-XACA-15-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.530' WHERE kode_barang='MTAT-XACA-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.540,berat_hancur_asli=berat_hancur_asli+1.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-15-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-260415-0002','34','MTAT-WACX-56-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.100' WHERE kode_barang='MTAT-WACX-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WACX-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WACX-56-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 ='BTATMT' AND kode_barang='MTAT-WACX-56-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-260415-0002','35','MTAT-VLAX-8-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.460' WHERE kode_barang='MTAT-VLAX-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-VLAX-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-VLAX-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.470,berat_hancur_asli=berat_hancur_asli+1.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-VLAX-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-260415-0002','36','MTAT-XACA-16-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.080' WHERE kode_barang='MTAT-XACA-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.090,berat_hancur_asli=berat_hancur_asli+2.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-16-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-260415-0002','37','MTAT-WACX-52-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.340' WHERE kode_barang='MTAT-WACX-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WACX-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WACX-52-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 ='BTATMT' AND kode_barang='MTAT-WACX-52-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-260415-0002','38','MTAT-XACA-5-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.690' WHERE kode_barang='MTAT-XACA-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.700,berat_hancur_asli=berat_hancur_asli+1.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','39','MTAT-XKXG-4-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.410' WHERE kode_barang='MTAT-XKXG-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-4-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 ='BTATMT' AND kode_barang='MTAT-XKXG-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-260415-0002','40','MTAT-WIXD-2-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.150' WHERE kode_barang='MTAT-WIXD-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-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-260415-0002','41','MTAT-WGBX-7-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.310' WHERE kode_barang='MTAT-WGBX-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WGBX-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WGBX-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.320,berat_hancur_asli=berat_hancur_asli+1.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WGBX-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-260415-0002','42','MTAT-XACA-7-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.430' WHERE kode_barang='MTAT-XACA-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-7-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 ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','43','MTAT-XACA-2-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.380' WHERE kode_barang='MTAT-XACA-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.390,berat_hancur_asli=berat_hancur_asli+1.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','44','MTAT-XACA-10-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.120' WHERE kode_barang='MTAT-XACA-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XACA-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XACA-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XACA-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-260415-0002','45','MTAT-WACX-37-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.570' WHERE kode_barang='MTAT-WACX-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WACX-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WACX-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.580,berat_hancur_asli=berat_hancur_asli+1.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WACX-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-260415-0002','46','MTAT-WIXD-1-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.150' WHERE kode_barang='MTAT-WIXD-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-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-260415-0002','47','MTAT-XCBA-62-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.970' WHERE kode_barang='MTAT-XCBA-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XCBA-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XCBA-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.980,berat_hancur_asli=berat_hancur_asli+1.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XCBA-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-260415-0002','48','MTAT-WIXD-9-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.520' WHERE kode_barang='MTAT-WIXD-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.530,berat_hancur_asli=berat_hancur_asli+1.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-WIXD-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-260415-0002','49','MTAT-WIAE-3-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.250' WHERE kode_barang='MTAT-WIAE-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIAE-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIAE-3-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 ='BTATMT' AND kode_barang='MTAT-WIAE-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-260415-0002','50','MTAT-WIXD-5-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.330' WHERE kode_barang='MTAT-WIXD-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WIXD-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WIXD-5-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 ='BTATMT' AND kode_barang='MTAT-WIXD-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-260415-0002','51','MTAT-WEAX-31-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='1.280' WHERE kode_barang='MTAT-WEAX-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-WEAX-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-WEAX-31-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 ='BTATMT' AND kode_barang='MTAT-WEAX-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-260415-0002','52','MTAT-XCAD-20-0','TOKO','BTATMT','AT TUSUK ITALY VC BTG ','1','2.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:42:43',status_delete='2.170' WHERE kode_barang='MTAT-XCAD-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XCAD-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XCAD-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.180,berat_hancur_asli=berat_hancur_asli+2.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XCAD-20-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-260415-0002','2026-04-15','admin','2026-04-15','14:42:43','admin','2026-04-15 14:42:43');
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-260415-0003','1','MSCN-WEBD-14-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.810' WHERE kode_barang='MSCN-WEBD-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-14-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-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-260415-0003','2','MSCN-YBBH-85-0','TOKO','BTCNMS','CN COR BT MK ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.140' WHERE kode_barang='MSCN-YBBH-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-YBBH-85-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-YBBH-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.150,berat_hancur_asli=berat_hancur_asli+1.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-YBBH-85-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-260415-0003','3','MSCN-WHAH-1-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.860' WHERE kode_barang='MSCN-WHAH-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WHAH-1-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WHAH-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.870,berat_hancur_asli=berat_hancur_asli+0.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WHAH-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-260415-0003','4','MSCN-XKAB-3-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.750' WHERE kode_barang='MSCN-XKAB-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-XKAB-3-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-XKAB-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.760,berat_hancur_asli=berat_hancur_asli+0.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-XKAB-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-260415-0003','5','MSCN-YAXD-1-0','TOKO','BTCNMS','CN COR BT MK ','1','1.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.070' WHERE kode_barang='MSCN-YAXD-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-YAXD-1-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-YAXD-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-YAXD-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-260415-0003','6','MSCN-WJAB-1-0','TOKO','BTCNMS','CN COR BT SHB ','1','1.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.130' WHERE kode_barang='MSCN-WJAB-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WJAB-1-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WJAB-1-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 ='BTCNMS' AND kode_barang='MSCN-WJAB-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-260415-0003','7','MSCN-WEBD-11-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.740' WHERE kode_barang='MSCN-WEBD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-11-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 ='BTCNMS' AND kode_barang='MSCN-WEBD-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-260415-0003','8','MSCN-WEBD-37-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.910' WHERE kode_barang='MSCN-WEBD-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-37-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.920,berat_hancur_asli=berat_hancur_asli+0.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-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-260415-0003','9','MSCN-WEBD-38-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.870' WHERE kode_barang='MSCN-WEBD-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-38-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-38-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-260415-0003','10','MSCN-WEBD-15-0','TOKO','BTCNMS','CN COR BT SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.990' WHERE kode_barang='MSCN-WEBD-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-15-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-15-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 ='BTCNMS' AND kode_barang='MSCN-WEBD-15-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-260415-0003','11','MSCN-WEBD-19-0','TOKO','BTCNMS','CN COR BT SHB','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.890' WHERE kode_barang='MSCN-WEBD-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-19-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-19-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-260415-0003','12','MSCN-XJAE-52-0','TOKO','BTCNMS','CN COR BT MK ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.930' WHERE kode_barang='MSCN-XJAE-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-XJAE-52-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-XJAE-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-XJAE-52-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-260415-0003','13','MSCN-WEBD-12-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.810' WHERE kode_barang='MSCN-WEBD-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-12-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-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-260415-0003','14','MSCN-WEBD-31-0','TOKO','BTCNMS','CN COR BT SHB ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='0.930' WHERE kode_barang='MSCN-WEBD-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-WEBD-31-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-WEBD-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-WEBD-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-260415-0003','15','MSCN-YABE-58-0','TOKO','BTCNMS','CN COR BT SHB ','1','1.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.560' WHERE kode_barang='MSCN-YABE-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-YABE-58-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-YABE-58-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 ='BTCNMS' AND kode_barang='MSCN-YABE-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-260415-0003','16','MSCN-YABE-56-0','TOKO','BTCNMS','CN COR BT SHB ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.420' WHERE kode_barang='MSCN-YABE-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-YABE-56-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-YABE-56-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.430,berat_hancur_asli=berat_hancur_asli+1.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-YABE-56-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-260415-0003','17','MSCN-XCBB-1-0','TOKO','BTCNMS','CN COR BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:49:16',status_delete='1.320' WHERE kode_barang='MSCN-XCBB-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSCN-XCBB-1-0';
DELETE FROM tm_barang WHERE kode_barang='MSCN-XCBB-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.330,berat_hancur_asli=berat_hancur_asli+1.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMS' AND kode_barang='MSCN-XCBB-1-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-260415-0003','2026-04-15','admin','2026-04-15','14:49:16','admin','2026-04-15 14:49:16');
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-260415-0004','1','MSGL-YHBG-6-0','TOKO','BTGLMS','GL FANCY DB MN5 17CM KKT PER SHB ','1','1.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:52:13',status_delete='1.960' WHERE kode_barang='MSGL-YHBG-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSGL-YHBG-6-0';
DELETE FROM tm_barang WHERE kode_barang='MSGL-YHBG-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.970,berat_hancur_asli=berat_hancur_asli+1.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMS' AND kode_barang='MSGL-YHBG-6-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-260415-0004','2','MSGL-YHBG-5-0','TOKO','BTGLMS','GL PLINTIR SHB ','1','9.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:52:13',status_delete='9.840' WHERE kode_barang='MSGL-YHBG-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSGL-YHBG-5-0';
DELETE FROM tm_barang WHERE kode_barang='MSGL-YHBG-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.850,berat_hancur_asli=berat_hancur_asli+9.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMS' AND kode_barang='MSGL-YHBG-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-260415-0004','3','MSGL-XKAB-22-0','TOKO','BTGLMS','GL PLINTIR SHB ','1','6.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:52:13',status_delete='6.850' WHERE kode_barang='MSGL-XKAB-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSGL-XKAB-22-0';
DELETE FROM tm_barang WHERE kode_barang='MSGL-XKAB-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.860,berat_hancur_asli=berat_hancur_asli+6.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMS' AND kode_barang='MSGL-XKAB-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-260415-0004','4','MSGL-WKBX-5-0','TOKO','BTGLMS','GL PLINTIR SHB ','1','19.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-15 14:52:13',status_delete='19.630' WHERE kode_barang='MSGL-WKBX-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MSGL-WKBX-5-0';
DELETE FROM tm_barang WHERE kode_barang='MSGL-WKBX-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.640,berat_hancur_asli=berat_hancur_asli+19.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMS' AND kode_barang='MSGL-WKBX-5-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-260415-0004','2026-04-15','admin','2026-04-15','14:52:13','admin','2026-04-15 14:52:13');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260415-0003','K','2026-04-15','15:49:15','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','170435670','54000','170381670');
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-00009405','X-00009405','LT COR WRN UBS','GR','---','MDLT','BELI','BELI001','2272000','2026-04-15','2.240','1','sales','2026-04-15 16:01:24');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00009405','X-00009405');
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-260415-0001','FJ-260111-0004','2103','1','BELI','BELI001','MDLT', 'X-00009405', 'LT COR WRN UBS','2.240','2.240','100.00','2419500','2272000','1014286','1','2272000','2272000','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-04-15','BELI','BELI001','MDLT','MDLT','100.00','2.240','2.240','1','2.240','2.240','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-260415-0001','2026-04-15','2026-04-15','16:01:23','2103','---','2.240','2272000','2272000','2272000','2272000','2272000','sales','2026-04-15 16:01:24','FB-260415-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260415-0001','MARHAMA','BNDR SUGIAN TNDS GOWOK 4C','','','','sales','2026-04-15 16:01:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-15' 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-260415-0004','K','2026-04-15','16:01:23','sales','PEMBELIAN UMUM','FB-260415-0001','170381670','2272000','168109670','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260415-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260415-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-15 ','16:24:26');