if ($current == "pending")
$sql .=" AND ca.mentorapproval=0 AND ca.registrarapproval=0 ";
else if ($current == "completed")
$sql .=" AND ca.mentorapproval IN (1,2) AND ca.registrarapproval IN (0,1,2)";
$tools = $DB->get_recordset_sql($sql);
$data = array();
foreach ($tools as $tool) {
$line = array();
$buttons = array();
$instructor = array();
$mentorStatus = $tool->mentorapproval;
$approveStatus = $tool->studentapproval;
$registratStatus = $tool->registrarapproval;
$username = get_userdetails($tool->userid);
$line[] = html_writer::tag('a', $username, array('href' => '' . $CFG->wwwroot . '/local/mentor/student.php?id=' . $tool->userid . '', 'title' => get_string('view_academicdetail', 'local_courseregistration')));
$line[] = $tool->shortname;
$line[] = $tool->coursename;
$instrctor = array();
$instructor[] = get_classinst($tool->ids);
$line[] = implode(' ', $instructor[0]);
$line[] = $tool->semestername;
if ($mentorStatus == 0 && $registratStatus == 0) {
$buttons[] = html_writer::link(new moodle_url('/local/courseregistration/mentor.php', array('userid' => $tool->userid, 'classid' => $tool->classid, 'page' => $page, 'current' => $current, 'unapprove' => 1, 'sesskey' => sesskey())), html_writer::empty_tag('img', array('src' => $OUTPUT->pix_url('t/delete'), 'title' => get_string('reject', 'local_courseregistration'), 'alt' => get_string('reject', 'local_courseregistration'), 'class' => 'iconsmall')));
$buttons[] = html_writer::link(new moodle_url('/local/courseregistration/mentor.php', array('userid' => $tool->userid, 'classid' => $tool->classid, 'page' => $page, 'current' => $current, 'approve' => 1, 'sesskey' => sesskey())), html_writer::empty_tag('img', array('src' => $OUTPUT->pix_url('t/check'), 'title' => get_string('approve', 'local_courseregistration'), 'alt' => get_string('approve', 'local_courseregistration'), 'class' => 'iconsmall')));
}
if ($current == "pending") {
$line[] = implode(' ', $buttons);
}
$line[] = get_courseregistrationstatus($approveStatus, $mentorStatus, $registratStatus);
{local_clclasses} lc ON c.classid=lc.id and c.registrarapproval != 3 JOIN
{local_cobaltcourses} cc ON cc.id=lc.cobaltcourseid where (c.event IS NULL or c.event = 'registration') and lc.schoolid in ($assignedschoolstring) group by c.id";
$userclclasses = $DB->get_records_sql($query);
//print_object($userclclasses);
$data = array();
foreach ($userclclasses as $userclass) {
$line = array();
$buttons = array();
$instructor = array();
$mentorStatus = $userclass->mapproval;
$approveStatus = $userclass->sapproval;
$registratStatus = $userclass->rapproval;
$username = get_userdetails($userclass->userid);
$line[] = $username;
$line[] = $userclass->shortname;
$line[] = $userclass->coursename;
$instructor[] = get_classinst($userclass->id);
if ($registratStatus == 0) {
$buttons[] = html_writer::link(new moodle_url('/local/courseregistration/registrar.php', array('userid' => $userclass->userid, 'classid' => $userclass->classid, 'page' => $page, 'current' => 'pending', 'unapprove' => 1, 'sesskey' => sesskey())), html_writer::empty_tag('img', array('src' => $OUTPUT->pix_url('t/delete'), 'title' => get_string('reject', 'local_courseregistration'), 'alt' => get_string('reject', 'local_courseregistration'), 'class' => 'iconsmall')));
$buttons[] = ' ';
$buttons[] = html_writer::link(new moodle_url('/local/courseregistration/registrar.php', array('userid' => $userclass->userid, 'classid' => $userclass->classid, 'page' => $page, 'current' => 'pending', 'approve' => 1, 'sesskey' => sesskey())), html_writer::empty_tag('img', array('src' => $OUTPUT->pix_url('t/check'), 'title' => get_string('approve', 'local_courseregistration'), 'alt' => get_string('approve', 'local_courseregistration'), 'class' => 'iconsmall')));
// checking for mentor status when registrar status is pending
// edited by hemalatha c arun
// checking, is student requesting for adding course or dropping course
if ($approveStatus == 1)
$actionstring = get_string('addd', 'local_adddrop');
