} $data = array(); echo $OUTPUT->header(); $requests = $DB->get_records('local_request_transcript'); foreach ($requests as $request) { $list = array(); $buttons = array(); $details = $DB->get_record_sql("select lud.schoolid,luc.semesterid,lud.userid,lud.serviceid,lud.programid from {local_userdata} lud INNER JOIN {local_user_clclasses} luc ON lud.userid = luc.userid AND lud.userid = {$request->studentid} AND luc.semesterid = {$request->req_semester} group by lud.schoolid"); if ($vals = $DB->get_records_sql("SELECT * FROM {local_school_permissions} where userid = '" . $USER->id . "' and schoolid='" . $details->schoolid . "'")) { $serviceid = $requestpro->service($details->schoolid, $details->programid, $request->studentid); $user = $requestpro->users($details->schoolid, $request->studentid); $list[] = $serviceid->serviceid; $list[] = $user->fullname; $list[] = $DB->get_field('local_school', 'fullname', array('id' => $details->schoolid)); $list[] = $DB->get_field('local_program', 'fullname', array('id' => $details->programid)); $list[] = $DB->get_field('local_semester', 'fullname', array('id' => $request->req_semester)); $list[] = date("Y-m-d", $request->requested_date); $reg_approval = $request->reg_approval; if ($reg_approval == 0) { $list[] = get_string('pending', 'local_request'); } if ($reg_approval == 1) { $list[] = get_string('approvedc', 'local_request'); } if ($reg_approval == 2) {
$PAGE->navbar->add($strheading); $PAGE->set_title($strheading); $requestpro = new requests(); $data = array(); global $USER; $url = '../../local/request/requestprofile.php'; if ($var) { redirect($url); } $data = array(); echo $OUTPUT->header(); $requests = $DB->get_records('local_request_profile_change', array('reg_approval' => '0')); foreach ($requests as $request) { $list = array(); if ($vals = $DB->get_records_sql("SELECT * FROM {local_school_permissions} where userid = '" . $USER->id . "' and schoolid='" . $request->schoolid . "'")) { $serviceid = $requestpro->service($request->schoolid, $request->studentid); $list[] = $serviceid->serviceid; $list[] = $DB->get_field('local_school', 'fullname', array('id' => $request->schoolid)); $list[] = $DB->get_field('local_program', 'fullname', array('id' => $request->programid)); if ($request->subjectcode == 1) { $list[] = get_string('name', 'local_approval'); } if ($request->subjectcode == 2) { $list[] = get_string('emailid', 'local_admission'); } $list[] = "<a href='view.php?id=" . $request->id . "&flag=1'>" . $request->presentdata . "</a>"; $list[] = $request->changeto; $list[] = date("Y-m-d", $request->requested_date); $reg_approval = $request->reg_approval; if ($reg_approval == 0) { $list[] = "<a href='../../local/profilechange/changeprofile.php?confirm=1&recid={$request->id}'>Confirm</a>";
function definition_after_data() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; $requestid = new requests(); $id = $this->_customdata['id']; $school = $mform->getElementValue('school_name'); $countvalue = $mform->getElementValue('count'); $fid = $school[0]; if ($countvalue == 1) { $pro_count = $mform->getElementValue('count_pros'); if ($pro_count > 1) { // single school and more than one program assigned to a user $program1 = $mform->getElementValue('program_name1'); $schoolid = $mform->getElementValue('schoolid'); $pro_index = $program1[0]; if ($pro_index > 0 && $pro_count > 1) { $semesteres = $requestpro->semester($schoolid, $pro_index); $semesteres = $requestid->semester($schoolid, $pro_index); foreach ($semesteres as $s) { $value2 = $s->fullname; } $ser_id = $mform->createElement('static', 'serviceid', get_string('student_id', 'local_request'), $serviceid->serviceid); $mform->insertElementBefore($ser_id, 'program_name'); $sem_name = $mform->createElement('static', 'semester_name', get_string('semester_name', 'local_request'), $value2); $mform->insertElementBefore($sem_name, 'addschool'); } } } // more than one school assiged to a user if ($school[0] > 0 && isset($school) && $countvalue > 1) { $service = $requestid->service($fid); $users = $requestid->users($fid); $programses = $requestid->program($fid); $mypro = array(); $mypro[''] = get_string('selectprogram', 'local_programs'); foreach ($programses as $p) { $mypro[$p->id] = $p->fullname; } $ser_id = $mform->createElement('static', 'serviceid', get_string('student_id', 'local_request'), $service->serviceid); $mform->insertElementBefore($ser_id, 'addschool'); $name = $mform->createElement('static', 'name', get_string('name', 'local_request'), $users->fullname); $mform->insertElementBefore($name, 'addschool'); if (count($mypro) == 2) { // more than school and one program to user $pro_name = $mform->createElement('static', 'program_name', get_string('program_name', 'local_request'), $mypro[$p->id]); $mform->insertElementBefore($pro_name, 'addschool'); $pro_id = $mform->createElement('hidden', 'programid', $p->id); $mform->insertElementBefore($pro_id, 'addschool'); $semesteres = $requestid->semester($fid, $p->id); foreach ($semesteres as $s) { $mysemvalue = $s->fullname; $mysemid = $s->id; } $sems_name = $mform->createElement('static', 'semester_name', get_string('semester_name', 'local_request'), $mysemvalue); $mform->insertElementBefore($sems_name, 'addschool'); $sem_id = $mform->createElement('hidden', 'semesterid', $mysemid); $mform->insertElementBefore($sem_id, 'addschool'); $school_programs = $requestid->school_programs($fid); $programs = array(); $programs[''] = get_string("select", "local_request"); foreach ($school_programs as $sch_pro) { $programs[$sch_pro->id] = $sch_pro->fullname; } $sch_pro = $mform->createElement('select', 'toprogramid', get_string('to_program_name', 'local_request'), $programs); $mform->insertElementBefore($sch_pro, 'addschool'); $mform->addRule('toprogramid', get_string('error_request_transfer', 'local_request'), 'required', null, 'server'); } else { // more than one program and school assined to user $pro_name = $mform->createElement('select', 'program_name', get_string('program_name', 'local_request'), $mypro); $mform->insertElementBefore($pro_name, 'addschool'); $mform->addRule('program_name', get_string('programid', 'local_prefix'), 'required', null, 'client'); } $formatvalue3 = $mform->getElementValue('program_name'); if ($formatvalue3[0] > 0) { $semesteres = $requestid->semester($fid, $formatvalue3[0]); foreach ($semesteres as $s) { $mysemvalue = $s->fullname; } $sem_name = $mform->createElement('static', 'semester_name', get_string('semester_name', 'local_request'), $mysemvalue); $mform->insertElementBefore($sem_name, 'addschool'); } } }
function definition_after_data() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; $id = $this->_customdata['id']; $requestpro = new requests(); $school = $mform->getElementValue('school_name'); $countvalue = $mform->getElementValue('count'); $fields = $mform->getElementValue('field_select'); $fid = $school[0]; if ($countvalue == 1) { $pro_count = $mform->getElementValue('count_pros'); if ($pro_count > 1) { // single school and more than one program assigned to a user $program1 = $mform->getElementValue('program_name1'); $schoolid = $mform->getElementValue('schoolid'); echo $pro_index = $program1[0]; if ($pro_index > 0 && $pro_count > 1) { $semesteres = $requestpro->semester($schoolid, $pro_index); $serviceid = $requestpro->service($schoolid, $pro_index); foreach ($semesteres as $s) { $value2 = $s->fullname; } $ser_id = $mform->createElement('static', 'serviceid', get_string('student_id', 'local_request'), $serviceid->serviceid); $mform->insertElementBefore($ser_id, 'name'); $sem_name = $mform->createElement('static', 'semester_name', get_string('semester', 'local_semesters'), $value2); $mform->insertElementBefore($sem_name, 'addschool'); } } } // more than one school assiged to a user if ($school[0] > 0 && isset($school) && $countvalue > 1) { $users = $requestpro->users($fid); $programses = $requestpro->program($fid); $mypro = array(); $mypro[''] = '--Select--'; foreach ($programses as $p) { $mypro[$p->id] = $p->fullname; } $service = $requestpro->service($fid, $p->id); $username = $mform->createElement('static', 'name', get_string('name', 'local_request'), $users->fullname); $mform->insertElementBefore($username, 'addschool'); $emailid = $mform->createElement('static', 'email_id', get_string('email_id', 'local_request'), $users->email); $mform->insertElementBefore($emailid, 'addschool'); $ser_id = $mform->createElement('static', 'serviceid', get_string('student_id', 'local_request'), $service->serviceid); $mform->insertElementBefore($ser_id, 'addschool'); if (count($mypro) == 2) { // more than school and one program to user $pro_name = $mform->createElement('static', 'program_name', get_string('program', 'local_programs'), $mypro[$p->id]); $mform->insertElementBefore($pro_name, 'addschool'); $pro_id = $mform->createElement('hidden', 'programid', $p->id); $mform->insertElementBefore($pro_id, 'addschool'); $semesteres = $requestpro->semester($fid, $p->id); foreach ($semesteres as $s) { $mysemvalue = $s->fullname; } $sems_name = $mform->createElement('static', 'semester_name', get_string('semester', 'local_semesters'), $mysemvalue); $mform->insertElementBefore($sems_name, 'addschool'); $sem_id = $mform->createElement('hidden', 'semesterid', $s->id); $mform->insertElementBefore($sem_id, 'addschool'); } else { // more than one program and school assined to user $pro_name = $mform->createElement('select', 'program_name', get_string('program', 'local_programs'), $mypro); $mform->insertElementBefore($pro_name, 'addschool'); } $formatvalue3 = $mform->getElementValue('program_name'); if ($formatvalue3[0] > 0) { $semesteres = $requestpro->semester($fid, $formatvalue3[0]); foreach ($semesteres as $s) { $mysemvalue = $s->fullname; } $se_name = $mform->createElement('static', 'semester_name', get_string('semester', 'local_semesters'), $mysemvalue); $mform->insertElementBefore($se_name, 'addschool'); } } if (isset($fields[0]) && $fields[0] != null) { if ($fields[0] == 0) { $result = $DB->get_record('local_request_profile_change', array('reg_approval' => 0, 'subjectcode' => 1, 'studentid' => $USER->id)); }if ($fields[0] == 1) { $result = $DB->get_record('local_request_profile_change', array('reg_approval' => 0, 'subjectcode' => 2, 'studentid' => $USER->id)); } if (!empty($result)) { if ($fields[0] == 0) { $errormsg = $mform->createElement('html', '<div class="alert alert-danger">' . get_string('noteforname', 'local_request') . '</div>'); $mform->insertElementBefore($errormsg, 'fields'); }if ($fields[0] == 1) { $errormsg = $mform->createElement('html', '<div class="alert alert-danger">' . get_string('noteforemail', 'local_request') . '</div>'); $mform->insertElementBefore($errormsg, 'fields'); } } else { $editheader = $mform->createElement('header', 'settingsheader', get_string('edit_settings', 'local_request')); $mform->insertElementBefore($editheader, 'fields'); $users = $requestpro->current_user(); $fullname = $users->firstname . " " . $users->lastname; if ($fields[0] == 0 && $fields[0] != null) { $username = $mform->createElement('static', 'fullname', get_string('present_data', 'local_request'), $fullname); $mform->insertElementBefore($username, 'fields'); } if ($fields[0] == 1 && $fields[0] != null) { $email_id = $mform->createElement('static', 'email_id', get_string('present_data', 'local_request'), $users->email); $mform->insertElementBefore($email_id, 'fields'); } $changeto = $mform->createElement('text', 'changeto', get_string("request_to_chage", "local_request")); $mform->insertElementBefore($changeto, 'fields'); $mform->addRule('changeto', get_string('error_change_to', 'local_request'), 'required', null, 'client'); $reason = $mform->createElement('editor', 'reason', get_string("reason_id", "local_request")); $mform->setType('reason', PARAM_RAW); $mform->insertElementBefore($reason, 'fields'); $mform->addRule('reason', get_string('error_request_id', 'local_request'), 'required', null, 'client'); } } }
public function get_userdetails_accounts($userid) { global $DB, $OUTPUT; $hierarchy = new hierarchy(); $requests = new requests(); $help_desk_lib = new user_filtering_accounts(); $user = $DB->get_record('user', array('id' => $userid)); $local_user = $DB->get_record('local_users', array('userid' => $userid)); $local_user_data = $DB->get_record('local_userdata', array('userid' => $userid)); $fullname = $user->firstname . ' ' . $user->lastname; $out = '<div class="userprofilebox clearfix"><div class="profilepicture">'; $out .= $OUTPUT->user_picture($user, array('size' => 50)); $out .= '</div>'; $table = new html_table(); $table->id = 'accounts_viewmore'; $table->size = array('20%', '80%'); $table->align = array('right', 'left'); $get_alldepartments = $hierarchy->get_alldepartments($user->id); $get_allmyactivesemester = $hierarchy->get_allmyactivesemester($user->id); $student_semesters = student_semesters($user->id); //School with department if ($school = $requests->school($user->id)) { foreach ($school as $schools) { $schoolid = $schools->id; $schoolname = $schools->fullname; $s1[] = $schoolname; $programs = $requests->program($schoolid, $user->id); foreach ($programs as $program) { $proid = $program->id; $p[] = $DB->get_field('local_program', 'fullname', array('id' => $proid)); if ($serviceid = $requests->service($schoolid, $proid, $user->id)) { $s3[] = $serviceid->serviceid; } } } if ($s1) { $s2 = implode(', ', $s1); $myschools = "<p><b>School: </b>" . $s2 . "</p>"; } if ($p) { $pro = implode(' ', $p); $myschools .= "<span style='margin-left: 6%;'><b>Program: </b>" . $pro . "</span>"; } } //End of school print_object($help_desk_lib->user_enrolled_courses($userid)); $table->data = array(array(get_string('username'), $user->username), array(get_string('fullname'), $fullname), array(get_string('firstname'), $user->firstname), array(get_string('lastname'), $user->lastname), array(get_string('email'), $user->email), array(get_string('phone'), $user->phone1), array(get_string('phone2'), $user->phone2), array(get_string('dob', 'local_admission'), date('Y-m-d', $local_user->dob)), array(get_string('doj', 'local_users'), date('Y-m-d', $local_user->timecreated)), array(get_string('genderheading', 'local_admission'), $local_user->gender), array(get_string('serviceid', 'local_users'), implode(', ', $s3)), array(get_string('idnumber'), $user->idnumber), array(get_string('hschool', 'local_users'), $local_user->primaryschoolname), array(get_string('primaryyear', 'local_admission'), $local_user->primaryyear), array(get_string('score', 'local_admission'), $local_user->primaryscore), array(get_string('pcountry', 'local_admission'), $local_user->primaryplace), array(get_string('contactname', 'local_admission'), $local_user->fathername), array(get_string('hno', 'local_admission'), $local_user->currenthno), array(get_string('pob', 'local_admission'), $local_user->pob), array(get_string('city'), $local_user->region), array(get_string('state'), $local_user->state), array(get_string('icqnumber'), $user->icq), array(get_string('skypeid'), $user->skype), array(get_string('yahooid'), $user->yahoo), array(get_string('aimid'), $user->aim), array(get_string('msnid'), $user->msn), array(get_string('language'), $user->lang), array(get_string('timezone'), usertimezone($user->timezone)), array(get_string('departments', 'local_help_desk'), $hierarchy->get_alldepartments($user->id)), array(get_string('activesemister', 'local_help_desk'), $hierarchy->get_allmyactivesemester($user->id)), array(get_string('studentsemister', 'local_help_desk'), student_semesters($user->id)), array(get_string('myschools', 'local_help_desk'), $myschools)); //get_string('dob', 'local_admission') . "</b></;" . date("Y-m-d", $local_users->dob) . " //get_string('doj', 'local_users') . "</b></td>< date("Y-m-d", $local_users->timecreated) //get_string('genderheading', 'local_admission')nbsp; " . $local_users->gender . "</ //print_object($get_alldepartments); //print_object($get_allmyactivesemester); //print_object($student_semesters); //print_object(date('D M Y', $user->dob)); $edit_url = new moodle_url('/user/edit.php', array('id' => $userid)); $out .= html_writer::tag('a', 'EDIT', array('href' => $edit_url, 'id' => 'EDIT')); $out .= html_writer::table($table); return $out; }
echo "<tr><td style='font-size:10px;color:#000;'><img src='" . $CFG->wwwroot . "/pix/emailpro.png' style='vertical-align:middle;' /> <a href='mailto:" . $name->email . "'>" . $name->email . "</a> <img src='" . $CFG->wwwroot . "/pix/phonepro.png' style='vertical-align:middle;' /> " . $name->phone1 . "</td></tr>"; $s1 = array(); $s3 = array(); $p = array(); if ($school = $requests->school($id)) { foreach ($school as $schools) { $schoolid = $schools->id; $schoolname = $schools->fullname; $s1[] = $schoolname; $programs = $requests->program($schoolid, $id); foreach ($programs as $program) { $proid = $program->id; $p[] = $DB->get_field('local_program', 'fullname', array('id' => $proid)); if ($serviceid = $requests->service($schoolid, $proid, $id)) { $s3[] = $serviceid->serviceid; } } } if ($s1) { $s2 = implode(', ', $s1); echo "<tr><td><b>School: </b>" . $s2 . "</td></tr>"; } if ($p) { $pro = implode(' ', $p); echo "<tr><td><b>Program: </b>" . $pro . "</td></tr>"; } }
$PAGE->navbar->add(get_string('view', 'local_request')); $PAGE->set_title($strheading); $requestpro = new requests(); $data = array(); global $USER; $url = '../../local/request/requestprofile.php'; if ($var) { redirect($url); } $data = array(); echo $OUTPUT->header(); if ($requests = $DB->get_records('local_request_profile_change', array('studentid' => $USER->id))) { foreach ($requests as $request) { $list = array(); $serviceid = $requestpro->service($request->schoolid, $request->programid); $list[] = $serviceid->serviceid; $list[] = $DB->get_field('local_school', 'fullname', array('id' => $request->schoolid)); $list[] = $DB->get_field('local_program', 'fullname', array('id' => $request->programid)); if ($request->subjectcode == 1) { $list[] = get_string('name', 'local_request'); } if ($request->subjectcode == 2) { $list[] = get_string('email_id', 'local_request'); } $list[] = $request->presentdata; $list[] = $request->changeto; $list[] = strtoupper(date("d-M-Y", $request->requested_date)); $reg_approval = $request->reg_approval; if ($reg_approval == 0) { $list[] = get_string('pending', 'local_request');