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,status_otorisasi,harga_skrg) VALUES ('F325230824291','input','1',' TFB1 X HK ','TOKO','PT-B','B1TF-YFBF-127-T','GW X TOGE MODEL MATA VAR HK 17K ','','0.500','1','100.00','957000','0','0','15000','958000','0','0','0','958000','AAT','T0070494','B1TF','0','0','-','0','1915000');
UPDATE tm_barang SET tgl_last_jual='2025-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YFBF-127-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-23' AND kode_barang='B1TF-YFBF-127-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-B' 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 ('F325230824291','2025-10-23','0.500','2025-10-23','08:24:30','PLG0025370','958000','958000','0','958000','958000','input','2025-10-23 08:24:29','F32523082429');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-23','F325230824291','2025-10-23','08:24:30','AAT','958000','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-251023-0002','D','2025-10-23','08:24:30','input','PENJUALAN','F325230824291','445422000','958000','446380000');
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3546000',harga_beli ='3546000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10800000',harga_beli ='10800000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10728000',harga_beli ='10728000' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='8964000',harga_beli ='8964000' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='18000000',harga_beli ='18000000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='846000',harga_beli ='846000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10800000',harga_beli ='10800000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10800000',harga_beli ='10800000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10800000',harga_beli ='10800000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='14400000',harga_beli ='14400000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='18000000',harga_beli ='18000000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='12600000',harga_beli ='12600000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='14400000',harga_beli ='14400000' WHERE kode_barcode='T0004186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='12600000',harga_beli ='12600000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='12600000',harga_beli ='12600000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1890000',harga_beli ='1890000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10836000',harga_beli ='10836000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7146000',harga_beli ='7146000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1818000',harga_beli ='1818000' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3528000',harga_beli ='3528000' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='954000',harga_beli ='954000' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0033060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7146000',harga_beli ='7146000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5364000',harga_beli ='5364000' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='14400000',harga_beli ='14400000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='10080000',harga_beli ='10080000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2610000',harga_beli ='2610000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5436000',harga_beli ='5436000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5436000',harga_beli ='5436000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3636000',harga_beli ='3636000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0043855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0043854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='936000',harga_beli ='936000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0044194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3510000',harga_beli ='3510000' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0044175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2790000',harga_beli ='2790000' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1746000',harga_beli ='1746000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2718000',harga_beli ='2718000' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0048353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3528000',harga_beli ='3528000' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1710000',harga_beli ='1710000' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0052755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5310000',harga_beli ='5310000' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1818000',harga_beli ='1818000' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3636000',harga_beli ='3636000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3564000',harga_beli ='3564000' WHERE kode_barcode='T0052776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='8856000',harga_beli ='8856000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3330000',harga_beli ='3330000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7110000',harga_beli ='7110000' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='18018000',harga_beli ='18018000' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='18018000',harga_beli ='18018000' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0056349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3618500',harga_beli ='3618500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3528000',harga_beli ='3528000' WHERE kode_barcode='T0056820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9036000',harga_beli ='9036000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7164000',harga_beli ='7164000' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7164000',harga_beli ='7164000' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3618500',harga_beli ='3618500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2610000',harga_beli ='2610000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0069558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='900000',harga_beli ='900000' WHERE kode_barcode='T0069559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0069565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='9036000',harga_beli ='9036000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1800000',harga_jual='5436000',harga_beli ='5436000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_group SET harga='1800000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1800000','input','2025-10-23 12:32:36');
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1470500',harga_beli ='1470500' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1847500',harga_beli ='1847500' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='T0029887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2507500',harga_beli ='2507500' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6974500',harga_beli ='6974500' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3713500',harga_beli ='3713500' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4712500',harga_beli ='4712500' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1942000',harga_beli ='1942000' WHERE kode_barcode='T0050962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3544000',harga_beli ='3544000' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3054000',harga_beli ='3054000' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0003177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='T0003180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2827500',harga_beli ='2827500' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4072000',harga_beli ='4072000' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3600500',harga_beli ='3600500' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1376500',harga_beli ='1376500' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2582500',harga_beli ='2582500' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3695000',harga_beli ='3695000' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='942500',harga_beli ='942500' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6428000',harga_beli ='6428000' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2752500',harga_beli ='2752500' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6786000',harga_beli ='6786000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5278000',harga_beli ='5278000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3808000',harga_beli ='3808000' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3393000',harga_beli ='3393000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='15137000',harga_beli ='15137000' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3073000',harga_beli ='3073000' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2752500',harga_beli ='2752500' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2865500',harga_beli ='2865500' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='13214000',harga_beli ='13214000' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1734500',harga_beli ='1734500' WHERE kode_barcode='T0004087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3525000',harga_beli ='3525000' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7917000',harga_beli ='7917000' WHERE kode_barcode='T0072989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='T0004055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1734500',harga_beli ='1734500' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7860500',harga_beli ='7860500' WHERE kode_barcode='T0025231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2601500',harga_beli ='2601500' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1828500',harga_beli ='1828500' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5372500',harga_beli ='5372500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3412000',harga_beli ='3412000' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3808000',harga_beli ='3808000' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='980500',harga_beli ='980500' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1074500',harga_beli ='1074500' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0008977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9293500',harga_beli ='9293500' WHERE kode_barcode='T0072987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3581500',harga_beli ='3581500' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2469500',harga_beli ='2469500' WHERE kode_barcode='T0009209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0009247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1565000',harga_beli ='1565000' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2941000',harga_beli ='2941000' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2262000',harga_beli ='2262000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2752500',harga_beli ='2752500' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1093500',harga_beli ='1093500' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1169000',harga_beli ='1169000' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1169000',harga_beli ='1169000' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2752500',harga_beli ='2752500' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2319000',harga_beli ='2319000' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6937000',harga_beli ='6937000' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4109500',harga_beli ='4109500' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2130500',harga_beli ='2130500' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3336500',harga_beli ='3336500' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2771000',harga_beli ='2771000' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2733500',harga_beli ='2733500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5184000',harga_beli ='5184000' WHERE kode_barcode='T0023419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6126500',harga_beli ='6126500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3487500',harga_beli ='3487500' WHERE kode_barcode='T0026794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1847500',harga_beli ='1847500' WHERE kode_barcode='T0026793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3412000',harga_beli ='3412000' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='15268500',harga_beli ='15268500' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7370500',harga_beli ='7370500' WHERE kode_barcode='T0027889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='37511500',harga_beli ='37511500' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2224500',harga_beli ='2224500' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2130500',harga_beli ='2130500' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3695000',harga_beli ='3695000' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1037000',harga_beli ='1037000' WHERE kode_barcode='T0032982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7634500',harga_beli ='7634500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3129500',harga_beli ='3129500' WHERE kode_barcode='T0033506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='T0033496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4675000',harga_beli ='4675000' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1319500',harga_beli ='1319500' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2959500',harga_beli ='2959500' WHERE kode_barcode='T0033728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1621500',harga_beli ='1621500' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3487500',harga_beli ='3487500' WHERE kode_barcode='T0034362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='T0034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3318000',harga_beli ='3318000' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1942000',harga_beli ='1942000' WHERE kode_barcode='T0034754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9331000',harga_beli ='9331000' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='10594000',harga_beli ='10594000' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1093500',harga_beli ='1093500' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1188000',harga_beli ='1188000' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3242500',harga_beli ='3242500' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='13214000',harga_beli ='13214000' WHERE kode_barcode='T0035441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1659000',harga_beli ='1659000' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5146500',harga_beli ='5146500' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2941000',harga_beli ='2941000' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='T0038795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='T0038788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2281000',harga_beli ='2281000' WHERE kode_barcode='T0037363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2507500',harga_beli ='2507500' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3638500',harga_beli ='3638500' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0040647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5089500',harga_beli ='5089500' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7182000',harga_beli ='7182000' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7389500',harga_beli ='7389500' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2959500',harga_beli ='2959500' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2790000',harga_beli ='2790000' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4901000',harga_beli ='4901000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3525000',harga_beli ='3525000' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0041153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='15325500',harga_beli ='15325500' WHERE kode_barcode='T0041179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6974500',harga_beli ='6974500' WHERE kode_barcode='T0041183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7502500',harga_beli ='7502500' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1828500',harga_beli ='1828500' WHERE kode_barcode='T0041676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7408500',harga_beli ='7408500' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1357500',harga_beli ='1357500' WHERE kode_barcode='T0042066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1244500',harga_beli ='1244500' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1282000',harga_beli ='1282000' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3581500',harga_beli ='3581500' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4637500',harga_beli ='4637500' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4109500',harga_beli ='4109500' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4939000',harga_beli ='4939000' WHERE kode_barcode='T0042197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5485500',harga_beli ='5485500' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2413000',harga_beli ='2413000' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1546000',harga_beli ='1546000' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='13006500',harga_beli ='13006500' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='12761500',harga_beli ='12761500' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3676000',harga_beli ='3676000' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9444000',harga_beli ='9444000' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3676000',harga_beli ='3676000' WHERE kode_barcode='T0042541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5278000',harga_beli ='5278000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3355500',harga_beli ='3355500' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5712000',harga_beli ='5712000' WHERE kode_barcode='T0042547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3883500',harga_beli ='3883500' WHERE kode_barcode='T0071233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='T0042830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='18718500',harga_beli ='18718500' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1074500',harga_beli ='1074500' WHERE kode_barcode='T0043129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2356500',harga_beli ='2356500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3035000',harga_beli ='3035000' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5372500',harga_beli ='5372500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='T0043105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5674000',harga_beli ='5674000' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5372500',harga_beli ='5372500' WHERE kode_barcode='T0043150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4750500',harga_beli ='4750500' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5938000',harga_beli ='5938000' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5806000',harga_beli ='5806000' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3016000',harga_beli ='3016000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9463000',harga_beli ='9463000' WHERE kode_barcode='T0044032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6371500',harga_beli ='6371500' WHERE kode_barcode='T0044034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7879500',harga_beli ='7879500' WHERE kode_barcode='T0072988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='942500',harga_beli ='942500' WHERE kode_barcode='T0044091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1904000',harga_beli ='1904000' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1885000',harga_beli ='1885000' WHERE kode_barcode='T0044165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1847500',harga_beli ='1847500' WHERE kode_barcode='T0044164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0044162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9519500',harga_beli ='9519500' WHERE kode_barcode='T0044195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6880500',harga_beli ='6880500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2941000',harga_beli ='2941000' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5466500',harga_beli ='5466500' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5335000',harga_beli ='5335000' WHERE kode_barcode='T0044275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4090500',harga_beli ='4090500' WHERE kode_barcode='T0044544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9708000',harga_beli ='9708000' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4392500',harga_beli ='4392500' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1376500',harga_beli ='1376500' WHERE kode_barcode='T0045127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0045283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3318000',harga_beli ='3318000' WHERE kode_barcode='T0045348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2413000',harga_beli ='2413000' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2733500',harga_beli ='2733500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5862500',harga_beli ='5862500' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2413000',harga_beli ='2413000' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4204000',harga_beli ='4204000' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4712500',harga_beli ='4712500' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1527000',harga_beli ='1527000' WHERE kode_barcode='T0046053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3902000',harga_beli ='3902000' WHERE kode_barcode='T0046088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3242500',harga_beli ='3242500' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4995500',harga_beli ='4995500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0047389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1904000',harga_beli ='1904000' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4204000',harga_beli ='4204000' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5108500',harga_beli ='5108500' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4769500',harga_beli ='4769500' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2846500',harga_beli ='2846500' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4656000',harga_beli ='4656000' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3996500',harga_beli ='3996500' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3789000',harga_beli ='3789000' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4524000',harga_beli ='4524000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='12931500',harga_beli ='12931500' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4939000',harga_beli ='4939000' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0047435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5561000',harga_beli ='5561000' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0047728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1885000',harga_beli ='1885000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='811000',harga_beli ='811000' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2187000',harga_beli ='2187000' WHERE kode_barcode='T0048992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='980500',harga_beli ='980500' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4279000',harga_beli ='4279000' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2413000',harga_beli ='2413000' WHERE kode_barcode='T0049691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1376500',harga_beli ='1376500' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1470500',harga_beli ='1470500' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5712000',harga_beli ='5712000' WHERE kode_barcode='T0049669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3921000',harga_beli ='3921000' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5712000',harga_beli ='5712000' WHERE kode_barcode='T0049679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0049682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0049684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3336500',harga_beli ='3336500' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9350000',harga_beli ='9350000' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='8200000',harga_beli ='8200000' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1093500',harga_beli ='1093500' WHERE kode_barcode='T0049951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3902000',harga_beli ='3902000' WHERE kode_barcode='T0050016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3619500',harga_beli ='3619500' WHERE kode_barcode='T0049966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='17738000',harga_beli ='17738000' WHERE kode_barcode='T0050021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1810000',harga_beli ='1810000' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3016000',harga_beli ='3016000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2771000',harga_beli ='2771000' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2187000',harga_beli ='2187000' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0050484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3713500',harga_beli ='3713500' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3902000',harga_beli ='3902000' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1885000',harga_beli ='1885000' WHERE kode_barcode='T0050469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5862500',harga_beli ='5862500' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3318000',harga_beli ='3318000' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3129500',harga_beli ='3129500' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1282000',harga_beli ='1282000' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2545000',harga_beli ='2545000' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3129500',harga_beli ='3129500' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2545000',harga_beli ='2545000' WHERE kode_barcode='T0051705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0051708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='T0051739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4430000',harga_beli ='4430000' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2130500',harga_beli ='2130500' WHERE kode_barcode='T0051738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2092500',harga_beli ='2092500' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2639000',harga_beli ='2639000' WHERE kode_barcode='T0051743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1847500',harga_beli ='1847500' WHERE kode_barcode='T0051745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2771000',harga_beli ='2771000' WHERE kode_barcode='T0051746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3808000',harga_beli ='3808000' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6070000',harga_beli ='6070000' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9915500',harga_beli ='9915500' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4449000',harga_beli ='4449000' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='22752000',harga_beli ='22752000' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='17436500',harga_beli ='17436500' WHERE kode_barcode='T0051759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5033000',harga_beli ='5033000' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5466500',harga_beli ='5466500' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1565000',harga_beli ='1565000' WHERE kode_barcode='T0052831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1942000',harga_beli ='1942000' WHERE kode_barcode='T0052833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2413000',harga_beli ='2413000' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='15457500',harga_beli ='15457500' WHERE kode_barcode='T0052836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='18888000',harga_beli ='18888000' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='18982000',harga_beli ='18982000' WHERE kode_barcode='T0052840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9557000',harga_beli ='9557000' WHERE kode_barcode='T0052841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6597500',harga_beli ='6597500' WHERE kode_barcode='T0052843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3883500',harga_beli ='3883500' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1942000',harga_beli ='1942000' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1753500',harga_beli ='1753500' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='980500',harga_beli ='980500' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1225500',harga_beli ='1225500' WHERE kode_barcode='T0052922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4901000',harga_beli ='4901000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2846500',harga_beli ='2846500' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2959500',harga_beli ='2959500' WHERE kode_barcode='T0052930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6503500',harga_beli ='6503500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='18944500',harga_beli ='18944500' WHERE kode_barcode='T0052947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='8030500',harga_beli ='8030500' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6220500',harga_beli ='6220500' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6447000',harga_beli ='6447000' WHERE kode_barcode='T0052952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1508000',harga_beli ='1508000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1508000',harga_beli ='1508000' WHERE kode_barcode='T0054112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='37926500',harga_beli ='37926500' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1433000',harga_beli ='1433000' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0054303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1282000',harga_beli ='1282000' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2092500',harga_beli ='2092500' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3808000',harga_beli ='3808000' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2696000',harga_beli ='2696000' WHERE kode_barcode='T0054339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='16305500',harga_beli ='16305500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='T0054332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2846500',harga_beli ='2846500' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2639000',harga_beli ='2639000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3676000',harga_beli ='3676000' WHERE kode_barcode='T0054320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5297000',harga_beli ='5297000' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7257500',harga_beli ='7257500' WHERE kode_barcode='T0054361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7351500',harga_beli ='7351500' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5523500',harga_beli ='5523500' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2092500',harga_beli ='2092500' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1037000',harga_beli ='1037000' WHERE kode_barcode='T0056279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7012500',harga_beli ='7012500' WHERE kode_barcode='T0056283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0056288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='T0056291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2469500',harga_beli ='2469500' WHERE kode_barcode='T0056292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2092500',harga_beli ='2092500' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2262000',harga_beli ='2262000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3902000',harga_beli ='3902000' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0056297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9425000',harga_beli ='9425000' WHERE kode_barcode='T0056298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='37380000',harga_beli ='37380000' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5881500',harga_beli ='5881500' WHERE kode_barcode='T0056310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1037000',harga_beli ='1037000' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4712500',harga_beli ='4712500' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='37888500',harga_beli ='37888500' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0056726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3450000',harga_beli ='3450000' WHERE kode_barcode='T0056729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7823000',harga_beli ='7823000' WHERE kode_barcode='T0056734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2884500',harga_beli ='2884500' WHERE kode_barcode='T0057087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3487500',harga_beli ='3487500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2790000',harga_beli ='2790000' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2733500',harga_beli ='2733500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4826000',harga_beli ='4826000' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2922000',harga_beli ='2922000' WHERE kode_barcode='T0057124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0057125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2545000',harga_beli ='2545000' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3035000',harga_beli ='3035000' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3732500',harga_beli ='3732500' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='942500',harga_beli ='942500' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1263000',harga_beli ='1263000' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2205500',harga_beli ='2205500' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5391500',harga_beli ='5391500' WHERE kode_barcode='T0057147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7483500',harga_beli ='7483500' WHERE kode_barcode='T0057156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='15457500',harga_beli ='15457500' WHERE kode_barcode='T0057155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9293500',harga_beli ='9293500' WHERE kode_barcode='T0057137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0057146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9519500',harga_beli ='9519500' WHERE kode_barcode='T0057141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='8577000',harga_beli ='8577000' WHERE kode_barcode='T0057140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7747500',harga_beli ='7747500' WHERE kode_barcode='T0057560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1998500',harga_beli ='1998500' WHERE kode_barcode='T0058798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1169000',harga_beli ='1169000' WHERE kode_barcode='T0071231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2337500',harga_beli ='2337500' WHERE kode_barcode='T0059280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2959500',harga_beli ='2959500' WHERE kode_barcode='T0059276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1753500',harga_beli ='1753500' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2036000',harga_beli ='2036000' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4637500',harga_beli ='4637500' WHERE kode_barcode='T0059337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1734500',harga_beli ='1734500' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4995500',harga_beli ='4995500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0059517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3789000',harga_beli ='3789000' WHERE kode_barcode='T0059516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3487500',harga_beli ='3487500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3412000',harga_beli ='3412000' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='T0059505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5372500',harga_beli ='5372500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4863500',harga_beli ='4863500' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5146500',harga_beli ='5146500' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6597500',harga_beli ='6597500' WHERE kode_barcode='T0042036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='T0063029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5391500',harga_beli ='5391500' WHERE kode_barcode='T0063030' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9764500',harga_beli ='9764500' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6843000',harga_beli ='6843000' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5655000',harga_beli ='5655000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2790000',harga_beli ='2790000' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='T0064224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='T0064225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6616500',harga_beli ='6616500' WHERE kode_barcode='T0064227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7295000',harga_beli ='7295000' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='6371500',harga_beli ='6371500' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1979500',harga_beli ='1979500' WHERE kode_barcode='T0066779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1847500',harga_beli ='1847500' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='999500',harga_beli ='999500' WHERE kode_barcode='T0068752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9463000',harga_beli ='9463000' WHERE kode_barcode='T0068740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3713500',harga_beli ='3713500' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5768500',harga_beli ='5768500' WHERE kode_barcode='T0068754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0068739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2865500',harga_beli ='2865500' WHERE kode_barcode='T0068948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1188000',harga_beli ='1188000' WHERE kode_barcode='T0069500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='961500',harga_beli ='961500' WHERE kode_barcode='T0069501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3827000',harga_beli ='3827000' WHERE kode_barcode='T0069932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='T0069934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='3751500',harga_beli ='3751500' WHERE kode_barcode='T0069936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5749500',harga_beli ='5749500' WHERE kode_barcode='T0069938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9444000',harga_beli ='9444000' WHERE kode_barcode='T0070158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9180000',harga_beli ='9180000' WHERE kode_barcode='T0070159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7710000',harga_beli ='7710000' WHERE kode_barcode='T0070160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1074500',harga_beli ='1074500' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='19284000',harga_beli ='19284000' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4901000',harga_beli ='4901000' WHERE kode_barcode='T0070515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='22582500',harga_beli ='22582500' WHERE kode_barcode='T0070516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1319500',harga_beli ='1319500' WHERE kode_barcode='T0070763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7333000',harga_beli ='7333000' WHERE kode_barcode='T0071525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4694000',harga_beli ='4694000' WHERE kode_barcode='T0071526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5825000',harga_beli ='5825000' WHERE kode_barcode='T0071529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='9613500',harga_beli ='9613500' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0072605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='4486500',harga_beli ='4486500' WHERE kode_barcode='T0072606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1056000',harga_beli ='1056000' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='5730500',harga_beli ='5730500' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='848500',harga_beli ='848500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1037000',harga_beli ='1037000' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='7446000',harga_beli ='7446000' WHERE kode_barcode='T0073721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1885000',harga_jual='1150000',harga_beli ='1150000' WHERE kode_barcode='T0073761' LIMIT 1;
UPDATE tm_group SET harga='1885000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1885000','input','2025-10-23 12:33:00');
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='T0070500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='T0070766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3655500',harga_beli ='3655500' WHERE kode_barcode='T0070765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3730000',harga_beli ='3730000' WHERE kode_barcode='T0070513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2648500',harga_beli ='2648500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2350000',harga_beli ='2350000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1641500',harga_beli ='1641500' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1790500',harga_beli ='1790500' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2331500',harga_beli ='2331500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='8411500',harga_beli ='8411500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3786000',harga_beli ='3786000' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3749000',harga_beli ='3749000' WHERE kode_barcode='T0070498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3189500',harga_beli ='3189500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2424500',harga_beli ='2424500' WHERE kode_barcode='T0070496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1977000',harga_beli ='1977000' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2574000',harga_beli ='2574000' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2704500',harga_beli ='2704500' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1790500',harga_beli ='1790500' WHERE kode_barcode='T0068925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2369000',harga_beli ='2369000' WHERE kode_barcode='T0068923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1958500',harga_beli ='1958500' WHERE kode_barcode='T0072612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2294000',harga_beli ='2294000' WHERE kode_barcode='T0073765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2947000',harga_beli ='2947000' WHERE kode_barcode='T0073759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1548000',harga_beli ='1548000' WHERE kode_barcode='T0073760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2947000',harga_beli ='2947000' WHERE kode_barcode='T0072973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2536500',harga_beli ='2536500' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1921000',harga_beli ='1921000' WHERE kode_barcode='T0072615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1977000',harga_beli ='1977000' WHERE kode_barcode='T0072614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1828000',harga_beli ='1828000' WHERE kode_barcode='T0072613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1361500',harga_beli ='1361500' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1921000',harga_beli ='1921000' WHERE kode_barcode='T0072611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1958500',harga_beli ='1958500' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2201000',harga_beli ='2201000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2480500',harga_beli ='2480500' WHERE kode_barcode='T0072323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1828000',harga_beli ='1828000' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1940000',harga_beli ='1940000' WHERE kode_barcode='T0071532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2480500',harga_beli ='2480500' WHERE kode_barcode='T0071528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1865000',harga_beli ='1865000' WHERE kode_barcode='T0071527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3823500',harga_beli ='3823500' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1716000',harga_beli ='1716000' WHERE kode_barcode='T0072980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4289500',harga_beli ='4289500' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2742000',harga_beli ='2742000' WHERE kode_barcode='T0072984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4476000',harga_beli ='4476000' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1865000',harga_beli ='1865000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2480500',harga_beli ='2480500' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2257000',harga_beli ='2257000' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2350000',harga_beli ='2350000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3991500',harga_beli ='3991500' WHERE kode_barcode='T0062325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2424500',harga_beli ='2424500' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3003000',harga_beli ='3003000' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2331500',harga_beli ='2331500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='T0072981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3208000',harga_beli ='3208000' WHERE kode_barcode='T0062987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5875000',harga_beli ='5875000' WHERE kode_barcode='T0063011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1865000',harga_beli ='1865000' WHERE kode_barcode='T0062992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3730000',harga_beli ='3730000' WHERE kode_barcode='T0068147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2797500',harga_beli ='2797500' WHERE kode_barcode='T0065466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2331500',harga_beli ='2331500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3264000',harga_beli ='3264000' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3730000',harga_beli ='3730000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1772000',harga_beli ='1772000' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1790500',harga_beli ='1790500' WHERE kode_barcode='T0062994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5315500',harga_beli ='5315500' WHERE kode_barcode='T0062996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4439000',harga_beli ='4439000' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1884000',harga_beli ='1884000' WHERE kode_barcode='T0062999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1828000',harga_beli ='1828000' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='1772000',harga_beli ='1772000' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_group SET harga='1865000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1865000','input','2025-10-23 12:33:35');
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5067500',harga_beli ='5067500' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='895500',harga_beli ='895500' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3867500',harga_beli ='3867500' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9639500',harga_beli ='9639500' WHERE kode_barcode='T0002682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5810500',harga_beli ='5810500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5658000',harga_beli ='5658000' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7639500',harga_beli ='7639500' WHERE kode_barcode='T0002701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4191500',harga_beli ='4191500' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5848500',harga_beli ='5848500' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5143500',harga_beli ='5143500' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4724500',harga_beli ='4724500' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2381500',harga_beli ='2381500' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3162500',harga_beli ='3162500' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9449000',harga_beli ='9449000' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='6153500',harga_beli ='6153500' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1143000',harga_beli ='1143000' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3429000',harga_beli ='3429000' WHERE kode_barcode='T0027964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2286000',harga_beli ='2286000' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='28518000',harga_beli ='28518000' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='12973500',harga_beli ='12973500' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7830000',harga_beli ='7830000' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4210500',harga_beli ='4210500' WHERE kode_barcode='T0021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1524000',harga_beli ='1524000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='972000',harga_beli ='972000' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5277000',harga_beli ='5277000' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='8191500',harga_beli ='8191500' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2724500',harga_beli ='2724500' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4000500',harga_beli ='4000500' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5772500',harga_beli ='5772500' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1238500',harga_beli ='1238500' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='28575000',harga_beli ='28575000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='T0031224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='15373500',harga_beli ='15373500' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='15049500',harga_beli ='15049500' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9735000',harga_beli ='9735000' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2781500',harga_beli ='2781500' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5258000',harga_beli ='5258000' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3715000',harga_beli ='3715000' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7487000',harga_beli ='7487000' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2877000',harga_beli ='2877000' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1429000',harga_beli ='1429000' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4134000',harga_beli ='4134000' WHERE kode_barcode='T0035428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18688500',harga_beli ='18688500' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1086000',harga_beli ='1086000' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1619500',harga_beli ='1619500' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3562500',harga_beli ='3562500' WHERE kode_barcode='T0037241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='13621000',harga_beli ='13621000' WHERE kode_barcode='T0037438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='991000',harga_beli ='991000' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1905000',harga_beli ='1905000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1657500',harga_beli ='1657500' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1848000',harga_beli ='1848000' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4324500',harga_beli ='4324500' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='895500',harga_beli ='895500' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18593000',harga_beli ='18593000' WHERE kode_barcode='T0038814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3943500',harga_beli ='3943500' WHERE kode_barcode='T0039187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3010000',harga_beli ='3010000' WHERE kode_barcode='T0040115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='13487500',harga_beli ='13487500' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9715500',harga_beli ='9715500' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4953000',harga_beli ='4953000' WHERE kode_barcode='T0040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5353500',harga_beli ='5353500' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5944000',harga_beli ='5944000' WHERE kode_barcode='T0040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7639500',harga_beli ='7639500' WHERE kode_barcode='T0040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4096000',harga_beli ='4096000' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='T0041160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2781500',harga_beli ='2781500' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3962500',harga_beli ='3962500' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19336000',harga_beli ='19336000' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='991000',harga_beli ='991000' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5810500',harga_beli ='5810500' WHERE kode_barcode='T0071235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11373000',harga_beli ='11373000' WHERE kode_barcode='T0042400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2877000',harga_beli ='2877000' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1143000',harga_beli ='1143000' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5601000',harga_beli ='5601000' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1105000',harga_beli ='1105000' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2096000',harga_beli ='2096000' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1238500',harga_beli ='1238500' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='972000',harga_beli ='972000' WHERE kode_barcode='T0044160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4953000',harga_beli ='4953000' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9754000',harga_beli ='9754000' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3772000',harga_beli ='3772000' WHERE kode_barcode='T0046373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='T0072991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2915000',harga_beli ='2915000' WHERE kode_barcode='T0047403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='T0047406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5810500',harga_beli ='5810500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='6667500',harga_beli ='6667500' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2572000',harga_beli ='2572000' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2419500',harga_beli ='2419500' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1238500',harga_beli ='1238500' WHERE kode_barcode='T0049706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5620000',harga_beli ='5620000' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3867500',harga_beli ='3867500' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7811000',harga_beli ='7811000' WHERE kode_barcode='T0050927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4096000',harga_beli ='4096000' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='972000',harga_beli ='972000' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4000500',harga_beli ='4000500' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1105000',harga_beli ='1105000' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5163000',harga_beli ='5163000' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1753000',harga_beli ='1753000' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1276500',harga_beli ='1276500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1200500',harga_beli ='1200500' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1391000',harga_beli ='1391000' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='8858500',harga_beli ='8858500' WHERE kode_barcode='T0052782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5905500',harga_beli ='5905500' WHERE kode_barcode='T0052784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9582500',harga_beli ='9582500' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2115000',harga_beli ='2115000' WHERE kode_barcode='T0052907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2572000',harga_beli ='2572000' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2000500',harga_beli ='2000500' WHERE kode_barcode='T0052915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1924500',harga_beli ='1924500' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5296000',harga_beli ='5296000' WHERE kode_barcode='T0052938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7334500',harga_beli ='7334500' WHERE kode_barcode='T0054364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4096000',harga_beli ='4096000' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='6667500',harga_beli ='6667500' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2096000',harga_beli ='2096000' WHERE kode_barcode='T0056709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3543500',harga_beli ='3543500' WHERE kode_barcode='T0056728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2000500',harga_beli ='2000500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1581500',harga_beli ='1581500' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7715500',harga_beli ='7715500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7487000',harga_beli ='7487000' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3886500',harga_beli ='3886500' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='991000',harga_beli ='991000' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11716000',harga_beli ='11716000' WHERE kode_barcode='T0059340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1391000',harga_beli ='1391000' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18955000',harga_beli ='18955000' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11297000',harga_beli ='11297000' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9735000',harga_beli ='9735000' WHERE kode_barcode='T0063023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2686500',harga_beli ='2686500' WHERE kode_barcode='T0068917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3905500',harga_beli ='3905500' WHERE kode_barcode='T0070154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0070492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2324500',harga_beli ='2324500' WHERE kode_barcode='T0070507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1295500',harga_beli ='1295500' WHERE kode_barcode='T0070764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5658000',harga_beli ='5658000' WHERE kode_barcode='T0071515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5601000',harga_beli ='5601000' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5582000',harga_beli ='5582000' WHERE kode_barcode='T0072636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1734000',harga_beli ='1734000' WHERE kode_barcode='T0073762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1333500',harga_beli ='1333500' WHERE kode_barcode='T0073763' LIMIT 1;
UPDATE tm_group SET harga='1905000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1905000','input','2025-10-23 12:34:14');
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='962500',harga_beli ='962500' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='808500',harga_beli ='808500' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1347500',harga_beli ='1347500' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6025500',harga_beli ='6025500' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1309000',harga_beli ='1309000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4620000',harga_beli ='4620000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7546000',harga_beli ='7546000' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6872500',harga_beli ='6872500' WHERE kode_barcode='T0050025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5987000',harga_beli ='5987000' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5602000',harga_beli ='5602000' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2445000',harga_beli ='2445000' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7854000',harga_beli ='7854000' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9394000',harga_beli ='9394000' WHERE kode_barcode='T0057162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6314000',harga_beli ='6314000' WHERE kode_barcode='T0059521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3850000',harga_beli ='3850000' WHERE kode_barcode='T0043700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9740500',harga_beli ='9740500' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3965500',harga_beli ='3965500' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4928000',harga_beli ='4928000' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2830000',harga_beli ='2830000' WHERE kode_barcode='T0069579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2887500',harga_beli ='2887500' WHERE kode_barcode='T0069580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2849000',harga_beli ='2849000' WHERE kode_barcode='T0069582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2753000',harga_beli ='2753000' WHERE kode_barcode='T0069583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2849000',harga_beli ='2849000' WHERE kode_barcode='T0069584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3908000',harga_beli ='3908000' WHERE kode_barcode='T0070517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7816000',harga_beli ='7816000' WHERE kode_barcode='T0065449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3715500',harga_beli ='3715500' WHERE kode_barcode='T0069911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5794500',harga_beli ='5794500' WHERE kode_barcode='T0072632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='500500',harga_beli ='500500' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='11704000',harga_beli ='11704000' WHERE kode_barcode='T0033028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3946500',harga_beli ='3946500' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='693000',harga_beli ='693000' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5890500',harga_beli ='5890500' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4947500',harga_beli ='4947500' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4524000',harga_beli ='4524000' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5505500',harga_beli ='5505500' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9047500',harga_beli ='9047500' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6256500',harga_beli ='6256500' WHERE kode_barcode='T0031228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6680000',harga_beli ='6680000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4081000',harga_beli ='4081000' WHERE kode_barcode='T0031706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='13475000',harga_beli ='13475000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5813500',harga_beli ='5813500' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4755000',harga_beli ='4755000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='15207500',harga_beli ='15207500' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='15592500',harga_beli ='15592500' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9856000',harga_beli ='9856000' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4004000',harga_beli ='4004000' WHERE kode_barcode='T0033858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='22927000',harga_beli ='22927000' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='808500',harga_beli ='808500' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='15304000',harga_beli ='15304000' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4139000',harga_beli ='4139000' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='19288500',harga_beli ='19288500' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7219000',harga_beli ='7219000' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9644500',harga_beli ='9644500' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6083000',harga_beli ='6083000' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9817500',harga_beli ='9817500' WHERE kode_barcode='T0042655' LIMIT 1;
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1925000','input','2025-10-23 12:34:36');
UPDATE tm_barang SET harga_skrg ='1945000',harga_jual='23593000',harga_beli ='23593000' WHERE kode_barcode='T0038815' LIMIT 1;
UPDATE tm_group SET harga='1945000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1945000','input','2025-10-23 12:35:06');
UPDATE tm_group SET harga='1965000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','1965000','input','2025-10-23 12:35:34');
UPDATE tm_group SET harga='1985000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','1985000','input','2025-10-23 12:36:20');
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,status_otorisasi,harga_skrg) VALUES ('F325231249311','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-YJAC-115-0','KL X SANTA KH 44 9K ','','3.000','1','100.00','3405000','0','0','15000','3405000','0','0','0','3405000','AAT','00372845','H2I','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2025-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YJAC-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-10-23' AND kode_barang='H2I-YJAC-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F325231249311','2025-10-23','3.000','2025-10-23','12:49:32','PLG0025371','3405000','3405000','0','3405000','3405000','input','2025-10-23 12:49:31','F32523124931');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-23','F325231249311','2025-10-23','12:49:32','AAT','3405000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251023-0003','D','2025-10-23','12:49:32','input','PENJUALAN','F325231249311','446380000','3405000','449785000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325231249311' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325231249312','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-YJXF-55-0','CC WEDDING MATA CM 12 8K ','','1.510','1','100.00','1563000','0','0','15000','1563000','0','10000','0','1573000','AAT','00372352','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXF-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-10-23' AND kode_barang='E2D-YJXF-55-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F325231249312','2025-10-23','1.510','2025-10-23','12:49:32','PLG0025372','1563000','1563000','10000','1573000','1573000','input','2025-10-23 12:49:31','F32523124931');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-23','F325231249312','2025-10-23','12:49:32','AAT','1573000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251023-0004','D','2025-10-23','12:49:32','input','PENJUALAN','F325231249312','449785000','1573000','451358000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325231249312' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325230103071','input','1',' MJH3 X UB ','TOKO','PM-H','H3J-XFAI-10-0','KL X SANTA ANAK BONEKA VAR UB 34 9K ','','2.450','1','100.00','2830000','0','0','15000','2830000','0','0','0','2830000','SIN','00303104','H3J','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2025-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-XFAI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-10-23' AND kode_barang='H3J-XFAI-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F325230103071','2025-10-23','2.450','2025-10-23','13:03:07','PLG0025373','2830000','2830000','0','2830000','2830000','input','2025-10-23 13:03:07','F32523010307');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-23','F325230103071','2025-10-23','13:03:07','SIN','2830000','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-251023-0005','D','2025-10-23','13:03:07','input','PENJUALAN','F325230103071','451358000','2830000','454188000');
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,status_otorisasi,harga_skrg) VALUES ('F325230104411','input','1',' MFH1 UB 34','TOKO','PM-H','H1F-YIXD-202-0','KL MILANO ANAK UB 34 8K ','','2.050','1','100.00','2204000','0','0','15000','2205000','0','0','0','2205000','SIN','00367959','H1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2025-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIXD-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-10-23' AND kode_barang='H1F-YIXD-202-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F325230104411','2025-10-23','2.050','2025-10-23','13:04:41','PLG0025374','2205000','2205000','0','2205000','2205000','input','2025-10-23 13:04:41','F32523010441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-23','F325230104411','2025-10-23','13:04:41','SIN','2205000','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-251023-0006','D','2025-10-23','13:04:41','input','PENJUALAN','F325230104411','454188000','2205000','456393000');
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-00017290','X-00017290','CC COR M 8K','GR','---','E2D','BELI','BELI001','930000','2025-10-23','1.060','1','kasir','2025-10-23 14:03:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017290','X-00017290');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0001','t0073060','AAT','1','BELI','BELI001','E2D', 'X-00017290', 'CC COR M 8K','1.060','1.060','100.00','1012000','930000','877358','1035000','1','930000','930000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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) VALUES ('FB-251023-0001','2025-10-23','2025-10-23','14:03:43','AAT','---','1.060','930000','930000','930000','930000','930000','kasir','2025-10-23 14:03:44','FB-251023-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0001','WAHYUDI','PURWANTORO','','','','kasir','2025-10-23 14:03:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0007','K','2025-10-23','14:03:43','kasir','PEMBELIAN UMUM','FB-251023-0001','456393000','930000','455463000');
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-00017291','X-00017291','CC X POLOS DG 16 8K','GR','---','E0C','BELI','BELI001','915000','2025-10-23','1.010','1','kasir','2025-10-23 14:05:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0C';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0C','X-00017291','X-00017291');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0002','F325130819161','AAT','1','BELI','BELI001','E0C', 'X-00017291', 'CC X POLOS DG 16 8K','1.010','1.010','100.00','983000','915000','905941','1015000','1','915000','915000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0C' 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) VALUES ('FB-251023-0002','2025-10-23','2025-10-23','14:05:51','AAT','---','1.010','915000','915000','915000','915000','915000','kasir','2025-10-23 14:05:51','FB-251023-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0002','DARMI','BITING BADEGAN','','','','kasir','2025-10-23 14:05:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0008','K','2025-10-23','14:05:51','kasir','PEMBELIAN UMUM','FB-251023-0002','455463000','915000','454548000');
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-00017292','X-00017292','GW X MODEL HURUF MATA LG PE A 8K','GR','---','B1F','BELI','BELI001','185000','2025-10-23','0.290','1','kasir','2025-10-23 14:06:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017292','X-00017292');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0003','F324030157251','FIT','1','BELI','BELI001','B1F', 'X-00017292', 'GW X MODEL HURUF MATA LG PE A 8K','0.550','0.290','100.00','365000','185000','637931','1075000','1','185000','185000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.290',berat_beli_asli=berat_beli_asli+'0.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.290',berat_akhir_asli=berat_akhir_asli+'0.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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) VALUES ('FB-251023-0003','2025-10-23','2025-10-23','14:06:24','FIT','---','0.290','185000','185000','185000','185000','185000','kasir','2025-10-23 14:06:25','FB-251023-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0003','YENI','BULUKERTO','','','','kasir','2025-10-23 14:06:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0009','K','2025-10-23','14:06:24','kasir','PEMBELIAN UMUM','FB-251023-0003','454548000','185000','454363000');
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-00017293','X-00017293','GL OVAL MODEL C UB D58 8K','GR','---','F1E','BELI','BELI001','1760000','2025-10-23','2.370','1','kasir','2025-10-23 14:06:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017293','X-00017293');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0004','F325151225251','FIT','1','BELI','BELI001','F1E', 'X-00017293', 'GL OVAL MODEL C UB D58 8K','2.370','2.370','100.00','1725000','1760000','742616','1065000','1','1760000','1760000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.370',berat_beli_asli=berat_beli_asli+'2.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.370',berat_akhir_asli=berat_akhir_asli+'2.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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) VALUES ('FB-251023-0004','2025-10-23','2025-10-23','14:06:55','FIT','---','2.370','1760000','1760000','1760000','1760000','1760000','kasir','2025-10-23 14:06:56','FB-251023-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0004','NARMI','SANGGRONG','','','','kasir','2025-10-23 14:06:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0010','K','2025-10-23','14:06:55','kasir','PEMBELIAN UMUM','FB-251023-0004','454363000','1760000','452603000');
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-00017294','X-00017294','LT MODEL MATA UB','GR','---','D2E','BELI','BELI001','2400000','2025-10-23','3.300','1','kasir','2025-10-23 14:07:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017294','X-00017294');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0005','F324120944401','FIT','1','BELI','BELI001','D2E', 'X-00017294', 'LT MODEL MATA UB','3.300','3.300','100.00','2190000','2400000','727273','1065000','1','2400000','2400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.300',berat_beli_asli=berat_beli_asli+'3.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.300',berat_akhir_asli=berat_akhir_asli+'3.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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) VALUES ('FB-251023-0005','2025-10-23','2025-10-23','14:07:23','FIT','---','3.300','2400000','2400000','2400000','2400000','2400000','kasir','2025-10-23 14:07:23','FB-251023-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0005','BU TEN','DAGANGAN BULUKERTO','','','','kasir','2025-10-23 14:07:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0011','K','2025-10-23','14:07:23','kasir','PEMBELIAN UMUM','FB-251023-0005','452603000','2400000','450203000');
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-00017295','X-00017295','KL X KOREA PANJANG KH 64 9K','GR','---','H2I','BELI','BELI001','9560000','2025-10-23','10.030','1','kasir','2025-10-23 14:07:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017295','X-00017295');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0006','F325260145301','FIT','1','BELI','BELI001','H2I', 'X-00017295', 'KL X KOREA PANJANG KH 64 9K','10.030','10.030','100.00','10280000','9560000','953141','1135000','1','9560000','9560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.030',berat_beli_asli=berat_beli_asli+'10.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.030',berat_akhir_asli=berat_akhir_asli+'10.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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) VALUES ('FB-251023-0006','2025-10-23','2025-10-23','14:07:40','FIT','---','10.030','9560000','9560000','9560000','9560000','9560000','kasir','2025-10-23 14:07:40','FB-251023-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0006','BU TIN','NGERJO BULUKERTO','','','','kasir','2025-10-23 14:07:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0012','K','2025-10-23','14:07:40','kasir','PEMBELIAN UMUM','FB-251023-0006','450203000','9560000','440643000');
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-00017296','X-00017296','CC X BANGKOK SLEP KH 22 8K','GR','---','E1D','BELI','BELI001','805000','2025-10-23','0.910','1','kasir','2025-10-23 14:08:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017296','X-00017296');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0007','F325040206361','SIN','1','BELI','BELI001','E1D', 'X-00017296', 'CC X BANGKOK SLEP KH 22 8K','0.910','0.910','100.00','865000','805000','884615','1035000','1','805000','805000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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) VALUES ('FB-251023-0007','2025-10-23','2025-10-23','14:08:05','SIN','---','0.910','805000','805000','805000','805000','805000','kasir','2025-10-23 14:08:05','FB-251023-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0007','MBAH RUK','MANGLU KISMANTORO','','','','kasir','2025-10-23 14:08:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0013','K','2025-10-23','14:08:05','kasir','PEMBELIAN UMUM','FB-251023-0007','440643000','805000','439838000');
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-00017297','X-00017297','KL X GUCCI ANAK UB 34 9K','GR','---','H2J','BELI','BELI001','1190000','2025-10-23','1.100','1','kasir','2025-10-23 14:08:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017297','X-00017297');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0008','F325191047471','SIN','1','BELI','BELI001','H2J', 'X-00017297', 'KL X GUCCI ANAK UB 34 9K','1.100','1.100','100.00','1280000','1190000','1081818','1165000','1','1190000','1190000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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) VALUES ('FB-251023-0008','2025-10-23','2025-10-23','14:08:27','SIN','---','1.100','1190000','1190000','1190000','1190000','1190000','kasir','2025-10-23 14:08:28','FB-251023-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0008','DENA','JERUK','','','','kasir','2025-10-23 14:08:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0014','K','2025-10-23','14:08:27','kasir','PEMBELIAN UMUM','FB-251023-0008','439838000','1190000','438648000');
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-00017298','X-00017298','CC X MODEL MATA LG 12 8K','GR','---','E2E','BELI','BELI001','387000','2025-10-23','0.510','1','kasir','2025-10-23 14:09:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017298','X-00017298');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0009','F325300121461','SIN','1','BELI','BELI001','E2E', 'X-00017298', 'CC X MODEL MATA LG 12 8K','0.510','0.510','100.00','418000','387000','758824','1065000','1','387000','387000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-251023-0009','2025-10-23','2025-10-23','14:09:16','SIN','---','0.510','387000','387000','387000','387000','387000','kasir','2025-10-23 14:09:16','FB-251023-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0009','RIKA','BULUREJO BULUKERTO','','','','kasir','2025-10-23 14:09:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0015','K','2025-10-23','14:09:16','kasir','PEMBELIAN UMUM','FB-251023-0009','438648000','387000','438261000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251023-0001','1','E2TE-YFAA-81-T','1','2.030','2.030','TOKO','PT-E','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TBK-E' WHERE kode_barang='E2TE-YFAA-81-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-23','TOKO','TBK-E','E2TE','E2TE-YFAA-81-T','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-23' AND kode_barang='E2TE-YFAA-81-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251023-0001','2025-10-23','2025-10-23','15:04','2.03','input','2025-10-23 15:05:16');
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-00017299','X-00017299','CC COR T 17K','GR','---','E1TE','BELI','BELI001','1500000','2025-10-23','1.030','1','kasir','2025-10-23 15:11:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00017299','X-00017299');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251023-0010','F321221250581','FIT','1','BELI','BELI001','E1TE', 'X-00017299', 'CC COR T 17K','1.030','1.030','100.00','721000','1500000','1456311','1885000','1','1500000','1500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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) VALUES ('FB-251023-0010','2025-10-23','2025-10-23','15:11:04','FIT','---','1.030','1500000','1500000','1500000','1500000','1500000','kasir','2025-10-23 15:11:04','FB-251023-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251023-0010','MUJIATI','BITING','','','','kasir','2025-10-23 15:11:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-23' 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) VALUES ('KK-251023-0016','K','2025-10-23','15:11:04','kasir','PEMBELIAN UMUM','FB-251023-0010','438261000','1500000','436761000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325230103071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325230103071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325230103071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325230104411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325230104411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325230104411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325230824291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325230824291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325230824291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325231249311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325231249311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325231249311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325231249312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325231249312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325231249312';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251023-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251023-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-23';
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='2025-10-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-23' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-251024-0001','D','2025-10-24','16:01:08','SYSTEM','SALDO AWAL','SALDO AWAL','0','436761000','436761000');
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-251024-0001','D','2025-10-24','16:01:08','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251024-0001','D','2025-10-24','16:01:08','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251024-0001','D','2025-10-24','16:01:08','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-10-24';