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;
}
