From b96bf0a85d55e7874567133370205340a568f5f2 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 5 Oct 2015 16:09:01 +0800 Subject: [PATCH] DataObjects/Core_curr_rate.php --- DataObjects/Core_curr_rate.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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); } -- 2.39.2