X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FEvents.php;h=5b002e9675458c3ee5f44ff02af18faaa49b5b28;hb=a7d65bd1e9177ef0f432534feebb66454500f939;hp=7e5f718fa6ab15440411dc8a5137ef81333fd647;hpb=e0a21dcc4ed4e3cdff8eb7221a81295e9a84c818;p=Pman.Core diff --git a/DataObjects/Events.php b/DataObjects/Events.php index 7e5f718f..5b002e96 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -7,7 +7,7 @@ * * */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Events extends DB_DataObject { @@ -25,7 +25,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject public $person_id; // int(11) public $remarks; // blob(65535) blob public $person_table; // string(64) - + /* the code above is auto generated do not remove the tag below */ ###END_AUTOCODE @@ -37,14 +37,18 @@ class Pman_Core_DataObjects_Events extends DB_DataObject { $tn = $this->tableName(); // if not empty on_table + if(!empty($q['person_table'])){ $jt = DB_DataObject::factory($q['person_table']); + + - if(!array_key_exists("{$jt->tableName()}_id", $this->table())){ // coz we have triiger on mysql... + if(!array_key_exists("{$jt->tableName()}_id", $this->tableColumns())){ // coz we have triiger on mysql... $keys = $jt->keys(); $this->_join = "LEFT JOIN {$jt->tableName()} AS join_person_id_id ON (join_person_id_id.{$keys[0]}=Events.person_id)"; + $this->selectAdd(); $this->selectAs(); @@ -61,7 +65,8 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } } else { - $person = 'Person'; + + $person = $au->tableName(); //'Person'; -- projects may not use person as the auth table... $cfg = HTML_FlexyFramework::get()->Pman; if (!empty($cfg['authTable'])) { $person =$cfg['authTable']; @@ -85,6 +90,15 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $dt = date('Y-m-d' , strtotime($q['query']['to'])); $this->whereAdd(" {$tn}.event_when <= '$dt' "); } + + if(!empty($q['dup_check'])){ + $et = DB_DataObject::factory($tn); + $this->_join .= "LEFT JOIN {$et->tableName()} AS evet ON (evet.id=Events.id)"; + $this->selectAdd("(select count(*)+1 from Events where Events.dup_id = evet.id) as cnt "); + //$this->selectAs($et,'%s','evet'); + $this->having('Events.dup_id = 0 '); + + } /* if (!empty($q['query']['grouped']) && $q['query']['grouped'] == 'gr') { // grouped.. @@ -99,7 +113,8 @@ class Pman_Core_DataObjects_Events extends DB_DataObject if (!$au->hasPerm("Admin.Admin_Tab", 'S')) { //DB_DataObject::DebugLevel(1); // they can only view their changes.. - $this->person_id = $au->id; + $this->whereAdd("($tn.person_id = {$au->id} OR $tn.person_id = 0)"); +// $this->person_id = $au->id; } // _join = tablename,tablename... @@ -114,9 +129,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject // empty ontable queries.. these are valid.. $this->whereAdd("$tn.on_table = ''"); } - - - + if (isset($q['query']['person_sum'])) { //DB_DataObject::debugLevel(1); $this->_extra_cols = array('qty' ); @@ -163,7 +176,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject LEFT JOIN {$jtn} as join_on_id_{$jtn} ON {$tn}.on_id = join_on_id_{$jtn}.{$jk} AND on_table = '{$jtn}' "; - $keys = array_keys($x->table()); + $keys = array_keys($x->tableColumns()); if (isset($q['_join_cols'])) { $jcs = explode(',',$q['_join_cols'] ); //DB_DataObject::DebugLevel(1); @@ -311,7 +324,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } else { $col = $au->tableName() == "Person" ? 'person_id' : $au->tableName() . '_id'; // does $col exist? - $cols = $this->table(); + $cols = $this->tableColumns(); $col = isset($cols[$col]) ? $col : 'person_id'; // for BC.... - revert to using person_id $this->{$col} = $au->pid(); //$this->person_id = $au ? (!empty($au->id) ? $au->id : $au->pid()) : -1; @@ -329,7 +342,9 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $rem = array(); // should this really go in remarks? - if ($obj && method_exists($obj,'toEventString')) { - $rem[] = $obj->toEventString() ; + if($obj->toEventString() !== false){ + $rem[] = $obj->toEventString(); + } } $rem[] = $remarks; $this->remarks = implode(' : ', $rem); @@ -351,7 +366,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } $ret = 0; - foreach(array_keys($new->table()) as $k) { + foreach(array_keys($new->tableColumns()) as $k) { // should we JSON serialize this? $n = empty($new->$k) ? '' : $new->$k; $o = empty($old->$k) || empty($old->$k) ? '' : $old->$k; @@ -450,15 +465,15 @@ class Pman_Core_DataObjects_Events extends DB_DataObject self::$deleted[] = $del; return true; } + static $extra_data = false; - function writeEventLog($extra_data = '') + static function writeEventLogExtra($data) { + self::$extra_data = $data; + } + + function logDir() { $ff = HTML_FlexyFramework::get(); - if (empty($ff->Pman['event_log_dir'])) { - return false; - } - - // add user (eg. www-data or local user if not..) if (function_exists('posix_getpwuid')) { $uinfo = posix_getpwuid( posix_getuid () ); @@ -466,10 +481,37 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } else { $user = getenv('USERNAME'); // windows. } + + // DEPRICATED... + if (!empty($ff->Pman['event_log_dir'])) { + return $ff->Pman['event_log_dir'] . '/'.$user; + } + if (!empty($ff->Pman['storedir'])) { + return $ff->Pman['storedir'] .'/Events/'.$user; + + } + return false; + } + + + + function writeEventLog($extra_data = false) + { + $logdir = $this->logDir(); + if (!$logdir) { + return false; + } + + //print_r($this); - $file = $ff->Pman['event_log_dir']. '/'. $user. date('/Y/m/d/'). $this->id . ".json"; + $file = $logdir. date('/Y/m/d/'). $this->id . ".json"; if (!file_exists(dirname($file))) { - mkdir(dirname($file),0700,true); + + @mkdir(dirname($file),0700,true); // this might fail if it does not have correct permissions.. + if (!file_exists(dirname($file))) { + die("could not create $file - permissons are not correct"); // fatal, otherwise we loop!? + } + } // Remove all the password from logs... @@ -495,7 +537,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $files[$k]['tmp_name'] = $this->id . '-'. $i; - $nf = $ff->Pman['event_log_dir']. '/'. $user. date('/Y/m/d/'). $files[$k]['tmp_name']; + $nf = $logdir . date('/Y/m/d/'). $files[$k]['tmp_name']; if (!copy($f['tmp_name'], $nf)) { print_r("failed to copy {$f['tmp_name']}...\n"); } @@ -511,9 +553,12 @@ class Pman_Core_DataObjects_Events extends DB_DataObject if (!empty(self::$deleted)) { $out['DELETED_DATAOBJECTS'] = self::$deleted; } - if (!empty($extra_data)) { + if ($extra_data !== false) { $out['EXTRA'] = $extra_data; } + if ( self::$extra_data !== false) { + $out['EXTRA_DATA'] = self::$extra_data; + } file_put_contents($file, json_encode($out)); @@ -567,22 +612,16 @@ class Pman_Core_DataObjects_Events extends DB_DataObject 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 () ); + $logdir = $this->logDir(); + if (!$logdir) { + return false; - $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"; + $file = $logdir. $date. $this->id . ".json"; if (!file_exists(dirname($file))) { return false; } @@ -604,85 +643,68 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $roo->jerr('Invalid url'); } - $processed = array(); $restored = array(); - $affects = array(); foreach ($log['DELETED_DATAOBJECTS'] as $d){ if( empty($d['id']) || empty($d['_table']) || ( - !empty($processed[$d['_table']]) && - in_array($d['id'], $processed[$d['_table']]) + !empty($restored[$d['_table']]) && + in_array($d['id'], $restored[$d['_table']]) ) ){ continue; } - $tableName = $d['_table']; - - unset($d['_table']); - - if(!isset($processed[$tableName])){ - $processed[$tableName] = array(); + if(!isset($restored[$d['_table']])){ + $restored[$d['_table']] = array(); } - $processed[$tableName][] = $d['id']; - + $restored[$d['_table']][] = $d['id']; - $table = DB_DataObject::factory($tableName); + $table = DB_DataObject::factory($d['_table']); if (!is_a($table,'DB_DataObject')) { continue; } - - - $table = DB_DataObject::factory($tableName); - - $pk = $table->keys(); - - $all_links = $GLOBALS['_DB_DATAOBJECT']['LINKS'][$this->_database]; - - foreach($all_links as $tbl => $links) { - foreach($links as $col => $totbl_col) { - $to = explode(':', $totbl_col); - if ($to[0] != $this->tableName()) { - continue; - } - - if(!isset($affects[$tbl])){ - $affects[$tbl] = array(); - } - - if(!isset($affects[$tbl][$col])){ - $affects[$tbl][$col] = array(); - } - - $affects[$tbl][$col][$d['id']] = $table->tableName() . '.' . ((empty($pk)) ? 'id' : $pk[0]); - - } - } + unset($d['_table']); $table->setFrom($d); + + /* + * need to use the old id + */ $table->id = $d['id']; - $this->sequenceKey(false,false); + + $table->sequenceKey(false,false); $table->insert(); - print_r($table); - if(!isset($restored[$table->tableName()])){ - $restored[$table->tableName()] = array(); + if($table->tableName() == 'crm_mailing_list_member'){ + $ml = DB_DataObject::factory('crm_mailing_list'); + if(!$ml->get($table->mailing_list_id)){ + continue; + } + + $mlm = DB_DataObject::factory('crm_mailing_list_member'); + $mlm->setFrom(array( + 'mailing_list_id' => $table->mailing_list_id, + 'is_active' => 1 + )); + + $o = clone($ml); + $ml->no_members = $mlm->count(); + $ml->update($o); } - - $restored[$table->tableName()][$d['id']] = $table; - - $table = DB_DataObject::factory($tableName); - - } - print_R($affects);exit; + + $roo->jok('RESTORE'); + } + function selectAddPersonEmail() + { + $this->selectAdd('join_person_id_id.email as email'); } }