echo '<option value="l" ' . ($person->familienstand == 'l' ? 'selected' : '') . '>ledig</option>';
echo '<option value="v" ' . ($person->familienstand == 'v' ? 'selected' : '') . '>verheiratet</option>';
echo '<option value="g" ' . ($person->familienstand == 'g' ? 'selected' : '') . '>geschieden</option>';
echo '<option value="w" ' . ($person->familienstand == 'w' ? 'selected' : '') . '>verwitwert</option>';
echo '</SELECT></td>';
echo "</tr><tr><td></td><td></td><td></td><td></td><td></td><td><input " . ($disabled ? 'disabled' : '') . " type='submit' value='Speichern' name='saveperson'></td>";
echo "</tr></table></form>";
echo "</div>";
// ----- PREINTERESSENT -----
echo "<div id='preinteressent' style='display: " . ($selection == 'preinteressent' ? 'block' : 'none') . "'>";
echo "<form accept-charset='UTF-8' action='" . $_SERVER['PHP_SELF'] . "?id={$preinteressent->preinteressent_id}&selection=preinteressent' method='POST'>";
echo '<table width="100%" ><tr>';
//STUDIENSEMESTER
echo "<td>Studiensemester:</td><td><SELECT name='studiensemester_kurzbz'>";
$stsem = new studiensemester();
$stsem->getAll();
echo "<option value='' >-- offen --</option>";
foreach ($stsem->studiensemester as $row) {
    if ($row->studiensemester_kurzbz == $preinteressent->studiensemester_kurzbz) {
        $selected = 'selected';
    } else {
        $selected = '';
    }
    echo "<option value='{$row->studiensemester_kurzbz}' {$selected}>{$row->studiensemester_kurzbz}</option>";
}
echo "</SELECT>";
echo '</td>';
//AUFMERKSAMDURCH
echo "<td>Aufmerksam durch:</td><td> <SELECT name='aufmerksamdurch_kurzbz'>";
$aufmerksam = new aufmerksamdurch();
$aufmerksam->getAll('beschreibung');
<head>
	<title>Studenten Vorrueckung</title>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<link rel="stylesheet" href="../../skin/vilesci.css" type="text/css">
	<link rel="stylesheet" href="../../include/js/tablesort/table.css" type="text/css">
	<script src="../../include/js/tablesort/table.js" type="text/javascript"></script>
</head>
<body class="Background_main">';
// Output flushen damit nach dem aendern des Dropdowns gleich die neue Seite geladen wird.
// Sonst wird bei zu langen Ladezeiten vom User noch auf einen anderen Link gedrueckt und der Studiengang
// wieder zurueckgesetzt
ob_flush();
flush();
//Einlesen der studiensemester in einen Array
$ss = new studiensemester();
$ss->getAll();
foreach ($ss->studiensemester as $studiensemester) {
    $ss_arr[] = $studiensemester->studiensemester_kurzbz;
}
//Übergabeparameter
//studiengang
if (isset($_GET['stg_kz']) || isset($_POST['stg_kz'])) {
    $stg_kz = isset($_GET['stg_kz']) ? $_GET['stg_kz'] : $_POST['stg_kz'];
} else {
    $stg_kz = $studiengang[0]->studiengang_kz;
}
//semester anzeige
if (isset($_GET['semester']) || isset($_POST['semester'])) {
    $semester = isset($_GET['semester']) ? $_GET['semester'] : $_POST['semester'];
} else {
    $semester = 100;
예제 #3
0
    $stsem = '';
}
//Vars
$datum_obj = new datum();
$uebung_id = isset($_GET['uebung_id']) ? $_GET['uebung_id'] : '';
//Kopfzeile
echo '<table width="100%">';
echo ' <tr><td>';
echo '<h1>' . $p->t('benotungstool/benotungstool');
echo '</h1></td><td align="right">' . "\n";
//Studiensemester laden
$stsem_obj = new studiensemester();
if ($stsem == '') {
    $stsem = $stsem_obj->getaktorNext();
}
$stsem_obj->getAll();
//Studiensemester DropDown
$stsem_content = $p->t('global/studiensemester') . ": <SELECT name='stsem' onChange=\"MM_jumpMenu('self',this,0)\">\n";
foreach ($stsem_obj->studiensemester as $studiensemester) {
    $selected = $stsem == $studiensemester->studiensemester_kurzbz ? 'selected' : '';
    $stsem_content .= "<OPTION value='statistik.php?lvid={$lvid}&stsem={$studiensemester->studiensemester_kurzbz}' {$selected}>{$studiensemester->studiensemester_kurzbz}</OPTION>\n";
}
$stsem_content .= "</SELECT>\n";
//Lehreinheiten laden
if ($rechte->isBerechtigt('admin', 0) || $rechte->isBerechtigt('admin', $lv_obj->studiengang_kz) || $rechte->isBerechtigt('lehre', $lv_obj->studiengang_kz)) {
    $qry = "SELECT \n\t\t\t\tdistinct lehrfach.kurzbz as lfbez, tbl_lehreinheit.lehreinheit_id, tbl_lehreinheit.lehrform_kurzbz as lehrform_kurzbz \n\t\t\tFROM \n\t\t\t\tlehre.tbl_lehreinheit, lehre.tbl_lehrveranstaltung as lehrfach, lehre.tbl_lehreinheitmitarbeiter\n\t\t\tWHERE \n\t\t\t\ttbl_lehreinheit.lehrveranstaltung_id=" . $db->db_add_param($lvid, FHC_INTEGER) . " AND\n\t\t\t\ttbl_lehreinheit.lehrfach_id = lehrfach.lehrveranstaltung_id AND\n\t\t\t\ttbl_lehreinheit.lehreinheit_id = tbl_lehreinheitmitarbeiter.lehreinheit_id AND\n\t\t\t\ttbl_lehreinheit.studiensemester_kurzbz = " . $db->db_add_param($stsem);
} else {
    $qry = "SELECT \n\t\t\t\tdistinct lehrfach.kurzbz as lfbez, tbl_lehreinheit.lehreinheit_id, tbl_lehreinheit.lehrform_kurzbz as lehrform_kurzbz \n\t\t\tFROM \n\t\t\t\tlehre.tbl_lehreinheit, lehre.tbl_lehrveranstaltung as lehrfach, lehre.tbl_lehreinheitmitarbeiter\n\t\t\tWHERE \n\t\t\t\ttbl_lehreinheit.lehrveranstaltung_id=" . $db->db_add_param($lvid, FHC_INTEGER) . " AND\n\t\t\t\ttbl_lehreinheit.lehrfach_id = lehrfach.lehrveranstaltung_id AND\n\t\t\t\ttbl_lehreinheit.lehreinheit_id = tbl_lehreinheitmitarbeiter.lehreinheit_id AND\n\t\t\t\ttbl_lehreinheit.lehrveranstaltung_id IN (SELECT lehrveranstaltung_id FROM lehre.tbl_lehreinheit JOIN lehre.tbl_lehreinheitmitarbeiter USING(lehreinheit_id) WHERE mitarbeiter_uid=" . $db->db_add_param($user) . ") AND\n\t\t\t\ttbl_lehreinheit.studiensemester_kurzbz = " . $db->db_add_param($stsem);
}
if ($result = $db->db_query($qry)) {
    if ($db->db_num_rows($result) > 1) {
// header für no cache
header("Cache-Control: no-cache");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Expires Mon, 26 Jul 1997 05:00:00 GMT");
header("Pragma: no-cache");
// content type setzen
header("Content-type: application/xhtml+xml");
// xml
echo '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>';
// DAO
require_once '../config/vilesci.config.inc.php';
require_once '../include/studiensemester.class.php';
// studiensemester holen
isset($_GET['order']) ? $order = $_GET['order'] : ($order = null);
$studiensemesterDAO = new studiensemester();
$studiensemesterDAO->getAll($order);
$rdf_url = 'http://www.technikum-wien.at/studiensemester';
?>

<RDF:RDF
	xmlns:RDF="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
	xmlns:STUDIENSEMESTER="<?php 
echo $rdf_url;
?>
/rdf#"
>
   <RDF:Seq about="<?php 
echo $rdf_url;
?>
/liste">
<?php 
예제 #5
0
	           		<menuitem
						 id        	="menu-prefs-stpltable-stundenplandev"
						 type		="radio"
	          			 key       	="menu-prefs-stpltable-stundenplandev:key"
						 label     	="&menu-prefs-stpltable-stundenplandev.label;"
						 command   	="menu-prefs-stpltable-stundenplandev:command"
	           			 accesskey 	="&menu-prefs-stpltable-stundenplandev.accesskey;"/>
	      		</menupopup>
	      	</menu>-->
	      	<menu
           id        =  "menu-properies-studiensemester"
           label     = "Studiensemester">
           <menupopup id="menu-properties-popup">
       <?php 
$stsemobj = new studiensemester();
$stsemobj->getAll();
foreach ($stsemobj->studiensemester as $stsem) {
    echo "\n\t\t\t<menuitem\n\t\t\t\tid = 'menu-properies-studiensemester-name'\n\t\t\t\tlabel = '{$stsem->studiensemester_kurzbz}'\n\t\t\t\ttype = 'radio'\n\t\t\t\tcommand = 'menu-properties-studiensemester:command'\n\t\t\t\tchecked = " . ($variable->variable->semester_aktuell == $stsem->studiensemester_kurzbz ? "'true' " : "'false'") . " />";
}
?>

      		</menupopup>
        </menu>
   		<menuitem
			 id        	="menu-prefs-kontofilterstg"
			 type		="checkbox"
  			 key       	="menu-prefs-kontofilterstg:key"
			 label     	="&menu-prefs-kontofilterstg.label;"
			 command   	="menu-prefs-kontofilterstg:command"
   			 accesskey 	="&menu-prefs-kontofilterstg.accesskey;"
   			 checkbox   ="true"
		<ul id='stgListe'>
		    
		</ul>
=======
		<div>
		    <h2>Studiengänge</h2>
		    <div id='stgListe'>

		    </div>
		</div>
		<div>
		    <h2>Studiensemester</h2>
		    <?php 
echo '<select id="filter_studiensemester" onchange="loadPruefungStudiengang();" style="visibility: hidden;">';
$aktuellesSemester = $studiensemester->getaktorNext();
$studiensemester->getAll();
foreach ($studiensemester->studiensemester as $sem) {
    /*@var $sem studiensemester */
    if ($aktuellesSemester == $sem->studiensemester_kurzbz) {
        echo '<option selected value="' . $sem->studiensemester_kurzbz . '">' . $sem->bezeichnung . '</option>';
    } else {
        echo '<option value="' . $sem->studiensemester_kurzbz . '">' . $sem->bezeichnung . '</option>';
    }
}
echo '</select></p>';
?>
		</div>
>>>>>>> fee287127566cd5d18c55b556d178b661711c694
	    </div>
	</div>
	<div id='prfWrapper'>
$stsem_obj->load($stsem);
echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<link href="../../skin/vilesci.css" rel="stylesheet" type="text/css">
	<link rel="stylesheet" href="../../include/js/tablesort/table.css" type="text/css">
	<script src="../../include/js/tablesort/table.js" type="text/javascript"></script>
	</head>
	<body>';
echo "<h2>Studierendenstatistik {$stsem}";
echo '<span style="position:absolute; right:15px;">' . date('d.m.Y') . '</span></h2><br>';
echo '</h2>';
echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="GET">Studiensemester: <SELECT name="stsem">';
$studsem = new studiensemester();
$studsem->getAll();
foreach ($studsem->studiensemester as $stsemester) {
    if ($stsemester->studiensemester_kurzbz == $stsem) {
        $selected = 'selected';
    } else {
        $selected = '';
    }
    echo '<option value="' . $stsemester->studiensemester_kurzbz . '" ' . $selected . '>' . $stsemester->studiensemester_kurzbz . '</option>';
}
echo '</SELECT>
		<input type="submit" value="Anzeigen" /></form><br><br>';
if ($stsem != '') {
    echo "<table class='liste table-stripeclass:alternate table-autostripe'>\n\t\t\t\t<thead>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th></th>\n\t\t\t\t\t\t<th></th>\n\t\t\t\t\t\t<th>Anteil an Gesamt</th>\n\t\t\t\t\t\t<th>Extern</th>\n\t\t\t\t\t\t<th>Studienart</th>\n\t\t\t\t\t\t<th colspan=2>Geschlecht</th>\n\t\t\t\t\t\t<th colspan=3>Staatsb&uuml;rgerschaft</th>\n\t\t\t\t\t</tr>\n\t\t\t\t</thead>\n\t\t\t\t<tbody>\n\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Bachelor</th>\n\t\t\t\t\t\t<th>Studiengänge</th>\n\t\t\t\t\t\t<th>Absolut / %</th>\n\t\t\t\t\t\t<th>In / Out</th>\n\t\t\t\t\t\t<th>BB / VZ / DL</th>\n\t\t\t\t\t\t<th>m</th>\n\t\t\t\t\t\t<th>w</th>\n\t\t\t\t\t\t<th>&Ouml;sterreich</th>\n\t\t\t\t\t\t<th>EU</th>\n\t\t\t\t\t\t<th>Nicht-EU</th>\n\t\t\t\t\t</tr>\n\t\t\t ";
    //Bachelor
    $qry = "SELECT studiengang_kz, kurzbz, typ, kurzbzlang, bezeichnung, orgform_kurzbz,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='{$stsem}'\n\t\t\t\t\t) a) AS gesamt_stg,\n\t\t\t\t\t\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_studiengang USING(studiengang_kz)\n\t   \t\t\t \tWHERE status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND typ='b'\n\t\t\t\t\t) a) AS gesamt_alle,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Incoming' AND studiensemester_kurzbz='" . addslashes($stsem) . "'\n\t\t\t\t\t) a) AS inc,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct student_uid FROM public.tbl_student JOIN bis.tbl_bisio USING (student_uid)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND (bis>='" . addslashes($stsem_obj->start) . "' OR bis is null) AND von<='" . addslashes($stsem_obj->ende) . "'\n\t\t\t\t\t) a) AS out,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND orgform_kurzbz='BB'\n\t\t\t\t\t) a) AS bb,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND orgform_kurzbz='VZ'\n\t\t\t\t\t) a) AS vz,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND orgform_kurzbz='DL'\n\t\t\t\t\t) a) AS fs,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING(person_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND geschlecht='w'\n\t\t\t\t\t) a) AS w,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING(person_id)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND geschlecht='m'\n\t\t\t\t\t) a) AS m,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING(person_id) JOIN bis.tbl_nation on(staatsbuergerschaft=nation_code)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND nation_code='A'\n\t\t\t\t\t) a) AS herkunft_at,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING(person_id) JOIN bis.tbl_nation on(staatsbuergerschaft=nation_code)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND eu AND nation_code<>'A'\n\t\t\t\t\t) a) AS herkunft_eu,\n\t\t\t\t(SELECT count(*) FROM (SELECT distinct prestudent_id FROM public.tbl_prestudent JOIN public.tbl_prestudentstatus USING (prestudent_id) JOIN public.tbl_person USING(person_id) JOIN bis.tbl_nation on(staatsbuergerschaft=nation_code)\n\t   \t\t\t \tWHERE studiengang_kz=stg.studiengang_kz AND status_kurzbz='Student' AND studiensemester_kurzbz='" . addslashes($stsem) . "' AND NOT eu\n\t\t\t\t\t) a) AS herkunft_noteu,\n\t\t\t\ttrue\n\t\t\tFROM\n\t\t\t\tpublic.tbl_studiengang stg\n\t\t\tWHERE\n\t\t\t\tstudiengang_kz>0 AND studiengang_kz<10000 AND aktiv AND typ='b'\n\t\t\tORDER BY typ, kurzbzlang; ";
    if ($result = $db->db_query($qry)) {
$cFormName = 'workMoodleCurse' . $mdl_course_id;
$content .= '
                <form accept-charset="UTF-8" name="' . $cFormName . '"  method="POST" target="_self" action="' . $_SERVER['PHP_SELF'] . '" >
                        <table class="liste">
						<tr><td>&nbsp;</td></tr>
                        <tr>
                                <td>&nbsp;Studiensemester&nbsp;</td>
                                <td>&nbsp;Studiengang&nbsp;</td>
                                <td>&nbsp;Semster&nbsp;</td>
				   				 <td>&nbsp;</td>
                        </tr>
                   <tr>';
//---------------------------------------------------------------------------
// Studiensemester public.tbl_studiensemester_kurzbz
$content .= '<td valign="top"><select onchange="document.' . $cFormName . '.aendern_bezeichnung.value=\'\';document.' . $cFormName . '.aendern_lehrveranstaltung_id.checked=false;uncheckLE();generateLEText();document.' . $cFormName . '.submit();" name="aendern_studiensemester_kurzbz">';
if ($stsem->getAll()) {
    foreach ($stsem->studiensemester as $row) {
        $content .= '<option value="' . $row->studiensemester_kurzbz . '" ' . ("{$aendern_studiensemester_kurzbz}" == "{$row->studiensemester_kurzbz}" ? ' selected="selected" ' : '') . '>&nbsp;' . $row->studiensemester_kurzbz . '&nbsp;</option>';
    }
} else {
    $errormsg[] = 'Studiensemester wurden nicht gefunden! ' . $stsem->errormsg;
}
$content .= '</select></td>';
//---------------------------------------------------------------------------
// Studiengang public.tbl_studiengang_kz
$content .= '<td valign="top"><select onchange="document.' . $cFormName . '.aendern_bezeichnung.value=\'\';document.' . $cFormName . '.aendern_lehrveranstaltung_id.checked=false;uncheckLE();generateLEText();document.' . $cFormName . '.submit();" name="aendern_studiengang_kz">';
$aendern_studiengang_name = '';
if ($stg_obj->getAll('typ, kurzbz', true)) {
    $max_semester = 0;
    $arrStudiengang = '';
    foreach ($stg_obj->result as $row) {