global $DB, $CFG; require_login(); $systemcontext = context_system::instance(); //check the context level of the user and check weather the user is login to the system or not $PAGE->set_context($systemcontext); $PAGE->set_url('/local/curriculum/assigncourses.php'); $PAGE->set_title(get_string('curriculum', 'local_curriculum') . ': ' . get_string('assigncourses', 'local_curriculum')); //Header and the navigation bar $PAGE->set_heading(get_string('curriculumplan', 'local_curriculum')); $PAGE->set_pagelayout('admin'); $cplan = curriculumplan::getInstance(); $conf = new object(); $returnurl = new moodle_url('/local/curriculum/assigncourses.php', array('id' => $id, 'mode' => $mode, 'cid' => $cid)); $hierarchy = new hierarchy(); //Adding the courses to the Curriculumplan if (!empty($moveto) and $data = data_submitted()) { $crs = array(); foreach ($data as $key => $value) { if (preg_match('/^c\d+$/', $key)) { $cuid = substr($key, 1); array_push($crs, $cuid); } } $currenturl = new moodle_url('/local/curriculum/assigncourses.php', array('id' => $id, 'mode' => $mode, 'cid' => $cid));
function display_active_classes(){ global $DB, $CFG, $USER; $string = '<div id="academic_status_tabs"><ul>'; $string.='<li><a href="#fragment-1"><span>My Classes</span></a></li>'; $string .='<li><a href="#fragment-2"><span>Time Table</span></a></li> <li><a href="#fragment-3"><span>Curriculum</span></a></li> </ul>'; // Tab for My Classes============ $string.='<div id="fragment-1">'; $sql = "SELECT plancourse.*, curriculum.programid, map.batchid FROM {local_curriculum_plancourses} AS plancourse JOIN {local_curriculum_plan} AS plan ON plan.id = plancourse.planid JOIN {local_curriculum} AS curriculum ON curriculum.id = plan.curriculumid JOIN {local_batch_map} AS map ON map.curriculumid = curriculum.id AND map.programid = curriculum.programid JOIN {cohort_members} AS member ON member.cohortid = map.batchid WHERE member.userid = {$USER->id}"; $records = $DB->get_records_sql($sql); $today = date('Y-m-d'); $semsql = "SELECT * FROM {local_semester} WHERE '{$today}' <= FROM_UNIXTIME(enddate, '%Y-%m-%d') ORDER BY enddate ASC LIMIT 1"; $semester = $DB->get_record_sql($semsql); $record = $DB->get_record('local_userdata', array('userid'=>$USER->id)); if(is_null($record->batchid)){ $batch = $DB->get_record('cobort_members', array('userid'=>$USER->id)); $record->batchid = $batch->cohortid; } $activeplan = $DB->get_record('local_activeplan_batch', array('batchid'=>$record->batchid, 'semesterid'=>$semester->id)); $program = $DB->get_record('local_program', array('id'=>$record->programid)); $plan = $DB->get_record('local_curriculum_plan', array('id'=>$activeplan->planid)); $string .= html_writer::start_tag('div', array('style'=>'width: 100%; margin: 10px 0 25px; font-weight: bold; overflow: auto;color: #82152C;font-family: SourceSansPro-Semibold;')); $string .= html_writer::tag('div', $program->fullname, array('style'=>'float: left;')); $string .= html_writer::tag('div', $plan->fullname.' ('.$semester->fullname.')', array('style'=>'float: right;')); $string .= html_writer::end_tag('div'); $data = array(); foreach($records as $record){ if(!$offernow = $DB->get_record('local_activeplan_batch', array('planid'=>$record->planid, 'batchid'=>$record->batchid))){ continue; } $row = array(); $course = $DB->get_record('local_cobaltcourses', array('id'=>$record->courseid), '*', MUST_EXIST); $sql = "SELECT c.* FROM {local_user_clclasses} AS uc JOIN {local_clclasses} AS c ON c.id = uc.classid WHERE c.cobaltcourseid = {$record->courseid} AND uc.userid = {$USER->id} AND registrarapproval = 1"; $class = $DB->get_record_sql($sql); $instuser = ''; if($class->instructor != 0){ $insts = explode(',', $class->instructor); foreach($insts as $inst){ if($inst){ $instructor = $DB->get_record('user', array('id'=>$inst), '*', MUST_EXIST); $instuser .= html_writer::tag('div', fullname($instructor), array()); } } } $row[] = $course->fullname; //$row[] = $class ? $class->shortname : 'Not yet created'; $row[] = $instuser != '' ? $instuser : '******'; $row[] = '-'; //'Attendance' $row[] = $class ? html_writer::tag('a', '<button>Launch</button>', array('href'=>$CFG->wwwroot.'/course/view.php?id='.$class->onlinecourseid, 'target'=>'_blank')) : '-'; $data[] = $row; } if(!empty($data)){ $table = new html_table(); $table->data = $data; $table->head = array('Course', 'Instructor', 'Attendance', 'Launch Course'); $table->align = array('left', 'left', 'left', 'center'); $string .= html_writer::table($table); } else { $string .= 'No Records Found'; } $string .= '</div>'; // End of Myclasses #fragment-1 // Tab for Timetable ================== global $OUTPUT; $string.='<div id="fragment-2">'; $string .= html_writer::start_tag('div', array('style'=>'width: 100%; margin: 10px 0 25px; font-weight: bold; overflow: auto;color: #82152C;font-family: SourceSansPro-Semibold;')); $string .= html_writer::tag('div', $program->fullname, array('style'=>'float: left;')); $string .= html_writer::tag('div', $plan->fullname.' ('.$semester->fullname.')', array('style'=>'float: right;')); $string .= html_writer::end_tag('div'); $src = $CFG->wwwroot.'/blocks/academic_status/pix/'.$program->shortname.'_'.$plan->fullname.'.png'; //$src = $OUTPUT->pix_url($program->shortname.'_'.$plan->fullname, 'blocks_academic_status'); $string .= html_writer::empty_tag('img', array('src'=>$src, 'alt'=>'Timetable for BBE_Semester - I')); $string .= '</div>'; // End of Timetable #fragment-2 // Tab for Curriculum plan ================== $string.='<div id="fragment-3">'; $assignedcount = $DB->count_records('local_userdata', array('userid'=>$USER->id)); //if($assignedcount > 1){ // $records = $DB->get_records('local_userdata', array('userid'=>$USER->id)); //} else { $record = $DB->get_record('local_userdata', array('userid'=>$USER->id)); //} require_once($CFG->dirroot . '/local/curriculum/lib.php'); global $PAGE; $currentcss = '/local/curriculum/css/styles.css'; $PAGE->requires->css($currentcss); $cplan = curriculumplan::getInstance(); $program = $DB->get_record('local_program', array('id'=>$record->programid)); $curriculum = $DB->get_record('local_curriculum', array('id'=>$record->curriculumid)); $string .= html_writer::start_tag('div', array('style'=>'width: 100%; margin: 10px 0 25px; font-weight: bold; overflow: auto; color: #82152C;font-family: SourceSansPro-Semibold;')); $string .= html_writer::tag('div', $program->fullname, array('style'=>'float: left;')); $string .= html_writer::tag('div', $curriculum->fullname, array('style'=>'float: right;')); $string .= html_writer::end_tag('div'); $plans = $DB->get_records_sql("SELECT * FROM {local_curriculum_plan} WHERE programid = {$record->programid} AND curriculumid = {$record->curriculumid} ORDER BY sortorder ASC"); $data = array(); foreach ($plans as $plan) { $line = array(); $line[] = $cplan->display_curriculum_plan($plan) ; $data[] = $line; } $table = new html_table(); $table->size = array('65%', '20%', '10%'); $table->align = array('left', 'left', 'left'); $table->width = '100%'; $table->data = $data; $string .= html_writer::table($table); $string .= '</div>'; // End of Curriculum #fragment-3 $string .= '</div>'; // End of Tabs functionality return $string; }