function definition() {
global $USER, $CFG, $DB, $PAGE;
$mform = $this->_form;
$requestid = new requests();
$schools = $requestid->school();
foreach ($schools as $school) {
$value = $school->fullname;
$key = $school->id;
}
$programs = $requestid->program($key);
foreach ($programs as $pro) {
$pro_val = $pro->fullname;
$pro_key = $pro->id;
}
$semester = $requestid->previoussemsofuser($key, $pro_key);
$cur_semester = $requestid->current_sem($key, $pro_key);
$list = array();
$list[''] = get_string("select", "local_request");
foreach ($semester as $ses) {
$key1 = $ses->id;
$list[$key1] = $ses->fullname;
}
foreach ($cur_semester as $cus_ses) {
global $sesid;
$sesid = $cus_ses->id;
}
unset($list[$sesid]);
$mform->addElement('select', 'semester_name', get_string('semester', 'local_semesters'), $list);
$mform->addRule('semester_name', get_string('missingsemester', 'local_semesters'), 'required', null, 'server');
$mform->addElement('editor', 'reason', get_string("reason_id", "local_request"));
$mform->addRule('reason', get_string('error_request_id', 'local_request'), 'required', null, 'client');
$this->add_action_buttons(true, get_string('submitbutton', 'local_request'));
}
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;
}
$x = optional_param('schoolid', 0, PARAM_INT);
$requestid = new requests();
global $USER;
if ($mform->is_cancelled()) {
/* if click on cancel it redirects us to request_id.php file */
redirect($nexturl);
} else if ($fromform = $mform->get_data()) {
/* presence of data */
$check = $DB->get_record_sql("SELECT * FROM {local_request_transcript} WHERE studentid = {$USER->id} AND req_semester = {$fromform->semester_name}");
$schools = $requestid->school();
foreach ($schools as $school) {
$value = $school->fullname;
$key = $school->id;
}
$programs = $requestid->program($key);
foreach ($programs as $pro) {
$pro_val = $pro->fullname;
$pro_key = $pro->id;
}
$cur_semester = $requestid->current_sem($key, $pro_key);
foreach ($cur_semester as $cus_ses) {
$sesid = $cus_ses->id;
$fromform->semester = $sesid;
}
$fromform->studentid = $USER->id;
$fromform->notification = '0';
$fromform->requested_date = time();
$fromform->req_semester = $fromform->semester_name;
$fromform->reason = $fromform->reason['text'];
echo '<div class="profilepicture" >';
echo $OUTPUT->user_picture($user, array('size' => 50, 'class' => 'mypic'));
echo '</div><div class="myinfo" >';
echo "<table class='schoolinfo' ><tr class='tableproheading'><td style='font-size:25px'>" . $name->firstname . " " . $name->lastname . "</td></tr>";
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);