X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=UpdateCurrencyRate.php;h=0c0fe04d6b6cfb5c4b7596f8e8938230ddf5866d;hp=2bf7b74b635b656a73ea104f1716b705aeeb1933;hb=refs%2Fheads%2Fwip_alan_T5884_add_photo_to_report;hpb=ed71b9a4fd1a45a9836d94f0739c2496e6891cb3 diff --git a/UpdateCurrencyRate.php b/UpdateCurrencyRate.php index 2bf7b74b..0c0fe04d 100644 --- a/UpdateCurrencyRate.php +++ b/UpdateCurrencyRate.php @@ -1,5 +1,8 @@ loadRates(); + + $hkd = $d->convert(1,'USD','HKD'); + + echo "1 USD is ~ $hkd HKD (should be about 7.75)\n "; + die("done"); + + + + } + function oldversion() + { $currency = array(); $response = $this->curl($this->actionUrl, array(), 'GET'); @@ -62,7 +79,7 @@ class Pman_Core_UpdateCurrencyRate extends Pman foreach ($currency as $k => $c){ - echo "\nProcessing Currency : $c ($k / $total)"; + echo "\nProcessing Currency : $c ($k / $total) \n"; $params = array( 'lang' => 'en', @@ -91,26 +108,37 @@ class Pman_Core_UpdateCurrencyRate extends Pman $rate = empty($elements->item(0)->nodeValue) ? 0 : $elements->item(0)->nodeValue * 1; - $curr = DB_DataObject::factory('core_curr_rate'); + $this->processCurrRate($c, $rate, $fromDate, $toDate); - $curr->curr = $c; - - $o = false; - - if($curr->find(true)){ - $o = clone($curr); + if(array_key_exists($c, $this->mapping)){ + $this->processCurrRate($this->mapping[$c], $rate, $fromDate, $toDate); } + } + + return; + } + + function processCurrRate($currency, $rate, $from, $to) + { + $curr = DB_DataObject::factory('core_curr_rate'); - $curr->setFrom(array( - 'rate' => $rate, - 'from' => date('Y-m-d H:i:s', strtotime($fromDate)), - 'to' => date('Y-m-d H:i:s', strtotime($toDate)) - )); + $curr->curr = $currency; - (empty($o)) ? $curr->insert() : $curr->update($o); - + $o = false; + + if($curr->find(true)){ + $o = clone($curr); } + + $curr->setFrom(array( + 'rate' => $rate, + 'from_dt' => date('Y-m-d H:i:s', strtotime($from)), + 'to_dt' => date('Y-m-d H:i:s', strtotime($to)) + )); + + (empty($o)) ? $curr->insert() : $curr->update($o); + return; } function curl($url, $request = array(), $method = 'GET') @@ -144,18 +172,4 @@ class Pman_Core_UpdateCurrencyRate extends Pman return $response; } - /* - lang:en - result:1 - date1:10/14/14 - date:10/20/14 - date_fmt:us - exch:USD - exch2: - expr:EUR - expr2: - margin_fixed:0 - format:HTML - SUBMIT:Get Table - */ } \ No newline at end of file