From a091f31cd15d6221ec1b1e670acda8e151e1e80e Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 28 Sep 2011 12:40:17 +0800
Subject: [PATCH] DataObjects/Core_event_audit.php

---
 DataObjects/Core_event_audit.php | 22 ++++++++++++++++++++--
 1 file changed, 20 insertions(+), 2 deletions(-)

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;
+        
+    }
     
     
     
-- 
2.39.2