$grp_obj = new gruppe(); if (!$grp_obj->getgruppe($row->studiengang_kz, null, true, true)) { echo $grp_obj->errormsg; } $zeile = 0; //StudentenListe Rausschreiben if ($row->studiengang_kz != 0) { $qry_stud = "SELECT count(*) as anzahl FROM public.tbl_student WHERE studiengang_kz='{$row->studiengang_kz}' AND student_uid NOT LIKE '_Dummy%'"; if (!($row_stud = $db->db_fetch_object($db->db_query($qry_stud)))) { echo $p->t('mailverteiler/fehlerBeimLadenDerStudenten'); } echo '<tr><td colspan="4" style="padding-left: 12px;"><a href="#" onClick="return(js_toggle_container(\'' . $row->kuerzel . '\'));"><img height="9px" src="../../skin/images/right_lvplan.png" title="' . $p->t('mailverteiler/ausblenden') . '" alt="' . $p->t('mailverteiler/ausblenden') . '" border="0"> ' . $p->t('mailverteiler/studentenverteiler') . '</a></td></tr>'; echo '<tr><td width="100%">'; echo '<table class="tabcontent2" id="' . $row->kuerzel . '" style="display: none">'; $lv_obj = new lehrverband(); $lv_obj->getlehrverband($row->studiengang_kz); $zeilenzaehler = 0; echo "\n"; foreach ($lv_obj->result as $row1) { if (!is_null($row1->semester) && !empty($row1->semester) && $row1->semester != "" && $row1->semester <= $row->max_semester && $row1->semester > '0') { $qry_cnt = "SELECT count(*) as anzahl FROM public.tbl_student WHERE studiengang_kz='{$row1->studiengang_kz}' AND semester='{$row1->semester}' AND student_uid NOT LIKE '_Dummy%'"; if (trim($row1->verband) != '') { $qry_cnt .= " AND verband='{$row1->verband}'"; if (trim($row1->gruppe) != '') { $qry_cnt .= " AND gruppe='{$row1->gruppe}'"; } } if ($row_cnt = $db->db_fetch_object($db->db_query($qry_cnt))) { if ($row_cnt->anzahl > 0) { $zeile++; if ($zeile % 2) {
$data[] = $row->verband; } } $data = array_unique($data); echo json_encode($data); } else { echo $studiengang->errormsg; } break; case 'getGruppe': $lvb = new lehrverband(); $studiengang_kz = $_REQUEST['stg_kz']; $semester = $_REQUEST['sem']; $verband = $_REQUEST['ver']; $data = array(); if ($lvb->getlehrverband($studiengang_kz, $semester, $verband)) { foreach ($lvb->result as $row) { if (trim($row->gruppe) != '') { $data[] = $row->gruppe; } } $data = array_unique($data); echo json_encode($data); } else { echo $studiengang->errormsg; } break; default: echo 'Invalid Parameter'; break; }