, * Andreas Oesterreicher and * Rudolf Hangl . */ require_once('../../config/vilesci.config.inc.php'); require_once('../../include/studiensemester.class.php'); require_once('../../include/benutzerberechtigung.class.php'); require_once('../../include/functions.inc.php'); if(isset($_GET['stsem'])) $stsem = $_GET['stsem']; else $stsem = ''; $db = new basis_db(); $rechte = new benutzerberechtigung(); $rechte->getBerechtigungen(get_uid()); if(!$rechte->isBerechtigt('student/stammdaten', null, 's')) die($rechte->errormsg); echo ' '; include('../../include/meta/jquery.php'); include('../../include/meta/jquery-tablesorter.php'); echo ' '; echo "

AbgängerInnenstatistik ".$db->convert_html_chars($stsem); echo ''.date('d.m.Y').'


'; echo '
Studiensemester:


'; if ($stsem != '') { $stgs = $rechte->getStgKz(); if (count($stgs) == 0) $stgwhere = ''; else { $stgwhere = ' AND studiengang_kz in('; $stgwhere .= $db->db_implode4SQL($stgs); $stgwhere .= ' )'; } $qry = "SELECT studiengang_kz, kurzbz, typ, kurzbzlang, bezeichnung, orgform_kurzbz, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abgewiesener' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abgewiesene, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abgewiesener' AND geschlecht ='m' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abgewiesene_maennlich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abgewiesener' AND geschlecht ='w' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abgewiesene_weiblich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abbrecher' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abbrecher, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abbrecher' AND geschlecht ='m' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abbrecher_maennlich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Abbrecher' AND geschlecht ='w' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS abbrecher_weiblich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Unterbrecher' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS unterbrecher, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Unterbrecher' AND geschlecht='m' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS unterbrecher_maennlich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Unterbrecher' AND geschlecht='w' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS unterbrecher_weiblich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Absolvent' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS absolvent, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Absolvent' AND geschlecht='m' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS absolvent_maennlich, (SELECT count(*) FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING (person_id) WHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Absolvent' AND geschlecht='w' AND studiensemester_kurzbz=".$db->db_add_param($stsem)." ) AS absolvent_weiblich FROM public.tbl_studiengang stg WHERE studiengang_kz>0 AND studiengang_kz<10000 AND aktiv $stgwhere ORDER BY kurzbzlang; "; if ($db->db_query($qry)) { ?> db_fetch_object()) { ?>
Abgewiesene AbbrecherInnen UnterbrecherInnen AbsolventInnen
Studiengang m w Gesamt m w Gesamt m w Gesamt m w Gesamt
typ.$row->kurzbz)?> (kurzbzlang ?>) abgewiesene_maennlich ?> abgewiesene_weiblich ?> abgewiesene ?> abbrecher_maennlich ?> abbrecher_weiblich ?> abbrecher ?> unterbrecher_maennlich ?> unterbrecher_weiblich ?> unterbrecher ?> absolvent_maennlich ?> absolvent_weiblich ?> absolvent ?>