INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','08:09:06'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','08:22:30'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-27 ','08:33:30'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-27','110','0','-214600000','110','0','-214600000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-26'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-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='2026-10-26' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-26'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-26'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-27' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-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-261027-0001','D','2026-10-27','08:33:43','','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-261027-0001','D','2026-10-27','08:33:43','BCA','SALDO AWAL','SALDO AWAL','0','1399094082','1399094082'); UPDATE tp_system SET tgl_system='2026-10-27'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-27 ','08:34:06'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-27 ','09:08:58'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','09:43:13'); INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261027-0001','1','X-00009951','BELI','BELI001','LT CAP PLAT LM SHB','1','1.010','933500.00' ,'0.00','933500','','933500','933500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-27 09:43:50' WHERE kode_barang='X-00009951' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009951' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009951' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.010',berat_hancur_asli=berat_hancur_asli+'1.010', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDLT' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261027-0001','2','X-00009952','BELI','BELI001','AT TUSUK ITALY TDK BT SHB','1','1.470','1359000.00' ,'0.00','1359000','','1359000','3226000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-27 09:43:50' WHERE kode_barang='X-00009952' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009952' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009952' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.470',berat_hancur_asli=berat_hancur_asli+'1.470', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-261027-0001','adminpusat','2026-10-27','2026-10-27','09:43:51','2292500','3226000', 'adminpusat','2026-10-27 09:43:50'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','10:31:06'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-27 ','11:00:48'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','11:45:48'); UPDATE tt_hutang_head SET byr_harus_rp='2000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'2292000',tgl_lunas='2026-10-27',status='CLOS',total_lunas='2292000' WHERE no_hutang='PI25-01407'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000' WHERE tanggal='2026-10-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-261027-0002','D','2026-10-27','12:20:14','cashier1','HUTANG LUNAS','PI25-01407','196391086','2292000','198683086'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-27 ','14:25:34'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-10-27 ','15:42:34'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','1','MDLT-XGCX-38-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.930','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.920' WHERE kode_barang='MDLT-XGCX-38-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XGCX-38-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XGCX-38-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 ='BTLTMD' AND kode_barang='MDLT-XGCX-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-261027-0002','2','MDLT-XGCX-39-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','3.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.990' WHERE kode_barang='MDLT-XGCX-39-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XGCX-39-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XGCX-39-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 ='BTLTMD' AND kode_barang='MDLT-XGCX-39-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','3','MDLT-XKAA-114-0','TOKO','BTLTMD','LT COR FORT HURUF O BG ','1','0.660','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.650' WHERE kode_barang='MDLT-XKAA-114-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-114-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-114-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.660,berat_hancur_asli=berat_hancur_asli+0.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-114-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','4','MDLT-XKAA-122-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.020','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.010' WHERE kode_barang='MDLT-XKAA-122-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-122-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-122-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.020,berat_hancur_asli=berat_hancur_asli+2.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-122-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','5','MDLT-XKAA-124-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.950' WHERE kode_barang='MDLT-XKAA-124-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-124-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-124-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-124-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','6','MDLT-XKAA-125-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.900','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.890' WHERE kode_barang='MDLT-XKAA-125-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-125-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-125-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.900,berat_hancur_asli=berat_hancur_asli+1.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-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-261027-0002','7','MDLT-XKAA-126-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.060','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.050' WHERE kode_barang='MDLT-XKAA-126-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-126-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-126-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-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-261027-0002','8','MDLT-XKAA-128-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.820','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.810' WHERE kode_barang='MDLT-XKAA-128-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-128-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-128-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.820,berat_hancur_asli=berat_hancur_asli+2.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-128-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','9','MDLT-XKAA-130-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.910','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.900' WHERE kode_barang='MDLT-XKAA-130-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-130-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-130-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-130-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','10','MDLT-XKAA-131-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.950' WHERE kode_barang='MDLT-XKAA-131-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-131-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-131-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.960,berat_hancur_asli=berat_hancur_asli+2.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-131-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','11','MDLT-XKAA-132-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','3.010','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='3.000' WHERE kode_barang='MDLT-XKAA-132-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-132-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-132-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-132-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','12','MDLT-XKAA-133-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','3.100','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='3.090' WHERE kode_barang='MDLT-XKAA-133-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-133-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-133-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-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-261027-0002','13','MDLT-XKAA-134-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.980','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='2.970' WHERE kode_barang='MDLT-XKAA-134-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-134-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-134-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-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-261027-0002','14','MDLT-YKXE-151-0','TOKO','BTLTMD','LT COR TDK BT LC2 ','1','1.400','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.390' WHERE kode_barang='MDLT-YKXE-151-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-151-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YKXE-151-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.400,berat_hancur_asli=berat_hancur_asli+1.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YKXE-151-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','15','MDLT-YCAC-80-0','TOKO','BTLTMD','LT ANAK CAT UBS ','1','0.600','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.590' WHERE kode_barang='MDLT-YCAC-80-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YCAC-80-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YCAC-80-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.600,berat_hancur_asli=berat_hancur_asli+0.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YCAC-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-261027-0002','16','MDLT-YEXE-69-0','TOKO','BTLTMD','LT COR BT SHB ','1','0.940','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.930' WHERE kode_barang='MDLT-YEXE-69-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YEXE-69-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YEXE-69-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YEXE-69-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','17','MDLT-YCAE-14-0','TOKO','BTLTMD','LT COR BT MK ','1','0.930','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.920' WHERE kode_barang='MDLT-YCAE-14-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YCAE-14-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YCAE-14-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.930,berat_hancur_asli=berat_hancur_asli+0.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YCAE-14-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','18','MDLT-YFBX-37-0','TOKO','BTLTMD','LT COR BT MK ','1','1.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.990' WHERE kode_barang='MDLT-YFBX-37-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-37-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-37-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','19','MDLT-YFBX-60-0','TOKO','BTLTMD','LT COR BT SHB ','1','0.860','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.850' WHERE kode_barang='MDLT-YFBX-60-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-60-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-60-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.860,berat_hancur_asli=berat_hancur_asli+0.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','20','MDLT-YFAH-60-0','TOKO','BTLTMD','LT COR VC UBS ','1','0.970','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.960' WHERE kode_barang='MDLT-YFAH-60-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFAH-60-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFAH-60-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.970,berat_hancur_asli=berat_hancur_asli+0.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFAH-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-261027-0002','21','MDLT-YFBX-58-0','TOKO','BTLTMD','LT COR BT SHB','1','0.920','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.910' WHERE kode_barang='MDLT-YFBX-58-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-58-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-58-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.920,berat_hancur_asli=berat_hancur_asli+0.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','22','MDLT-YFBX-64-0','TOKO','BTLTMD','LT COR BT SHB ','1','1.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.040' WHERE kode_barang='MDLT-YFBX-64-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-64-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-64-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','23','MDLT-YFBX-55-0','TOKO','BTLTMD','LT COR BT SHB ','1','0.810','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.800' WHERE kode_barang='MDLT-YFBX-55-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-55-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-55-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.810,berat_hancur_asli=berat_hancur_asli+0.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-55-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','24','MDLT-YFBX-49-0','TOKO','BTLTMD','LT COR BT MK ','1','1.020','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.010' WHERE kode_barang='MDLT-YFBX-49-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-49-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-49-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-49-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0002','25','MDLT-YFBX-63-0','TOKO','BTLTMD','LT COR BT SHB ','1','1.080','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.070' WHERE kode_barang='MDLT-YFBX-63-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-63-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-63-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','26','MDLT-YHBH-82-0','TOKO','BTLTMD','LT COR BT SHB ','1','0.780','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='0.770' WHERE kode_barang='MDLT-YHBH-82-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YHBH-82-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YHBH-82-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.780,berat_hancur_asli=berat_hancur_asli+0.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YHBH-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-261027-0002','27','MDLT-YFBX-51-0','TOKO','BTLTMD','LT COR BT MK ','1','1.020','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.010' WHERE kode_barang='MDLT-YFBX-51-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-51-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-51-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-261027-0002','28','MDLT-YFBX-41-0','TOKO','BTLTMD','LT COR BT MK ','1','1.040','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:48:48',status_delete='1.030' WHERE kode_barang='MDLT-YFBX-41-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-41-0'; DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-41-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.040,berat_hancur_asli=berat_hancur_asli+1.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-41-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-261027-0002','2026-10-27','admin','2026-10-27','15:48:48','admin','2026-10-27 15:48:48'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0003','1','MDGL-YABE-35-0','TOKO','BTGLMD','GL PIPA BT AD WRN SMBR PTH UBS','1','9.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='9.950' WHERE kode_barang='MDGL-YABE-35-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YABE-35-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YABE-35-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.960,berat_hancur_asli=berat_hancur_asli+9.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YABE-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-261027-0003','2','MDGL-YCXG-30-0','TOKO','BTGLMD','GL PIPA BT AD MRH UBS ','1','10.070','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='10.060' WHERE kode_barang='MDGL-YCXG-30-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YCXG-30-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YCXG-30-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.070,berat_hancur_asli=berat_hancur_asli+10.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YCXG-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-261027-0003','3','MDGL-YFBX-30-0','TOKO','BTGLMD','GL PIPA TDK BT SMBR PTH UBS ','1','10.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='10.040' WHERE kode_barang='MDGL-YFBX-30-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YFBX-30-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YFBX-30-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.050,berat_hancur_asli=berat_hancur_asli+10.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YFBX-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-261027-0003','4','MDGL-YHBH-74-0','TOKO','BTGLMD','GL BANGKOK TALI AIR SMBR PTH UBS ','1','5.110','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='5.100' WHERE kode_barang='MDGL-YHBH-74-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-74-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-74-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.110,berat_hancur_asli=berat_hancur_asli+5.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YHBH-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-261027-0003','5','MDGL-YHBH-71-0','TOKO','BTGLMD','GL PIPA BT UBS ','1','4.100','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='4.090' WHERE kode_barang='MDGL-YHBH-71-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-71-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-71-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 ='BTGLMD' AND kode_barang='MDGL-YHBH-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-261027-0003','6','MDGL-YHBH-68-0','TOKO','BTGLMD','GL BABY CAT UBS ','1','1.980','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='1.970' WHERE kode_barang='MDGL-YHBH-68-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-68-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-68-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.980,berat_hancur_asli=berat_hancur_asli+1.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YHBH-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-261027-0003','7','MDGL-ZBAA-9-0','TOKO','BTGLMD','GL PIPA ANK BTR SMBR PTH UBS ','1','2.560','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='2.550' WHERE kode_barang='MDGL-ZBAA-9-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-9-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBAA-9-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.560,berat_hancur_asli=berat_hancur_asli+2.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-ZBAA-9-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0003','8','MDGL-ZEAI-51-0','TOKO','BTGLMD','GL BABY BTR WRN UBS ','1','2.560','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='2.550' WHERE kode_barang='MDGL-ZEAI-51-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZEAI-51-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-ZEAI-51-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.560,berat_hancur_asli=berat_hancur_asli+2.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-ZEAI-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-261027-0003','9','MDGL-YFAH-45-0','TOKO','BTGLMD','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','3.540','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='3.530' WHERE kode_barang='MDGL-YFAH-45-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YFAH-45-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YFAH-45-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.540,berat_hancur_asli=berat_hancur_asli+3.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YFAH-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-261027-0003','10','MDGL-YHBH-56-0','TOKO','BTGLMD','GL ITALY ST SRT BTR BL PSR 18CM KKT PER SHB ','1','2.680','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='2.670' WHERE kode_barang='MDGL-YHBH-56-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-56-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-56-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.680,berat_hancur_asli=berat_hancur_asli+2.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YHBH-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-261027-0003','11','MDGL-YFBX-18-0','TOKO','BTGLMD','GL KEPANG SMBR PTH 17CM YT ','1','16.660','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='16.650' WHERE kode_barang='MDGL-YFBX-18-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YFBX-18-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YFBX-18-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+16.660,berat_hancur_asli=berat_hancur_asli+16.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YFBX-18-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0003','12','MDGL-YHBH-65-0','TOKO','BTGLMD','GL CAP HOLO 5624 16CM KKT PER SHB ','1','10.800','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='10.790' WHERE kode_barang='MDGL-YHBH-65-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-65-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-65-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.800,berat_hancur_asli=berat_hancur_asli+10.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YHBH-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-261027-0003','13','MDGL-YKXE-80-0','TOKO','BTGLMD','GL HOLO POLES 19CM SHB ','1','24.270','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='24.260' WHERE kode_barang='MDGL-YKXE-80-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-80-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YKXE-80-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+24.270,berat_hancur_asli=berat_hancur_asli+24.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YKXE-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-261027-0003','14','MDGL-YKXE-81-0','TOKO','BTGLMD','GL HOLO POLES 21CM SHB ','1','26.630','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='26.620' WHERE kode_barang='MDGL-YKXE-81-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-81-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YKXE-81-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+26.630,berat_hancur_asli=berat_hancur_asli+26.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMD' AND kode_barang='MDGL-YKXE-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-261027-0003','15','MDGL-YHBH-61-0','TOKO','BTGLMD','GL BTR 16CM KKT PER SHB ','1','3.180','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 15:56:26',status_delete='3.170' WHERE kode_barang='MDGL-YHBH-61-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGL-YHBH-61-0'; DELETE FROM tm_barang WHERE kode_barang='MDGL-YHBH-61-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 ='BTGLMD' AND kode_barang='MDGL-YHBH-61-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-261027-0003','2026-10-27','admin','2026-10-27','15:56:26','admin','2026-10-27 15:56:26'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','1','MDKL-YKAI-4-0','TOKO','BTKLMD','KL HL RT PAPRAS 44CM KKT S UBS ','1','8.080','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='8.070' WHERE kode_barang='MDKL-YKAI-4-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKAI-4-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKAI-4-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.080,berat_hancur_asli=berat_hancur_asli+8.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKAI-4-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','2','MDKL-YHBH-79-0','TOKO','BTKLMD','KL FANCY DB 43CM KKT S SHB ','1','9.400','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='9.390' WHERE kode_barang='MDKL-YHBH-79-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YHBH-79-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YHBH-79-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.400,berat_hancur_asli=berat_hancur_asli+9.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YHBH-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-261027-0004','3','MDKL-YJAG-65-0','TOKO','BTKLMD','KL ITALY ST VAR BT 42CM KKT PER MK ','1','3.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.990' WHERE kode_barang='MDKL-YJAG-65-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YJAG-65-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YJAG-65-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 ='BTKLMD' AND kode_barang='MDKL-YJAG-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-261027-0004','4','MDKL-YKXE-102-0','TOKO','BTKLMD','KL POCO 48CM KKT PER UBS ','1','9.700','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='9.690' WHERE kode_barang='MDKL-YKXE-102-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-102-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-102-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.700,berat_hancur_asli=berat_hancur_asli+9.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-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-261027-0004','5','MDKL-XKAA-101-0','TOKO','BTKLMD','KL KOREA 43CM KKT S MK ','1','20.100','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='20.090' WHERE kode_barang='MDKL-XKAA-101-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-XKAA-101-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-XKAA-101-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.100,berat_hancur_asli=berat_hancur_asli+20.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-XKAA-101-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','6','MDKL-YKXE-91-0','TOKO','BTKLMD','KL FANCY VAR BT VC 39CM KKT PER UBS ','1','2.760','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.750' WHERE kode_barang='MDKL-YKXE-91-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-91-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-91-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.760,berat_hancur_asli=berat_hancur_asli+2.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-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-261027-0004','7','MDKL-YCBE-163-0','TOKO','BTKLMD','KL FANCY ANAK CAT 39CM KKT S LC2 ','1','2.550','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.540' WHERE kode_barang='MDKL-YCBE-163-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YCBE-163-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YCBE-163-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.550,berat_hancur_asli=berat_hancur_asli+2.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YCBE-163-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','8','MDKL-YJAG-66-0','TOKO','BTKLMD','KL FANCY 42CM KKT PER SHB ','1','2.900','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.890' WHERE kode_barang='MDKL-YJAG-66-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YJAG-66-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YJAG-66-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.900,berat_hancur_asli=berat_hancur_asli+2.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YJAG-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-261027-0004','9','MDKL-ZBAB-50-0','TOKO','BTKLMD','KL FANCY VAR BT 42CM KKT S SHB ','1','3.090','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='3.080' WHERE kode_barang='MDKL-ZBAB-50-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZBAB-50-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBAB-50-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.090,berat_hancur_asli=berat_hancur_asli+3.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-ZBAB-50-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','10','MDKL-YKXE-85-0','TOKO','BTKLMD','KL FANCY ANAK 33CM KKT S LL ','1','3.060','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='3.050' WHERE kode_barang='MDKL-YKXE-85-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-85-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-85-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.060,berat_hancur_asli=berat_hancur_asli+3.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-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-261027-0004','11','MDKL-YKXE-98-0','TOKO','BTKLMD','KL FANCY BL PSR WRN 42CM KKT PER UBS ','1','3.100','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='3.090' WHERE kode_barang='MDKL-YKXE-98-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-98-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-98-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 ='BTKLMD' AND kode_barang='MDKL-YKXE-98-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','12','MDKL-YCBE-162-0','TOKO','BTKLMD','KL FANCY ANAK CAT 39CM KKT S LC2 ','1','2.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.660' WHERE kode_barang='MDKL-YCBE-162-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YCBE-162-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YCBE-162-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.670,berat_hancur_asli=berat_hancur_asli+2.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YCBE-162-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','13','MDKL-YHBH-77-0','TOKO','BTKLMD','KL ITALY ST VC HTM 42CM KKT PER MK ','1','2.750','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.740' WHERE kode_barang='MDKL-YHBH-77-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YHBH-77-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YHBH-77-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.750,berat_hancur_asli=berat_hancur_asli+2.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YHBH-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-261027-0004','14','MDKL-YJBI-19-0','TOKO','BTKLMD','KL ITALY ST VAR BTR 42CM KKT PER SHB ','1','2.970','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.960' WHERE kode_barang='MDKL-YJBI-19-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YJBI-19-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YJBI-19-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 ='BTKLMD' AND kode_barang='MDKL-YJBI-19-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','15','MDKL-YKXE-111-0','TOKO','BTKLMD','KL ITALY ST VC HTM 42CM KKT PER MK ','1','3.130','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='3.120' WHERE kode_barang='MDKL-YKXE-111-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-111-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-111-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.130,berat_hancur_asli=berat_hancur_asli+3.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-111-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','16','MDKL-YKXE-113-0','TOKO','BTKLMD','KL ITALY ST CAT HURUF H 42CM KKT PER MK ','1','2.900','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.890' WHERE kode_barang='MDKL-YKXE-113-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-113-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-113-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.900,berat_hancur_asli=berat_hancur_asli+2.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-113-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','17','MDKL-YBBF-113-0','TOKO','BTKLMD','KL ITALY ST ANAK VAR BT 34CM KKT PER SHB ','1','2.170','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.160' WHERE kode_barang='MDKL-YBBF-113-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YBBF-113-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YBBF-113-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.170,berat_hancur_asli=berat_hancur_asli+2.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YBBF-113-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','18','MDKL-YKXE-108-0','TOKO','BTKLMD','KL ITALY ST VAR BT 42CM KKT PER SHB ','1','3.520','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='3.510' WHERE kode_barang='MDKL-YKXE-108-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-108-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-108-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.520,berat_hancur_asli=berat_hancur_asli+3.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-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-261027-0004','19','MDKL-YCBE-165-0','TOKO','BTKLMD','KL FANCY ANAK CAT 39CM KKT S LC2 ','1','2.370','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.360' WHERE kode_barang='MDKL-YCBE-165-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YCBE-165-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YCBE-165-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 ='BTKLMD' AND kode_barang='MDKL-YCBE-165-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261027-0004','20','MDKL-YKXE-88-0','TOKO','BTKLMD','KL ITALY ST 42CM KKT PER SHB ','1','2.280','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.270' WHERE kode_barang='MDKL-YKXE-88-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-88-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-88-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.280,berat_hancur_asli=berat_hancur_asli+2.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-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-261027-0004','21','MDKL-YKXE-87-0','TOKO','BTKLMD','KL ITALY ST 42CM KKT PER SHB ','1','2.060','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-27 16:02:29',status_delete='2.050' WHERE kode_barang='MDKL-YKXE-87-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-87-0'; DELETE FROM tm_barang WHERE kode_barang='MDKL-YKXE-87-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 ='BTKLMD' AND kode_barang='MDKL-YKXE-87-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-261027-0004','2026-10-27','admin','2026-10-27','16:02:29','admin','2026-10-27 16:02:29'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-27 ','16:06:07');