3 * Table Definition for core_notify_recur
5 require_once 'DB/DataObject.php';
7 class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject
10 /* the code below is auto generated do not remove the above tag */
12 public $__table = 'core_notify_recur'; // table name
13 public $id; // int(11) not_null primary_key auto_increment
14 public $person_id; // int(11) not_null
16 public $dtstart; // datetime(19) not_null binary
17 public $dtend; // datetime(19) not_null binary
18 public $tz; // real(6) not_null
20 public $updated_dt; // datetime(19) not_null binary
22 public $last_applied_dt; // datetime(19) not_null binary
23 // public $max_applied_dtl
24 public $freq; // varchar(8) NOT NULL;
25 public $freq_day; // text NOT NULL;
26 public $freq_hour; // text
28 public $onid; // int(11) not_null
29 public $ontable; // string(128) not_null
30 public $last_event_id; // int(11)
31 public $method; // string(128) not_null
40 freq = DAILY | YEARLY | MONTHLY
42 * THESE ARE EXCLUSIVE..
43 * freq_day = 1,2,3,4,5" - day number.. or dayofmonth USES TIME FROM DTSTART (unless hours are speced.)
45 * freq_hourly = 'what hours' << OR IF EMPTY USES TIME FROM DTSTART
47 /* the code above is auto generated do not remove the tag below */
50 function notifytimesRange($advance) {
51 error_log($this->dtstart);
52 error_log($this->dtend);
53 $this->start = date('Y-m-d H:i:s', max(strtotime("NOW - 24 HOURS"), strtotime($this->dtstart)));
54 $this->end = date('Y-m-d H:i:s', min(strtotime("NOW"), strtotime($this->dtend)));
55 error_log($this->start);
56 error_log($this->end);
60 function notifytimes($advance)
63 // make a list of datetimes when notifies need to be generated for.
64 // it starts 24 hours ago.. or when dtstart
66 $this->notifytimesRange($advance);
67 error_log($this->start);
68 error_log($this->end);
69 if (strtotime($this->start) > strtotime($this->end)) {
70 return array(); // no data..
80 // happens every day based on freq_hour.
81 $hours = explode(',', $this->freq_hour);
82 for ($day = date('Y-m-d', strtotime($start));
83 strtotime($day) < strtotime($end);
84 $day = date('Y-m-d', strtotime("$day + 1 DAY")))
86 foreach($hours as $h) {
87 $hh = strpos($h,":") > 0 ? $h : "$H:00";
88 $ret[] = $day . ' ' . $hh;
91 return $this->applyTimezoneToList($ret);
94 $hours = explode(',', $this->freq_hour);
96 $hours = array(date('H:i', strtotime($this->dtstart)));
99 $days = explode(','. $this->freq_day);
101 for ($day = date('Y-m-d', strtotime($start));
102 strtotime($day) < strtotime($end);
103 $day = date('Y-m-d', strtotime("$day + 1 DAY")))
105 // skip days not accounted for..
106 if (!in_array(date('N', strtotime($day)), $days)) {
110 foreach($hours as $h) {
111 $hh = strpos($h,":") > 0 ? $h : "$H:00";
112 $ret[] = $day . ' ' . $hh;
116 return $this->applyTimezoneToList($ret);
119 case 'MONTHLY': // ignored..
120 case 'YEARLY': // ignored..
126 function applyTimezoneToList($ar)
130 $tz = explode($this->tz, ":");
134 $append = ($tz[0] < 0) ? " - " : " + ";
136 $append .= abs($tz[0]) . " HOURS";
137 if (!empty($tz[1])) {
138 $append .= $tz[1] . " MINUTES";
143 $ret[] = date('Y-m-d H:i', strtotime($a . $append));
151 function generateNotifications(){
152 //$this->notifytimes(2);
153 $test = $this->notifytimes(2);
154 foreach($test as $item){