INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','08:35:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','08:38:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-30 ','08:40:46');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-30','121','0','-176100000','121','0','-176100000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-29';
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-09-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-29' 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-260930-0001','D','2026-09-30','08:40:56','','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260930-0001','D','2026-09-30','08:40:56','BCA','SALDO AWAL','SALDO AWAL','0','1359829582','1359829582');
UPDATE tp_system SET tgl_system='2026-09-30';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-30 ','08:41:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','08:42:03');
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-260930-0001','1','X-00009864','BELI','BELI001','AT TINDIK PLS SHB','1','0.420','400500.00' ,'0.00','400500','','400500','400500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-30 08:42:17' WHERE kode_barang='X-00009864' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009864' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009864' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.420',berat_hancur_asli=berat_hancur_asli+'0.420', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260930-0001','2','X-00009865','BELI','BELI001','AT ITALY HT BT SHB','1','0.440','629000.00' ,'0.00','629000','','629000','1430000','RUSAK ADA HILANG');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-30 08:42:17' WHERE kode_barang='X-00009865' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009865' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009865' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.440',berat_hancur_asli=berat_hancur_asli+'0.440', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260930-0001','3','X-00009866','BELI','BELI001','KL ITALY ST BT 42CM KKT PER BLT SHB','1','3.270','5294000.00' ,'0.00','5294000','','5294000','7353000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-30 08:42:17' WHERE kode_barang='X-00009866' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009866' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009866' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.270',berat_hancur_asli=berat_hancur_asli+'3.270', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260930-0001','4','X-00009867','BELI','BELI001','GL VANESSA VAR BTR HT BT 17CM KKT PER MK','1','4.840','7835500.00' ,'0.00','7835500','','7835500','20482500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-30 08:42:17' WHERE kode_barang='X-00009867' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009867' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009867' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.840',berat_hancur_asli=berat_hancur_asli+'4.840', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.840',berat_akhir_asli=berat_akhir_asli-'4.840' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-260930-0001','adminpusat','2026-09-30','2026-09-30','08:42:17','14159000','20482500', 'adminpusat','2026-09-30 08:42:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-30 ','09:01:49');
UPDATE tt_hutang_head SET byr_harus_rp='900000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'927000',tgl_lunas='2026-09-30',status='CLOS',total_lunas='927000' WHERE no_hutang='PI26-01853';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'900000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'900000'  WHERE tanggal='2026-09-30';
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-260930-0002','D','2026-09-30','09:12:03','cashier1','HUTANG LUNAS','PI26-01853','74415786','927000','75342786');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','09:28:56');
INSERT INTO tm_credit_card(id_card,nama_customer,no_ktp,alamat1,alamat2,kota,no_telp,tgl_daftar,tgl_valid_until,tgl_last_gesek) VALUES ('6019005102540874','BCA','', ' ' , ' ' , ' ' ,'','2026-09-30 10:10:26','','2026-09-30 10:10:26');
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-260930-0001','cashier1','1',' ','TOKO','BTLTMD','MDLT-ZBBX-74-0','LT COR TDK BT UBS ','','1.270','1','100.00','1410000','0','0','0','1410000','0','0','0','1410000','2403','00028622','MDLT','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBBX-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-09-30' AND kode_barang='MDLT-ZBBX-74-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-260930-0001','2026-09-30','1.270','2026-09-30','10:10:29','PLG0019535','1410000','1410000','0','1410000','0','cashier1','2026-09-30 10:10:27','FJ-260930-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-09-30','FJ-260930-0001','2026-09-30','10:10:29','2403','1410000','0');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260930-0001','2026-09-30','2026-09-30 10:10:27','PENJUALAN : FJ-260930-0001','6019005102540874','BCA','1410000','1410000','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-260930-0002','D','2026-09-30','10:10:29','BCA','PENJUALAN','FJ-260930-0001','1359829582','1410000','1361239582','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='1410000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260930-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260930-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-30 ','10:14:47');
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-00009868','X-00009868','CN COR DB SHB','GR','---','MDCN','BELI','BELI001','973500','2026-09-30','1.020','1','sales','2026-09-30 10:15:59');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009868','X-00009868');
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-260930-0001','FJ-260907-0001','2501','1','BELI','BELI001','MDCN', 'X-00009868', 'CN COR DB SHB','1.020','1.020','100.00','1132500','973500','954412','1','973500','973500','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-09-30','BELI','BELI001','MDCN','MDCN','100.00','1.020','1.020','1','1.020','1.020','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-260930-0001','2026-09-30','2026-09-30','10:15:59','2501','---','1.020','973500','973500','973500','973500','973500','sales','2026-09-30 10:15:59','FB-260930-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260930-0001','KHALISHA','KAMPUNG SENG 4/5','','','','sales','2026-09-30 10:15:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-30' 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-260930-0003','K','2026-09-30','10:15:59','sales','PEMBELIAN UMUM','FB-260930-0001','75342786','973500','74369286','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-00009869','X-00009869','CN COR SLP LC2','GR','---','MDCN','BELI','BELI001','1842000','2026-09-30','1.930','1','sales','2026-09-30 10:16:37');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009869','X-00009869');
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-260930-0002','FJ-260904-0002','2501','1','BELI','BELI001','MDCN', 'X-00009869', 'CN COR SLP LC2','1.930','1.930','100.00','2142500','1842000','954404','1','1842000','1842000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.930',berat_beli_asli=berat_beli_asli+'1.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.930',berat_akhir_asli=berat_akhir_asli+'1.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260930-0002','2026-09-30','2026-09-30','10:16:36','2501','---','1.930','1842000','1842000','1842000','1842000','1842000','sales','2026-09-30 10:16:37','FB-260930-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260930-0002','RAHMA','KAPAS BARU 10/17','','','','sales','2026-09-30 10:16:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-30' 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-260930-0004','K','2026-09-30','10:16:36','sales','PEMBELIAN UMUM','FB-260930-0002','74369286','1842000','72527286','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-00009870','X-00009870','GL PIPA BT AD WARNA SHB','GR','---','MDGL','BELI','BELI001','2779000','2026-09-30','3.970','1','sales','2026-09-30 10:28:03');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009870','X-00009870');
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-260930-0003','FJ-230407-0003','2501','1','BELI','BELI001','MDGL', 'X-00009870', 'GL PIPA BT AD WARNA SHB','4.270','3.970','100.00','2033000','2779000','700000','1','2779000','2779000','RONGSOK');
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-09-30','BELI','BELI001','MDGL','MDGL','100.00','3.970','3.970','1','3.970','3.970','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-260930-0003','2026-09-30','2026-09-30','10:28:02','2501','---','3.970','2779000','2779000','2779000','2779000','2779000','sales','2026-09-30 10:28:03','FB-260930-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260930-0003','NAFA','JL IRAWATI 2/16','','','085230461011','sales','2026-09-30 10:28:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-30' 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-260930-0005','K','2026-09-30','10:28:02','sales','PEMBELIAN UMUM','FB-260930-0003','72527286','2779000','69748286','OPEN');
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-260930-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-YKXD-124-0','CN COR BT SHB ','','1.860','1','100.00','2065000','0','0','0','2065000','0','0','0','2065000','2501','00026630','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-09-30' AND kode_barang='MDCN-YKXD-124-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260930-0002','2026-09-30','1.860','2026-09-30','10:29:03','PLG0019536','2065000','2065000','0','2065000','2065000','sales','2026-09-30 10:29:02','FJ-260930-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-09-30','FJ-260930-0002','2026-09-30','10:29:03','2501','2065000','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-260930-0006','D','2026-09-30','10:29:03','sales','PENJUALAN','FJ-260930-0002','69748286','2065000','71813286');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260930-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260930-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260930-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260930-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260930-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260930-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260930-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260930-0003','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZFXH-28-0','GL BANGKOK TMBL SMBR PTH MT ','','3.140','1','100.00','3485500','0','0','0','3485500','0','0','0','3485500','2501','00030063','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFXH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-09-30' AND kode_barang='MDGL-ZFXH-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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-260930-0003','2026-09-30','3.140','2026-09-30','10:40:54','PLG0019537','3485500','3485500','0','3485500','3485500','sales','2026-09-30 10:40:54','FJ-260930-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-09-30','FJ-260930-0003','2026-09-30','10:40:54','2501','3485500','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-260930-0007','D','2026-09-30','10:40:54','sales','PENJUALAN','FJ-260930-0003','71813286','3485500','75298786');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260930-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','10:45:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-30 ','11:20:18');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','1','MTGW-YABH-96-0','TOKO','BTGWMT','GW CAP DOLLAR YT ','1','1.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.970' WHERE kode_barang='MTGW-YABH-96-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-96-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-96-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.980,berat_hancur_asli=berat_hancur_asli+1.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YABH-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-260930-0002','2','MTGW-YABH-97-0','TOKO','BTGWMT','GW CAP DOLLAR YT ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.990' WHERE kode_barang='MTGW-YABH-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-97-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-YABH-97-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','3','MTGW-YBAA-79-0','TOKO','BTGWMT','GW CAP BT SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.100' WHERE kode_barang='MTGW-YBAA-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YBAA-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YBAA-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YBAA-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','4','MTGW-YCXE-102-0','TOKO','BTGWMT','GW COR DB SHB ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.140' WHERE kode_barang='MTGW-YCXE-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-102-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-102-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.150,berat_hancur_asli=berat_hancur_asli+1.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-102-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','5','MTGW-YEXC-15-0','TOKO','BTGWMT','GW COR BT AD MRH MK ','1','2.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='2.350' WHERE kode_barang='MTGW-YEXC-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.360,berat_hancur_asli=berat_hancur_asli+2.360, 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-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-260930-0002','6','MTGW-YEXC-33-0','TOKO','BTGWMT','GW CAP TDK BT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='0.720' WHERE kode_barang='MTGW-YEXC-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-33-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-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','7','MTGW-YABH-86-0','TOKO','BTGWMT','GW COR BT AD BIRU CAT SHB ','1','1.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.790' WHERE kode_barang='MTGW-YABH-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-86-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.800,berat_hancur_asli=berat_hancur_asli+1.800, 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-86-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','8','MTGW-XLAA-13-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.350' WHERE kode_barang='MTGW-XLAA-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-13-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 ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260930-0002','9','MTGW-XLAA-8-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.440' WHERE kode_barang='MTGW-XLAA-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.450,berat_hancur_asli=berat_hancur_asli+1.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-XLAA-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-260930-0002','10','MTGW-XLAA-11-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.310' WHERE kode_barang='MTGW-XLAA-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-XLAA-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-XLAA-11-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-XLAA-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-260930-0002','11','MTGW-YABH-92-0','TOKO','BTGWMT','GW COR BT YT ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.050' WHERE kode_barang='MTGW-YABH-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YABH-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YABH-92-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 ='BTGWMT' AND kode_barang='MTGW-YABH-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-260930-0002','12','MTGW-YCXE-94-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.450' WHERE kode_barang='MTGW-YCXE-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-94-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 ='BTGWMT' AND kode_barang='MTGW-YCXE-94-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','13','MTGW-YCXE-88-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.370' WHERE kode_barang='MTGW-YCXE-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-88-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-88-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 ='BTGWMT' AND kode_barang='MTGW-YCXE-88-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','14','MTGW-YCXE-89-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.340' WHERE kode_barang='MTGW-YCXE-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCXE-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCXE-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCXE-89-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','15','MTGW-YBAG-16-0','TOKO','BTGWMT','GW COR TDK BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.290' WHERE kode_barang='MTGW-YBAG-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YBAG-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YBAG-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YBAG-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-260930-0002','16','MTGW-YEXC-10-0','TOKO','BTGWMT','GW COR BT SHB ','1','2.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='2.290' WHERE kode_barang='MTGW-YEXC-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.300,berat_hancur_asli=berat_hancur_asli+2.300, 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-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-260930-0002','17','MTGW-YEXC-31-0','TOKO','BTGWMT','GW CAP BT SHB ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.140' WHERE kode_barang='MTGW-YEXC-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.150,berat_hancur_asli=berat_hancur_asli+1.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260930-0002','18','MTGW-YEXC-27-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.440','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.430' WHERE kode_barang='MTGW-YEXC-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-27-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-YEXC-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-260930-0002','19','MTGW-YEXC-25-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.510' WHERE kode_barang='MTGW-YEXC-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-25-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-25-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','20','MTGW-YEXC-17-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.230' WHERE kode_barang='MTGW-YEXC-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-17-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-YEXC-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-260930-0002','21','MTGW-YEXC-1-0','TOKO','BTGWMT','GW COR BT MK ','1','1.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.200' WHERE kode_barang='MTGW-YEXC-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.210,berat_hancur_asli=berat_hancur_asli+1.210, 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-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-260930-0002','22','MTGW-YEXC-7-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.310','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.300' WHERE kode_barang='MTGW-YEXC-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-7-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-YEXC-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-260930-0002','23','MTGW-YEXC-2-0','TOKO','BTGWMT','GW COR BT SHB','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.590' WHERE kode_barang='MTGW-YEXC-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','24','MTGW-YEXC-18-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.100' WHERE kode_barang='MTGW-YEXC-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.110,berat_hancur_asli=berat_hancur_asli+1.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260930-0002','25','MTGW-YEXC-29-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.360' WHERE kode_barang='MTGW-YEXC-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.370,berat_hancur_asli=berat_hancur_asli+1.370, 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-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-260930-0002','26','MTGW-YEXC-23-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.500' WHERE kode_barang='MTGW-YEXC-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-23-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-YEXC-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','27','MTGW-YEXC-21-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.470' WHERE kode_barang='MTGW-YEXC-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.480,berat_hancur_asli=berat_hancur_asli+1.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260930-0002','28','MTGW-YEXC-20-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.110' WHERE kode_barang='MTGW-YEXC-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-20-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-YEXC-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-260930-0002','29','MTGW-YEXC-22-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.680','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.670' WHERE kode_barang='MTGW-YEXC-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.680,berat_hancur_asli=berat_hancur_asli+1.680, 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-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-260930-0002','30','MTGW-YEXC-9-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.600' WHERE kode_barang='MTGW-YEXC-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.610,berat_hancur_asli=berat_hancur_asli+1.610, 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-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-260930-0002','31','MTGW-YEXC-30-0','TOKO','BTGWMT','GW COR BT MK ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.590' WHERE kode_barang='MTGW-YEXC-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YEXC-30-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','32','MTGW-YEXC-19-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.450' WHERE kode_barang='MTGW-YEXC-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-19-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-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-260930-0002','33','MTGW-YEXC-39-0','TOKO','BTGWMT','GW COR DOLLAR UBS ','1','1.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.900' WHERE kode_barang='MTGW-YEXC-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.910,berat_hancur_asli=berat_hancur_asli+1.910, 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-39-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','34','MTGW-YEXC-14-0','TOKO','BTGWMT','GW COR BT AD BIRU SHB ','1','1.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.820' WHERE kode_barang='MTGW-YEXC-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.830,berat_hancur_asli=berat_hancur_asli+1.830, 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-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-260930-0002','35','MTGW-YEXC-12-0','TOKO','BTGWMT','GW COR BT HWT ','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='2.140' WHERE kode_barang='MTGW-YEXC-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-12-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-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-260930-0002','36','MTGW-YEXC-5-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.250' WHERE kode_barang='MTGW-YEXC-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-5-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','37','MTGW-YEXC-28-0','TOKO','BTGWMT','GW COR BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.450' WHERE kode_barang='MTGW-YEXC-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-28-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-28-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 ='BTGWMT' AND kode_barang='MTGW-YEXC-28-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','38','MTGW-YCAD-58-0','TOKO','BTGWMT','GW COR BT PJG UBS ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.420' WHERE kode_barang='MTGW-YCAD-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCAD-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCAD-58-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 ='BTGWMT' AND kode_barang='MTGW-YCAD-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','39','MTGW-YCBE-47-0','TOKO','BTGWMT','GW FANCY FKL UBS ','1','2.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='2.190' WHERE kode_barang='MTGW-YCBE-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YCBE-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YCBE-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.200,berat_hancur_asli=berat_hancur_asli+2.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YCBE-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-260930-0002','40','MTGW-YEXC-40-0','TOKO','BTGWMT','GW COR TDK BT UBS ','1','2.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='2.400' WHERE kode_barang='MTGW-YEXC-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YEXC-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YEXC-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.410,berat_hancur_asli=berat_hancur_asli+2.410, 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-40-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0002','41','MTGW-YFAH-159-0','TOKO','BTGWMT','GW COR BT CAT SHB ','1','1.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:28:47',status_delete='1.820' WHERE kode_barang='MTGW-YFAH-159-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-YFAH-159-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-YFAH-159-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.830,berat_hancur_asli=berat_hancur_asli+1.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMT' AND kode_barang='MTGW-YFAH-159-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-260930-0002','2026-09-30','admin','2026-09-30','11:28:47','admin','2026-09-30 11:28:47');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','1','MTAT-XKXB-15-0','TOKO','BTATMT','AT KLP KTK BT SHB ','1','2.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.220' WHERE kode_barang='MTAT-XKXB-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXB-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXB-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.230,berat_hancur_asli=berat_hancur_asli+2.230, 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-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-260930-0003','2','MTAT-XLBG-18-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.510' WHERE kode_barang='MTAT-XLBG-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-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-260930-0003','3','MTAT-YBBG-48-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.060' WHERE kode_barang='MTAT-YBBG-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-48-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-YBBG-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-260930-0003','4','MTAT-YBBG-35-0','TOKO','BTATMT','AT TINDIK MN PLAT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.720' WHERE kode_barang='MTAT-YBBG-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-35-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 ='BTATMT' AND kode_barang='MTAT-YBBG-35-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','5','MTAT-YBBG-34-0','TOKO','BTATMT','AT TINDIK MN PLAT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.720' WHERE kode_barang='MTAT-YBBG-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-34-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 ='BTATMT' AND kode_barang='MTAT-YBBG-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-260930-0003','6','MTAT-YBBG-31-0','TOKO','BTATMT','AT TINDIK MN PLAT MK ','1','0.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.720' WHERE kode_barang='MTAT-YBBG-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-31-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 ='BTATMT' AND kode_barang='MTAT-YBBG-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-260930-0003','7','MTAT-YDCX-13-0','TOKO','BTATMT','AT TINDIK PLAT MK ','1','0.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.690' WHERE kode_barang='MTAT-YDCX-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.700,berat_hancur_asli=berat_hancur_asli+0.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-YDCX-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-260930-0003','8','MTAT-YDCX-10-0','TOKO','BTATMT','AT TINDIK PLAT MK ','1','0.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.640' WHERE kode_barang='MTAT-YDCX-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','9','MTAT-YCAE-15-0','TOKO','BTATMT','AT TINDIK MN PLAT MK ','1','0.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.640' WHERE kode_barang='MTAT-YCAE-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAE-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAE-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAE-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-260930-0003','10','MTAT-YDCX-41-0','TOKO','BTATMT','AT ITALY BT SHB ','1','1.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.540' WHERE kode_barang='MTAT-YDCX-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-41-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-YDCX-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-260930-0003','11','MTAT-YFAH-84-0','TOKO','BTATMT','AT ITALY BTR BT MK ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.760' WHERE kode_barang='MTAT-YFAH-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YFAH-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YFAH-84-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-YFAH-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','12','MTAT-YBBG-61-0','TOKO','BTATMT','AT ITALY VC SLP BT MK ','1','1.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.540' WHERE kode_barang='MTAT-YBBG-61-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-61-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-61-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-YBBG-61-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','13','MTAT-YCBE-21-0','TOKO','BTATMT','AT ITALY BT SHB ','1','1.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.660' WHERE kode_barang='MTAT-YCBE-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCBE-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCBE-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.670,berat_hancur_asli=berat_hancur_asli+1.670, 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-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-260930-0003','14','MTAT-YDCX-43-0','TOKO','BTATMT','AT ITALY TDK BT SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.500' WHERE kode_barang='MTAT-YDCX-43-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-43-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-43-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 ='BTATMT' AND kode_barang='MTAT-YDCX-43-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','15','MTAT-YDCX-47-0','TOKO','BTATMT','AT KAWAT RUMBAI BT MK ','1','2.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.190' WHERE kode_barang='MTAT-YDCX-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.200,berat_hancur_asli=berat_hancur_asli+2.200, 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-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-260930-0003','16','MTAT-YDCX-48-0','TOKO','BTATMT','AT KAWAT SPIRAL BT SHB ','1','1.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.960' WHERE kode_barang='MTAT-YDCX-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.970,berat_hancur_asli=berat_hancur_asli+1.970, 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-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-260930-0003','17','MTAT-YDCX-38-0','TOKO','BTATMT','AT CAP KAWAT BT BTR BL SLP SHB ','1','2.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.190' WHERE kode_barang='MTAT-YDCX-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.200,berat_hancur_asli=berat_hancur_asli+2.200, 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-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-260930-0003','18','MTAT-YDCX-37-0','TOKO','BTATMT','AT CAP KAWAT BT BTR BL SLP SHB ','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.140' WHERE kode_barang='MTAT-YDCX-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-37-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 ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','19','MTAT-YDCX-36-0','TOKO','BTATMT','AT CAP KAWAT BT BTR SHB ','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.000' WHERE kode_barang='MTAT-YDCX-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-36-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-36-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-YDCX-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-260930-0003','20','MTAT-YCBE-19-0','TOKO','BTATMT','AT CAP KWT BTR BT SHB ','1','1.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.630' WHERE kode_barang='MTAT-YCBE-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCBE-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCBE-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.640,berat_hancur_asli=berat_hancur_asli+1.640, 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-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-260930-0003','21','MTAT-YCAD-17-0','TOKO','BTATMT','AT COR KLP TDK BT UBS ','1','2.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.500' WHERE kode_barang='MTAT-YCAD-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.510,berat_hancur_asli=berat_hancur_asli+2.510, 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-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-260930-0003','22','MTAT-YDCX-30-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.700' WHERE kode_barang='MTAT-YDCX-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.710,berat_hancur_asli=berat_hancur_asli+1.710, 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-30-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','23','MTAT-YDCX-31-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.950' WHERE kode_barang='MTAT-YDCX-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-31-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 ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','24','MTAT-YCAD-12-0','TOKO','BTATMT','AT COR KLP BT UBS ','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.460' WHERE kode_barang='MTAT-YCAD-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.470,berat_hancur_asli=berat_hancur_asli+1.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-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-260930-0003','25','MTAT-YCAD-15-0','TOKO','BTATMT','AT COR KLP TDK BT MN HT UBS ','1','1.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.800' WHERE kode_barang='MTAT-YCAD-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-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-260930-0003','26','MTAT-YCXE-36-0','TOKO','BTATMT','AT COR KLP TDK BT MN BL SHB ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.950' WHERE kode_barang='MTAT-YCXE-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-36-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-36-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 ='BTATMT' AND kode_barang='MTAT-YCXE-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-260930-0003','27','MTAT-YCAD-13-0','TOKO','BTATMT','AT COR KLP HT BT UBS ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.060' WHERE kode_barang='MTAT-YCAD-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-13-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-YCAD-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-260930-0003','28','MTAT-YCAD-14-0','TOKO','BTATMT','AT COR KLP HT BT UBS ','1','2.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.040' WHERE kode_barang='MTAT-YCAD-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-14-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-YCAD-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-260930-0003','29','MTAT-YDCX-22-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.170' WHERE kode_barang='MTAT-YDCX-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.180,berat_hancur_asli=berat_hancur_asli+1.180, 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-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-260930-0003','30','MTAT-YABH-14-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.450' WHERE kode_barang='MTAT-YABH-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-14-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-YABH-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-260930-0003','31','MTAT-XKXG-13-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.530' WHERE kode_barang='MTAT-XKXG-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.540,berat_hancur_asli=berat_hancur_asli+1.540, 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-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-260930-0003','32','MTAT-YDCX-26-0','TOKO','BTATMT','AT COR KLP BT UBS ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.590' WHERE kode_barang='MTAT-YDCX-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','33','MTAT-YEXE-77-0','TOKO','BTATMT','AT COR KLP BT SHB','1','1.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.260' WHERE kode_barang='MTAT-YEXE-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YEXE-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YEXE-77-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.270,berat_hancur_asli=berat_hancur_asli+1.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YEXE-77-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','34','MTAT-YDCX-23-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='2.090' WHERE kode_barang='MTAT-YDCX-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','35','MTAT-XKXG-9-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.520' WHERE kode_barang='MTAT-XKXG-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-9-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-XKXG-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-260930-0003','36','MTAT-YDCX-16-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.350' WHERE kode_barang='MTAT-YDCX-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-16-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-YDCX-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-260930-0003','37','MTAT-YDCX-19-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.620' WHERE kode_barang='MTAT-YDCX-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.630,berat_hancur_asli=berat_hancur_asli+1.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','38','MTAT-YDCX-17-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.340' WHERE kode_barang='MTAT-YDCX-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-17-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-YDCX-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-260930-0003','39','MTAT-YDCX-20-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.760' WHERE kode_barang='MTAT-YDCX-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-20-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-YDCX-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-260930-0003','40','MTAT-YEXE-78-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.280' WHERE kode_barang='MTAT-YEXE-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YEXE-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YEXE-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.290,berat_hancur_asli=berat_hancur_asli+1.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YEXE-78-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','41','MTAT-XLXB-1-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.520' WHERE kode_barang='MTAT-XLXB-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-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-XLXB-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-260930-0003','42','MTAT-XLXB-3-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.410' WHERE kode_barang='MTAT-XLXB-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-3-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-XLXB-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-260930-0003','43','MTAT-YDCX-21-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.320' WHERE kode_barang='MTAT-YDCX-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-21-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 ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','44','MTAT-YDCX-15-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.320' WHERE kode_barang='MTAT-YDCX-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-15-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 ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','45','MTAT-YABH-6-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.000' WHERE kode_barang='MTAT-YABH-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-6-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-YABH-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-260930-0003','46','MTAT-YABH-7-0','TOKO','BTATMT','AT ANAK CAT MK ','1','1.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.000' WHERE kode_barang='MTAT-YABH-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-7-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-YABH-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-260930-0003','47','MTAT-XLXC-41-0','TOKO','BTATMT','AT ANAK CAT UBS ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.330' WHERE kode_barang='MTAT-XLXC-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXC-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXC-41-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-XLXC-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-260930-0003','48','MTAT-YEXE-80-0','TOKO','BTATMT','AT ANAK CAT UBS ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.510' WHERE kode_barang='MTAT-YEXE-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YEXE-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YEXE-80-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-YEXE-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','49','MTAT-YBBG-54-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB','1','1.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.200' WHERE kode_barang='MTAT-YBBG-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.210,berat_hancur_asli=berat_hancur_asli+1.210, 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-54-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','50','MTAT-YBBG-47-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='1.150' WHERE kode_barang='MTAT-YBBG-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-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-260930-0003','51','MTAT-YDCX-2-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.550' WHERE kode_barang='MTAT-YDCX-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.560,berat_hancur_asli=berat_hancur_asli+0.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-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','52','MTAT-YDCX-4-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.570' WHERE kode_barang='MTAT-YDCX-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','53','MTAT-YDCX-7-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.590' WHERE kode_barang='MTAT-YDCX-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.600,berat_hancur_asli=berat_hancur_asli+0.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','54','MTAT-YDCX-1-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.590' WHERE kode_barang='MTAT-YDCX-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.600,berat_hancur_asli=berat_hancur_asli+0.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','55','MTAT-YDCX-6-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.590' WHERE kode_barang='MTAT-YDCX-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.600,berat_hancur_asli=berat_hancur_asli+0.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-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-260930-0003','56','MTAT-YDCX-8-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.610' WHERE kode_barang='MTAT-YDCX-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.620,berat_hancur_asli=berat_hancur_asli+0.620, 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-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-260930-0003','57','MTAT-YDCX-3-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.620' WHERE kode_barang='MTAT-YDCX-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.630,berat_hancur_asli=berat_hancur_asli+0.630, 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-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-260930-0003','58','MTAT-YDCX-5-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.640' WHERE kode_barang='MTAT-YDCX-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260930-0003','59','MTAT-YCAD-8-0','TOKO','BTATMT','AT TINDIK TOGE BL PSR UBS ','1','0.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.960' WHERE kode_barang='MTAT-YCAD-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.970,berat_hancur_asli=berat_hancur_asli+0.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-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-260930-0003','60','MTAT-YCAD-7-0','TOKO','BTATMT','AT TINDIK TOGE BL PSR UBS ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-30 11:37:27',status_delete='0.950' WHERE kode_barang='MTAT-YCAD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.960,berat_hancur_asli=berat_hancur_asli+0.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-7-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-260930-0003','2026-09-30','admin','2026-09-30','11:37:27','admin','2026-09-30 11:37:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','12:24:52');
UPDATE tt_hutang_head SET byr_harus_rp='2000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'2190000',tgl_lunas='2026-09-30',status='CLOS',total_lunas='2190000' WHERE no_hutang='PI25-01549';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000'  WHERE tanggal='2026-09-30';
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-260930-0008','D','2026-09-30','12:45:54','cashier1','HUTANG LUNAS','PI25-01549','75298786','2190000','77488786');
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-00009871','X-00009871','AT COR KLP BT SHB','GR','---','MTAT','BELI','BELI001','2687500','2026-09-30','1.660','1','sales','2026-09-30 13:50:13');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009871','X-00009871');
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-260930-0004','FJ-230503-0006','2501','1','BELI','BELI001','MTAT', 'X-00009871', 'AT COR KLP BT SHB','1.710','1.660','100.00','1257000','2687500','1618976','1','2687500','2687500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.660',berat_beli_asli=berat_beli_asli+'1.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.660',berat_akhir_asli=berat_akhir_asli+'1.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260930-0004','2026-09-30','2026-09-30','13:50:12','2501','---','1.660','2687500','2687500','2687500','2687500','2687500','sales','2026-09-30 13:50:13','FB-260930-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260930-0004','SITI AMINAH','KAPASARI 5/40','','','087778554282','sales','2026-09-30 13:50:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-30' 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-260930-0009','K','2026-09-30','13:50:12','sales','PEMBELIAN UMUM','FB-260930-0004','77488786','2687500','74801286','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260930-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260930-0004';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260930-0010','K','2026-09-30','13:56:59','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','74801286','54000','74747286');
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-00009872','X-00009872','AT COR KAWAT FORTUNE LC2','GR','---','MDAT','BELI','BELI001','2787000','2026-09-30','2.920','1','sales','2026-09-30 14:05:54');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009872','X-00009872');
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-260930-0005','FJ-260922-0006','2105','1','BELI','BELI001','MDAT', 'X-00009872', 'AT COR KAWAT FORTUNE LC2','2.920','2.920','100.00','3241500','2787000','954452','1','2787000','2787000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.920',berat_beli_asli=berat_beli_asli+'2.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.920',berat_akhir_asli=berat_akhir_asli+'2.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260930-0005','2026-09-30','2026-09-30','14:05:54','2105','---','2.920','2787000','2787000','2787000','2787000','2787000','sales','2026-09-30 14:05:54','FB-260930-0005','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260930-0005','MARITA','JL. TMBK WEDI 1/33A','','','082330312852','sales','2026-09-30 14:05:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-30' 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-260930-0011','K','2026-09-30','14:05:54','sales','PEMBELIAN UMUM','FB-260930-0005','74747286','2787000','71960286','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260930-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260930-0005';
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-260930-0004','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZIAH-30-0','CN COR BT SHB ','','1.160','1','100.00','1288000','0','0','0','1288000','0','0','0','1288000','2103','00031467','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZIAH-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-09-30' AND kode_barang='MDCN-ZIAH-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260930-0004','2026-09-30','1.160','2026-09-30','15:30:19','PLG0019538','1288000','1288000','0','1288000','1288000','sales','2026-09-30 15:30:19','FJ-260930-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-09-30','FJ-260930-0004','2026-09-30','15:30:19','2103','1288000','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-260930-0012','D','2026-09-30','15:30:19','sales','PENJUALAN','FJ-260930-0004','71960286','1288000','73248286');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260930-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260930-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-30 ','16:28:30');