X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_event_audit.php;h=b7950109f63abf3f167212ea1c2c5d6661776c62;hb=4815ad97d9b7cfd878c833605aea14fd3e7214c2;hp=ccb5a521ee8a95ee6b93e092387554433bfb15dc;hpb=0639931e628a515f194475abaa4b70bf82a4bc9a;p=Pman.Core diff --git a/DataObjects/Core_event_audit.php b/DataObjects/Core_event_audit.php index ccb5a521..b7950109 100644 --- a/DataObjects/Core_event_audit.php +++ b/DataObjects/Core_event_audit.php @@ -1,6 +1,6 @@ newvalue($event); } - - - - + function findLast($event, $name) + { + //DB_DataObject::debugLevel(1); + $x = DB_DataObject::factory('core_event_audit'); + $x->autoJoin(); + + print_r($x->links()); + + $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