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 ('F325080929031','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-YGAH-159-0','GL X OVAL SLEP YT 54 8K ','','1.950','1','100.00','1726000','0','0','15000','1725000','0','0','0','1725000','SIN','00361567','F1E','0','0','-','1','890000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YGAH-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='F1E-YGAH-159-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325080929031','2025-09-08','1.950','2025-09-08','09:29:03','PLG0024834','1725000','1725000','0','1725000','1725000','input','2025-09-08 09:29:03','F32508092903');
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-09-08','F325080929031','2025-09-08','09:29:03','SIN','1725000','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-250908-0002','D','2025-09-08','09:29:03','input','PENJUALAN','F325080929031','4317000','1725000','6042000');
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2945500',harga_beli ='2945500' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8970000',harga_beli ='8970000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8910500',harga_beli ='8910500' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7445500',harga_beli ='7445500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='14950000',harga_beli ='14950000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='703000',harga_beli ='703000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0003984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8970000',harga_beli ='8970000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8970000',harga_beli ='8970000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8970000',harga_beli ='8970000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='11960000',harga_beli ='11960000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='14950000',harga_beli ='14950000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='10465000',harga_beli ='10465000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='11960000',harga_beli ='11960000' WHERE kode_barcode='T0004186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='10465000',harga_beli ='10465000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='10465000',harga_beli ='10465000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1570000',harga_beli ='1570000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='9000000',harga_beli ='9000000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1465500',harga_beli ='1465500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5935500',harga_beli ='5935500' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1510000',harga_beli ='1510000' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1465500',harga_beli ='1465500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2930500',harga_beli ='2930500' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='792500',harga_beli ='792500' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0033060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5935500',harga_beli ='5935500' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4455500',harga_beli ='4455500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='11960000',harga_beli ='11960000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='8372500',harga_beli ='8372500' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4515000',harga_beli ='4515000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0043875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4515000',harga_beli ='4515000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='3020000',harga_beli ='3020000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0043855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0043854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='777500',harga_beli ='777500' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0044194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2915500',harga_beli ='2915500' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4425500',harga_beli ='4425500' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0044175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2317500',harga_beli ='2317500' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1450500',harga_beli ='1450500' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0048353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2930500',harga_beli ='2930500' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1420500',harga_beli ='1420500' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='718000',harga_beli ='718000' WHERE kode_barcode='T0052753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='718000',harga_beli ='718000' WHERE kode_barcode='T0052755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4410500',harga_beli ='4410500' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1465500',harga_beli ='1465500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1510000',harga_beli ='1510000' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='3020000',harga_beli ='3020000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2960500',harga_beli ='2960500' WHERE kode_barcode='T0052776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7355500',harga_beli ='7355500' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2766000',harga_beli ='2766000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5905500',harga_beli ='5905500' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4425500',harga_beli ='4425500' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='14965000',harga_beli ='14965000' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='14965000',harga_beli ='14965000' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='3005000',harga_beli ='3005000' WHERE kode_barcode='T0052942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0056347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0056349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0056799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='718000',harga_beli ='718000' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='3005000',harga_beli ='3005000' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7475000',harga_beli ='7475000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2930500',harga_beli ='2930500' WHERE kode_barcode='T0056820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7505000',harga_beli ='7505000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5950500',harga_beli ='5950500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5950500',harga_beli ='5950500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='3005000',harga_beli ='3005000' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2168000',harga_beli ='2168000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1465500',harga_beli ='1465500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1465500',harga_beli ='1465500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='1495000',harga_beli ='1495000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0069558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='747500',harga_beli ='747500' WHERE kode_barcode='T0069559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2990000',harga_beli ='2990000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='5980000',harga_beli ='5980000' WHERE kode_barcode='T0069565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='7505000',harga_beli ='7505000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4485000',harga_beli ='4485000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1495000',harga_jual='4515000',harga_beli ='4515000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_group SET harga='1495000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1495000','input','2025-09-08 09:35:29');
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='T0070500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3044000',harga_beli ='3044000' WHERE kode_barcode='T0070765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3106000',harga_beli ='3106000' WHERE kode_barcode='T0070513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2205500',harga_beli ='2205500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1957000',harga_beli ='1957000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1367000',harga_beli ='1367000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1491000',harga_beli ='1491000' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1941500',harga_beli ='1941500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2516000',harga_beli ='2516000' WHERE kode_barcode='T0070503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='7004500',harga_beli ='7004500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='T0070766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3122000',harga_beli ='3122000' WHERE kode_barcode='T0070498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2656000',harga_beli ='2656000' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2019000',harga_beli ='2019000' WHERE kode_barcode='T0070496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1646500',harga_beli ='1646500' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2143500',harga_beli ='2143500' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2252000',harga_beli ='2252000' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1786000',harga_beli ='1786000' WHERE kode_barcode='T0069931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1786000',harga_beli ='1786000' WHERE kode_barcode='T0068927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1491000',harga_beli ='1491000' WHERE kode_barcode='T0068925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1398000',harga_beli ='1398000' WHERE kode_barcode='T0072608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2454000',harga_beli ='2454000' WHERE kode_barcode='T0072973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2112500',harga_beli ='2112500' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1600000',harga_beli ='1600000' WHERE kode_barcode='T0072615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1646500',harga_beli ='1646500' WHERE kode_barcode='T0072614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1522000',harga_beli ='1522000' WHERE kode_barcode='T0072613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1631000',harga_beli ='1631000' WHERE kode_barcode='T0072612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1600000',harga_beli ='1600000' WHERE kode_barcode='T0072611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1631000',harga_beli ='1631000' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1972500',harga_beli ='1972500' WHERE kode_barcode='T0068923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2066000',harga_beli ='2066000' WHERE kode_barcode='T0072323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1522000',harga_beli ='1522000' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='T0071533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1615500',harga_beli ='1615500' WHERE kode_barcode='T0071532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2066000',harga_beli ='2066000' WHERE kode_barcode='T0071528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='T0071527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3153000',harga_beli ='3153000' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3463500',harga_beli ='3463500' WHERE kode_barcode='T0070767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='T0062325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1429000',harga_beli ='1429000' WHERE kode_barcode='T0072980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3572000',harga_beli ='3572000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2283000',harga_beli ='2283000' WHERE kode_barcode='T0072984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3727500',harga_beli ='3727500' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2066000',harga_beli ='2066000' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1879500',harga_beli ='1879500' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1957000',harga_beli ='1957000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1475500',harga_beli ='1475500' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2920000',harga_beli ='2920000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2019000',harga_beli ='2019000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2500500',harga_beli ='2500500' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1941500',harga_beli ='1941500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1802000',harga_beli ='1802000' WHERE kode_barcode='T0072981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2671500',harga_beli ='2671500' WHERE kode_barcode='T0062987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='4892000',harga_beli ='4892000' WHERE kode_barcode='T0063011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3774000',harga_beli ='3774000' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1708500',harga_beli ='1708500' WHERE kode_barcode='T0062970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1584500',harga_beli ='1584500' WHERE kode_barcode='T0062991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1134000',harga_beli ='1134000' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3106000',harga_beli ='3106000' WHERE kode_barcode='T0068147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2329500',harga_beli ='2329500' WHERE kode_barcode='T0065466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1941500',harga_beli ='1941500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2718000',harga_beli ='2718000' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2920000',harga_beli ='2920000' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3106000',harga_beli ='3106000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1475500',harga_beli ='1475500' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1802000',harga_beli ='1802000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='T0062992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1491000',harga_beli ='1491000' WHERE kode_barcode='T0062994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='4426500',harga_beli ='4426500' WHERE kode_barcode='T0062996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='3696500',harga_beli ='3696500' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1569000',harga_beli ='1569000' WHERE kode_barcode='T0062999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1802000',harga_beli ='1802000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1553000',harga_jual='1522000',harga_beli ='1522000' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_group SET harga='1553000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1553000','input','2025-09-08 09:36:07');
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1225000',harga_beli ='1225000' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2041000',harga_beli ='2041000' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0025242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2481000',harga_beli ='2481000' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1177500',harga_beli ='1177500' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2669000',harga_beli ='2669000' WHERE kode_barcode='T0029887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2088500',harga_beli ='2088500' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4035000',harga_beli ='4035000' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5809000',harga_beli ='5809000' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3093000',harga_beli ='3093000' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1617500',harga_beli ='1617500' WHERE kode_barcode='T0050962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2952000',harga_beli ='2952000' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2543500',harga_beli ='2543500' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0003177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2229500',harga_beli ='2229500' WHERE kode_barcode='T0003180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2355000',harga_beli ='2355000' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3391500',harga_beli ='3391500' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2229500',harga_beli ='2229500' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2999000',harga_beli ='2999000' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1146500',harga_beli ='1146500' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='738000',harga_beli ='738000' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2041000',harga_beli ='2041000' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2151000',harga_beli ='2151000' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='785000',harga_beli ='785000' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1758500',harga_beli ='1758500' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5354000',harga_beli ='5354000' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2292500',harga_beli ='2292500' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5652000',harga_beli ='5652000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2229500',harga_beli ='2229500' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4396000',harga_beli ='4396000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3171500',harga_beli ='3171500' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2920500',harga_beli ='2920500' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2826000',harga_beli ='2826000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2920500',harga_beli ='2920500' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='12607500',harga_beli ='12607500' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2559500',harga_beli ='2559500' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2292500',harga_beli ='2292500' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='11006000',harga_beli ='11006000' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1444500',harga_beli ='1444500' WHERE kode_barcode='T0004087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6594000',harga_beli ='6594000' WHERE kode_barcode='T0072989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2229500',harga_beli ='2229500' WHERE kode_barcode='T0004055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1444500',harga_beli ='1444500' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1413000',harga_beli ='1413000' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6547000',harga_beli ='6547000' WHERE kode_barcode='T0025231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1523000',harga_beli ='1523000' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4474500',harga_beli ='4474500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3297000',harga_beli ='3297000' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2842000',harga_beli ='2842000' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3171500',harga_beli ='3171500' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='816500',harga_beli ='816500' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0008977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7740500',harga_beli ='7740500' WHERE kode_barcode='T0072987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2983000',harga_beli ='2983000' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2057000',harga_beli ='2057000' WHERE kode_barcode='T0009209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0009247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2449500',harga_beli ='2449500' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1884000',harga_beli ='1884000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2292500',harga_beli ='2292500' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='911000',harga_beli ='911000' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='973500',harga_beli ='973500' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='973500',harga_beli ='973500' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2292500',harga_beli ='2292500' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1931500',harga_beli ='1931500' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5778000',harga_beli ='5778000' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3423000',harga_beli ='3423000' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2481000',harga_beli ='2481000' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1774500',harga_beli ='1774500' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1334500',harga_beli ='1334500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2779000',harga_beli ='2779000' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2308000',harga_beli ='2308000' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2276500',harga_beli ='2276500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4317500',harga_beli ='4317500' WHERE kode_barcode='T0023419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2904500',harga_beli ='2904500' WHERE kode_barcode='T0026794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0026793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2842000',harga_beli ='2842000' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='12717000',harga_beli ='12717000' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6139000',harga_beli ='6139000' WHERE kode_barcode='T0027889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='31243500',harga_beli ='31243500' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1853000',harga_beli ='1853000' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1727500',harga_beli ='1727500' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1774500',harga_beli ='1774500' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2041000',harga_beli ='2041000' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1915500',harga_beli ='1915500' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0032982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1413000',harga_beli ='1413000' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6358500',harga_beli ='6358500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2606500',harga_beli ='2606500' WHERE kode_barcode='T0033506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1601500',harga_beli ='1601500' WHERE kode_barcode='T0033496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3894000',harga_beli ='3894000' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1099000',harga_beli ='1099000' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='T0033728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2904500',harga_beli ='2904500' WHERE kode_barcode='T0034362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1413000',harga_beli ='1413000' WHERE kode_barcode='T0034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1617500',harga_beli ='1617500' WHERE kode_barcode='T0034754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7771500',harga_beli ='7771500' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='8823500',harga_beli ='8823500' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='911000',harga_beli ='911000' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='989500',harga_beli ='989500' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2700500',harga_beli ='2700500' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1994000',harga_beli ='1994000' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='11006000',harga_beli ='11006000' WHERE kode_barcode='T0035441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1382000',harga_beli ='1382000' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4286500',harga_beli ='4286500' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2449500',harga_beli ='2449500' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1601500',harga_beli ='1601500' WHERE kode_barcode='T0038795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='T0038788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='T0037363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='942000',harga_beli ='942000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2088500',harga_beli ='2088500' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3030500',harga_beli ='3030500' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0040647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4239000',harga_beli ='4239000' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5982000',harga_beli ='5982000' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6154500',harga_beli ='6154500' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2324000',harga_beli ='2324000' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4082000',harga_beli ='4082000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3156000',harga_beli ='3156000' WHERE kode_barcode='T0041155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3140000',harga_beli ='3140000' WHERE kode_barcode='T0041153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='12764500',harga_beli ='12764500' WHERE kode_barcode='T0041179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5809000',harga_beli ='5809000' WHERE kode_barcode='T0041183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6249000',harga_beli ='6249000' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='879500',harga_beli ='879500' WHERE kode_barcode='T0041660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3454500',harga_beli ='3454500' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1523000',harga_beli ='1523000' WHERE kode_barcode='T0041676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6170500',harga_beli ='6170500' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1130500',harga_beli ='1130500' WHERE kode_barcode='T0042066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1036500',harga_beli ='1036500' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1068000',harga_beli ='1068000' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2983000',harga_beli ='2983000' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3862500',harga_beli ='3862500' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3423000',harga_beli ='3423000' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4113500',harga_beli ='4113500' WHERE kode_barcode='T0042197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1758500',harga_beli ='1758500' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4569000',harga_beli ='4569000' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1287500',harga_beli ='1287500' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1680000',harga_beli ='1680000' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='10833000',harga_beli ='10833000' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='10629000',harga_beli ='10629000' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3061500',harga_beli ='3061500' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3250000',harga_beli ='3250000' WHERE kode_barcode='T0042175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7866000',harga_beli ='7866000' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3061500',harga_beli ='3061500' WHERE kode_barcode='T0042541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1334500',harga_beli ='1334500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1601500',harga_beli ='1601500' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4396000',harga_beli ='4396000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2795000',harga_beli ='2795000' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2481000',harga_beli ='2481000' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4757500',harga_beli ='4757500' WHERE kode_barcode='T0042547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3234500',harga_beli ='3234500' WHERE kode_barcode='T0071233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2041000',harga_beli ='2041000' WHERE kode_barcode='T0042830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='15590500',harga_beli ='15590500' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0043129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1962500',harga_beli ='1962500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2072500',harga_beli ='2072500' WHERE kode_barcode='T0043110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4474500',harga_beli ='4474500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4679000',harga_beli ='4679000' WHERE kode_barcode='T0043105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4726000',harga_beli ='4726000' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4474500',harga_beli ='4474500' WHERE kode_barcode='T0043150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2669000',harga_beli ='2669000' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3956500',harga_beli ='3956500' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4945500',harga_beli ='4945500' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4836000',harga_beli ='4836000' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2512000',harga_beli ='2512000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7881500',harga_beli ='7881500' WHERE kode_barcode='T0044032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5307000',harga_beli ='5307000' WHERE kode_barcode='T0044034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6563000',harga_beli ='6563000' WHERE kode_barcode='T0072988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='785000',harga_beli ='785000' WHERE kode_barcode='T0044091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1586000',harga_beli ='1586000' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1570000',harga_beli ='1570000' WHERE kode_barcode='T0044165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0044164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1727500',harga_beli ='1727500' WHERE kode_barcode='T0044162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7928500',harga_beli ='7928500' WHERE kode_barcode='T0044195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5730500',harga_beli ='5730500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2449500',harga_beli ='2449500' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4553000',harga_beli ='4553000' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4443500',harga_beli ='4443500' WHERE kode_barcode='T0044275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3297000',harga_beli ='3297000' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3407000',harga_beli ='3407000' WHERE kode_barcode='T0044544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='8086000',harga_beli ='8086000' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3658500',harga_beli ='3658500' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0045123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1146500',harga_beli ='1146500' WHERE kode_barcode='T0045127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0045283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='T0045348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1758500',harga_beli ='1758500' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2276500',harga_beli ='2276500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4883000',harga_beli ='4883000' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3470000',harga_beli ='3470000' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2041000',harga_beli ='2041000' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3501500',harga_beli ='3501500' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1272000',harga_beli ='1272000' WHERE kode_barcode='T0046053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3250000',harga_beli ='3250000' WHERE kode_barcode='T0046088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2700500',harga_beli ='2700500' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4160500',harga_beli ='4160500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1177500',harga_beli ='1177500' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='942000',harga_beli ='942000' WHERE kode_barcode='T0047389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2135500',harga_beli ='2135500' WHERE kode_barcode='T0047390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1586000',harga_beli ='1586000' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3501500',harga_beli ='3501500' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1962500',harga_beli ='1962500' WHERE kode_barcode='T0047401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4255000',harga_beli ='4255000' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3972500',harga_beli ='3972500' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3328500',harga_beli ='3328500' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3156000',harga_beli ='3156000' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3768000',harga_beli ='3768000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='10770500',harga_beli ='10770500' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4113500',harga_beli ='4113500' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0047435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4631500',harga_beli ='4631500' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0047728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1570000',harga_beli ='1570000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='675500',harga_beli ='675500' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1821500',harga_beli ='1821500' WHERE kode_barcode='T0048992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='816500',harga_beli ='816500' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3564000',harga_beli ='3564000' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0049691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1146500',harga_beli ='1146500' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1225000',harga_beli ='1225000' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4757500',harga_beli ='4757500' WHERE kode_barcode='T0049669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4553000',harga_beli ='4553000' WHERE kode_barcode='T0049676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3266000',harga_beli ='3266000' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4757500',harga_beli ='4757500' WHERE kode_barcode='T0049679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0049682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0049684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2779000',harga_beli ='2779000' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7787500',harga_beli ='7787500' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='911000',harga_beli ='911000' WHERE kode_barcode='T0049951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3250000',harga_beli ='3250000' WHERE kode_barcode='T0050016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3014500',harga_beli ='3014500' WHERE kode_barcode='T0049966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='14774000',harga_beli ='14774000' WHERE kode_barcode='T0050021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1507500',harga_beli ='1507500' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2512000',harga_beli ='2512000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2308000',harga_beli ='2308000' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1821500',harga_beli ='1821500' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1334500',harga_beli ='1334500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0050484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3093000',harga_beli ='3093000' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3250000',harga_beli ='3250000' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1570000',harga_beli ='1570000' WHERE kode_barcode='T0050469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4883000',harga_beli ='4883000' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1758500',harga_beli ='1758500' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2606500',harga_beli ='2606500' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1068000',harga_beli ='1068000' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2119500',harga_beli ='2119500' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2606500',harga_beli ='2606500' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2119500',harga_beli ='2119500' WHERE kode_barcode='T0051705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='942000',harga_beli ='942000' WHERE kode_barcode='T0051708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='T0051739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3689500',harga_beli ='3689500' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1774500',harga_beli ='1774500' WHERE kode_barcode='T0051738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3140000',harga_beli ='3140000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2198000',harga_beli ='2198000' WHERE kode_barcode='T0051743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0051745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2308000',harga_beli ='2308000' WHERE kode_barcode='T0051746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3171500',harga_beli ='3171500' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2920500',harga_beli ='2920500' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5055500',harga_beli ='5055500' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='8258500',harga_beli ='8258500' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3454500',harga_beli ='3454500' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3705500',harga_beli ='3705500' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='18950000',harga_beli ='18950000' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='14522500',harga_beli ='14522500' WHERE kode_barcode='T0051759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4192000',harga_beli ='4192000' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4553000',harga_beli ='4553000' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='T0052831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1617500',harga_beli ='1617500' WHERE kode_barcode='T0052833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='12874500',harga_beli ='12874500' WHERE kode_barcode='T0052836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='15731500',harga_beli ='15731500' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='15810000',harga_beli ='15810000' WHERE kode_barcode='T0052840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0052841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5495000',harga_beli ='5495000' WHERE kode_barcode='T0052843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3234500',harga_beli ='3234500' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1617500',harga_beli ='1617500' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1460500',harga_beli ='1460500' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='816500',harga_beli ='816500' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0052922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4082000',harga_beli ='4082000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='T0052930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5416500',harga_beli ='5416500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='15779000',harga_beli ='15779000' WHERE kode_barcode='T0052947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6688500',harga_beli ='6688500' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5181000',harga_beli ='5181000' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5369500',harga_beli ='5369500' WHERE kode_barcode='T0052952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1256000',harga_beli ='1256000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1256000',harga_beli ='1256000' WHERE kode_barcode='T0054112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='31588500',harga_beli ='31588500' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1193500',harga_beli ='1193500' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='T0054303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1068000',harga_beli ='1068000' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1915500',harga_beli ='1915500' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3171500',harga_beli ='3171500' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2245500',harga_beli ='2245500' WHERE kode_barcode='T0054339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='13580500',harga_beli ='13580500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1680000',harga_beli ='1680000' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3297000',harga_beli ='3297000' WHERE kode_barcode='T0054332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2198000',harga_beli ='2198000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3061500',harga_beli ='3061500' WHERE kode_barcode='T0054320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4412000',harga_beli ='4412000' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6044500',harga_beli ='6044500' WHERE kode_barcode='T0054361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6123000',harga_beli ='6123000' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4600500',harga_beli ='4600500' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1821500',harga_beli ='1821500' WHERE kode_barcode='T0055401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0056279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5840500',harga_beli ='5840500' WHERE kode_barcode='T0056283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0056288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1727500',harga_beli ='1727500' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2669000',harga_beli ='2669000' WHERE kode_barcode='T0056291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2057000',harga_beli ='2057000' WHERE kode_barcode='T0056292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1884000',harga_beli ='1884000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3250000',harga_beli ='3250000' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1915500',harga_beli ='1915500' WHERE kode_barcode='T0056297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7850000',harga_beli ='7850000' WHERE kode_barcode='T0056298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='31133500',harga_beli ='31133500' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4898500',harga_beli ='4898500' WHERE kode_barcode='T0056310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2857500',harga_beli ='2857500' WHERE kode_barcode='T0056717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='31557500',harga_beli ='31557500' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0056726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2873500',harga_beli ='2873500' WHERE kode_barcode='T0056729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6516000',harga_beli ='6516000' WHERE kode_barcode='T0056734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2402500',harga_beli ='2402500' WHERE kode_barcode='T0057087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2904500',harga_beli ='2904500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2324000',harga_beli ='2324000' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1334500',harga_beli ='1334500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2276500',harga_beli ='2276500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4019500',harga_beli ='4019500' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0057124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1177500',harga_beli ='1177500' WHERE kode_barcode='T0057125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2119500',harga_beli ='2119500' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3109000',harga_beli ='3109000' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='785000',harga_beli ='785000' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1052000',harga_beli ='1052000' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1837000',harga_beli ='1837000' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4977000',harga_beli ='4977000' WHERE kode_barcode='T0057111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3140000',harga_beli ='3140000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4490500',harga_beli ='4490500' WHERE kode_barcode='T0057147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6233000',harga_beli ='6233000' WHERE kode_barcode='T0057156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='12874500',harga_beli ='12874500' WHERE kode_barcode='T0057155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7740500',harga_beli ='7740500' WHERE kode_barcode='T0057137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0057146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7928500',harga_beli ='7928500' WHERE kode_barcode='T0057141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7143500',harga_beli ='7143500' WHERE kode_barcode='T0057140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6453000',harga_beli ='6453000' WHERE kode_barcode='T0057560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1664500',harga_beli ='1664500' WHERE kode_barcode='T0058798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='973500',harga_beli ='973500' WHERE kode_barcode='T0071231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1947000',harga_beli ='1947000' WHERE kode_barcode='T0059280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='T0059276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1460500',harga_beli ='1460500' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1696000',harga_beli ='1696000' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3862500',harga_beli ='3862500' WHERE kode_barcode='T0059337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1680000',harga_beli ='1680000' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1444500',harga_beli ='1444500' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2088500',harga_beli ='2088500' WHERE kode_barcode='T0059498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1758500',harga_beli ='1758500' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4160500',harga_beli ='4160500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1727500',harga_beli ='1727500' WHERE kode_barcode='T0059517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3156000',harga_beli ='3156000' WHERE kode_barcode='T0059516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2983000',harga_beli ='2983000' WHERE kode_barcode='T0059513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2904500',harga_beli ='2904500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2842000',harga_beli ='2842000' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2669000',harga_beli ='2669000' WHERE kode_barcode='T0059505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4474500',harga_beli ='4474500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4051000',harga_beli ='4051000' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4286500',harga_beli ='4286500' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5495000',harga_beli ='5495000' WHERE kode_barcode='T0042036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='942000',harga_beli ='942000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4679000',harga_beli ='4679000' WHERE kode_barcode='T0063029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4490500',harga_beli ='4490500' WHERE kode_barcode='T0063030' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='8133000',harga_beli ='8133000' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5699500',harga_beli ='5699500' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4710000',harga_beli ='4710000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2324000',harga_beli ='2324000' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='T0064224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3297000',harga_beli ='3297000' WHERE kode_barcode='T0064225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5511000',harga_beli ='5511000' WHERE kode_barcode='T0064227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='11021500',harga_beli ='11021500' WHERE kode_barcode='T0065471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6076000',harga_beli ='6076000' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='5307000',harga_beli ='5307000' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1648500',harga_beli ='1648500' WHERE kode_barcode='T0066779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='832500',harga_beli ='832500' WHERE kode_barcode='T0068752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7881500',harga_beli ='7881500' WHERE kode_barcode='T0068740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3093000',harga_beli ='3093000' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4804500',harga_beli ='4804500' WHERE kode_barcode='T0068754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3140000',harga_beli ='3140000' WHERE kode_barcode='T0068739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0068948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='942000',harga_beli ='942000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='989500',harga_beli ='989500' WHERE kode_barcode='T0069500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='801000',harga_beli ='801000' WHERE kode_barcode='T0069501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='T0069932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1680000',harga_beli ='1680000' WHERE kode_barcode='T0069934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3171500',harga_beli ='3171500' WHERE kode_barcode='T0069935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3124500',harga_beli ='3124500' WHERE kode_barcode='T0069936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3109000',harga_beli ='3109000' WHERE kode_barcode='T0069937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4788500',harga_beli ='4788500' WHERE kode_barcode='T0069938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7866000',harga_beli ='7866000' WHERE kode_barcode='T0070158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='7646000',harga_beli ='7646000' WHERE kode_barcode='T0070159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6421500',harga_beli ='6421500' WHERE kode_barcode='T0070160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='958000',harga_beli ='958000' WHERE kode_barcode='T0070495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='16061500',harga_beli ='16061500' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4082000',harga_beli ='4082000' WHERE kode_barcode='T0070515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='18809000',harga_beli ='18809000' WHERE kode_barcode='T0070516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1099000',harga_beli ='1099000' WHERE kode_barcode='T0070763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0071530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='6107500',harga_beli ='6107500' WHERE kode_barcode='T0071525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3909500',harga_beli ='3909500' WHERE kode_barcode='T0071526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4851500',harga_beli ='4851500' WHERE kode_barcode='T0071529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='8007500',harga_beli ='8007500' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='738000',harga_beli ='738000' WHERE kode_barcode='T0072605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='738000',harga_beli ='738000' WHERE kode_barcode='T0072637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3737000',harga_beli ='3737000' WHERE kode_barcode='T0072606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='879500',harga_beli ='879500' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='3328500',harga_beli ='3328500' WHERE kode_barcode='T0072633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='4773000',harga_beli ='4773000' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='706500',harga_beli ='706500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1570000',harga_jual='864000',harga_beli ='864000' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_group SET harga='1570000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1570000','input','2025-09-08 09:36:21');
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4221500',harga_beli ='4221500' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='746000',harga_beli ='746000' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3222000',harga_beli ='3222000' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3967500',harga_beli ='3967500' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='8030500',harga_beli ='8030500' WHERE kode_barcode='T0002682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4840500',harga_beli ='4840500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4713500',harga_beli ='4713500' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6364000',harga_beli ='6364000' WHERE kode_barcode='T0002701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3491500',harga_beli ='3491500' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4872500',harga_beli ='4872500' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0062974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4285000',harga_beli ='4285000' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3936000',harga_beli ='3936000' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1984000',harga_beli ='1984000' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2634500',harga_beli ='2634500' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='7872000',harga_beli ='7872000' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='5126500',harga_beli ='5126500' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='5174000',harga_beli ='5174000' WHERE kode_barcode='T0027907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2857000',harga_beli ='2857000' WHERE kode_barcode='T0027964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1904500',harga_beli ='1904500' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='23757500',harga_beli ='23757500' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='10807500',harga_beli ='10807500' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6523000',harga_beli ='6523000' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='5428000',harga_beli ='5428000' WHERE kode_barcode='T0021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3507500',harga_beli ='3507500' WHERE kode_barcode='T0021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1270000',harga_beli ='1270000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='809500',harga_beli ='809500' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4396500',harga_beli ='4396500' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3349000',harga_beli ='3349000' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6824500',harga_beli ='6824500' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2269500',harga_beli ='2269500' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4809000',harga_beli ='4809000' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1032000',harga_beli ='1032000' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='23805000',harga_beli ='23805000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3364500',harga_beli ='3364500' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3364500',harga_beli ='3364500' WHERE kode_barcode='T0031224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='12807500',harga_beli ='12807500' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='12537500',harga_beli ='12537500' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='8110000',harga_beli ='8110000' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2317500',harga_beli ='2317500' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4936000',harga_beli ='4936000' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4380500',harga_beli ='4380500' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3095000',harga_beli ='3095000' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6237000',harga_beli ='6237000' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2396500',harga_beli ='2396500' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1190500',harga_beli ='1190500' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3444000',harga_beli ='3444000' WHERE kode_barcode='T0035428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='15568500',harga_beli ='15568500' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1349000',harga_beli ='1349000' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2968000',harga_beli ='2968000' WHERE kode_barcode='T0037241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='11347500',harga_beli ='11347500' WHERE kode_barcode='T0037438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='825500',harga_beli ='825500' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1587000',harga_beli ='1587000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1381000',harga_beli ='1381000' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1539500',harga_beli ='1539500' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3603000',harga_beli ='3603000' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='746000',harga_beli ='746000' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='15489500',harga_beli ='15489500' WHERE kode_barcode='T0038814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3285500',harga_beli ='3285500' WHERE kode_barcode='T0039187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2507500',harga_beli ='2507500' WHERE kode_barcode='T0040115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='11236000',harga_beli ='11236000' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='8094000',harga_beli ='8094000' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4126500',harga_beli ='4126500' WHERE kode_barcode='T0040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4459500',harga_beli ='4459500' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4951500',harga_beli ='4951500' WHERE kode_barcode='T0040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6364000',harga_beli ='6364000' WHERE kode_barcode='T0040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3412500',harga_beli ='3412500' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3349000',harga_beli ='3349000' WHERE kode_barcode='T0041160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2317500',harga_beli ='2317500' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='16108500',harga_beli ='16108500' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='825500',harga_beli ='825500' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4840500',harga_beli ='4840500' WHERE kode_barcode='T0071235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='9474500',harga_beli ='9474500' WHERE kode_barcode='T0042400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2396500',harga_beli ='2396500' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='952500',harga_beli ='952500' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4666000',harga_beli ='4666000' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='920500',harga_beli ='920500' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1746000',harga_beli ='1746000' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1032000',harga_beli ='1032000' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='809500',harga_beli ='809500' WHERE kode_barcode='T0044160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4126500',harga_beli ='4126500' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='8125500',harga_beli ='8125500' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='873000',harga_beli ='873000' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3142500',harga_beli ='3142500' WHERE kode_barcode='T0046373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1492000',harga_beli ='1492000' WHERE kode_barcode='T0072991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2428500',harga_beli ='2428500' WHERE kode_barcode='T0047403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='873000',harga_beli ='873000' WHERE kode_barcode='T0047406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4840500',harga_beli ='4840500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='5554500',harga_beli ='5554500' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2016000',harga_beli ='2016000' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1032000',harga_beli ='1032000' WHERE kode_barcode='T0049706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4682000',harga_beli ='4682000' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3222000',harga_beli ='3222000' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6507000',harga_beli ='6507000' WHERE kode_barcode='T0050927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3412500',harga_beli ='3412500' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='809500',harga_beli ='809500' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1857000',harga_beli ='1857000' WHERE kode_barcode='T0051698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='920500',harga_beli ='920500' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4301000',harga_beli ='4301000' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1460500',harga_beli ='1460500' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1063500',harga_beli ='1063500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1000000',harga_beli ='1000000' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1159000',harga_beli ='1159000' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='7380000',harga_beli ='7380000' WHERE kode_barcode='T0052782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4920000',harga_beli ='4920000' WHERE kode_barcode='T0052784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='7983000',harga_beli ='7983000' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1762000',harga_beli ='1762000' WHERE kode_barcode='T0052907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1666500',harga_beli ='1666500' WHERE kode_barcode='T0052915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1603000',harga_beli ='1603000' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4412000',harga_beli ='4412000' WHERE kode_barcode='T0052938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6110000',harga_beli ='6110000' WHERE kode_barcode='T0054364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3412500',harga_beli ='3412500' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='5554500',harga_beli ='5554500' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1746000',harga_beli ='1746000' WHERE kode_barcode='T0056709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2952000',harga_beli ='2952000' WHERE kode_barcode='T0056728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1666500',harga_beli ='1666500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1317500',harga_beli ='1317500' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6427500',harga_beli ='6427500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='6237000',harga_beli ='6237000' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3238000',harga_beli ='3238000' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='825500',harga_beli ='825500' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='889000',harga_beli ='889000' WHERE kode_barcode='T0065973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='9760500',harga_beli ='9760500' WHERE kode_barcode='T0059340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1159000',harga_beli ='1159000' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='19139500',harga_beli ='19139500' WHERE kode_barcode='T0059379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='15791000',harga_beli ='15791000' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='9411000',harga_beli ='9411000' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='8110000',harga_beli ='8110000' WHERE kode_barcode='T0063023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='873000',harga_beli ='873000' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2238000',harga_beli ='2238000' WHERE kode_barcode='T0068917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0068933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='3253500',harga_beli ='3253500' WHERE kode_barcode='T0070154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='2460000',harga_beli ='2460000' WHERE kode_barcode='T0070155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0070492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0070494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1936500',harga_beli ='1936500' WHERE kode_barcode='T0070507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='1079500',harga_beli ='1079500' WHERE kode_barcode='T0070764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4713500',harga_beli ='4713500' WHERE kode_barcode='T0071515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4666000',harga_beli ='4666000' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='4650000',harga_beli ='4650000' WHERE kode_barcode='T0072636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1587000',harga_jual='793500',harga_beli ='793500' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_group SET harga='1587000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1587000','input','2025-09-08 09:36:42');
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3304500',harga_beli ='3304500' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='1123000',harga_beli ='1123000' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5021000',harga_beli ='5021000' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='1091000',harga_beli ='1091000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3850000',harga_beli ='3850000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='6288000',harga_beli ='6288000' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5726500',harga_beli ='5726500' WHERE kode_barcode='T0050025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4988500',harga_beli ='4988500' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4668000',harga_beli ='4668000' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2037500',harga_beli ='2037500' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='6544500',harga_beli ='6544500' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='7828000',harga_beli ='7828000' WHERE kode_barcode='T0057162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5261500',harga_beli ='5261500' WHERE kode_barcode='T0059521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='802000',harga_beli ='802000' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='8116500',harga_beli ='8116500' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='674000',harga_beli ='674000' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5373500',harga_beli ='5373500' WHERE kode_barcode='T0065474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2358000',harga_beli ='2358000' WHERE kode_barcode='T0069579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2406000',harga_beli ='2406000' WHERE kode_barcode='T0069580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='T0069582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2294000',harga_beli ='2294000' WHERE kode_barcode='T0069583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='T0069584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3256500',harga_beli ='3256500' WHERE kode_barcode='T0070517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='658000',harga_beli ='658000' WHERE kode_barcode='T0070519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='6512500',harga_beli ='6512500' WHERE kode_barcode='T0065449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3096000',harga_beli ='3096000' WHERE kode_barcode='T0069911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4828500',harga_beli ='4828500' WHERE kode_barcode='T0072632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='417500',harga_beli ='417500' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='12992500',harga_beli ='12992500' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3288500',harga_beli ='3288500' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='577500',harga_beli ='577500' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4908500',harga_beli ='4908500' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4122500',harga_beli ='4122500' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3769500',harga_beli ='3769500' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4587500',harga_beli ='4587500' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='7539000',harga_beli ='7539000' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5213000',harga_beli ='5213000' WHERE kode_barcode='T0031228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5566000',harga_beli ='5566000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3401000',harga_beli ='3401000' WHERE kode_barcode='T0031706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='11228000',harga_beli ='11228000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3962000',harga_beli ='3962000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='9752500',harga_beli ='9752500' WHERE kode_barcode='T0033028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='12672000',harga_beli ='12672000' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='8213000',harga_beli ='8213000' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3336500',harga_beli ='3336500' WHERE kode_barcode='T0033858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='19104000',harga_beli ='19104000' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='674000',harga_beli ='674000' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='12752000',harga_beli ='12752000' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3449000',harga_beli ='3449000' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='11228000',harga_beli ='11228000' WHERE kode_barcode='T0038313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='16072500',harga_beli ='16072500' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='6015000',harga_beli ='6015000' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='8036500',harga_beli ='8036500' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='5069000',harga_beli ='5069000' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='8180500',harga_beli ='8180500' WHERE kode_barcode='T0042655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1604000',harga_jual='3208000',harga_beli ='3208000' WHERE kode_barcode='T0043700' LIMIT 1;
UPDATE tm_group SET harga='1604000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1604000','input','2025-09-08 09:36:59');
UPDATE tm_barang SET harga_skrg ='1621000',harga_jual='19663000',harga_beli ='19663000' WHERE kode_barcode='T0038815' LIMIT 1;
UPDATE tm_group SET harga='1621000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1621000','input','2025-09-08 09:37:10');
UPDATE tm_group SET harga='1638000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','1638000','input','2025-09-08 09:37:25');
UPDATE tm_group SET harga='1655000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','1655000','input','2025-09-08 09:37:35');
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 ('F325080955171','input','1',' MDA1 CM ','TOKO','PM-A','A1D-YIXD-160-0','AT MODEL MATA VAR CM 8K ','','0.860','1','100.00','747000','0','0','15000','748000','0','0','0','748000','FIT','00367917','A1D','0','0','-','0','873000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIXD-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='A1D-YIXD-160-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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 ('F325080955171','2025-09-08','0.860','2025-09-08','09:55:18','PLG0024835','748000','748000','0','748000','748000','input','2025-09-08 09:55:17','F32508095517');
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-09-08','F325080955171','2025-09-08','09:55:18','FIT','748000','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-250908-0003','D','2025-09-08','09:55:18','input','PENJUALAN','F325080955171','6042000','748000','6790000');
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 ('F325081023081','input','1',' MEF1 PM 38','TOKO','PM-F','F1E-YCXE-266-0','GL BANGKOK KACA ANAK PM 38 8K ','','1.570','1','100.00','1389000','0','0','15000','1390000','0','0','0','1390000','FIT','00342071','F1E','0','0','-','0','890000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YCXE-266-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='F1E-YCXE-266-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325081023081','2025-09-08','1.570','2025-09-08','10:23:08','PLG0024836','1390000','1390000','0','1390000','1390000','input','2025-09-08 10:23:08','F32508102308');
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-09-08','F325081023081','2025-09-08','10:23:08','FIT','1390000','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-250908-0004','D','2025-09-08','10:23:08','input','PENJUALAN','F325081023081','6790000','1390000','8180000');
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 ('F325081048521','input','1',' MEH1 KH 42','TOKO','PM-H','H1E-YGAF-232-0','KL SANTA KH 42CM 8K ','','1.550','1','100.00','1372000','0','0','15000','1373000','0','0','0','1373000','FIT','00361058','H1E','0','0','-','0','890000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGAF-232-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='H1E-YGAF-232-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 ('F325081048521','2025-09-08','1.550','2025-09-08','10:48:53','PLG0024837','1373000','1373000','0','1373000','1373000','input','2025-09-08 10:48:52','F32508104852');
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-09-08','F325081048521','2025-09-08','10:48:53','FIT','1373000','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-250908-0005','D','2025-09-08','10:48:53','input','PENJUALAN','F325081048521','8180000','1373000','9553000');
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 ('F325081052201','input','1',' MFA1F X PM','TOKO','PM-A','A1F-YHXI-12-0','AT X MODEL ARESO SLEP PM 8K ','','0.570','1','100.00','514000','0','0','15000','515000','0','0','0','515000','SIN','00364876','A1F','0','0','-','0','902000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHXI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='A1F-YHXI-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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 ('F325081052201','2025-09-08','0.570','2025-09-08','10:52:21','PLG0024838','515000','515000','0','515000','515000','input','2025-09-08 10:52:20','F32508105220');
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-09-08','F325081052201','2025-09-08','10:52:21','SIN','515000','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-250908-0006','D','2025-09-08','10:52:21','input','PENJUALAN','F325081052201','9553000','515000','10068000');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250908-0001','1','A1E-YGXE-343-0','1','1.100','TOKO','SBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YGXE-343-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1E-YGXE-343-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-A';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1E-YGXE-343-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.100',berat_out_asli='1.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.100',berat_akhir_asli =berat_akhir_asli-'1.100' WHERE kode_barang='A1E-YGXE-343-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-250908-0001','2025-09-08','2025-09-08','11:36','1.100','admpindah','250908');
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 ('F325081145521','input','1',' MEF3E XXX ','TOKO','PM-F','F3E-YEXE-339-0','GL XXX CAPELLA SLEP HW 8K ','','1.860','1','100.00','1646000','0','0','15000','1645000','0','0','0','1645000','FIT','00353222','F3E','0','0','-','1','890000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YEXE-339-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='F3E-YEXE-339-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325081145521','2025-09-08','1.860','2025-09-08','11:45:52','PLG0024839','1645000','1645000','0','1645000','1645000','input','2025-09-08 11:45:52','F32508114552');
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-09-08','F325081145521','2025-09-08','11:45:52','FIT','1645000','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-250908-0007','D','2025-09-08','11:45:52','input','PENJUALAN','F325081145521','10068000','1645000','11713000');
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 ('F325081155331','input','1',' MCB0C DG ','TOKO','PM-B','B0C-YAXG-107-0','GW BOTORAN DG 8K ','','0.510','1','100.00','434000','0','0','15000','435000','0','0','0','435000','FIT','00332921','B0C','0','0','-','0','851000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YAXG-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='B0C-YAXG-107-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325081155331','2025-09-08','0.510','2025-09-08','11:55:33','PLG0024840','435000','435000','0','435000','435000','input','2025-09-08 11:55:33','F32508115533');
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-09-08','F325081155331','2025-09-08','11:55:33','FIT','435000','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-250908-0008','D','2025-09-08','11:55:33','input','PENJUALAN','F325081155331','11713000','435000','12148000');
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-250908-0001','1','H1F-YHAE-2-0','1','0.920','0.920','TOKO','PM-H','TOKO','SBK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-H' WHERE kode_barang='H1F-YHAE-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H';
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-09-08','TOKO','SBK-H','H1F','H1F-YHAE-2-0','100.00','1','0.920','0.920','1','0.920','0.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-08' AND kode_barang='H1F-YHAE-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H' 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-250908-0001','2025-09-08','2025-09-08','12:45','0.92','input','2025-09-08 12:46:33');
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-250908-0002','1','H1F-YHAE-73-0','1','1.020','1.020','TOKO','PM-H','TOKO','MBK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MBK-H' WHERE kode_barang='H1F-YHAE-73-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H';
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-09-08','TOKO','MBK-H','H1F','H1F-YHAE-73-0','100.00','1','1.020','1.020','1','1.020','1.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.020',berat_out_asli=berat_out_asli+'1.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-08' AND kode_barang='H1F-YHAE-73-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0;
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-250908-0002','2','H1F-YGBD-120-0','1','1.000','1.000','TOKO','PM-H','TOKO','MBK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MBK-H' WHERE kode_barang='H1F-YGBD-120-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H';
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-09-08','TOKO','MBK-H','H1F','H1F-YGBD-120-0','100.00','1','1.000','1.000','1','1.000','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-08' AND kode_barang='H1F-YGBD-120-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-H' 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-250908-0002','2025-09-08','2025-09-08','12:48','2.02','input','2025-09-08 12:50:32');
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-00016937','X-00016937','GL OVAL MODEL C UB D56 8K','GR','---','F1E','BELI','BELI001','1430000','2025-09-08','2.270','1','kasir','2025-09-08 12:57:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016937','X-00016937');
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-250908-0001','F325170907071','FIT','1','BELI','BELI001','F1E', 'X-00016937', 'GL OVAL MODEL C UB D56 8K','2.270','2.270','100.00','1685000','1430000','629956','890000','1','1430000','1430000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.270',berat_beli_asli=berat_beli_asli+'2.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.270',berat_akhir_asli=berat_akhir_asli+'2.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-08' 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-250908-0001','2025-09-08','2025-09-08','12:57:15','FIT','---','2.270','1430000','1430000','1430000','1430000','1430000','kasir','2025-09-08 12:57:16','FB-250908-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250908-0001','TUTIK','JOHO PURWANTORO','','','','kasir','2025-09-08 12:57:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-08' 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-250908-0009','K','2025-09-08','12:57:15','kasir','PEMBELIAN UMUM','FB-250908-0001','12148000','1430000','10718000');
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-00016938','X-00016938','GL X OVAL C UB 58','GR','---','F1E','BELI','BELI001','2730000','2025-09-08','4.720','1','kasir','2025-09-08 12:58:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016938','X-00016938');
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-250908-0002','F322081211081','AAT','1','BELI','BELI001','F1E', 'X-00016938', 'GL X OVAL C UB 58','4.720','4.720','100.00','2055000','2730000','578390','890000','1','2730000','2730000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.720',berat_beli_asli=berat_beli_asli+'4.720',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.720',berat_akhir_asli=berat_akhir_asli+'4.720',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-08' 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-250908-0002','2025-09-08','2025-09-08','12:58:13','AAT','---','4.720','2730000','2730000','2730000','2730000','2730000','kasir','2025-09-08 12:58:13','FB-250908-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250908-0002','RIRIN HANDAYANI','SENAYU BITING','','','','kasir','2025-09-08 12:58:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-08' 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-250908-0010','K','2025-09-08','12:58:13','kasir','PEMBELIAN UMUM','FB-250908-0002','10718000','2730000','7988000');
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-00016939','X-00016939','GL X OVAL C YT 54','GR','---','F1E','BELI','BELI001','1695000','2025-09-08','2.950','1','kasir','2025-09-08 13:02:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016939','X-00016939');
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-250908-0003','F324121236231','FIT','1','BELI','BELI001','F1E', 'X-00016939', 'GL X OVAL C YT 54','2.950','2.950','100.00','1720000','1695000','574576','890000','1','1695000','1695000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-08' 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-250908-0003','2025-09-08','2025-09-08','13:02:46','FIT','---','2.950','1695000','1695000','1695000','1695000','1695000','kasir','2025-09-08 13:02:47','FB-250908-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250908-0003','ASIH','TEGALREJO','','','','kasir','2025-09-08 13:02:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-08' 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-250908-0011','K','2025-09-08','13:02:46','kasir','PEMBELIAN UMUM','FB-250908-0003','7988000','1695000','6293000');
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 ('F325080123281','kasir','1',' MGB1 UB ','TOKO','PM-B','B1G-XGXI-370-0','GW TRIXIE PANJANG BINTANG VAR UB 8K ','','0.320','1','100.00','294000','0','0','15000','295000','0','0','0','295000','SIN','00306984','B1G','0','0','-','0','924000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-XGXI-370-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='B1G-XGXI-370-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325080123281','2025-09-08','0.320','2025-09-08','13:23:28','PLG0024841','295000','295000','0','295000','295000','kasir','2025-09-08 13:23:28','F32508012328');
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-09-08','F325080123281','2025-09-08','13:23:28','SIN','295000','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-250908-0012','D','2025-09-08','13:23:28','kasir','PENJUALAN','F325080123281','6293000','295000','6588000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='295000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325080123281' 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 ('F325080123282','kasir',' 1',' MEH1 15K K','TOKO','PM-H','H1E-YDAE-11-0','KL SANTA MODEL HATI MATA VAR KH 8K ','','2.740','1','100.00','2425000','0','0','15000','2425000','0','15000','0','2440000','SIN','00349480','H1E','0','0','-','0','890000');
UPDATE tm_barang SET tgl_last_jual='2025-09-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YDAE-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.740',berat_jual_asli=berat_jual_asli+'2.740',stock_jual='1',berat_akhir=berat_akhir-'2.740',berat_akhir_asli=berat_akhir_asli-'2.740',stock_akhir='0' WHERE tanggal='2025-09-08' AND kode_barang='H1E-YDAE-11-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 ('F325080123282','2025-09-08','2.740','2025-09-08','13:23:28','PLG0024842','2425000','2425000','15000','2440000','2440000','kasir','2025-09-08 13:23:28','F32508012328');
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-09-08','F325080123282','2025-09-08','13:23:28','SIN','2440000','15000');
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-250908-0013','D','2025-09-08','13:23:28','kasir','PENJUALAN','F325080123282','6588000','2440000','9028000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2440000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325080123282' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080123281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080123281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080123281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080123282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080123282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080123282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080929031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080929031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080929031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080955171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080955171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080955171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081023081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081023081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081023081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081048521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081048521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081048521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081052201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081052201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081052201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081145521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081145521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081145521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081155331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081155331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081155331';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250908-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250908-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250908-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250908-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250908-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250908-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-08';
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-09-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-08' 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-250909-0001','D','2025-09-09','15:14:39','SYSTEM','SALDO AWAL','SALDO AWAL','0','9028000','9028000');
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-250909-0001','D','2025-09-09','15:14:39','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-250909-0001','D','2025-09-09','15:14:39','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-250909-0001','D','2025-09-09','15:14:39','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-09-09';