/** * @mcms_message ru.molinos.cms.hook.node */ public static function hookNodeUpdate(Context $ctx, Node $node, $op) { switch ($op) { case 'delete': $node->onSave("UPDATE `node` SET `deleted` = 1 WHERE `class` = 'comment' AND `id` IN (SELECT `nid` FROM `node__rel` WHERE `tid` = %ID%"); break; case 'erase': $node->onSave("DELETE FROM `node` WHERE `class` = 'comment' AND `id` IN (SELECT `nid` FROM `node__rel` WHERE `tid` = %ID%)"); break; case 'create': if (!empty($node->doc) and is_numeric($nid = Node::_id($node->doc))) { // Собираем прикреплённых пользователей. $l1 = $node->getDB()->getResultsV("nid", "SELECT `nid` " . "FROM `node__rel` WHERE `tid` = ? AND `nid` IN (SELECT `id` " . "FROM `node` WHERE `class` = 'user')", array($nid)); // Собираем пользователей, комментировавших ранее $l2 = $node->getDB()->getResultsV("uid", "SELECT `n`.`uid` " . "FROM `node` `n` " . "INNER JOIN `node__rel` `r` ON `r`.`nid` = `n`.`id` " . "WHERE `r`.`tid` = ? AND `n`.`class` = 'comment'", array($nid)); $uids = array_diff(array_unique(array_merge($l1, $l2)), array($ctx->user->id)); $body = mcms::render(__CLASS__, array('mode' => 'new', 'comment' => $node->getRaw())); if (!empty($body) and !empty($uids)) { foreach ($uids as $uid) { if (empty($node->doc)) { $subject = t('Новый комментарий'); } else { $subject = t('Новый комментарий [%id]', array('%id' => Node::_id($node->doc))); } mcms::mail(null, $uid, $subject, $body); } } } } }
private function notify($isnew) { if ($this->to and $this->to == Context::last()->user->id) { return; } $data = array('mode' => 'mail', 'node' => $this->getRaw()); $data['node']['uid'] = Node::load(array('class' => 'user', 'id' => $this->uid))->getRaw(); $message = bebop_render_object('mail', 'todo', null, $data, __CLASS__); if (!empty($message)) { if ($isnew) { if ($this->to) { mcms::mail(null, $this->to, t('Новое напоминание'), $message); } } elseif (!$isnew) { if ($this->closed) { mcms::mail(null, $this->uid, t('Напоминание удалено'), $message); } elseif ($this->to) { mcms::mail(null, $this->to, t('Напоминание реактивировано'), $message); } } } }