From: Alan Knowles <alan@roojs.com>
Date: Wed, 28 Sep 2011 04:40:17 +0000 (+0800)
Subject: DataObjects/Core_event_audit.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a091f31cd15d6221ec1b1e670acda8e151e1e80e

DataObjects/Core_event_audit.php
---

diff --git a/DataObjects/Core_event_audit.php b/DataObjects/Core_event_audit.php
index 98bfb2a6..a0eaccec 100644
--- a/DataObjects/Core_event_audit.php
+++ b/DataObjects/Core_event_audit.php
@@ -59,8 +59,26 @@ class Pman_Core_DataObjects_Core_event_audit extends DB_DataObject
         return $x->newvalue($event);
         
     }
-     
-     
+    function findLast($event, $name)
+    {
+        $x = DB_DataObject::factory('core_event_audit');
+        $x->autoJoin();
+        $x->selectAdd();
+        $x->selectAdd('core_event_audit.id as id');
+
+        $x->name = $name;
+        $x->whereAdd("
+                Events.on_table= '{$event->on_table}' AND
+                Events.on_id= '{$event->on_id}'
+        ");
+        $x->orderBy('Events.event_when DESC');
+        $x->limit(1);
+        if (!$x->find(true)) {
+            return 0;
+        }
+        return $x->id;
+        
+    }