require_once '../../config/vilesci.config.inc.php';
require_once '../../include/functions.inc.php';
require_once '../../include/benutzerberechtigung.class.php';
require_once '../../include/erhalter.class.php';
require_once '../../include/studiensemester.class.php';
require_once '../../include/datum.class.php';
$uid = get_uid();
$rechte = new benutzerberechtigung();
$rechte->getBerechtigungen($uid);
if (!$rechte->isBerechtigt('admin')) {
die('Sie haben keine Berechtigung fuer diese Seite');
}
$db = new basis_db();
$datum_obj = new datum();
$stsem_obj = new studiensemester();
$studiensemester_kurzbz = $stsem_obj->getAktOrNext();
$erhalter = new erhalter();
$erhalter->getAll();
if (!isset($erhalter->result[0])) {
die('Es ist kein Erhalter vorhanden');
}
$erhalter_row = $erhalter->result[0];
$filename = sprintf('%1$03d', $erhalter_row->erhalter_kz) . '_' . str_replace(' ', '_', $erhalter_row->bezeichnung) . '.csv';
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=' . $filename);
// Daten holen - Alle Personen mit akt. Status Student, Diplomand die bezahlt haben
$qry = "\nSELECT * FROM (\nSELECT DISTINCT ON (matrikelnr) matrikelnr AS personenkennzeichen, \n\ttbl_person.svnr,\n\ttbl_person.ersatzkennzeichen,\n\ttbl_person.gebdatum,\n\ttbl_person.nachname,\n\ttbl_person.vorname,\n\ttbl_person.geschlecht,\n\ttbl_student.studiengang_kz,\n\ttbl_student.student_uid,\n\t(SELECT plz FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY zustelladresse desc LIMIT 1) AS zustell_plz, \n\t(SELECT gemeinde FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY zustelladresse desc LIMIT 1) AS zustell_ort, \n\t(SELECT strasse FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY zustelladresse desc LIMIT 1) AS zustell_strasse, \n\t(SELECT plz FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY heimatadresse desc LIMIT 1) AS heimat_plz, \n\t(SELECT gemeinde FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY heimatadresse desc LIMIT 1) AS heimat_ort, \n\t(SELECT strasse FROM public.tbl_adresse WHERE person_id=public.tbl_person.person_id ORDER BY heimatadresse desc LIMIT 1) AS heimat_strasse,\n\ttbl_person.person_id\nFROM public.tbl_person \n\tJOIN public.tbl_konto as ka using(person_id) \n\tJOIN public.tbl_konto as kb using(person_id) \n\tJOIN public.tbl_benutzer using(person_id) \n\tJOIN public.tbl_student on(uid=student_uid)\n\tJOIN public.tbl_prestudent using(prestudent_id)\n\tJOIN public.tbl_prestudentstatus on(tbl_prestudentstatus.prestudent_id=tbl_student.prestudent_id)\nWHERE \n\ttbl_prestudentstatus.studiensemester_kurzbz=" . $db->db_add_param($studiensemester_kurzbz) . " \n\tAND get_rolle_prestudent(tbl_prestudent.prestudent_id, " . $db->db_add_param($studiensemester_kurzbz) . ") in('Student','Diplomand')\n\tAND tbl_student.studiengang_kz<10000\n\tAND tbl_student.studiengang_kz>0\n\tAND tbl_student.studiengang_kz!='9" . $erhalter_row->erhalter_kz . "'\n\tAND ka.studiensemester_kurzbz=" . $db->db_add_param($studiensemester_kurzbz) . " AND ka.buchungstyp_kurzbz='OEH' AND tbl_student.studiengang_kz=ka.studiengang_kz \n\tAND kb.studiensemester_kurzbz=" . $db->db_add_param($studiensemester_kurzbz) . " AND kb.buchungstyp_kurzbz='OEH' AND tbl_student.studiengang_kz=kb.studiengang_kz \n\tAND kb.buchungsnr_verweis=ka.buchungsnr AND bismelden\n) a\nORDER BY person_id";
$last_person_id = '';
$data_row = array();
$personenkennzeichen = array();
$studiengang_kz = array();
