$fromform->reg_approval = 0; $fromform->regapproval_date = 0; $registrar = $DB->get_records_sql("select userid from {local_school_permissions} where roleid = 9 and schoolid = {$fromform->schoolid} group by userid"); foreach ($registrar as $reg) { $registrarid = $reg->userid; } $userto = $DB->get_record('user', array('id' => $registrarid)); $userfrom = $DB->get_record('user', array('id' => $USER->id)); $message = get_string('usertransferrequest', 'local_request', $userfrom->firstname); if ($DB->insert_record('local_request_transfer', $fromform)) { message_post_message($userfrom, $userto, $message, FORMAT_HTML); $conmessage = get_string('requestsubmit', 'local_request'); $options = array('style' => 'notifysuccess'); $hierarchy->set_confirmation($conmessage, $nexturl, $options); } } echo $OUTPUT->header(); echo $OUTPUT->heading($strheading); $check = $DB->get_record_sql("SELECT * FROM {local_request_transfer} WHERE studentid = {$USER->id} AND approvalstatus = 0"); if (!empty($check)) { $message = get_string('requesttransfererror', 'local_request'); $options = array('style' => 'notifyproblem'); $hierarchy->set_confirmation($message, $nexturl, $options); } $currenttab = 'request'; $requestid->requesttransfertabview($currenttab); $mform->display(); echo $OUTPUT->footer(); ?>