INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-27 ','08:35:35');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-27','110','0','-276150000','110','0','-276150000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-26';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-26' 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-251227-0001','D','2025-12-27','08:35:49','','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-251227-0001','D','2025-12-27','08:35:49','BCA','SALDO AWAL','SALDO AWAL','0','1529102385','1529102385');
UPDATE tp_system SET tgl_system='2025-12-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-27 ','08:36:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-12-27 ','08:46:05');
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-00009097','X-00009097','LT COR 3WRN LC2','GR','---','MDLT','BELI','BELI001','1996500','2025-12-27','2.180','1','sales','2025-12-27 09:31:08');
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-00009097','X-00009097');
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-251227-0001','FJ-240805-0011','2502','1','BELI','BELI001','MDLT', 'X-00009097', 'LT COR 3WRN LC2','2.180','2.180','100.00','1376000','1996500','915826','1','1996500','1996500','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 ('2025-12-27','BELI','BELI001','MDLT','MDLT','100.00','2.180','2.180','1','2.180','2.180','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-251227-0001','2025-12-27','2025-12-27','09:31:07','2502','---','2.180','1996500','1996500','1996500','1996500','1996500','sales','2025-12-27 09:31:08','FB-251227-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251227-0001','IBU MAISAROH','JATI PURWO GG.7/16','','','083854973172','sales','2025-12-27 09:31:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-27' 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-251227-0002','K','2025-12-27','09:31:07','sales','PEMBELIAN UMUM','FB-251227-0001','244998576','1996500','243002076','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251227-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251227-0001';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009098','X-00009098','KL FANCY CATENA 41CM KKT S SHB','GR','---','MTKL','BELI','BELI001','2422500','2025-12-27','1.500','1','sales','2025-12-27 10:10:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009098','X-00009098');
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-251227-0002','FJ-251123-0001','2502','1','BELI','BELI001','MTKL', 'X-00009098', 'KL FANCY CATENA 41CM KKT S SHB','1.500','1.500','100.00','2580000','2422500','1615000','1','2422500','2422500','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 ('2025-12-27','BELI','BELI001','MTKL','MTKL','100.00','1.500','1.500','1','1.500','1.500','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-251227-0002','2025-12-27','2025-12-27','10:10:45','2502','---','1.500','2422500','2422500','2422500','2422500','2422500','sales','2025-12-27 10:10:46','FB-251227-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251227-0002','ANAM','KENJERAN','','','','sales','2025-12-27 10:10:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-27' 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-251227-0003','K','2025-12-27','10:10:45','sales','PEMBELIAN UMUM','FB-251227-0002','243002076','2422500','240579576','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-00009099','X-00009099','GW COR BT SHB','GR','---','MTGW','BELI','BELI001','1938000','2025-12-27','1.200','1','sales','2025-12-27 10:10:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009099','X-00009099');
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-251227-0003','FJ-251112-0005','2502','2','BELI','BELI001','MTGW', 'X-00009099', 'GW COR BT SHB','1.200','1.200','100.00','2040000','1938000','1615000','1','1938000','1938000','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 ('2025-12-27','BELI','BELI001','MTGW','MTGW','100.00','1.200','1.200','1','1.200','1.200','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-251227-0003','2025-12-27','2025-12-27','10:10:46','2502','---','1.200','1938000','1938000','1938000','1938000','1938000','sales','2025-12-27 10:10:46','FB-251227-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251227-0003','ZAHRA','KENJERAN','','','085815214882','sales','2025-12-27 10:10:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-27' 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-251227-0004','K','2025-12-27','10:10:46','sales','PEMBELIAN UMUM','FB-251227-0003','240579576','1938000','238641576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251227-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251227-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251227-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251227-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-27 ','10:41:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-27 ','10:42:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-27 ','10:43:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-27 ','10:53:29');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','1','MTKL-WBAE-1-0','TOKO','BTKLMT','KL ITALY ST 43CM KKT PER BLT SHB','1','2.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.760' WHERE kode_barang='MTKL-WBAE-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBAE-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBAE-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.770,berat_hancur_asli=berat_hancur_asli+2.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBAE-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','2','MTKL-WAAI-38-0','TOKO','BTKLMT','KL ITALY ST 46CM KKT S SHB ','1','2.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.820' WHERE kode_barang='MTKL-WAAI-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.830,berat_hancur_asli=berat_hancur_asli+2.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','3','MTKL-YFAH-171-0','TOKO','BTKLMT','KL ITALY ST 41CM KKT S SHB ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.950' WHERE kode_barang='MTKL-YFAH-171-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YFAH-171-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YFAH-171-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YFAH-171-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','4','MTKL-WAAI-54-0','TOKO','BTKLMT','KL MILTA 43CM KKT S SHB ','1','2.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.970' WHERE kode_barang='MTKL-WAAI-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.980,berat_hancur_asli=berat_hancur_asli+2.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','5','MTKL-WBBB-63-0','TOKO','BTKLMT','KL ITALY ST 42CM KKT S SHB','1','3.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.000' WHERE kode_barang='MTKL-WBBB-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBBB-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBBB-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.010,berat_hancur_asli=berat_hancur_asli+3.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBBB-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-251227-0001','6','MTKL-WCBG-135-0','TOKO','BTKLMT','KL ITALY KC 48CM KKT S HWT ','1','2.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.720' WHERE kode_barang='MTKL-WCBG-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBG-135-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBG-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.730,berat_hancur_asli=berat_hancur_asli+2.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBG-135-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','7','MTKL-WAAI-42-0','TOKO','BTKLMT','KL ITALY ST 44CM KKT PER BLT SHB ','1','3.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.640' WHERE kode_barang='MTKL-WAAI-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-42-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.650,berat_hancur_asli=berat_hancur_asli+3.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','8','MTKL-WDAE-155-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER BLT SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.990' WHERE kode_barang='MTKL-WDAE-155-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAE-155-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAE-155-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.000,berat_hancur_asli=berat_hancur_asli+3.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDAE-155-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','9','MTKL-YJAH-76-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER BLT SHB ','1','2.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.970' WHERE kode_barang='MTKL-YJAH-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YJAH-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YJAH-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.980,berat_hancur_asli=berat_hancur_asli+2.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YJAH-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-251227-0001','10','MTKL-YCXA-12-0','TOKO','BTKLMT','KL ITALY ST 41CM KKT PER BLT SHB ','1','2.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.110' WHERE kode_barang='MTKL-YCXA-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXA-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-251227-0001','11','MTKL-YEXC-54-0','TOKO','BTKLMT','KL ITALY ST 43CM KKT PER BLT SHB ','1','2.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.940' WHERE kode_barang='MTKL-YEXC-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.950,berat_hancur_asli=berat_hancur_asli+2.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-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-251227-0001','12','MTKL-YACX-45-0','TOKO','BTKLMT','KL MILANO 46CM KKT S SHB ','1','10.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.990' WHERE kode_barang='MTKL-YACX-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.000,berat_hancur_asli=berat_hancur_asli+10.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YACX-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-251227-0001','13','MTKL-WGBX-134-0','TOKO','BTKLMT','KL MILLANO 46CM KKT PER BLT SHB ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.900' WHERE kode_barang='MTKL-WGBX-134-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WGBX-134-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WGBX-134-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 ='BTKLMT' AND kode_barang='MTKL-WGBX-134-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','14','MTKL-VJXF-109-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','5.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.000' WHERE kode_barang='MTKL-VJXF-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VJXF-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VJXF-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.010,berat_hancur_asli=berat_hancur_asli+5.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VJXF-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','15','MTKL-WAAI-53-0','TOKO','BTKLMT','KL MILANO 43CM KKT S SHB ','1','4.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.840' WHERE kode_barang='MTKL-WAAI-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-53-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.850,berat_hancur_asli=berat_hancur_asli+4.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','16','MTKL-WHAE-83-0','TOKO','BTKLMT','KL MILANO 42CM KKT S SHB ','1','4.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.890' WHERE kode_barang='MTKL-WHAE-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WHAE-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WHAE-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.900,berat_hancur_asli=berat_hancur_asli+4.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WHAE-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','17','MTKL-YEXC-72-0','TOKO','BTKLMT','KL MILANO 42CM KKT S SHB ','1','4.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.940' WHERE kode_barang='MTKL-YEXC-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-72-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.950,berat_hancur_asli=berat_hancur_asli+4.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','18','MTKL-WCBH-189-0','TOKO','BTKLMT','KL MILANO ICE 41CM KKT PER BLT UBS ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.900' WHERE kode_barang='MTKL-WCBH-189-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBH-189-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBH-189-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 ='BTKLMT' AND kode_barang='MTKL-WCBH-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-251227-0001','19','MTKL-XKXG-60-0','TOKO','BTKLMT','KL MILANO ANAK 33CM KKT PER BLT SHB ','1','3.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.200' WHERE kode_barang='MTKL-XKXG-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.210,berat_hancur_asli=berat_hancur_asli+3.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','20','MTKL-XJAE-133-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','3.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.970' WHERE kode_barang='MTKL-XJAE-133-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XJAE-133-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XJAE-133-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.980,berat_hancur_asli=berat_hancur_asli+3.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XJAE-133-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','21','MTKL-UJXH-21-0','TOKO','BTKLMT','KL VENUS ITALY VAR CAT 35CM KKT PER BLT UBS ','1','3.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.170' WHERE kode_barang='MTKL-UJXH-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UJXH-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UJXH-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.180,berat_hancur_asli=berat_hancur_asli+3.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UJXH-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-251227-0001','22','MTKL-UDXI-27-0','TOKO','BTKLMT','KL MILLANO ANK 33CM KKT PER BLT SHB','1','3.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.190' WHERE kode_barang='MTKL-UDXI-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDXI-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDXI-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.190,berat_hancur_asli=berat_hancur_asli+3.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDXI-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-251227-0001','23','MTKL-XCBA-37-0','TOKO','BTKLMT','KL ANAK ITALY ST VAR BT 34CM KKT PER BLT SHB ','1','2.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.650' WHERE kode_barang='MTKL-XCBA-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCBA-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCBA-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.660,berat_hancur_asli=berat_hancur_asli+2.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCBA-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-251227-0001','24','MTKL-XCBA-33-0','TOKO','BTKLMT','KL ANAK ITALY ST DB 34CM KKT PER BLT SHB ','1','2.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.650' WHERE kode_barang='MTKL-XCBA-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCBA-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCBA-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.660,berat_hancur_asli=berat_hancur_asli+2.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCBA-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-251227-0001','25','MTKL-XKXG-58-0','TOKO','BTKLMT','KL MILANO ANAK 33CM KKT PER BLT SHB','1','1.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.940' WHERE kode_barang='MTKL-XKXG-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.950,berat_hancur_asli=berat_hancur_asli+1.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','26','MTKL-UDAE-105-0','TOKO','BTKLMT','KL ITALY KACA ANK 34CM KKT PER BLT SHB','1','3.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.550' WHERE kode_barang='MTKL-UDAE-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDAE-105-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDAE-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.560,berat_hancur_asli=berat_hancur_asli+3.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDAE-105-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','27','MTKL-VDXH-64-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.930' WHERE kode_barang='MTKL-VDXH-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VDXH-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VDXH-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VDXH-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','28','MTKL-VCAA-32-0','TOKO','BTKLMT','KL MILANO 43CM KKT PER SHB ','1','3.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.020' WHERE kode_barang='MTKL-VCAA-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VCAA-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VCAA-32-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 ='BTKLMT' AND kode_barang='MTKL-VCAA-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-251227-0001','29','MTKL-UEXD-5-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER BLT SHB ','1','2.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.960' WHERE kode_barang='MTKL-UEXD-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UEXD-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UEXD-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.970,berat_hancur_asli=berat_hancur_asli+2.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UEXD-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','30','MTKL-VLAX-85-0','TOKO','BTKLMT','KL MILLANO ANAK 33CM KKT PER BLT SHB ','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.140' WHERE kode_barang='MTKL-VLAX-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VLAX-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VLAX-85-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 ='BTKLMT' AND kode_barang='MTKL-VLAX-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-251227-0001','31','MTKL-WJXC-6-0','TOKO','BTKLMT','KL SHANIA 42CM KKT S SHB ','1','2.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.130' WHERE kode_barang='MTKL-WJXC-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WJXC-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WJXC-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.140,berat_hancur_asli=berat_hancur_asli+2.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WJXC-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-251227-0001','32','MTKL-WDXC-47-0','TOKO','BTKLMT','KL FANCY CATENA 42CM KKT S SHB ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.510' WHERE kode_barang='MTKL-WDXC-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDXC-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDXC-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.520,berat_hancur_asli=berat_hancur_asli+1.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDXC-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-251227-0001','33','MTKL-XKXG-85-0','TOKO','BTKLMT','KL MOCCA VAR BT 44CM KKT PER BLT SHB ','1','3.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.320' WHERE kode_barang='MTKL-XKXG-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.330,berat_hancur_asli=berat_hancur_asli+3.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','34','MTKL-UJAE-77-0','TOKO','BTKLMT','KL SHANIA 41CM KKT S SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.100' WHERE kode_barang='MTKL-UJAE-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UJAE-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UJAE-77-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UJAE-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-251227-0001','35','MTKL-XKXG-71-0','TOKO','BTKLMT','KL CASTELI VAR BT 41CM KKT PER MK ','1','3.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.760' WHERE kode_barang='MTKL-XKXG-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.770,berat_hancur_asli=berat_hancur_asli+3.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','36','MTKL-XKXG-89-0','TOKO','BTKLMT','KL FANCY VAR PIPA KRW 44CM KKT S SHB ','1','4.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.930' WHERE kode_barang='MTKL-XKXG-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.940,berat_hancur_asli=berat_hancur_asli+4.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','37','MTKL-XKXG-90-0','TOKO','BTKLMT','KL FANCY VAR BT 41CM KKT PER BLT SHB ','1','3.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.270' WHERE kode_barang='MTKL-XKXG-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.280,berat_hancur_asli=berat_hancur_asli+3.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','38','MTKL-UJAE-79-0','TOKO','BTKLMT','KL SHANIA 41CM KKT S SHB ','1','2.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.130' WHERE kode_barang='MTKL-UJAE-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UJAE-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UJAE-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.140,berat_hancur_asli=berat_hancur_asli+2.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UJAE-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-251227-0001','39','MTKL-WGAH-134-0','TOKO','BTKLMT','KL CATENA VAR BT 42CM KKT PER SHB ','1','3.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.910' WHERE kode_barang='MTKL-WGAH-134-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WGAH-134-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WGAH-134-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.920,berat_hancur_asli=berat_hancur_asli+3.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WGAH-134-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','40','MTKL-XEBE-91-0','TOKO','BTKLMT','KL FANCY 43CM KKT S SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.990' WHERE kode_barang='MTKL-XEBE-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.000,berat_hancur_asli=berat_hancur_asli+3.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XEBE-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-251227-0001','41','MTKL-WBAG-97-0','TOKO','BTKLMT','KL CATENA VAR 42CM KKT PER SHB ','1','9.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.430' WHERE kode_barang='MTKL-WBAG-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBAG-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBAG-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.440,berat_hancur_asli=berat_hancur_asli+9.440, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBAG-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-251227-0001','42','MTKL-YCXA-5-0','TOKO','BTKLMT','KL VANESSA ANAK 33CM KKT S SHB ','1','1.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.690' WHERE kode_barang='MTKL-YCXA-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.700,berat_hancur_asli=berat_hancur_asli+1.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXA-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','43','MTKL-WLAE-41-0','TOKO','BTKLMT','KL CATENA VAR BT 42CM KKT PER MK ','1','3.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.390' WHERE kode_barang='MTKL-WLAE-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WLAE-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WLAE-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.400,berat_hancur_asli=berat_hancur_asli+3.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WLAE-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-251227-0001','44','MTKL-WBAG-96-0','TOKO','BTKLMT','KL CATENA VAR 43CM KKT PER SHB ','1','6.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='6.540' WHERE kode_barang='MTKL-WBAG-96-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBAG-96-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBAG-96-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.550,berat_hancur_asli=berat_hancur_asli+6.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBAG-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-251227-0001','45','MTKL-XGXC-108-0','TOKO','BTKLMT','KL CATENA VAR BT 42CM KKT PER SHB ','1','3.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.550' WHERE kode_barang='MTKL-XGXC-108-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XGXC-108-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XGXC-108-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.560,berat_hancur_asli=berat_hancur_asli+3.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XGXC-108-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','46','MTKL-XKXG-72-0','TOKO','BTKLMT','KL FANCY VAR BT 42CM KKT PER UBS ','1','7.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='7.010' WHERE kode_barang='MTKL-XKXG-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-72-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.020,berat_hancur_asli=berat_hancur_asli+7.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','47','MTKL-XJAE-126-0','TOKO','BTKLMT','KL CASTELLI 43CM KKT S SHB ','1','2.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.510' WHERE kode_barang='MTKL-XJAE-126-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XJAE-126-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XJAE-126-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.520,berat_hancur_asli=berat_hancur_asli+2.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XJAE-126-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','48','MTKL-YCAD-73-0','TOKO','BTKLMT','KL LAYER 42CM KKT PER SHB ','1','3.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.400' WHERE kode_barang='MTKL-YCAD-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCAD-73-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCAD-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.410,berat_hancur_asli=berat_hancur_asli+3.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCAD-73-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','49','MTKL-WJAB-102-0','TOKO','BTKLMT','KL VANESSA BTR 42CM KKT PER SHB ','1','4.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.450' WHERE kode_barang='MTKL-WJAB-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WJAB-102-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WJAB-102-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.460,berat_hancur_asli=berat_hancur_asli+4.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WJAB-102-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','50','MTKL-XKXG-79-0','TOKO','BTKLMT','KL FANCY ANAK 35CM KKT S SHB ','1','2.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.940' WHERE kode_barang='MTKL-XKXG-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.950,berat_hancur_asli=berat_hancur_asli+2.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','51','MTKL-WFXC-115-0','TOKO','BTKLMT','KL FANCY PLAT HURUF N 42CM KKT PER SHB ','1','3.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.350' WHERE kode_barang='MTKL-WFXC-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WFXC-115-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WFXC-115-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.360,berat_hancur_asli=berat_hancur_asli+3.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WFXC-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','52','MTKL-WHAE-100-0','TOKO','BTKLMT','KL FANCY HURUF K 42CM KKT PER SHB ','1','3.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.460' WHERE kode_barang='MTKL-WHAE-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WHAE-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WHAE-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.470,berat_hancur_asli=berat_hancur_asli+3.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WHAE-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-251227-0001','53','MTKL-VJBX-28-0','TOKO','BTKLMT','KL FANCY HURUF D 42CM KKT PER SHB ','1','3.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.540' WHERE kode_barang='MTKL-VJBX-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VJBX-28-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VJBX-28-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 ='BTKLMT' AND kode_barang='MTKL-VJBX-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-251227-0001','54','MTKL-YAXD-48-0','TOKO','BTKLMT','KL FANCY PLAT HURUF A 44CM KKT PER BLT SHB ','1','2.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.830' WHERE kode_barang='MTKL-YAXD-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YAXD-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YAXD-48-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 ='BTKLMT' AND kode_barang='MTKL-YAXD-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-251227-0001','55','MTKL-VJBX-35-0','TOKO','BTKLMT','KL FANCY VAR BT 41CM KKT PER DMI ','1','3.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.110' WHERE kode_barang='MTKL-VJBX-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VJBX-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VJBX-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.120,berat_hancur_asli=berat_hancur_asli+3.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VJBX-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-251227-0001','56','MTKL-XCAD-44-0','TOKO','BTKLMT','KL ANAK FANCY TDK BT 39CM KKT PER BLT UBS ','1','2.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.650' WHERE kode_barang='MTKL-XCAD-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCAD-44-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCAD-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.660,berat_hancur_asli=berat_hancur_asli+2.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCAD-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-251227-0001','57','MTKL-XCAD-46-0','TOKO','BTKLMT','KL ANAK FANCY TDK BT 39CM KKT PER BLT UBS ','1','2.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.730' WHERE kode_barang='MTKL-XCAD-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCAD-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCAD-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.740,berat_hancur_asli=berat_hancur_asli+2.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCAD-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-251227-0001','58','MTKL-VJBX-26-0','TOKO','BTKLMT','KL FANCY HURUF G 42CM KKT PER SHB ','1','3.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.410' WHERE kode_barang='MTKL-VJBX-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VJBX-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VJBX-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.420,berat_hancur_asli=berat_hancur_asli+3.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VJBX-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-251227-0001','59','MTKL-WFXC-116-0','TOKO','BTKLMT','KL ITALY ST VAR BT 42CM KKT PER BLT SHB ','1','4.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.090' WHERE kode_barang='MTKL-WFXC-116-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WFXC-116-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WFXC-116-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.100,berat_hancur_asli=berat_hancur_asli+4.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WFXC-116-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','60','MTKL-XKXG-83-0','TOKO','BTKLMT','KL ANAK BTR DB 33CM KKT PER BLT SHB ','1','2.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.370' WHERE kode_barang='MTKL-XKXG-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.380,berat_hancur_asli=berat_hancur_asli+2.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','61','MTKL-YACX-53-0','TOKO','BTKLMT','KL ITALY VAR 41CM KKT PER BLT HWT ','1','6.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='6.180' WHERE kode_barang='MTKL-YACX-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-53-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.190,berat_hancur_asli=berat_hancur_asli+6.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YACX-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-251227-0001','62','MTKL-WDAE-164-0','TOKO','BTKLMT','KL ITALY ST VAR 42CM KKT PER BLT UBS ','1','6.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='6.730' WHERE kode_barang='MTKL-WDAE-164-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAE-164-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAE-164-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.740,berat_hancur_asli=berat_hancur_asli+6.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDAE-164-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','63','MTKL-YGAE-15-0','TOKO','BTKLMT','KL ITALY ST VAR BT 42CM KKT PER BLT MK ','1','3.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.110' WHERE kode_barang='MTKL-YGAE-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.120,berat_hancur_asli=berat_hancur_asli+3.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YGAE-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-251227-0001','64','MTKL-YCXA-15-0','TOKO','BTKLMT','KL ITALY ST VAR BT 41CM KKT PER BLT MK ','1','3.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.130' WHERE kode_barang='MTKL-YCXA-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.140,berat_hancur_asli=berat_hancur_asli+3.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXA-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-251227-0001','65','MTKL-YCXA-16-0','TOKO','BTKLMT','KL ITALY ST BTR BL PSR 42CM KKT PER BLT SHB ','1','3.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.490' WHERE kode_barang='MTKL-YCXA-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.500,berat_hancur_asli=berat_hancur_asli+3.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXA-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-251227-0001','66','MTKL-XIXE-83-0','TOKO','BTKLMT','KL ITALY ST VAR BL PSR 40CM KKT PER UBS ','1','3.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.090' WHERE kode_barang='MTKL-XIXE-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XIXE-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XIXE-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.100,berat_hancur_asli=berat_hancur_asli+3.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XIXE-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','67','MTKL-UDXH-268-0','TOKO','BTKLMT','KL ITALY ST ANK 33CM KKT PER BLT SHB','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.530' WHERE kode_barang='MTKL-UDXH-268-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDXH-268-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDXH-268-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 ='BTKLMT' AND kode_barang='MTKL-UDXH-268-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','68','MTKL-UDBG-3-0','TOKO','BTKLMT','KL ANK ITALY ST PLTR 34CM KKT S SHB ','1','2.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.360' WHERE kode_barang='MTKL-UDBG-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDBG-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDBG-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.370,berat_hancur_asli=berat_hancur_asli+2.370, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDBG-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-251227-0001','69','MTKL-XACA-208-0','TOKO','BTKLMT','KL ANAK FANCY DB 33CM KKT PER SHB ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.900' WHERE kode_barang='MTKL-XACA-208-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XACA-208-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XACA-208-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 ='BTKLMT' AND kode_barang='MTKL-XACA-208-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','70','MTKL-XEBE-93-0','TOKO','BTKLMT','KL FANCY ANAK CAT 33CM KKT S MK ','1','2.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.070' WHERE kode_barang='MTKL-XEBE-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.080,berat_hancur_asli=berat_hancur_asli+2.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XEBE-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','71','MTKL-XKXG-63-0','TOKO','BTKLMT','KL FANCY ANAK VAR BT 34CM KKT S SHB ','1','2.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.510' WHERE kode_barang='MTKL-XKXG-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.520,berat_hancur_asli=berat_hancur_asli+2.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','72','MTKL-XKXG-87-0','TOKO','BTKLMT','KL SHANIA DB 40CM KKT S SHB ','1','4.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.160' WHERE kode_barang='MTKL-XKXG-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-87-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 ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','73','MTKL-YCBE-81-0','TOKO','BTKLMT','KL FANCY ANAK CAT 35CM KKT PER UBS ','1','2.590','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.580' WHERE kode_barang='MTKL-YCBE-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.590,berat_hancur_asli=berat_hancur_asli+2.590, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','74','MTKL-XKXG-88-0','TOKO','BTKLMT','KL CASTELLI BTR 42CM KKT PER SHB ','1','4.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.660' WHERE kode_barang='MTKL-XKXG-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-88-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-88-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.670,berat_hancur_asli=berat_hancur_asli+4.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','75','MTKL-YGAE-12-0','TOKO','BTKLMT','KL CATENA VAR BT 42CM KKT PER MK ','1','5.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.740' WHERE kode_barang='MTKL-YGAE-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.750,berat_hancur_asli=berat_hancur_asli+5.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YGAE-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-251227-0001','76','MTKL-XKXG-91-0','TOKO','BTKLMT','KL CATENA VAR BT 41CM KKT PER SHB ','1','3.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.470' WHERE kode_barang='MTKL-XKXG-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.480,berat_hancur_asli=berat_hancur_asli+3.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','77','MTKL-YCBE-83-0','TOKO','BTKLMT','KL FANCY ANAK CAT 35CM KKT PER UBS ','1','2.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.640' WHERE kode_barang='MTKL-YCBE-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-83-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 ='BTKLMT' AND kode_barang='MTKL-YCBE-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','78','MTKL-XKXG-86-0','TOKO','BTKLMT','KL VANESSA DB 42CM KKT PER SHB ','1','4.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.210' WHERE kode_barang='MTKL-XKXG-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-86-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.220,berat_hancur_asli=berat_hancur_asli+4.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-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-251227-0001','79','MTKL-XKXG-74-0','TOKO','BTKLMT','KL CABLE STRIP VAR BT 42CM KKT PER BLT UBS ','1','3.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.210' WHERE kode_barang='MTKL-XKXG-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.220,berat_hancur_asli=berat_hancur_asli+3.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','80','MTKL-UJAE-80-0','TOKO','BTKLMT','KL SHANIA 41CM KKT S SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.100' WHERE kode_barang='MTKL-UJAE-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UJAE-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UJAE-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UJAE-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','81','MTKL-UDAD-158-0','TOKO','BTKLMT','KL FANCY SLP 42CM KKT PER BLT SHB ','1','2.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.350' WHERE kode_barang='MTKL-UDAD-158-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDAD-158-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDAD-158-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.360,berat_hancur_asli=berat_hancur_asli+2.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDAD-158-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','82','MTKL-XCBA-125-0','TOKO','BTKLMT','KL CATENA VAR 41CM KKT S SHB ','1','2.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.190' WHERE kode_barang='MTKL-XCBA-125-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCBA-125-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCBA-125-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.200,berat_hancur_asli=berat_hancur_asli+2.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCBA-125-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','83','MTKL-XACA-197-0','TOKO','BTKLMT','KL FANCY PJG 66CM KKT PER BLT SHB ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.930' WHERE kode_barang='MTKL-XACA-197-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XACA-197-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XACA-197-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XACA-197-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','84','MTKL-XABD-70-0','TOKO','BTKLMT','KL ATHENS 42CM KKT PER HWT ','1','3.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.310' WHERE kode_barang='MTKL-XABD-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XABD-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XABD-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.320,berat_hancur_asli=berat_hancur_asli+3.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XABD-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-251227-0001','85','MTKL-YCXA-11-0','TOKO','BTKLMT','KL FANCY ANAK HURUF S CAT 33CM KKT PER BLT SHB ','1','2.310','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.300' WHERE kode_barang='MTKL-YCXA-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.310,berat_hancur_asli=berat_hancur_asli+2.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXA-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-251227-0001','86','MTKL-YAXF-11-0','TOKO','BTKLMT','KL FANCY DB 42CM KKT S SHB ','1','6.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='6.460' WHERE kode_barang='MTKL-YAXF-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YAXF-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YAXF-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.470,berat_hancur_asli=berat_hancur_asli+6.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YAXF-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-251227-0001','87','MTKL-XGXC-109-0','TOKO','BTKLMT','KL CATENA VAR 44CM KKT PER MK ','1','9.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.620' WHERE kode_barang='MTKL-XGXC-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XGXC-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XGXC-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.630,berat_hancur_asli=berat_hancur_asli+9.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XGXC-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','88','MTKL-YACX-51-0','TOKO','BTKLMT','KL ITALY ST VAR BL PSR 44CM KKT PER HWT ','1','3.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.440' WHERE kode_barang='MTKL-YACX-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-51-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 ='BTKLMT' AND kode_barang='MTKL-YACX-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-251227-0001','89','MTKL-YGAE-20-0','TOKO','BTKLMT','KL ITALY ST VAR BT DSC 42CM KKT PER BLT SHB ','1','3.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.060' WHERE kode_barang='MTKL-YGAE-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YGAE-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-251227-0001','90','MTKL-YACX-82-0','TOKO','BTKLMT','KL ITALY ST VAR BTR WRN 42CM KKT PER KH ','1','4.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.000' WHERE kode_barang='MTKL-YACX-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-82-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 ='BTKLMT' AND kode_barang='MTKL-YACX-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-251227-0001','91','MTKL-XKXG-81-0','TOKO','BTKLMT','KL ITALY DB ANAK 33CM KKT PER BLT SHB','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.250' WHERE kode_barang='MTKL-XKXG-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-81-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 ='BTKLMT' AND kode_barang='MTKL-XKXG-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','92','MTKL-XKXG-66-0','TOKO','BTKLMT','KL ITALY ST VAR BT 43CM KKT PER SHB ','1','5.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.410' WHERE kode_barang='MTKL-XKXG-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-66-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.420,berat_hancur_asli=berat_hancur_asli+5.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-66-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','93','MTKL-WBBB-71-0','TOKO','BTKLMT','KL MILLANO BLT 41CM KKT S UBS ','1','9.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.960' WHERE kode_barang='MTKL-WBBB-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBBB-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBBB-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.970,berat_hancur_asli=berat_hancur_asli+9.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBBB-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-251227-0001','94','MTKL-VKBE-30-0','TOKO','BTKLMT','KL ITALY ST 42CM KKT PER BLT SHB ','1','5.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.920' WHERE kode_barang='MTKL-VKBE-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VKBE-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VKBE-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.930,berat_hancur_asli=berat_hancur_asli+5.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VKBE-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-251227-0001','95','MTKL-WCBH-193-0','TOKO','BTKLMT','KL MILANO BLT 43CM KKT PER UBS','1','10.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='10.040' WHERE kode_barang='MTKL-WCBH-193-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBH-193-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBH-193-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.050,berat_hancur_asli=berat_hancur_asli+10.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBH-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-251227-0001','96','MTKL-WCBH-190-0','TOKO','BTKLMT','KL MILANO ICE 41CM KKT PER BLT UBS ','1','4.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.100' WHERE kode_barang='MTKL-WCBH-190-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBH-190-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBH-190-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.110,berat_hancur_asli=berat_hancur_asli+4.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBH-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-251227-0001','97','MTKL-VKBD-106-0','TOKO','BTKLMT','KL ITALY ST 46CM KKT PER SHB ','1','11.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='11.260' WHERE kode_barang='MTKL-VKBD-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VKBD-106-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VKBD-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.270,berat_hancur_asli=berat_hancur_asli+11.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VKBD-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-251227-0001','98','MTKL-WAAI-58-0','TOKO','BTKLMT','KL MILANO 47CM KKT PER BLT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.120' WHERE kode_barang='MTKL-WAAI-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-58-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 ='BTKLMT' AND kode_barang='MTKL-WAAI-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','99','MTKL-XKXG-75-0','TOKO','BTKLMT','KL ROLLO TIARA 41CM KKT PER UBS ','1','7.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='7.150' WHERE kode_barang='MTKL-XKXG-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.160,berat_hancur_asli=berat_hancur_asli+7.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','100','MTKL-WCBG-129-0','TOKO','BTKLMT','KL FANCY 44CM KKT S SHB ','1','3.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.040' WHERE kode_barang='MTKL-WCBG-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBG-129-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBG-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.050,berat_hancur_asli=berat_hancur_asli+3.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBG-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','101','MTKL-WAAI-12-0','TOKO','BTKLMT','KL FANCY 43CM KKT S SHB','1','2.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.940' WHERE kode_barang='MTKL-WAAI-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.950,berat_hancur_asli=berat_hancur_asli+2.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','102','MTKL-WBAC-2-0','TOKO','BTKLMT','KL FANCY SLP 47CM KKT PER BLT SHB ','1','5.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.110' WHERE kode_barang='MTKL-WBAC-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBAC-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBAC-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.120,berat_hancur_asli=berat_hancur_asli+5.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBAC-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-251227-0001','103','MTKL-WAAI-27-0','TOKO','BTKLMT','KL FANCY 66CM KKT S SHB ','1','4.990','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.980' WHERE kode_barang='MTKL-WAAI-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.990,berat_hancur_asli=berat_hancur_asli+4.990, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-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-251227-0001','104','MTKL-VKBD-97-0','TOKO','BTKLMT','KL ITALY ST TWIST 42CM KKT PER BLT SHB ','1','2.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.050' WHERE kode_barang='MTKL-VKBD-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VKBD-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VKBD-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.060,berat_hancur_asli=berat_hancur_asli+2.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VKBD-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-251227-0001','105','MTKL-WDAE-157-0','TOKO','BTKLMT','KL ITALY ST 42CM KKT S SHB ','1','2.690','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.680' WHERE kode_barang='MTKL-WDAE-157-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAE-157-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAE-157-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 ='BTKLMT' AND kode_barang='MTKL-WDAE-157-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','106','MTKL-WABX-83-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','5.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.950' WHERE kode_barang='MTKL-WABX-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WABX-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WABX-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.960,berat_hancur_asli=berat_hancur_asli+5.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WABX-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','107','MTKL-XDXD-70-0','TOKO','BTKLMT','KL FANCY PJG 66CM KKT PER SHB ','1','10.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='10.130' WHERE kode_barang='MTKL-XDXD-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XDXD-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XDXD-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.140,berat_hancur_asli=berat_hancur_asli+10.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XDXD-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-251227-0001','108','MTKL-WAAI-65-0','TOKO','BTKLMT','KL MOCCA VIGARO 43CM KKT PER BLT SHB','1','5.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.020' WHERE kode_barang='MTKL-WAAI-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WAAI-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WAAI-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.030,berat_hancur_asli=berat_hancur_asli+5.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WAAI-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','109','MTKL-WBBB-76-0','TOKO','BTKLMT','KL MOCCA 42CM KKT S SHB ','1','5.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.040' WHERE kode_barang='MTKL-WBBB-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBBB-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBBB-76-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 ='BTKLMT' AND kode_barang='MTKL-WBBB-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-251227-0001','110','MTKL-XAXI-24-0','TOKO','BTKLMT','KL CATENA JEDAR 42CM KKT S SHB ','1','2.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.430' WHERE kode_barang='MTKL-XAXI-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XAXI-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XAXI-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.440,berat_hancur_asli=berat_hancur_asli+2.440, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XAXI-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-251227-0001','111','MTKL-WBBB-75-0','TOKO','BTKLMT','KL MOCCA 43CM KKT S UBS ','1','4.990','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='4.980' WHERE kode_barang='MTKL-WBBB-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBBB-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBBB-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.990,berat_hancur_asli=berat_hancur_asli+4.990, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBBB-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','112','MTKL-XDXD-68-0','TOKO','BTKLMT','KL FANCY ANAK 33CM KKT S SHB ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.020' WHERE kode_barang='MTKL-XDXD-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XDXD-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XDXD-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XDXD-68-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','113','MTKL-WCBH-181-0','TOKO','BTKLMT','KL GUCCI 44CM KKT PER HWT ','1','5.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.120' WHERE kode_barang='MTKL-WCBH-181-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBH-181-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBH-181-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.130,berat_hancur_asli=berat_hancur_asli+5.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBH-181-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','114','MTKL-UEXF-109-0','TOKO','BTKLMT','KL FANCY 41CM KKT S SHB ','1','1.990','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.980' WHERE kode_barang='MTKL-UEXF-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UEXF-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UEXF-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.990,berat_hancur_asli=berat_hancur_asli+1.990, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UEXF-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','115','MTKL-WGBX-145-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT PER SHB ','1','2.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.910' WHERE kode_barang='MTKL-WGBX-145-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WGBX-145-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WGBX-145-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.920,berat_hancur_asli=berat_hancur_asli+2.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WGBX-145-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','116','MTKL-XCBA-121-0','TOKO','BTKLMT','KL VANESSA ANAK 33CM KKT S SHB ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='1.920' WHERE kode_barang='MTKL-XCBA-121-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCBA-121-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCBA-121-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 ='BTKLMT' AND kode_barang='MTKL-XCBA-121-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','117','MTKL-WFXC-112-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT PER SHB ','1','2.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.860' WHERE kode_barang='MTKL-WFXC-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WFXC-112-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WFXC-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.870,berat_hancur_asli=berat_hancur_asli+2.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WFXC-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-251227-0001','118','MTKL-WBBB-83-0','TOKO','BTKLMT','KL TARO PJG 65CM KKT PER SHB','1','11.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='11.960' WHERE kode_barang='MTKL-WBBB-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WBBB-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WBBB-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.970,berat_hancur_asli=berat_hancur_asli+11.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WBBB-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','119','MTKL-XLXB-63-0','TOKO','BTKLMT','KL SATELIT 47CM KKT PER SHB ','1','10.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='10.810' WHERE kode_barang='MTKL-XLXB-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XLXB-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XLXB-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.820,berat_hancur_asli=berat_hancur_asli+10.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XLXB-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-251227-0001','120','MTKL-XACA-204-0','TOKO','BTKLMT','KL ANAK MILANO DB 33CM KKT PER BLT SHB ','1','2.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.710' WHERE kode_barang='MTKL-XACA-204-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XACA-204-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XACA-204-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.720,berat_hancur_asli=berat_hancur_asli+2.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XACA-204-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','121','MTKL-XKXD-54-0','TOKO','BTKLMT','KL CASTELI SLP 48CM KKT PER SHB ','1','5.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='5.370' WHERE kode_barang='MTKL-XKXD-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXD-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXD-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.380,berat_hancur_asli=berat_hancur_asli+5.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXD-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-251227-0001','122','MTKL-WHAB-70-0','TOKO','BTKLMT','KL KOREA 43CM KKT S SHB ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.020' WHERE kode_barang='MTKL-WHAB-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WHAB-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WHAB-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WHAB-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-251227-0001','123','MTKL-UDAE-97-0','TOKO','BTKLMT','KL MILANO ICE ANK 34CM KKT PER SHB','1','3.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.970' WHERE kode_barang='MTKL-UDAE-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDAE-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDAE-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.980,berat_hancur_asli=berat_hancur_asli+3.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDAE-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-251227-0001','124','MTKL-WGBX-144-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT PER SHB ','1','2.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.870' WHERE kode_barang='MTKL-WGBX-144-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WGBX-144-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WGBX-144-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.880,berat_hancur_asli=berat_hancur_asli+2.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WGBX-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-251227-0001','125','MTKL-WABX-84-0','TOKO','BTKLMT','KL VANESSA VAR TRG 44CM KKT S SHB ','1','8.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='8.500' WHERE kode_barang='MTKL-WABX-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WABX-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WABX-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.510,berat_hancur_asli=berat_hancur_asli+8.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WABX-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-251227-0001','126','MTKL-WDAC-54-0','TOKO','BTKLMT','KL HL RT 44CM KKT S SHB ','1','7.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='7.970' WHERE kode_barang='MTKL-WDAC-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAC-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAC-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.980,berat_hancur_asli=berat_hancur_asli+7.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDAC-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-251227-0001','127','MTKL-VLAX-91-0','TOKO','BTKLMT','KL ITALY ST 46CM KKT S SHB ','1','3.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='3.590' WHERE kode_barang='MTKL-VLAX-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-VLAX-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-VLAX-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.600,berat_hancur_asli=berat_hancur_asli+3.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-VLAX-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-251227-0001','128','MTKL-WCBG-136-0','TOKO','BTKLMT','KL HL RT PAPRAS 49CM KKT S SHB ','1','24.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='24.920' WHERE kode_barang='MTKL-WCBG-136-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCBG-136-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCBG-136-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+24.930,berat_hancur_asli=berat_hancur_asli+24.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCBG-136-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','129','MTKL-UDXH-152-0','TOKO','BTKLMT','KL FANCY 44CM KKT S SHB','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='2.030' WHERE kode_barang='MTKL-UDXH-152-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-UDXH-152-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-UDXH-152-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-UDXH-152-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','130','MTKL-WDAC-51-0','TOKO','BTKLMT','KL HL RT 45CM KKT S SHB ','1','7.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='6.990' WHERE kode_barang='MTKL-WDAC-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAC-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAC-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.000,berat_hancur_asli=berat_hancur_asli+7.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDAC-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-251227-0001','131','MTKL-WDAC-56-0','TOKO','BTKLMT','KL HL RT 43CM KKT S SHB ','1','10.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.990' WHERE kode_barang='MTKL-WDAC-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WDAC-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WDAC-56-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.000,berat_hancur_asli=berat_hancur_asli+10.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WDAC-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-251227-0001','132','MTKL-XEBE-80-0','TOKO','BTKLMT','KL KOREA 43CM KKT S SHB ','1','10.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='9.990' WHERE kode_barang='MTKL-XEBE-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.000,berat_hancur_asli=berat_hancur_asli+10.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XEBE-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-251227-0001','133','MTKL-WCAG-103-0','TOKO','BTKLMT','KL FANCY 44CM KKT S SHB ','1','10.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-12-27 11:11:40',status_delete='10.000' WHERE kode_barang='MTKL-WCAG-103-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WCAG-103-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WCAG-103-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.010,berat_hancur_asli=berat_hancur_asli+10.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-WCAG-103-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-251227-0001','2025-12-27','admin','2025-12-27','11:11:40','admin','2025-12-27 11:11:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-27 ','11:18:17');
UPDATE tt_hutang_head SET byr_harus_rp='7000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'7196000',tgl_lunas='2025-12-27',status='CLOS',total_lunas='7196000' WHERE no_hutang='PI25-01620';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'7000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'7000000'  WHERE tanggal='2025-12-27';
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-251227-0005','D','2025-12-27','11:26:24','cashier1','HUTANG LUNAS','PI25-01620','238641576','7196000','245837576');
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-251227-0001','sales','1',' ','TOKO','BTLTMT','MTLT-YLXA-22-0','LT CAP PLAT LM SHB ','','1.940','1','100.00','3560000','0','0','0','3560000','0','0','0','3560000','2503','00026897','MTLT','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTLT-YLXA-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2025-12-27' AND kode_barang='MTLT-YLXA-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251227-0001','2025-12-27','1.940','2025-12-27','13:55:09','PLG0017792','3560000','3560000','0','3560000','3560000','sales','2025-12-27 13:55:09','FJ-251227-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-27','FJ-251227-0001','2025-12-27','13:55:09','2503','3560000','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-251227-0006','D','2025-12-27','13:55:09','sales','PENJUALAN','FJ-251227-0001','245837576','3560000','249397576');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-27 ','13:55:21');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251227-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251227-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251227-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-12-27 ','14:35:39');
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-251227-0007','K','2025-12-27','14:35:56','cashier1','PENGELUARAN','SETOR PUSAT PAK BUDI','249397576','100000000','149397576');