INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-04 ','08:19:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-04 ','08:26:59');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-04','120','0','-170550000','120','0','-170550000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-03';
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-08-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-03' 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-260804-0001','D','2026-08-04','08:27:14','BCA','SALDO AWAL','SALDO AWAL','0','2006825755','2006825755');
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-260804-0001','D','2026-08-04','08:27:14','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-04 ','08:27:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-04 ','08:37:12');
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-260804-0001','1','X-00009692','BELI','BELI001','GL HL RANTAI PLT BT 18CM KKT S SHB','1','13.970','22491500.00' ,'0.00','22491500','','22491500','22491500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-04 08:37:36' WHERE kode_barang='X-00009692' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009692' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009692' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'13.970',berat_hancur_asli=berat_hancur_asli+'13.970', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'13.970',berat_akhir_asli=berat_akhir_asli-'13.970' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-260804-0001','2','X-00009693','BELI','BELI001','LT COR BT MK','1','1.090','890000.00' ,'0.00','890000','','890000','45873000','RUSAK BIASA');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-04 08:37:36' WHERE kode_barang='X-00009693' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009693' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009693' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.090',berat_hancur_asli=berat_hancur_asli+'1.090', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDLT' 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-260804-0001','adminpusat','2026-08-04','2026-08-04','08:37:36','23381500','45873000', 'adminpusat','2026-08-04 08:37:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-08-04 ','08:49:50');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009694','X-00009694','CN COR BT SHB','GR','---','MDCN','BELI','BELI001','788500','2026-08-04','0.830','1','sales','2026-08-04 10:22:24');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009694','X-00009694');
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-260804-0001','FJ-260715-0002','2402','1','BELI','BELI001','MDCN', 'X-00009694', 'CN COR BT SHB','0.830','0.830','100.00','917500','788500','950000','1','788500','788500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-04','BELI','BELI001','MDCN','MDCN','100.00','0.830','0.830','1','0.830','0.830','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-260804-0001','2026-08-04','2026-08-04','10:22:24','2402','---','0.830','788500','788500','788500','788500','788500','sales','2026-08-04 10:22:24','FB-260804-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260804-0001','RAHMA','KAPASAN BARU 10/17','','','089612071567','sales','2026-08-04 10:22:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-04' 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-260804-0002','K','2026-08-04','10:22:24','sales','PEMBELIAN UMUM','FB-260804-0001','159668571','788500','158880071','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260804-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260804-0001';
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-260804-0001','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZEAI-27-0','CN COR EROPA SHB ','','2.850','1','100.00','3149500','0','0','0','3149500','0','0','0','3149500','2105','00029669','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAI-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-08-04' AND kode_barang='MDCN-ZEAI-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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-260804-0001','2026-08-04','2.850','2026-08-04','12:07:28','PLG0019271','3149500','3149500','0','3149500','3149500','sales','2026-08-04 12:07:28','FJ-260804-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-04','FJ-260804-0001','2026-08-04','12:07:28','2105','3149500','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-260804-0003','D','2026-08-04','12:07:28','sales','PENJUALAN','FJ-260804-0001','158880071','3149500','162029571');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260804-0001';
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-260804-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZBBE-1-0','CN COR BT MK ','','1.030','1','100.00','1138500','0','0','0','1138500','0','0','0','1138500','2402','00028759','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBBE-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-08-04' AND kode_barang='MDCN-ZBBE-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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-260804-0002','2026-08-04','1.030','2026-08-04','12:11:44','PLG0019272','1138500','1138500','0','1138500','1138500','sales','2026-08-04 12:11:44','FJ-260804-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-04','FJ-260804-0002','2026-08-04','12:11:44','2402','1138500','0');
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 ('KM-260804-0004','D','2026-08-04','12:11:44','sales','PENJUALAN','FJ-260804-0002','162029571','1138500','163168071','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1138500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260804-0002' LIMIT 1;
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-260804-0003','sales',' 1',' ','TOKO','BTCNMD','MDCN-ZBXF-106-0','CN COR BT SHB ','','1.420','1','100.00','1569500','0','0','0','1569500','0','0','0','1569500','2402','00027752','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-08-04' AND kode_barang='MDCN-ZBXF-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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-260804-0003','2026-08-04','1.420','2026-08-04','12:11:44','PLG0019273','1569500','1569500','0','1569500','1569500','sales','2026-08-04 12:11:44','FJ-260804-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-04','FJ-260804-0003','2026-08-04','12:11:44','2402','1569500','0');
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 ('KM-260804-0005','D','2026-08-04','12:11:44','sales','PENJUALAN','FJ-260804-0003','163168071','1569500','164737571','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1569500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260804-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260804-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260804-0003';
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-260804-0004','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZFAE-19-0','CN SESER SHB ','','6.010','1','100.00','10998500','0','0','0','10998500','0','0','0','10998500','2105','00030278','MTCN','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAE-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.010',berat_jual_asli=berat_jual_asli+'6.010',stock_jual='1',berat_akhir=berat_akhir-'6.010',berat_akhir_asli=berat_akhir_asli-'6.010',stock_akhir='0' WHERE tanggal='2026-08-04' AND kode_barang='MTCN-ZFAE-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-260804-0004','2026-08-04','6.010','2026-08-04','13:17:06','PLG0019274','10998500','10998500','0','10998500','10998500','sales','2026-08-04 13:17:05','FJ-260804-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-04','FJ-260804-0004','2026-08-04','13:17:06','2105','10998500','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-260804-0006','D','2026-08-04','13:17:06','sales','PENJUALAN','FJ-260804-0004','164737571','10998500','175736071');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260804-0004';
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-260804-0007','K','2026-08-04','14:30:28','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB','175736071','54000','175682071');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-08-04 ','15:24:03');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','1','MDAT-XKXH-107-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.450' WHERE kode_barang='MDAT-XKXH-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXH-107-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXH-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.460,berat_hancur_asli=berat_hancur_asli+1.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXH-107-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','2','MDAT-XKXD-59-0','TOKO','BTATMD','AT COR KLP TDK BT UBS ','1','1.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.930' WHERE kode_barang='MDAT-XKXD-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XKXD-59-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XKXD-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.940,berat_hancur_asli=berat_hancur_asli+1.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XKXD-59-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','3','MDAT-YABD-5-0','TOKO','BTATMD','AT COR KLP BT SHB ','1','1.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.380' WHERE kode_barang='MDAT-YABD-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.390,berat_hancur_asli=berat_hancur_asli+1.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','4','MDAT-YABD-2-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.190' WHERE kode_barang='MDAT-YABD-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-2-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.200,berat_hancur_asli=berat_hancur_asli+1.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','5','MDAT-YABD-4-0','TOKO','BTATMD','AT COR KLP BT AD MRH UBS ','1','1.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.690' WHERE kode_barang='MDAT-YABD-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-4-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-4-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 ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','6','MDAT-YABD-7-0','TOKO','BTATMD','AT COR KLP TDK BT MK ','1','1.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.740' WHERE kode_barang='MDAT-YABD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.750,berat_hancur_asli=berat_hancur_asli+1.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-7-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','7','MDAT-YABD-13-0','TOKO','BTATMD','AT COR KAWAT FORTUNE LC2 ','1','3.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='3.330' WHERE kode_barang='MDAT-YABD-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.340,berat_hancur_asli=berat_hancur_asli+3.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','8','MDAT-YABD-8-0','TOKO','BTATMD','AT CAP KAWAT BTR BT SHB ','1','1.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.810' WHERE kode_barang='MDAT-YABD-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.820,berat_hancur_asli=berat_hancur_asli+1.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','9','MDAT-YABD-10-0','TOKO','BTATMD','AT CAP KAWAT BTR BT SHB ','1','1.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.800' WHERE kode_barang='MDAT-YABD-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-10-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-10-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','10','MDAT-YBBH-7-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.520' WHERE kode_barang='MDAT-YBBH-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBH-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBH-7-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 ='BTATMD' AND kode_barang='MDAT-YBBH-7-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','11','MDAT-YBBH-16-0','TOKO','BTATMD','AT COR KAWAT FORTUNE LC2 ','1','4.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='4.090' WHERE kode_barang='MDAT-YBBH-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBH-16-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBH-16-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 ='BTATMD' AND kode_barang='MDAT-YBBH-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-260804-0002','12','MDAT-YCBE-136-0','TOKO','BTATMD','AT TUSUK ITALY SMBR PTH LC2 ','1','2.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='2.450' WHERE kode_barang='MDAT-YCBE-136-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-136-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-136-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.460,berat_hancur_asli=berat_hancur_asli+2.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCBE-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-260804-0002','13','MDAT-YFAI-18-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.280' WHERE kode_barang='MDAT-YFAI-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YFAI-18-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YFAI-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.290,berat_hancur_asli=berat_hancur_asli+1.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YFAI-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-260804-0002','14','MDAT-YKXD-39-0','TOKO','BTATMD','AT COR KAWAT BT MK ','1','1.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.620' WHERE kode_barang='MDAT-YKXD-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-39-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.630,berat_hancur_asli=berat_hancur_asli+1.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-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-260804-0002','15','MDAT-YKXD-6-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.470' WHERE kode_barang='MDAT-YKXD-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-6-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.480,berat_hancur_asli=berat_hancur_asli+0.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-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-260804-0002','16','MDAT-YLXA-60-0','TOKO','BTATMD','AT JEPSI SLP KEMBANG MK ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.970' WHERE kode_barang='MDAT-YLXA-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YLXA-60-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-60-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 ='BTATMD' AND kode_barang='MDAT-YLXA-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-260804-0002','17','MDAT-YKXD-13-0','TOKO','BTATMD','AT JEPSI SLP KEMBANG MK ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.970' WHERE kode_barang='MDAT-YKXD-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-13-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 ='BTATMD' AND kode_barang='MDAT-YKXD-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','18','MDAT-YKXD-12-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.970' WHERE kode_barang='MDAT-YKXD-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-12-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 ='BTATMD' AND kode_barang='MDAT-YKXD-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-260804-0002','19','MDAT-ZBXF-3-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.030' WHERE kode_barang='MDAT-ZBXF-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZBXF-3-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBXF-3-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 ='BTATMD' AND kode_barang='MDAT-ZBXF-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-260804-0002','20','MDAT-ZBXF-27-0','TOKO','BTATMD','AT TUSUK ITALY TDK BT SMBR PTH LC2 ','1','2.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='2.320' WHERE kode_barang='MDAT-ZBXF-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZBXF-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBXF-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.330,berat_hancur_asli=berat_hancur_asli+2.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-ZBXF-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-260804-0002','21','MDAT-ZCBG-2-0','TOKO','BTATMD','AT JEPSI SLP KEMBANG SHB ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.950' WHERE kode_barang='MDAT-ZCBG-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZCBG-2-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZCBG-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.960,berat_hancur_asli=berat_hancur_asli+0.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-ZCBG-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-260804-0002','22','MDAT-XFBG-7-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.020' WHERE kode_barang='MDAT-XFBG-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XFBG-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XFBG-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XFBG-7-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','23','MDAT-XIAD-7-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.330' WHERE kode_barang='MDAT-XIAD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XIAD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XIAD-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XIAD-7-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','24','MDAT-XIAD-5-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.270' WHERE kode_barang='MDAT-XIAD-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XIAD-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XIAD-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.280,berat_hancur_asli=berat_hancur_asli+1.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XIAD-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-260804-0002','25','MDAT-XJAF-9-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.320' WHERE kode_barang='MDAT-XJAF-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-9-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.330,berat_hancur_asli=berat_hancur_asli+1.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-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-260804-0002','26','MDAT-XJAF-31-0','TOKO','BTATMD','AT TUSUK ITALY BL DSC SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.830' WHERE kode_barang='MDAT-XJAF-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-31-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.840,berat_hancur_asli=berat_hancur_asli+0.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','27','MDAT-YABD-24-0','TOKO','BTATMD','AT TUSUK ITALY BL SLP SHB ','1','0.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.800' WHERE kode_barang='MDAT-YABD-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-24-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-24-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 ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','28','MDAT-YABD-19-0','TOKO','BTATMD','AT TUSUK ITALY BL SLP SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.830' WHERE kode_barang='MDAT-YABD-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-19-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.840,berat_hancur_asli=berat_hancur_asli+0.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','29','MDAT-YABD-18-0','TOKO','BTATMD','AT TUSUK ITALY BL SLP SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.810' WHERE kode_barang='MDAT-YABD-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-18-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','30','MDAT-YABD-15-0','TOKO','BTATMD','AT TUSUK ITALY BL SLP SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.810' WHERE kode_barang='MDAT-YABD-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-15-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','31','MDAT-YABD-16-0','TOKO','BTATMD','AT TUSUK ITALY BL SLP SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='0.810' WHERE kode_barang='MDAT-YABD-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-16-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','32','MDAT-YABD-11-0','TOKO','BTATMD','AT COR FORTUNE YT ','1','1.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.710' WHERE kode_barang='MDAT-YABD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.720,berat_hancur_asli=berat_hancur_asli+1.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260804-0002','33','MDAT-YBBH-13-0','TOKO','BTATMD','AT ITALY KUPU2 BT SHB ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='1.590' WHERE kode_barang='MDAT-YBBH-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YBBH-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YBBH-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YBBH-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','34','MDAT-YCAC-23-0','TOKO','BTATMD','AT COR KLP KUPU BTG ','1','3.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='3.310' WHERE kode_barang='MDAT-YCAC-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCAC-23-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCAC-23-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 ='BTATMD' AND kode_barang='MDAT-YCAC-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0002','35','MDAT-YEXE-5-0','TOKO','BTATMD','AT ANAK COR KLP TDK BT UBS ','1','3.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:28:52',status_delete='3.290' WHERE kode_barang='MDAT-YEXE-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YEXE-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YEXE-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.300,berat_hancur_asli=berat_hancur_asli+3.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YEXE-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260804-0002','2026-08-04','admin','2026-08-04','15:28:52','admin','2026-08-04 15:28:52');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','1','MDCN-XGXD-39-0','TOKO','BTCNMD','CN SESER MK ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.990' WHERE kode_barang='MDCN-XGXD-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XGXD-39-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XGXD-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 ='BTCNMD' AND kode_barang='MDCN-XGXD-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-260804-0003','2','MDCN-XKXI-190-0','TOKO','BTCNMD','CN SESER MK ','1','1.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.570' WHERE kode_barang='MDCN-XKXI-190-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-190-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-190-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.580,berat_hancur_asli=berat_hancur_asli+1.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260804-0003','3','MDCN-XKXD-70-0','TOKO','BTCNMD','CN COR LBG CAT LC2 ','1','1.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.840' WHERE kode_barang='MDCN-XKXD-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXD-70-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXD-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.850,berat_hancur_asli=berat_hancur_asli+1.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXD-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-260804-0003','4','MDCN-XKXI-213-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','6.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='6.040' WHERE kode_barang='MDCN-XKXI-213-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-213-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-213-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.050,berat_hancur_asli=berat_hancur_asli+6.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-213-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','5','MDCN-YBBH-60-0','TOKO','BTCNMD','CN COR TEBU SEKERET SHB ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.030' WHERE kode_barang='MDCN-YBBH-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YBBH-60-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YBBH-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.040,berat_hancur_asli=berat_hancur_asli+2.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YBBH-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-260804-0003','6','MDCN-YBBH-45-0','TOKO','BTCNMD','CN SESER MK ','1','6.680','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='6.670' WHERE kode_barang='MDCN-YBBH-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YBBH-45-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YBBH-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.680,berat_hancur_asli=berat_hancur_asli+6.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YBBH-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-260804-0003','7','MDCN-YEXE-34-0','TOKO','BTCNMD','CN SESER MK ','1','3.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='3.690' WHERE kode_barang='MDCN-YEXE-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-34-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.700,berat_hancur_asli=berat_hancur_asli+3.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-34-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','8','MDCN-YEXE-44-0','TOKO','BTCNMD','CN COR TDK BT LC2 ','1','2.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.230' WHERE kode_barang='MDCN-YEXE-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-44-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.240,berat_hancur_asli=berat_hancur_asli+2.240, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260804-0003','9','MDCN-YFAI-102-0','TOKO','BTCNMD','CN SESER MK ','1','3.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='3.150' WHERE kode_barang='MDCN-YFAI-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-102-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-102-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.160,berat_hancur_asli=berat_hancur_asli+3.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260804-0003','10','MDCN-YFBF-3-0','TOKO','BTCNMD','CN SESER MK ','1','6.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='6.890' WHERE kode_barang='MDCN-YFBF-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFBF-3-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFBF-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.900,berat_hancur_asli=berat_hancur_asli+6.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFBF-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-260804-0003','11','MDCN-YKXD-164-0','TOKO','BTCNMD','CN SESER MK ','1','2.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.080' WHERE kode_barang='MDCN-YKXD-164-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-164-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-164-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.090,berat_hancur_asli=berat_hancur_asli+2.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260804-0003','12','MDCN-YKXD-165-0','TOKO','BTCNMD','CN SESER MK ','1','3.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='3.010' WHERE kode_barang='MDCN-YKXD-165-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-165-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-165-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.020,berat_hancur_asli=berat_hancur_asli+3.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260804-0003','13','MDCN-YKXD-171-0','TOKO','BTCNMD','CN PLINTIR SHB ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.350' WHERE kode_barang='MDCN-YKXD-171-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-171-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-171-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.360,berat_hancur_asli=berat_hancur_asli+1.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260804-0003','14','MDCN-YJAG-37-0','TOKO','BTCNMD','CN COR TDK BT SHB ','1','2.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.440' WHERE kode_barang='MDCN-YJAG-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-37-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.450,berat_hancur_asli=berat_hancur_asli+2.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJAG-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-260804-0003','15','MDCN-YKXD-162-0','TOKO','BTCNMD','CN SESER SHB ','1','2.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.840' WHERE kode_barang='MDCN-YKXD-162-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-162-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-162-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.850,berat_hancur_asli=berat_hancur_asli+2.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260804-0003','16','MDCN-YKXD-166-0','TOKO','BTCNMD','CN SESER MK ','1','3.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='3.050' WHERE kode_barang='MDCN-YKXD-166-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-166-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-166-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-166-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','17','MDCN-ZBXF-140-0','TOKO','BTCNMD','CN SESER MK ','1','7.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='7.710' WHERE kode_barang='MDCN-ZBXF-140-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-140-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-140-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.720,berat_hancur_asli=berat_hancur_asli+7.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-140-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','18','MDCN-ZBAH-68-0','TOKO','BTCNMD','CN COR KRW LC2 ','1','4.310','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='4.300' WHERE kode_barang='MDCN-ZBAH-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBAH-68-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAH-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.310,berat_hancur_asli=berat_hancur_asli+4.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBAH-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-260804-0003','19','MDCN-WBAX-100-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.810' WHERE kode_barang='MDCN-WBAX-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-100-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WBAX-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-260804-0003','20','MDCN-WBAX-78-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.890' WHERE kode_barang='MDCN-WBAX-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-78-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WBAX-78-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','21','MDCN-WBAX-81-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.890' WHERE kode_barang='MDCN-WBAX-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-81-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WBAX-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-260804-0003','22','MDCN-WHXE-99-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.840' WHERE kode_barang='MDCN-WHXE-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-99-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-99-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 ='BTCNMD' AND kode_barang='MDCN-WHXE-99-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','23','MDCN-WGAH-17-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.830' WHERE kode_barang='MDCN-WGAH-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WGAH-17-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WGAH-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.840,berat_hancur_asli=berat_hancur_asli+0.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WGAH-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','24','MDCN-WGAH-22-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.020' WHERE kode_barang='MDCN-WGAH-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WGAH-22-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WGAH-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WGAH-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','25','MDCN-WHXE-133-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.960' WHERE kode_barang='MDCN-WHXE-133-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-133-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-133-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 ='BTCNMD' AND kode_barang='MDCN-WHXE-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-260804-0003','26','MDCN-WHXE-188-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.890' WHERE kode_barang='MDCN-WHXE-188-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-188-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-188-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-188-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','27','MDCN-WHXE-66-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.120' WHERE kode_barang='MDCN-WHXE-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-66-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.130,berat_hancur_asli=berat_hancur_asli+1.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-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-260804-0003','28','MDCN-WFXB-27-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.060' WHERE kode_barang='MDCN-WFXB-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WFXB-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WFXB-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.070,berat_hancur_asli=berat_hancur_asli+1.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WFXB-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-260804-0003','29','MDCN-WHXE-105-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.870' WHERE kode_barang='MDCN-WHXE-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-105-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-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-260804-0003','30','MDCN-WJAC-9-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.870' WHERE kode_barang='MDCN-WJAC-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WJAC-9-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WJAC-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WJAC-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-260804-0003','31','MDCN-WIAF-81-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.850' WHERE kode_barang='MDCN-WIAF-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WIAF-81-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WIAF-81-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 ='BTCNMD' AND kode_barang='MDCN-WIAF-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-260804-0003','32','MDCN-WLAE-58-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.840' WHERE kode_barang='MDCN-WLAE-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WLAE-58-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WLAE-58-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 ='BTCNMD' AND kode_barang='MDCN-WLAE-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-260804-0003','33','MDCN-XKXI-48-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.820' WHERE kode_barang='MDCN-XKXI-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-48-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.830,berat_hancur_asli=berat_hancur_asli+0.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260804-0003','34','MDCN-XKXI-134-0','TOKO','BTCNMD','CN COR BT MK ','1','0.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.920' WHERE kode_barang='MDCN-XKXI-134-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-134-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-134-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 ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260804-0003','35','MDCN-XKXI-69-0','TOKO','BTCNMD','CN COR BT MK ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.820' WHERE kode_barang='MDCN-XKXI-69-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-69-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-69-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.830,berat_hancur_asli=berat_hancur_asli+0.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260804-0003','36','MDCN-XKXI-237-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','2.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='2.430' WHERE kode_barang='MDCN-XKXI-237-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-237-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-237-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 ='BTCNMD' AND kode_barang='MDCN-XKXI-237-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','37','MDCN-XKXI-46-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.870' WHERE kode_barang='MDCN-XKXI-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-46-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260804-0003','38','MDCN-YABD-42-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.890' WHERE kode_barang='MDCN-YABD-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-42-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YABD-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-260804-0003','39','MDCN-YABD-36-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.760' WHERE kode_barang='MDCN-YABD-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-36-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-36-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.770,berat_hancur_asli=berat_hancur_asli+0.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YABD-36-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','40','MDCN-YABD-61-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.810' WHERE kode_barang='MDCN-YABD-61-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-61-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-61-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YABD-61-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','41','MDCN-YBBH-38-0','TOKO','BTCNMD','CN COR BT UBS ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.770' WHERE kode_barang='MDCN-YBBH-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YBBH-38-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YBBH-38-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 ='BTCNMD' AND kode_barang='MDCN-YBBH-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-260804-0003','42','MDCN-YEXE-20-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.830' WHERE kode_barang='MDCN-YEXE-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-20-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.840,berat_hancur_asli=berat_hancur_asli+0.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260804-0003','43','MDCN-YEXE-22-0','TOKO','BTCNMD','CN COR DOLLAR BT SHB ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.110' WHERE kode_barang='MDCN-YEXE-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-22-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.120,berat_hancur_asli=berat_hancur_asli+1.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','44','MDCN-YEXE-12-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.870' WHERE kode_barang='MDCN-YEXE-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260804-0003','45','MDCN-YCAC-35-0','TOKO','BTCNMD','CN COR BT UBS ','1','1.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.120' WHERE kode_barang='MDCN-YCAC-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YCAC-35-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YCAC-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.130,berat_hancur_asli=berat_hancur_asli+1.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YCAC-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-260804-0003','46','MDCN-YEXE-14-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.840' WHERE kode_barang='MDCN-YEXE-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-14-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 ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260804-0003','47','MDCN-YFAH-12-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='0.740' WHERE kode_barang='MDCN-YFAH-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAH-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAH-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.750,berat_hancur_asli=berat_hancur_asli+0.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAH-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-260804-0003','48','MDCN-YJAG-14-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.230' WHERE kode_barang='MDCN-YJAG-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.240,berat_hancur_asli=berat_hancur_asli+1.240, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJAG-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-260804-0003','49','MDCN-YJBI-13-0','TOKO','BTCNMD','CN COR BT MK ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.020' WHERE kode_barang='MDCN-YJBI-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJBI-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260804-0003','50','MDCN-ZBAB-13-0','TOKO','BTCNMD','CN COR BT MK ','1','1.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-04 15:35:50',status_delete='1.770' WHERE kode_barang='MDCN-ZBAB-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBAB-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.780,berat_hancur_asli=berat_hancur_asli+1.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBAB-13-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-260804-0003','2026-08-04','admin','2026-08-04','15:35:50','admin','2026-08-04 15:35:50');
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-260804-0005','sales','1',' ','TOKO','BTCNMD','MDCN-YFAI-62-0','CN COR BT MK ','','1.000','1','100.00','1105000','0','0','0','1105000','0','0','0','1105000','2402','00025335','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YFAI-62-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-08-04' AND kode_barang='MDCN-YFAI-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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-260804-0005','2026-08-04','1.000','2026-08-04','15:38:32','PLG0019275','1105000','1105000','0','1105000','1105000','sales','2026-08-04 15:38:31','FJ-260804-0005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-04','FJ-260804-0005','2026-08-04','15:38:32','2402','1105000','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-260804-0008','D','2026-08-04','15:38:32','sales','PENJUALAN','FJ-260804-0005','175682071','1105000','176787071');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260804-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260804-0005';