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