X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_event_audit.php;h=0e578b10f1ee58be2c9e19bd296f6a9da28a5abf;hp=ccb5a521ee8a95ee6b93e092387554433bfb15dc;hb=HEAD;hpb=0639931e628a515f194475abaa4b70bf82a4bc9a diff --git a/DataObjects/Core_event_audit.php b/DataObjects/Core_event_audit.php index ccb5a521..0e578b10 100644 --- a/DataObjects/Core_event_audit.php +++ b/DataObjects/Core_event_audit.php @@ -1,8 +1,8 @@ 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