<?php
/**
- * Table Definition for mtrack_change_audit
+ * 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
{
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