public function course_completion_gauge(&$course, $div, $width = 160, $height = 160, $type = 'progressbar')
{
global $USER, $PAGE;
$str = '';
$completion = new completion_info($course);
if ($completion->is_enabled(null)) {
$alltracked = count($completion->get_activities());
$progressinfo = $completion->get_progress_all('u.id = :userid', array('userid' => $USER->id));
$completed = 0;
if (!empty($progressinfo)) {
if (!empty($progressinfo[$USER->id]->progress)) {
foreach ($progressinfo[$USER->id]->progress as $progressrecord) {
if ($progressrecord->completionstate) {
$completed++;
}
}
}
}
$ratio = $alltracked == 0 ? 0 : round($completed / $alltracked * 100);
$jqwrenderer = $PAGE->get_renderer('local_vflibs');
if ($div == 'div') {
$str .= '<div class="course-completion" title="' . get_string('completion', 'local_my', 0 + $ratio) . '">';
} else {
$str .= '<td class="course-completion" title="' . get_string('completion', 'local_my', 0 + $ratio) . '">';
}
if ($type == 'gauge') {
$properties = array('width' => $width, 'height' => $height, 'max' => 100, 'crop' => 120);
$str .= $jqwrenderer->jqw_bargauge_simple('completion-jqw-' . $course->id, array($ratio), $properties);
} else {
$properties = array('width' => $width, 'height' => $height, 'animation' => 300, 'template' => 'success');
$str .= $jqwrenderer->jqw_progress_bar('completion-jqw-' . $course->id, $ratio, $properties);
}
if ($div == 'div') {
$str .= '</div>';
} else {
$str .= '</td>';
}
} else {
if ($div == 'div') {
$str .= '<div class="course-completion">';
} else {
$str .= '<td class="course-completion">';
}
if ($div == 'div') {
$str .= '</div>';
} else {
$str .= '</td>';
}
}
return $str;
}
$where_params['silast'] = $silast . '%';
}
// Get user match count
$total = $completion->get_num_tracked_users(implode(' AND ', $where), $where_params, $group);
// Total user count
$grandtotal = $completion->get_num_tracked_users('', array(), $group);
// If no users in this course what-so-ever
if (!$grandtotal) {
echo $OUTPUT->container(get_string('err_nousers', 'completion'), 'errorbox errorboxcontent');
echo $OUTPUT->footer();
exit;
}
// Get user data
$progress = array();
if ($total) {
$progress = $completion->get_progress_all(implode(' AND ', $where), $where_params, $group, $firstnamesort ? 'u.firstname ASC' : 'u.lastname ASC', $csv ? 0 : COMPLETION_REPORT_PAGE, $csv ? 0 : $start);
}
// Build link for paging
$link = $CFG->wwwroot . '/course/report/completion/?course=' . $course->id;
if (strlen($sort)) {
$link .= '&sort=' . $sort;
}
$link .= '&start=';
// Build the the page by Initial bar
$initials = array('first', 'last');
$alphabet = explode(',', get_string('alphabet', 'langconfig'));
$pagingbar = '';
foreach ($initials as $initial) {
$var = 'si' . $initial;
$pagingbar .= ' <div class="initialbar ' . $initial . 'initial">';
$pagingbar .= get_string($initial . 'name') . ': ';
/**
* Get Activities completion status
*
* @param int $courseid ID of the Course
* @param int $userid ID of the User
* @return array of activities progress and warnings
* @throws moodle_exception
* @since Moodle 2.9
* @throws moodle_exception
*/
public static function get_activities_completion_status($courseid, $userid)
{
global $CFG, $USER;
require_once $CFG->libdir . '/grouplib.php';
$warnings = array();
$arrayparams = array('courseid' => $courseid, 'userid' => $userid);
$params = self::validate_parameters(self::get_activities_completion_status_parameters(), $arrayparams);
$course = get_course($params['courseid']);
$user = core_user::get_user($params['userid'], 'id', MUST_EXIST);
$context = context_course::instance($course->id);
self::validate_context($context);
// Check that current user have permissions to see this user's activities.
if ($user->id != $USER->id) {
require_capability('report/progress:view', $context);
if (!groups_user_groups_visible($course, $user->id)) {
// We are not in the same group!
throw new moodle_exception('accessdenied', 'admin');
}
}
$completion = new completion_info($course);
$activities = $completion->get_activities();
$progresses = $completion->get_progress_all();
$userprogress = $progresses[$user->id];
$results = array();
foreach ($activities as $activity) {
// Check if current user has visibility on this activity.
if (!$activity->uservisible) {
continue;
}
// Get progress information and state.
if (array_key_exists($activity->id, $userprogress->progress)) {
$thisprogress = $userprogress->progress[$activity->id];
$state = $thisprogress->completionstate;
$timecompleted = $thisprogress->timemodified;
} else {
$state = COMPLETION_INCOMPLETE;
$timecompleted = 0;
}
$results[] = array('cmid' => $activity->id, 'modname' => $activity->modname, 'instance' => $activity->instance, 'state' => $state, 'timecompleted' => $timecompleted, 'tracking' => $activity->completion);
}
$results = array('statuses' => $results, 'warnings' => $warnings);
return $results;
}
require_capability('coursereport/progress:view', $context);
// Get group mode
$group = groups_get_course_group($course, true);
// Supposed to verify group
if ($group === 0 && $course->groupmode == SEPARATEGROUPS) {
require_capability('moodle/site:accessallgroups', $context);
}
// Get data on activities and progress of all users, and give error if we've
// nothing to display (no users or no activities)
$reportsurl = $CFG->wwwroot . '/course/report.php?id=' . $course->id;
$completion = new completion_info($course);
$activities = $completion->get_activities();
if (count($activities) == 0) {
print_error('err_noactivities', 'completion', $reportsurl);
}
$progress = $completion->get_progress_all($firstnamesort, $group, $csv ? 0 : COMPLETION_REPORT_PAGE, $csv ? 0 : $start);
if ($csv) {
header('Content-Disposition: attachment; filename=progress.' . preg_replace('/[^a-z0-9-]/', '_', strtolower($course->shortname)) . '.csv');
// Unicode byte-order mark for Excel
if ($excel) {
header('Content-Type: text/csv; charset=UTF-16LE');
print chr(0xff) . chr(0xfe);
$sep = "\t" . chr(0);
$line = "\n" . chr(0);
} else {
header('Content-Type: text/csv; charset=UTF-8');
$sep = ",";
$line = "\n";
}
} else {
// Use SVG to draw sideways text if supported
public static function get_completion($userid, $courseid)
{
global $DB;
// Going to build an array for the data.
$data = array();
// Count the three statii for the graph.
$notstarted = 0;
$inprogress = 0;
$completed = 0;
// Get completion data for course.
// Get course object.
if (!($course = $DB->get_record('course', array('id' => $courseid)))) {
error('unable to find course record');
}
$datum = new stdclass();
$datum->coursename = $course->fullname;
// Instantiate completion info thingy.
$info = new completion_info($course);
// Get gradebook details.
$gbsql = "select gg.finalgrade as result from {grade_grades} gg, {grade_items} gi\n WHERE gi.courseid={$courseid} AND gi.itemtype='course' AND gg.userid={$userid}\n AND gi.id=gg.itemid";
if (!($gradeinfo = $DB->get_record_sql($gbsql))) {
$gradeinfo = new object();
$gradeinfo->result = null;
}
// If completion is not enabled on the course
// there's no point carrying on.
if (!$info->is_enabled()) {
$datum->enabled = false;
$data[$courseid] = $datum;
return false;
} else {
$datum->enabled = true;
}
// Get criteria for coursed.
// This is an array of tracked activities (only tracked ones).
$criteria = $info->get_criteria();
// Number of tracked activities to complete.
$trackedcount = count($criteria);
$datum->trackedcount = $trackedcount;
// Get data for all users in course.
// This is an array of users in the course. It contains a 'progress'
// array showing completed *tracked* activities.
$progress = $info->get_progress_all();
$u = new stdclass();
// Iterate over users to get info.
if (isset($progress[$userid])) {
$user = $progress[$userid];
// Find user's completion info for this course.
if ($completioninfo = $DB->get_record('course_completions', array('userid' => $user->id, 'course' => $courseid))) {
$u->timeenrolled = $completioninfo->timeenrolled;
if (!empty($completioninfo->timestarted)) {
$u->timestarted = $completioninfo->timestarted;
if (!empty($completioninfo->timecompleted)) {
$u->timecompleted = $completioninfo->timecompleted;
$u->status = 'completed';
++$completed;
} else {
$u->timecompleted = 0;
$u->status = 'inprogress';
++$inprogress;
}
} else {
$u->timestarted = 0;
$u->status = 'notstarted';
++$notstarted;
}
} else {
$u->timeenrolled = 0;
$u->timecompleted = 0;
$u->timestarted = 0;
$u->status = 'notstarted';
++$notstarted;
}
} else {
$u->completed_count = 0;
$u->completed_percent = '--';
$u->completed_progress = 'notstarted';
}
$u->result = round($gradeinfo->result, 0);
$datum->completion = $u;
$data[$courseid] = $datum;
// Make return object.
$returnobj = new stdclass();
$returnobj->data = $data;
$returnobj->criteria = $criteria;
return $returnobj;
}
public static function get_completion($companyid, $courseid = 0, $wantedusers = null, $compfrom = 0, $compto = 0)
{
global $DB, $CFG;
// Get list of course ids.
$courseids = array();
if ($courseid == 0) {
if (!($courses = $DB->get_records_sql("SELECT c.id AS courseid FROM {course} c\n WHERE c.id in (\n SELECT courseid FROM {companycourse}\n WHERE companyid = {$companyid} )\n OR c.id in (\n SELECT pc.courseid FROM {iomad_courses} pc\n INNER JOIN {company_shared_courses} csc\n ON pc.courseid=csc.courseid\n WHERE pc.shared=2\n AND csc.companyid = {$companyid} )\n OR c.id in (\n SELECT pc.courseid FROM {iomad_courses} pc\n WHERE pc.shared=1)"))) {
// No courses for company, so exit.
return false;
}
foreach ($courses as $course) {
$courseids[] = $course->courseid;
}
} else {
$courseids[] = $courseid;
}
// Going to build an array for the data.
$data = array();
// Count the three statii for the graph.
$notstarted = 0;
$inprogress = 0;
$completed = 0;
// Get completion data for each course.
foreach ($courseids as $courseid) {
// Get course object.
if (!($course = $DB->get_record('course', array('id' => $courseid)))) {
error('unable to find course record');
}
$datum = null;
$datum->coursename = $course->fullname;
// Instantiate completion info thingy.
$info = new completion_info($course);
// If completion is not enabled on the course
// there's no point carrying on.
if (!$info->is_enabled()) {
$datum->enabled = false;
$data[$courseid] = $datum;
continue;
} else {
$datum->enabled = true;
}
// Get criteria for coursed.
// This is an array of tracked activities (only tracked ones).
$criteria = $info->get_criteria();
// Number of tracked activities to complete.
$trackedcount = count($criteria);
$datum->trackedcount = $trackedcount;
// Get data for all users in course.
// This is an array of users in the course. It contains a 'progress'
// array showing completed *tracked* activities.
$progress = $info->get_progress_all();
// Iterate over users to get info.
$users = array();
$numusers = 0;
$numprogress = 0;
$numcomplete = 0;
$numnotstarted = 0;
foreach ($wantedusers as $wanteduser) {
if (empty($progress[$wanteduser])) {
continue;
}
$user = $progress[$wanteduser];
++$numusers;
$u = null;
$u->fullname = fullname($user);
// Count of progress is the number they have completed.
$u->completed_count = count($user->progress);
if ($trackedcount > 0) {
$u->completed_percent = round(100 * $u->completed_count / $trackedcount, 2);
} else {
$u->completed_percent = '0';
}
// Find user's completion info for this course.
if ($completioninfo = $DB->get_record('course_completions', array('userid' => $user->id, 'course' => $courseid))) {
if ((!empty($compfrom) || !empty($compto)) && empty($completioninfo->timecompleted)) {
continue;
} else {
if (!empty($compfrom) && $completioninfo->timecompleted < $compfrom) {
continue;
} else {
if (!empty($compto) && $completioninfo->timecompleted > $compto) {
continue;
} else {
$u->timeenrolled = $completioninfo->timeenrolled;
if (!empty($completioninfo->timestarted)) {
$u->timestarted = $completioninfo->timestarted;
if (!empty($completioninfo->timecompleted)) {
$u->timecompleted = $completioninfo->timecompleted;
$u->status = 'completed';
++$numcomplete;
} else {
$u->timecompleted = 0;
$u->status = 'inprogress';
++$numprogress;
}
} else {
$u->timestarted = 0;
$u->status = 'notstarted';
++$numnotstarted;
}
}
}
}
} else {
$u->timeenrolled = 0;
$u->timecompleted = 0;
$u->timestarted = 0;
$u->status = 'notstarted';
++$numnotstarted;
}
// Get the users score.
$gbsql = "select gg.finalgrade as result from {grade_grades} gg, {grade_items} gi\n WHERE gi.courseid={$courseid} AND gi.itemtype='course' AND gg.userid=" . $user->id . "\n AND gi.id=gg.itemid";
if (!($gradeinfo = $DB->get_record_sql($gbsql))) {
$gradeinfo = new object();
$gradeinfo->result = null;
}
$u->result = round($gradeinfo->result, 0);
$userinfo = $DB->get_record('user', array('id' => $user->id));
$u->email = $userinfo->email;
$u->id = $user->id;
$u->department = company_user::get_department_name($user->id);
// Add to revised user array.
$users[$user->id] = $u;
}
$datum->users = $users;
$datum->completed = $numcomplete;
$datum->numusers = $numusers;
$datum->started = $numnotstarted;
$datum->inprogress = $numprogress;
$data[$courseid] = $datum;
}
// Make the data for the graph.
$graphdata = array('notstarted' => $notstarted, 'inprogress' => $inprogress, 'completed' => $completed);
// Make return object.
$returnobj = null;
$returnobj->data = $data;
$returnobj->graphdata = $graphdata;
return $returnobj;
}
public function get_completion($companyid, $courseid = 0)
{
global $DB;
// Get list of course ids.
$courseids = array();
if ($courseid == 0) {
if (!($courses = $DB->get_records('companycourse', array('companyid' => $companyid)))) {
// No courses for company, so exit.
return false;
}
foreach ($courses as $course) {
$courseids[] = $course->courseid;
}
} else {
$courseids[] = $courseid;
}
// Going to build an array for the data.
$data = array();
// Count the three statii for the graph.
$notstarted = 0;
$inprogress = 0;
$completed = 0;
// Get completion data for each course.
foreach ($courseids as $courseid) {
// Get course object.
if (!($course = $DB->get_record('course', array('id' => $courseid)))) {
error('unable to find course record');
}
$datum = null;
$datum->coursename = $course->fullname;
// Instantiate completion info thingy.
$info = new completion_info($course);
// If completion is not enabled on the course
// there's no point carrying on.
if (!$info->is_enabled()) {
$datum->enabled = false;
$data[$courseid] = $datum;
continue;
} else {
$datum->enabled = true;
}
// Get criteria for coursed.
// This is an array of tracked activities (only tracked ones).
$criteria = $info->get_criteria();
// Number of tracked activities to complete.
$trackedcount = count($criteria);
$datum->trackedcount = $trackedcount;
// Get data for all users in course.
// This is an array of users in the course. It contains a 'progress'
// array showing completed *tracked* activities.
$progress = $info->get_progress_all();
// Iterate over users to get info.
$users = array();
$numusers = 0;
$numprogress = 0;
$numcomplete = 0;
$numnotstarted = 0;
foreach ($progress as $user) {
++$numusers;
$u = null;
$u->fullname = fullname($user);
// Count of progress is the number they have completed.
$u->completed_count = count($user->progress);
if ($trackedcount > 0) {
$u->completed_percent = round(100 * $u->completed_count / $trackedcount, 2);
} else {
$u->completed_percent = '0';
}
// Find user's last access to this course.
if ($lastaccess = $DB->get_record('user_lastaccess', array('userid' => $user->id, 'courseid' => $courseid))) {
$u->lastaccess = $lastaccess->timeaccess;
} else {
$u->lastaccess = 0;
}
// Work out status.
if ($u->completed_percent == 0) {
$u->status = 'notstarted';
++$notstarted;
++$numnotstarted;
} else {
if ($u->completed_percent < 100) {
$u->status = 'inprogress';
++$inprogress;
++$numprogress;
} else {
$u->status = 'completed';
++$completed;
++$numcomplete;
}
}
// Add to revised user array.
$users[$user->id] = $u;
}
$datum->users = $users;
$datum->completed = $numcomplete;
$datum->numusers = $numusers;
$datum->started = $numnotstarted;
$datum->inprogress = $numprogress;
$data[$courseid] = $datum;
}
// Make the data for the graph.
$graphdata = array('notstarted' => $notstarted, 'inprogress' => $inprogress, 'completed' => $completed);
// Make return object.
$returnobj = null;
$returnobj->data = $data;
$returnobj->graphdata = $graphdata;
return $returnobj;
}
