INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-13 ','08:39:25'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-13','116','0','-187400000','116','0','-187400000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-12'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-12'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-12'; 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-10-12' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-12'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-12'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-12'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-12'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-13' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-12' 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-261013-0001','D','2026-10-13','08:39:34','BCA','SALDO AWAL','SALDO AWAL','0','1369060082','1369060082'); 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-261013-0001','D','2026-10-13','08:39:34','','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-13'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-13 ','08:40:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-13 ','08:46:02'); 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-261013-0001','1','X-00009917','BELI','BELI001','GL PIPA BT SHB','1','3.840','6216500.00' ,'0.00','6216500','','6216500','6216500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-13 08:46:20' WHERE kode_barang='X-00009917' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009917' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009917' AND kode_lokasi_toko ='BELI001' LIMIT 1; 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=stock_akhir-'1', berat_akhir=berat_akhir-'3.840',berat_akhir_asli=berat_akhir_asli-'3.840' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-261013-0001','adminpusat','2026-10-13','2026-10-13','08:46:20','6216500','6216500', 'adminpusat','2026-10-13 08:46:20'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-13 ','09:18:51'); 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-00009918','X-00009918','CN PLINTIR HT SHB','GR','---','MTCN','BELI','BELI001','3173000','2026-10-13','1.960','1','sales','2026-10-13 09:20:34'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009918','X-00009918'); 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-261013-0001','FJ-220823-0009','2402','1','BELI','BELI001','MTCN', 'X-00009918', 'CN PLINTIR HT SHB','2.060','1.960','100.00','1411500','3173000','1618878','1','3173000','3173000','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-10-13','BELI','BELI001','MTCN','MTCN','100.00','1.960','1.960','1','1.960','1.960','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-261013-0001','2026-10-13','2026-10-13','09:20:34','2402','---','1.960','3173000','3173000','3173000','3173000','3173000','sales','2026-10-13 09:20:34','FB-261013-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0001','LULUK','DKH BLK BANTENG SKLHAN 4A/5','','','','sales','2026-10-13 09:20:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0002','K','2026-10-13','09:20:34','sales','PEMBELIAN UMUM','FB-261013-0001','165846086','3173000','162673086','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-13 ','09:22:04'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-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-00009919','X-00009919','CN PLINTIR SHB','GR','---','MTCN','BELI','BELI001','2902000','2026-10-13','2.030','1','sales','2026-10-13 10:05:24'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009919','X-00009919'); 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-261013-0002','FJ-251118-0008','2501','1','BELI','BELI001','MTCN', 'X-00009919', 'CN PLINTIR SHB','2.030','2.030','100.00','3512000','2902000','1429557','1','2902000','2902000','RONGSOK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261013-0002','2026-10-13','2026-10-13','10:05:23','2501','---','2.030','2902000','2902000','2902000','2902000','2902000','sales','2026-10-13 10:05:24','FB-261013-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0002','AKBAR','JL JOHAR','','','','sales','2026-10-13 10:05:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0003','K','2026-10-13','10:05:23','sales','PEMBELIAN UMUM','FB-261013-0002','162673086','2902000','159771086','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0002'; 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-261013-0001','sales','1',' ','TOKO','BTMF','MTGL-ZJXC-5-0','GL RANGKAIAN 18CM KKT PER SHB ','','5.840','1','100.00','10746000','0','0','0','10746000','0','0','0','10746000','2501','00031551','MTGL','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZJXC-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.840',berat_jual_asli=berat_jual_asli+'5.840',stock_jual='1',berat_akhir=berat_akhir-'5.840',berat_akhir_asli=berat_akhir_asli-'5.840',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='MTGL-ZJXC-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTMF' 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-261013-0001','2026-10-13','5.840','2026-10-13','10:27:28','PLG0019585','10746000','10746000','0','10746000','10746000','sales','2026-10-13 10:27:28','FJ-261013-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-10-13','FJ-261013-0001','2026-10-13','10:27:28','2501','10746000','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-261013-0004','D','2026-10-13','10:27:28','sales','PENJUALAN','FJ-261013-0001','159771086','10746000','170517086'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-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-00009920','X-00009920','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','1193000','2026-10-13','1.250','1','sales','2026-10-13 10:48:27'); 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-00009920','X-00009920'); 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-261013-0003','FJ-260627-0003','2103','1','BELI','BELI001','MDCN', 'X-00009920', 'CN COR TDK BT SHB','1.250','1.250','100.00','1394000','1193000','954400','1','1193000','1193000','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-10-13','BELI','BELI001','MDCN','MDCN','100.00','1.250','1.250','1','1.250','1.250','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-261013-0003','2026-10-13','2026-10-13','10:48:27','2103','---','1.250','1193000','1193000','1193000','1193000','1193000','sales','2026-10-13 10:48:27','FB-261013-0003','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0003','KIKI','JL. KEDONGDNG KIDUL 1/5A','','','087781283353','sales','2026-10-13 10:48:27'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0005','K','2026-10-13','10:48:27','sales','PEMBELIAN UMUM','FB-261013-0003','170517086','1193000','169324086','OPEN'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-261013-0002','sales','1',' ','TOKO','BTGWMD','MDGW-ZIAH-83-0','GW COR TDK BT LC2 ','','0.670','1','100.00','744000','0','0','0','744000','0','0','0','744000','2103','00031520','MDGW','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGW-ZIAH-83-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='MDGW-ZIAH-83-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261013-0002','2026-10-13','0.670','2026-10-13','10:50:22','PLG0019586','744000','744000','0','744000','744000','sales','2026-10-13 10:50:21','FJ-261013-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-10-13','FJ-261013-0002','2026-10-13','10:50:22','2103','744000','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-261013-0006','D','2026-10-13','10:50:22','sales','PENJUALAN','FJ-261013-0002','169324086','744000','170068086'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-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-00009921','X-00009921','GL PAJERO 17CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','2691500','2026-10-13','2.820','1','sales','2026-10-13 11:51:53'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009921','X-00009921'); 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-261013-0004','FJ-260909-0001','2106','1','BELI','BELI001','MDGL', 'X-00009921', 'GL PAJERO 17CM KKT PER SHB','2.820','2.820','100.00','3130500','2691500','954433','1','2691500','2691500','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-10-13','BELI','BELI001','MDGL','MDGL','100.00','2.820','2.820','1','2.820','2.820','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-261013-0004','2026-10-13','2026-10-13','11:51:52','2106','---','2.820','2691500','2691500','2691500','2691500','2691500','sales','2026-10-13 11:51:53','FB-261013-0004','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0004','FIA','JL.SUMBO NO 52','','','082329778936','sales','2026-10-13 11:51:53'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0007','K','2026-10-13','11:51:52','sales','PEMBELIAN UMUM','FB-261013-0004','170068086','2691500','167376586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0004'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-13 ','13:08:17'); INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01644','2026-10-13', '2026-10-13','332400','51000','332500'); UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'51000' WHERE no_hutang='PI26-01644'; 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-261013-0008','D','2026-10-13','13:46:20','cashier1','HUTANG BUNGA','PI26-01644','167376586','51000','167427586'); 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-261013-0003','cashier1','1',' ','TOKO','BTGWMT','MTGW-ZDBH-130-0','GW COR BT SHB ','','1.500','1','100.00','2760000','0','0','0','2760000','0','0','0','2760000','2105','00029363','MTGW','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGW-ZDBH-130-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='MTGW-ZDBH-130-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMT' 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-261013-0003','2026-10-13','1.500','2026-10-13','14:22:04','PLG0019587','2760000','2760000','0','2760000','2760000','cashier1','2026-10-13 14:22:03','FJ-261013-0003'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0003','2026-10-13','14:22:04','2105','2760000','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-261013-0009','D','2026-10-13','14:22:04','cashier1','PENJUALAN','FJ-261013-0003','167427586','2760000','170187586'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-13 ','14:53:07'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-13 ','15:49:51'); 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-00009922','X-00009922','GL BABY CAT TDK BT SHB','GR','---','MTGL','BELI','BELI001','2674000','2026-10-13','1.870','1','sales','2026-10-13 16:03:46'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009922','X-00009922'); 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-261013-0005','FJ-260207-0007','2105','1','BELI','BELI001','MTGL', 'X-00009922', 'GL BABY CAT TDK BT SHB','1.920','1.870','100.00','4090000','2674000','1429947','1','2674000','2674000','RONGSOK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.870',berat_beli_asli=berat_beli_asli+'1.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.870',berat_akhir_asli=berat_akhir_asli+'1.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-261013-0005','2026-10-13','2026-10-13','16:03:45','2105','---','1.870','2674000','2674000','2674000','2674000','2674000','sales','2026-10-13 16:03:46','FB-261013-0005','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0005','ECHA','JL. PENCINDLAN TRATAI 1A/15','','','','sales','2026-10-13 16:03:46'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0010','K','2026-10-13','16:03:45','sales','PEMBELIAN UMUM','FB-261013-0005','170187586','2674000','167513586','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0005'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-10-13 ','16:09:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-13 ','16:28:37'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','1','MTGL-XLXB-55-0','TOKO','BTGLMT','GL PIPA VENUS WRN UBS ','1','10.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='10.350' WHERE kode_barang='MTGL-XLXB-55-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XLXB-55-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-XLXB-55-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.360,berat_hancur_asli=berat_hancur_asli+10.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-XLXB-55-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','2','MTGL-YCXD-40-0','TOKO','BTGLMT','GL PIPA KRC 6 BG3 ','1','24.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='24.350' WHERE kode_barang='MTGL-YCXD-40-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXD-40-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXD-40-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+24.360,berat_hancur_asli=berat_hancur_asli+24.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-YCXD-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-261013-0002','3','MTGL-YBBH-210-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','5.570','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.560' WHERE kode_barang='MTGL-YBBH-210-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-210-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-210-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.570,berat_hancur_asli=berat_hancur_asli+5.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-210-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','4','MTGL-YCXF-126-0','TOKO','BTGLMT','GL BANGKOK TALI AIR ANAK SHB ','1','2.510','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.500' WHERE kode_barang='MTGL-YCXF-126-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-126-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-126-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.510,berat_hancur_asli=berat_hancur_asli+2.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-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-261013-0002','5','MTGL-YEXE-142-0','TOKO','BTGLMT','GL ANAK BANGKOK TALI AIR SHB ','1','2.380','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.370' WHERE kode_barang='MTGL-YEXE-142-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXE-142-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXE-142-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-YEXE-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-261013-0002','6','MTGL-YCAD-40-0','TOKO','BTGLMT','GL KEPANG 3WRN KKT PER UBS ','1','4.630','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.620' WHERE kode_barang='MTGL-YCAD-40-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-40-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-40-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.630,berat_hancur_asli=berat_hancur_asli+4.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-YCAD-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-261013-0002','7','MTGL-YABH-52-0','TOKO','BTGLMT','GL KK FANCY VAR MN9 BT 27CM KKT S SHB ','1','4.820','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.810' WHERE kode_barang='MTGL-YABH-52-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YABH-52-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YABH-52-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-YABH-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-261013-0002','8','MTGL-YCXF-92-0','TOKO','BTGLMT','GL CATENA FANCY VAR 17CM KKT PER MK ','1','1.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.950' WHERE kode_barang='MTGL-YCXF-92-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-92-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-92-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-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-261013-0002','9','MTGL-YDCX-130-0','TOKO','BTGLMT','GL CATENA VAR BMB 16CM KKT PER SHB ','1','2.740','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.730' WHERE kode_barang='MTGL-YDCX-130-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-130-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-130-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.740,berat_hancur_asli=berat_hancur_asli+2.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-YDCX-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-261013-0002','10','MTGL-YCAD-67-0','TOKO','BTGLMT','GL LAYER 17CM KKT PER SHB ','1','2.470','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.460' WHERE kode_barang='MTGL-YCAD-67-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-67-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-67-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.470,berat_hancur_asli=berat_hancur_asli+2.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-YCAD-67-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','11','MTGL-YCAD-65-0','TOKO','BTGLMT','GL GUCI BTR 17CM KKT PER SHB ','1','2.210','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.200' WHERE kode_barang='MTGL-YCAD-65-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-65-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-65-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.210,berat_hancur_asli=berat_hancur_asli+2.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-YCAD-65-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','12','MTGL-YCAD-66-0','TOKO','BTGLMT','GL GUCI BTR 18CM KKT PER SHB ','1','2.250','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.240' WHERE kode_barang='MTGL-YCAD-66-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-66-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-66-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.250,berat_hancur_asli=berat_hancur_asli+2.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAD-66-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','13','MTGL-YDCX-158-0','TOKO','BTGLMT','GL VANESSA BTR BT 17CM KKT PER SHB ','1','2.940','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.930' WHERE kode_barang='MTGL-YDCX-158-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-158-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-158-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-YDCX-158-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','14','MTGL-YGAD-43-0','TOKO','BTGLMT','GL BRILLIANT MN 1 16CM KKT PER SHB ','1','3.330','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.320' WHERE kode_barang='MTGL-YGAD-43-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-43-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-43-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-YGAD-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-261013-0002','15','MTGL-YGAD-46-0','TOKO','BTGLMT','GL RANGKAIAN COR 17CM KKT PER PM','1','3.930','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.920' WHERE kode_barang='MTGL-YGAD-46-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-46-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-46-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.930,berat_hancur_asli=berat_hancur_asli+3.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','16','MTGL-YGAD-38-0','TOKO','BTGLMT','GL CAP HOLLO 17CM KKT PER SHB ','1','2.920','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.910' WHERE kode_barang='MTGL-YGAD-38-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-38-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-38-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.920,berat_hancur_asli=berat_hancur_asli+2.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-YGAD-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-261013-0002','17','MTGL-YGAD-39-0','TOKO','BTGLMT','GL CAP HOLLO 17CM KKT PER SHB ','1','3.320','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.310' WHERE kode_barang='MTGL-YGAD-39-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-39-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-39-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.320,berat_hancur_asli=berat_hancur_asli+3.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-39-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','18','MTGL-YFAA-41-0','TOKO','BTGLMT','GL CATENA BTR 16CM KKT PER SHB ','1','2.430','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.420' WHERE kode_barang='MTGL-YFAA-41-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAA-41-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAA-41-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.430,berat_hancur_asli=berat_hancur_asli+2.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YFAA-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-261013-0002','19','MTGL-YGBH-2-0','TOKO','BTGLMT','GL FANCY SLP BTR MN 1 BEL 17CM KKT PER BLT SHB ','1','1.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.660' WHERE kode_barang='MTGL-YGBH-2-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGBH-2-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGBH-2-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-YGBH-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-261013-0002','20','MTGL-YEXB-65-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','3.430','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.420' WHERE kode_barang='MTGL-YEXB-65-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-65-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-65-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.430,berat_hancur_asli=berat_hancur_asli+3.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-65-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','21','MTGL-YEXB-30-0','TOKO','BTGLMT','GL RANGKAIAN COR 17CM KKT PER SHB ','1','5.620','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.610' WHERE kode_barang='MTGL-YEXB-30-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-30-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-30-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.620,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-30-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','22','MTGL-YEXB-42-0','TOKO','BTGLMT','GL VIGARU 16CM KKT S SHB ','1','4.610','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.600' WHERE kode_barang='MTGL-YEXB-42-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-42-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-42-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.610,berat_hancur_asli=berat_hancur_asli+4.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-42-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','23','MTGL-YEXB-33-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','4.320','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.310' WHERE kode_barang='MTGL-YEXB-33-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-33-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-33-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.320,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-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-261013-0002','24','MTGL-YCBG-5-0','TOKO','BTGLMT','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','2.580','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.570' WHERE kode_barang='MTGL-YCBG-5-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBG-5-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBG-5-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.580,berat_hancur_asli=berat_hancur_asli+2.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBG-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-261013-0002','25','MTGL-YEXB-38-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','4.720','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.710' WHERE kode_barang='MTGL-YEXB-38-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-38-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-38-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.720,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-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-261013-0002','26','MTGL-YEXB-57-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.230','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.220' WHERE kode_barang='MTGL-YEXB-57-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-57-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-57-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.230,berat_hancur_asli=berat_hancur_asli+5.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','27','MTGL-YEXB-4-0','TOKO','BTGLMT','GL CATENA VAR BT MN 1 16CM KKT PER MK ','1','4.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.660' WHERE kode_barang='MTGL-YEXB-4-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-4-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-4-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.670,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-4-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','28','MTGL-YDCX-86-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB ','1','1.560','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.550' WHERE kode_barang='MTGL-YDCX-86-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-86-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-86-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.560,berat_hancur_asli=berat_hancur_asli+1.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-261013-0002','29','MTGL-YEXB-52-0','TOKO','BTGLMT','GL VIGARU 16CM KKT PER SHB ','1','3.640','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.630' WHERE kode_barang='MTGL-YEXB-52-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-52-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-52-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.640,berat_hancur_asli=berat_hancur_asli+3.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-YEXB-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-261013-0002','30','MTGL-YEXB-63-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','3.220','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.210' WHERE kode_barang='MTGL-YEXB-63-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-63-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-63-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.220,berat_hancur_asli=berat_hancur_asli+3.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','31','MTGL-YEXB-62-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.040' WHERE kode_barang='MTGL-YEXB-62-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-62-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-62-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-62-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','32','MTGL-YEXB-35-0','TOKO','BTGLMT','GL CAP HOLLO 17CM KKT PER SHB ','1','4.850','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.840' WHERE kode_barang='MTGL-YEXB-35-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-35-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-35-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.850,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-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-261013-0002','33','MTGL-YEXB-61-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.350','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.340' WHERE kode_barang='MTGL-YEXB-61-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-61-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-61-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.350,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-61-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','34','MTGL-YDCX-82-0','TOKO','BTGLMT','GL MOCCA VIGARU 17CM KKT PER SHB ','1','2.130','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.120' WHERE kode_barang='MTGL-YDCX-82-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-82-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-82-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.130,berat_hancur_asli=berat_hancur_asli+2.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-82-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','35','MTGL-YDCX-85-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB','1','1.650','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.640' WHERE kode_barang='MTGL-YDCX-85-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-85-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-85-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.650,berat_hancur_asli=berat_hancur_asli+1.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-YDCX-85-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','36','MTGL-YEXB-15-0','TOKO','BTGLMT','GL VANESSA MN 5 BL PSR 4 BTR 16CM KKT PER BLT SHB ','1','3.010','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.000' WHERE kode_barang='MTGL-YEXB-15-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-15-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-15-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.010,berat_hancur_asli=berat_hancur_asli+3.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','37','MTGL-YEXB-58-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.300','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.290' WHERE kode_barang='MTGL-YEXB-58-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-58-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-58-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.300,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-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-261013-0002','38','MTGL-YEXB-24-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER SHB ','1','3.830','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.820' WHERE kode_barang='MTGL-YEXB-24-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-24-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-24-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-YEXB-24-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','39','MTGL-YCBE-73-0','TOKO','BTGLMT','GL MOCCA VIGARU 16CM KKT PER SHB ','1','1.790','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.780' WHERE kode_barang='MTGL-YCBE-73-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-73-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-73-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.790,berat_hancur_asli=berat_hancur_asli+1.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-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-261013-0002','40','MTGL-YDCX-92-0','TOKO','BTGLMT','GL GUCCI CK MN HT 17CM KKT S SHB ','1','3.510','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.500' WHERE kode_barang='MTGL-YDCX-92-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-92-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-92-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.510,berat_hancur_asli=berat_hancur_asli+3.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-261013-0002','41','MTGL-YEXB-39-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','4.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.700' WHERE kode_barang='MTGL-YEXB-39-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-39-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-39-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.710,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-39-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','42','MTGL-YEXB-44-0','TOKO','BTGLMT','GL VIGARU 17CM KKT S SHB ','1','4.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.950' WHERE kode_barang='MTGL-YEXB-44-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-44-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-44-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.960,berat_hancur_asli=berat_hancur_asli+4.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-44-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','43','MTGL-YDCX-141-0','TOKO','BTGLMT','GL VANESSA KBS BTR 17CM KKT PER SHB ','1','3.550','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.540' WHERE kode_barang='MTGL-YDCX-141-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-141-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-141-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.550,berat_hancur_asli=berat_hancur_asli+3.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-141-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','44','MTGL-YDCX-87-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB ','1','1.500','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.490' WHERE kode_barang='MTGL-YDCX-87-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-87-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-87-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-261013-0002','45','MTGL-YEXB-25-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER SHB ','1','3.970','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.960' WHERE kode_barang='MTGL-YEXB-25-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-25-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-25-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.970,berat_hancur_asli=berat_hancur_asli+3.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-25-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','46','MTGL-YEXB-60-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.990' WHERE kode_barang='MTGL-YEXB-60-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-60-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-60-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.000,berat_hancur_asli=berat_hancur_asli+5.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','47','MTGL-YEXB-46-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','3.950','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.940' WHERE kode_barang='MTGL-YEXB-46-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-46-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-46-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.950,berat_hancur_asli=berat_hancur_asli+3.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','48','MTGL-YCBE-54-0','TOKO','BTGLMT','GL CAP HOLO 16CM KKT PER SHB ','1','4.260','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.250' WHERE kode_barang='MTGL-YCBE-54-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-54-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-54-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.260,berat_hancur_asli=berat_hancur_asli+4.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-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-261013-0002','49','MTGL-YDCX-110-0','TOKO','BTGLMT','GL SHANIA VAR 17CM KKT PER BLT SHB ','1','2.180','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.170' WHERE kode_barang='MTGL-YDCX-110-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-110-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-110-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.180,berat_hancur_asli=berat_hancur_asli+2.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-261013-0002','50','MTGL-YEXB-50-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.370','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.360' WHERE kode_barang='MTGL-YEXB-50-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-50-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-50-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.370,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-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-261013-0002','51','MTGL-YDCX-88-0','TOKO','BTGLMT','GL CATENA VAR 16CM KKT PER BLT SHB ','1','2.110','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.100' WHERE kode_barang='MTGL-YDCX-88-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-88-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-88-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.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-YDCX-88-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','52','MTGL-YEXB-9-0','TOKO','BTGLMT','GL GUCCI VAR MN 3 17CM KKT PER SHB ','1','5.220','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.210' WHERE kode_barang='MTGL-YEXB-9-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-9-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-9-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.220,berat_hancur_asli=berat_hancur_asli+5.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-9-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','53','MTGL-YEXB-49-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.120','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.110' WHERE kode_barang='MTGL-YEXB-49-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-49-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-49-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.120,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-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-261013-0002','54','MTGL-YCBE-52-0','TOKO','BTGLMT','GL 5567 BTR 16CM KKT PER SHB ','1','5.100','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.090' WHERE kode_barang='MTGL-YCBE-52-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-52-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-52-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.100,berat_hancur_asli=berat_hancur_asli+5.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-YCBE-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-261013-0002','55','MTGL-YEXB-56-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.220','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.210' WHERE kode_barang='MTGL-YEXB-56-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-56-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-56-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.220,berat_hancur_asli=berat_hancur_asli+5.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-56-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','56','MTGL-YEXB-7-0','TOKO','BTGLMT','GL GUCCI VAR MN 1 16CM KKT PER SHB ','1','4.880','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.870' WHERE kode_barang='MTGL-YEXB-7-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-7-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-7-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.880,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-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-261013-0002','57','MTGL-YEXB-48-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.120','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.110' WHERE kode_barang='MTGL-YEXB-48-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-48-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-48-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.120,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-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-261013-0002','58','MTGL-YEXB-59-0','TOKO','BTGLMT','GL VIGARU 17CM KKT PER SHB ','1','5.150','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.140' WHERE kode_barang='MTGL-YEXB-59-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-59-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-59-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.150,berat_hancur_asli=berat_hancur_asli+5.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-YEXB-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-261013-0002','59','MTGL-YDCX-161-0','TOKO','BTGLMT','GL VANESSA VAR BT 16CM KKT PER SHB ','1','4.610','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.600' WHERE kode_barang='MTGL-YDCX-161-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-161-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-161-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.610,berat_hancur_asli=berat_hancur_asli+4.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-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-261013-0002','60','MTGL-YEXB-74-0','TOKO','BTGLMT','GL KK ITALY ST BTR MN8 1BEL 26CM KKT PER BLT SHB','1','3.110','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.100' WHERE kode_barang='MTGL-YEXB-74-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-74-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-74-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.110,berat_hancur_asli=berat_hancur_asli+3.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-YEXB-74-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','61','MTGL-YEXB-72-0','TOKO','BTGLMT','GL KK ITALY ST DB MN5 1BEL 26CM KKT S SHB','1','2.970','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='2.960' WHERE kode_barang='MTGL-YEXB-72-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-72-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-72-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.970,berat_hancur_asli=berat_hancur_asli+2.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-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-261013-0002','62','MTGL-YEXB-75-0','TOKO','BTGLMT','GL KK ITALY ST DB MN6 1BEL 26CM KKT S SHB','1','4.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.040' WHERE kode_barang='MTGL-YEXB-75-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-75-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-75-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.050,berat_hancur_asli=berat_hancur_asli+4.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-YEXB-75-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','63','MTGL-YGAD-61-0','TOKO','BTGLMT','GL VANESSA VAR BTR BL PSR 16CM KKT PER MK ','1','5.460','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.450' WHERE kode_barang='MTGL-YGAD-61-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-61-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-61-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.460,berat_hancur_asli=berat_hancur_asli+5.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-61-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','64','MTGL-YGAD-60-0','TOKO','BTGLMT','GL VANESSA GLR BT DSC 18CM KKT PER SHB ','1','3.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.660' WHERE kode_barang='MTGL-YGAD-60-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-60-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-60-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.670,berat_hancur_asli=berat_hancur_asli+3.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','65','MTGL-YGAD-53-0','TOKO','BTGLMT','GL VANESSA DOLLAR 16CM KKT PER SHB ','1','3.170','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.160' WHERE kode_barang='MTGL-YGAD-53-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-53-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-53-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.170,berat_hancur_asli=berat_hancur_asli+3.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-53-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','66','MTGL-YGAD-126-0','TOKO','BTGLMT','GL CATENA VAR BL PSR 17CM KKT PER MK ','1','3.030','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.020' WHERE kode_barang='MTGL-YGAD-126-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-126-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-126-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.030,berat_hancur_asli=berat_hancur_asli+3.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','67','MTGL-YGAD-70-0','TOKO','BTGLMT','GL BMB BTR VAR 16CM KKT PER SHB ','1','4.330','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.320' WHERE kode_barang='MTGL-YGAD-70-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-70-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-70-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.330,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-70-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','68','MTGL-YGAD-80-0','TOKO','BTGLMT','GL VANESSA CK HT BT 17CM KKT PER SHB ','1','4.200','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.190' WHERE kode_barang='MTGL-YGAD-80-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-80-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-80-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.200,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-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-261013-0002','69','MTGL-YGAD-98-0','TOKO','BTGLMT','GL VANESSA FANCY SLP VAR 16CM KKT PER MK ','1','4.630','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.620' WHERE kode_barang='MTGL-YGAD-98-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-98-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-98-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.630,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-98-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','70','MTGL-YGAD-64-0','TOKO','BTGLMT','GL VANESSA FANCY SLP VAR 17CM KKT PER MK ','1','4.510','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.500' WHERE kode_barang='MTGL-YGAD-64-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-64-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-64-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.510,berat_hancur_asli=berat_hancur_asli+4.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','71','MTGL-YGAD-117-0','TOKO','BTGLMT','GL GUCCI VAR BT 17CM KKT PER SHB ','1','8.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='8.350' WHERE kode_barang='MTGL-YGAD-117-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-117-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-117-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.360,berat_hancur_asli=berat_hancur_asli+8.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-YGAD-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-261013-0002','72','MTGL-YGAD-128-0','TOKO','BTGLMT','GL CATENA DOUBLE VAR 17CM KKT PER MK ','1','3.430','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.420' WHERE kode_barang='MTGL-YGAD-128-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-128-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-128-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.430,berat_hancur_asli=berat_hancur_asli+3.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-128-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','73','MTGL-YGAD-153-0','TOKO','BTGLMT','GL RANGKAIAN HT BTR 16CM KKT PER SHB ','1','4.110','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.100' WHERE kode_barang='MTGL-YGAD-153-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-153-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-153-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-YGAD-153-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','74','MTGL-YGAD-109-0','TOKO','BTGLMT','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','4.610','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.600' WHERE kode_barang='MTGL-YGAD-109-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-109-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-109-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.610,berat_hancur_asli=berat_hancur_asli+4.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','75','MTGL-YGAD-118-0','TOKO','BTGLMT','GL CASTELI VAR 16CM KKT PER SHB ','1','3.070','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.060' WHERE kode_barang='MTGL-YGAD-118-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-118-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-118-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-118-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','76','MTGL-YGAD-54-0','TOKO','BTGLMT','GL VANESSA DOLLAR CDY 16CM KKT PER SHB ','1','3.350','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.340' WHERE kode_barang='MTGL-YGAD-54-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-54-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-54-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-YGAD-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-261013-0002','77','MTGL-YGAD-85-0','TOKO','BTGLMT','GL VANESSA DOLLAR CDY 16CM KKT PER SHB ','1','3.340','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.330' WHERE kode_barang='MTGL-YGAD-85-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-85-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-85-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-YGAD-85-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','78','MTGL-YGAD-92-0','TOKO','BTGLMT','GL VANESSA BLCHN 16CM KKT PER SHB','1','4.820','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.810' WHERE kode_barang='MTGL-YGAD-92-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-92-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-92-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-YGAD-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-261013-0002','79','MTGL-YGAD-78-0','TOKO','BTGLMT','GL RANGKAIAN 19CM KKT PER HWT ','1','10.480','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='10.470' WHERE kode_barang='MTGL-YGAD-78-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-78-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-78-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.480,berat_hancur_asli=berat_hancur_asli+10.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','80','MTGL-YGAD-55-0','TOKO','BTGLMT','GL VANESSA DOLLAR 17CM KKT PER SHB ','1','3.120','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.110' WHERE kode_barang='MTGL-YGAD-55-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-55-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-55-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.120,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-55-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','81','MTGL-YFAH-150-0','TOKO','BTGLMT','GL RANGKAIAN VAR MN 2 17CM KKT PER MK ','1','5.350','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.340' WHERE kode_barang='MTGL-YFAH-150-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAH-150-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAH-150-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.350,berat_hancur_asli=berat_hancur_asli+5.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-YFAH-150-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','82','MTGL-YGAD-73-0','TOKO','BTGLMT','GL SATELIT BTR 16CM KKT PER SHB ','1','4.700','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.690' WHERE kode_barang='MTGL-YGAD-73-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-73-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-73-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.700,berat_hancur_asli=berat_hancur_asli+4.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','83','MTGL-YGAD-158-0','TOKO','BTGLMT','GL CAP HOLO 17CM KKT PER SHB ','1','4.770','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.760' WHERE kode_barang='MTGL-YGAD-158-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-158-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-158-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.770,berat_hancur_asli=berat_hancur_asli+4.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-158-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','84','MTGL-YGAD-129-0','TOKO','BTGLMT','GL CATENA DOUBLE VAR 17CM KKT PER SHB ','1','3.130','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.120' WHERE kode_barang='MTGL-YGAD-129-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-129-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-129-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.130,berat_hancur_asli=berat_hancur_asli+3.130, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','85','MTGL-YGAD-81-0','TOKO','BTGLMT','GL VANESSA DOLLAR 16CM KKT PER SHB ','1','3.080','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.070' WHERE kode_barang='MTGL-YGAD-81-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-81-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-81-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.080,berat_hancur_asli=berat_hancur_asli+3.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-81-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','86','MTGL-YGAD-86-0','TOKO','BTGLMT','GL VANESSA BLCHN BT 16CM KKT PER SHB ','1','3.740','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.730' WHERE kode_barang='MTGL-YGAD-86-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-86-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-86-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.740,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-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-261013-0002','87','MTGL-YGAD-87-0','TOKO','BTGLMT','GL VANESSA BTR BL PSR BT 16CM KKT PER SHB ','1','5.420','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='5.410' WHERE kode_barang='MTGL-YGAD-87-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-87-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-87-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.420,berat_hancur_asli=berat_hancur_asli+5.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','88','MTGL-YGAD-76-0','TOKO','BTGLMT','GL SATELIT CK 17CM KKT PER SHB ','1','4.740','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.730' WHERE kode_barang='MTGL-YGAD-76-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-76-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-76-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.740,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-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-261013-0002','89','MTGL-YGAD-67-0','TOKO','BTGLMT','GL VIGARU 16CM KKT PER MK ','1','4.520','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='4.510' WHERE kode_barang='MTGL-YGAD-67-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-67-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-67-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.520,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-67-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','90','MTGL-YGAD-151-0','TOKO','BTGLMT','GL ITALY ST SRT TDK BT 18CM KKT PER MK ','1','3.460','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='3.450' WHERE kode_barang='MTGL-YGAD-151-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-151-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-151-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.460,berat_hancur_asli=berat_hancur_asli+3.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-151-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261013-0002','91','MTGL-YGAD-125-0','TOKO','BTGLMT','GL CATENA VAR 17CM KKT PER SHB ','1','1.690','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.680' WHERE kode_barang='MTGL-YGAD-125-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-125-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-125-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.690,berat_hancur_asli=berat_hancur_asli+1.690, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261013-0002','92','MTGL-YDCX-133-0','TOKO','BTGLMT','GL VANESSA DB MN5 17CM KKT S SHB ','1','2.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-10-13 16:30:37',status_delete='1.990' WHERE kode_barang='MTGL-YDCX-133-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-133-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-133-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-133-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-261013-0002','2026-10-13','admin','2026-10-13','16:30:37','admin','2026-10-13 16:30:37');