} else {
- $jt = DB_DataObject::factory('Person');
+ $person = 'Person';
+ $cfg = HTML_FlexyFramework::get()->Pman;
+ if (!empty($cfg['authTable'])) {
+ $person =$cfg['authTable'];
+ }
+
+ $jt = DB_DataObject::factory($person);
$this->whereAdd("
person_table = '{$jt->tableName()}'
OR
//DB_DataObject::debugLevel(1);
$this->_extra_cols = array('qty' , 'uqty');
$this->selectAdd("count($tn.id) as qty");
-// $this->selectAdd("count( distinct $tn.on_table, $tn.on_id) as uqty");
- $this->selectAdd("count($tn.on_id) as uqty");
+ $this->selectAdd("count( distinct $tn.on_table, $tn.on_id) as uqty");
$this->groupBy('on_table');
}
$tnb = $this->escape($q['query']['on_table']);
$this->whereAdd("Events.on_table LIKE '%{$tnb}%'");
}
+
}
}
-
+ function beforeInsert($request,$roo)
+ {
+ if(empty($this->event_when)){
+ $this->event_when = $this->sqlValue("NOW()");
+ }
+
+ if(empty($this->person_id)){
+ $this->person_id = $roo->authUser->id;
+ $this->person_name = $roo->authUser->name;
+ $this->person_table = $roo->authUser->tableName();
+ }
+
+ if(empty($this->ipaddr)){
+ $this->ipaddr = isset($_SERVER["REMOTE_ADDR"]) ? $_SERVER["REMOTE_ADDR"] : 'cli';
+ if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
+ $this->ipaddr = $_SERVER['HTTP_X_FORWARDED_FOR'];
+ }
+ }
+ }
function onInsert($request,$roo)
{
$this->writeEventLog();
}
- function writeEventLog()
+ function writeEventLog($extra_data = '')
{
$ff = HTML_FlexyFramework::get();
if (empty($ff->Pman['event_log_dir'])) {
print_r("failed to copy {$f['tmp_name']}...\n");
}
}
-
- file_put_contents($file, json_encode(array(
+ $out = array(
'REQUEST_URI' => empty($_SERVER['REQUEST_URI']) ? 'cli' : $_SERVER['REQUEST_URI'],
'HTTP_USER_AGENT' => empty($_SERVER['HTTP_USER_AGENT']) ? '' : $_SERVER['HTTP_USER_AGENT'],
'GET' => empty($_GET) ? array() : $_GET,
'POST' =>$p,
'FILES' => $files,
- )));
+ );
+ if (!empty($extra_data)) {
+ $out['EXTRA'] = $extra_data;
+ }
+
+ file_put_contents($file, json_encode($out));
}
+ function toRooSingleArray($au, $q)
+ {
+ $ret = $this->toArray();
+
+ if(empty($q['_retrieve_source'])){
+ return $ret;
+ }
+
+ $file = $this->retrieveEventLog();
+
+ if(!$file){
+ return "No records?!";
+ }
+
+ $source = json_decode(file_get_contents($file));
+
+ return $source;
+ }
+ function retrieveEventLog()
+ {
+ $ff = HTML_FlexyFramework::get();
+ if (empty($ff->Pman['event_log_dir'])) {
+ return false;
+ }
+
+ if (function_exists('posix_getpwuid')) {
+ $uinfo = posix_getpwuid( posix_getuid () );
+
+ $user = $uinfo['name'];
+ } else {
+ $user = getenv('USERNAME'); // windows.
+ }
+
+ $date = date('/Y/m/d/', strtotime($this->event_when));
+
+ $file = $ff->Pman['event_log_dir']. '/'. $user. $date. $this->id . ".json";
+ if (!file_exists(dirname($file))) {
+ return false;
+ }
+
+ return $file;
+ }
}