X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_curr_rate.php;h=5b6858cfbf1fb3bae92d5174f982871de11bac61;hp=c31073def93e57d3dd3bed97b14a76cd38c1d3fa;hb=HEAD;hpb=1c64d44d4fac705194fa1e074af4f2dc09c96d0e diff --git a/DataObjects/Core_curr_rate.php b/DataObjects/Core_curr_rate.php index c31073de..5b6858cf 100644 --- a/DataObjects/Core_curr_rate.php +++ b/DataObjects/Core_curr_rate.php @@ -2,7 +2,7 @@ /** * Table Definition for core_curr_rate */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject { @@ -48,8 +48,7 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject // how often do we need to know this..? // let's assume we do it once a week.. $x = DB_DataObject::Factory('core_curr_rate'); - $x->whereAdd("to_dt > NOW() AND curr != ''");// ingore crap data. - + $x->whereAdd('to_dt > NOW()'); if ($x->count()) { // got some data for beyond today.. @@ -79,7 +78,7 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject return false; } - $dom = simplexml_load_file($target); + $dom = simplexml_load_string($f); $rates['EUR'] = 1.0; foreach($dom->Cube->Cube->Cube as $c) { @@ -88,16 +87,16 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject } $rates['RMB'] = $rates['CNY'] ; - foreach($rates as $cur=>$euro) { + foreach($rates as $cur=>$in_euro) { - $rate = $this->rates['USD'] * $euro; + $rate = (1.0 / $rates['USD']) * $in_euro; $ov = DB_DataObject::Factory('core_curr_rate'); $ov->curr = $cur; - $nl = clone($x); + $nl = clone($ov); $ov->orderBy('to_dt DESC'); $ov->limit(1); @@ -114,7 +113,7 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject if ($ov->rate == $rate) { // modify the old one to expire $oo = clone($ov); - $ov->to_dt = $nv->from_dt; + $ov->to_dt = $nl->from_dt; $ov->update($oo); continue; } @@ -158,10 +157,10 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject // crappy error handling.. if ($fr === false) { - $fr = 1; + return false; } if ($tr === false) { - $tr = 1; + return false; } return ((1.0 / $fr) * $val) * $tr; @@ -170,6 +169,22 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject } + function currentRates() + { + $this->loadRates(); + // DB_DataObject::debugLevel(1); + $c = DB_DAtaObject::factory('core_curr_rate'); + $c->whereAdd('from_dt < NOW() AND to_dt > NOW()'); + $c->find(); + $ret = array(); + while($c->fetch()) { + $ret[$c->curr] = $c->rate; + } + return $ret; + + + + } }