/** * Returns the count of records for the provided user and quora and [optionally] group. * * @global object * @global object * @global object * @param object $cm * @param object $course * @return int */ function quora_tp_count_quora_unread_posts($cm, $course) { global $CFG, $USER, $DB; static $readcache = array(); $quoraid = $cm->instance; if (!isset($readcache[$course->id])) { $readcache[$course->id] = array(); if ($counts = quora_tp_get_course_unread_posts($USER->id, $course->id)) { foreach ($counts as $count) { $readcache[$course->id][$count->id] = $count->unread; } } } if (empty($readcache[$course->id][$quoraid])) { // no need to check group mode ;-) return 0; } $groupmode = groups_get_activity_groupmode($cm, $course); if ($groupmode != SEPARATEGROUPS) { return $readcache[$course->id][$quoraid]; } if (has_capability('moodle/site:accessallgroups', context_module::instance($cm->id))) { return $readcache[$course->id][$quoraid]; } require_once $CFG->dirroot . '/course/lib.php'; $modinfo = get_fast_modinfo($course); $mygroups = $modinfo->get_groups($cm->groupingid); // add all groups posts $mygroups[-1] = -1; list($groups_sql, $groups_params) = $DB->get_in_or_equal($mygroups); $now = round(time(), -2); // db cache friendliness $cutoffdate = $now - $CFG->quora_oldpostdays * 24 * 60 * 60; $params = array($USER->id, $quoraid, $cutoffdate); if (!empty($CFG->quora_enabletimedposts)) { $timedsql = "AND d.timestart < ? AND (d.timeend = 0 OR d.timeend > ?)"; $params[] = $now; $params[] = $now; } else { $timedsql = ""; } $params = array_merge($params, $groups_params); $sql = "SELECT COUNT(p.id)\n FROM {quora_posts} p\n JOIN {quora_discussions} d ON p.discussion = d.id\n LEFT JOIN {quora_read} r ON (r.postid = p.id AND r.userid = ?)\n WHERE d.quora = ?\n AND p.modified >= ? AND r.id is NULL\n {$timedsql}\n AND d.groupid {$groups_sql}"; return $DB->get_field_sql($sql, $params); }
/** * Test the logic in the quora_tp_get_course_unread_posts() function. */ public function test_quora_tp_get_course_unread_posts() { global $CFG; $this->resetAfterTest(); $useron = $this->getDataGenerator()->create_user(array('trackquoras' => 1)); $useroff = $this->getDataGenerator()->create_user(array('trackquoras' => 0)); $course = $this->getDataGenerator()->create_course(); $options = array('course' => $course->id, 'trackingtype' => FORUM_TRACKING_OFF); // Off. $quoraoff = $this->getDataGenerator()->create_module('quora', $options); $options = array('course' => $course->id, 'trackingtype' => FORUM_TRACKING_FORCED); // On. $quoraforce = $this->getDataGenerator()->create_module('quora', $options); $options = array('course' => $course->id, 'trackingtype' => FORUM_TRACKING_OPTIONAL); // Optional. $quoraoptional = $this->getDataGenerator()->create_module('quora', $options); // Add discussions to the tracking off quora. $record = new stdClass(); $record->course = $course->id; $record->userid = $useron->id; $record->quora = $quoraoff->id; $discussionoff = $this->getDataGenerator()->get_plugin_generator('mod_quora')->create_discussion($record); // Add discussions to the tracking forced quora. $record = new stdClass(); $record->course = $course->id; $record->userid = $useron->id; $record->quora = $quoraforce->id; $discussionforce = $this->getDataGenerator()->get_plugin_generator('mod_quora')->create_discussion($record); // Add post to the tracking forced discussion. $record = new stdClass(); $record->course = $course->id; $record->userid = $useroff->id; $record->quora = $quoraforce->id; $record->discussion = $discussionforce->id; $this->getDataGenerator()->get_plugin_generator('mod_quora')->create_post($record); // Add discussions to the tracking optional quora. $record = new stdClass(); $record->course = $course->id; $record->userid = $useron->id; $record->quora = $quoraoptional->id; $discussionoptional = $this->getDataGenerator()->get_plugin_generator('mod_quora')->create_discussion($record); // Allow force. $CFG->quora_allowforcedreadtracking = 1; $result = quora_tp_get_course_unread_posts($useron->id, $course->id); $this->assertEquals(2, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(true, isset($result[$quoraforce->id])); $this->assertEquals(2, $result[$quoraforce->id]->unread); $this->assertEquals(true, isset($result[$quoraoptional->id])); $this->assertEquals(1, $result[$quoraoptional->id]->unread); $result = quora_tp_get_course_unread_posts($useroff->id, $course->id); $this->assertEquals(1, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(true, isset($result[$quoraforce->id])); $this->assertEquals(2, $result[$quoraforce->id]->unread); $this->assertEquals(false, isset($result[$quoraoptional->id])); // Don't allow force. $CFG->quora_allowforcedreadtracking = 0; $result = quora_tp_get_course_unread_posts($useron->id, $course->id); $this->assertEquals(2, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(true, isset($result[$quoraforce->id])); $this->assertEquals(2, $result[$quoraforce->id]->unread); $this->assertEquals(true, isset($result[$quoraoptional->id])); $this->assertEquals(1, $result[$quoraoptional->id]->unread); $result = quora_tp_get_course_unread_posts($useroff->id, $course->id); $this->assertEquals(0, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(false, isset($result[$quoraforce->id])); $this->assertEquals(false, isset($result[$quoraoptional->id])); // Stop tracking so we can test again. quora_tp_stop_tracking($quoraforce->id, $useron->id); quora_tp_stop_tracking($quoraoptional->id, $useron->id); quora_tp_stop_tracking($quoraforce->id, $useroff->id); quora_tp_stop_tracking($quoraoptional->id, $useroff->id); // Allow force. $CFG->quora_allowforcedreadtracking = 1; $result = quora_tp_get_course_unread_posts($useron->id, $course->id); $this->assertEquals(1, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(true, isset($result[$quoraforce->id])); $this->assertEquals(2, $result[$quoraforce->id]->unread); $this->assertEquals(false, isset($result[$quoraoptional->id])); $result = quora_tp_get_course_unread_posts($useroff->id, $course->id); $this->assertEquals(1, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(true, isset($result[$quoraforce->id])); $this->assertEquals(2, $result[$quoraforce->id]->unread); $this->assertEquals(false, isset($result[$quoraoptional->id])); // Don't allow force. $CFG->quora_allowforcedreadtracking = 0; $result = quora_tp_get_course_unread_posts($useron->id, $course->id); $this->assertEquals(0, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(false, isset($result[$quoraforce->id])); $this->assertEquals(false, isset($result[$quoraoptional->id])); $result = quora_tp_get_course_unread_posts($useroff->id, $course->id); $this->assertEquals(0, count($result)); $this->assertEquals(false, isset($result[$quoraoff->id])); $this->assertEquals(false, isset($result[$quoraforce->id])); $this->assertEquals(false, isset($result[$quoraoptional->id])); }