Esempio n. 1
0
/**
 * Return a small object with summary information about what a
 * user has done with a given particular instance of this module
 * Used for user activity reports.
 * $return->time = the time they did it
 * $return->info = a short text description
 *
 * @return null
 * @todo Finish documenting this function
 */
function checklist_user_outline($course, $user, $mod, $checklist)
{
    global $DB, $CFG;
    $groupins_sel = '';
    if (isset($CFG->enablegroupmembersonly) && $CFG->enablegroupmembersonly && $checklist->autopopulate) {
        $groupings = checklist_class::get_user_groupings($user->id, $checklist->course);
        $groupings[] = 0;
        $groupings_sel = ' AND grouping IN (' . implode(',', $groupings) . ') ';
    }
    $sel = 'checklist = ? AND userid = 0 AND itemoptional = ' . CHECKLIST_OPTIONAL_NO;
    $sel .= ' AND hidden = ' . CHECKLIST_HIDDEN_NO . $groupings_sel;
    $items = $DB->get_records_select('checklist_item', $sel, array($checklist->id), '', 'id');
    if (!$items) {
        return null;
    }
    $total = count($items);
    list($isql, $iparams) = $DB->get_in_or_equal(array_keys($items));
    $sql = "userid = ? AND item {$isql} AND ";
    if ($checklist->teacheredit == CHECKLIST_MARKING_STUDENT) {
        $sql .= 'usertimestamp > 0';
        $order = 'usertimestamp DESC';
    } else {
        $sql .= 'teachermark = ' . CHECKLIST_TEACHERMARK_YES;
        $order = 'teachertimestamp DESC';
    }
    $params = array_merge(array($user->id), $iparams);
    $checks = $DB->get_records_select('checklist_check', $sql, $params, $order);
    $return = null;
    if ($checks) {
        $return = new stdClass();
        $ticked = count($checks);
        $check = reset($checks);
        if ($checklist->teacheredit == CHECKLIST_MARKING_STUDENT) {
            $return->time = $check->usertimestamp;
        } else {
            $return->time = $check->teachertimestamp;
        }
        $percent = sprintf('%0d', $ticked * 100 / $total);
        $return->info = get_string('progress', 'checklist') . ': ' . $ticked . '/' . $total . ' (' . $percent . '%)';
    }
    return $return;
}
Esempio n. 2
0
 static function get_user_progress($checklistid, $userid)
 {
     global $DB, $CFG;
     $userid = intval($userid);
     // Just to be on the safe side...
     $checklist = $DB->get_record('checklist', array('id' => $checklistid));
     if (!$checklist) {
         return array(false, false);
     }
     $groupings_sel = '';
     if (isset($CFG->enablegroupmembersonly) && $CFG->enablegroupmembersonly && $checklist->autopopulate) {
         $groupings = checklist_class::get_user_groupings($userid, $checklist->course);
         $groupings[] = 0;
         $groupings_sel = ' AND grouping IN (' . implode(',', $groupings) . ') ';
     }
     $items = $DB->get_records_select('checklist_item', 'checklist = ? AND userid = 0 AND itemoptional = ' . CHECKLIST_OPTIONAL_NO . ' AND hidden = ' . CHECKLIST_HIDDEN_NO . $groupings_sel, array($checklist->id), '', 'id');
     if (empty($items)) {
         return array(false, false);
     }
     $total = count($items);
     list($isql, $iparams) = $DB->get_in_or_equal(array_keys($items));
     $params = array_merge(array($userid), $iparams);
     $sql = "userid = ? AND item {$isql} AND ";
     if ($checklist->teacheredit == CHECKLIST_MARKING_STUDENT) {
         $sql .= 'usertimestamp > 0';
     } else {
         $sql .= 'teachermark = ' . CHECKLIST_TEACHERMARK_YES;
     }
     $ticked = $DB->count_records_select('checklist_check', $sql, $params);
     return array($ticked, $total);
 }