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();