INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-29 ','08:19:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-29 ','08:31:02');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-29','136','0','18000000','136','0','18000000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-28';
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-04-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-28' 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-260429-0001','D','2026-04-29','08:31:30','BCA','SALDO AWAL','SALDO AWAL','0','2005697276','2005697276');
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-260429-0001','D','2026-04-29','08:31:30','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-29 ','08:31:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-04-29 ','08:31:51');
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-260429-0001','1','X-00009433','BELI','BELI001','LT COR JODHA SHB','1','1.460','2505000.00' ,'0.00','2505000','','2505000','2505000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-29 08:32:00' WHERE kode_barang='X-00009433' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009433' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009433' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTLT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260429-0001','2','X-00009434','BELI','BELI001','AT ITALY CAT BT SHB','1','1.430','2309000.00' ,'0.00','2309000','','2309000','7319000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-04-29 08:32:00' WHERE kode_barang='X-00009434' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009434' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009434' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.430',berat_hancur_asli=berat_hancur_asli+'1.430', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-260429-0001','adminpusat','2026-04-29','2026-04-29','08:32:00','4814000','7319000', 'adminpusat','2026-04-29 08:32:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-04-29 ','08:57:09');
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-260429-0001','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAH-73-0','GL BABY TDK BT LC2 ','','1.970','1','100.00','2265500','0','0','0','2265500','0','0','0','2265500','2501','00028316','MDGL','161000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-04-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAH-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-04-29' AND kode_barang='MDGL-ZBAH-73-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-260429-0001','2026-04-29','1.970','2026-04-29','09:34:30','PLG0018713','2265500','2265500','0','2265500','115500','sales','2026-04-29 09:34:30','FJ-260429-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-04-29','FJ-260429-0001','2026-04-29','09:34:30','2501','2265500','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-260429-0002','D','2026-04-29','09:34:30','sales','PENJUALAN','FJ-260429-0001','94855170','115500','94970670','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260429-0001','2026-04-29','2026-04-29 09:34:30','PENJUALAN : FJ-260429-0001','bca','BCA','2150000','2150000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260429-0002','D','2026-04-29','09:34:30','BCA','PENJUALAN','FJ-260429-0001','2005697276','2150000','2007847276','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','NUR HANIFAH FARADIBA');
UPDATE tt_jual_head SET dibayar_rp='115500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2150000' WHERE no_faktur_jual='FJ-260429-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260429-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260429-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260429-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-29 ','10:17:58');
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-260429-0002','sales','1',' EX ','TOKO','BTATMT','MTAT-ZBAC-5-0','AT JEPSI SLP KEMBANG MK ','','0.510','1','100.00','979500','0','0','0','979500','0','0','0','979500','2501','00028129','MTAT','230500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-04-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZBAC-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-04-29' AND kode_barang='MTAT-ZBAC-5-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-260429-0002','2026-04-29','0.510','2026-04-29','11:09:35','PLG0018714','979500','979500','0','979500','979500','sales','2026-04-29 11:09:34','FJ-260429-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-29','FJ-260429-0002','2026-04-29','11:09:35','2501','979500','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-260429-0003','D','2026-04-29','11:09:35','sales','PENJUALAN','FJ-260429-0002','94970670','979500','95950170');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260429-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260429-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260429-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-00009435','X-00009435','GL BABY PLINTIR 2 BEL SHB','GR','---','MSGL','BELI','BELI001','2887500','2026-04-29','2.920','1','sales','2026-04-29 11:17:43');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MSGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MSGL','X-00009435','X-00009435');
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-260429-0001','FJ-251110-0009','2402','1','BELI','BELI001','MSGL', 'X-00009435', 'GL BABY PLINTIR 2 BEL SHB','2.920','2.920','100.00','2876500','2887500','988870','1','2887500','2887500','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-04-29','BELI','BELI001','MSGL','MSGL','100.00','2.920','2.920','1','2.920','2.920','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260429-0001','2026-04-29','2026-04-29','11:17:43','2402','---','2.920','2887500','2887500','2887500','2887500','2887500','sales','2026-04-29 11:17:43','FB-260429-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260429-0001','ROBBIATUL','IRAWATI 3/1B','','','083854358100','sales','2026-04-29 11:17:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-29' 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-260429-0004','K','2026-04-29','11:17:43','sales','PEMBELIAN UMUM','FB-260429-0001','95950170','2887500','93062670','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260429-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260429-0001';
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-00009436','X-00009436','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','781000','2026-04-29','0.790','1','sales','2026-04-29 11:20:12');
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-00009436','X-00009436');
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-260429-0002','FJ-260417-0006','2105','1','BELI','BELI001','MDCN', 'X-00009436', 'CN COR TDK BT SHB','0.790','0.790','100.00','932500','781000','988608','1','781000','781000','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-04-29','BELI','BELI001','MDCN','MDCN','100.00','0.790','0.790','1','0.790','0.790','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-260429-0002','2026-04-29','2026-04-29','11:20:11','2105','---','0.790','781000','781000','781000','781000','781000','sales','2026-04-29 11:20:12','FB-260429-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260429-0002','HJ. MISNATI','JL TANAH MERAH 34','','','','sales','2026-04-29 11:20:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-29' 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-260429-0005','K','2026-04-29','11:20:11','sales','PEMBELIAN UMUM','FB-260429-0002','93062670','781000','92281670','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260429-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260429-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-29 ','12:09:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-04-29 ','13:09:57');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','1','MTGL-XCBC-59-0','TOKO','BTGLMT','GL BANGKOK LBG SHB ','1','23.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='23.370' WHERE kode_barang='MTGL-XCBC-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBC-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBC-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+23.380,berat_hancur_asli=berat_hancur_asli+23.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XCBC-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-260429-0002','2','MTGL-WGBX-113-0','TOKO','BTGLMT','GL PIPA LBG SHB SHB ','1','19.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='19.060' WHERE kode_barang='MTGL-WGBX-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WGBX-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WGBX-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.070,berat_hancur_asli=berat_hancur_asli+19.070, 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-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','3','MTGL-UDAG-8-0','TOKO','BTGLMT','GL BANGKOK LUBANG SHB ','1','20.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='20.380' WHERE kode_barang='MTGL-UDAG-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-UDAG-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-UDAG-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.390,berat_hancur_asli=berat_hancur_asli+20.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-UDAG-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','4','MTGL-WBBD-123-0','TOKO','BTGLMT','GL BANGKOK LBG SHB ','1','25.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='25.400' WHERE kode_barang='MTGL-WBBD-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBD-123-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBD-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+25.410,berat_hancur_asli=berat_hancur_asli+25.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBBD-123-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','5','MTGL-XBAE-27-0','TOKO','BTGLMT','GL BANGKOK PLAT SHB ','1','14.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='14.910' WHERE kode_barang='MTGL-XBAE-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XBAE-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XBAE-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+14.920,berat_hancur_asli=berat_hancur_asli+14.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XBAE-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-260429-0002','6','MTGL-WGBX-110-0','TOKO','BTGLMT','GL PIPA TDK BT SHB ','1','10.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.710' WHERE kode_barang='MTGL-WGBX-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WGBX-110-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WGBX-110-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.720,berat_hancur_asli=berat_hancur_asli+10.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-WGBX-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-260429-0002','7','MTGL-XABD-51-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SMBR PTH BG3 ','1','14.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='14.110' WHERE kode_barang='MTGL-XABD-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XABD-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XABD-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+14.120,berat_hancur_asli=berat_hancur_asli+14.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XABD-51-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','8','MTGL-WBBB-59-0','TOKO','BTGLMT','GL BANGKOK TMBL SMBR PTH BG3 ','1','8.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='8.770' WHERE kode_barang='MTGL-WBBB-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.780,berat_hancur_asli=berat_hancur_asli+8.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-WBBB-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-260429-0002','9','MTGL-WCBH-142-0','TOKO','BTGLMT','GL BANGKOK TMBL SMBR PTH BG3 ','1','7.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.800' WHERE kode_barang='MTGL-WCBH-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-142-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-142-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.810,berat_hancur_asli=berat_hancur_asli+7.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-WCBH-142-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','10','MTGL-WBXC-64-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','5.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.100' WHERE kode_barang='MTGL-WBXC-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBXC-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBXC-64-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-WBXC-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-260429-0002','11','MTGL-WBBB-60-0','TOKO','BTGLMT','GL BANGKOK TMBL SMBR PTH MTJ ','1','11.890','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='11.880' WHERE kode_barang='MTGL-WBBB-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.890,berat_hancur_asli=berat_hancur_asli+11.890, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBBB-60-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','12','MTGL-WABX-68-0','TOKO','BTGLMT','GL BANGKOK TMBL SHB ','1','5.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.000' WHERE kode_barang='MTGL-WABX-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WABX-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WABX-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.010,berat_hancur_asli=berat_hancur_asli+5.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WABX-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-260429-0002','13','MTGL-WBBB-58-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SMBR PTH A ','1','10.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.080' WHERE kode_barang='MTGL-WBBB-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.090,berat_hancur_asli=berat_hancur_asli+10.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBBB-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-260429-0002','14','MTGL-WBBB-57-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SMBR PTH BG3 ','1','9.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='9.830' WHERE kode_barang='MTGL-WBBB-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.840,berat_hancur_asli=berat_hancur_asli+9.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-WBBB-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','15','MTGL-WAXI-73-0','TOKO','BTGLMT','GL BANGKOK TMBL SHB ','1','5.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.190' WHERE kode_barang='MTGL-WAXI-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WAXI-73-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WAXI-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.200,berat_hancur_asli=berat_hancur_asli+5.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WAXI-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-260429-0002','16','MTGL-WBBB-52-0','TOKO','BTGLMT','GL BANGKOK TALI AIR UBS ','1','5.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.060' WHERE kode_barang='MTGL-WBBB-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.070,berat_hancur_asli=berat_hancur_asli+5.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBBB-52-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','17','MTGL-XDXD-37-0','TOKO','BTGLMT','GL PIPA VAR 3WRN BL PSR UBS ','1','10.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.110' WHERE kode_barang='MTGL-XDXD-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XDXD-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XDXD-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.120,berat_hancur_asli=berat_hancur_asli+10.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XDXD-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-260429-0002','18','MTGL-XACA-125-0','TOKO','BTGLMT','GL EG BANGLE 4M UBS ','1','8.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='8.370' WHERE kode_barang='MTGL-XACA-125-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-125-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-125-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.380,berat_hancur_asli=berat_hancur_asli+8.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XACA-125-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','19','MTGL-WJXC-5-0','TOKO','BTGLMT','GL PIPA BT SMBR PTH KH ','1','6.680','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.670' WHERE kode_barang='MTGL-WJXC-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WJXC-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WJXC-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.680,berat_hancur_asli=berat_hancur_asli+6.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WJXC-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','20','MTGL-WEAX-92-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','6.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.200' WHERE kode_barang='MTGL-WEAX-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEAX-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEAX-92-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.210,berat_hancur_asli=berat_hancur_asli+6.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WEAX-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-260429-0002','21','MTGL-VFAF-48-0','TOKO','BTGLMT','GL KERONCONG PLINTIR ANAK 6 SHB ','1','12.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='12.030' WHERE kode_barang='MTGL-VFAF-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-VFAF-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-VFAF-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+12.040,berat_hancur_asli=berat_hancur_asli+12.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-VFAF-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','22','MTGL-WLAF-23-0','TOKO','BTGLMT','GL RANTAI LEBAR 15CM BG ','1','24.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='24.640' WHERE kode_barang='MTGL-WLAF-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAF-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAF-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+24.650,berat_hancur_asli=berat_hancur_asli+24.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WLAF-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-260429-0002','23','MTGL-WEXF-2-0','TOKO','BTGLMT','GL RANGAKAIAN COR 17CM UBS','1','33.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='33.440' WHERE kode_barang='MTGL-WEXF-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEXF-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEXF-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+33.450,berat_hancur_asli=berat_hancur_asli+33.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-WEXF-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-260429-0002','24','MTGL-XCBC-48-0','TOKO','BTGLMT','GL CATENA VAR 16CM KKT PER SHB ','1','2.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.830' WHERE kode_barang='MTGL-XCBC-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBC-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBC-48-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-XCBC-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','25','MTGL-XKXH-72-0','TOKO','BTGLMT','GL RANGKAIAN COR 17CM KKT PER SHB ','1','6.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.110' WHERE kode_barang='MTGL-XKXH-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-72-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.120,berat_hancur_asli=berat_hancur_asli+6.120, 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-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','26','MTGL-XCBC-50-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER SHB ','1','4.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.260' WHERE kode_barang='MTGL-XCBC-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBC-50-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBC-50-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.270,berat_hancur_asli=berat_hancur_asli+4.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XCBC-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-260429-0002','27','MTGL-WCBH-155-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SMBR PTH TL ','1','8.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='8.930' WHERE kode_barang='MTGL-WCBH-155-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-155-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-155-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.940,berat_hancur_asli=berat_hancur_asli+8.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-WCBH-155-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','28','MTGL-WDAE-137-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','3.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.700' WHERE kode_barang='MTGL-WDAE-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WDAE-137-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WDAE-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.710,berat_hancur_asli=berat_hancur_asli+3.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WDAE-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-260429-0002','29','MTGL-WLAE-34-0','TOKO','BTGLMT','GL PIPA BT MK ','1','11.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='11.610' WHERE kode_barang='MTGL-WLAE-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAE-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAE-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.620,berat_hancur_asli=berat_hancur_asli+11.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-WLAE-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-260429-0002','30','MTGL-WEAX-94-0','TOKO','BTGLMT','GL PIPA BT HWT ','1','11.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='11.620' WHERE kode_barang='MTGL-WEAX-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEAX-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEAX-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.630,berat_hancur_asli=berat_hancur_asli+11.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WEAX-94-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','31','MTGL-WACX-218-0','TOKO','BTGLMT','GL PIPA BT AD MERAH SHB ','1','5.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.930' WHERE kode_barang='MTGL-WACX-218-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WACX-218-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WACX-218-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.940,berat_hancur_asli=berat_hancur_asli+5.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-WACX-218-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','32','MTGL-WCBH-131-0','TOKO','BTGLMT','GL PIPA BT SMBR PTH HWT ','1','10.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.000' WHERE kode_barang='MTGL-WCBH-131-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-131-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-131-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.010,berat_hancur_asli=berat_hancur_asli+10.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WCBH-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-260429-0002','33','MTGL-UDAX-142-0','TOKO','BTGLMT','GL PIPA COR BT SHB','1','10.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.580' WHERE kode_barang='MTGL-UDAX-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-UDAX-142-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-UDAX-142-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.580,berat_hancur_asli=berat_hancur_asli+10.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-UDAX-142-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','34','MTGL-WEAX-93-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','9.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='9.350' WHERE kode_barang='MTGL-WEAX-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEAX-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEAX-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.360,berat_hancur_asli=berat_hancur_asli+9.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WEAX-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-260429-0002','35','MTGL-WBAG-72-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','5.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.150' WHERE kode_barang='MTGL-WBAG-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBAG-72-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBAG-72-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 ='BTGLMT' AND kode_barang='MTGL-WBAG-72-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','36','MTGL-XABD-47-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','4.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.790' WHERE kode_barang='MTGL-XABD-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XABD-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XABD-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.800,berat_hancur_asli=berat_hancur_asli+4.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-XABD-47-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','37','MTGL-VLAG-7-0','TOKO','BTGLMT','GL PIPA TDK BT SHB ','1','4.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.050' WHERE kode_barang='MTGL-VLAG-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-VLAG-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-VLAG-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.060,berat_hancur_asli=berat_hancur_asli+4.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-VLAG-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-260429-0002','38','MTGL-WHAE-80-0','TOKO','BTGLMT','GL CARA BTG ','1','6.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.480' WHERE kode_barang='MTGL-WHAE-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WHAE-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WHAE-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.490,berat_hancur_asli=berat_hancur_asli+6.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WHAE-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-260429-0002','39','MTGL-WBBB-51-0','TOKO','BTGLMT','GL PIPA BT AD MERAH SHB','1','6.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.280' WHERE kode_barang='MTGL-WBBB-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.290,berat_hancur_asli=berat_hancur_asli+6.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBBB-51-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','40','MTGL-WACX-211-0','TOKO','BTGLMT','GL PIPA BT SHB','1','5.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.150' WHERE kode_barang='MTGL-WACX-211-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WACX-211-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WACX-211-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 ='BTGLMT' AND kode_barang='MTGL-WACX-211-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','41','MTGL-WHAE-79-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','4.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.750' WHERE kode_barang='MTGL-WHAE-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WHAE-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WHAE-79-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.760,berat_hancur_asli=berat_hancur_asli+4.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WHAE-79-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','42','MTGL-UDAX-136-0','TOKO','BTGLMT','GL PIPA COR BT SHB','1','10.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.190' WHERE kode_barang='MTGL-UDAX-136-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-UDAX-136-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-UDAX-136-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.200,berat_hancur_asli=berat_hancur_asli+10.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-UDAX-136-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','43','MTGL-WGBX-106-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','12.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='12.020' WHERE kode_barang='MTGL-WGBX-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WGBX-106-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WGBX-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+12.030,berat_hancur_asli=berat_hancur_asli+12.030, 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-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-260429-0002','44','MTGL-WACX-193-0','TOKO','BTGLMT','GL PIPA BT SHB','1','10.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.510' WHERE kode_barang='MTGL-WACX-193-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WACX-193-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WACX-193-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.520,berat_hancur_asli=berat_hancur_asli+10.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WACX-193-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','45','MTGL-VKAX-34-0','TOKO','BTGLMT','GL PIPA BT UBS ','1','10.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='10.070' WHERE kode_barang='MTGL-VKAX-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-VKAX-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-VKAX-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.080,berat_hancur_asli=berat_hancur_asli+10.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-VKAX-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-260429-0002','46','MTGL-WACX-200-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','3.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.650' WHERE kode_barang='MTGL-WACX-200-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WACX-200-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WACX-200-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.660,berat_hancur_asli=berat_hancur_asli+3.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WACX-200-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','47','MTGL-WCBH-123-0','TOKO','BTGLMT','GL PIPA BT SMBR PTH UBS ','1','5.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.820' WHERE kode_barang='MTGL-WCBH-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-123-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.830,berat_hancur_asli=berat_hancur_asli+5.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-WCBH-123-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','48','MTGL-WCBH-122-0','TOKO','BTGLMT','GL PIPA BT CAT SHB ','1','5.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.870' WHERE kode_barang='MTGL-WCBH-122-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-122-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-122-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.880,berat_hancur_asli=berat_hancur_asli+5.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WCBH-122-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','49','MTGL-WKBA-78-0','TOKO','BTGLMT','GL CARA BTG ','1','6.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.380' WHERE kode_barang='MTGL-WKBA-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WKBA-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WKBA-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.390,berat_hancur_asli=berat_hancur_asli+6.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WKBA-78-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','50','MTGL-WCBH-157-0','TOKO','BTGLMT','GL PIPA PLINTIR SMBR PTH TL ','1','7.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.610' WHERE kode_barang='MTGL-WCBH-157-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-157-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-157-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.620,berat_hancur_asli=berat_hancur_asli+7.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-WCBH-157-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','51','MTGL-WLAE-33-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','4.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.490' WHERE kode_barang='MTGL-WLAE-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAE-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAE-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.500,berat_hancur_asli=berat_hancur_asli+4.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-WLAE-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','52','MTGL-WCBH-156-0','TOKO','BTGLMT','GL PIPA KEPANG SMBR PTH TL ','1','7.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.340' WHERE kode_barang='MTGL-WCBH-156-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WCBH-156-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WCBH-156-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.350,berat_hancur_asli=berat_hancur_asli+7.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WCBH-156-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','53','MTGL-WLAE-35-0','TOKO','BTGLMT','GL PIPA BT MK ','1','19.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='19.040' WHERE kode_barang='MTGL-WLAE-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAE-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAE-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.050,berat_hancur_asli=berat_hancur_asli+19.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WLAE-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-260429-0002','54','MTGL-WIAE-48-0','TOKO','BTGLMT','GL PIPA BT YT ','1','2.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.900' WHERE kode_barang='MTGL-WIAE-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WIAE-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WIAE-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.910,berat_hancur_asli=berat_hancur_asli+2.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WIAE-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','55','MTGL-WLAE-32-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','3.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.620' WHERE kode_barang='MTGL-WLAE-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAE-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAE-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.630,berat_hancur_asli=berat_hancur_asli+3.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WLAE-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-260429-0002','56','MTGL-WBAG-86-0','TOKO','BTGLMT','GL PIPA COR KRW BT SHB ','1','16.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='16.400' WHERE kode_barang='MTGL-WBAG-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBAG-86-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBAG-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+16.410,berat_hancur_asli=berat_hancur_asli+16.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WBAG-86-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','57','MTGL-XACA-117-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','3.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.820' WHERE kode_barang='MTGL-XACA-117-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-117-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-117-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.830,berat_hancur_asli=berat_hancur_asli+3.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-XACA-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-260429-0002','58','MTGL-WBBB-46-0','TOKO','BTGLMT','GL PIPA BT KH ','1','11.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='11.490' WHERE kode_barang='MTGL-WBBB-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.500,berat_hancur_asli=berat_hancur_asli+11.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-WBBB-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','59','MTGL-WEAB-63-0','TOKO','BTGLMT','GL ALEXA LL ','1','6.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.140' WHERE kode_barang='MTGL-WEAB-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEAB-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEAB-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.150,berat_hancur_asli=berat_hancur_asli+6.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-WEAB-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','60','MTGL-WJAB-87-0','TOKO','BTGLMT','GL BABY BANGKOK TMBL MK ','1','2.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.260' WHERE kode_barang='MTGL-WJAB-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WJAB-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WJAB-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.270,berat_hancur_asli=berat_hancur_asli+2.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WJAB-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','61','MTGL-WFXC-78-0','TOKO','BTGLMT','GL ANAK PIPA BTR SHB ','1','2.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.290' WHERE kode_barang='MTGL-WFXC-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WFXC-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WFXC-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.300,berat_hancur_asli=berat_hancur_asli+2.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WFXC-78-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','62','MTGL-XCBA-109-0','TOKO','BTGLMT','GL PIPA ANAK BTR SHB ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.250' WHERE kode_barang='MTGL-XCBA-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBA-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBA-109-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.260,berat_hancur_asli=berat_hancur_asli+2.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XCBA-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-260429-0002','63','MTGL-XCAD-33-0','TOKO','BTGLMT','GL BABY PIPA CAT BT UBS ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.930' WHERE kode_barang='MTGL-XCAD-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCAD-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCAD-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XCAD-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','64','MTGL-VJXF-87-0','TOKO','BTGLMT','GL ANAK PIPA BTR SHB ','1','2.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.330' WHERE kode_barang='MTGL-VJXF-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-VJXF-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-VJXF-87-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 ='BTGLMT' AND kode_barang='MTGL-VJXF-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','65','MTGL-XDBD-10-0','TOKO','BTGLMT','GL ANAK PIPA CAT UBS ','1','3.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.590' WHERE kode_barang='MTGL-XDBD-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XDBD-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XDBD-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.600,berat_hancur_asli=berat_hancur_asli+3.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-XDBD-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-260429-0002','66','MTGL-UDAX-162-0','TOKO','BTGLMT','GL BABY CAT SHB','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.000' WHERE kode_barang='MTGL-UDAX-162-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-UDAX-162-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-UDAX-162-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.000,berat_hancur_asli=berat_hancur_asli+3.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-UDAX-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-260429-0002','67','MTGL-WKBA-76-0','TOKO','BTGLMT','GL ANAK BANGKOK TMBL MK ','1','2.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.370' WHERE kode_barang='MTGL-WKBA-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WKBA-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WKBA-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.380,berat_hancur_asli=berat_hancur_asli+2.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WKBA-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-260429-0002','68','MTGL-XLAF-2-0','TOKO','BTGLMT','GL RANGKAIAN 18CM KKT PER SHB ','1','8.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='8.130' WHERE kode_barang='MTGL-XLAF-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XLAF-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XLAF-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.140,berat_hancur_asli=berat_hancur_asli+8.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XLAF-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-260429-0002','69','MTGL-VGAB-6-0','TOKO','BTGLMT','GL KEPANG SMBR PTH 17CM YT ','1','19.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='19.630' WHERE kode_barang='MTGL-VGAB-6-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-VGAB-6-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-VGAB-6-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.640,berat_hancur_asli=berat_hancur_asli+19.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-VGAB-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-260429-0002','70','MTGL-WLAE-27-0','TOKO','BTGLMT','GL KEPANG SMBR PTH 17CM YT ','1','20.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='19.990' WHERE kode_barang='MTGL-WLAE-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WLAE-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WLAE-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.000,berat_hancur_asli=berat_hancur_asli+20.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-WLAE-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-260429-0002','71','MTGL-WHAE-68-0','TOKO','BTGLMT','GL CATENA DOUBLE VAR BT 18CM KKT S SHB ','1','3.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.460' WHERE kode_barang='MTGL-WHAE-68-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WHAE-68-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WHAE-68-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.470,berat_hancur_asli=berat_hancur_asli+3.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WHAE-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-260429-0002','72','MTGL-WEAX-83-0','TOKO','BTGLMT','GL HL SUPER PLAT BT 17CM KKT PER SHB ','1','7.570','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.560' WHERE kode_barang='MTGL-WEAX-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WEAX-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WEAX-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.570,berat_hancur_asli=berat_hancur_asli+7.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-WEAX-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','73','MTGL-WBBB-38-0','TOKO','BTGLMT','GL HL RANTAI COR BT 17CM SHB','1','7.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.090' WHERE kode_barang='MTGL-WBBB-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WBBB-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WBBB-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.100,berat_hancur_asli=berat_hancur_asli+7.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-WBBB-38-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','74','MTGL-XKXH-43-0','TOKO','BTGLMT','GL CATENA DOUBLE VAR BT AD MERAH 17CM KKT S SHB ','1','3.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.340' WHERE kode_barang='MTGL-XKXH-43-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-43-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-43-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.350,berat_hancur_asli=berat_hancur_asli+3.350, 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-43-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','75','MTGL-XKXH-18-0','TOKO','BTGLMT','GL RANGKAIAN BTR HT 17CM KKT PER SHB ','1','4.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.100' WHERE kode_barang='MTGL-XKXH-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.110,berat_hancur_asli=berat_hancur_asli+4.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-XKXH-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-260429-0002','76','MTGL-XKXH-51-0','TOKO','BTGLMT','GL FANCY DB MN5 17CM KKT S SHB ','1','4.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.010' WHERE kode_barang='MTGL-XKXH-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-51-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.020,berat_hancur_asli=berat_hancur_asli+4.020, 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-51-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','77','MTGL-XACA-130-0','TOKO','BTGLMT','GL VANESSA VAR HT 17CM KKT PER SHB ','1','2.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.840' WHERE kode_barang='MTGL-XACA-130-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-130-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-130-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-XACA-130-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','78','MTGL-XKXH-11-0','TOKO','BTGLMT','GL RANGKAIAN COR 18CM KKT PER PM ','1','6.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='6.310' WHERE kode_barang='MTGL-XKXH-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.320,berat_hancur_asli=berat_hancur_asli+6.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-XKXH-11-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','79','MTGL-XGAX-8-0','TOKO','BTGLMT','GL CASTELI VIGARU 16CM KKT PER SHB ','1','1.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='1.660' WHERE kode_barang='MTGL-XGAX-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XGAX-8-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XGAX-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.670,berat_hancur_asli=berat_hancur_asli+1.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XGAX-8-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','80','MTGL-XKXH-45-0','TOKO','BTGLMT','GL MILANO DB MN 2 16CM KKT S SHB ','1','2.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.650' WHERE kode_barang='MTGL-XKXH-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.660,berat_hancur_asli=berat_hancur_asli+2.660, 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-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-260429-0002','81','MTGL-XKXG-139-0','TOKO','BTGLMT','GL GUCCI BTR VAR 17CM KKT PER SHB ','1','3.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.830' WHERE kode_barang='MTGL-XKXG-139-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-139-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-139-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.840,berat_hancur_asli=berat_hancur_asli+3.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-XKXG-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-260429-0002','82','MTGL-XGCA-54-0','TOKO','BTGLMT','GL VANESSA VAR BT BTR 16CM KKT PER SHB ','1','5.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.160' WHERE kode_barang='MTGL-XGCA-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XGCA-54-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XGCA-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.170,berat_hancur_asli=berat_hancur_asli+5.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-XGCA-54-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','83','MTGL-XKXG-126-0','TOKO','BTGLMT','GL MOCCA VIGARU DB MN 2 17CM KKT PER SHB','1','2.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.340' WHERE kode_barang='MTGL-XKXG-126-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-126-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-126-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.350,berat_hancur_asli=berat_hancur_asli+2.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXG-126-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','84','MTGL-YCAD-48-0','TOKO','BTGLMT','GL CATENA MN BL 5 CAT 16CM KKT PER UBS ','1','7.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='7.810' WHERE kode_barang='MTGL-YCAD-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.820,berat_hancur_asli=berat_hancur_asli+7.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAD-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','85','MTGL-XKXH-49-0','TOKO','BTGLMT','GL MOCCA VIGARU MN 2 16CM KKT PER SHB ','1','2.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.340' WHERE kode_barang='MTGL-XKXH-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.350,berat_hancur_asli=berat_hancur_asli+2.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-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-260429-0002','86','MTGL-YJCX-40-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER MK ','1','5.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.160' WHERE kode_barang='MTGL-YJCX-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YJCX-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YJCX-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.170,berat_hancur_asli=berat_hancur_asli+5.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-YJCX-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-260429-0002','87','MTGL-XKXG-161-0','TOKO','BTGLMT','GL VANESSA VAR MN DOLLAR 3 16CM KKT PER SHB ','1','5.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.420' WHERE kode_barang='MTGL-XKXG-161-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-161-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-161-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.430,berat_hancur_asli=berat_hancur_asli+5.430, 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-161-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','88','MTGL-XKXH-47-0','TOKO','BTGLMT','GL ITALY KC MN 4 17CM KKT S SHB ','1','3.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.030' WHERE kode_barang='MTGL-XKXH-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.040,berat_hancur_asli=berat_hancur_asli+3.040, 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-47-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','89','MTGL-XKXH-10-0','TOKO','BTGLMT','GL VENUS VAR BT 18CM KKT PER KH ','1','5.240','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.230' WHERE kode_barang='MTGL-XKXH-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.240,berat_hancur_asli=berat_hancur_asli+5.240, 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-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-260429-0002','90','MTGL-XKXH-15-0','TOKO','BTGLMT','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','5.840','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='5.830' WHERE kode_barang='MTGL-XKXH-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.840,berat_hancur_asli=berat_hancur_asli+5.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-XKXH-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-260429-0002','91','MTGL-XKXG-125-0','TOKO','BTGLMT','GL MOCCA DB MN 5 17CM KKT S SHB','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.000' WHERE kode_barang='MTGL-XKXG-125-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-125-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-125-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXG-125-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','92','MTGL-XKXG-163-0','TOKO','BTGLMT','GL VANESSA VAR BL CN BT 17CM KKT PER MK','1','2.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.780' WHERE kode_barang='MTGL-XKXG-163-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-163-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-163-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.790,berat_hancur_asli=berat_hancur_asli+2.790, 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-163-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','93','MTGL-XACA-135-0','TOKO','BTGLMT','GL VANESSA VAR HT BTR 17CM KKT PER SHB ','1','3.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.490' WHERE kode_barang='MTGL-XACA-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-135-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.500,berat_hancur_asli=berat_hancur_asli+3.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-XACA-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-260429-0002','94','MTGL-XACA-160-0','TOKO','BTGLMT','GL ITALY VAR BTR 17CM KKT PER SHB ','1','3.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.380' WHERE kode_barang='MTGL-XACA-160-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-160-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-160-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.390,berat_hancur_asli=berat_hancur_asli+3.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XACA-160-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','95','MTGL-XKXH-46-0','TOKO','BTGLMT','GL MILANO DB MN 4 16CM KKT S SHB ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.020' WHERE kode_barang='MTGL-XKXH-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','96','MTGL-XKXG-143-0','TOKO','BTGLMT','GL CATENA DB MN5 17CM KKT PER BLT MK','1','2.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.010' WHERE kode_barang='MTGL-XKXG-143-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-143-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-143-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.020,berat_hancur_asli=berat_hancur_asli+2.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXG-143-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','97','MTGL-XKXG-144-0','TOKO','BTGLMT','GL ITALY BTR 16CM KKT PER SHB','1','3.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.320' WHERE kode_barang='MTGL-XKXG-144-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-144-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-144-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.330,berat_hancur_asli=berat_hancur_asli+3.330, 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-144-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','98','MTGL-XKXH-41-0','TOKO','BTGLMT','GL CAP HOLO MN 4 17CM KKT S SHB ','1','4.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='4.810' WHERE kode_barang='MTGL-XKXH-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.820,berat_hancur_asli=berat_hancur_asli+4.820, 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-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-260429-0002','99','MTGL-XACA-146-0','TOKO','BTGLMT','GL VANESSA VAR DOLLAR BT DSC 17CM KKT PER SHB ','1','3.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.200' WHERE kode_barang='MTGL-XACA-146-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-146-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-146-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.210,berat_hancur_asli=berat_hancur_asli+3.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XACA-146-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','100','MTGL-WIAE-40-0','TOKO','BTGLMT','GL CATENA DOBLE BMB 16CM KKT PER SHB ','1','2.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.700' WHERE kode_barang='MTGL-WIAE-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-WIAE-40-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-WIAE-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.710,berat_hancur_asli=berat_hancur_asli+2.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-WIAE-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-260429-0002','101','MTGL-XKXG-129-0','TOKO','BTGLMT','GL FANCY BL KRW 17CM KKT S SHB','1','2.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.810' WHERE kode_barang='MTGL-XKXG-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-129-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.820,berat_hancur_asli=berat_hancur_asli+2.820, 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-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-260429-0002','102','MTGL-XAXI-59-0','TOKO','BTGLMT','GL VIGARU FANCY BTR BT 17CM KKT PER MK ','1','3.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.330' WHERE kode_barang='MTGL-XAXI-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XAXI-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XAXI-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.340,berat_hancur_asli=berat_hancur_asli+3.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XAXI-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-260429-0002','103','MTGL-XKXH-73-0','TOKO','BTGLMT','GL ITALY ST BTR MN8 16CM KKT PER BLT SHB ','1','2.190','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.180' WHERE kode_barang='MTGL-XKXH-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-73-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.190,berat_hancur_asli=berat_hancur_asli+2.190, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-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-260429-0002','104','MTGL-XKXG-132-0','TOKO','BTGLMT','GL FANCY DB MN 4 17CM KKT S SHB','1','4.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.990' WHERE kode_barang='MTGL-XKXG-132-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-132-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-132-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.000,berat_hancur_asli=berat_hancur_asli+4.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-XKXG-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-260429-0002','105','MTGL-XKXH-48-0','TOKO','BTGLMT','GL MOCCA DB MN 4 17CM KKT S SHB ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='1.730' WHERE kode_barang='MTGL-XKXH-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.740,berat_hancur_asli=berat_hancur_asli+1.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','106','MTGL-XKXG-140-0','TOKO','BTGLMT','GL CATENA BL PSR 17CM KKT PER SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='2.990' WHERE kode_barang='MTGL-XKXG-140-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXG-140-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXG-140-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.000,berat_hancur_asli=berat_hancur_asli+3.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXG-140-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260429-0002','107','MTGL-XCBA-97-0','TOKO','BTGLMT','GL VANESSA VAR 16CM KKT PER SHB ','1','3.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.360' WHERE kode_barang='MTGL-XCBA-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XCBA-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XCBA-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.370,berat_hancur_asli=berat_hancur_asli+3.370, 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-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-260429-0002','108','MTGL-XACA-145-0','TOKO','BTGLMT','GL VANESSA VAR BTR BT DSC 17CM KKT PER SHB ','1','3.090','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-04-29 13:24:50',status_delete='3.080' WHERE kode_barang='MTGL-XACA-145-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XACA-145-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XACA-145-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.090,berat_hancur_asli=berat_hancur_asli+3.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XACA-145-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-260429-0002','2026-04-29','admin','2026-04-29','13:24:50','admin','2026-04-29 13:24:50');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01758','2501','1','KL SATELIT PASIRAN KKT PER 8K LC2','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'4000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'4000000'  WHERE tanggal='2026-04-29'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01758','2026-04-29','2026-04-29','13:50:11','PLG0018715','2501','90','2026-07-28','sales','2026-04-29 13:50:10','16.450','4000000','3.00','360000','4360000','0','OPEN','22.69','1','2026-07-28','0','4360000')
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-260429-0006','K','2026-04-29','13:50:11','sales','HUTANG','PI26-01758','92281670','4000000','88281670','OPEN') 
UPDATE tt_hutang_head SET byr_harus_rp='6000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'6276000',tgl_lunas='2026-04-29',status='CLOS',total_lunas='6276000' WHERE no_hutang='PI26-01716';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'6000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'6000000'  WHERE tanggal='2026-04-29';
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-260429-0007','D','2026-04-29','13:51:27','cashier1','HUTANG LUNAS','PI26-01716','88281670','6276000','94557670');
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01758' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01758';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01665','2026-04-29', '2026-04-29','758333','492000','492000');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'492000' WHERE no_hutang='PI26-01665';
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-260429-0008','D','2026-04-29','13:52:12','cashier1','HUTANG BUNGA','PI26-01665','94557670','492000','95049670');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-04-29 ','16:48:34');