From: Alan Knowles <alan@roojs.com>
Date: Mon, 5 Oct 2015 08:09:01 +0000 (+0800)
Subject: DataObjects/Core_curr_rate.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=b96bf0a85d55e7874567133370205340a568f5f2

DataObjects/Core_curr_rate.php
---

diff --git a/DataObjects/Core_curr_rate.php b/DataObjects/Core_curr_rate.php
index 37e2bf86..232ecbbf 100644
--- a/DataObjects/Core_curr_rate.php
+++ b/DataObjects/Core_curr_rate.php
@@ -142,7 +142,9 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject
         
         $r = DB_DataObject::factory('core_curr_rate');
         $r->curr = $cur;
-        $r->whereAdd('from_dt < when_dt
+        $r->whereAdd("from_dt < '" . date('Y-m-d H:i:s', strtotime($when)) . "'");
+        $r->orderBy('to_dt ASC');
+        $r->limit(1);
         
     }