INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-11 ','08:34:47'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-11','106','0','-214300000','106','0','-214300000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-11'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-10'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-10'; 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-11-10' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-10'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-10'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-10'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-10'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-11' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-10' 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-261111-0001','D','2026-11-11','08:35:04','BCA','SALDO AWAL','SALDO AWAL','0','1416573607','1416573607'); 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-261111-0001','D','2026-11-11','08:35:04','','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-11-11'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-11 ','08:37:21'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-11 ','09:05:33'); 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-261111-0001','1','X-00009983','BELI','BELI001','CN COR EROPA SHB','1','2.230','3551000.00' ,'0.00','3551000','','3551000','3551000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-11-11 09:06:21' WHERE kode_barang='X-00009983' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009983' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009983' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.230',berat_hancur_asli=berat_hancur_asli+'2.230', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261111-0001','2','X-00009984','BELI','BELI001','GL HL RT ANAK 13CM KKT PER SHB','1','4.000','6370000.00' ,'0.00','6370000','','6370000','13472000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-11-11 09:06:21' WHERE kode_barang='X-00009984' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009984' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009984' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.000',berat_hancur_asli=berat_hancur_asli+'4.000', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261111-0001','3','X-00009985','BELI','BELI001','GL RANGKAIAN COR KRW 17CM KKT PER SHB','1','7.130','11354500.00' ,'0.00','11354500','','11354500','31196500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-11-11 09:06:21' WHERE kode_barang='X-00009985' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009985' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009985' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'7.130',berat_hancur_asli=berat_hancur_asli+'7.130', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'7.130',berat_akhir_asli=berat_akhir_asli-'7.130' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261111-0001','4','X-00009986','BELI','BELI001','KL ITALY ST VC BT HTM 42CM KKT PER BLT MK','1','3.600','5733000.00' ,'0.00','5733000','','5733000','48284000','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-11-11 09:06:21' WHERE kode_barang='X-00009986' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009986' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009986' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.600',berat_hancur_asli=berat_hancur_asli+'3.600', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' 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-261111-0001','adminpusat','2026-11-11','2026-11-11','09:06:21','27008500','48284000', 'adminpusat','2026-11-11 09:06:21'); INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01877','2501','1','CN COR BT AD WARNA BIRU UBS700','0','1','0','','') UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'900000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'900000' WHERE tanggal='2026-11-11' INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01877','2026-11-11','2026-11-11','09:11:53','PLG0019700','2501','90','2027-02-09','cashier1','2026-11-11 09:11:53','1.070','900000','4.00','108000','1008000','0','OPEN','11.9','1','2027-02-09','0','1008000') 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-261111-0002','K','2026-11-11','09:11:53','cashier1','HUTANG','PI26-01877','122090965','900000','121190965','OPEN') UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01877' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01877'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-11 ','09:15:37'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-11-11 ','09:17:25'); 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-00009987','X-00009987','CN COR EROPA SHB','GR','---','MTCN','BELI','BELI001','8217000','2026-11-11','5.160','1','sales','2026-11-11 09:35:19'); 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-00009987','X-00009987'); 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-261111-0001','FJ-261105-0006','2403','1','BELI','BELI001','MTCN', 'X-00009987', 'CN COR EROPA SHB','5.160','5.160','100.00','9185000','8217000','1592442','1','8217000','8217000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.160',berat_beli_asli=berat_beli_asli+'5.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.160',berat_akhir_asli=berat_akhir_asli+'5.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-11' 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-261111-0001','2026-11-11','2026-11-11','09:35:18','2403','---','5.160','8217000','8217000','8217000','8217000','8217000','sales','2026-11-11 09:35:19','FB-261111-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261111-0001','M FANI','KAMPUNG SENG 53A','','','081217756937','sales','2026-11-11 09:35:19'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-11' 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-261111-0003','K','2026-11-11','09:35:18','sales','PEMBELIAN UMUM','FB-261111-0001','121190965','8217000','112973965','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-11 ','10:40:10'); 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-261111-0001','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZFAG-85-0','CN KAWIN COR BT SHB ','','2.460','1','100.00','4453000','0','0','0','4453000','0','0','0','4453000','2106','00030396','MTCN','217500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAG-85-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.460',berat_jual_asli=berat_jual_asli+'2.460',stock_jual='1',berat_akhir=berat_akhir-'2.460',berat_akhir_asli=berat_akhir_asli-'2.460',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='MTCN-ZFAG-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-261111-0001','2026-11-11','2.460','2026-11-11','10:40:21','PLG0019701','4453000','4453000','0','4453000','4453000','sales','2026-11-11 10:40:21','FJ-261111-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-11-11','FJ-261111-0001','2026-11-11','10:40:21','2106','4453000','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-261111-0004','D','2026-11-11','10:40:21','sales','PENJUALAN','FJ-261111-0001','112973965','4453000','117426965'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-11 ','12:00:23'); 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-00009988','X-00009988','LT COR BT MK','GR','---','MDLT','BELI','BELI001','983500','2026-11-11','1.050','1','sales','2026-11-11 12:11:57'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00009988','X-00009988'); 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-261111-0002','FJ-260927-0001','2105','1','BELI','BELI001','MDLT', 'X-00009988', 'LT COR BT MK','1.050','1.050','100.00','1165500','983500','936667','1','983500','983500','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-11-11','BELI','BELI001','MDLT','MDLT','100.00','1.050','1.050','1','1.050','1.050','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-261111-0002','2026-11-11','2026-11-11','12:11:56','2105','---','1.050','983500','983500','983500','983500','983500','sales','2026-11-11 12:11:57','FB-261111-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261111-0002','MALIKA','SIDOTOPO DIPO 2/21A','','','','sales','2026-11-11 12:11:57'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-11' 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-261111-0005','K','2026-11-11','12:11:56','sales','PEMBELIAN UMUM','FB-261111-0002','117426965','983500','116443465','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-11-11 ','12:12:39'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261111-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261111-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261111-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261111-0002'; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','1','MTGL-XGXC-70-0','TOKO','BTGLMT','GL PIPA TDK BT BG3 ','1','19.750','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='19.740' WHERE kode_barang='MTGL-XGXC-70-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XGXC-70-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-XGXC-70-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+19.750,berat_hancur_asli=berat_hancur_asli+19.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XGXC-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-261111-0002','2','MTGL-YCAE-32-0','TOKO','BTGLMT','GL BANGKOK PLAT SHB ','1','15.320','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='15.310' WHERE kode_barang='MTGL-YCAE-32-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAE-32-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAE-32-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+15.320,berat_hancur_asli=berat_hancur_asli+15.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-YCAE-32-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','3','MTGL-YCAX-23-0','TOKO','BTGLMT','GL PLINTIR SHB ','1','9.980','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='9.970' WHERE kode_barang='MTGL-YCAX-23-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAX-23-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAX-23-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.980,berat_hancur_asli=berat_hancur_asli+9.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAX-23-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','4','MTGL-YFAH-142-0','TOKO','BTGLMT','GL PIPA BT SMBR PTH BG3 ','1','13.860','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='13.850' WHERE kode_barang='MTGL-YFAH-142-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAH-142-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAH-142-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+13.860,berat_hancur_asli=berat_hancur_asli+13.860, 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-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-261111-0002','5','MTGL-YGAD-34-0','TOKO','BTGLMT','GL PIPA ANAK KRC 6 SHB ','1','11.350','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='11.340' WHERE kode_barang='MTGL-YGAD-34-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-34-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-34-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.350,berat_hancur_asli=berat_hancur_asli+11.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-34-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','6','MTGL-YGAD-35-0','TOKO','BTGLMT','GL PIPA ANAK KRC PLTR KOMB 6 SHB ','1','15.000','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='14.990' WHERE kode_barang='MTGL-YGAD-35-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-35-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-35-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+15.000,berat_hancur_asli=berat_hancur_asli+15.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-YGAD-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-261111-0002','7','MTGL-YGAD-37-0','TOKO','BTGLMT','GL CAP HOLLO 17CM KKT PER SHB ','1','2.980','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.970' WHERE kode_barang='MTGL-YGAD-37-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-37-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-37-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.980,berat_hancur_asli=berat_hancur_asli+2.980, 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-37-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','8','MTGL-YFAH-144-0','TOKO','BTGLMT','GL VANESSA HL RT PLT TDK BT 16CM KKT PER MK ','1','3.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.350' WHERE kode_barang='MTGL-YFAH-144-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAH-144-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAH-144-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.360,berat_hancur_asli=berat_hancur_asli+3.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-YFAH-144-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','9','MTGL-YGAD-45-0','TOKO','BTGLMT','GL VIGARU VAR 17CM KKT PER SHB ','1','4.730','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.720' WHERE kode_barang='MTGL-YGAD-45-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-45-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-45-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.730,berat_hancur_asli=berat_hancur_asli+4.730, 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-45-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','10','MTGL-YCAD-44-0','TOKO','BTGLMT','GL FANCY SRT VAR SMBR PTH 19CM KKT PER BLT UBS ','1','1.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='1.700' WHERE kode_barang='MTGL-YCAD-44-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-44-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-44-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.710,berat_hancur_asli=berat_hancur_asli+1.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAD-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-261111-0002','11','MTGL-YEXB-2-0','TOKO','BTGLMT','GL CATENA DOUBLE VAR BT 17CM KKT PER MK ','1','3.610','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.600' WHERE kode_barang='MTGL-YEXB-2-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-2-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-2-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.610,berat_hancur_asli=berat_hancur_asli+3.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-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-261111-0002','12','MTGL-YCBE-51-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER SHB ','1','5.170','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='5.160' WHERE kode_barang='MTGL-YCBE-51-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-51-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-51-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.170,berat_hancur_asli=berat_hancur_asli+5.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-51-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','13','MTGL-YDCX-144-0','TOKO','BTGLMT','GL VANESSA BLCHN VAR 16CM KKT PER SHB ','1','3.700','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.690' WHERE kode_barang='MTGL-YDCX-144-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-144-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-144-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.700,berat_hancur_asli=berat_hancur_asli+3.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-YDCX-144-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','14','MTGL-YDCX-142-0','TOKO','BTGLMT','GL VANESSA BTR HT 16CM KKT PER SHB ','1','3.650','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.640' WHERE kode_barang='MTGL-YDCX-142-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-142-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-142-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.650,berat_hancur_asli=berat_hancur_asli+3.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-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-261111-0002','15','MTGL-YEXB-29-0','TOKO','BTGLMT','GL RANGKAIAN MN BTR4 16CM KKT PER SHB ','1','4.440','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.430' WHERE kode_barang='MTGL-YEXB-29-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-29-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-29-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.440,berat_hancur_asli=berat_hancur_asli+4.440, 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-29-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','16','MTGL-YDCX-143-0','TOKO','BTGLMT','GL VANESSA BTR HT 16CM KKT PER SHB ','1','3.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.660' WHERE kode_barang='MTGL-YDCX-143-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-143-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-143-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-YDCX-143-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','17','MTGL-YDCX-159-0','TOKO','BTGLMT','GL VANESSA VAR BT 17CM KKT PER SHB','1','4.260','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.250' WHERE kode_barang='MTGL-YDCX-159-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-159-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-159-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-YDCX-159-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','18','MTGL-YGAD-110-0','TOKO','BTGLMT','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','4.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.700' WHERE kode_barang='MTGL-YGAD-110-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-110-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-110-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-YGAD-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-261111-0002','19','MTGL-YGAD-149-0','TOKO','BTGLMT','GL RANGKAIAN KWT BTR 17CM KKT S SHB ','1','4.650','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.640' WHERE kode_barang='MTGL-YGAD-149-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-149-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-149-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.650,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-149-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','20','MTGL-YGAD-133-0','TOKO','BTGLMT','GL JELITA BTR 16CM KKT PER SHB ','1','4.900','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.890' WHERE kode_barang='MTGL-YGAD-133-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-133-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-133-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.900,berat_hancur_asli=berat_hancur_asli+4.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-133-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','21','MTGL-YGAD-84-0','TOKO','BTGLMT','GL VANESSA DOLLAR 16CM KKT PER SHB ','1','3.020','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.010' WHERE kode_barang='MTGL-YGAD-84-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-84-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-84-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.020,berat_hancur_asli=berat_hancur_asli+3.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-84-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','22','MTGL-YGAD-123-0','TOKO','BTGLMT','GL CATENA VAR HT 17CM KKT PER SHB ','1','3.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.350' WHERE kode_barang='MTGL-YGAD-123-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-123-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-123-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.360,berat_hancur_asli=berat_hancur_asli+3.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-123-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','23','MTGL-YGAD-89-0','TOKO','BTGLMT','GL VANESSA BTR MN BT 17CM KKT S SHB ','1','3.210','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.200' WHERE kode_barang='MTGL-YGAD-89-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-89-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-89-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.210,berat_hancur_asli=berat_hancur_asli+3.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-89-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','24','MTGL-YGAD-162-0','TOKO','BTGLMT','GL VIGARU SMBR PTH 17CM KKT PER MK ','1','5.950','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='5.940' WHERE kode_barang='MTGL-YGAD-162-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-162-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-162-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.950,berat_hancur_asli=berat_hancur_asli+5.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-YGAD-162-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','25','MTGL-YGAD-132-0','TOKO','BTGLMT','GL JELITA BTR 16CM KKT PER SHB ','1','4.860','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.850' WHERE kode_barang='MTGL-YGAD-132-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-132-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-132-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.860,berat_hancur_asli=berat_hancur_asli+4.860, 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-132-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','26','MTGL-YGAD-161-0','TOKO','BTGLMT','GL VIGARU SMBR PTH 16CM KKT PER MK ','1','4.900','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.890' WHERE kode_barang='MTGL-YGAD-161-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-161-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-161-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.900,berat_hancur_asli=berat_hancur_asli+4.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','27','MTGL-YGAD-111-0','TOKO','BTGLMT','GL RANGKAIAN VAR 17CM KKT PER SHB ','1','4.540','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.530' WHERE kode_barang='MTGL-YGAD-111-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-111-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-111-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.540,berat_hancur_asli=berat_hancur_asli+4.540, 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-111-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','28','MTGL-YGAD-130-0','TOKO','BTGLMT','GL FANCY SLP VAR BTR BL PSR 17CM KKT PER SHB ','1','3.600','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.590' WHERE kode_barang='MTGL-YGAD-130-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-130-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-130-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.600,berat_hancur_asli=berat_hancur_asli+3.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','29','MTGL-YGAD-59-0','TOKO','BTGLMT','GL VANESSA VAR BL CN BT 17CM KKT PER SHB ','1','3.780','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.770' WHERE kode_barang='MTGL-YGAD-59-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-59-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-59-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.780,berat_hancur_asli=berat_hancur_asli+3.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','30','MTGL-YGAD-88-0','TOKO','BTGLMT','GL VANESSA BTR BL CN BT 17CM KKT PER MK ','1','2.930','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.920' WHERE kode_barang='MTGL-YGAD-88-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-88-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-88-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.930,berat_hancur_asli=berat_hancur_asli+2.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','31','MTGL-YGAD-113-0','TOKO','BTGLMT','GL GUCCI VAR BTR 17CM KKT PER SHB ','1','3.800','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.790' WHERE kode_barang='MTGL-YGAD-113-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-113-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-113-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.800,berat_hancur_asli=berat_hancur_asli+3.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-113-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','32','MTGL-YGAD-74-0','TOKO','BTGLMT','GL SATELIT BTR 17CM KKT PER SHB ','1','4.650','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.640' WHERE kode_barang='MTGL-YGAD-74-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-74-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-74-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.650,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-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-261111-0002','33','MTGL-YGAD-138-0','TOKO','BTGLMT','GL RANGKAIAN BTR OVAL 17CM KKT PER SHB ','1','4.500','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.490' WHERE kode_barang='MTGL-YGAD-138-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-138-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-138-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.500,berat_hancur_asli=berat_hancur_asli+4.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-138-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','34','MTGL-YGAD-146-0','TOKO','BTGLMT','GL CAP PLAT 17CM KKT PER SHB ','1','3.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.700' WHERE kode_barang='MTGL-YGAD-146-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-146-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-146-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.710,berat_hancur_asli=berat_hancur_asli+3.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-146-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','35','MTGL-YGAD-135-0','TOKO','BTGLMT','GL RANGKAIAN MN BTR 4 16CM KKT PER SHB ','1','4.420','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.410' WHERE kode_barang='MTGL-YGAD-135-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-135-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-135-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.420,berat_hancur_asli=berat_hancur_asli+4.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-135-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','36','MTGL-YGAD-62-0','TOKO','BTGLMT','GL VANESSA VAR 16CM KKT PER SHB ','1','2.740','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.730' WHERE kode_barang='MTGL-YGAD-62-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-62-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-62-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-YGAD-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-261111-0002','37','MTGL-YGAD-159-0','TOKO','BTGLMT','GL MOCCA VIGARU SMBR PTH 17CM KKT PER MK ','1','3.720','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.710' WHERE kode_barang='MTGL-YGAD-159-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-159-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-159-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.720,berat_hancur_asli=berat_hancur_asli+3.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-159-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','38','MTGL-YFAH-146-0','TOKO','BTGLMT','GL RANGKAIAN BTR 16CM KKT PER SHB ','1','3.360','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.350' WHERE kode_barang='MTGL-YFAH-146-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAH-146-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAH-146-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.360,berat_hancur_asli=berat_hancur_asli+3.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-YFAH-146-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','39','MTGL-YGAD-124-0','TOKO','BTGLMT','GL CATENA VAR BTR 17CM KKT PER SHB ','1','2.750','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.740' WHERE kode_barang='MTGL-YGAD-124-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-124-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-124-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.750,berat_hancur_asli=berat_hancur_asli+2.750, 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-124-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','40','MTGL-YGAD-148-0','TOKO','BTGLMT','GL MOCCA VIGARU MN 5 16CM KKT S SHB ','1','3.150','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.140' WHERE kode_barang='MTGL-YGAD-148-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-148-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-148-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.150,berat_hancur_asli=berat_hancur_asli+3.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-148-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','41','MTGL-YGAD-57-0','TOKO','BTGLMT','GL VANESSA VAR BLCHN 17CM KKT PER SHB ','1','2.660','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.650' WHERE kode_barang='MTGL-YGAD-57-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-57-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-57-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.660,berat_hancur_asli=berat_hancur_asli+2.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','42','MTGL-YGAD-142-0','TOKO','BTGLMT','GL VIGARU 5516 BTR 16CM KKT PER SHB ','1','3.730','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.720' WHERE kode_barang='MTGL-YGAD-142-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-142-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-142-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.730,berat_hancur_asli=berat_hancur_asli+3.730, 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-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-261111-0002','43','MTGL-YGAD-94-0','TOKO','BTGLMT','GL VANESSA KBS 17CM KKT PER SHB ','1','3.630','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.620' WHERE kode_barang='MTGL-YGAD-94-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-94-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-94-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.630,berat_hancur_asli=berat_hancur_asli+3.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-94-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','44','MTGL-YGAD-93-0','TOKO','BTGLMT','GL VANESSA VAR BTR BL PSR 16CM KKT PER SHB ','1','3.480','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.470' WHERE kode_barang='MTGL-YGAD-93-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-93-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-93-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.480,berat_hancur_asli=berat_hancur_asli+3.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-93-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','45','MTGL-YGAD-68-0','TOKO','BTGLMT','GL VIGARU 17CM KKT S SHB ','1','5.480','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='5.470' WHERE kode_barang='MTGL-YGAD-68-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-68-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-68-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.480,berat_hancur_asli=berat_hancur_asli+5.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-68-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','46','MTGL-YGAD-154-0','TOKO','BTGLMT','GL RANGKAIAN HT 16CM KKT PER SHB ','1','4.270','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.260' WHERE kode_barang='MTGL-YGAD-154-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-154-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-154-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.270,berat_hancur_asli=berat_hancur_asli+4.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-154-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','47','MTGL-YGAD-127-0','TOKO','BTGLMT','GL CATENA VAR BT MN 1 17CM KKT PER MK ','1','4.160','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.150' WHERE kode_barang='MTGL-YGAD-127-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-127-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-127-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.160,berat_hancur_asli=berat_hancur_asli+4.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-127-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','48','MTGL-YGAD-97-0','TOKO','BTGLMT','GL VANESSA VAR 16CM KKT PER MK ','1','4.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.040' WHERE kode_barang='MTGL-YGAD-97-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-97-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-97-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-YGAD-97-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','49','MTGL-YGAD-66-0','TOKO','BTGLMT','GL GUCCI VIGARU VAR 17CM KKT PER SHB ','1','3.560','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.550' WHERE kode_barang='MTGL-YGAD-66-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-66-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-66-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.560,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-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-261111-0002','50','MTGL-YGAD-56-0','TOKO','BTGLMT','GL VANESSA VAR BLCHN 17CM KKT PER SHB ','1','2.700','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.690' WHERE kode_barang='MTGL-YGAD-56-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-56-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-56-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.700,berat_hancur_asli=berat_hancur_asli+2.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-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-261111-0002','51','MTGL-YGAD-157-0','TOKO','BTGLMT','GL POPCORN VAR MN 2 17CM KKT PER SHB ','1','4.570','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.560' WHERE kode_barang='MTGL-YGAD-157-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-157-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-157-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.570,berat_hancur_asli=berat_hancur_asli+4.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-157-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','52','MTGL-YGAD-83-0','TOKO','BTGLMT','GL VANESSA DOLLAR 16CM KKT PER SHB ','1','3.050','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.040' WHERE kode_barang='MTGL-YGAD-83-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-83-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-83-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.050,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-83-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','53','MTGL-YGAD-141-0','TOKO','BTGLMT','GL BLB VAR 16CM KKT PER SHB ','1','4.400','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.390' WHERE kode_barang='MTGL-YGAD-141-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-141-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-141-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.400,berat_hancur_asli=berat_hancur_asli+4.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','54','MTGL-YGAD-150-0','TOKO','BTGLMT','GL BMB VAR BL PSR 16CM KKT PER SHB ','1','4.870','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.860' WHERE kode_barang='MTGL-YGAD-150-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-150-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-150-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.870,berat_hancur_asli=berat_hancur_asli+4.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','55','MTGL-YGAD-122-0','TOKO','BTGLMT','GL CATENA VAR HT 16CM KKT PER SHB ','1','4.620','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.610' WHERE kode_barang='MTGL-YGAD-122-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-122-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-122-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.620,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-122-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','56','MTGL-YGAD-69-0','TOKO','BTGLMT','GL RANGKAIAN MN BTR 4 16CM KKT PER SHB ','1','4.450','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.440' WHERE kode_barang='MTGL-YGAD-69-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-69-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-69-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.450,berat_hancur_asli=berat_hancur_asli+4.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-69-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','57','MTGL-YGAD-96-0','TOKO','BTGLMT','GL VANESSA VAR 16CM KKT PER MK ','1','3.470','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.460' WHERE kode_barang='MTGL-YGAD-96-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-96-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-96-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.470,berat_hancur_asli=berat_hancur_asli+3.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-96-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','58','MTGL-YGAD-71-0','TOKO','BTGLMT','GL BLB VAR 16CM KKT PER SHB ','1','3.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.660' WHERE kode_barang='MTGL-YGAD-71-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-71-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-71-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-71-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','59','MTGL-YGAD-106-0','TOKO','BTGLMT','GL SQUIDEST BTR 17CM KKT PER SHB ','1','4.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.700' WHERE kode_barang='MTGL-YGAD-106-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-106-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-106-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-YGAD-106-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','60','MTGL-YGAD-120-0','TOKO','BTGLMT','GL FANCY SLP VAR 17CM KKT PER SHB ','1','5.430','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='5.420' WHERE kode_barang='MTGL-YGAD-120-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-120-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-120-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.430,berat_hancur_asli=berat_hancur_asli+5.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-120-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','61','MTGL-YGAD-114-0','TOKO','BTGLMT','GL GUCCI VAR BTR 17CM KKT PER SHB ','1','4.010','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.000' WHERE kode_barang='MTGL-YGAD-114-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-114-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-114-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.010,berat_hancur_asli=berat_hancur_asli+4.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-YGAD-114-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','62','MTGL-YGAD-134-0','TOKO','BTGLMT','GL RANGKAIAN MN BTR 4 16CM KKT PER SHB ','1','4.480','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='4.470' WHERE kode_barang='MTGL-YGAD-134-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-134-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-134-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.480,berat_hancur_asli=berat_hancur_asli+4.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-134-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','63','MTGL-YGAD-147-0','TOKO','BTGLMT','GL CAP PLAT 17CM KKT PER SHB ','1','3.630','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.620' WHERE kode_barang='MTGL-YGAD-147-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-147-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-147-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.630,berat_hancur_asli=berat_hancur_asli+3.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-147-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','64','MTGL-YGAD-90-0','TOKO','BTGLMT','GL VANESSA BL CN 16CM KKT PER SHB ','1','3.010','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.000' WHERE kode_barang='MTGL-YGAD-90-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-90-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-90-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-YGAD-90-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','65','MTGL-YFAH-147-0','TOKO','BTGLMT','GL ITALY ST SRT VAR BT 18CM KKT PER MK ','1','3.960','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.950' WHERE kode_barang='MTGL-YFAH-147-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YFAH-147-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YFAH-147-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.960,berat_hancur_asli=berat_hancur_asli+3.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-YFAH-147-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','66','MTGL-YGAD-21-0','TOKO','BTGLMT','GL ANAK PIPA CAT UBS ','1','3.560','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='3.550' WHERE kode_barang='MTGL-YGAD-21-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-21-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-21-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.560,berat_hancur_asli=berat_hancur_asli+3.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-YGAD-21-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','67','MTGL-YGAD-22-0','TOKO','BTGLMT','GL ANAK PIPA CAT UBS ','1','2.600','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.590' WHERE kode_barang='MTGL-YGAD-22-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-22-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-22-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.600,berat_hancur_asli=berat_hancur_asli+2.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-22-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','68','MTGL-YGAD-23-0','TOKO','BTGLMT','GL ANAK PIPA CAT UBS ','1','2.800','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.790' WHERE kode_barang='MTGL-YGAD-23-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-23-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-23-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.800,berat_hancur_asli=berat_hancur_asli+2.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-23-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','69','MTGL-YGAD-27-0','TOKO','BTGLMT','GL ANAK PIPA TDK BT SHB ','1','1.910','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='1.900' WHERE kode_barang='MTGL-YGAD-27-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-27-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-27-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.910,berat_hancur_asli=berat_hancur_asli+1.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-27-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','70','MTGL-YGBH-9-0','TOKO','BTGLMT','GL BABY CAT BT SHB ','1','2.370','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.360' WHERE kode_barang='MTGL-YGBH-9-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGBH-9-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGBH-9-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.370,berat_hancur_asli=berat_hancur_asli+2.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-YGBH-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-261111-0002','71','MTGL-YGAD-16-0','TOKO','BTGLMT','GL BABY CAT BT SHB ','1','2.310','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.300' WHERE kode_barang='MTGL-YGAD-16-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-16-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-16-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.310,berat_hancur_asli=berat_hancur_asli+2.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-16-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','72','MTGL-YGAD-18-0','TOKO','BTGLMT','GL BABY CAT BT SHB ','1','2.120','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.110' WHERE kode_barang='MTGL-YGAD-18-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-18-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-18-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-18-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','73','MTGL-YGAD-4-0','TOKO','BTGLMT','GL BABY KWT BTR 1 BEL SHB ','1','2.300','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.290' WHERE kode_barang='MTGL-YGAD-4-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-4-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-4-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.300,berat_hancur_asli=berat_hancur_asli+2.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','74','MTGL-YGAD-7-0','TOKO','BTGLMT','GL BABY KWT BTR 1 BEL SHB ','1','2.920','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='2.910' WHERE kode_barang='MTGL-YGAD-7-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-7-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-7-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-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-261111-0002','75','MTGL-YGAD-1-0','TOKO','BTGLMT','GL BABY KWT BTR 1 BEL SHB ','1','1.710','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='1.700' WHERE kode_barang='MTGL-YGAD-1-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-1-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-1-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.710,berat_hancur_asli=berat_hancur_asli+1.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-1-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261111-0002','76','MTGL-YGAD-2-0','TOKO','BTGLMT','GL BABY KWT BTR 1 BEL SHB ','1','1.660','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='1.650' WHERE kode_barang='MTGL-YGAD-2-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-2-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-2-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.660,berat_hancur_asli=berat_hancur_asli+1.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-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-261111-0002','77','MTGL-YGAD-3-0','TOKO','BTGLMT','GL BABY KWT BTR 1 BEL SHB ','1','1.670','RETUR CUCI ULANG'); UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-11-11 12:27:49',status_delete='1.660' WHERE kode_barang='MTGL-YGAD-3-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-3-0'; DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-3-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-YGAD-3-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-261111-0002','2026-11-11','admin','2026-11-11','12:27:49','admin','2026-11-11 12:27:49'); UPDATE tt_hutang_head SET byr_harus_rp='1000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1033000',tgl_lunas='2026-11-11',status='CLOS',total_lunas='1033000' WHERE no_hutang='PI26-01849'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1000000' WHERE tanggal='2026-11-11'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1000000' WHERE tanggal='2026-11-11'; 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-261111-0006','D','2026-11-11','12:39:35','cashier1','HUTANG LUNAS','PI26-01849','116443465','1033000','117476465'); 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-261111-0002','sales','1',' EX ','TOKO','BTKLMD','MDKL-ZJXG-43-0','KL ITALY ST VAR BT 42CM KKT PER UBS ','','2.170','1','100.00','2365500','0','0','0','2365500','0','0','0','2365500','2501','00031699','MDKL','153000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZJXG-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='MDKL-ZJXG-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-261111-0002','2026-11-11','2.170','2026-11-11','13:24:34','PLG0019702','2365500','2365500','0','2365500','2365500','sales','2026-11-11 13:24:34','FJ-261111-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-11-11','FJ-261111-0002','2026-11-11','13:24:34','2501','2365500','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-261111-0007','D','2026-11-11','13:24:34','sales','PENJUALAN','FJ-261111-0002','117476465','2365500','119841965'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-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-00009989','X-00009989','GL PAJERO 16CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','2454500','2026-11-11','2.620','1','sales','2026-11-11 13:45:13'); 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-00009989','X-00009989'); 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-261111-0003','FJ-261018-0006','2106','1','BELI','BELI001','MDGL', 'X-00009989', 'GL PAJERO 16CM KKT PER SHB','2.620','2.620','100.00','2908500','2454500','936832','1','2454500','2454500','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-11-11','BELI','BELI001','MDGL','MDGL','100.00','2.620','2.620','1','2.620','2.620','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-261111-0003','2026-11-11','2026-11-11','13:45:13','2106','---','2.620','2454500','2454500','2454500','2454500','2454500','sales','2026-11-11 13:45:13','FB-261111-0003','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261111-0003','DARUL QOMAR','BANGUN SARI 7/22','','SBY','','sales','2026-11-11 13:45:13'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-11' 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-261111-0008','K','2026-11-11','13:45:13','sales','PEMBELIAN UMUM','FB-261111-0003','119841965','2454500','117387465','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261111-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261111-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-11 ','16:53:07');