X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_event_audit.php;h=0e578b10f1ee58be2c9e19bd296f6a9da28a5abf;hp=98bfb2a6ad74be14f665b71b8669c90d019942c3;hb=HEAD;hpb=f6d20fbc9082e631b5bdfa7821221abd06c15fa0 diff --git a/DataObjects/Core_event_audit.php b/DataObjects/Core_event_audit.php index 98bfb2a6..0e578b10 100644 --- a/DataObjects/Core_event_audit.php +++ b/DataObjects/Core_event_audit.php @@ -2,7 +2,7 @@ /** * Table Definition for core_event_audit */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Core_event_audit extends DB_DataObject { @@ -59,9 +59,29 @@ class Pman_Core_DataObjects_Core_event_audit extends DB_DataObject return $x->newvalue($event); } - - - - + function findLast($event, $name) + { + //DB_DataObject::debugLevel(1); + $x = DB_DataObject::factory('core_event_audit'); + $x->autoJoin(); + + + $x->selectAdd(); + $x->selectAdd('core_event_audit.id as id'); + + $x->name = $name; + $x->whereAdd(" + join_event_id_id.on_table = '{$event->on_table}' AND + join_event_id_id.on_id = {$event->on_id} + "); + $x->orderBy('join_event_id_id.event_when DESC'); + $x->limit(1); + if (!$x->find(true)) { + return 0; + } + return $x->id; + + } + } \ No newline at end of file