register_hook('PLUGIN_NOTIFICATION_REGISTER_SOURCE', 'AFTER', $this, 'add_notifications_source'); $controller->register_hook('PLUGIN_NOTIFICATION_GATHER', 'AFTER', $this, 'add_notifications'); $controller->register_hook('PLUGIN_NOTIFICATION_CACHE_DEPENDENCIES', 'AFTER', $this, 'add_notification_cache_dependencies'); } public function add_notifications_source(Doku_Event $event) { $event->data[] = 'approve'; } public function add_notification_cache_dependencies(Doku_Event $event) { if (!in_array('approve', $event->data['plugins'])) return; try { /** @var \helper_plugin_approve_db $db_helper */ $db_helper = plugin_load('helper', 'approve_db'); $sqlite = $db_helper->getDB(); $event->data['dependencies'][] = $sqlite->getAdapter()->getDbFile(); } catch (Exception $e) { msg($e->getMessage(), -1); return; } } public function add_notifications(Doku_Event $event) { if (!in_array('approve', $event->data['plugins'])) return; try { /** @var \helper_plugin_approve_db $db_helper */ $db_helper = plugin_load('helper', 'approve_db'); $sqlite = $db_helper->getDB(); } catch (Exception $e) { msg($e->getMessage(), -1); return; } $user = $event->data['user']; $is_ready_for_approval = ''; if ($this->getConf('ready_for_approval_notification')) { $is_ready_for_approval = 'AND revision.ready_for_approval IS NOT NULL'; } $q = 'SELECT page.page, revision.rev FROM page INNER JOIN revision ON page.page = revision.page WHERE page.hidden = 0 AND page.approver=? AND revision.current=1 AND revision.approved IS NULL ' . $is_ready_for_approval; $res = $sqlite->query($q, $user); $notifications = $sqlite->res2arr($res); foreach ($notifications as $notification) { $page = $notification['page']; $rev = $notification['rev']; $link = ''; if (useHeading('content')) { $heading = p_get_first_heading($page); if (!blank($heading)) { $link .= $heading; } else { $link .= noNSorNS($page); } } else { $link .= noNSorNS($page); } $link .= ''; $full = sprintf($this->getLang('notification full'), $link); $event->data['notifications'][] = [ 'plugin' => 'approve', 'id' => $page.':'.$rev, 'full' => $full, 'brief' => $link, 'timestamp' => (int)$rev ]; } } }