X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_notify_recur.php;h=ceca27cb28f11d8144010a2e3a0beb3c719e9ea4;hp=abcc32a5c0ef926d54ce52041afe7288398c5db7;hb=HEAD;hpb=6c57ccba338a7c65b22031fd4c705f4d3ec4b159 diff --git a/DataObjects/Core_notify_recur.php b/DataObjects/Core_notify_recur.php index abcc32a5..ceca27cb 100644 --- a/DataObjects/Core_notify_recur.php +++ b/DataObjects/Core_notify_recur.php @@ -2,7 +2,7 @@ /** * Table Definition for core_notify_recur */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject { @@ -12,7 +12,6 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject public $__table = 'core_notify_recur'; // table name public $id; // int(11) not_null primary_key auto_increment public $person_id; // int(11) not_null - public $recur_id; //INT(11) not_null public $dtstart; // datetime(19) not_null binary public $dtend; // datetime(19) not_null binary @@ -29,9 +28,14 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject public $onid; // int(11) not_null public $ontable; // string(128) not_null public $last_event_id; // int(11) - public $method; // string(128) not_null + public $method; // depricated. + public $method_id; // string(128) not_null + + public $recur_id; //INT(11) not_null + ###END_AUTOCODE + //NOTE recur_id and method are depricated. /* @@ -44,12 +48,32 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject * /* the code above is auto generated do not remove the tag below */ - + function applyFilters($q, $au, $roo) + { + + if (isset($q['query']['person_id_name']) ) { + $this->whereAdd( "join_person_id_id.name LIKE '{$this->escape($q['query']['person_id_name'])}%'"); + + } + + + + + + } function notifytimesRange($advance) { $start = date('Y-m-d H:i:s', max(strtotime("NOW"), strtotime($this->dtstart))); - $end = date('Y-m-d H:i:s', min(strtotime("NOW + $advance DAYS"), strtotime($this->dtend))); + $end = min( new DateTime("NOW + $advance DAYS"), new DateTime($this->dtend ) )->format('Y-m-d H:i:s'); + return array($start, $end); + } + + function method() + { + $e = DB_DataObject::Factory('core_enum'); + $e->get($this->method_id); + return $e; } function notifytimes($advance) @@ -59,6 +83,8 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject // it starts 24 hours ago.. or when dtstart list($start, $end) = $this->notifytimesRange($advance); + //var_dump(array($start, $end)); + //print_r($this); if (strtotime($start) > strtotime($end)) { return array(); // no data.. @@ -86,14 +112,18 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject $usedays[] = date("Y-m-d", $ut); } } - + //print_r($this); foreach($usedays as $d){ foreach($hours as $h){ $date = new DateTime($d. ' ' . $h, new DateTimeZone($this->tz)); - $date->setTimezone(new DateTimeZone(ini_get('date.timezone'))); + $tz= ini_get('date.timezone'); + if(!empty($tz)){ + $date->setTimezone(new DateTimeZone($tz)); + } + $ret[] = $date->format('Y-m-d H:i:s'); } } @@ -118,7 +148,8 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject $notifytimes = $this->notifyTimes(2); - print_R($notifytimes);exit; + //echo "{$this->person()->email}\n"; + //print_R($notifytimes); $newSearch = DB_DataObject::factory('core_notify'); $newSearch->whereAdd( 'act_start > NOW()'); @@ -128,17 +159,23 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject foreach($notifytimes as $time){ - if (strtotime($time) < time()) { - // will not get deleted.. - unset($old[$time]); - continue; - } + if (isset($old[$time])) { // we already have it... + $oo = DB_DataObject::Factory('core_notify'); + $oo->get($old[$time]); + $oc = clone($oo); + $oo->evtype = $this->method()->name; + $oo->update($oc); + unset($old[$time]); continue; } - + + if (strtotime($time) < time()) { // should not happen, just in case... + continue; + } + // do not have a notify event... creat it.. $add = DB_DataObject::factory('core_notify'); $add->setFrom(array( @@ -148,7 +185,7 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject "person_id" => $this->person_id, "onid" => $this->onid, "ontable" => $this->ontable, - 'evtype' => $this->method, + 'evtype' => $this->method()->name, )); $add->insert(); } @@ -157,9 +194,17 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject $del->get($id); $del->delete(); } + //echo("UPDATED"); } + function person() + { + $p = DB_DAtaObject::factory('core_person'); + $p->get($this->person_id); + return $p; + } + function onUpdate($old, $request,$roo) { $this->generateNotificationsSingle(); @@ -178,4 +223,5 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject // should delete old events that have not occurred... $n->delete(DB_DATAOBJECT_WHEREADD_ONLY); } + }