From: Alan Knowles Date: Mon, 5 Oct 2015 08:09:34 +0000 (+0800) Subject: DataObjects/Core_curr_rate.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=bc2cc52d7aa7ec4d14631b8eda7b5b2db15e9c42 DataObjects/Core_curr_rate.php --- diff --git a/DataObjects/Core_curr_rate.php b/DataObjects/Core_curr_rate.php index 232ecbbf..4258b82d 100644 --- a/DataObjects/Core_curr_rate.php +++ b/DataObjects/Core_curr_rate.php @@ -143,9 +143,12 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject $r = DB_DataObject::factory('core_curr_rate'); $r->curr = $cur; $r->whereAdd("from_dt < '" . date('Y-m-d H:i:s', strtotime($when)) . "'"); + $r->orderBy('to_dt ASC'); $r->limit(1); - + if ($r->find(true)) { + return $r->rate; + } } function convert($val, $from, $to, $when = false)