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
public $ontable; // string(128) not_null
public $last_event_id; // int(11)
public $method; // depricated.
- public $method_id; // string(128) not_null
+ public $method_id; // string(128) not_null
+
+ public $recur_id; //INT(11) not_null
+
+
###END_AUTOCODE
+ //NOTE recur_id and method are depricated.
/*
*
/* 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)));
}
+ function method()
+ {
+ $e = DB_DataObject::Factory('core_enum');
+ $e->get($this->method_id);
+ return $e;
+ }
+
function notifytimes($advance)
{
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')));
+ $date->setTimezone(new DateTimeZone(date_default_timezone_get()));
$ret[] = $date->format('Y-m-d H:i:s');
}
}
{
//DB_DataObject::debugLevel(1);
$w = DB_DataObject::factory($this->tableName());
+ $w->id = 117;
$w->find();
while($w->fetch()){
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;
}
"person_id" => $this->person_id,
"onid" => $this->onid,
"ontable" => $this->ontable,
- 'evtype' => $this->method,
+ 'evtype' => $this->method()->name,
));
$add->insert();
}
// should delete old events that have not occurred...
$n->delete(DB_DATAOBJECT_WHEREADD_ONLY);
}
+
+ function toRooSingleArray($authUser, $request)
+ {
+ $ret = $this->toArray();
+
+ if(!empty($ret['keyword_filters'])){
+ $keywords = array_unique(array_filter(explode(',', $ret['keyword_filters'])));
+
+ $clipping_keywords = DB_DataObject::factory('clipping_keywords');
+ $clipping_keywords->whereAddIn('id', $keywords, 'int');
+
+ $li = array();
+
+ foreach ($clipping_keywords->fetchAll('id', 'keyword') as $k => $v){
+ $li[] = array(
+ 'id' => $k,
+ 'keyword' => $v
+ );
+ }
+
+ $ret['keywords'] = json_encode($li);
+ }
+
+ return $ret;
+ }
+
+ function toRooArray($request)
+ {
+ $ret = $this->toArray();
+
+ if(!empty($ret['keyword_filters'])){
+ $keywords = array_unique(array_filter(explode(',', $ret['keyword_filters'])));
+
+ $clipping_keywords = DB_DataObject::factory('clipping_keywords');
+ $clipping_keywords->whereAddIn('id', $keywords, 'int');
+
+ $ret['keywords'] = implode(',', $clipping_keywords->fetchAll('keyword'));
+ }
+
+ return $ret;
+ }
}