}
}
// Reservieren
if (isset($reserve) && $raumres) {
$ort_obj = new ort();
if (!$ort_obj->load($ort_kurzbz)) {
die($p->t('lvplan/raumExistiertNicht'));
}
if (!($erg_std = $db->db_query("SELECT * FROM lehre.tbl_stunde ORDER BY stunde"))) {
die($db->db_last_error());
}
$num_rows_std = $db->db_num_rows($erg_std);
$count = 0;
for ($t = 1; $t <= TAGE_PRO_WOCHE; $t++) {
for ($j = 0; $j < $num_rows_std; $j++) {
$stunde = $db->db_result($erg_std, $j, '"stunde"');
$var = 'reserve' . $t . '_' . $stunde;
if (isset($_REQUEST[$var])) {
$datum_res = $_REQUEST[$var];
$reservierung = new reservierung();
if (!$reservierung->isReserviert($ort_kurzbz, $datum_res, $stunde)) {
if (empty($_REQUEST['titel']) && empty($_REQUEST['beschreibung'])) {
echo "<br>" . $p->t('lvplan/titelUndBeschreibungFehlt') . "! <br>";
} else {
if (empty($_REQUEST['titel'])) {
echo "<br>" . $p->t('lvplan/titelFehlt') . "! <br>";
} else {
if (empty($_REQUEST['beschreibung'])) {
echo "<br>" . $p->t('lvplan/beschreibungFehlt') . "! <br>";
} else {
$reservierung = new reservierung();
//echo $query;
if (!($erg = $db->db_query($query))) {
die($db->db_last_error());
}
} else {
die("Zuviele Eintraege!");
}
}
}
}
if (!($erg = $db->db_query("SELECT * FROM campus.tbl_zeitwunsch WHERE mitarbeiter_uid='{$uid}'"))) {
die($db->db_last_error());
}
$num_rows = $db->db_num_rows($erg);
for ($i = 0; $i < $num_rows; $i++) {
$tag = $db->db_result($erg, $i, "tag");
$stunde = $db->db_result($erg, $i, "stunde");
$gewicht = $db->db_result($erg, $i, "gewicht");
$wunsch[$tag][$stunde] = $gewicht;
$updateamum = $db->db_result($erg, $i, "updateamum");
$updatevon = $db->db_result($erg, $i, "updatevon");
}
if (!isset($wunsch)) {
//6-16
for ($i = 1; $i < 7; $i++) {
for ($j = 0; $j < 17; $j++) {
$wunsch[$i][$j] = '1';
}
}
}
// Personendaten
$result_stg = $db->db_query($sql_query);
if (!$result_stg) {
echo "studiengang not found! " . $db->db_last_error() . ' line ' . __LINE__ . ' ; file ' . __FILE__ . "<br>";
}
$sql_query = "SELECT * FROM lehre.tbl_lehrfach ORDER BY kurzbz";
$result_lehrf = $db->db_query($sql_query);
if (!$result_lehrf) {
echo "lehrfach not found! " . $db->db_last_error() . ' line ' . __LINE__ . ' ; file ' . __FILE__ . "<br>";
}
$sql_query = "SELECT * FROM public.tbl_ort ORDER BY ort_kurzbz";
$result_ort = $db->db_query($sql_query);
if (!$result_ort) {
echo "ort not found! " . $db->db_last_error() . ' line ' . __LINE__ . ' ; file ' . __FILE__ . "<br>";
}
if ($result_stg && (!isset($stgid) || empty($stgid))) {
$stgid = $stgbz = $db->db_result($result_stg, 0, 'studiengang_kz');
}
$sql_query = "SELECT * FROM public.tbl_studiengang WHERE studiengang_kz={$stgid}";
$result_stgbz = $db->db_query($sql_query);
if (!$result_stgbz) {
echo "lehrfach not found! " . $db->db_last_error() . ' line ' . __LINE__ . ' ; file ' . __FILE__ . "<br>";
} else {
$stgbz = $db->db_result($result_stgbz, 0, 'kurzbz');
}
if (!isset($semester)) {
$semester = 0;
}
if (!isset($verband)) {
$verband = '0';
}
if (!isset($gruppe)) {
<?php
echo $p->t('zeitwunsch/help');
?>
</font>
</A>
</td>-->
<?php
echo "<h2>" . $p->t('zeitwunsch/zeitwunschVon') . " {$person->titelpre} {$person->vorname} {$person->nachname} {$person->titelpost}<br/></h2>";
echo $p->t('zeitwunsch/tragenSieInDiesesNormwochenraster') . "<br/><br/>";
echo '<FORM name="zeitwunsch" method="post" action="zeitwunsch.php?type=save" onsubmit="return checkvalues()">
<TABLE>
<TR>';
echo '<th>' . $p->t('global/stunde') . '<br>' . $p->t('global/beginn') . '<br>' . $p->t('global/ende') . '</th>';
for ($i = 0; $i < $num_rows_stunde; $i++) {
$beginn = $db->db_result($result_stunde, $i, '"beginn"');
$beginn = substr($beginn, 0, 5);
$ende = $db->db_result($result_stunde, $i, '"ende"');
$ende = substr($ende, 0, 5);
$stunde = $db->db_result($result_stunde, $i, '"stunde"');
echo "<th><div align=\"center\">{$stunde}<br>{$beginn}<br>{$ende}</div></th>";
}
echo '</TR>';
for ($j = 1; $j < 7; $j++) {
echo '<TR><TD>' . $tagbez[$lang->index][$j] . '</TD>';
for ($i = 0; $i < $num_rows_stunde; $i++) {
if (isset($wunsch[$j][$i + 1])) {
$index = $wunsch[$j][$i + 1];
} else {
$index = 1;
}
$var = 'wunsch' . $t . '_' . $i;
//echo $$var;
$gewicht = ${$var};
$stunde = $i + 1;
$query = "SELECT * FROM zeitwunsch WHERE lektor_id={$lkid} AND stunde_id={$stunde} AND tag={$t}";
if (!($erg_wunsch = $db->db_query($query))) {
die($db->db_last_error());
}
$num_rows_wunsch = $db->db_num_rows($erg_wunsch);
if ($num_rows_wunsch == 0) {
$query = "INSERT INTO zeitwunsch (lektor_id, stunde_id, tag, gewicht) VALUES ({$lkid}, {$stunde}, {$t}, {$gewicht})";
if (!($erg = $db->db_query($query))) {
die($db->db_last_error());
}
} elseif ($num_rows_wunsch == 1) {
$id = $db->db_result($erg_wunsch, 0, "id");
$query = "UPDATE zeitwunsch SET lektor_id={$lkid}, stunde_id={$stunde}, tag={$t}, gewicht={$gewicht} WHERE id={$id}";
if (!($erg = $db->db_query($query))) {
die($db->db_last_error());
}
} else {
die("Zuviele Eintraege fuer!");
}
}
}
?>
<html>
<head>
<title>Profil</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
if (!($uid = get_uid())) {
die('Sie sind nicht angemeldet. Es wurde keine Benutzer UID gefunden ! <a href="javascript:history.back()">Zurück</a>');
}
$sql_query = "SELECT titelpre, titelpost, uid, nachname, vorname FROM campus.vw_benutzer WHERE uid LIKE '{$uid}'";
//echo $sql_query;
$result = $db->db_query($sql_query);
if ($db->db_num_rows($result) == 0) {
//GastAccount
$titelpre = '';
$titelpost = '';
$uid = '';
$nachname = '';
$vornamen = '';
//echo "User not found!";
} else {
$titelpre = $db->db_result($result, 0, '"titelpre"');
$titelpost = $db->db_result($result, 0, '"titelpost"');
$uid = $db->db_result($result, 0, '"uid"');
$nachname = $db->db_result($result, 0, '"nachname"');
$vornamen = $db->db_result($result, 0, '"vorname"');
}
$sql_query = "SELECT studiengang_kz, kurzbz, kurzbzlang, bezeichnung, typ, english FROM public.tbl_studiengang WHERE aktiv ORDER BY typ, kurzbz";
$result_stg = $db->db_query($sql_query);
if (!$result_stg) {
die("Studiengang not found!");
}
$num_rows_stg = $db->db_num_rows($result_stg);
$sql_query = "SELECT ort_kurzbz, bezeichnung FROM public.tbl_ort WHERE aktiv AND lehre ORDER BY ort_kurzbz";
$result_ort = $db->db_query($sql_query);
if (!$result_ort) {
die("ort not found!");
echo '<link rel="stylesheet" media="print" href="../../../skin/cis.css" type="text/css">';
echo '<link rel="stylesheet" type="text/css" media="print" href="../../../skin/print.css" />';
echo '</head>';
echo '<body id="inhalt">';
}
if (!isset($begin) || !isset($ende)) {
// datum holen falls nicht gesetzt
if (!isset($_GET['semesterplan'])) {
die($p->t('global/datumNichtGesetzt') . "!");
} else {
$query = "SELECT start,ende FROM campus.tbl_studiensemester WHERE studiensemester_kurzbz=(SELECT wert FROM public.tbl_variable WHERE name='semester_aktuell' AND uid='{$uid}');";
if (!($result_semester = $db->db_query($query))) {
die($db->db_last_error());
}
if ($db->db_num_rows($result_semester) > 0) {
$begin = strtotime($db->db_result($result_semester, 0, 'start'));
$ende = strtotime($db->db_result($result_semester, 0, 'ende'));
} else {
die($p->t('global/studiensemesterKonnteNichtGefundenWerden') . '!');
}
$result_semester = $db->db_query("SELECT wert FROM public.tbl_variable WHERE uid='{$uid}' AND name='db_stpl_table';");
if ($db->db_num_rows($result_semester) > 0) {
$db_stpl_table = $db->db_result($result_semester, 0, 'wert');
} else {
die($p->t('global/userNichtGefunden') . '!');
}
}
}
if ($ende - $begin > 31536000) {
die($p->t('lvplan/datumsbereichZuGross') . "!");
}
