INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','08:02:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-26 ','08:29:30');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-26','146','0','50900000','146','0','50900000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-25';
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-05-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-25' 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-260526-0001','D','2026-05-26','08:29:46','BCA','SALDO AWAL','SALDO AWAL','0','2114778276','2114778276');
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-260526-0001','D','2026-05-26','08:29:46','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-26';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-26 ','08:30:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-05-26 ','08:52:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','08:54:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','09:04:29');
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-260526-0001','1','X-00009507','BELI','BELI001','GL FANCY VAR 17CM KKT PER BLT LC2','1','1.500','1464000.00' ,'0.00','1464000','','1464000','1464000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009507' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009507' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009507' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.500',berat_hancur_asli=berat_hancur_asli+'1.500', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260526-0001','2','X-00009508','BELI','BELI001','CN COR TDK BT SMBR PTH BG3','1','2.130','3542000.00' ,'0.00','3542000','','3542000','6470000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009508' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009508' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009508' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.130',berat_hancur_asli=berat_hancur_asli+'2.130', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' 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-260526-0001','3','X-00009509','BELI','BELI001','CN CAP PLT ANK TDK BT SHB','1','0.480','744000.00' ,'0.00','744000','','744000','10756000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009509' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009509' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009509' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' 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-260526-0001','4','X-00009510','BELI','BELI001','CN COR SETENGAH RT SHB','1','2.030','3375500.00' ,'0.00','3375500','','3375500','14875500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009510' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009510' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009510' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.030',berat_hancur_asli=berat_hancur_asli+'2.030', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' 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-260526-0001','5','X-00009511','BELI','BELI001','GW CAP BT SHB','1','0.810','1347000.00' ,'0.00','1347000','','1347000','19598000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009511' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009511' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009511' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGW' 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-260526-0001','6','X-00009512','BELI','BELI001','KL FANCY 42CM KKT PER SHB','1','2.940','2869000.00' ,'0.00','2869000','','2869000','23814000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009512' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009512' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009512' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.940',berat_hancur_asli=berat_hancur_asli+'2.940', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' 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-260526-0001','7','X-00009513','BELI','BELI001','LT COR BT SHB','1','0.100','77000.00' ,'0.00','77000','','77000','26760000','RUSAK ADA HILANG');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009513' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009513' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009513' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.100',berat_hancur_asli=berat_hancur_asli+'0.100', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.100',berat_akhir_asli=berat_akhir_asli-'0.100' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDLT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260526-0001','8','X-00009514','BELI','BELI001','CINCIN PIPA MT AD 5 BJ','1','0.890','689000.00' ,'0.00','689000','','689000','27526000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009514' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009514' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009514' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.890',berat_hancur_asli=berat_hancur_asli+'0.890', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.890',berat_akhir_asli=berat_akhir_asli-'0.890' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260526-0001','9','X-00009515','BELI','BELI001','CINCIN PIPA S MT AD 7 BJ','1','0.970','751000.00' ,'0.00','751000','','751000','28966000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009515' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009515' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009515' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260526-0001','10','X-00009516','BELI','BELI001','CN SESER MK','1','3.010','2937500.00' ,'0.00','2937500','','2937500','32654500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009516' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009516' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009516' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.010',berat_hancur_asli=berat_hancur_asli+'3.010', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260526-0001','11','X-00009517','BELI','BELI001','CN COR BT MK','1','0.820','800000.00' ,'0.00','800000','','800000','36392000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009517' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009517' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009517' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-260526-0001','12','X-00009518','BELI','BELI001','AT COR KWT TDK BT LC2','1','0.940','917000.00' ,'0.00','917000','','917000','38109000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-26 09:04:50' WHERE kode_barang='X-00009518' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009518' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009518' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.940',berat_hancur_asli=berat_hancur_asli+'0.940', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260526-0001','adminpusat','2026-05-26','2026-05-26','09:04:50','19513000','38109000', 'adminpusat','2026-05-26 09:04:50');
UPDATE tt_titip_detail SET harga_jual ='1058500' ,ongkos_detail ='0',berat ='0.56',jml_Detail_rp ='1058500' WHERE no_titip= 'TU-260525-0001' AND no_urut*1 ='1'
DELETE FROM tt_jual_detail WHERE kode_barang='MTAT-ZCAD-3-0' LIMIT 1
DELETE FROM tt_jual_detail WHERE kode_barcode='00028987' LIMIT 1
INSERT INTO tm_barang SELECT * FROM tm_barang_titip WHERE kode_barcode='00028987' LIMIT 1
DELETE FROM tm_barang_titip WHERE kode_barcode='00028987' LIMIT 1
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli ) VALUES ('2026-05-26','TOKO','BTATMT','MTAT','MTAT-ZCAD-3-0','0','1','0.56','0.55', '1','0.56','0.55');
UPDATE tt_barang_saldo SET stock_out= stock_out+'1' ,berat_out=berat_out+'0.56',berat_out_asli=berat_out_asli+'0.55', stock_akhir=stock_akhir-'1',berat_akhir =berat_akhir-'0.56',berat_akhir_asli =berat_akhir_asli-'0.55' WHERE tanggal='2026-05-26' AND kode_barang='MTAT-ZCAD-3-0' AND kode_lokasi_gudang='TITIP' AND kode_lokasi_toko='TITIP' AND stock_akhir*1 > 0 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,harga_beli,harga_jual,ongkos_detail,dpp_detail,sales_id,kode_barcode,kode_dept,berlian_usd,berlian_rp,ongkos_berlian,diskon,harga_atribut) VALUES ('FT-260526-0001', 'cashier1', '1','EX ','TOKO','BTATMT', 'MTAT-ZCAD-3-0','AT TINDIK MN HT SHB','','0.56','1','1058500', '1058500', '0','1058500','2402','00028987','MTAT','0','0','0','0','0')
UPDATE tt_barang_saldo SET stock_jual= stock_jual+ '1' ,berat_jual=berat_jual+'0.56',berat_jual_asli=berat_jual_asli+'0.55', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.56',berat_akhir_asli =berat_akhir_asli-'0.55' WHERE tanggal='2026-05-26' AND kode_barang='MTAT-ZCAD-3-0' AND kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko = 'BTATMT' AND stock_akhir*1 > 0
UPDATE tm_barang SET tgl_last_jual='2026-05-26 09:58:34', stock_on_hand=0 WHERE kode_barang='MTAT-ZCAD-3-0'
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,debet_rp,card_rp,transfer_rp,input_by,input_date,no_faktur_group,no_faktur_titip,status_valid) VALUES ('FT-260526-0001','2026-05-26','0.56', '2026-05-26','09:58:34','PLG0018850','1058500','1058500', '0','1058500','458500','0','','0','cashier1','2026-05-26 09:58:34','FT-260526-0001','TU-260525-0001','OPEN')
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-05-26','FT-260526-0001','2026-05-26','09:58:34','2402', '1058500','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-260526-0002','D','2026-05-26','09:58:34','cashier1','AMBIL TITIPAN','TU-260525-0001','185497950','458500','185956450','DONE') 
UPDATE tt_jual_head SET dibayar_rp='458500',debet_rp='0',card_rp='',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FT-260526-0001' LIMIT 1
UPDATE tt_titip_head SET Tgl_ambil='2026-05-26',  dibayar_rp = dibayar_rp + '458500', card_rp = card_rp + '0', debet_rp = debet_rp + '0', transfer_rp = transfer_rp + '0',card_fee_rp = card_fee_rp + '0', sld_akhir_rp = sld_akhir_rp - '458500 + 0 + 0 + 0', status ='CLOS'  WHERE no_titip ='TU-260525-0001'
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-26 ','09:58:53');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FT-260526-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FT-260526-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FT-260526-0001';
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='TU-260525-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','10:38:12');
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-260526-0002','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZEAH-28-0','CN ANAK CAP NONA BT SHB ','','0.570','1','100.00','1077500','0','0','0','1077500','0','0','0','1077500','2502','00029604','MTCN','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZEAH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MTCN-ZEAH-28-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-260526-0002','2026-05-26','0.570','2026-05-26','10:45:22','PLG0018851','1077500','1077500','0','1077500','1077500','sales','2026-05-26 10:45:22','FJ-260526-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-05-26','FJ-260526-0002','2026-05-26','10:45:22','2502','1077500','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-260526-0003','D','2026-05-26','10:45:22','sales','PENJUALAN','FJ-260526-0002','185956450','1077500','187033950','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1077500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260526-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-260526-0003','sales',' 1',' ','TOKO','BTCNMT','MTCN-ZBXI-61-0','CN COR ANAK TDK BT SHB ','','0.580','1','100.00','1096500','0','0','0','1096500','0','0','0','1096500','2502','00027875','MTCN','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZBXI-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MTCN-ZBXI-61-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-260526-0003','2026-05-26','0.580','2026-05-26','10:45:22','PLG0018852','1096500','1096500','0','1096500','1096500','sales','2026-05-26 10:45:22','FJ-260526-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-05-26','FJ-260526-0003','2026-05-26','10:45:22','2502','1096500','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-260526-0004','D','2026-05-26','10:45:22','sales','PENJUALAN','FJ-260526-0003','187033950','1096500','188130450','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1096500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260526-0003' 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-260526-0004','sales',' 1',' EX ','TOKO','BTCNMT','MTCN-ZDBH-5-0','CN COR ANAK CAT MK ','','0.960','1','100.00','1814500','0','0','0','1814500','0','0','0','1814500','2502','00029238','MTCN','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZDBH-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MTCN-ZDBH-5-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-260526-0004','2026-05-26','0.960','2026-05-26','10:45:22','PLG0018853','1814500','1814500','0','1814500','1814500','sales','2026-05-26 10:45:22','FJ-260526-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-05-26','FJ-260526-0004','2026-05-26','10:45:22','2502','1814500','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-260526-0005','D','2026-05-26','10:45:22','sales','PENJUALAN','FJ-260526-0004','188130450','1814500','189944950','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1814500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260526-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0004';
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-260526-0005','sales','1',' ','TOKO','BTGWMD','MDGW-ZBAX-55-0','GW COR BT SHB ','','1.210','1','100.00','1373500','0','0','0','1373500','0','0','0','1373500','2501','00027993','MDGW','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGW-ZBAX-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MDGW-ZBAX-55-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMD' 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-260526-0005','2026-05-26','1.210','2026-05-26','11:25:25','PLG0018854','1373500','1373500','0','1373500','1373500','sales','2026-05-26 11:25:25','FJ-260526-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-05-26','FJ-260526-0005','2026-05-26','11:25:25','2501','1373500','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-260526-0006','D','2026-05-26','11:25:25','sales','PENJUALAN','FJ-260526-0005','189944950','1373500','191318450');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','11:40:51');
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-260526-0006','sales','1',' ','TOKO','BTLTMT','MTLT-YHBF-9-0','LT COR TAS KRW SHB ','','2.260','1','100.00','4271500','0','0','0','4271500','0','0','0','4271500','2502','00025904','MTLT','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTLT-YHBF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MTLT-YHBF-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260526-0006','2026-05-26','2.260','2026-05-26','12:12:06','PLG0018855','4271500','4271500','0','4271500','0','sales','2026-05-26 12:12:05','FJ-260526-0006');
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-05-26','FJ-260526-0006','2026-05-26','12:12:06','2502','4271500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260526-0001','2026-05-26','2026-05-26 12:12:05','PENJUALAN : FJ-260526-0006','bca','BCA','4271500','4271500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260526-0002','D','2026-05-26','12:12:06','BCA','PENJUALAN','FJ-260526-0006','2114778276','4271500','2119049776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AINUL MUSYDA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4271500' WHERE no_faktur_jual='FJ-260526-0006' 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-260526-0007','sales',' 1',' ','TOKO','BTKLMT','MTKL-ZBXI-117-0','KL KOREA 42CM KKT PER SHB ','','4.470','1','100.00','8448500','0','0','0','8448500','0','0','0','8448500','2502','00027931','MTKL','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-ZBXI-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.470',berat_jual_asli=berat_jual_asli+'4.470',stock_jual='1',berat_akhir=berat_akhir-'4.470',berat_akhir_asli=berat_akhir_asli-'4.470',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MTKL-ZBXI-117-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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-260526-0007','2026-05-26','4.470','2026-05-26','12:12:06','PLG0018856','8448500','8448500','0','8448500','0','sales','2026-05-26 12:12:05','FJ-260526-0006');
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-05-26','FJ-260526-0007','2026-05-26','12:12:06','2502','8448500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260526-0002','2026-05-26','2026-05-26 12:12:05','PENJUALAN : FJ-260526-0007','bca','BCA','8448500','8448500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260526-0003','D','2026-05-26','12:12:06','BCA','PENJUALAN','FJ-260526-0007','2119049776','8448500','2127498276','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AINUL MUSYDA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='8448500' WHERE no_faktur_jual='FJ-260526-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','13:03:26');
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-260526-0007','K','2026-05-26','13:08:15','cashier1','PENGELUARAN','GAJI KARYAWAN MEI 2026 ','191318450','34720000','156598450');
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-260526-0008','K','2026-05-26','13:08:31','cashier1','PENGELUARAN','JASA KONSULTAN AKUNTING MEI 2026','156598450','800000','155798450');
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-00009519','X-00009519','AT COR KWT TDK BT LC2','GR','---','MDAT','BELI','BELI001','888000','2026-05-26','0.910','1','sales','2026-05-26 13:32:49');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009519','X-00009519');
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-260526-0001','FJ-260314-0006','2502','1','BELI','BELI001','MDAT', 'X-00009519', 'AT COR KWT TDK BT LC2','0.910','0.910','100.00','1142500','888000','975824','1','888000','888000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260526-0001','2026-05-26','2026-05-26','13:32:48','2502','---','0.910','888000','888000','888000','888000','888000','sales','2026-05-26 13:32:49','FB-260526-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0001','NHAZLA','JL. NYAMPLUNGAN 8/61','','','','sales','2026-05-26 13:32:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0009','K','2026-05-26','13:32:48','sales','PEMBELIAN UMUM','FB-260526-0001','155798450','888000','154910450','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-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-260526-0008','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZBXF-61-0','CN COR BT SHB ','','0.870','1','100.00','987500','0','0','0','987500','0','0','0','987500','2401','00027707','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='MDCN-ZBXF-61-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-260526-0008','2026-05-26','0.870','2026-05-26','14:17:15','PLG0018857','987500','987500','0','987500','987500','sales','2026-05-26 14:17:14','FJ-260526-0008');
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-05-26','FJ-260526-0008','2026-05-26','14:17:15','2401','987500','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-260526-0010','D','2026-05-26','14:17:15','sales','PENJUALAN','FJ-260526-0008','154910450','987500','155897950');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260526-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260526-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-05-26 ','15:38:50');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','1','MDCN-WBAX-122-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.770' WHERE kode_barang='MDCN-WBAX-122-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-122-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-122-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-WBAX-122-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','2','MDCN-WBAX-104-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.860' WHERE kode_barang='MDCN-WBAX-104-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-104-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-104-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.870,berat_hancur_asli=berat_hancur_asli+0.870, 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-104-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','3','MDCN-WBAX-108-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.150' WHERE kode_barang='MDCN-WBAX-108-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-108-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-108-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WBAX-108-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','4','MDCN-WBAX-34-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-WBAX-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-34-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-34-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-WBAX-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-260526-0002','5','MDCN-WBAX-132-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.960' WHERE kode_barang='MDCN-WBAX-132-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-132-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-132-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-WBAX-132-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','6','MDCN-WBAX-97-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.030' WHERE kode_barang='MDCN-WBAX-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-97-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-97-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 ='BTCNMD' AND kode_barang='MDCN-WBAX-97-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','7','MDCN-WBAX-52-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.800' WHERE kode_barang='MDCN-WBAX-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WBAX-52-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WBAX-52-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 ='BTCNMD' AND kode_barang='MDCN-WBAX-52-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','8','MDCN-WCAE-45-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.850' WHERE kode_barang='MDCN-WCAE-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WCAE-45-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WCAE-45-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-WCAE-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-260526-0002','9','MDCN-WCAE-56-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.890' WHERE kode_barang='MDCN-WCAE-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WCAE-56-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WCAE-56-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-WCAE-56-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','10','MDCN-WHXE-132-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.820' WHERE kode_barang='MDCN-WHXE-132-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-132-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-132-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-WHXE-132-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','11','MDCN-WHXE-130-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.850' WHERE kode_barang='MDCN-WHXE-130-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-130-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-130-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-WHXE-130-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','12','MDCN-WHXE-165-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.710' WHERE kode_barang='MDCN-WHXE-165-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-165-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-165-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.720,berat_hancur_asli=berat_hancur_asli+0.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-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-260526-0002','13','MDCN-WHXE-142-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-WHXE-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-142-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-142-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-142-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','14','MDCN-WHXE-111-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.920' WHERE kode_barang='MDCN-WHXE-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-111-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-111-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-WHXE-111-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','15','MDCN-WHXE-101-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.850' WHERE kode_barang='MDCN-WHXE-101-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-101-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-101-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-WHXE-101-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','16','MDCN-WHXE-72-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.900' WHERE kode_barang='MDCN-WHXE-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-72-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','17','MDCN-WHXE-107-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-WHXE-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-107-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-107-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-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-260526-0002','18','MDCN-WHXE-121-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.820' WHERE kode_barang='MDCN-WHXE-121-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-121-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-121-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-WHXE-121-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','19','MDCN-WHXE-124-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.970' WHERE kode_barang='MDCN-WHXE-124-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-124-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-124-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 ='BTCNMD' AND kode_barang='MDCN-WHXE-124-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','20','MDCN-WHXE-97-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.820' WHERE kode_barang='MDCN-WHXE-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-97-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-97-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-WHXE-97-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','21','MDCN-WHXE-83-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.830' WHERE kode_barang='MDCN-WHXE-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-83-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-83-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-WHXE-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','22','MDCN-WHXE-164-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.720' WHERE kode_barang='MDCN-WHXE-164-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-164-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-164-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.730,berat_hancur_asli=berat_hancur_asli+0.730, 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-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-260526-0002','23','MDCN-WHXE-135-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.740' WHERE kode_barang='MDCN-WHXE-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-135-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-135-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-WHXE-135-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','24','MDCN-WHXE-113-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.830' WHERE kode_barang='MDCN-WHXE-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-113-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-113-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-WHXE-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','25','MDCN-WHXE-170-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.770' WHERE kode_barang='MDCN-WHXE-170-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-170-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-170-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-WHXE-170-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','26','MDCN-WHXE-146-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.990' WHERE kode_barang='MDCN-WHXE-146-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-146-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-146-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-146-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','27','MDCN-WHXE-87-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.730' WHERE kode_barang='MDCN-WHXE-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-87-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.740,berat_hancur_asli=berat_hancur_asli+0.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','28','MDCN-WHXE-94-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.010' WHERE kode_barang='MDCN-WHXE-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-94-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHXE-94-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','29','MDCN-WHXE-98-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.850' WHERE kode_barang='MDCN-WHXE-98-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-98-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-98-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-WHXE-98-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','30','MDCN-WGAH-27-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.100' WHERE kode_barang='MDCN-WGAH-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WGAH-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WGAH-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WGAH-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-260526-0002','31','MDCN-WHXE-150-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.770' WHERE kode_barang='MDCN-WHXE-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-150-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-150-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-WHXE-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','32','MDCN-WHXE-186-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-WHXE-186-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHXE-186-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHXE-186-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-186-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','33','MDCN-WIAF-79-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.770' WHERE kode_barang='MDCN-WIAF-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WIAF-79-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WIAF-79-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-WIAF-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','34','MDCN-WHAD-16-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.240' WHERE kode_barang='MDCN-WHAD-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WHAD-16-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WHAD-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.250,berat_hancur_asli=berat_hancur_asli+1.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WHAD-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-260526-0002','35','MDCN-WKBX-21-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.220' WHERE kode_barang='MDCN-WKBX-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WKBX-21-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WKBX-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.230,berat_hancur_asli=berat_hancur_asli+1.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WKBX-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','36','MDCN-XAAF-9-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.830' WHERE kode_barang='MDCN-XAAF-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XAAF-9-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XAAF-9-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-XAAF-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-260526-0002','37','MDCN-WLAE-59-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.030' WHERE kode_barang='MDCN-WLAE-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WLAE-59-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WLAE-59-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 ='BTCNMD' AND kode_barang='MDCN-WLAE-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-260526-0002','38','MDCN-XAAF-23-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.260' WHERE kode_barang='MDCN-XAAF-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XAAF-23-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XAAF-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.270,berat_hancur_asli=berat_hancur_asli+1.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XAAF-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-260526-0002','39','MDCN-XAAF-25-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-XAAF-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XAAF-25-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XAAF-25-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-XAAF-25-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','40','MDCN-XAAE-44-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.020' WHERE kode_barang='MDCN-XAAE-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XAAE-44-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XAAE-44-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-XAAE-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-260526-0002','41','MDCN-XCBB-27-0','TOKO','BTCNMD','CN COR BT MK ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.890' WHERE kode_barang='MDCN-XCBB-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XCBB-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XCBB-27-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-XCBB-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-260526-0002','42','MDCN-XCBB-42-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.930' WHERE kode_barang='MDCN-XCBB-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XCBB-42-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XCBB-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XCBB-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-260526-0002','43','MDCN-XEBD-26-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','2.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.540' WHERE kode_barang='MDCN-XEBD-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XEBD-26-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XEBD-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.550,berat_hancur_asli=berat_hancur_asli+2.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XEBD-26-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','44','MDCN-XIXE-95-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.130' WHERE kode_barang='MDCN-XIXE-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XIXE-95-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XIXE-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.140,berat_hancur_asli=berat_hancur_asli+1.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XIXE-95-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','45','MDCN-XDBD-7-0','TOKO','BTCNMD','CN COR BT UBS ','1','0.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.860' WHERE kode_barang='MDCN-XDBD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XDBD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XDBD-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.870,berat_hancur_asli=berat_hancur_asli+0.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XDBD-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-260526-0002','46','MDCN-XHXI-1-0','TOKO','BTCNMD','CN COR BT MK ','1','0.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.780' WHERE kode_barang='MDCN-XHXI-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XHXI-1-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XHXI-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.790,berat_hancur_asli=berat_hancur_asli+0.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XHXI-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','47','MDCN-XIXD-11-0','TOKO','BTCNMD','CN COR BT UBS ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-XIXD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XIXD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XIXD-11-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-XIXD-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-260526-0002','48','MDCN-XEBD-24-0','TOKO','BTCNMD','CN COR BT SHB ','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.090' WHERE kode_barang='MDCN-XEBD-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XEBD-24-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XEBD-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XEBD-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-260526-0002','49','MDCN-XKXI-238-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','2.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.620' WHERE kode_barang='MDCN-XKXI-238-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-238-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-238-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.630,berat_hancur_asli=berat_hancur_asli+2.630, 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-238-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','50','MDCN-XJAE-7-0','TOKO','BTCNMD','CN COR BT MK ','1','0.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.900' WHERE kode_barang='MDCN-XJAE-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XJAE-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XJAE-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XJAE-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-260526-0002','51','MDCN-XKXD-64-0','TOKO','BTCNMD','CN COR BT MK ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.280' WHERE kode_barang='MDCN-XKXD-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXD-64-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXD-64-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 ='BTCNMD' AND kode_barang='MDCN-XKXD-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','52','MDCN-XKXI-41-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.970' WHERE kode_barang='MDCN-XKXI-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-41-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-41-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 ='BTCNMD' AND kode_barang='MDCN-XKXI-41-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','53','MDCN-XKXI-84-0','TOKO','BTCNMD','CN COR BT MK ','1','0.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.920' WHERE kode_barang='MDCN-XKXI-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-84-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-84-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-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','54','MDCN-XKXI-34-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.830' WHERE kode_barang='MDCN-XKXI-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-34-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-34-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-XKXI-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-260526-0002','55','MDCN-XKXI-123-0','TOKO','BTCNMD','CN COR BT MK ','1','0.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.840' WHERE kode_barang='MDCN-XKXI-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-123-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-123-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-XKXI-123-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','56','MDCN-XKXI-36-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.890' WHERE kode_barang='MDCN-XKXI-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-36-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-36-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-XKXI-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-260526-0002','57','MDCN-XKXI-179-0','TOKO','BTCNMD','CN COR TDK BT UBS ','1','1.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.830' WHERE kode_barang='MDCN-XKXI-179-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-179-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-179-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.840,berat_hancur_asli=berat_hancur_asli+1.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-XKXI-179-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','58','MDCN-XKXI-91-0','TOKO','BTCNMD','CN COR BT MK ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.100' WHERE kode_barang='MDCN-XKXI-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-91-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','59','MDCN-XKXI-142-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.340' WHERE kode_barang='MDCN-XKXI-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-142-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-142-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 ='BTCNMD' AND kode_barang='MDCN-XKXI-142-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','60','MDCN-XKXI-32-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.910' WHERE kode_barang='MDCN-XKXI-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-32-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.920,berat_hancur_asli=berat_hancur_asli+0.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKXI-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','61','MDCN-XKXI-38-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.890' WHERE kode_barang='MDCN-XKXI-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-38-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-38-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-XKXI-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-260526-0002','62','MDCN-XKXI-49-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.890','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.880' WHERE kode_barang='MDCN-XKXI-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-49-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.890,berat_hancur_asli=berat_hancur_asli+0.890, 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-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','63','MDCN-YABD-57-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.120' WHERE kode_barang='MDCN-YABD-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-57-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-57-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-YABD-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','64','MDCN-YABD-28-0','TOKO','BTCNMD','CN COR BT MK ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.810' WHERE kode_barang='MDCN-YABD-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-28-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-28-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YABD-28-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','65','MDCN-XKAH-5-0','TOKO','BTCNMD','CN COR BT UBS ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.020' WHERE kode_barang='MDCN-XKAH-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKAH-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKAH-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKAH-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-260526-0002','66','MDCN-YABD-39-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.870' WHERE kode_barang='MDCN-YABD-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YABD-39-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YABD-39-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-YABD-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-260526-0002','67','MDCN-XKAH-4-0','TOKO','BTCNMD','CN COR BT MK ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.930' WHERE kode_barang='MDCN-XKAH-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKAH-4-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKAH-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XKAH-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-260526-0002','68','MDCN-YACA-1-0','TOKO','BTCNMD','CN COR TDK BT SHB ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.950' WHERE kode_barang='MDCN-YACA-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YACA-1-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YACA-1-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 ='BTCNMD' AND kode_barang='MDCN-YACA-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','69','MDCN-YEXE-18-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.240' WHERE kode_barang='MDCN-YEXE-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-18-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.250,berat_hancur_asli=berat_hancur_asli+1.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260526-0002','70','MDCN-YCAC-43-0','TOKO','BTCNMD','CN COR TDK BT SMBR PTH UBS ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.820' WHERE kode_barang='MDCN-YCAC-43-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YCAC-43-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YCAC-43-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-YCAC-43-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','71','MDCN-YFAI-90-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.990' WHERE kode_barang='MDCN-YFAI-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-90-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','72','MDCN-YFAI-82-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.220' WHERE kode_barang='MDCN-YFAI-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-82-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.230,berat_hancur_asli=berat_hancur_asli+1.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-82-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','73','MDCN-YFAI-103-0','TOKO','BTCNMD','CN PLINTIR BTG','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.040' WHERE kode_barang='MDCN-YFAI-103-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-103-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-103-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-103-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','74','MDCN-YFAH-14-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.440' WHERE kode_barang='MDCN-YFAH-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAH-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAH-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.450,berat_hancur_asli=berat_hancur_asli+1.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAH-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-260526-0002','75','MDCN-YHBH-18-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.810' WHERE kode_barang='MDCN-YHBH-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-18-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-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 ='BTCNMD' AND kode_barang='MDCN-YHBH-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-260526-0002','76','MDCN-YHBH-27-0','TOKO','BTCNMD','CN COR BT MK ','1','0.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.920' WHERE kode_barang='MDCN-YHBH-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-27-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-27-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-YHBH-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-260526-0002','77','MDCN-YFAI-64-0','TOKO','BTCNMD','CN COR BT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.720' WHERE kode_barang='MDCN-YFAI-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-64-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.730,berat_hancur_asli=berat_hancur_asli+0.730, 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-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','78','MDCN-YFAI-54-0','TOKO','BTCNMD','CN COR BT MK ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.100' WHERE kode_barang='MDCN-YFAI-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-54-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-54-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','79','MDCN-YHBH-29-0','TOKO','BTCNMD','CN COR BT MK ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.100' WHERE kode_barang='MDCN-YHBH-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-29-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YHBH-29-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','80','MDCN-YFAI-144-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','6.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='6.010' WHERE kode_barang='MDCN-YFAI-144-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-144-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-144-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.020,berat_hancur_asli=berat_hancur_asli+6.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-YFAI-144-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','81','MDCN-YHBH-40-0','TOKO','BTCNMD','CN COR TDK BT UBS ','1','2.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.920' WHERE kode_barang='MDCN-YHBH-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-40-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.930,berat_hancur_asli=berat_hancur_asli+2.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-YHBH-40-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','82','MDCN-YFAH-21-0','TOKO','BTCNMD','CN COR BT MK ','1','0.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.940' WHERE kode_barang='MDCN-YFAH-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAH-21-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAH-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.950,berat_hancur_asli=berat_hancur_asli+0.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAH-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','83','MDCN-YFAI-46-0','TOKO','BTCNMD','CN COR BT MK','1','0.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.900' WHERE kode_barang='MDCN-YFAI-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-46-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260526-0002','84','MDCN-YKXD-159-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','6.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='6.210' WHERE kode_barang='MDCN-YKXD-159-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-159-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-159-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.220,berat_hancur_asli=berat_hancur_asli+6.220, 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-159-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','85','MDCN-YKXD-109-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.940' WHERE kode_barang='MDCN-YKXD-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-109-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.950,berat_hancur_asli=berat_hancur_asli+1.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','86','MDCN-YJAG-13-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.900' WHERE kode_barang='MDCN-YJAG-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJAG-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-260526-0002','87','MDCN-YKXD-158-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','6.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='6.180' WHERE kode_barang='MDCN-YKXD-158-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-158-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-158-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.190,berat_hancur_asli=berat_hancur_asli+6.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-158-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','88','MDCN-YKXD-128-0','TOKO','BTCNMD','CN COR BT AYU ','1','4.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='4.250' WHERE kode_barang='MDCN-YKXD-128-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-128-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-128-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.260,berat_hancur_asli=berat_hancur_asli+4.260, 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-128-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','89','MDCN-YKXD-150-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','4.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='4.900' WHERE kode_barang='MDCN-YKXD-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-150-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-150-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.910,berat_hancur_asli=berat_hancur_asli+4.910, 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-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','90','MDCN-YKXD-121-0','TOKO','BTCNMD','CN COR BT AYU ','1','2.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.420' WHERE kode_barang='MDCN-YKXD-121-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-121-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-121-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.430,berat_hancur_asli=berat_hancur_asli+2.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-121-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','91','MDCN-YKXD-106-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.090' WHERE kode_barang='MDCN-YKXD-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-106-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-106-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','92','MDCN-YJBI-15-0','TOKO','BTCNMD','CN COR BT MK ','1','1.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.080' WHERE kode_barang='MDCN-YJBI-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-15-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-15-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJBI-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-260526-0002','93','MDCN-YKXD-129-0','TOKO','BTCNMD','CN COR BT SHB ','1','2.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='2.520' WHERE kode_barang='MDCN-YKXD-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-129-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.530,berat_hancur_asli=berat_hancur_asli+2.530, 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-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','94','MDCN-YJBI-6-0','TOKO','BTCNMD','CN COR BT MK ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.850' WHERE kode_barang='MDCN-YJBI-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-6-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-6-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-YJBI-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-260526-0002','95','MDCN-YLXA-65-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.910' WHERE kode_barang='MDCN-YLXA-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YLXA-65-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXA-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.920,berat_hancur_asli=berat_hancur_asli+0.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YLXA-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','96','MDCN-YJBI-14-0','TOKO','BTCNMD','CN COR BT MK ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.010' WHERE kode_barang='MDCN-YJBI-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-14-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJBI-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-260526-0002','97','MDCN-YJAG-4-0','TOKO','BTCNMD','CN COR BT MK ','1','0.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.920' WHERE kode_barang='MDCN-YJAG-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-4-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-4-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-YJAG-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-260526-0002','98','MDCN-YKXD-100-0','TOKO','BTCNMD','CN COR BT MK ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.110' WHERE kode_barang='MDCN-YKXD-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-100-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-100-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-YKXD-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-260526-0002','99','MDCN-YKXD-72-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.720' WHERE kode_barang='MDCN-YKXD-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-72-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.730,berat_hancur_asli=berat_hancur_asli+1.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','100','MDCN-YKXD-189-0','TOKO','BTCNMD','CN COR TDK BT BTG ','1','1.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.780' WHERE kode_barang='MDCN-YKXD-189-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-189-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-189-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.790,berat_hancur_asli=berat_hancur_asli+1.790, 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-189-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','101','MDCN-YKXD-95-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.940' WHERE kode_barang='MDCN-YKXD-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-95-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.950,berat_hancur_asli=berat_hancur_asli+0.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-95-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','102','MDCN-YJBI-11-0','TOKO','BTCNMD','CN COR BT MK ','1','1.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.080' WHERE kode_barang='MDCN-YJBI-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-11-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJBI-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-260526-0002','103','MDCN-YJBI-7-0','TOKO','BTCNMD','CN COR BT MK ','1','0.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.840' WHERE kode_barang='MDCN-YJBI-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-7-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-YJBI-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-260526-0002','104','MDCN-YKXD-73-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.490' WHERE kode_barang='MDCN-YKXD-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-73-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-73-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','105','MDCN-YKXD-64-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.800' WHERE kode_barang='MDCN-YKXD-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-64-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-64-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0002','106','MDCN-ZBXF-105-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.390' WHERE kode_barang='MDCN-ZBXF-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-105-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.400,berat_hancur_asli=berat_hancur_asli+1.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-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-260526-0002','107','MDCN-ZBXF-70-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='0.800' WHERE kode_barang='MDCN-ZBXF-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-70-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-70-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 ='BTCNMD' AND kode_barang='MDCN-ZBXF-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-260526-0002','108','MDCN-ZBBH-2-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 15:53:44',status_delete='1.120' WHERE kode_barang='MDCN-ZBBH-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBBH-2-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBH-2-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-ZBBH-2-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-260526-0002','2026-05-26','admin','2026-05-26','15:53:44','admin','2026-05-26 15:53:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-26 ','16:02:12');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','1','MDLT-XCAB-112-0','TOKO','BTLTMD','LT COR FORTUNE LC2 ','1','9.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='9.640' WHERE kode_barang='MDLT-XCAB-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCAB-112-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCAB-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.650,berat_hancur_asli=berat_hancur_asli+9.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XCAB-112-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','2','MDLT-XKAA-137-0','TOKO','BTLTMD','BROSS COR FORT LC2 ','1','10.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='10.240' WHERE kode_barang='MDLT-XKAA-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-137-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.250,berat_hancur_asli=berat_hancur_asli+10.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-137-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','3','MDLT-YAXC-34-0','TOKO','BTLTMD','BROSS COR FORTUNE LC2 ','1','13.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='12.990' WHERE kode_barang='MDLT-YAXC-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YAXC-34-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YAXC-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+13.000,berat_hancur_asli=berat_hancur_asli+13.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YAXC-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-260526-0003','4','MDLT-XCAB-110-0','TOKO','BTLTMD','LT COR FORTUNE LC2','1','4.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='4.900' WHERE kode_barang='MDLT-XCAB-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCAB-110-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCAB-110-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.910,berat_hancur_asli=berat_hancur_asli+4.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XCAB-110-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','5','MDLT-XKAA-129-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','2.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='2.830' WHERE kode_barang='MDLT-XKAA-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-129-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.840,berat_hancur_asli=berat_hancur_asli+2.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','6','MDLT-XCAB-109-0','TOKO','BTLTMD','LT COR FORTUNE LC2 ','1','3.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='3.090' WHERE kode_barang='MDLT-XCAB-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCAB-109-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCAB-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.100,berat_hancur_asli=berat_hancur_asli+3.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XCAB-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','7','MDLT-WJAC-44-0','TOKO','BTLTMD','LT COR FORTUNE LC2 ','1','2.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='2.320' WHERE kode_barang='MDLT-WJAC-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-WJAC-44-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-WJAC-44-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 ='BTLTMD' AND kode_barang='MDLT-WJAC-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-260526-0003','8','MDLT-XBXA-64-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.730' WHERE kode_barang='MDLT-XBXA-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XBXA-64-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XBXA-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.740,berat_hancur_asli=berat_hancur_asli+1.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XBXA-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','9','MDLT-XKAA-123-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.870' WHERE kode_barang='MDLT-XKAA-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-123-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.880,berat_hancur_asli=berat_hancur_asli+1.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-123-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','10','MDLT-XCBB-91-0','TOKO','BTLTMD','LT COR FORT LC2 ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.010' WHERE kode_barang='MDLT-XCBB-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCBB-91-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCBB-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XCBB-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','11','MDLT-XKAH-24-0','TOKO','BTLTMD','LT COR TDK BT LC2 ','1','4.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='4.460' WHERE kode_barang='MDLT-XKAH-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAH-24-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAH-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.470,berat_hancur_asli=berat_hancur_asli+4.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAH-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-260526-0003','12','MDLT-XCAB-99-0','TOKO','BTLTMD','LT COR DOLLAR LC2 ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.190' WHERE kode_barang='MDLT-XCAB-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCAB-99-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCAB-99-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 ='BTLTMD' AND kode_barang='MDLT-XCAB-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-260526-0003','13','MDLT-ZBAI-113-0','TOKO','BTLTMD','LT COR BOROBUDUR LC2 ','1','2.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='2.340' WHERE kode_barang='MDLT-ZBAI-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZBAI-113-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAI-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.350,berat_hancur_asli=berat_hancur_asli+2.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-ZBAI-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','14','MDLT-ZBAI-111-0','TOKO','BTLTMD','LT COR BOROBUDUR LC2 ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.280' WHERE kode_barang='MDLT-ZBAI-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZBAI-111-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAI-111-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 ='BTLTMD' AND kode_barang='MDLT-ZBAI-111-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','15','MDLT-XCBB-90-0','TOKO','BTLTMD','LT COR FORT HURUF K BG ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.510' WHERE kode_barang='MDLT-XCBB-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XCBB-90-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XCBB-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XCBB-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','16','MDLT-XKAA-115-0','TOKO','BTLTMD','LT COR FORT BLT HURUF K BG ','1','0.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.470' WHERE kode_barang='MDLT-XKAA-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-115-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-115-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 ='BTLTMD' AND kode_barang='MDLT-XKAA-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','17','MDLT-YEXE-68-0','TOKO','BTLTMD','LT COR BT MK ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.820' WHERE kode_barang='MDLT-YEXE-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YEXE-68-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YEXE-68-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 ='BTLTMD' AND kode_barang='MDLT-YEXE-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-260526-0003','18','MDLT-YFBX-34-0','TOKO','BTLTMD','LT COR BT MK ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.050' WHERE kode_barang='MDLT-YFBX-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-34-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.060,berat_hancur_asli=berat_hancur_asli+1.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-260526-0003','19','MDLT-YFBX-47-0','TOKO','BTLTMD','LT COR BT MK ','1','1.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.070' WHERE kode_barang='MDLT-YFBX-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-47-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-47-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','20','MDLT-XKAA-118-0','TOKO','BTLTMD','LT COR BT UBS ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.140' WHERE kode_barang='MDLT-XKAA-118-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-118-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-118-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.150,berat_hancur_asli=berat_hancur_asli+1.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-118-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','21','MDLT-XKAA-119-0','TOKO','BTLTMD','LT COR BT MK ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.090' WHERE kode_barang='MDLT-XKAA-119-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-XKAA-119-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-XKAA-119-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-XKAA-119-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','22','MDLT-YFBX-45-0','TOKO','BTLTMD','LT COR BT MK ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.040' WHERE kode_barang='MDLT-YFBX-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-45-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-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-260526-0003','23','MDLT-YAXC-33-0','TOKO','BTLTMD','LT COR BT DSC UBS ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.390' WHERE kode_barang='MDLT-YAXC-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YAXC-33-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YAXC-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.400,berat_hancur_asli=berat_hancur_asli+1.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YAXC-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','24','MDLT-WHXG-88-0','TOKO','BTLTMD','LT COR BT MK','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.210' WHERE kode_barang='MDLT-WHXG-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-WHXG-88-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-WHXG-88-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-WHXG-88-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','25','MDLT-YKXE-150-0','TOKO','BTLTMD','LT BLT HURUF A BG ','1','0.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.570' WHERE kode_barang='MDLT-YKXE-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-150-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YKXE-150-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YKXE-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','26','MDLT-ZBBX-54-0','TOKO','BTLTMD','LT BL PSR ARESO UBS ','1','0.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.650' WHERE kode_barang='MDLT-ZBBX-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZBBX-54-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBBX-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.660,berat_hancur_asli=berat_hancur_asli+0.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-ZBBX-54-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','27','MDLT-WHXG-80-0','TOKO','BTLTMD','LT COR BT MK','1','0.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.780' WHERE kode_barang='MDLT-WHXG-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-WHXG-80-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-WHXG-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.790,berat_hancur_asli=berat_hancur_asli+0.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-WHXG-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','28','MDLT-YBBH-79-0','TOKO','BTLTMD','LT COR BT SHB ','1','0.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='0.830' WHERE kode_barang='MDLT-YBBH-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YBBH-79-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YBBH-79-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 ='BTLTMD' AND kode_barang='MDLT-YBBH-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260526-0003','29','MDLT-YFBX-39-0','TOKO','BTLTMD','LT COR BT MK ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-05-26 16:02:37',status_delete='1.010' WHERE kode_barang='MDLT-YFBX-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-YFBX-39-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-YFBX-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-YFBX-39-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-260526-0003','2026-05-26','admin','2026-05-26','16:02:37','admin','2026-05-26 16:02:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-05-26 ','16:05:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','16:07:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','16:09:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-26 ','16:29:36');