/**
* 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]));
}
