* @copyright 2013 Davo Smith, Synergy Learning * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ require_once dirname(__FILE__) . '/../../config.php'; global $CFG, $DB, $PAGE, $OUTPUT; require_once $CFG->dirroot . '/mod/attendance/locallib.php'; require_once $CFG->dirroot . '/mod/attendance/tempmerge_form.php'; $id = required_param('id', PARAM_INT); $userid = required_param('userid', PARAM_INT); $cm = get_coursemodule_from_id('attendance', $id, 0, false, MUST_EXIST); $course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST); $att = $DB->get_record('attendance', array('id' => $cm->instance), '*', MUST_EXIST); $tempuser = $DB->get_record('attendance_tempusers', array('id' => $userid), '*', MUST_EXIST); $att = new attendance($att, $cm, $course); $params = array('userid' => $tempuser->id); $PAGE->set_url($att->url_tempmerge($params)); require_login($course, true, $cm); $PAGE->set_title($course->shortname . ": " . $att->name . ' - ' . get_string('tempusermerge', 'attendance')); $PAGE->set_heading($course->fullname); $PAGE->set_cacheable(true); $PAGE->set_button($OUTPUT->update_module_button($cm->id, 'attendance')); $PAGE->navbar->add(get_string('tempusermerge', 'attendance')); $formdata = (object) array('id' => $cm->id, 'userid' => $tempuser->id); $custom = array('description' => format_string($tempuser->fullname) . ' (' . format_string($tempuser->email) . ')'); $mform = new tempmerge_form(null, $custom); $mform->set_data($formdata); if ($mform->is_cancelled()) { redirect($att->url_managetemp()); } else { if ($data = $mform->get_data()) { $sql = "SELECT s.id, lr.id AS reallogid, lt.id AS templogid\n FROM {attendance_sessions} s\n LEFT JOIN {attendance_log} lr ON lr.sessionid = s.id AND lr.studentid = :realuserid\n LEFT JOIN {attendance_log} lt ON lt.sessionid = s.id AND lt.studentid = :tempuserid\n WHERE s.attendanceid = :attendanceid AND lt.id IS NOT NULL\n ORDER BY s.id";
function print_tempusers($tempusers, attendance $att) { echo '<p></p>'; echo '<table border="1" bordercolor="#EEEEEE" style="background-color:#fff" cellpadding="2" align="center"' . 'width="80%" summary="' . get_string('temptable', 'attendance') . '"><tr>'; echo '<th class="header">' . get_string('tusername', 'attendance') . '</th>'; echo '<th class="header">' . get_string('tuseremail', 'attendance') . '</th>'; echo '<th class="header">' . get_string('tcreated', 'attendance') . '</th>'; echo '<th class="header">' . get_string('tactions', 'attendance') . '</th>'; echo '</tr>'; $even = false; // Used to colour rows. foreach ($tempusers as $tempuser) { if ($even) { echo '<tr style="background-color: #FCFCFC">'; } else { echo '<tr>'; } $even = !$even; echo '<td>' . format_string($tempuser->fullname) . '</td>'; echo '<td>' . format_string($tempuser->email) . '</td>'; echo '<td>' . userdate($tempuser->created, get_string('strftimedatetime')) . '</td>'; $params = array('userid' => $tempuser->id); $editlink = html_writer::link($att->url_tempedit($params), get_string('edituser', 'attendance')); $deletelink = html_writer::link($att->url_tempdelete($params), get_string('deleteuser', 'attendance')); $mergelink = html_writer::link($att->url_tempmerge($params), get_string('mergeuser', 'attendance')); echo '<td>' . $editlink . ' | ' . $deletelink . ' | ' . $mergelink . '</td>'; echo '</tr>'; } echo '</table>'; }