/** * Returns an array of available roles * @return array of availble roles */ function get_roles() { global $DB; $myuser = users::getInstance(); $context = context_system::instance(); $rs = $DB->get_records_sql("SELECT * FROM {role} WHERE archetype = 'student'"); $role = array(); foreach ($rs as $r) { $role[$r->id] = ucwords($r->shortname); } $systemroles = $myuser->systemroles_custom(); $roles = array(0 => get_string('anyrole', 'filters')) + $systemroles + $role; return $roles; }
function user_download_xls($fields) { $hier = new hierarchy(); $schools = $hier->get_assignedschools(); global $CFG, $DB; require_once("$CFG->libdir/excellib.class.php"); $filename = clean_filename('Users.xls'); $workbook = new MoodleExcelWorkbook('-'); $workbook->send($filename); $worksheet = array(); $worksheet[0] = $workbook->add_worksheet(''); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write(0, $col, $fieldname); $col++; } $sheetrow = 1; $myuser = users::getInstance(); $users = $DB->get_records_sql("SELECT u.id, u.username, u.email, u.firstname, u.lastname, u.city, u.country, u.lastaccess, u.confirmed, u.mnethostid, u.suspended FROM {user} u, {local_users} lu WHERE lu.userid = u.id "); foreach ($users as $user) { $rid = $myuser->get_rolename($user->id); $post = new stdclass(); $post->firstname = $user->firstname; $post->lastname = $user->lastname; $post->email = $user->email; $post->schoolname = $myuser->get_schoolnames($user); $post->roleid = $myuser->get_rolename($user->id); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write($sheetrow, $col, $post->$fieldname); $col++; } $sheetrow++; } $workbook->close(); die; }
$currentcss = '/local/courseregistration/css/styles.css'; $PAGE->requires->css($currentcss); $PAGE->requires->js('/local/courseregistration/js/expand.js'); /* ---check the context level of the user and check weather the user is login to the system or not--- */ $PAGE->set_context($systemcontext); if ($CFG->forcelogin) { require_login(); } else { user_accesstime_log(); } $PAGE->set_url('/local/courseregistration/mycur.php'); /* ---Header and the navigation bar--- */ $PAGE->set_heading($SITE->fullname); $PAGE->navbar->add(get_string('mycurriculum', 'local_curriculum')); $users = users::getInstance(); echo $OUTPUT->header(); /* ---Heading of the page--- */ echo $OUTPUT->heading(get_string('mycurriculum', 'local_curriculum')); /* ---Moodle 2.2 and onwards--- */ $currenttab = 'myplan'; /* ---adding tabs--- */ $exams->studentside_tabs($currenttab); if (isset($CFG->allowframembedding) and ! $CFG->allowframembedding) { echo $OUTPUT->box(get_string('mycurriculumdec', 'local_curriculum')); } // -----used get to cuurent active semesterid-------------------------------- $hier = new hierarchy(); $semesterid = $hier->get_allmyactivesemester($USER->id);
//require_once($CFG->dirroot . '/local/admission/lib.php'); require_once($CFG->dirroot . '/local/users/user_form.php'); require_once($CFG->dirroot . '/local/costcenter/lib.php'); require_once($CFG->dirroot . '/user/editlib.php'); require_once($CFG->dirroot . '/user/profile/lib.php'); require_once($CFG->libdir . '/gdlib.php'); require_once($CFG->libdir . '/adminlib.php'); require_once($CFG->dirroot . '/local/positions/lib.php'); $id = optional_param('id', -1, PARAM_INT); $delete = optional_param('delete', 0, PARAM_INT); $visible = optional_param('visible', -1, PARAM_INT); $confirm = optional_param('confirm', 0, PARAM_INT); global $CFG; $myuser = users::getInstance(); $costcenter = new costcenter(); $conf = new object(); $systemcontext = context_system::instance(); //get the admin layout $PAGE->set_pagelayout('admin'); //check the context level of the user and check weather the user is login to the system or not $PAGE->set_context($systemcontext); require_login(); //if (!has_capability('local/costcenter:manage', $systemcontext)) { // print_error('You dont have permissions'); //} $PAGE->set_url('/local/users/user.php');
/** * @method student_currculum_progress * @todo to print student curriculum progress bar * @param int $curid curriculum id, int $schoid schoolid * @return- print progress bar */ function student_currculum_progress($curid, $schoid) { global $CFG, $DB, $USER; $myuser = users::getInstance(); $courses = $DB->get_records('local_curriculum_plancourses', array('curriculumid' => $curid)); $course_count = sizeof($courses); $enrolled = 0; $completed = 0; foreach ($courses as $course) { $status = $myuser->get_coursestatus($course->courseid, $USER->id); if ($status != 'Not Enrolled') { $enrolled++; if ($status != 'Enrolled (Inprogress)') $completed++; } } $curculum = $DB->get_record('local_curriculum', array('id' => $curid)); $program = $DB->get_record('local_program', array('id' => $curculum->programid)); $grades = $DB->get_record('local_cobalt_gpasettings', array('schoolid' => $schoid, 'sub_entityid' => $program->programlevel)); $cgpa = $DB->get_field('local_graduation', 'finalcgpa', array('userid' => $USER->id, 'schoolid' => $schoid, 'curriculumid' => $curid)); if (empty($cgpa)) { $cgpa = 'Not Graded'; } $totalcredit = $DB->get_field('local_level_settings', 'mincredithours', array('schoolid' => $schoid, 'levelid' => $curculum->programid, 'level' => 'PL')); if (empty($totalcredit)) { $totalcredit = 'Not Applicable'; } $usercredits = "SELECT sum(totcredithours) as total FROM {local_user_sem_details} WHERE userid={$USER->id} AND curriculumid={$curid}"; $usercredit = $DB->get_record_sql($usercredits); $gpasql = "SELECT * FROM {local_user_sem_details} WHERE userid={$USER->id} AND curriculumid={$curid}"; $gpaqry = $DB->get_records_sql($gpasql); $gpacount = sizeof($gpaqry); if ($completed < $enrolled || $enrolled == 0) { $one = "<img src='pix/unsuccess.png'>"; } else { $one = "<img src='pix/success.png'>"; } if ($totalcredit <= $usercredit->total) { $two = "<img src='pix/success.png'>"; } else { $two = "<img src='pix/unsuccess.png'>"; } /* * ###Bugreport#181-Curriculum * @author Naveen Kumar<*****@*****.**> * (Resolved) checking both empty and less than or equal to cgpa */ if (round($grades->cgpa) <= $cgpa && !empty($grades->cgpa)) { $three = "<img src='pix/success.png'>"; } else { $three = "<img src='pix/unsuccess.png'>"; } $string .= html_writer::start_tag('div', array('style'=>'border: 1px solid #E8E8E8; background: #EAEAEA; padding: 10px; width: 97%; margin: 25px 0 25px; font-weight: bold; overflow: auto;')); $string .= html_writer::tag('div', $program->fullname, array('style'=>'float: left;')); $string .= html_writer::tag('div', $curculum->fullname, array('style'=>'float: right;')); $string .= html_writer::end_tag('div'); echo $string; //========By Vinod for DYPatil // $table = new html_table(); // $table->align = array('left', 'left', 'left', 'left'); // $table->size = array('20%', '36%', '32%', '12%'); // $table->width = '100%'; // $cell = new html_table_cell(); // $cell->text = 'Graduation will be given if following conditions are met<br> ' . $one . ' Need to complete all enrolled courses in curriculum .<br> ' . $two . ' Credithours should be greater than or equal to required credit hours.<br> // ' . $three . ' CGPA achieved is equal or greater than to required CGPA.<br> '; // $cell->colspan = 3; // $table->data[] = array('Program Name', '<b>' . $program->fullname . '</b>', 'Total Number of Courses', '<b>' . $course_count . '</b>'); // $table->data[] = array('Curriculum Name', '<b>' . $curculum->fullname . '</b>', 'Total Number of Enroled Courses', '<b>' . $enrolled . '</b>'); // $table->data[] = array('Required Credithours', '<b>' . $totalcredit . '</b>', 'Total Number of Completed Courses', '<b>' . $completed . '</b>'); // $table->data[] = array('Credithours Achieved', '<b>' . $usercredit->total . '</b>', 'Required CGPA', '<b>' . round($grades->cgpa) . '</b>'); // // $table->data[] = array('Progress', get_my_progress($USER->id, 0, $curid), 'CGPA Achieved', '<b>' . round($cgpa) . '</b>'); // $table->data[] = array('Description', $cell); // // echo html_writer::table($table); }