INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','08:01:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','08:09:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-04 ','08:35:33');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-04','122','0','-170900000','122','0','-170900000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-03';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-03' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260904-0001','D','2026-09-04','08:35:52','BCA','SALDO AWAL','SALDO AWAL','0','2130992213','2130992213');
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-260904-0001','D','2026-09-04','08:35:52','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-04 ','08:36:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','08:37:08');
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-260904-0001','1','X-00009782','BELI','BELI001','KL FANCY ANAK VAR CAT 35CM KKT PER UBS','1','1.890','1551000.00' ,'0.00','1551000','','1551000','1551000','RUSAK BIASA');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-04 08:37:29' WHERE kode_barang='X-00009782' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009782' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009782' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.890',berat_hancur_asli=berat_hancur_asli+'1.890', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' 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-260904-0001','adminpusat','2026-09-04','2026-09-04','08:37:29','1551000','1551000', 'adminpusat','2026-09-04 08:37:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','08:45:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-04 ','08:58:48');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009783','X-00009783','CN CAP BANGKOK SLP SHB','GR','---','MDCN','BELI','BELI001','973500','2026-09-04','1.020','1','sales','2026-09-04 10:34:20');
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-00009783','X-00009783');
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-260904-0001','FJ-260828-0001','2105','1','BELI','BELI001','MDCN', 'X-00009783', 'CN CAP BANGKOK SLP SHB','1.020','1.020','100.00','1147500','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-04','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-260904-0001','2026-09-04','2026-09-04','10:34:19','2105','---','1.020','973500','973500','973500','973500','973500','sales','2026-09-04 10:34:20','FB-260904-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260904-0001','RAHMA','KAPAS BR 10/17','','','','sales','2026-09-04 10:34:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-04' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260904-0002','K','2026-09-04','10:34:19','sales','PEMBELIAN UMUM','FB-260904-0001','115867610','973500','114894110','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260904-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260904-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260904-0001','sales','1',' EX ','TOKO','BTKLMT','MTKL-ZEAC-2-0','KL FANCY DB 41CM KKT S SHB ','','2.300','1','100.00','4232000','0','0','0','4232000','0','0','0','4232000','2105','00029492','MTKL','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-ZEAC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-09-04' AND kode_barang='MTKL-ZEAC-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260904-0001','2026-09-04','2.300','2026-09-04','10:38:42','PLG0019428','4232000','4232000','0','4232000','4232000','sales','2026-09-04 10:38:41','FJ-260904-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-04','FJ-260904-0001','2026-09-04','10:38:42','2105','4232000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260904-0003','D','2026-09-04','10:38:42','sales','PENJUALAN','FJ-260904-0001','114894110','4232000','119126110','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4232000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260904-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260904-0002','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZGAE-66-0','CN COR SLP LC2 ','','1.930','1','100.00','2142500','0','0','0','2142500','0','0','0','2142500','2105','00030818','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZGAE-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-09-04' AND kode_barang='MDCN-ZGAE-66-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-260904-0002','2026-09-04','1.930','2026-09-04','10:38:42','PLG0019429','2142500','2142500','0','2142500','2142500','sales','2026-09-04 10:38:41','FJ-260904-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-04','FJ-260904-0002','2026-09-04','10:38:42','2105','2142500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260904-0004','D','2026-09-04','10:38:42','sales','PENJUALAN','FJ-260904-0002','119126110','2142500','121268610','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2142500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260904-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260904-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260904-0002';
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-00009784','X-00009784','AT KLEP BKK CKT PASIRAN','GR','---','MTAT','BELI','BELI001','2860000','2026-09-04','2.000','1','sales','2026-09-04 12:08:33');
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-00009784','X-00009784');
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-260904-0002','-','2501','1','BELI','BELI001','MTAT', 'X-00009784', 'AT KLEP BKK CKT PASIRAN','2.200','2.000','100.00','880000','2860000','1430000','1','2860000','2860000','CUCI');
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-04','BELI','BELI001','MTAT','MTAT','100.00','2.000','2.000','1','2.000','2.000','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-260904-0002','2026-09-04','2026-09-04','12:08:33','2501','---','2.000','2860000','2860000','2860000','2860000','2860000','sales','2026-09-04 12:08:33','FB-260904-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260904-0002','-','-','','','','sales','2026-09-04 12:08:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-04' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260904-0005','K','2026-09-04','12:08:33','sales','PEMBELIAN UMUM','FB-260904-0002','121268610','2860000','118408610','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260904-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260904-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','13:27:28');
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-260904-0003','cashier1','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','2501','00028657','MSKL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-09-04' AND kode_barang='MSKL-ZBBX-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMS' 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-260904-0003','2026-09-04','1.550','2026-09-04','13:44:00','PLG0019430','1837500','1837500','0','1837500','1837500','cashier1','2026-09-04 13:43:59','FJ-260904-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-04','FJ-260904-0003','2026-09-04','13:44:00','2501','1837500','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-260904-0006','D','2026-09-04','13:44:00','cashier1','PENJUALAN','FJ-260904-0003','118408610','1837500','120246110');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260904-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-04 ','14:10:16');
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-260904-0004','sales','1',' EX ','TOKO','BTATMT','MTAT-ZFAB-2-0','AT JEPSI SLP KEMBANG SHB ','','1.030','1','100.00','1895500','0','0','0','1895500','0','0','0','1895500','2103','00030161','MTAT','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZFAB-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-09-04' AND kode_barang='MTAT-ZFAB-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260904-0004','2026-09-04','1.030','2026-09-04','14:11:21','PLG0019431','1895500','1895500','0','1895500','1895500','sales','2026-09-04 14:11:21','FJ-260904-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-04','FJ-260904-0004','2026-09-04','14:11:21','2103','1895500','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-260904-0007','D','2026-09-04','14:11:21','sales','PENJUALAN','FJ-260904-0004','120246110','1895500','122141610');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260904-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-04 ','14:38:04');
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-260904-0008','K','2026-09-04','14:41:59','admin','PENGELUARAN','BATAL TU2608290001 29082026 UMIK NURUL KARENA KESALAHAN SISTEM','122141610','500000','121641610');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-04 ','14:45:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-04 ','14:46:59');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','1','MTCN-WHAE-58-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.920' WHERE kode_barang='MTCN-WHAE-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-WHAE-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-WHAE-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.930,berat_hancur_asli=berat_hancur_asli+2.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-WHAE-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-260904-0002','2','MTCN-XKXG-55-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.150' WHERE kode_barang='MTCN-XKXG-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XKXG-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XKXG-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.160,berat_hancur_asli=berat_hancur_asli+5.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XKXG-55-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','3','MTCN-XKXG-23-0','TOKO','BTCNMT','CN EROPA SHB ','1','5.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.760' WHERE kode_barang='MTCN-XKXG-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XKXG-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XKXG-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.770,berat_hancur_asli=berat_hancur_asli+5.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XKXG-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-260904-0002','4','MTCN-XKXB-85-0','TOKO','BTCNMT','CN COR CAT BT MK ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.210' WHERE kode_barang='MTCN-XKXB-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XKXB-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XKXB-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XKXB-85-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','5','MTCN-YAXD-41-0','TOKO','BTCNMT','CN COR TDK BT SMBR PTH BG3 ','1','3.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='3.420' WHERE kode_barang='MTCN-YAXD-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YAXD-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YAXD-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.430,berat_hancur_asli=berat_hancur_asli+3.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YAXD-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-260904-0002','6','MTCN-YCXF-70-0','TOKO','BTCNMT','CN COR DB SHB ','1','3.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='3.840' WHERE kode_barang='MTCN-YCXF-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXF-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXF-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.850,berat_hancur_asli=berat_hancur_asli+3.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCXF-70-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','7','MTCN-YBBH-189-0','TOKO','BTCNMT','CN COR TDK BT SMBR PTH BG3 ','1','3.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='3.660' WHERE kode_barang='MTCN-YBBH-189-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-189-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-189-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.670,berat_hancur_asli=berat_hancur_asli+3.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-189-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','8','MTCN-YCXF-9-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.190' WHERE kode_barang='MTCN-YCXF-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXF-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXF-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.200,berat_hancur_asli=berat_hancur_asli+1.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCXF-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-260904-0002','9','MTCN-YCXE-64-0','TOKO','BTCNMT','CN COR HT BT MK ','1','0.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.630' WHERE kode_barang='MTCN-YCXE-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXE-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXE-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.640,berat_hancur_asli=berat_hancur_asli+0.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCXE-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','10','MTCN-YBBH-177-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.360' WHERE kode_barang='MTCN-YBBH-177-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-177-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-177-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 ='BTCNMT' AND kode_barang='MTCN-YBBH-177-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','11','MTCN-YCXE-68-0','TOKO','BTCNMT','CN COR BT CAT SHB ','1','1.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.100' WHERE kode_barang='MTCN-YCXE-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXE-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXE-68-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 ='BTCNMT' AND kode_barang='MTCN-YCXE-68-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','12','MTCN-YBBH-182-0','TOKO','BTCNMT','CN COR TDK BT UBS ','1','2.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.710' WHERE kode_barang='MTCN-YBBH-182-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-182-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-182-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.720,berat_hancur_asli=berat_hancur_asli+2.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-182-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','13','MTCN-YCXE-69-0','TOKO','BTCNMT','CN COR BT CAT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.340' WHERE kode_barang='MTCN-YCXE-69-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXE-69-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXE-69-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 ='BTCNMT' AND kode_barang='MTCN-YCXE-69-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','14','MTCN-YBBH-183-0','TOKO','BTCNMT','CN COR TDK BT UBS ','1','2.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.790' WHERE kode_barang='MTCN-YBBH-183-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-183-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-183-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.800,berat_hancur_asli=berat_hancur_asli+2.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-183-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','15','MTCN-YCXD-7-0','TOKO','BTCNMT','CN COR TDK BT BG3 ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.340' WHERE kode_barang='MTCN-YCXD-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXD-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXD-7-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 ='BTCNMT' AND kode_barang='MTCN-YCXD-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-260904-0002','16','MTCN-YCAE-29-0','TOKO','BTCNMT','CN SESER SHB ','1','10.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='10.260' WHERE kode_barang='MTCN-YCAE-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCAE-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCAE-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.270,berat_hancur_asli=berat_hancur_asli+10.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCAE-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-260904-0002','17','MTCN-YEXE-110-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.060' WHERE kode_barang='MTCN-YEXE-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-110-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-110-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-110-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','18','MTCN-YEXE-129-0','TOKO','BTCNMT','CN COR CAT MK ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.290' WHERE kode_barang='MTCN-YEXE-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-129-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-129-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','19','MTCN-YCAD-27-0','TOKO','BTCNMT','CN COR BT UBS ','1','2.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.420' WHERE kode_barang='MTCN-YCAD-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCAD-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCAD-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.430,berat_hancur_asli=berat_hancur_asli+2.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCAD-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-260904-0002','20','MTCN-UDBH-19-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.730','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.720' WHERE kode_barang='MTCN-UDBH-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-UDBH-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-UDBH-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.730,berat_hancur_asli=berat_hancur_asli+2.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-UDBH-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-260904-0002','21','MTCN-XACA-92-0','TOKO','BTCNMT','CN COR BT MK ','1','1.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.260' WHERE kode_barang='MTCN-XACA-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XACA-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XACA-92-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 ='BTCNMT' AND kode_barang='MTCN-XACA-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-260904-0002','22','MTCN-YBBH-159-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.040' WHERE kode_barang='MTCN-YBBH-159-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-159-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-159-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-159-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','23','MTCN-XACA-71-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.150' WHERE kode_barang='MTCN-XACA-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XACA-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XACA-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XACA-71-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','24','MTCN-XGXC-35-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.050' WHERE kode_barang='MTCN-XGXC-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XGXC-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XGXC-35-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 ='BTCNMT' AND kode_barang='MTCN-XGXC-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-260904-0002','25','MTCN-XGCA-28-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.200' WHERE kode_barang='MTCN-XGCA-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XGCA-28-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XGCA-28-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 ='BTCNMT' AND kode_barang='MTCN-XGCA-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-260904-0002','26','MTCN-XEBE-19-0','TOKO','BTCNMT','CN COR BT UBS ','1','1.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.480' WHERE kode_barang='MTCN-XEBE-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XEBE-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XEBE-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.490,berat_hancur_asli=berat_hancur_asli+1.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XEBE-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-260904-0002','27','MTCN-XIXE-37-0','TOKO','BTCNMT','CN COR BT CAT SHB ','1','1.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.850' WHERE kode_barang='MTCN-XIXE-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XIXE-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XIXE-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.860,berat_hancur_asli=berat_hancur_asli+1.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XIXE-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-260904-0002','28','MTCN-XLXB-18-0','TOKO','BTCNMT','CN COR BT MK ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.140' WHERE kode_barang='MTCN-XLXB-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-18-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 ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260904-0002','29','MTCN-XLXB-30-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.330' WHERE kode_barang='MTCN-XLXB-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.340,berat_hancur_asli=berat_hancur_asli+5.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260904-0002','30','MTCN-XLXB-29-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','2.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.320' WHERE kode_barang='MTCN-XLXB-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.330,berat_hancur_asli=berat_hancur_asli+2.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260904-0002','31','MTCN-XLAX-1-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.530' WHERE kode_barang='MTCN-XLAX-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLAX-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLAX-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.540,berat_hancur_asli=berat_hancur_asli+5.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLAX-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-260904-0002','32','MTCN-YAXD-25-0','TOKO','BTCNMT','CN COR BT HURUF G SHB ','1','1.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.070' WHERE kode_barang='MTCN-YAXD-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YAXD-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YAXD-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YAXD-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-260904-0002','33','MTCN-YAXD-20-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.360' WHERE kode_barang='MTCN-YAXD-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YAXD-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YAXD-20-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 ='BTCNMT' AND kode_barang='MTCN-YAXD-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-260904-0002','34','MTCN-YAXD-21-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.840' WHERE kode_barang='MTCN-YAXD-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YAXD-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YAXD-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.850,berat_hancur_asli=berat_hancur_asli+1.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YAXD-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-260904-0002','35','MTCN-XLXB-19-0','TOKO','BTCNMT','CN COR BT MK ','1','1.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.180' WHERE kode_barang='MTCN-XLXB-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.190,berat_hancur_asli=berat_hancur_asli+1.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260904-0002','36','MTCN-XKBX-2-0','TOKO','BTCNMT','CN COR BT MK ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.450' WHERE kode_barang='MTCN-XKBX-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XKBX-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XKBX-2-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 ='BTCNMT' AND kode_barang='MTCN-XKBX-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-260904-0002','37','MTCN-XLXB-25-0','TOKO','BTCNMT','CN KAWIN COR BT SHB ','1','2.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.710' WHERE kode_barang='MTCN-XLXB-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-XLXB-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-XLXB-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.720,berat_hancur_asli=berat_hancur_asli+2.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-XLXB-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-260904-0002','38','MTCN-YBBG-69-0','TOKO','BTCNMT','CN ANAK COR CAT BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.020' WHERE kode_barang='MTCN-YBBG-69-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBG-69-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBG-69-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBG-69-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','39','MTCN-YBBG-70-0','TOKO','BTCNMT','CN ANAK COR CAT BT SHB','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.990' WHERE kode_barang='MTCN-YBBG-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBG-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBG-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBG-70-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','40','MTCN-YBBH-149-0','TOKO','BTCNMT','CN COR BT MK ','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.460' WHERE kode_barang='MTCN-YBBH-149-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-149-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-149-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 ='BTCNMT' AND kode_barang='MTCN-YBBH-149-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','41','MTCN-YBBH-141-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.330' WHERE kode_barang='MTCN-YBBH-141-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-141-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-141-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.340,berat_hancur_asli=berat_hancur_asli+2.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-141-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','42','MTCN-YBBH-137-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.530' WHERE kode_barang='MTCN-YBBH-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-137-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-137-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 ='BTCNMT' AND kode_barang='MTCN-YBBH-137-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','43','MTCN-YBBH-188-0','TOKO','BTCNMT','CN CAP PLAT TDK BT SHB ','1','1.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.120' WHERE kode_barang='MTCN-YBBH-188-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-188-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-188-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.130,berat_hancur_asli=berat_hancur_asli+1.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-188-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','44','MTCN-YCXF-17-0','TOKO','BTCNMT','CN COR BT MK ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.950' WHERE kode_barang='MTCN-YCXF-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXF-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXF-17-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 ='BTCNMT' AND kode_barang='MTCN-YCXF-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-260904-0002','45','MTCN-YBBG-71-0','TOKO','BTCNMT','CN ANAK COR CAT BT SHB ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.090' WHERE kode_barang='MTCN-YBBG-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBG-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBG-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBG-71-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','46','MTCN-YBBH-139-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.320' WHERE kode_barang='MTCN-YBBH-139-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-139-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-139-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 ='BTCNMT' AND kode_barang='MTCN-YBBH-139-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','47','MTCN-YBBH-138-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.240' WHERE kode_barang='MTCN-YBBH-138-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-138-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-138-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.250,berat_hancur_asli=berat_hancur_asli+2.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-138-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','48','MTCN-YBBH-152-0','TOKO','BTCNMT','CN KAWIN COR BT MK ','1','3.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='3.140' WHERE kode_barang='MTCN-YBBH-152-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-152-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-152-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.150,berat_hancur_asli=berat_hancur_asli+3.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-152-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','49','MTCN-YCXF-15-0','TOKO','BTCNMT','CN COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.970' WHERE kode_barang='MTCN-YCXF-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXF-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXF-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.980,berat_hancur_asli=berat_hancur_asli+0.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCXF-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-260904-0002','50','MTCN-YBBH-151-0','TOKO','BTCNMT','CN COR BT MK ','1','2.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.170' WHERE kode_barang='MTCN-YBBH-151-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-151-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-151-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.180,berat_hancur_asli=berat_hancur_asli+2.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-151-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','51','MTCN-YBBH-150-0','TOKO','BTCNMT','CN COR BT MK ','1','1.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.410' WHERE kode_barang='MTCN-YBBH-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-150-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-150-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 ='BTCNMT' AND kode_barang='MTCN-YBBH-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','52','MTCN-YBBH-135-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.090' WHERE kode_barang='MTCN-YBBH-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-135-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-135-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','53','MTCN-YBBH-147-0','TOKO','BTCNMT','CN COR BT MK ','1','1.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.090' WHERE kode_barang='MTCN-YBBH-147-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-147-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-147-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.100,berat_hancur_asli=berat_hancur_asli+1.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-147-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','54','MTCN-YBBH-132-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.990' WHERE kode_barang='MTCN-YBBH-132-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-132-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-132-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-132-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','55','MTCN-YCXF-16-0','TOKO','BTCNMT','CN COR BT MK ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.890' WHERE kode_barang='MTCN-YCXF-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCXF-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCXF-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCXF-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-260904-0002','56','MTCN-YBAB-2-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.160' WHERE kode_barang='MTCN-YBAB-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBAB-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBAB-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.170,berat_hancur_asli=berat_hancur_asli+2.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBAB-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-260904-0002','57','MTCN-YBBH-134-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.040' WHERE kode_barang='MTCN-YBBH-134-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-134-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-134-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-134-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','58','MTCN-YBBH-129-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.210' WHERE kode_barang='MTCN-YBBH-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBH-129-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBH-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YBBH-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','59','MTCN-YEXE-95-0','TOKO','BTCNMT','CN ANAK COR BT AD MRH SHB ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.040' WHERE kode_barang='MTCN-YEXE-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-95-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','60','MTCN-YCBE-32-0','TOKO','BTCNMT','CN COR EROPA SHB ','1','5.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='5.640' WHERE kode_barang='MTCN-YCBE-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCBE-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCBE-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.650,berat_hancur_asli=berat_hancur_asli+5.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCBE-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','61','MTCN-YEXE-102-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.290' WHERE kode_barang='MTCN-YEXE-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-102-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-102-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-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-260904-0002','62','MTCN-YEXE-103-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.290' WHERE kode_barang='MTCN-YEXE-103-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-103-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-103-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-103-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','63','MTCN-YCAE-24-0','TOKO','BTCNMT','CN COR BT MK ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.290' WHERE kode_barang='MTCN-YCAE-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCAE-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCAE-24-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 ='BTCNMT' AND kode_barang='MTCN-YCAE-24-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','64','MTCN-YEXE-101-0','TOKO','BTCNMT','CN COR BT MK ','1','2.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.490' WHERE kode_barang='MTCN-YEXE-101-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-101-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-101-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.500,berat_hancur_asli=berat_hancur_asli+2.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-101-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','65','MTCN-YEXE-111-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.220' WHERE kode_barang='MTCN-YEXE-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-111-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-111-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-111-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','66','MTCN-YEXE-99-0','TOKO','BTCNMT','CN COR BT MK ','1','1.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.620' WHERE kode_barang='MTCN-YEXE-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-99-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-99-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','67','MTCN-YEXE-115-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.420' WHERE kode_barang='MTCN-YEXE-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-115-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-115-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.430,berat_hancur_asli=berat_hancur_asli+2.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','68','MTCN-YCAE-21-0','TOKO','BTCNMT','CN COR BT MK ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.290' WHERE kode_barang='MTCN-YCAE-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCAE-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCAE-21-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 ='BTCNMT' AND kode_barang='MTCN-YCAE-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-260904-0002','69','MTCN-YEXE-109-0','TOKO','BTCNMT','CN COR BT SHB ','1','2.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.160' WHERE kode_barang='MTCN-YEXE-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.170,berat_hancur_asli=berat_hancur_asli+2.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-109-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','70','MTCN-YEXE-96-0','TOKO','BTCNMT','CN COR BT MK ','1','1.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.110' WHERE kode_barang='MTCN-YEXE-96-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-96-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-96-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-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-260904-0002','71','MTCN-YEXE-93-0','TOKO','BTCNMT','CN ANAK COR BT MK ','1','0.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.790' WHERE kode_barang='MTCN-YEXE-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.800,berat_hancur_asli=berat_hancur_asli+0.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','72','MTCN-YCBE-26-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.450' WHERE kode_barang='MTCN-YCBE-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCBE-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCBE-26-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 ='BTCNMT' AND kode_barang='MTCN-YCBE-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-260904-0002','73','MTCN-YEXE-97-0','TOKO','BTCNMT','CN COR BT MK ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.150' WHERE kode_barang='MTCN-YEXE-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-97-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 ='BTCNMT' AND kode_barang='MTCN-YEXE-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-260904-0002','74','MTCN-YEXE-106-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.690' WHERE kode_barang='MTCN-YEXE-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YEXE-106-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YEXE-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.700,berat_hancur_asli=berat_hancur_asli+1.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YEXE-106-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','75','MTCN-YCBE-25-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.210' WHERE kode_barang='MTCN-YCBE-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YCBE-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YCBE-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YCBE-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-260904-0002','76','MTCN-YHBH-167-0','TOKO','BTCNMT','CN CAP TDK BT SHB ','1','2.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='2.660' WHERE kode_barang='MTCN-YHBH-167-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YHBH-167-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YHBH-167-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.670,berat_hancur_asli=berat_hancur_asli+2.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMT' AND kode_barang='MTCN-YHBH-167-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','77','MTCN-YFAH-103-0','TOKO','BTCNMT','CN COR BT SHB ','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='1.510' WHERE kode_barang='MTCN-YFAH-103-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YFAH-103-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YFAH-103-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 ='BTCNMT' AND kode_barang='MTCN-YFAH-103-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0002','78','MTCN-YBBG-68-0','TOKO','BTCNMT','CN ANAK COR CAT BT SHB ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 14:54:48',status_delete='0.950' WHERE kode_barang='MTCN-YBBG-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTCN-YBBG-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTCN-YBBG-68-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 ='BTCNMT' AND kode_barang='MTCN-YBBG-68-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-260904-0002','2026-09-04','admin','2026-09-04','14:54:48','admin','2026-09-04 14:54:48');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','1','MTGL-YCXG-32-0','TOKO','BTGLMT','GL KRC LBG 6 BG3 ','1','21.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='21.610' WHERE kode_barang='MTGL-YCXG-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXG-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXG-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+21.620,berat_hancur_asli=berat_hancur_asli+21.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXG-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','2','MTGL-YCBE-36-0','TOKO','BTGLMT','GL BANGKOK TMBL SMBR PTH BG3 ','1','6.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='6.690' WHERE kode_barang='MTGL-YCBE-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-36-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-36-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.700,berat_hancur_asli=berat_hancur_asli+6.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-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-260904-0003','3','MTGL-YBBH-206-0','TOKO','BTGLMT','GL BANGKOK TMBL SHB ','1','3.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.090' WHERE kode_barang='MTGL-YBBH-206-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-206-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-206-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.100,berat_hancur_asli=berat_hancur_asli+3.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-206-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','4','MTGL-YCXF-152-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','3.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.160' WHERE kode_barang='MTGL-YCXF-152-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-152-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-152-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.170,berat_hancur_asli=berat_hancur_asli+3.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-152-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','5','MTGL-YCXF-154-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','3.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.140' WHERE kode_barang='MTGL-YCXF-154-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-154-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-154-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.150,berat_hancur_asli=berat_hancur_asli+3.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-154-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','6','MTGL-YBAA-59-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','2.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.950' WHERE kode_barang='MTGL-YBAA-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBAA-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBAA-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.960,berat_hancur_asli=berat_hancur_asli+2.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBAA-59-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','7','MTGL-YCXF-135-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','4.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.820' WHERE kode_barang='MTGL-YCXF-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-135-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.830,berat_hancur_asli=berat_hancur_asli+4.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-135-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','8','MTGL-YCXD-62-0','TOKO','BTGLMT','GL PIPA BANGKOK LBG CAT BG3 ','1','9.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='9.890' WHERE kode_barang='MTGL-YCXD-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.900,berat_hancur_asli=berat_hancur_asli+9.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXD-62-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','9','MTGL-YCXD-64-0','TOKO','BTGLMT','GL PIPA BANGKOK LBG CAT BG3 ','1','12.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='12.490' WHERE kode_barang='MTGL-YCXD-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+12.500,berat_hancur_asli=berat_hancur_asli+12.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXD-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','10','MTGL-YCXE-2-0','TOKO','BTGLMT','GL COR 16CM BG3 ','1','12.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='12.440' WHERE kode_barang='MTGL-YCXE-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXE-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXE-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+12.450,berat_hancur_asli=berat_hancur_asli+12.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXE-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-260904-0003','11','MTGL-YEXE-137-0','TOKO','BTGLMT','GL HOLO SUPER DB 17CM KKT S SHB ','1','3.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.310' WHERE kode_barang='MTGL-YEXE-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXE-137-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXE-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.320,berat_hancur_asli=berat_hancur_asli+3.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXE-137-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','12','MTGL-YCXF-95-0','TOKO','BTGLMT','GL CATENA CASTELI VAR 17CM KKT PER SHB ','1','2.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.140' WHERE kode_barang='MTGL-YCXF-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-95-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 ='BTGLMT' AND kode_barang='MTGL-YCXF-95-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','13','MTGL-YCXD-35-0','TOKO','BTGLMT','GL KRC BABY PLINTIR 3 BG3 ','1','5.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='5.100' WHERE kode_barang='MTGL-YCXD-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.110,berat_hancur_asli=berat_hancur_asli+5.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXD-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-260904-0003','14','MTGL-YCXD-34-0','TOKO','BTGLMT','GL KRC BABY PLINTIR 3 BG3 ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.990' WHERE kode_barang='MTGL-YCXD-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.000,berat_hancur_asli=berat_hancur_asli+5.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXD-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-260904-0003','15','MTGL-WGBX-99-0','TOKO','BTGLMT','GL BABY CAT SHB ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.920' WHERE kode_barang='MTGL-WGBX-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WGBX-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WGBX-99-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.930,berat_hancur_asli=berat_hancur_asli+1.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WGBX-99-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','16','MTGL-YBBG-76-0','TOKO','BTGLMT','GL BABY CAT BT SHB ','1','1.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.890' WHERE kode_barang='MTGL-YBBG-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBG-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBG-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.900,berat_hancur_asli=berat_hancur_asli+1.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBG-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','17','MTGL-YBBG-74-0','TOKO','BTGLMT','GL PIPA ANAK TDK BT SHB ','1','2.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.590' WHERE kode_barang='MTGL-YBBG-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBG-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBG-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.600,berat_hancur_asli=berat_hancur_asli+2.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBG-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','18','MTGL-YCXD-29-0','TOKO','BTGLMT','GL BANGKOK ANAK TDK BT BG3 ','1','4.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.240' WHERE kode_barang='MTGL-YCXD-29-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-29-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-29-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.250,berat_hancur_asli=berat_hancur_asli+4.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXD-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-260904-0003','19','MTGL-YCXF-131-0','TOKO','BTGLMT','GL BANGKOK TALI AIR ANAK SHB ','1','2.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.600' WHERE kode_barang='MTGL-YCXF-131-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-131-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-131-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.610,berat_hancur_asli=berat_hancur_asli+2.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-131-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','20','MTGL-YBBH-204-0','TOKO','BTGLMT','GL BANGKOK TMBL ANAK SHB ','1','2.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.410' WHERE kode_barang='MTGL-YBBH-204-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-204-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-204-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.420,berat_hancur_asli=berat_hancur_asli+2.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-204-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','21','MTGL-YCXF-128-0','TOKO','BTGLMT','GL BANGKOK TALI AIR ANAK SHB ','1','2.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.520' WHERE kode_barang='MTGL-YCXF-128-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-128-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-128-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.530,berat_hancur_asli=berat_hancur_asli+2.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-128-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','22','MTGL-XJAX-1-0','TOKO','BTGLMT','GL BANGKOK ANAK TMBL SHB ','1','2.310','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.300' WHERE kode_barang='MTGL-XJAX-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XJAX-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XJAX-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.310,berat_hancur_asli=berat_hancur_asli+2.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XJAX-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-260904-0003','23','MTGL-XKXD-10-0','TOKO','BTGLMT','GL CASTELI ANAK CAT 14CM KKT PER MK ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.990' WHERE kode_barang='MTGL-XKXD-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXD-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXD-10-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 ='BTGLMT' AND kode_barang='MTGL-XKXD-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-260904-0003','24','MTGL-YBBH-191-0','TOKO','BTGLMT','GL FANCY ANAK PLAT 12CM KKT S SHB ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.920' WHERE kode_barang='MTGL-YBBH-191-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-191-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-191-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.930,berat_hancur_asli=berat_hancur_asli+1.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-191-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','25','MTGL-XCBA-107-0','TOKO','BTGLMT','GL BABY KAWAT BTR 1BEL SHB ','1','2.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.840' WHERE kode_barang='MTGL-XCBA-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBA-107-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBA-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.850,berat_hancur_asli=berat_hancur_asli+2.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XCBA-107-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','26','MTGL-XIXE-59-0','TOKO','BTGLMT','GL BABY PIPA BT SHB ','1','1.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.790' WHERE kode_barang='MTGL-XIXE-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XIXE-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XIXE-59-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 ='BTGLMT' AND kode_barang='MTGL-XIXE-59-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','27','MTGL-XKXG-133-0','TOKO','BTGLMT','GL FANCY DB MN5 1BEL 16CM KKT S SHB ','1','2.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.860' WHERE kode_barang='MTGL-XKXG-133-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-133-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-133-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.870,berat_hancur_asli=berat_hancur_asli+2.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXG-133-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','28','MTGL-XKXH-50-0','TOKO','BTGLMT','GL FANCY DB MN5 BT 1BEL 16CM KKT S SHB ','1','2.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.220' WHERE kode_barang='MTGL-XKXH-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-50-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-50-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 ='BTGLMT' AND kode_barang='MTGL-XKXH-50-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','29','MTGL-XKXD-49-0','TOKO','BTGLMT','GL ITALY ST SRT BTR BT 17CM KKT PER BLT MK ','1','3.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.290' WHERE kode_barang='MTGL-XKXD-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXD-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXD-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.300,berat_hancur_asli=berat_hancur_asli+3.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXD-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','30','MTGL-XLXC-45-0','TOKO','BTGLMT','GL VANESSA BLCHN VAR 16CM KKT PER SHB ','1','4.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.560' WHERE kode_barang='MTGL-XLXC-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XLXC-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XLXC-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.570,berat_hancur_asli=berat_hancur_asli+4.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XLXC-45-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','31','MTGL-YCXF-117-0','TOKO','BTGLMT','GL ITALY ST SRT MN VC SLP 19CM KKT PER MK','1','3.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.290' WHERE kode_barang='MTGL-YCXF-117-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-117-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-117-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.300,berat_hancur_asli=berat_hancur_asli+3.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-117-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','32','MTGL-YCXF-115-0','TOKO','BTGLMT','GL ITALY ST SRT HT TDK BT 19CM KKT PER SHB','1','3.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.070' WHERE kode_barang='MTGL-YCXF-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-115-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-115-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.080,berat_hancur_asli=berat_hancur_asli+3.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','33','MTGL-YBXC-13-0','TOKO','BTGLMT','GL BABY KAWAT CAT 1 BEL MK ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.920' WHERE kode_barang='MTGL-YBXC-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBXC-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBXC-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.930,berat_hancur_asli=berat_hancur_asli+1.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBXC-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-260904-0003','34','MTGL-YBXC-10-0','TOKO','BTGLMT','GL BABY KAWAT BTR 1 BEL SHB ','1','1.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.900' WHERE kode_barang='MTGL-YBXC-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBXC-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBXC-10-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 ='BTGLMT' AND kode_barang='MTGL-YBXC-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-260904-0003','35','MTGL-YBBG-73-0','TOKO','BTGLMT','GL BABY KAWAT SHB ','1','1.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.770' WHERE kode_barang='MTGL-YBBG-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBG-73-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBG-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.780,berat_hancur_asli=berat_hancur_asli+1.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBG-73-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','36','MTGL-YCBE-35-0','TOKO','BTGLMT','GL BABY BT SHB ','1','1.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='1.900' WHERE kode_barang='MTGL-YCBE-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-35-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 ='BTGLMT' AND kode_barang='MTGL-YCBE-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-260904-0003','37','MTGL-YCBE-64-0','TOKO','BTGLMT','GL FANCY ANAK PLAT CAT 14CM KKT S SHB ','1','2.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.120' WHERE kode_barang='MTGL-YCBE-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','38','MTGL-YDCX-76-0','TOKO','BTGLMT','GL ANAK FANCY VAR CAT MN4 13CM KKT PER UBS ','1','2.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.830' WHERE kode_barang='MTGL-YDCX-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.840,berat_hancur_asli=berat_hancur_asli+2.840, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','39','MTGL-YDCX-74-0','TOKO','BTGLMT','GL ANAK FANCY VAR POCO 1BEL 13CM KKT S SHB ','1','2.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.490' WHERE kode_barang='MTGL-YDCX-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.500,berat_hancur_asli=berat_hancur_asli+2.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','40','MTGL-YDCX-71-0','TOKO','BTGLMT','GL ANAK FANCY DB MN5 1BEL 12CM KKT S SHB ','1','2.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.960' WHERE kode_barang='MTGL-YDCX-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-71-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.970,berat_hancur_asli=berat_hancur_asli+2.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-71-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','41','MTGL-YDCX-70-0','TOKO','BTGLMT','GL ANAK MILANO ICE DB MN4 1BEL 12CM KKT S SHB ','1','2.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.540' WHERE kode_barang='MTGL-YDCX-70-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-70-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-70-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.550,berat_hancur_asli=berat_hancur_asli+2.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-70-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','42','MTGL-YDCX-75-0','TOKO','BTGLMT','GL ANAK FANCY VAR CAT MN4 13CM KKT PER UBS ','1','2.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.390' WHERE kode_barang='MTGL-YDCX-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.400,berat_hancur_asli=berat_hancur_asli+2.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','43','MTGL-YEXB-18-0','TOKO','BTGLMT','GL RANGKAIAN KERUCUT BTR 16CM KKT PER SHB ','1','4.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.470' WHERE kode_barang='MTGL-YEXB-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.480,berat_hancur_asli=berat_hancur_asli+4.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','44','MTGL-YEXB-17-0','TOKO','BTGLMT','GL RANGKAIAN BTR OVAL 16CM KKT PER SHB ','1','4.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.240' WHERE kode_barang='MTGL-YEXB-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.250,berat_hancur_asli=berat_hancur_asli+4.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','45','MTGL-YEXB-20-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.990' WHERE kode_barang='MTGL-YEXB-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.000,berat_hancur_asli=berat_hancur_asli+5.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','46','MTGL-YCBE-53-0','TOKO','BTGLMT','GL VIGARU VAR 16CM KKT PER SHB ','1','3.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.710' WHERE kode_barang='MTGL-YCBE-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-53-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.720,berat_hancur_asli=berat_hancur_asli+3.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-53-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','47','MTGL-YEXB-34-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','4.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.930' WHERE kode_barang='MTGL-YEXB-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.940,berat_hancur_asli=berat_hancur_asli+4.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','48','MTGL-YCBG-4-0','TOKO','BTGLMT','GL CATENA VAR BTR 16CM KKT PER SHB ','1','2.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='2.410' WHERE kode_barang='MTGL-YCBG-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBG-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBG-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.420,berat_hancur_asli=berat_hancur_asli+2.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBG-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-260904-0003','49','MTGL-YEXB-27-0','TOKO','BTGLMT','GL RANGKAIAN RING POCO 16CM KKT PER SHB ','1','3.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='3.800' WHERE kode_barang='MTGL-YEXB-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.810,berat_hancur_asli=berat_hancur_asli+3.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','50','MTGL-YDCX-80-0','TOKO','BTGLMT','GL BTR OVAL 16CM KKT PER SHB ','1','4.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.170' WHERE kode_barang='MTGL-YDCX-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.180,berat_hancur_asli=berat_hancur_asli+4.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-260904-0003','51','MTGL-YEXB-40-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','4.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.600' WHERE kode_barang='MTGL-YEXB-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.610,berat_hancur_asli=berat_hancur_asli+4.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','52','MTGL-YDCX-162-0','TOKO','BTGLMT','GL VANESSA VAR BT 16CM KKT PER SHB ','1','5.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='5.560' WHERE kode_barang='MTGL-YDCX-162-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-162-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-162-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.570,berat_hancur_asli=berat_hancur_asli+5.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-162-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260904-0003','53','MTGL-YEXB-36-0','TOKO','BTGLMT','GL VIGARU BTR 17CM KKT PER SHB ','1','4.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.900' WHERE kode_barang='MTGL-YEXB-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-36-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-36-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.910,berat_hancur_asli=berat_hancur_asli+4.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','54','MTGL-YEXB-6-0','TOKO','BTGLMT','GL VENUS COR BT 18CM KKT PER KH ','1','5.130','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='5.120' WHERE kode_barang='MTGL-YEXB-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.130,berat_hancur_asli=berat_hancur_asli+5.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-260904-0003','55','MTGL-YEXB-23-0','TOKO','BTGLMT','GL RANGKAIAN BMB BTR 16CM KKT PER SHB ','1','4.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-04 15:22:12',status_delete='4.540' WHERE kode_barang='MTGL-YEXB-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.550,berat_hancur_asli=berat_hancur_asli+4.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-23-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-260904-0003','2026-09-04','admin','2026-09-04','15:22:12','admin','2026-09-04 15:22:12');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260904-0005','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZFXH-16-0','GL COR FORT 16CM LC2 ','','10.210','1','100.00','11333500','0','0','0','11333500','0','0','0','11333500','2106','00030051','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFXH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.210',berat_jual_asli=berat_jual_asli+'10.210',stock_jual='1',berat_akhir=berat_akhir-'10.210',berat_akhir_asli=berat_akhir_asli-'10.210',stock_akhir='0' WHERE tanggal='2026-09-04' AND kode_barang='MDGL-ZFXH-16-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-260904-0005','2026-09-04','10.210','2026-09-04','15:48:32','PLG0019432','11333500','11333500','0','11333500','11333500','sales','2026-09-04 15:48:32','FJ-260904-0005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-04','FJ-260904-0005','2026-09-04','15:48:32','2106','11333500','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-260904-0009','D','2026-09-04','15:48:32','sales','PENJUALAN','FJ-260904-0005','121641610','11333500','132975110');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260904-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260904-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-04 ','16:29:11');