INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','08:32:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-06-23 ','08:36:50');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-23','144','0','5700000','144','0','5700000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-22';
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-06-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-22' 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-260623-0001','D','2026-06-23','08:37:02','BCA','SALDO AWAL','SALDO AWAL','0','2218663067','2218663067');
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-260623-0001','D','2026-06-23','08:37:02','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-06-23 ','08:46:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','08:49:40');
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-260623-0001','1','X-00009585','BELI','BELI001','AT ITALY BT SHB','1','1.020','995500.00' ,'0.00','995500','','995500','995500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-06-23 08:50:08' WHERE kode_barang='X-00009585' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009585' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009585' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020' 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-260623-0001','adminpusat','2026-06-23','2026-06-23','08:50:08','995500','995500', 'adminpusat','2026-06-23 08:50:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','08:53:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-06-23 ','09:16:57');
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-260623-0001','cashier1','1',' ','TOKO','BTLTMD','MDLT-ZBAI-62-0','MN COR FORTUNE HURUF N BG ','','0.610','1','100.00','692500','0','0','0','692500','0','0','0','692500','2501','00028438','MDLT','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-06-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-62-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-06-23' AND kode_barang='MDLT-ZBAI-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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-260623-0001','2026-06-23','0.610','2026-06-23','10:54:25','PLG0019021','692500','692500','0','692500','692500','cashier1','2026-06-23 10:54:24','FJ-260623-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-23','FJ-260623-0001','2026-06-23','10:54:25','2501','692500','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-260623-0002','D','2026-06-23','10:54:25','cashier1','PENJUALAN','FJ-260623-0001','258543250','692500','259235750');
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-260623-0002','cashier1','1',' ','TOKO','BTLTMD','MDLT-ZBAI-24-0','MN COR FORTUNE MK ','','0.480','1','100.00','545000','0','0','0','545000','0','0','0','545000','2501','00028400','MDLT','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-06-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-23' AND kode_barang='MDLT-ZBAI-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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-260623-0002','2026-06-23','0.480','2026-06-23','10:55:42','PLG0019022','545000','545000','0','545000','545000','cashier1','2026-06-23 10:55:42','FJ-260623-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-06-23','FJ-260623-0002','2026-06-23','10:55:42','2501','545000','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-260623-0003','D','2026-06-23','10:55:42','cashier1','PENJUALAN','FJ-260623-0002','259235750','545000','259780750');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260623-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260623-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-06-23 ','11:18:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','11:27:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-06-23 ','11:37:56');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01805','2502','1','KL FANCY KKT PER UBS 16K','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'13000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'13000000'  WHERE tanggal='2026-06-23'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01805','2502','2','LT KS MODEL KURA2 UBS16K','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'13000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'13000000'  WHERE tanggal='2026-06-23'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01805','2026-06-23','2026-06-23','11:38:29','PLG0019023','2502','90','2026-09-21','cashier1','2026-06-23 11:38:29','17.080','13000000','2.50','975000','13975000','0','OPEN','23.45','2','2026-09-21','0','13975000')
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-260623-0004','K','2026-06-23','11:38:29','cashier1','HUTANG','PI26-01805','259780750','13000000','246780750','OPEN') 
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009586','X-00009586','LT COR BT MK','GR','---','MDLT','BELI','BELI001','1007000','2026-06-23','1.200','1','sales','2026-06-23 11:39:10');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00009586','X-00009586');
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-260623-0001','FJ-260207-0003','2402','1','BELI','BELI001','MDLT', 'X-00009586', 'LT COR BT MK','1.200','1.200','100.00','1506000','1007000','839167','1','1007000','1007000','RUSAK BIASA');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-23','BELI','BELI001','MDLT','MDLT','100.00','1.200','1.200','1','1.200','1.200','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260623-0001','2026-06-23','2026-06-23','11:39:09','2402','---','1.200','1007000','1007000','1007000','1007000','1007000','sales','2026-06-23 11:39:10','FB-260623-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260623-0001','SHAFA','JATI SRONO BARAT 2/8','','','','sales','2026-06-23 11:39:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-23' 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-260623-0005','K','2026-06-23','11:39:09','sales','PEMBELIAN UMUM','FB-260623-0001','246780750','1007000','245773750','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260623-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260623-0001';
UPDATE tt_hutang_head SET byr_harus_rp='5000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'5050000',tgl_lunas='2026-06-23',status='CLOS',total_lunas='5050000' WHERE no_hutang='PI26-01794';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-06-23';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-06-23';
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-260623-0006','D','2026-06-23','11:39:56','cashier1','HUTANG LUNAS','PI26-01794','245773750','5050000','250823750');
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01805' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01805';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','11:45:02');
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-260623-0003','sales','1',' ','TOKO','BTATMT','MTAT-YCAD-9-0','AT TINDIK TOGE BL PSR UBS ','','0.980','1','100.00','1852500','0','0','0','1852500','0','0','0','1852500','2403','00024169','MTAT','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-06-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YCAD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-06-23' AND kode_barang='MTAT-YCAD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-260623-0003','2026-06-23','0.980','2026-06-23','12:41:27','PLG0019024','1852500','1852500','0','1852500','1852500','sales','2026-06-23 12:41:26','FJ-260623-0003');
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-06-23','FJ-260623-0003','2026-06-23','12:41:27','2403','1852500','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-260623-0007','D','2026-06-23','12:41:27','sales','PENJUALAN','FJ-260623-0003','250823750','1852500','252676250');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260623-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','13:14:48');
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-00009587','X-00009587','GL ANAK HL RT MN1 1BEL 13CM KKT S SHB','GR','---','MTGL','BELI','BELI001','4855500','2026-06-23','2.920','1','sales','2026-06-23 14:07:59');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009587','X-00009587');
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-260623-0002','FJ-240201-0005','2502','1','BELI','BELI001','MTGL', 'X-00009587', 'GL ANAK HL RT MN1 1BEL 13CM KKT S SHB','2.970','2.920','100.00','2361500','4855500','1662842','1','4855500','4855500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-23','BELI','BELI001','MTGL','MTGL','100.00','2.920','2.920','1','2.920','2.920','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-260623-0002','2026-06-23','2026-06-23','14:07:59','2502','---','2.920','4855500','4855500','4855500','4855500','4855500','sales','2026-06-23 14:07:59','FB-260623-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260623-0002','ADINDA','BANGKALAN MADURA','','','','sales','2026-06-23 14:07:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-23' 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-260623-0008','K','2026-06-23','14:07:59','sales','PEMBELIAN UMUM','FB-260623-0002','252676250','4855500','247820750','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260623-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260623-0002';
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-260623-0009','K','2026-06-23','14:10:09','cashier1','PENGELUARAN','SETOR PUSAT PAK BUDI ','247820750','100000000','147820750');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','14:52:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-06-23 ','15:10:23');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','1','MTAT-YABH-34-0','TOKO','BTATMT','AT JEPSI PLS MK ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.030' WHERE kode_barang='MTAT-YABH-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-34-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 ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','2','MTAT-YAXF-1-0','TOKO','BTATMT','AT JEPSI MN HT MK ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.520' WHERE kode_barang='MTAT-YAXF-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXF-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXF-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.530,berat_hancur_asli=berat_hancur_asli+1.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXF-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-260623-0002','3','MTAT-YABH-37-0','TOKO','BTATMT','AT JEPSI PLS MK ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.050' WHERE kode_barang='MTAT-YABH-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-37-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 ='BTATMT' AND kode_barang='MTAT-YABH-37-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','4','MTAT-YABH-45-0','TOKO','BTATMT','AT JEPSI MN HT MK ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.520' WHERE kode_barang='MTAT-YABH-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.530,berat_hancur_asli=berat_hancur_asli+1.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','5','MTAT-YABH-38-0','TOKO','BTATMT','AT JEPSI PLS MK ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.030' WHERE kode_barang='MTAT-YABH-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-38-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 ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','6','MTAT-YCAE-16-0','TOKO','BTATMT','AT JEPSI SLP KEMBANG MK ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.050' WHERE kode_barang='MTAT-YCAE-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAE-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAE-16-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 ='BTATMT' AND kode_barang='MTAT-YCAE-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-260623-0002','7','MTAT-YCBE-22-0','TOKO','BTATMT','AT JEPSI DEWI 3 MK ','1','3.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='3.020' WHERE kode_barang='MTAT-YCBE-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCBE-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCBE-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.030,berat_hancur_asli=berat_hancur_asli+3.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCBE-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','8','MTAT-YABH-41-0','TOKO','BTATMT','AT JEPSI DEWI 3 MN GANDUL MK ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.900' WHERE kode_barang='MTAT-YABH-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.910,berat_hancur_asli=berat_hancur_asli+2.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','9','MTAT-XKXB-26-0','TOKO','BTATMT','AT KLP KTK TDK BT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.120' WHERE kode_barang='MTAT-XKXB-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXB-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXB-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXB-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-260623-0002','10','MTAT-XKBH-31-0','TOKO','BTATMT','AT KLP KTK TDK BT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.120' WHERE kode_barang='MTAT-XKBH-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','11','MTAT-XKBH-22-0','TOKO','BTATMT','AT KLP KTK BT SHB ','1','2.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.180' WHERE kode_barang='MTAT-XKBH-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.190,berat_hancur_asli=berat_hancur_asli+2.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','12','MTAT-XJBE-3-0','TOKO','BTATMT','AT ANAK CAT BT MK','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.420' WHERE kode_barang='MTAT-XJBE-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJBE-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJBE-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.430,berat_hancur_asli=berat_hancur_asli+1.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJBE-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','13','MTAT-XJBE-6-0','TOKO','BTATMT','AT ANAK CAT BT MK ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.410' WHERE kode_barang='MTAT-XJBE-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJBE-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJBE-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.420,berat_hancur_asli=berat_hancur_asli+1.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJBE-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-260623-0002','14','MTAT-XKXD-29-0','TOKO','BTATMT','AT TUSUK ITALY BUNGA SHB ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.010' WHERE kode_barang='MTAT-XKXD-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXD-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXD-29-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 ='BTATMT' AND kode_barang='MTAT-XKXD-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-260623-0002','15','MTAT-YABH-47-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.060' WHERE kode_barang='MTAT-YABH-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','16','MTAT-XJAE-75-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.000' WHERE kode_barang='MTAT-XJAE-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJAE-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','17','MTAT-XJAE-74-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','2.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.050' WHERE kode_barang='MTAT-XJAE-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.060,berat_hancur_asli=berat_hancur_asli+2.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJAE-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','18','MTAT-YABH-48-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','2.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.040' WHERE kode_barang='MTAT-YABH-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.050,berat_hancur_asli=berat_hancur_asli+2.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','19','MTAT-YDCX-62-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','4.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='4.120' WHERE kode_barang='MTAT-YDCX-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.130,berat_hancur_asli=berat_hancur_asli+4.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-62-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','20','MTAT-YAXD-16-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.250' WHERE kode_barang='MTAT-YAXD-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXD-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXD-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.260,berat_hancur_asli=berat_hancur_asli+2.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXD-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-260623-0002','21','MTAT-YABH-49-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','5.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='5.690' WHERE kode_barang='MTAT-YABH-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.700,berat_hancur_asli=berat_hancur_asli+5.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','22','MTAT-YDCX-68-0','TOKO','BTATMT','AT PARWATI BT BTR SHB ','1','4.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='4.950' WHERE kode_barang='MTAT-YDCX-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.960,berat_hancur_asli=berat_hancur_asli+4.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260623-0002','23','MTAT-YDCX-63-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='4.990' WHERE kode_barang='MTAT-YDCX-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.000,berat_hancur_asli=berat_hancur_asli+5.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','24','MTAT-YDCX-65-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','4.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='4.550' WHERE kode_barang='MTAT-YDCX-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.560,berat_hancur_asli=berat_hancur_asli+4.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260623-0002','25','MTAT-XJAE-73-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.030' WHERE kode_barang='MTAT-XJAE-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XJAE-73-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XJAE-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.040,berat_hancur_asli=berat_hancur_asli+2.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XJAE-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-260623-0002','26','MTAT-YLCX-59-0','TOKO','BTATMT','AT JEPSI SLP KEMBANG SHB ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.520' WHERE kode_barang='MTAT-YLCX-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YLCX-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YLCX-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.530,berat_hancur_asli=berat_hancur_asli+1.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YLCX-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-260623-0002','27','MTAT-YCXE-49-0','TOKO','BTATMT','AT TUSUK ITALY BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.160' WHERE kode_barang='MTAT-YCXE-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.170,berat_hancur_asli=berat_hancur_asli+1.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-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-260623-0002','28','MTAT-XLXB-7-0','TOKO','BTATMT','AT TUSUK ITALY BT SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.060' WHERE kode_barang='MTAT-XLXB-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.070,berat_hancur_asli=berat_hancur_asli+1.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLXB-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-260623-0002','29','MTAT-YCAD-11-0','TOKO','BTATMT','AT COR KLP BT UBS ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.420' WHERE kode_barang='MTAT-YCAD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.430,berat_hancur_asli=berat_hancur_asli+1.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-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-260623-0002','30','MTAT-XGXC-12-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.710' WHERE kode_barang='MTAT-XGXC-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XGXC-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XGXC-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.720,berat_hancur_asli=berat_hancur_asli+1.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XGXC-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','31','MTAT-YABH-17-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.400' WHERE kode_barang='MTAT-YABH-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.410,berat_hancur_asli=berat_hancur_asli+1.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','32','MTAT-YABH-20-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.120' WHERE kode_barang='MTAT-YABH-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','33','MTAT-XKXG-8-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.340' WHERE kode_barang='MTAT-XKXG-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-8-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 ='BTATMT' AND kode_barang='MTAT-XKXG-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','34','MTAT-YBBH-101-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.740' WHERE kode_barang='MTAT-YBBH-101-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-101-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-101-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.750,berat_hancur_asli=berat_hancur_asli+1.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-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-260623-0002','35','MTAT-XKXG-3-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.590','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.580' WHERE kode_barang='MTAT-XKXG-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.590,berat_hancur_asli=berat_hancur_asli+1.590, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','36','MTAT-YABH-10-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.350' WHERE kode_barang='MTAT-YABH-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.360,berat_hancur_asli=berat_hancur_asli+1.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-10-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','37','MTAT-YABH-15-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.480' WHERE kode_barang='MTAT-YABH-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.490,berat_hancur_asli=berat_hancur_asli+1.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','38','MTAT-YABH-12-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.400' WHERE kode_barang='MTAT-YABH-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.410,berat_hancur_asli=berat_hancur_asli+1.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','39','MTAT-YBBH-100-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.890' WHERE kode_barang='MTAT-YBBH-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.900,berat_hancur_asli=berat_hancur_asli+1.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-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-260623-0002','40','MTAT-YABH-19-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.150' WHERE kode_barang='MTAT-YABH-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-19-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','41','MTAT-XKXG-19-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.330' WHERE kode_barang='MTAT-XKXG-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-19-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','42','MTAT-XKXG-18-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.650' WHERE kode_barang='MTAT-XKXG-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.660,berat_hancur_asli=berat_hancur_asli+1.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-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-260623-0002','43','MTAT-XKXG-7-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.550' WHERE kode_barang='MTAT-XKXG-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.560,berat_hancur_asli=berat_hancur_asli+1.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-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-260623-0002','44','MTAT-XCBA-60-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.490' WHERE kode_barang='MTAT-XCBA-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XCBA-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XCBA-60-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 ='BTATMT' AND kode_barang='MTAT-XCBA-60-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','45','MTAT-XKXG-15-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.370' WHERE kode_barang='MTAT-XKXG-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.380,berat_hancur_asli=berat_hancur_asli+1.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-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-260623-0002','46','MTAT-XKXG-11-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.450' WHERE kode_barang='MTAT-XKXG-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.460,berat_hancur_asli=berat_hancur_asli+1.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-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-260623-0002','47','MTAT-YABH-13-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.540' WHERE kode_barang='MTAT-YABH-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.550,berat_hancur_asli=berat_hancur_asli+1.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','48','MTAT-YDCX-29-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.400' WHERE kode_barang='MTAT-YDCX-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.410,berat_hancur_asli=berat_hancur_asli+1.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260623-0002','49','MTAT-YAXD-12-0','TOKO','BTATMT','AT ITALY TDK BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.490' WHERE kode_barang='MTAT-YAXD-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXD-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXD-12-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 ='BTATMT' AND kode_barang='MTAT-YAXD-12-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','50','MTAT-YAXD-14-0','TOKO','BTATMT','AT ITALY VC MRH MK ','1','1.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.720' WHERE kode_barang='MTAT-YAXD-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXD-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXD-14-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 ='BTATMT' AND kode_barang='MTAT-YAXD-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-260623-0002','51','MTAT-YABH-26-0','TOKO','BTATMT','AT CAP VAR BT SHB ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.760' WHERE kode_barang='MTAT-YABH-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.770,berat_hancur_asli=berat_hancur_asli+1.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','52','MTAT-YABH-31-0','TOKO','BTATMT','AT ITALY BT MK ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.930' WHERE kode_barang='MTAT-YABH-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','53','MTAT-XLXB-6-0','TOKO','BTATMT','AT ITALY BT SHB ','1','1.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.710' WHERE kode_barang='MTAT-XLXB-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.720,berat_hancur_asli=berat_hancur_asli+1.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLXB-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-260623-0002','54','MTAT-XLBG-21-0','TOKO','BTATMT','AT ITALY VC SLP BT MK','1','1.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.770' WHERE kode_barang='MTAT-XLBG-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.780,berat_hancur_asli=berat_hancur_asli+1.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-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-260623-0002','55','MTAT-YBBG-59-0','TOKO','BTATMT','AT ITALY BTR VC SLP BT MK ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.510' WHERE kode_barang='MTAT-YBBG-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.520,berat_hancur_asli=berat_hancur_asli+1.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-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-260623-0002','56','MTAT-XKAH-26-0','TOKO','BTATMT','AT TUSUK ITALY VC BTG ','1','2.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.180' WHERE kode_barang='MTAT-XKAH-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKAH-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKAH-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.190,berat_hancur_asli=berat_hancur_asli+2.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKAH-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-260623-0002','57','MTAT-XGAX-27-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.030' WHERE kode_barang='MTAT-XGAX-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XGAX-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XGAX-27-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 ='BTATMT' AND kode_barang='MTAT-XGAX-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-260623-0002','58','MTAT-YBBG-53-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.110' WHERE kode_barang='MTAT-YBBG-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-53-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 ='BTATMT' AND kode_barang='MTAT-YBBG-53-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','59','MTAT-YBBG-56-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.020' WHERE kode_barang='MTAT-YBBG-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-56-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 ='BTATMT' AND kode_barang='MTAT-YBBG-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-260623-0002','60','MTAT-YBBG-45-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.000' WHERE kode_barang='MTAT-YBBG-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.010,berat_hancur_asli=berat_hancur_asli+1.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-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-260623-0002','61','MTAT-YABH-4-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.060' WHERE kode_barang='MTAT-YABH-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.070,berat_hancur_asli=berat_hancur_asli+1.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-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-260623-0002','62','MTAT-YBBH-110-0','TOKO','BTATMT','AT COR BT AD MRH MK ','1','1.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.810' WHERE kode_barang='MTAT-YBBH-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-110-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-110-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.820,berat_hancur_asli=berat_hancur_asli+1.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-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-260623-0002','63','MTAT-YBBG-46-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.030' WHERE kode_barang='MTAT-YBBG-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-46-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 ='BTATMT' AND kode_barang='MTAT-YBBG-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-260623-0002','64','MTAT-XIXE-4-0','TOKO','BTATMT','AT ANAK CAT UBS ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.250' WHERE kode_barang='MTAT-XIXE-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XIXE-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XIXE-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.260,berat_hancur_asli=berat_hancur_asli+1.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XIXE-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-260623-0002','65','MTAT-XLXD-3-0','TOKO','BTATMT','AT COR KAWAT BT MK ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='1.760' WHERE kode_barang='MTAT-XLXD-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXD-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXD-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.770,berat_hancur_asli=berat_hancur_asli+1.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLXD-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0002','66','MTAT-YDCX-34-0','TOKO','BTATMT','AT KAWAT BT SMBR PTH BG3 ','1','2.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:19:11',status_delete='2.010' WHERE kode_barang='MTAT-YDCX-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.020,berat_hancur_asli=berat_hancur_asli+2.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-34-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-260623-0002','2026-06-23','admin','2026-06-23','15:19:11','admin','2026-06-23 15:19:11');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','1','MTGW-XGAX-21-0','TOKO','BTGWMT','GW COR DB SHB ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='2.150' WHERE kode_barang='MTGW-XGAX-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260623-0003','2','MTGW-YBAA-81-0','TOKO','BTGWMT','GW CAP BT SHB ','1','1.310','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.300' WHERE kode_barang='MTGW-YBAA-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YBAA-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YBAA-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.310,berat_hancur_asli=berat_hancur_asli+1.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YBAA-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','3','MTGW-YEXC-32-0','TOKO','BTGWMT','GW CAP TDK BT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='0.720' WHERE kode_barang='MTGW-YEXC-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-32-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260623-0003','4','MTGW-XACA-181-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.610' WHERE kode_barang='MTGW-XACA-181-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XACA-181-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XACA-181-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.620,berat_hancur_asli=berat_hancur_asli+1.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XACA-181-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','5','MTGW-XCAD-36-0','TOKO','BTGWMT','GW COR TDK BT UBS ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.990' WHERE kode_barang='MTGW-XCAD-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XCAD-36-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XCAD-36-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XCAD-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-260623-0003','6','MTGW-XCBA-119-0','TOKO','BTGWMT','GW COR BT PINK SHB ','1','1.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.770' WHERE kode_barang='MTGW-XCBA-119-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XCBA-119-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XCBA-119-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.780,berat_hancur_asli=berat_hancur_asli+1.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XCBA-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-260623-0003','7','MTGW-XGAX-14-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.310' WHERE kode_barang='MTGW-XGAX-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XGAX-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XGAX-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.320,berat_hancur_asli=berat_hancur_asli+1.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XGAX-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-260623-0003','8','MTGW-XLAA-6-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.330' WHERE kode_barang='MTGW-XLAA-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260623-0003','9','MTGW-XLAA-9-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.430' WHERE kode_barang='MTGW-XLAA-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.440,berat_hancur_asli=berat_hancur_asli+1.440, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260623-0003','10','MTGW-YABH-85-0','TOKO','BTGWMT','GW COR BT SHB ','1','2.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='2.110' WHERE kode_barang='MTGW-YABH-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-85-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','11','MTGW-YABH-87-0','TOKO','BTGWMT','GW COR MN PJG HWT ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.950' WHERE kode_barang='MTGW-YABH-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-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-260623-0003','12','MTGW-YABH-91-0','TOKO','BTGWMT','GW COR BT AD MRH SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.500' WHERE kode_barang='MTGW-YABH-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.510,berat_hancur_asli=berat_hancur_asli+1.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-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-260623-0003','13','MTGW-YABH-93-0','TOKO','BTGWMT','GW COR BT ITALY YT ','1','2.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='2.570' WHERE kode_barang='MTGW-YABH-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.580,berat_hancur_asli=berat_hancur_asli+2.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','14','MTGW-YBAA-66-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.110' WHERE kode_barang='MTGW-YBAA-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YBAA-66-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YBAA-66-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 ='BTGWMT' AND kode_barang='MTGW-YBAA-66-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','15','MTGW-YBAA-68-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.230' WHERE kode_barang='MTGW-YBAA-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YBAA-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YBAA-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.240,berat_hancur_asli=berat_hancur_asli+1.240, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YBAA-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-260623-0003','16','MTGW-YCXE-87-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.240' WHERE kode_barang='MTGW-YCXE-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-87-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 ='BTGWMT' AND kode_barang='MTGW-YCXE-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-260623-0003','17','MTGW-YCXE-90-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.410' WHERE kode_barang='MTGW-YCXE-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.420,berat_hancur_asli=berat_hancur_asli+1.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-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-260623-0003','18','MTGW-YCXE-91-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.310' WHERE kode_barang='MTGW-YCXE-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.320,berat_hancur_asli=berat_hancur_asli+1.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-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-260623-0003','19','MTGW-YCXE-92-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.490' WHERE kode_barang='MTGW-YCXE-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-92-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 ='BTGWMT' AND kode_barang='MTGW-YCXE-92-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','20','MTGW-YCXE-93-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.320' WHERE kode_barang='MTGW-YCXE-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.330,berat_hancur_asli=berat_hancur_asli+1.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','21','MTGW-YCXE-96-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.270' WHERE kode_barang='MTGW-YCXE-96-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-96-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-96-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.280,berat_hancur_asli=berat_hancur_asli+1.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-96-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260623-0003','22','MTGW-YEXC-11-0','TOKO','BTGWMT','GW COR BT SHB ','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='2.140' WHERE kode_barang='MTGW-YEXC-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.150,berat_hancur_asli=berat_hancur_asli+2.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260623-0003','23','MTGW-YEXC-16-0','TOKO','BTGWMT','GW COR BT AD MRH SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-06-23 15:23:28',status_delete='1.490' WHERE kode_barang='MTGW-YEXC-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-16-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-16-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-260623-0003','2026-06-23','admin','2026-06-23','15:23:28','admin','2026-06-23 15:23:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-06-23 ','16:12:50');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260623-0004','sales','1',' ','TOKO','BTKLMD','MDKL-ZBBX-99-0','KL LONG LINK 44CM KKT PER UBS ','','6.020','1','100.00','6833000','0','0','0','6833000','0','0','0','6833000','2106','00028647','MDKL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-06-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZBBX-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.020',berat_jual_asli=berat_jual_asli+'6.020',stock_jual='1',berat_akhir=berat_akhir-'6.020',berat_akhir_asli=berat_akhir_asli-'6.020',stock_akhir='0' WHERE tanggal='2026-06-23' AND kode_barang='MDKL-ZBBX-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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-260623-0004','2026-06-23','6.020','2026-06-23','16:18:33','PLG0019025','6833000','6833000','0','6833000','0','sales','2026-06-23 16:18:32','FJ-260623-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-23','FJ-260623-0004','2026-06-23','16:18:33','2106','6833000','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-260623-0001','2026-06-23','2026-06-23 16:18:32','PENJUALAN : FJ-260623-0004','bri','BCA','6833000','6833000','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-260623-0002','D','2026-06-23','16:18:33','BCA','PENJUALAN','FJ-260623-0004','2218663067','6833000','2225496067','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','RACHMAT HIDAYAT');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6833000' WHERE no_faktur_jual='FJ-260623-0004' 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-260623-0005','sales',' 1',' ','TOKO','BTLTMD','MDLT-ZBAI-104-0','LT COR FORTUNE LC2 ','','3.150','1','100.00','3575500','0','0','0','3575500','0','0','0','3575500','2106','00028480','MDLT','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-06-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-06-23' AND kode_barang='MDLT-ZBAI-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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-260623-0005','2026-06-23','3.150','2026-06-23','16:18:33','PLG0019026','3575500','3575500','0','3575500','0','sales','2026-06-23 16:18:32','FJ-260623-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-23','FJ-260623-0005','2026-06-23','16:18:33','2106','3575500','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-260623-0002','2026-06-23','2026-06-23 16:18:32','PENJUALAN : FJ-260623-0005','bri','BCA','3575500','3575500','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-260623-0003','D','2026-06-23','16:18:33','BCA','PENJUALAN','FJ-260623-0005','2225496067','3575500','2229071567','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','RACHMAT HIDAYAT');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3575500' WHERE no_faktur_jual='FJ-260623-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260623-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260623-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260623-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-06-23 ','16:35:51');