INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250824-0001','1','F1E-XIXC-89-0','TOKO','BK-F','GL OVAL C SLEP UB 56 8K ','1','1.350','SALAH INPUT');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 12:19:20',status_delete='1.350' WHERE kode_barang='F1E-XIXC-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1E-XIXC-89-0';
DELETE FROM tm_barang WHERE kode_barang='F1E-XIXC-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-F' AND kode_barang='F1E-XIXC-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-250824-0001','2','F3E-XIXC-27-0','TOKO','BK-F','GL CAPELLA SLEP LT 8K ','1','1.480','SALAH GRAMASI');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 12:19:20',status_delete='1.480' WHERE kode_barang='F3E-XIXC-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3E-XIXC-27-0';
DELETE FROM tm_barang WHERE kode_barang='F3E-XIXC-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.480,berat_hancur_asli=berat_hancur_asli+1.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-F' AND kode_barang='F3E-XIXC-27-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-250824-0001','2025-08-24','irgosa','2025-08-24','12:19:20','irgosa','2025-08-24 12:19:20');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250824-0002','1','D1F-XIAA-182-0','TOKO','BK-D','LT X MODEL SPECTRA HITAM TD 8K ','1','0.850','SALAH INPUT');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='0.850' WHERE kode_barang='D1F-XIAA-182-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D1F-XIAA-182-0';
DELETE FROM tm_barang WHERE kode_barang='D1F-XIAA-182-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.850,berat_hancur_asli=berat_hancur_asli+0.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-D' AND kode_barang='D1F-XIAA-182-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250824-0002','2','E1D-YAXD-192-0','TOKO','BK-E','CC X MODEL SLEP LG 14 8K ','1','120.000','SALAH INPUT');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='120.000' WHERE kode_barang='E1D-YAXD-192-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-YAXD-192-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-YAXD-192-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+120.000,berat_hancur_asli=berat_hancur_asli+120.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-E' AND kode_barang='E1D-YAXD-192-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250824-0002','3','E1F-XJAF-50-0','TOKO','BK-E','CC MODEL SLEP BG 14 8K ','1','0.650','PS BKL');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='0.650' WHERE kode_barang='E1F-XJAF-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1F-XJAF-50-0';
DELETE FROM tm_barang WHERE kode_barang='E1F-XJAF-50-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-E' AND kode_barang='E1F-XJAF-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-250824-0002','4','E1F-XJAF-48-0','TOKO','BK-E','CC MODEL SLEP BG 14 8K ','1','0.650','PS BKL');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='0.650' WHERE kode_barang='E1F-XJAF-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1F-XJAF-48-0';
DELETE FROM tm_barang WHERE kode_barang='E1F-XJAF-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-E' AND kode_barang='E1F-XJAF-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-250824-0002','5','A1E-XJXE-5-0','TOKO','BK-A','AT CANDY SLEP 2C KH 8K ','1','0.970','RSK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='0.970' WHERE kode_barang='A1E-XJXE-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XJXE-5-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XJXE-5-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 ='BK-A' AND kode_barang='A1E-XJXE-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-250824-0002','6','A1E-XKCX-232-0','TOKO','BK-A','AT X TIFF MATA VAR LG 8K ','1','0.980','RSK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-08-24 14:13:51',status_delete='0.980' WHERE kode_barang='A1E-XKCX-232-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XKCX-232-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XKCX-232-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.980,berat_hancur_asli=berat_hancur_asli+0.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BK-A' AND kode_barang='A1E-XKCX-232-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-250824-0002','2025-08-24','irgosa','2025-08-24','14:13:51','irgosa','2025-08-24 14:13:51');
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-250824-0002','K','2025-08-24','21:27:48','irgosa','BELANJA','BENERIN KLIRU TULIS KEBANYAKAN NOL NYA','19318710000','19318710000','0');