/**
* 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
{
*
/* 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)
// 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..
$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');
}
}
$notifytimes = $this->notifyTimes(2);
- ////print_R($notifytimes);
+ //echo "{$this->person()->email}\n";
+ //print_R($notifytimes);
$newSearch = DB_DataObject::factory('core_notify');
$newSearch->whereAdd( 'act_start > NOW()');
// 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]);
+
+ 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(
"person_id" => $this->person_id,
"onid" => $this->onid,
"ontable" => $this->ontable,
- 'evtype' => $this->method,
+ 'evtype' => $this->method()->name,
));
$add->insert();
}
}
+ function person()
+ {
+ $p = DB_DAtaObject::factory('core_person');
+ $p->get($this->person_id);
+ return $p;
+ }
+
function onUpdate($old, $request,$roo)
{
$this->generateNotificationsSingle();
// should delete old events that have not occurred...
$n->delete(DB_DATAOBJECT_WHEREADD_ONLY);
}
+
}