. /** * local functions and constants for module attendance * * @package mod_attendance * @copyright 2011 Artem Andreev * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); require_once($CFG->libdir . '/gradelib.php'); require_once(dirname(__FILE__).'/renderhelpers.php'); define('ATT_VIEW_DAYS', 1); define('ATT_VIEW_WEEKS', 2); define('ATT_VIEW_MONTHS', 3); define('ATT_VIEW_ALLPAST', 4); define('ATT_VIEW_ALL', 5); define('ATT_VIEW_NOTPRESENT', 6); define('ATT_VIEW_SUMMARY', 7); define('ATT_SORT_DEFAULT', 0); define('ATT_SORT_LASTNAME', 1); define('ATT_SORT_FIRSTNAME', 2); function attendance_get_statuses($attid, $onlyvisible=true, $statusset = -1) { global $DB; // Set selector. $params = array('aid' => $attid); $setsql = ''; if ($statusset >= 0) { $params['statusset'] = $statusset; $setsql = ' AND setnumber = :statusset '; } if ($onlyvisible) { $statuses = $DB->get_records_select('attendance_statuses', "attendanceid = :aid AND visible = 1 AND deleted = 0 $setsql", $params, 'setnumber ASC, grade DESC'); } else { $statuses = $DB->get_records_select('attendance_statuses', "attendanceid = :aid AND deleted = 0 $setsql", $params, 'setnumber ASC, grade DESC'); } return $statuses; } /** * Get the name of the status set. * * @param int $attid * @param int $statusset * @param bool $includevalues * @return string */ function attendance_get_setname($attid, $statusset, $includevalues = true) { $statusname = get_string('statusset', 'mod_attendance', $statusset + 1); if ($includevalues) { $statuses = attendance_get_statuses($attid, true, $statusset); $statusesout = array(); foreach ($statuses as $status) { $statusesout[] = $status->acronym; } if ($statusesout) { if (count($statusesout) > 6) { $statusesout = array_slice($statusesout, 0, 6); $statusesout[] = '&helip;'; } $statusesout = implode(' ', $statusesout); $statusname .= ' ('.$statusesout.')'; } } return $statusname; } function attendance_get_user_courses_attendances($userid) { global $DB; $usercourses = enrol_get_users_courses($userid); list($usql, $uparams) = $DB->get_in_or_equal(array_keys($usercourses), SQL_PARAMS_NAMED, 'cid0'); $sql = "SELECT att.id as attid, att.course as courseid, course.fullname as coursefullname, course.startdate as coursestartdate, att.name as attname, att.grade as attgrade FROM {attendance} att JOIN {course} course ON att.course = course.id WHERE att.course $usql ORDER BY coursefullname ASC, attname ASC"; $params = array_merge($uparams, array('uid' => $userid)); return $DB->get_records_sql($sql, $params); } /** * Used to calculate a fraction based on the part and total values * * @param float $part - part of the total value * @param float $total - total value. * @return float the calculated fraction. */ function attendance_calc_fraction($part, $total) { if ($total == 0) { return 0; } else { return $part / $total; } } /** * Check to see if statusid in use to help prevent deletion etc. * * @param integer $statusid */ function attendance_has_logs_for_status($statusid) { global $DB; return $DB->record_exists('attendance_log', array('statusid' => $statusid)); } /** * Helper function to add sessiondate_selector to add/update forms. * * @param MoodleQuickForm $mform */ function attendance_form_sessiondate_selector (MoodleQuickForm $mform) { $mform->addElement('date_selector', 'sessiondate', get_string('sessiondate', 'attendance')); for ($i = 0; $i <= 23; $i++) { $hours[$i] = sprintf("%02d", $i); } for ($i = 0; $i < 60; $i += 5) { $minutes[$i] = sprintf("%02d", $i); } $sesendtime = array(); $sesendtime[] =& $mform->createElement('static', 'from', '', get_string('from', 'attendance')); $sesendtime[] =& $mform->createElement('select', 'starthour', get_string('hour', 'form'), $hours, false, true); $sesendtime[] =& $mform->createElement('select', 'startminute', get_string('minute', 'form'), $minutes, false, true); $sesendtime[] =& $mform->createElement('static', 'to', '', get_string('to', 'attendance')); $sesendtime[] =& $mform->createElement('select', 'endhour', get_string('hour', 'form'), $hours, false, true); $sesendtime[] =& $mform->createElement('select', 'endminute', get_string('minute', 'form'), $minutes, false, true); $mform->addGroup($sesendtime, 'sestime', get_string('time', 'attendance'), array(' '), true); } /** * Count the number of status sets that exist for this instance. * * @param int $attendanceid * @return int */ function attendance_get_max_statusset($attendanceid) { global $DB; $max = $DB->get_field_sql('SELECT MAX(setnumber) FROM {attendance_statuses} WHERE attendanceid = ? AND deleted = 0', array($attendanceid)); if ($max) { return $max; } return 0; } /** * Returns the maxpoints for each statusset * * @param array statuses * @return array */ function attendance_get_statusset_maxpoints($statuses) { $statussetmaxpoints = array(); foreach ($statuses as $st) { if (!isset($statussetmaxpoints[$st->setnumber])) { $statussetmaxpoints[$st->setnumber] = $st->grade; } } return $statussetmaxpoints; } /** * Update user grades * * @param mixed mod_attendance_structure|stdClass $attendance * @param array $userids */ function attendance_update_users_grade($attendance, $userids=array()) { global $DB; if (empty($attendance->grade)) { return false; } list($course, $cm) = get_course_and_cm_from_instance($attendance->id, 'attendance'); $summary = new mod_attendance_summary($attendance->id, $userids); if (empty($userids)) { $context = context_module::instance($cm->id); $userids = array_keys(get_enrolled_users($context, 'mod/attendance:canbelisted', 0, 'u.id')); } if ($attendance->grade < 0) { $dbparams = array('id' => -($attendance->grade)); $scale = $DB->get_record('scale', $dbparams); $scalearray = explode(',', $scale->scale); $attendancegrade = count($scalearray); } else { $attendancegrade = $attendance->grade; } $grades = array(); foreach ($userids as $userid) { $grades[$userid] = new stdClass(); $grades[$userid]->userid = $userid; if ($summary->has_taken_sessions($userid)) { $usersummary = $summary->get_taken_sessions_summary_for($userid); $grades[$userid]->rawgrade = $usersummary->takensessionspercentage * $attendancegrade; } else { $grades[$userid]->rawgrade = null; } } return grade_update('mod/attendance', $course->id, 'mod', 'attendance', $attendance->id, 0, $grades); }