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' => '*****@*****.**', '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 = ['*****@*****.**']; Mail::send('mails.welcome', ['name' => 'Angela Namikoye, Brian Phiri'], function ($message) use($emails) { $message->to($emails)->from('*****@*****.**', '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('*****@*****.**', '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' => '*****@*****.**'); // 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); }
echo "Grade: " . $this->grade . "<br>"; echo "Class: " . $this->classs . "<br>"; echo "Favorite Class: " . $this->favoriteClass . "<br><br>"; } //do anything when object is shutdown/deleted function __destruct() { echo $this->firstName . " has been obliterated<br><br>"; } //this is a fail safe to prevent a error if it is printed i think function __toString() { return "This is the student object not some text to be just printed<br><br>"; } } echo "<h2>Create a new object from the student class</h2><br>"; $cat = new student("Max", "DeVos", "867-5309", 348, 11, 2017, "Chemistry"); echo "<h2>Run a test method</h2><br>"; $cat->test(); echo "<h2>Run a printall method for a student</h2><br>"; $cat->printall(); echo "<h2>Try to print the student object as text</h2><br>"; echo $cat; echo "<h2>Activate the destruct function by giving the object the text value of 'dog'</h2><br>"; $cat = "dog"; ?> </div> </center> <?php makeFooter("Programing is Fun", 0, "True");
/** * Notifies that students have not passed their classes via the notifications where applicable, * setting enrolment status to failed where applicable * * @param int $pmuserid optional userid to update, default(0) updates all users */ function pm_update_student_enrolment($pmuserid = 0) { global $DB; require_once elispm::lib('data/student.class.php'); require_once elispm::lib('notifications.php'); //look for all enrolments where status is incomplete / in progress and end time has passed $select = 'completestatusid = :status AND endtime > 0 AND endtime < :time'; $params = array('status' => STUSTATUS_NOTCOMPLETE, 'time' => time()); if ($pmuserid) { $select .= ' AND userid = :userid'; $params['userid'] = $pmuserid; } $students = $DB->get_recordset_select(student::TABLE, $select, $params); if (!empty($students)) { foreach ($students as $s) { // Send notification, if enabled. $sendnotification = !empty(elis::$config->local_elisprogram->notify_incompletecourse_user) ? true : false; if ($sendnotification === true) { $a = $DB->get_field(pmclass::TABLE, 'idnumber', array('id' => $s->classid)); $message = get_string('incomplete_course_message', 'local_elisprogram', $a); $cuser = new user($s->userid); $from = get_admin(); notification::notify($message, $cuser, $from); } //set status to failed $s->completetime = time(); $s->completestatusid = STUSTATUS_FAILED; $stu = new student($s->id); $stu->set_from_data($s); $stu->update(); } } return true; }
require_once '../include/student.class.php'; require_once '../include/studiengang.class.php'; require_once '../include/firma.class.php'; require_once '../include/standort.class.php'; require_once '../include/adresse.class.php'; require_once '../include/nation.class.php'; require_once '../include/prestudent.class.php'; header("Content-type: application/xhtml+xml"); if (isset($_REQUEST["xmlformat"]) && $_REQUEST["xmlformat"] == "xml") { if (!isset($_REQUEST['preoutgoing_id'])) { die('Parameter preoutgoing_id is missing!'); } $preoutgoing_id = $_REQUEST['preoutgoing_id']; $preoutgoing = new preoutgoing(); $benutzer = new benutzer(); $student = new student(); $studiengang = new studiengang(); $prestudent = new prestudent(); if (!$preoutgoing->load($preoutgoing_id)) { die('Konnte Outgoing nicht finden!'); } if (!$benutzer->load($preoutgoing->uid)) { die('Konnte Benutzer nicht laden!'); } if (!$student->load($preoutgoing->uid)) { die('Konnte Student nicht laden!'); } $projektarbeittitel = $preoutgoing->projektarbeittitel; $studiengang->load($student->studiengang_kz); $preoutgoingFirma = new preoutgoing(); $preoutgoingFirma->loadAuswahl($preoutgoing_id);
/** * Validate that mappings are applied during the student enrolment delete action */ public function test_mapping_applied_during_student_enrolment_delete() { global $CFG, $DB; require_once $CFG->dirroot . '/local/elisprogram/lib/data/course.class.php'; require_once $CFG->dirroot . '/local/elisprogram/lib/data/pmclass.class.php'; require_once $CFG->dirroot . '/local/elisprogram/lib/data/student.class.php'; $this->init_mapping(); $userid = $this->create_test_user(); $course = new course(array('name' => 'testcoursename', 'idnumber' => 'testcourseidnumber', 'syllabus' => '')); $course->save(); $pmclass = new pmclass(array('courseid' => $course->id, 'idnumber' => 'testclassidnumber')); $pmclass->save(); $student = new student(array('classid' => $pmclass->id, 'userid' => $userid)); $student->save(); // Run the student enrolment delete action. $record = new stdClass(); $record->customaction = 'delete'; $record->customcontext = 'class_testclassidnumber'; $record->customuser_username = '******'; $record->customuser_email = '*****@*****.**'; $record->customuser_idnumber = 'testuseridnumber'; $record->customrole = 'student'; $this->run_enrolment_import((array) $record); // Validation. $this->assertEquals(0, $DB->count_records(student::TABLE)); }
function print_add_form($cmclass) { $type = $this->optional_param('stype', '', PARAM_ALPHA); $sort = $this->optional_param('sort', 'name', PARAM_ALPHANUM); $dir = $this->optional_param('dir', 'ASC', PARAM_ALPHA); $page = $this->optional_param('page', 0, PARAM_INT); $perpage = $this->optional_param('perpage', 30, PARAM_INT); // how many per page $namesearch = trim($this->optional_param('search', '', PARAM_TEXT)); $alpha = $this->optional_param('alpha', '', PARAM_ALPHA); $newstu = new student(); $newstu->classid = $cmclass->id; echo $newstu->edit_form_html($cmclass->id, $type, $sort, $dir, $page, $perpage, $namesearch, $alpha); }
function drawperson_xml($row) { global $conn, $datum; $pers = new person(); $pers->load($row->person_id); $stg = new studiengang($row->studiengang_kz); $student_obj = new student(); $student_obj->load_person($row->person_id, $row->studiengang_kz); echo "\n \t\t<person>\n\t\t\t<person_id><![CDATA[" . $pers->person_id . "]]></person_id>\n\t\t\t<anrede><![CDATA[" . $pers->anrede . "]]></anrede>\n\t\t\t<titelpost><![CDATA[" . $pers->titelpost . "]]></titelpost>\n\t\t\t<titelpre><![CDATA[" . $pers->titelpre . "]]></titelpre>\n\t\t\t<nachname><![CDATA[" . $pers->nachname . "]]></nachname>\n\t\t\t<vorname><![CDATA[" . $pers->vorname . "]]></vorname>\n\t\t\t<vornamen><![CDATA[" . $pers->vornamen . "]]></vornamen>\n\t\t\t<name_gesamt><![CDATA[" . trim($pers->anrede . ' ' . $pers->titelpre . ' ' . $pers->vorname . ' ' . $pers->nachname . ' ' . $pers->titelpost) . "]]></name_gesamt>\n\t\t\t<geburtsdatum><![CDATA[" . $datum->convertISODate($pers->gebdatum) . "]]></geburtsdatum>\n\t\t\t<sozialversicherungsnummer><![CDATA[" . $pers->svnr . "]]></sozialversicherungsnummer>\n\t\t\t<ersatzkennzeichen><![CDATA[" . $pers->ersatzkennzeichen . "]]></ersatzkennzeichen>\n\t\t\t<matrikelnr><![CDATA[" . trim($student_obj->matrikelnr) . "]]></matrikelnr>\n\t\t\t<tagesdatum><![CDATA[" . date('d.m.Y') . "]]></tagesdatum>\n\t\t\t<logopath>" . DOC_ROOT . "skin/images/</logopath>\n\t\t\t<studiengang><![CDATA[" . $stg->bezeichnung . "]]></studiengang>\n\t\t</person>"; }
file_put_contents($tempfolder . '/Pictures/' . $bn->uid . '.jpg', base64_decode($cTmpHEX)); // Bild zum Manifest-File des ODTs hinzufuegen addImageToManifest($tempname_zip, 'Pictures/' . $bn->uid . '.jpg', $contenttype = 'image/jpeg'); if (check_lektor($uid)) { $ma = new mitarbeiter(); $ma->load($uid); $benutzerfunktion = new benutzerfunktion(); $benutzerfunktion->getBenutzerFunktionByUid($uid, NULL, date("Y-m-d"), date("Y-m-d")); if (!empty($benutzerfunktion->result[0])) { $oe = new organisationseinheit($benutzerfunktion->result[0]->oe_kurzbz); } else { $oe = new organisationseinheit(); } $xml .= "\n\t\t\t\t<mitarbeiter>\n\t\t\t\t\t<uid><![CDATA[" . $bn->uid . "]]></uid>\n\t\t\t\t\t<vorname><![CDATA[" . $bn->vorname . "]]></vorname>\n\t\t\t\t\t<nachname><![CDATA[" . $bn->nachname . "]]></nachname>\n\t\t\t\t\t<titelpre><![CDATA[" . $bn->titelpre . "]]></titelpre>\n\t\t\t\t\t<titelpost><![CDATA[" . $bn->titelpost . "]]></titelpost>\n\t\t\t\t\t<personalnummer><![CDATA[" . $ma->personalnummer . "]]></personalnummer>\n\t\t\t\t\t<ausstellungsdatum><![CDATA[" . date('d.m.Y') . "]]></ausstellungsdatum>\n\t\t\t\t\t<gebdatum><![CDATA[" . $datum_obj->formatDatum($ma->gebdatum, 'd.m.Y') . "]]></gebdatum>\n\t\t\t\t\t<organisationseinheit><![CDATA[" . $oe->bezeichnung . "]]></organisationseinheit>\n\t\t\t\t</mitarbeiter>"; } else { $student = new student(); $student->load($bn->uid); $konto = new konto(); $studiengang = new studiengang(); $studiengang->load($student->studiengang_kz); $stsem_obj = new studiensemester(); $stsem = $stsem_obj->getaktorNext(); $stsem_obj->load($stsem); if ($konto->checkStudienbeitrag($bn->uid, $stsem_obj->studiensemester_kurzbz)) { $gueltigbis = $stsem_obj->ende; } else { // Studiengebuehr noch nicht bezahlt $gueltigbis = $stsem_obj->ende; } if ($type == 'datum') { //Nur der Datumsstempel wird erstellt
<?php include 'connection.php'; require 'class/class.php'; $conn = connection(); $sel = new student(); $s3lect = $sel->details($_GET['id'], $conn); //print_r($s3lect); if (empty($s3lect)) { echo "</br>invalie user id"; } else { $id = $s3lect['0']['id']; $name = $s3lect['0']['name']; $age = $s3lect['0']['age']; $designation = $s3lect['0']['designation']; if (!empty($_POST)) { if (empty($_POST['id'])) { $error_arr['id'] = "Empty Id"; } else { $id = $_POST['id']; } if (empty($_POST['name'])) { $error_arr['name'] = "Empty name"; } else { $name = $_POST['name']; } if (empty($_POST['age'])) { $error_arr['age'] = "Empty age"; } else { $age = $_POST['age']; }
function count_users_avail($namesearch = '', $alpha = '') { global $CFG, $CURMAN; $LIKE = $CURMAN->db->sql_compare(); $FULLNAME = sql_concat('usr.firstname', "' '", 'usr.lastname'); $select = 'SELECT COUNT(usr.id) '; $tables = 'FROM ' . $CURMAN->db->prefix_table(USRTABLE) . ' usr '; $join = 'LEFT JOIN ' . $CURMAN->db->prefix_table(INSTABLE) . ' ins '; $on = 'ON ins.userid = usr.id '; /// If limiting returns to specific teams, set that up now. if (!empty($CFG->curr_configteams)) { $where = 'usr.team IN (' . $CFG->curr_configteams . ') '; } else { $where = ''; } if (!empty($namesearch)) { $namesearch = trim($namesearch); $where .= (!empty($where) ? ' AND ' : '') . "({$FULLNAME} {$LIKE} '%{$namesearch}%') "; } if ($alpha) { $where .= (!empty($where) ? ' AND ' : '') . "({$FULLNAME} {$LIKE} '{$alpha}%') "; } /* switch ($type) { case 'student': $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Student\' '; break; case 'instructor': $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Instructor\' '; break; case '': $where .= (!empty($where) ? ' AND ' : '') . '(usr.type = \'Student\' OR usr.type = \'Instructor\') '; break; } */ $uids = array(); $stu = new student(); if ($users = $stu->get_students()) { foreach ($users as $user) { $uids[] = $user->id; } } if ($users = $this->get_instructors()) { foreach ($users as $user) { $uids[] = $user->id; } } if (!empty($uids)) { $where .= (!empty($where) ? ' AND ' : '') . 'usr.id NOT IN ( ' . implode(', ', $uids) . ' ) '; } if (!empty($where)) { $where = 'WHERE ' . $where . ' '; } $sql = $select . $tables . $join . $on . $where; return $CURMAN->db->count_records_sql($sql); }
/** * * Funktion nimmt Anfragen entgegen und bearbeitet diese * @param $parameters -> XML SOAP File */ function GetStipendienbezieherStip($parameters) { $anfrageDaten = $parameters->anfrageDaten; $Stipendiumsbezieher = $anfrageDaten->Stipendiumsbezieher; $ErhalterKz = $anfrageDaten->ErhKz; $AnfrageDatenID = $anfrageDaten->AnfragedatenID; // Eintrag in der LogTabelle anlegen $log = new webservicelog(); $log->request_data = file_get_contents('php://input'); $log->webservicetyp_kurzbz = 'stip'; $log->request_id = $AnfrageDatenID; $log->beschreibung = "Anfrage von Stip"; $log->save(true); $username = $parameters->userName; $passwort = $parameters->passWord; if (!($username == STIP_USER_NAME && $passwort == STIP_USER_PASSWORD)) { // Eintrag in der LogTabelle anlegen $log = new webservicelog(); $log->request_data = 'SOAP FAULT - Invalid Credentials'; $log->webservicetyp_kurzbz = 'stip'; $log->request_id = $AnfrageDatenID; $log->beschreibung = "Antwort an Stip"; $log->save(true); return new SoapFault("Server", 'Invalid Credentials'); } $StipBezieherAntwort = array(); $i = 0; if (!is_array($Stipendiumsbezieher->StipendiumsbezieherAnfrage)) { $Stipendiumsbezieher->StipendiumsbezieherAnfrage = array($Stipendiumsbezieher->StipendiumsbezieherAnfrage); } // läuft alle Anfragedaten durch foreach ($Stipendiumsbezieher->StipendiumsbezieherAnfrage as $BezieherStip) { $prestudentID; $studentUID; $studSemester; $StipBezieher = new stip(); $datum_obj = new datum(); if ($StipBezieher->validateStipDaten($anfrageDaten->ErhKz, $anfrageDaten->AnfragedatenID, $BezieherStip)) { $StipBezieher->Semester = $BezieherStip->Semester; $StipBezieher->Studienjahr = $BezieherStip->Studienjahr; $StipBezieher->PersKz = $BezieherStip->PersKz; $StipBezieher->SVNR = $BezieherStip->SVNR; $StipBezieher->Familienname = $BezieherStip->Familienname; $StipBezieher->Vorname = $BezieherStip->Vorname; $StipBezieher->Typ = $BezieherStip->Typ; // Studiensemester_kurzbz auslesen if ($BezieherStip->Semester == "WS" || $BezieherStip->Semester == "ws") { $year = mb_substr($BezieherStip->Studienjahr, 0, 4); $studSemester = "WS" . $year; } elseif ($BezieherStip->Semester == "SS" || $BezieherStip->Semester == "ss") { $year = mb_substr($BezieherStip->Studienjahr, 0, 2) . mb_substr($BezieherStip->Studienjahr, 5, 7); $studSemester = "SS" . $year; } if (!($prestudentID = $StipBezieher->searchPersonKz($BezieherStip->PersKz))) { if (!($prestudentID = $StipBezieher->searchSvnr($BezieherStip->SVNR))) { $prestudentID = $StipBezieher->searchVorNachname($BezieherStip->Vorname, $BezieherStip->Familienname); } } // Student wurde gefunden if ($StipBezieher->AntwortStatusCode == 1) { $prestudent = new prestudent(); $prestudent->load($prestudentID); $prestudent->getLastStatus($prestudentID); $prestudentStatus = new prestudent(); $student = new student(); $studentUID = $student->getUID($prestudentID); $abschlusspruefung = new abschlusspruefung(); $abschlusspruefung->getLastAbschlusspruefung($studentUID); $student->load($studentUID); $studiengang_kz = $student->studiengang_kz; $konto = new konto(); $studGebuehr = $konto->getStudiengebuehrGesamt($studentUID, $studSemester, $studiengang_kz); // , als Dezimaltrennzeichen $studGebuehr = str_replace('.', ',', $studGebuehr); // wenn nicht bezahlt if ($studGebuehr == "") { $studGebuehr = "0,00"; } if (!$prestudentStatus->getLastStatus($prestudentID, $studSemester)) { $StipBezieher->Inskribiert = 'n'; } else { // wenn nur Interessent letzer Status ist -> nicht inskribiert if ($prestudentStatus->status_kurzbz == 'Interessent') { $StipBezieher->Inskribiert = 'n'; } else { $StipBezieher->Inskribiert = 'j'; } } if ($BezieherStip->Typ == "as" || $BezieherStip->Typ == "AS") { $StipBezieher->getOrgFormTeilCode($studentUID, $studSemester, $prestudentID); $StipBezieher->Studienbeitrag = $studGebuehr; // Wenn letzter Status von Semester Interessent ist -> Semester = null if ($prestudentStatus->status_kurzbz != 'Interessent') { $StipBezieher->Ausbildungssemester = $StipBezieher->getSemester($prestudentID, $studSemester); } else { $StipBezieher->Ausbildungssemester = null; } $StipBezieher->StudStatusCode = $StipBezieher->getStudStatusCode($prestudentID, $studSemester); // Ausgeschieden ohne Abschluss if ($StipBezieher->StudStatusCode == 4) { $StipBezieher->BeendigungsDatum = $datum_obj->formatDatum($prestudent->datum, 'dmY'); } else { if ($StipBezieher->StudStatusCode == 3) { // Absolvent -> letzte Prüfung nehmen $StipBezieher->BeendigungsDatum = $datum_obj->formatDatum($abschlusspruefung->datum, 'dmY'); } else { $StipBezieher->BeendigungsDatum = null; } } $StipBezieher->Erfolg = $StipBezieher->getErfolg($prestudentID, $studSemester); } elseif ($BezieherStip->Typ == "ag" || $BezieherStip->Typ == "AG") { $StipBezieher->Ausbildungssemester = null; $StipBezieher->StudStatusCode = null; $StipBezieher->BeendigungsDatum = null; $StipBezieher->Studienbeitrag = null; $StipBezieher->OrgFormTeilCode = null; } $StipBezieherAntwort[$i] = $StipBezieher; $i++; } else { if ($StipBezieher->AntwortStatusCode == 2) { // Student wurde nicht gefunden $StipBezieher->PersKz_Antwort = null; $StipBezieher->SVNR_Antwort = null; $StipBezieher->Familienname_Antwort = null; $StipBezieher->Vorname_Antwort = null; $StipBezieher->Ausbildungssemester = null; $StipBezieher->StudStatusCode = null; $StipBezieher->BeendigungsDatum = null; $StipBezieher->VonNachPersKz = null; $StipBezieher->Studienbeitrag = null; $StipBezieher->Inskribiert = null; $StipBezieher->Erfolg = null; $StipBezieher->OrgFormTeilCode = null; $StipBezieherAntwort[$i] = $StipBezieher; $i++; } } } else { // Eintrag in der LogTabelle anlegen $log = new webservicelog(); $log->request_data = 'SOAP FAULT - ValidationError: ' . $StipBezieher->errormsg; $log->webservicetyp_kurzbz = 'stip'; $log->request_id = $AnfrageDatenID; $log->beschreibung = "Antwort an Stip"; $log->save(true); return new SoapFault("Server", $StipBezieher->errormsg); } } $ret = array("GetStipendienbezieherStipResult" => array("ErhKz" => $ErhalterKz, "AnfragedatenID" => $AnfrageDatenID, "Stipendiumsbezieher" => $StipBezieherAntwort)); // Eintrag in der LogTabelle anlegen $log = new webservicelog(); $log->request_data = print_r($ret, true); $log->webservicetyp_kurzbz = 'stip'; $log->request_id = $AnfrageDatenID; $log->beschreibung = "Antwort an Stip"; $log->save(true); return $ret; }