INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-22 ','08:34:14');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-22','136','0','53800000','136','0','53800000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-21';
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-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-21' 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-260422-0001','D','2026-04-22','08:34:26','','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-260422-0001','D','2026-04-22','08:34:26','BCA','SALDO AWAL','SALDO AWAL','0','2097137747','2097137747');
UPDATE tp_system SET tgl_system='2026-04-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-22 ','08:34:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','08:43:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-04-22 ','09:08:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','09:16:35');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260422-0001','sales','1',' ','TOKO','BTGLMD','MDGL-ZBBX-65-0','GL PIPA BT UBS ','','2.890','1','100.00','3410500','0','0','0','3410500','0','0','0','3410500','2103','00028613','MDGL','165500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-04-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBBX-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-04-22' AND kode_barang='MDGL-ZBBX-65-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-260422-0001','2026-04-22','2.890','2026-04-22','09:46:05','PLG0018688','3410500','3410500','0','3410500','3410500','sales','2026-04-22 09:46:05','FJ-260422-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-22','FJ-260422-0001','2026-04-22','09:46:05','2103','3410500','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-260422-0002','D','2026-04-22','09:46:05','sales','PENJUALAN','FJ-260422-0001','236170170','3410500','239580670');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260422-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260422-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260422-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-04-22 ','11:07:52');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0002','K','2026-04-22','11:09:00','BCA','PENGELUARAN','SEWA STAN KAPASAN APR 2026 S/D MAR 2027','2097137747','90000000','2007137747');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0003','K','2026-04-22','11:10:25','BCA','PENGELUARAN','BPJS KESEHATAN','2007137747','266940','2006870807');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0004','K','2026-04-22','11:10:43','BCA','PENGELUARAN','GOOGLE WORKSPACE','2006870807','967799','2005903008');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0005','K','2026-04-22','11:10:59','BCA','PENGELUARAN','TELKOM 0313716972','2005903008','386616','2005516392');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0006','K','2026-04-22','11:11:12','BCA','PENGELUARAN','TELKOM 0313716832','2005516392','42516','2005473876');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260422-0007','K','2026-04-22','11:11:34','BCA','PENGELUARAN','ORBIT 082137813887 100RB','2005473876','99600','2005374276');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','12:33:24');
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-260422-0001','1','X-00009413','BELI','BELI001','CN COR BT UBS','1','2.490','4021000.00' ,'0.00','4021000','','4021000','4021000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-22 12:33:50' WHERE kode_barang='X-00009413' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009413' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009413' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.490',berat_hancur_asli=berat_hancur_asli+'2.490', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260422-0001','adminpusat','2026-04-22','2026-04-22','12:33:50','4021000','4021000', 'adminpusat','2026-04-22 12:33:50');
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-00009414','X-00009414','CN COR TDK BT LC2','GR','---','MDCN','BELI','BELI001','2029000','2026-04-22','2.000','1','sales','2026-04-22 12:54:10');
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-00009414','X-00009414');
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-260422-0001','FJ-250726-0008','2403','1','BELI','BELI001','MDCN', 'X-00009414', 'CN COR TDK BT LC2','2.000','2.000','100.00','1620000','2029000','1014500','1','2029000','2029000','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-22','BELI','BELI001','MDCN','MDCN','100.00','2.000','2.000','1','2.000','2.000','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-260422-0001','2026-04-22','2026-04-22','12:54:10','2403','---','2.000','2029000','2029000','2029000','2029000','2029000','sales','2026-04-22 12:54:10','FB-260422-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260422-0001','MARYAM','GEMBONG 2/39','','','','sales','2026-04-22 12:54:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-22' 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-260422-0003','K','2026-04-22','12:54:10','sales','PEMBELIAN UMUM','FB-260422-0001','239580670','2029000','237551670','OPEN');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009415','X-00009415','LT COR SMBR PTH BG3','GR','---','MDLT','BELI','BELI001','1744500','2026-04-22','1.720','1','sales','2026-04-22 12:54:10');
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-00009415','X-00009415');
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-260422-0002','FJ-250514-0002','2403','2','BELI','BELI001','MDLT', 'X-00009415', 'LT COR SMBR PTH BG3','1.720','1.720','100.00','1389000','1744500','1014244','1','1744500','1744500','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-22','BELI','BELI001','MDLT','MDLT','100.00','1.720','1.720','1','1.720','1.720','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-260422-0002','2026-04-22','2026-04-22','12:54:10','2403','---','1.720','1744500','1744500','1744500','1744500','1744500','sales','2026-04-22 12:54:10','FB-260422-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260422-0002','MARIAM','GEMBONG 2/39','','','','sales','2026-04-22 12:54:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-22' 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-260422-0004','K','2026-04-22','12:54:10','sales','PEMBELIAN UMUM','FB-260422-0002','237551670','1744500','235807170','OPEN');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009416','X-00009416','CN PLINTIR SHB','GR','---','MDCN','BELI','BELI001','2453000','2026-04-22','2.600','1','sales','2026-04-22 12:54:10');
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-00009416','X-00009416');
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-260422-0003','FJ-250726-0007','2403','3','BELI','BELI001','MDCN', 'X-00009416', 'CN PLINTIR SHB','2.600','2.600','100.00','2106000','2453000','943462','1','2453000','2453000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.600',berat_beli_asli=berat_beli_asli+'2.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.600',berat_akhir_asli=berat_akhir_asli+'2.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260422-0003','2026-04-22','2026-04-22','12:54:10','2403','---','2.600','2453000','2453000','2453000','2453000','2453000','sales','2026-04-22 12:54:10','FB-260422-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260422-0003','MARYAM','GEMBONG 2/39','','','','sales','2026-04-22 12:54:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-22' 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-260422-0005','K','2026-04-22','12:54:10','sales','PEMBELIAN UMUM','FB-260422-0003','235807170','2453000','233354170','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260422-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260422-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260422-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260422-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260422-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260422-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-04-22 ','13:03:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-04-22 ','13:08:52');
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-260422-0002','1','MTCN-XGCA-18-0','TOKO','BTCNMT','CN COR ANAK CAT MK ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.930' WHERE kode_barang='MTCN-XGCA-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XGCA-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XGCA-18-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 ='BTCNMT' AND kode_barang='MTCN-XGCA-18-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-260422-0002','2','MTCN-XCBC-79-0','TOKO','BTCNMT','CN ANAK BRILLIANT SHB ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.510' WHERE kode_barang='MTCN-XCBC-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XCBC-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XCBC-79-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 ='BTCNMT' AND kode_barang='MTCN-XCBC-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-260422-0002','3','MTCN-XKBH-82-0','TOKO','BTCNMT','CN CAP PLAT ANAK TDK BT SHB ','1','0.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.520' WHERE kode_barang='MTCN-XKBH-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XKBH-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XKBH-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XKBH-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-260422-0002','4','MTCN-WGBX-37-0','TOKO','BTCNMT','CN COR ANAK KIT M UBS ','1','1.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.620' WHERE kode_barang='MTCN-WGBX-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WGBX-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WGBX-37-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 ='BTCNMT' AND kode_barang='MTCN-WGBX-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-260422-0002','5','MTCN-XLXB-13-0','TOKO','BTCNMT','CN ANAK CAP PLAT TDK BT SHB ','1','0.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.520' WHERE kode_barang='MTCN-XLXB-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260422-0002','6','MTCN-XCBC-78-0','TOKO','BTCNMT','CN ANAK CAT MK ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.950' WHERE kode_barang='MTCN-XCBC-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XCBC-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XCBC-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.960,berat_hancur_asli=berat_hancur_asli+0.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XCBC-78-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-260422-0002','7','MTCN-XGXC-28-0','TOKO','BTCNMT','CN ANAK COR BT MK ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.810' WHERE kode_barang='MTCN-XGXC-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XGXC-28-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XGXC-28-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 ='BTCNMT' AND kode_barang='MTCN-XGXC-28-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-260422-0002','8','MTCN-WDXC-3-0','TOKO','BTCNMT','CN ANAK CAT SHB ','1','0.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.730' WHERE kode_barang='MTCN-WDXC-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WDXC-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WDXC-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.740,berat_hancur_asli=berat_hancur_asli+0.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WDXC-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-260422-0002','9','MTCN-WGAH-127-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.640' WHERE kode_barang='MTCN-WGAH-127-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WGAH-127-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WGAH-127-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.650,berat_hancur_asli=berat_hancur_asli+5.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WGAH-127-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-260422-0002','10','MTCN-WCBH-96-0','TOKO','BTCNMT','CN COR EROPA UBS ','1','4.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='4.540' WHERE kode_barang='MTCN-WCBH-96-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WCBH-96-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WCBH-96-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 ='BTCNMT' AND kode_barang='MTCN-WCBH-96-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-260422-0002','11','MTCN-XABD-32-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.290' WHERE kode_barang='MTCN-XABD-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XABD-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XABD-32-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 ='BTCNMT' AND kode_barang='MTCN-XABD-32-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-260422-0002','12','MTCN-WCBH-97-0','TOKO','BTCNMT','CN COR EROPA UBS ','1','6.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='6.740' WHERE kode_barang='MTCN-WCBH-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WCBH-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WCBH-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.750,berat_hancur_asli=berat_hancur_asli+6.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WCBH-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-260422-0002','13','MTCN-VGXA-111-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.930' WHERE kode_barang='MTCN-VGXA-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VGXA-111-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VGXA-111-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 ='BTCNMT' AND kode_barang='MTCN-VGXA-111-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-260422-0002','14','MTCN-UEXH-38-0','TOKO','BTCNMT','CN COR DB SHB ','1','2.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.830' WHERE kode_barang='MTCN-UEXH-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UEXH-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UEXH-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.840,berat_hancur_asli=berat_hancur_asli+2.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UEXH-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-260422-0002','15','MTCN-UJAI-37-0','TOKO','BTCNMT','CN COR DB SHB ','1','2.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.570' WHERE kode_barang='MTCN-UJAI-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UJAI-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UJAI-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.580,berat_hancur_asli=berat_hancur_asli+2.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UJAI-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-260422-0002','16','MTCN-VCAX-82-0','TOKO','BTCNMT','CN COR TDK BT SHB','1','2.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.810' WHERE kode_barang='MTCN-VCAX-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VCAX-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VCAX-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.820,berat_hancur_asli=berat_hancur_asli+2.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VCAX-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-260422-0002','17','MTCN-UIAA-25-0','TOKO','BTCNMT','CN COR TDK BT SHB ','1','2.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.640' WHERE kode_barang='MTCN-UIAA-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAA-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAA-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.650,berat_hancur_asli=berat_hancur_asli+2.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UIAA-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-260422-0002','18','MTCN-VKXC-55-0','TOKO','BTCNMT','CN COR 3WRN UBS ','1','4.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='4.160' WHERE kode_barang='MTCN-VKXC-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VKXC-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VKXC-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.170,berat_hancur_asli=berat_hancur_asli+4.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VKXC-55-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-260422-0002','19','MTCN-UDAX-211-0','TOKO','BTCNMT','CN COR BT SHB','1','4.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='4.240' WHERE kode_barang='MTCN-UDAX-211-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-211-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-211-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.250,berat_hancur_asli=berat_hancur_asli+4.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDAX-211-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-260422-0002','20','MTCN-UDAX-237-0','TOKO','BTCNMT','CN COR BT AD MERAH SHB','1','5.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.040' WHERE kode_barang='MTCN-UDAX-237-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-237-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-237-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDAX-237-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-260422-0002','21','MTCN-VGAB-29-0','TOKO','BTCNMT','CN COR DB SHB ','1','3.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.540' WHERE kode_barang='MTCN-VGAB-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VGAB-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VGAB-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.550,berat_hancur_asli=berat_hancur_asli+3.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VGAB-29-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-260422-0002','22','MTCN-WBAG-38-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.240' WHERE kode_barang='MTCN-WBAG-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WBAG-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WBAG-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.250,berat_hancur_asli=berat_hancur_asli+1.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WBAG-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-260422-0002','23','MTCN-WEAX-54-0','TOKO','BTCNMT','CN PLINTIR SHB ','1','1.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.630' WHERE kode_barang='MTCN-WEAX-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WEAX-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WEAX-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.640,berat_hancur_asli=berat_hancur_asli+1.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WEAX-54-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-260422-0002','24','MTCN-VJXF-51-0','TOKO','BTCNMT','CN COR SETENGAH RT SHB ','1','1.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.720' WHERE kode_barang='MTCN-VJXF-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VJXF-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VJXF-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.730,berat_hancur_asli=berat_hancur_asli+1.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VJXF-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-260422-0002','25','MTCN-XDBD-4-0','TOKO','BTCNMT','CN PLINTIR SUSUN SHB ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.920' WHERE kode_barang='MTCN-XDBD-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XDBD-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XDBD-4-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 ='BTCNMT' AND kode_barang='MTCN-XDBD-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-260422-0002','26','MTCN-VJXF-53-0','TOKO','BTCNMT','CN COR TEBU SEKERET SHB ','1','2.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.040' WHERE kode_barang='MTCN-VJXF-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VJXF-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VJXF-53-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.050,berat_hancur_asli=berat_hancur_asli+2.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VJXF-53-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-260422-0002','27','MTCN-WCBG-86-0','TOKO','BTCNMT','CN COR TEBU SEKERET SHB ','1','2.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.320' WHERE kode_barang='MTCN-WCBG-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WCBG-86-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WCBG-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.330,berat_hancur_asli=berat_hancur_asli+2.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WCBG-86-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-260422-0002','28','MTCN-VEAC-33-0','TOKO','BTCNMT','CN SESER SHB ','1','10.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='10.010' WHERE kode_barang='MTCN-VEAC-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VEAC-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VEAC-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.020,berat_hancur_asli=berat_hancur_asli+10.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VEAC-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-260422-0002','29','MTCN-UDAB-6-0','TOKO','BTCNMT','CN EROPA SHB ','1','5.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.100' WHERE kode_barang='MTCN-UDAB-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAB-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAB-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.110,berat_hancur_asli=berat_hancur_asli+5.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDAB-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-260422-0002','30','MTCN-VJXF-46-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','3.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.440' WHERE kode_barang='MTCN-VJXF-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VJXF-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VJXF-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.450,berat_hancur_asli=berat_hancur_asli+3.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VJXF-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-260422-0002','31','MTCN-WCBG-95-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.730' WHERE kode_barang='MTCN-WCBG-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WCBG-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WCBG-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.740,berat_hancur_asli=berat_hancur_asli+5.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WCBG-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-260422-0002','32','MTCN-VBAX-63-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='5.010' WHERE kode_barang='MTCN-VBAX-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VBAX-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VBAX-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.020,berat_hancur_asli=berat_hancur_asli+5.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VBAX-63-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-260422-0002','33','MTCN-UDBD-2-0','TOKO','BTCNMT','CN EROPA SHB ','1','3.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.070' WHERE kode_barang='MTCN-UDBD-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDBD-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDBD-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.080,berat_hancur_asli=berat_hancur_asli+3.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDBD-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-260422-0002','34','MTCN-WGBX-82-0','TOKO','BTCNMT','CN COR BT AD MERAH SHB ','1','4.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='4.720' WHERE kode_barang='MTCN-WGBX-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WGBX-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WGBX-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.730,berat_hancur_asli=berat_hancur_asli+4.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WGBX-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-260422-0002','35','MTCN-UDXG-113-0','TOKO','BTCNMT','CN COR BT SHB','1','2.690','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.690' WHERE kode_barang='MTCN-UDXG-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.690,berat_hancur_asli=berat_hancur_asli+2.690, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDXG-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-260422-0002','36','MTCN-UDBH-14-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.120' WHERE kode_barang='MTCN-UDBH-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDBH-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDBH-14-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 ='BTCNMT' AND kode_barang='MTCN-UDBH-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-260422-0002','37','MTCN-UDBC-35-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.420' WHERE kode_barang='MTCN-UDBC-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDBC-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDBC-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.430,berat_hancur_asli=berat_hancur_asli+2.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDBC-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-260422-0002','38','MTCN-UDAX-228-0','TOKO','BTCNMT','CN COR BT SHB','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.150' WHERE kode_barang='MTCN-UDAX-228-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-228-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-228-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.150,berat_hancur_asli=berat_hancur_asli+2.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDAX-228-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-260422-0002','39','MTCN-WABX-46-0','TOKO','BTCNMT','CN COR BT MTJ ','1','3.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.020' WHERE kode_barang='MTCN-WABX-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WABX-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WABX-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.030,berat_hancur_asli=berat_hancur_asli+3.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WABX-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-260422-0002','40','MTCN-UFXC-33-0','TOKO','BTCNMT','CN COR BT SHB','1','3.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.140' WHERE kode_barang='MTCN-UFXC-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFXC-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFXC-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.150,berat_hancur_asli=berat_hancur_asli+3.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UFXC-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-260422-0002','41','MTCN-WAXI-53-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.270' WHERE kode_barang='MTCN-WAXI-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WAXI-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WAXI-53-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 ='BTCNMT' AND kode_barang='MTCN-WAXI-53-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-260422-0002','42','MTCN-WDAE-85-0','TOKO','BTCNMT','CN COR BT SHB ','1','3.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='3.050' WHERE kode_barang='MTCN-WDAE-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WDAE-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WDAE-85-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 ='BTCNMT' AND kode_barang='MTCN-WDAE-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-260422-0002','43','MTCN-XJAE-91-0','TOKO','BTCNMT','CN KAWIN COR BT SHB ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.900' WHERE kode_barang='MTCN-XJAE-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XJAE-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XJAE-91-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 ='BTCNMT' AND kode_barang='MTCN-XJAE-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-260422-0002','44','MTCN-WACX-112-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.250' WHERE kode_barang='MTCN-WACX-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WACX-112-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WACX-112-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 ='BTCNMT' AND kode_barang='MTCN-WACX-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-260422-0002','45','MTCN-WABX-44-0','TOKO','BTCNMT','CN COR BT SHB','1','2.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.890' WHERE kode_barang='MTCN-WABX-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WABX-44-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WABX-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.900,berat_hancur_asli=berat_hancur_asli+2.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WABX-44-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-260422-0002','46','MTCN-VLAX-48-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','1.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.750' WHERE kode_barang='MTCN-VLAX-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VLAX-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VLAX-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.760,berat_hancur_asli=berat_hancur_asli+1.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VLAX-48-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-260422-0002','47','MTCN-UDAX-229-0','TOKO','BTCNMT','CN COR BT SHB','1','2.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.170' WHERE kode_barang='MTCN-UDAX-229-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-229-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-229-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.170,berat_hancur_asli=berat_hancur_asli+2.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDAX-229-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-260422-0002','48','MTCN-VBXI-39-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.800' WHERE kode_barang='MTCN-VBXI-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VBXI-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VBXI-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VBXI-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-260422-0002','49','MTCN-UEXD-77-0','TOKO','BTCNMT','CN COR BT HT SHB','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.460' WHERE kode_barang='MTCN-UEXD-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UEXD-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UEXD-77-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 ='BTCNMT' AND kode_barang='MTCN-UEXD-77-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-260422-0002','50','MTCN-UIAA-29-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.150' WHERE kode_barang='MTCN-UIAA-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAA-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAA-29-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 ='BTCNMT' AND kode_barang='MTCN-UIAA-29-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-260422-0002','51','MTCN-VKXC-21-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.290' WHERE kode_barang='MTCN-VKXC-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VKXC-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VKXC-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.300,berat_hancur_asli=berat_hancur_asli+2.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VKXC-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-260422-0002','52','MTCN-UDXG-107-0','TOKO','BTCNMT','CN COR BT SHB','1','2.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.210' WHERE kode_barang='MTCN-UDXG-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-107-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-107-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-107-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-260422-0002','53','MTCN-VEBG-48-0','TOKO','BTCNMT','CN COR DB SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.370' WHERE kode_barang='MTCN-VEBG-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VEBG-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VEBG-48-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 ='BTCNMT' AND kode_barang='MTCN-VEBG-48-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-260422-0002','54','MTCN-VLCX-15-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.520' WHERE kode_barang='MTCN-VLCX-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VLCX-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VLCX-15-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 ='BTCNMT' AND kode_barang='MTCN-VLCX-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-260422-0002','55','MTCN-VDBX-106-0','TOKO','BTCNMT','CN COR DOLLAR BT SHB ','1','1.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.440' WHERE kode_barang='MTCN-VDBX-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VDBX-106-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VDBX-106-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VDBX-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-260422-0002','56','MTCN-UHBX-38-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.110' WHERE kode_barang='MTCN-UHBX-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UHBX-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UHBX-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.120,berat_hancur_asli=berat_hancur_asli+1.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UHBX-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-260422-0002','57','MTCN-VBXI-31-0','TOKO','BTCNMT','CN COR HURUF E BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.290' WHERE kode_barang='MTCN-VBXI-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VBXI-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VBXI-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VBXI-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-260422-0002','58','MTCN-UFBE-45-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.260' WHERE kode_barang='MTCN-UFBE-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.270,berat_hancur_asli=berat_hancur_asli+1.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UFBE-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-260422-0002','59','MTCN-UDAG-33-0','TOKO','BTCNMT','CN COR BT HT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.320' WHERE kode_barang='MTCN-UDAG-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAG-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAG-33-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 ='BTCNMT' AND kode_barang='MTCN-UDAG-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-260422-0002','60','MTCN-XIXE-54-0','TOKO','BTCNMT','CN COR TDK BT SMBR PTH LL ','1','1.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.540' WHERE kode_barang='MTCN-XIXE-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XIXE-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XIXE-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.550,berat_hancur_asli=berat_hancur_asli+1.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XIXE-54-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-260422-0002','61','MTCN-VFAG-26-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.220' WHERE kode_barang='MTCN-VFAG-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VFAG-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VFAG-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.230,berat_hancur_asli=berat_hancur_asli+1.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-VFAG-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-260422-0002','62','MTCN-UIAA-27-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.190' WHERE kode_barang='MTCN-UIAA-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAA-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAA-27-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 ='BTCNMT' AND kode_barang='MTCN-UIAA-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-260422-0002','63','MTCN-UKBF-23-0','TOKO','BTCNMT','CN COR BT SHB ','1','0.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.900' WHERE kode_barang='MTCN-UKBF-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UKBF-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UKBF-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UKBF-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-260422-0002','64','MTCN-UFBE-49-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.250' WHERE kode_barang='MTCN-UFBE-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-49-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 ='BTCNMT' AND kode_barang='MTCN-UFBE-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-260422-0002','65','MTCN-UDAX-200-0','TOKO','BTCNMT','CN COR BT SHB','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.350' WHERE kode_barang='MTCN-UDAX-200-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-200-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-200-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 ='BTCNMT' AND kode_barang='MTCN-UDAX-200-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-260422-0002','66','MTCN-WFXC-53-0','TOKO','BTCNMT','CN COR BT HURUF F SHB ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.090' WHERE kode_barang='MTCN-WFXC-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WFXC-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WFXC-53-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 ='BTCNMT' AND kode_barang='MTCN-WFXC-53-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-260422-0002','67','MTCN-UDXG-207-0','TOKO','BTCNMT','CN COR BT SHB','1','1.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.210' WHERE kode_barang='MTCN-UDXG-207-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-207-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-207-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-207-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-260422-0002','68','MTCN-UDAX-193-0','TOKO','BTCNMT','CN COR BT SHB','1','0.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.940' WHERE kode_barang='MTCN-UDAX-193-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDAX-193-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDAX-193-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 ='BTCNMT' AND kode_barang='MTCN-UDAX-193-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-260422-0002','69','MTCN-UDXG-303-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.180' WHERE kode_barang='MTCN-UDXG-303-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-303-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-303-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-303-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-260422-0002','70','MTCN-WACX-78-0','TOKO','BTCNMT','CN COR BT SHB','1','1.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.070' WHERE kode_barang='MTCN-WACX-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WACX-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WACX-78-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 ='BTCNMT' AND kode_barang='MTCN-WACX-78-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-260422-0002','71','MTCN-UDXG-260-0','TOKO','BTCNMT','CN COR BT SHB','1','1.590','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.590' WHERE kode_barang='MTCN-UDXG-260-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-260-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-260-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.590,berat_hancur_asli=berat_hancur_asli+1.590, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDXG-260-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-260422-0002','72','MTCN-VGXA-113-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.160' WHERE kode_barang='MTCN-VGXA-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VGXA-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VGXA-113-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 ='BTCNMT' AND kode_barang='MTCN-VGXA-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-260422-0002','73','MTCN-WCBG-77-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.100' WHERE kode_barang='MTCN-WCBG-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WCBG-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WCBG-77-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WCBG-77-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-260422-0002','74','MTCN-ULBD-70-0','TOKO','BTCNMT','CN COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.970' WHERE kode_barang='MTCN-ULBD-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-ULBD-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-ULBD-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.980,berat_hancur_asli=berat_hancur_asli+0.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-ULBD-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-260422-0002','75','MTCN-UDXG-329-0','TOKO','BTCNMT','CN COR BT SHB ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.940' WHERE kode_barang='MTCN-UDXG-329-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-329-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-329-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-329-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-260422-0002','76','MTCN-UDXG-100-0','TOKO','BTCNMT','CN COR BT SHB','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.400' WHERE kode_barang='MTCN-UDXG-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-100-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-100-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-260422-0002','77','MTCN-UFBE-20-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.310' WHERE kode_barang='MTCN-UFBE-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-20-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 ='BTCNMT' AND kode_barang='MTCN-UFBE-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-260422-0002','78','MTCN-UIBC-55-0','TOKO','BTCNMT','CN COR BT SHB','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.290' WHERE kode_barang='MTCN-UIBC-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIBC-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIBC-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UIBC-55-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-260422-0002','79','MTCN-WACX-139-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='2.570' WHERE kode_barang='MTCN-WACX-139-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WACX-139-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WACX-139-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.580,berat_hancur_asli=berat_hancur_asli+2.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WACX-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-260422-0002','80','MTCN-WFXC-41-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.320' WHERE kode_barang='MTCN-WFXC-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WFXC-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WFXC-41-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 ='BTCNMT' AND kode_barang='MTCN-WFXC-41-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-260422-0002','81','MTCN-VGBA-33-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.590' WHERE kode_barang='MTCN-VGBA-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VGBA-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VGBA-33-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 ='BTCNMT' AND kode_barang='MTCN-VGBA-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-260422-0002','82','MTCN-UIAA-30-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.160' WHERE kode_barang='MTCN-UIAA-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAA-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAA-30-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 ='BTCNMT' AND kode_barang='MTCN-UIAA-30-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-260422-0002','83','MTCN-UFBE-29-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.060' WHERE kode_barang='MTCN-UFBE-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-29-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 ='BTCNMT' AND kode_barang='MTCN-UFBE-29-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-260422-0002','84','MTCN-UIAF-37-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.360' WHERE kode_barang='MTCN-UIAF-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAF-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAF-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.370,berat_hancur_asli=berat_hancur_asli+1.370, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UIAF-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-260422-0002','85','MTCN-UDXG-128-0','TOKO','BTCNMT','CN COR BT SHB','1','1.590','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.590' WHERE kode_barang='MTCN-UDXG-128-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-128-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-128-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.590,berat_hancur_asli=berat_hancur_asli+1.590, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDXG-128-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-260422-0002','86','MTCN-VFAG-38-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.790' WHERE kode_barang='MTCN-VFAG-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VFAG-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VFAG-38-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 ='BTCNMT' AND kode_barang='MTCN-VFAG-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-260422-0002','87','MTCN-UFXC-30-0','TOKO','BTCNMT','CN COR BT SHB','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.600' WHERE kode_barang='MTCN-UFXC-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFXC-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFXC-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.610,berat_hancur_asli=berat_hancur_asli+1.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UFXC-30-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-260422-0002','88','MTCN-UFBE-40-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.340' WHERE kode_barang='MTCN-UFBE-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-40-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 ='BTCNMT' AND kode_barang='MTCN-UFBE-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-260422-0002','89','MTCN-UFBC-52-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.340' WHERE kode_barang='MTCN-UFBC-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBC-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBC-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 ='BTCNMT' AND kode_barang='MTCN-UFBC-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-260422-0002','90','MTCN-WABX-42-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.030' WHERE kode_barang='MTCN-WABX-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WABX-42-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WABX-42-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 ='BTCNMT' AND kode_barang='MTCN-WABX-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-260422-0002','91','MTCN-UIAF-38-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.390' WHERE kode_barang='MTCN-UIAF-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UIAF-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UIAF-38-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 ='BTCNMT' AND kode_barang='MTCN-UIAF-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-260422-0002','92','MTCN-UFXE-31-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.420' WHERE kode_barang='MTCN-UFXE-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFXE-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFXE-31-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 ='BTCNMT' AND kode_barang='MTCN-UFXE-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-260422-0002','93','MTCN-UDXG-234-0','TOKO','BTCNMT','CN COR BT SHB','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.380' WHERE kode_barang='MTCN-UDXG-234-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-234-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-234-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-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-260422-0002','94','MTCN-WGBX-76-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.040' WHERE kode_barang='MTCN-WGBX-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WGBX-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WGBX-76-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 ='BTCNMT' AND kode_barang='MTCN-WGBX-76-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-260422-0002','95','MTCN-UJAE-37-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.170' WHERE kode_barang='MTCN-UJAE-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UJAE-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UJAE-37-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 ='BTCNMT' AND kode_barang='MTCN-UJAE-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-260422-0002','96','MTCN-WFXC-47-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='0.990' WHERE kode_barang='MTCN-WFXC-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WFXC-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WFXC-47-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 ='BTCNMT' AND kode_barang='MTCN-WFXC-47-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-260422-0002','97','MTCN-UFBE-44-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.290' WHERE kode_barang='MTCN-UFBE-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFBE-44-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFBE-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UFBE-44-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-260422-0002','98','MTCN-XGAX-29-0','TOKO','BTCNMT','CN ANAK COR BT CAT MK ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.320' WHERE kode_barang='MTCN-XGAX-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XGAX-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XGAX-29-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 ='BTCNMT' AND kode_barang='MTCN-XGAX-29-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-260422-0002','99','MTCN-UEXD-71-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.790' WHERE kode_barang='MTCN-UEXD-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UEXD-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UEXD-71-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 ='BTCNMT' AND kode_barang='MTCN-UEXD-71-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-260422-0002','100','MTCN-UDXG-225-0','TOKO','BTCNMT','CN COR BT SHB','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.030' WHERE kode_barang='MTCN-UDXG-225-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDXG-225-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDXG-225-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 ='BTCNMT' AND kode_barang='MTCN-UDXG-225-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-260422-0002','101','MTCN-UFXE-39-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.410' WHERE kode_barang='MTCN-UFXE-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UFXE-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UFXE-39-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 ='BTCNMT' AND kode_barang='MTCN-UFXE-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-260422-0002','102','MTCN-VEBG-21-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.430' WHERE kode_barang='MTCN-VEBG-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-VEBG-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-VEBG-21-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 ='BTCNMT' AND kode_barang='MTCN-VEBG-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-260422-0002','103','MTCN-WJAB-42-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:25:44',status_delete='1.160' WHERE kode_barang='MTCN-WJAB-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WJAB-42-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WJAB-42-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 ='BTCNMT' AND kode_barang='MTCN-WJAB-42-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-260422-0002','2026-04-22','admin','2026-04-22','13:25:44','admin','2026-04-22 13:25:44');
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-260422-0003','1','MTGW-YHBI-31-0','TOKO','BTGWMT','GW CAP TDK BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='0.870' WHERE kode_barang='MTGW-YHBI-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YHBI-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YHBI-31-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 ='BTGWMT' AND kode_barang='MTGW-YHBI-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-260422-0003','2','MTGW-YABH-95-0','TOKO','BTGWMT','GW CAP DOLLAR YT ','1','1.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.960' WHERE kode_barang='MTGW-YABH-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-95-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 ='BTGWMT' AND kode_barang='MTGW-YABH-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-260422-0003','3','MTGW-YABH-94-0','TOKO','BTGWMT','GW CAP TDK BT MK ','1','0.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='0.710' WHERE kode_barang='MTGW-YABH-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.720,berat_hancur_asli=berat_hancur_asli+0.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-94-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-260422-0003','4','MTGW-XEBE-77-0','TOKO','BTGWMT','GW COR DB MHL SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.100' WHERE kode_barang='MTGW-XEBE-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XEBE-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XEBE-77-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XEBE-77-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-260422-0003','5','MTGW-XBBG-26-0','TOKO','BTGWMT','GW COR BT AD MRH SHB ','1','1.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.700' WHERE kode_barang='MTGW-XBBG-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XBBG-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XBBG-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.710,berat_hancur_asli=berat_hancur_asli+1.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XBBG-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-260422-0003','6','MTGW-XGXC-87-0','TOKO','BTGWMT','GW CAP BT SHB ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.210' WHERE kode_barang='MTGW-XGXC-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGXC-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGXC-87-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 ='BTGWMT' AND kode_barang='MTGW-XGXC-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-260422-0003','7','MTGW-XACA-189-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.590' WHERE kode_barang='MTGW-XACA-189-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XACA-189-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XACA-189-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 ='BTGWMT' AND kode_barang='MTGW-XACA-189-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-260422-0003','8','MTGW-YABH-84-0','TOKO','BTGWMT','GW COR BT SHB ','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='2.090' WHERE kode_barang='MTGW-YABH-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-84-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-260422-0003','9','MTGW-WKBA-98-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.370' WHERE kode_barang='MTGW-WKBA-98-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-WKBA-98-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-WKBA-98-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 ='BTGWMT' AND kode_barang='MTGW-WKBA-98-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-260422-0003','10','MTGW-YCXE-99-0','TOKO','BTGWMT','GW CAP TDK BT SHB ','1','0.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='0.610' WHERE kode_barang='MTGW-YCXE-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-99-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-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-260422-0003','11','MTGW-XLAA-7-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.350' WHERE kode_barang='MTGW-XLAA-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-7-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 ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260422-0003','12','MTGW-XGAX-16-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.440' WHERE kode_barang='MTGW-XGAX-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-16-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260422-0003','13','MTGW-YEXE-144-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.730' WHERE kode_barang='MTGW-YEXE-144-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXE-144-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXE-144-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXE-144-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-260422-0003','14','MTGW-XKXD-52-0','TOKO','BTGWMT','GW COR BT BT SHB ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.730' WHERE kode_barang='MTGW-XKXD-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XKXD-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XKXD-52-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XKXD-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-260422-0003','15','MTGW-XGAX-19-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.490' WHERE kode_barang='MTGW-XGAX-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-19-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 ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260422-0003','16','MTGW-YABH-89-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.490' WHERE kode_barang='MTGW-YABH-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-89-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 ='BTGWMT' AND kode_barang='MTGW-YABH-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-260422-0003','17','MTGW-YEXC-34-0','TOKO','BTGWMT','GW CAP TDK BT SHB ','1','0.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='0.800' WHERE kode_barang='MTGW-YEXC-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.810,berat_hancur_asli=berat_hancur_asli+0.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-34-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-260422-0003','18','MTGW-YEXC-24-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.720' WHERE kode_barang='MTGW-YEXC-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.730,berat_hancur_asli=berat_hancur_asli+1.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260422-0003','19','MTGW-YABH-90-0','TOKO','BTGWMT','GW COR BT SHB ','1','4.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='4.000' WHERE kode_barang='MTGW-YABH-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.010,berat_hancur_asli=berat_hancur_asli+4.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-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-260422-0003','20','MTGW-XGAX-11-0','TOKO','BTGWMT','GW COR TDK BT SHB ','1','1.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.480' WHERE kode_barang='MTGW-XGAX-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.490,berat_hancur_asli=berat_hancur_asli+1.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260422-0003','21','MTGW-XGAX-17-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.250' WHERE kode_barang='MTGW-XGAX-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-17-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 ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260422-0003','22','MTGW-YEXC-3-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.320' WHERE kode_barang='MTGW-YEXC-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-3-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260422-0003','23','MTGW-XACA-190-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.610' WHERE kode_barang='MTGW-XACA-190-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XACA-190-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XACA-190-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.620,berat_hancur_asli=berat_hancur_asli+1.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XACA-190-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-260422-0003','24','MTGW-XLAA-12-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.350' WHERE kode_barang='MTGW-XLAA-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-12-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 ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260422-0003','25','MTGW-YABH-88-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.500' WHERE kode_barang='MTGW-YABH-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-88-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-88-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 ='BTGWMT' AND kode_barang='MTGW-YABH-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-260422-0003','26','MTGW-XLXB-56-0','TOKO','BTGWMT','GW COR BT SHB ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='2.030' WHERE kode_barang='MTGW-XLXB-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLXB-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLXB-56-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 ='BTGWMT' AND kode_barang='MTGW-XLXB-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-260422-0003','27','MTGW-YEXC-26-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.360' WHERE kode_barang='MTGW-YEXC-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.370,berat_hancur_asli=berat_hancur_asli+1.370, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260422-0003','28','MTGW-XCAD-39-0','TOKO','BTGWMT','GW COR DOLLAR UBS ','1','1.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.910' WHERE kode_barang='MTGW-XCAD-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XCAD-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XCAD-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.920,berat_hancur_asli=berat_hancur_asli+1.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XCAD-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-260422-0003','29','MTGW-XGAX-18-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.260' WHERE kode_barang='MTGW-XGAX-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.270,berat_hancur_asli=berat_hancur_asli+1.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XGAX-18-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-260422-0003','30','MTGW-YCXE-95-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.240' WHERE kode_barang='MTGW-YCXE-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.250,berat_hancur_asli=berat_hancur_asli+1.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-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-260422-0003','31','MTGW-XGCA-60-0','TOKO','BTGWMT','GW CAP BT SHB ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.140' WHERE kode_barang='MTGW-XGCA-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGCA-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGCA-60-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 ='BTGWMT' AND kode_barang='MTGW-XGCA-60-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-260422-0003','32','MTGW-YEXC-8-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-22 13:35:14',status_delete='1.190' WHERE kode_barang='MTGW-YEXC-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-8-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-8-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-260422-0003','2026-04-22','admin','2026-04-22','13:35:14','admin','2026-04-22 13:35:14');
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-260422-0006','K','2026-04-22','14:16:28','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','233354170','54000','233300170');
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-260422-0007','K','2026-04-22','14:17:08','cashier1','PENGELUARAN','IURAN APEPI BULAN MARET 2026','233300170','250000','233050170');
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-260422-0008','K','2026-04-22','14:17:25','cashier1','PENGELUARAN','SETOR PUSAT PAK BUDI ','233050170','100000000','133050170');
UPDATE tt_hutang_head SET byr_harus_rp='10000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'10109000',tgl_lunas='2026-04-22',status='CLOS',total_lunas='10109000' WHERE no_hutang='PI26-01743';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'10000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'10000000'  WHERE tanggal='2026-04-22';
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-260422-0009','D','2026-04-22','14:18:07','cashier1','HUTANG LUNAS','PI26-01743','133050170','10109000','143159170');
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-00009417','X-00009417','GL COR FORTUNE 19CM KKT PER LC2','GR','---','MDGL','BELI','BELI001','11088000','2026-04-22','10.930','1','sales','2026-04-22 14:43:20');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009417','X-00009417');
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-260422-0004','FJ-260107-0008','2502','1','BELI','BELI001','MDGL', 'X-00009417', 'GL COR FORTUNE 19CM KKT PER LC2','10.930','10.930','100.00','11695500','11088000','1014456','1','11088000','11088000','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-22','BELI','BELI001','MDGL','MDGL','100.00','10.930','10.930','1','10.930','10.930','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-260422-0004','2026-04-22','2026-04-22','14:43:20','2502','---','10.930','11088000','11088000','11088000','11088000','11088000','sales','2026-04-22 14:43:20','FB-260422-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260422-0004','IBU AMINAH','SUKOLILO MDR','','','081314808429','sales','2026-04-22 14:43:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-22' 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-260422-0010','K','2026-04-22','14:43:20','sales','PEMBELIAN UMUM','FB-260422-0004','143159170','11088000','132071170','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260422-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260422-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-04-22 ','15:08:46');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01752','2105','1','GL PAJERO MN KOIN DOLAR 5BJ KKT PER LC2 8K','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'4000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'4000000'  WHERE tanggal='2026-04-22'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01752','2026-04-22','2026-04-22','15:12:38','PLG0018689','2105','90','2026-07-21','sales','2026-04-22 15:12:38','7.630','4000000','3.00','360000','4360000','0','OPEN','13.95','1','2026-07-21','0','4360000')
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-260422-0011','K','2026-04-22','15:12:38','sales','HUTANG','PI26-01752','132071170','4000000','128071170','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01752' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01752';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','15:37:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','16:14:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-22 ','16:40:45');