X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_watch.php;h=e41d10d88dcf5aea77b9ace6f65d4c18b36e9b6c;hp=d91a8419a468344b4ec848a3996b3e6305090eb8;hb=HEAD;hpb=256fa79c19148491aa5c6fe03fbd30d654293d57 diff --git a/DataObjects/Core_watch.php b/DataObjects/Core_watch.php index d91a8419..2e207ff2 100644 --- a/DataObjects/Core_watch.php +++ b/DataObjects/Core_watch.php @@ -1,8 +1,32 @@ notify($ontable, $onid) + * + * in which case it should create a core_notify event. + * + * + * Should 'event' trigger this.. + * -> eg. somebody makes a 'EDIT' on 'person' + * -> a watch exists for + * ontable=person, + * onid = -1 <<-- every entry.. + * person_id -> who is goes to. + * event = CRUD (eg. shortcut for edit/create/delete) + * medium = "REVIEW" << eg. review needed.. + * + * + * if onid == 0 then it will monitor all changes to that table.. + * + * + * + * */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Core_watch extends DB_DataObject { @@ -10,14 +34,288 @@ class Pman_Core_DataObjects_Core_watch extends DB_DataObject /* the code below is auto generated do not remove the above tag */ public $__table = 'core_watch'; // table name - public $ontable; // string(128) not_null primary_key - public $onid; // string(128) not_null primary_key - public $user_id; // string(128) not_null primary_key - public $event; // string(128) not_null primary_key - public $medium; // string(128) not_null primary_key + public $id; // int(11) not_null primary_key auto_increment + public $ontable; // string(128) not_null + public $onid; // int(11) not_null + public $person_id; // int(11) not_null + public $event; // string(128) not_null + public $medium; // string(128) not_null public $active; // int(11) not_null /* the code above is auto generated do not remove the tag below */ ###END_AUTOCODE + /** make sure there is a watch for this user.. */ + + + function applyFilters($q,$au, $roo) + { + if (!empty($q['_list_actions'])) { + $this->listActions($roo,$q); + } + //die("apply filters"); + if (!empty($q['_split_event_name'])) { + $this->selectAdd(" + + substr( event, 1, LOCATE( '.',event) -1) as event_left, + substr( event, LOCATE( '.',event) +1) as event_right, + (SELECT + display_name FROM core_enum where etype = '{$this->escape($q['_split_event_name'])}' + AND name = substr( event, LOCATE( '.',event) +1) + ) as event_right_display_name + + "); + + + + } + + } + + function toRooSingleArray($au,$q) + { + $ret = $this->toArray(); + if (empty($q['_split_event_name'])) { + return $ret; + } + $bits = explode('.', $this->event); + $ret['event_left'] = $bits[0]; + $ret['event_right'] = $bits[1]; + // check core enu. + if (!empty($ret['event_right'])) { + $ce = DB_DataObject::factory('core_enum')->lookupObject($q['_split_event_name'], $ret['event_right']); + $ret['event_right_display_name'] = $ce->display_name; + } + + return $ret; + + + } + + function listActions($roo, $q) { + + //print_r($q); + $d = DB_DataObject::Factory($q['on_table']); + $ret = array(); + + foreach(get_class_methods($d) as $m) { + //var_dump($m); + if (!preg_match('/^notify/', $m)) { + continue; + } + $ret[] = array( + 'display_name' => preg_replace('/^notify/', '' , $m), + 'name' => $q['on_table'] .':'. $m + ); + } + $roo->jdata($ret); + } + + /** + * + * Create a watch... + * + */ + + + + + function ensureNotify( $ontable, $onid, $person_id, $whereAdd) + { + //DB_DAtaObject::debugLevel(1); + $w = DB_DataObject::factory('core_watch'); + $w->person_id = $person_id; + if (empty($w->person_id)) { + return; + } + + $nw = clone($w); + $w->whereAdd($whereAdd); + + + if ($w->count()) { + return; + } + $nw->ontable = $ontable; + $nw->onid = $onid; + + $nw->medium = 'email'; + $nw->active = 1; + $nw->insert(); + + } + /** + * Generate a notify event based on watches (matching whereAdd) + * + * Usage: $core_watch->notify('mtrack_repos', 1, false, date() + * + * This can match any 'event' type - eg. it can be blank etc... + * Generally used by non-event driven notifications, like our + * Daily commit message. + * + * @param string $ontable - the database table that has been updated/changed etc. + * @param int $onid - the id of the row changed + * @param string $whereAdd (optiona) - a DB whereAdd() condition to filter the search for watches + * @param datetime $when (default now) - date/time to create the notification for (Eg. end of day..) + * @param string $to_ontable - notify event create on this table, rather than watch table. + * @param string $to_id - notify event create on this id, rather than watch id. + * + * + */ + function notify($ontable , $onid, $whereAdd = false, $when=false, $to_ontable=false, $to_onid=false) + { + $w = DB_DataObject::factory('core_watch'); + if ($whereAdd !== false) { + $w->whereAdd($whereAdd ); + } + $w->active =1; + + $w->whereAdd('onid = 0 OR onid='. ((int) $onid)); + + + $w->ontable = $ontable; + //$w->selectAdd(); + //$w->selectAdd('distinct(person_id) as person_id'); + + foreach($w->fetchAll() as $w) { + if (!$w->person_id) { // no people??? bugs in watch table + continue; + } + + $nn = DB_DataObject::Factory('core_notify'); + $nn->ontable = $to_ontable === false ? $ontable : $to_ontable; + $nn->onid = $to_onid === false ? $onid : $to_onid; + $nn->evtype = $w->medium; + $nn->person_id = $w->person_id; + + $nf = clone($nn); + $nf->whereAdd("sent < '2000-01-01'"); + if ($nf->count()) { + // we have a item in the queue for that waiting to be sent.. + continue; + } + $nn->act_start( date("Y-m-d H:i:s", $when !== false ? strtotime($when) : time()) ); + $nn->insert(); + } + + } + // static really... + /** + * + * This get's called by roo->addEvent() + * + * And searches for matching '$watch->event' == $event->action + * along with id/table etc.. + * + * it's basic usage is to fill in core_notify after an event has happend. + * + * We can also use it to notify other modules if something has happend. + * = eg. mtrack_ticket * watch will notify mtrack_jira:: + * + * @param Pman_Core_DataObject_Events $event - the Pman event dataobject that was created + * + */ + + function notifyEvent($event) + { + //print_r($event); + //DB_DataObject::DebugLevel(1); + // see if there are any watches on events.. + // notify everyone flagged except the person doing it... + // this is very basic logic... - + // if more intelligence is needed... + // then it 'rules' will have to be added by the watched object.... + // anyway leave that for another day.. + if (empty($event->action)) { + return; + } + $w = DB_DataObject::factory('core_watch'); + $w->ontable = $event->on_table; + $w->whereAdd('onid = 0 OR onid='. ((int) $event->on_id)); + + $w->event = $event->action; + $w->active = 1; + + // not sure why this is here... - it breaks on the reader article -> + if ($event->person_id) { + $w->whereAdd('person_id != '. (int) $event->person_id); + } + + $watches = $w->fetchAll(); + + //print_R($watches); + + $nn = DB_DataObject::Factory('core_notify'); + $nn->ontable = $event->on_table; + $nn->onid = $event->on_id; + + foreach($watches as $watch) { + $n = clone($nn); + if (!$watch->person_id) { // no people??? bugs in watch table + $dom = explode(':',$watch->medium); + if (count($dom) != 2) { + continue; + } + // in some scenarios (like watching for new articles) + // we need to create a core, notify on the medium.. + // in which case we set the set $nn->evtype = medium.. + // in that case - just let the called method generate the notify.. + + //print_R($dom); + $do = DB_DataObject::factory($dom[0]); + if (!method_exists($do,$dom[1])) { + continue; + } + //echo "calling {$watch->medium}\n"; + // the triggered method, can either do something + // or modify the notify event.. + if ($do->{$dom[1]}($event, $n) !== false) { + //echo "method did not return false?"; + continue; + } + + + } + + + $n->trigger_person_id = $event->person_id; + $n->trigger_event_id = $event->id; + $n->person_id = $watch->person_id; + $n->watch_id = $watch->id; + $n->evtype = $watch->medium; + + // does this watch already have a flag... + $nf = clone($n); + $nf->whereAdd("sent < '2000-01-01'"); + //$nf->whereAdd('sent < act_when'); + if ($nf->count()) { + // we have a item in the queue for that waiting to be sent.. + continue; + } + //echo "inserting notify?"; + $n->act_start( empty($n->act_start) ? date("Y-m-d H:i:s") : $n->act_start ); + $n->insert(); + } + + } + function initDatabase($roo, $data) { + foreach($data as $d) { + $dd = $d; + if (isset($dd['active'])) { + unset($dd['active']); + } + $t = DB_DataObject::Factory($this->tableName()); + $t->setFrom($dd); + if ($t->find(true)) { + continue; + } + $t = DB_DataObject::Factory($this->tableName()); + $t->setFrom($d); + $t->insert(); + + + } + } + + }