X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_notify_recur.php;h=bd683128b44c16e7f7a6d1c23f92f857b9064b42;hb=2a38115acdac2ba798a0f73a9d39d7a72b7e5787;hp=45fc8a4439a48c11a9434a2f7fcd4691a70c5784;hpb=0fed8c29baa820a81ccbc1694b8e0874441877ab;p=Pman.Core diff --git a/DataObjects/Core_notify_recur.php b/DataObjects/Core_notify_recur.php index 45fc8a44..bd683128 100644 --- a/DataObjects/Core_notify_recur.php +++ b/DataObjects/Core_notify_recur.php @@ -28,10 +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,180 +48,168 @@ 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 - 24 HOURS"), strtotime($this->dtstart))); - $end = date('Y-m-d H:i:s', min(strtotime("NOW + $advance DAYS"), strtotime($this->dtend))); + $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))); } + function method() + { + $e = DB_DataObject::Factory('core_enum'); + $e->get($this->method_id); + return $e; + } + function notifytimes($advance) { // make a list of datetimes when notifies need to be generated for. // it starts 24 hours ago.. or when dtstart - //print_r($this); + list($start, $end) = $this->notifytimesRange($advance); if (strtotime($start) > strtotime($end)) { return array(); // no data.. } - print_r($this); $ret = array(); + $hours = empty($this->freq_hour) ? array() : array_unique(json_decode($this->freq_hour)); + $days = empty($this->freq_day) ? array() : json_decode($this->freq_day); - $hours = array_unique(json_decode($this->freq_hour)); + //days to use are = MON FRI SUN - $days = json_decode($this->freq_day); - //print_r($days); - foreach($days as $d){ - foreach($hours as $h){ - $ret[] = date('Y-m-d', strtotime($d)) . ' ' . $h; + //ARE there events on these day in advance days in the future? + //TODAY = 25th of may (FRI) + //TODAY+1 = 26th (SAT) + //TODAY +2 = 27th = SUN (2== advance) + //foreeach day in the future upto >>> advance <<< days? + + // - does an event occur on this day? + // -YES - then we will generate an event for it. + // -NO nothing happens.. + $usedays = array(); + for ( $i =0; $i < $advance +1; $i++) { + $ut = strtotime("NOW + $i DAYS"); + $day = strtoupper(date("D", $ut)); + if (in_array($day, $days)) { + $usedays[] = date("Y-m-d", $ut); } } - return $this->applyTimezoneToList($ret); - //print_r($ret); -// for ($day = date('Y-m-d', strtotime($start)); strtotime($day) < strtotime($end); $day = date('Y-m-d', strtotime("$day + 1 DAY"))){ -// print_r($day); -// // skip days not accounted for.. -// if (!in_array(date('N', strtotime($day)), $days)) { -// continue; -// } -// foreach($hours as $h) { -// $hh = strpos($h,":") > 0 ? $h : "$H:00"; -// $ret[] = $day . ' ' . $hh; -// } -// } -// return $this->applyTimezoneToList($ret); - -// if($this->freq_hour){ -// // happens every day based on freq_hour. -// $hours = json_decode($this->freq_hour); -// for ($day = date('Y-m-d', strtotime($start)); -// strtotime($day) < strtotime($end); -// $day = date('Y-m-d', strtotime("$day + 1 DAY"))) -// { -// foreach($hours as $h) { -// $hh = strpos($h,":") > 0 ? $h : "$H:00"; -// $ret[] = $day . ' ' . $hh; -// } -// } -// return $this->applyTimezoneToList($ret); -// } -// switch($this->freq) { -// case 'HOURLY': -// // happens every day based on freq_hour. -// $hours = explode(',', $this->freq_hour); -// for ($day = date('Y-m-d', strtotime($start)); -// strtotime($day) < strtotime($end); -// $day = date('Y-m-d', strtotime("$day + 1 DAY"))) -// { -// foreach($hours as $h) { -// $hh = strpos($h,":") > 0 ? $h : "$H:00"; -// $ret[] = $day . ' ' . $hh; -// } -// } -// return $this->applyTimezoneToList($ret); -// -// case 'DAILY': -// $hours = explode(',', $this->freq_hour); -// if (!$hours) { -// $hours = array(date('H:i', strtotime($this->dtstart))); -// } -// -// $days = explode(','. $this->freq_day); -// -// for ($day = date('Y-m-d', strtotime($start)); -// strtotime($day) < strtotime($end); -// $day = date('Y-m-d', strtotime("$day + 1 DAY"))) -// { -// // skip days not accounted for.. -// if (!in_array(date('N', strtotime($day)), $days)) { -// continue; -// } -// -// foreach($hours as $h) { -// $hh = strpos($h,":") > 0 ? $h : "$H:00"; -// $ret[] = $day . ' ' . $hh; -// } -// } -// -// return $this->applyTimezoneToList($ret); -// -// -// case 'MONTHLY': // ignored.. -// case 'YEARLY': // ignored.. -// break; -// -// } - - } - function applyTimezoneToList($ar) - { - $ret = array(); + + //print_r($this); -// $tz = explode($this->tz, ":"); -// if ($tz < 0) { -// -// } -// $append = ($tz[0] < 0) ? " - " : " + "; -// -// $append .= abs($tz[0]) . " HOURS"; -// if (!empty($tz[1])) { -// $append .= $tz[1] . " MINUTES"; -// } - - - foreach($ar as $a) { - $date = new DateTime(strtotime($a), new DateTimeZone($this->tz)); - $ret[] = $date; - //$ret[] = date('Y-m-d H:i', strtotime($a . $append)); + + 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'))); + $ret[] = $date->format('Y-m-d H:i:s'); + } } return $ret; - - } - function generateNotifications(){ - //$this->notifytimes(2); + function generateNotifications() + { //DB_DataObject::debugLevel(1); - $w = DB_DataObject::factory($this->tableName()); - //$this->notifytimes(2); $w->find(); - //$test = $w->fetchAll(); - //$test = $this->notifytimes(2); - - //$test = array(); while($w->fetch()){ - - $notifytime = $w->notifyTimes(2); - var_dump($notifytime); -// $this->id = $w->id; -// $this->person_id = $w->person_id; -// $this->dtstart = $w->dtstart; -// $this->dtend = $w->dtend; -// $this->tz = $w->tz; -// $this->updated_dt = $w->updated_dt; -// $this->last_applied_dt = $w->last_applied_dt; -// $this->freq = $w->freq; -// $this->freq_day = $w->freq_day; -// $this->freq_hour = $w->freq_hour; -// $this->onid = $w->onid; -// $this->ontable = $w->ontable; -// $this->last_event_id = $w->last_event_id; -// $this->method = $w->method; - //$this->dtstart = $w->dtstart; - //$this->dtend = $w->dtend; - //$this = clone($w); - //$w->notifytimes(2); - //var_dump($w->notifytimes(2)); + $w->generateNotificationsSingle(); + } -// foreach($test as $item){ -// error_log($item); -// } + } + + + function generateNotificationsSingle() + { + + $notifytimes = $this->notifyTimes(2); + ////print_R($notifytimes); + + $newSearch = DB_DataObject::factory('core_notify'); + $newSearch->whereAdd( 'act_start > NOW()'); + $newSearch->recur_id = $this->id; + $old = $newSearch->fetchAll('act_start', 'id'); + // returns array('2012-12-xx'=>12, 'date' => id....) + + + + foreach($notifytimes as $time){ + + 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()) { + // will not get deleted.. + //echo "SKIP BEFORE NOW"; + unset($old[$time]); + continue; + } + // do not have a notify event... creat it.. + $add = DB_DataObject::factory('core_notify'); + $add->setFrom(array( + "recur_id" => $this->id, + "act_start" => $time, + "act_when" => $time, + "person_id" => $this->person_id, + "onid" => $this->onid, + "ontable" => $this->ontable, + 'evtype' => $this->method()->name, + )); + $add->insert(); + } + foreach($old as $date => $id ) { + $del = DB_DataObject::factory('core_notify'); + $del->get($id); + $del->delete(); + } + //echo("UPDATED"); + + } + + function onUpdate($old, $request,$roo) + { + $this->generateNotificationsSingle(); + + } + function onInsert($request,$roo) + { + $this->generateNotificationsSingle(); + + } + function beforeDelete($dependants_array, $roo) + { + $n = DB_DataObject::Factory("core_notify"); + $n->recur_id = $this->id; + $n->whereAdd('act_start > NOW() OR act_when > NOW()'); + // should delete old events that have not occurred... + $n->delete(DB_DATAOBJECT_WHEREADD_ONLY); } }