public function login_student($student_id, $student_password)
 {
     if (empty($student_id) || empty($student_password)) {
         echo "Username or Password is invalid";
         return false;
     }
     $student_id = stripslashes($student_id);
     $student_password = stripslashes($student_password);
     $student_id = mysql_real_escape_string($student_id);
     $student_password = mysql_real_escape_string($student_password);
     $student_password = sha1($student_password);
     $students_rec = mysql_query("SELECT * FROM " . $this->students_table . " where student_id = {$student_id};");
     if (($obj = mysql_fetch_object($students_rec)) != NULL) {
         $student = new student($obj->student_id, $obj->user_name, $obj->user_password, $obj->change_password);
         if ($student->getUser_password() == $student_password) {
             echo "welcome " . $student->getUser_name();
             return true;
         } else {
             echo "Wrong password";
             return false;
         }
     } else {
         echo "No such user!";
         return false;
     }
 }

 /**
  * Test student save works when $USER object not set
  */
 public function test_student_save_nouserobject()
 {
     global $DB, $USER;
     // Create Moodle course category.
     $crscat = create_course_category((object) array('name' => 'Test Course category', 'idnumber' => 'MCC-1'));
     // Create Moodle course.
     $crsdata = array('category' => $crscat->id, 'fullname' => 'MC-TEST-ELIS-8484', 'shortname' => 'MC-TEST-ELIS-8484', 'idnumber' => 'MC-TEST-ELIS-8484');
     $mdlcrs = new stdClass();
     $mdlcrs->id = $DB->insert_record('course', (object) $crsdata);
     $cddata = array('name' => 'CD-ELIS-8484', 'code' => 'CD-ELIS-8484', 'idnumber' => 'CD-ELIS-8484', 'syllabus' => 'syllabus');
     $cd = new course($cddata);
     $cd->save();
     $ci = new pmclass(array('idnumber' => 'CI-ELIS-8484', 'courseid' => $cd->id, 'moodlecourseid' => $mdlcrs->id, 'autocreate' => 0));
     $ci->save();
     $testuser = new user(array('idnumber' => 'testuserelis8484', 'username' => 'testuserelis8484', 'firstname' => 'Test', 'lastname' => 'User-ELIS8484', 'email' => '[email protected]', 'city' => 'Waterloo', 'country' => 'CA'));
     $testuser->save();
     $USER = null;
     $sturec = new stdClass();
     $sturec->userid = $testuser->id;
     $sturec->classid = $ci->id;
     $sturec->grade = 0;
     $sturec->enrolmenttime = time();
     $student = new student($sturec);
     $student->save();
     $this->assertFalse(empty($student));
     if (!empty($student)) {
         $this->assertFalse(empty($student->id));
     }
 }

 protected function addteacher()
 {
     global $objPDO;
     global $user;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin()) {
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/subject_teacher_relations.php';
     }
 }

 protected function create()
 {
     global $objPDO;
     global $user;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin()) {
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/create_section.php';
     }
 }

 public function insertion()
 {
     echo "hello";
     if (!is_dir("uploads/")) {
         mkdir("uploads/");
     }
     $dir = "uploads/";
     $valuePost = array("firstname" => $_POST['firstname'], "lastname" => $_POST['lastname'], "fathername" => $_POST['fathername'], "dob" => $_POST['dob'], "sex" => $_POST['sex'], "contact" => $_POST['contact'], "email" => $_POST['email'], "secondary" => $_POST['secondary'], "senior" => $_POST['senior'], "fn" => $_FILES['img']['name'], "target" => $dir . basename($_FILES['img']['name']));
     $student = new student();
     $error = $student->Insertion($valuePost);
     return $error;
 }

 private function create_student($row)
 {
     $obj = new student();
     $obj->setstudentId($row["student_Id"]);
     $obj->setFirstName($row["FirstName"]);
     $obj->setLastName($row["LastName"]);
     $obj->setDob(new \DateTime($row["dob"]));
     $obj->setGender($row["gender"]);
     $obj->setUsername($row["UserName"]);
     $obj->setPassword($row["password"]);
     $obj->setapproved($row["approved"]);
     return $obj;
 }

 /**
  * Save a set of enrolments and LO grades to the database
  * @param array $enrolments Enrolment data to save
  * @param array $grades LO grade data to save
  */
 protected function save_enrolments($enrolments, $grades = array())
 {
     // Enrolments.
     foreach ($enrolments as $enrolment) {
         $student = new student($enrolment);
         $sink = $this->redirectMessages();
         $student->save();
     }
     // LO grades.
     foreach ($grades as $grade) {
         $studentgrade = new student_grade($grade);
         $studentgrade->save();
     }
 }

 protected function studentsection()
 {
     global $objPDO;
     global $user;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin()) {
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/section_student_relation_view.php';
     } else {
         if ($student->checkTeacher()) {
         } else {
         }
     }
 }

 /**
  * Method to create test user class enrolment
  * @param int $userid the user DB id
  * @param int $classid the class DB id
  */
 public function create_class_enrolment($userid, $classid)
 {
     // Initialize version1elis importplugin for utility functions.
     $importplugin = rlip_dataplugin_factory::factory('dhimport_version1elis');
     $record = new stdClass();
     $record->userid = $userid;
     $record->classid = $classid;
     $record->completestatusid = 0;
     $record->grade = 50;
     $record->credits = 1;
     $record->locked = 0;
     $record->enrolmenttime = $importplugin->parse_date('Jan/10/2013');
     $stu = new student($record);
     $stu->save();
 }

 protected function addparent()
 {
     global $user;
     global $objPDO;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin() == true && isset($_GET['uid'])) {
         global $objPDO;
         $studentProfile = new StudentProfile($objPDO);
         $studentProfile->loadByUserId($_GET['uid']);
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/addparent.php';
     } else {
         header('Location:http://localhost/cloud');
     }
 }

 /**
  * When a role is selected from the sync configuration, create class
  * enrolments for the specified role assignments.
  */
 static function student_sync_role_set()
 {
     require_once CURMAN_DIRLOCATION . '/lib/student.class.php';
     global $CURMAN;
     $contextlevel = context_level_base::get_custom_context_level('class', 'block_curr_admin');
     // find all class role assignments
     $sql = "SELECT ra.id, cu.id AS userid, ctx.instanceid AS classid\n                  FROM {$CURMAN->db->prefix_table('role_assignments')} ra\n                  JOIN {$CURMAN->db->prefix_table('user')} mu ON ra.userid = mu.id\n                  JOIN {$CURMAN->db->prefix_table('crlm_user')} cu ON mu.idnumber = cu.idnumber\n                  JOIN {$CURMAN->db->prefix_table('context')} ctx ON ctx.id = ra.contextid\n                 WHERE ctx.contextlevel = {$contextlevel}\n                   AND ra.roleid = {$CURMAN->config->enrolment_role_sync_student_role}";
     $studentswanted = $CURMAN->db->get_records_sql($sql);
     $studentswanted = $studentswanted ? $studentswanted : array();
     foreach ($studentswanted as $student) {
         unset($student->id);
         $student = new student($student);
         $student->add();
     }
     return true;
 }

 protected function index()
 {
     global $user;
     global $objPDO;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin() == true) {
         $role = $student->getacctType();
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/temp_page.php';
     } else {
         if ($student->checkTeacher() == true) {
             $role = $student->getacctType();
             include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/temp_page.php';
         } else {
             header('Location:http://localhost/cloud');
         }
     }
 }

 protected function index()
 {
     global $objPDO;
     global $user;
     $student = new student($objPDO, $user->getuserId());
     $headMenu = array("username" => $student->getName());
     if ($user->checkAdmin()) {
         include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/admin.php';
     } else {
         if ($student->checkTeacher()) {
             include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/employee.php';
         } else {
             if ($student->checkStudent()) {
                 include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/student.php';
             }
         }
     }
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $emails = ['[email protected]'];
     Mail::send('mails.welcome', ['name' => 'Angela Namikoye, Brian Phiri'], function ($message) use($emails) {
         $message->to($emails)->from('[email protected]', 'strath')->subject('This is test email');
     });
     $user = Auth::user()->regNo;
     student::where('studentNo', '=', $user)->update(['state' => 'Activated']);
     Session::flash('flash_msg', 'You have initiated the clearance process');
     return redirect('/student');
 }

 protected function savepass()
 {
     $required = array("current" => "Current Password", "new" => "New Password");
     foreach ($required as $key => $value) {
         if (!isset($_POST[$key]) || $_POST[$key] == '' || $_POST[$key] == 'select') {
             echo $value . ' is Required<br/>';
             return;
         }
     }
     global $user;
     global $objPDO;
     $student = new student($objPDO, $user->getuserId());
     if (md5($_POST['current']) == $student->getPassword()) {
         $student->setPassword(md5($_POST['new']));
         $student->save();
     } else {
         echo 'The Current Password is Wrong';
         return;
     }
     echo '<meta http-equiv="Refresh" content="0;url=http://localhost/cloud/profile"/>';
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $user = Auth::user()->regNo;
     $res = DB::table('students')->select('faculty')->where('studentNo', '=', $user)->pluck('faculty');
     //Query below gets the email of the specific administrator
     $admin = DB::table('departments')->join('administrators', 'departments.administrator', '=', 'administrators.admin_id')->select('administrators.email')->where('departments.department_name', '=', $res)->pluck('email');
     Mail::send('mails.welcome', ['name' => 'Angela Namikoye, Brian Phiri'], function ($message) use($admin) {
         $message->to($admin)->from('[email protected]', 'Strathmore University')->subject('Clearance Request');
     });
     student::where('studentNo', '=', $user)->update(['state' => 'Activated']);
     Session::flash('flash_msg', 'You have initiated the clearance process');
     return redirect('/student');
 }

 /**
  * Test successful class enrolment deletion.
  */
 public function test_success()
 {
     global $DB;
     $this->give_permissions(array('local/elisprogram:class_enrol'));
     // Initialize version1elis importplugin for utility functions.
     $importplugin = rlip_dataplugin_factory::factory('dhimport_version1elis');
     // Create test course and class.
     $datagen = new elis_program_datagenerator($DB);
     $crs = $datagen->create_course(array('idnumber' => 'TestCourse'));
     $cls = $datagen->create_pmclass(array('idnumber' => 'TestClassEnrolmentCreate', 'courseid' => $crs->id));
     $data = array('class_idnumber' => $cls->idnumber, 'user_username' => 'assigninguser', 'user_email' => '[email protected]');
     // Create the class enrolment record to delete.
     $userid = $DB->get_field(user::TABLE, 'id', array('username' => 'assigninguser'));
     $stu = new student(array('classid' => $cls->id, 'userid' => $userid));
     $stu->save();
     $response = local_datahub_elis_class_enrolment_delete::class_enrolment_delete($data);
     $this->assertNotEmpty($response);
     $this->assertInternalType('array', $response);
     $this->assertArrayHasKey('messagecode', $response);
     $this->assertArrayHasKey('message', $response);
     $this->assertEquals(get_string('ws_class_enrolment_delete_success_code', 'local_datahub'), $response['messagecode']);
     $this->assertEquals(get_string('ws_class_enrolment_delete_success_msg', 'local_datahub'), $response['message']);
     $this->assertFalse($DB->record_exists(student::TABLE, array('classid' => $cls->id, 'userid' => $userid)));
 }

 /**
  * Handle the event.
  *
  * @param  UserAuthenticated  $event
  * @return void
  */
 public function handle(DelayOrderAccepted $event)
 {
     $delay_order = $event->order;
     //add student history
     $student = student::findOrFail($delay_order->student_id);
     StudentHistory::where('academycycle_semester_id', $delay_order->semester_id)->where('student_id', $delay_order->student_id)->update(['state' => 'delayed']);
     /*
             StudentHistory::insert([
                 'academycycle_semester_id' => $delay_order->semester_id,
                 'student_id' => $delay_order->student_id,
                 'state' => 'delayed',
                 'study_state' => 'stop',
                 'academystructure_department_id' => $student->academystructure_department_id
                 ]);   
     */
 }

 public function studentPdf(Request $request)
 {
     $post = $request->all();
     $user = $post['student'];
     $std = student::where('studentNo', '=', $user)->first();
     $charge = charges::where('students_studentNo', '=', $user)->first();
     $serial = Serial::where('students_studentNo', '=', $user)->first();
     if ($charge->total == 0) {
         $html = PDF::make($std, $serial);
     } else {
         $html = PDF::create($std, $charge, $serial);
     }
     $mpdf = new mpdf();
     $mpdf->WriteHTML($html);
     $mpdf->Output();
 }

 /**
  * Validate that the sync from course role assignment to class instance enrolment works
  */
 public function test_enrolled_course_user_syncstoclass()
 {
     global $CFG, $DB;
     require_once elispm::lib('lib.php');
     // Set up import data.
     $this->load_csv_data();
     // Make sure the context is set up.
     $crsctx = context_course::instance(100);
     // Set up our test role.
     $roleid = create_role('gradedrole', 'gradedrole', 'gradedrole');
     set_config('gradebookroles', $roleid);
     // Create role assignments.
     role_assign($roleid, 100, $crsctx->id);
     // Attempt the sync.
     $sync = new \local_elisprogram\moodle\synchronize();
     $sync->synchronize_moodle_class_grades();
     // Make sure the student record was created.
     $student = student::find();
     $this->assertTrue($student->valid());
     // Make sure the student has the right class id.
     $student = $student->current();
     $this->assertEquals(100, $student->classid);
 }