diff options
Diffstat (limited to 'www-ssl_old/nonpublic')
-rw-r--r-- | www-ssl_old/nonpublic/myschichtplan.php | 178 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/myschichtplan_ical.php | 51 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/schichtplan.1.php | 20 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/schichtplan.2.php | 22 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/schichtplan.php | 220 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/schichtplan_add.php | 114 | ||||
-rw-r--r-- | www-ssl_old/nonpublic/schichtplan_beamer.php | 59 |
7 files changed, 664 insertions, 0 deletions
diff --git a/www-ssl_old/nonpublic/myschichtplan.php b/www-ssl_old/nonpublic/myschichtplan.php new file mode 100644 index 00000000..5d7b5da3 --- /dev/null +++ b/www-ssl_old/nonpublic/myschichtplan.php @@ -0,0 +1,178 @@ +<?php + +// Eigener Schichtplan +require_once ('../bootstrap.php'); + +$title = "Himmel"; +$header = "Mein Schichtplan"; + +include ("includes/header.php"); +include ("includes/funktionen.php"); +include ("includes/funktion_schichtplan.php"); +include ("includes/funktion_schichtplan_aray.php"); + +if (!isset ($_GET["action"])) { + echo Get_Text("Hello") . $_SESSION['Nick'] . ", <br />\n"; + echo Get_Text("pub_mywake_beschreibung1") . "<br />\n"; + echo Get_Text("pub_mywake_beschreibung2") . "<br /><br />\n"; + echo Get_Text("pub_mywake_beschreibung3") . ($LETZTES_AUSTRAGEN) . + Get_Text("pub_mywake_beschreibung4") . "<br /><br />\n"; + + $USER_ID = $_SESSION['UID']; + + if ($_SESSION['CVS']["admin/schichtplan.php"] == "Y") { + if (!isset ($_GET["UIDs"])) + $_GET["UIDs"] = $_SESSION['UID']; + else + $USER_ID = $_GET["UIDs"]; + + echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >"; + + echo "Liste von <select name=\"UIDs\">\n"; + + $usql = "SELECT * FROM `User` ORDER BY `Nick`"; + $uErg = mysql_query($usql, $con); + $urowcount = mysql_num_rows($uErg); + + for ($k = 0; $k < $urowcount; $k++) { + echo "<option value=\"" . mysql_result($uErg, $k, "UID") . "\" " . + (($_GET["UIDs"] == mysql_result($uErg, $k, "UID")) ? " selected" : "") . ">" . + mysql_result($uErg, $k, "Nick") . + "</option>\n"; + } + + echo "</select> anzeigen.\n"; + echo mysql_error($con); + + echo "<input type=\"submit\" value=\"zeigen\">\n"; + + echo "</form>"; + } + + $SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` " . + "INNER JOIN `ShiftEntry` " . + "ON `Shifts`.`SID`=`ShiftEntry`.`SID` " . + "WHERE `ShiftEntry`.`UID`='$USER_ID' " . + "ORDER BY `DateS`"; + $erg = mysql_query($SQL, $con); +?> + <table border="0" class="border" cellpadding="2" cellspacing="1"> + <tr> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Datum");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Uhrzeit");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Len");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Name");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Ort");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Bemerkung");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Austragen");?></b></td> + </tr> + <?php + + + for ($i = 0; $i < mysql_num_rows($erg); $i++) { + echo "<tr class=\"content\">"; + + echo "<td>" . substr(mysql_result($erg, $i, "DateS"), 0, 10) . "</td>\n"; + echo "<td>" . substr(mysql_result($erg, $i, "DateS"), 11) . "</td>\n"; + echo "<td>" . mysql_result($erg, $i, "Len") . " h</td>\n"; + echo "<td>" . mysql_result($erg, $i, "Man") . "</td>\n"; + echo "<td>" . $RoomID[mysql_result($erg, $i, "RID")] . "<br />\n" . + "(" . TID2Type(mysql_result($erg, $i, "TID")) . Get_Text("inc_schicht_engel") . ")" . + "</td>\n"; + echo "<td><pre style=\"font-family:Fixedsys,Courier; padding:12x;\">\n" . + mysql_result($erg, $i, "Comment") . + "\n</pre>\n"; + echo "<br /><a href=\"./myschichtplan.php?action=edit&SID=\n" . + mysql_result($erg, $i, "SID") . "\"># vi #</a></td>\n"; + + // bis $LETZTES_AUSTRAGEN (aus dem config-file) soll es moeglich sein, seine Schichten + //// selber noch austragen zu koennen... + $schichtdate = mysql_result($erg, $i, "DateS"); + ereg("^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})", $schichtdate, $res); + $info["year"] = $res[1]; + $info["month"] = $res[2]; + $info["day"] = $res[3]; + $info["hour"] = $res[4]; + $info["min"] = $res[5]; + $info["sec"] = $res[6]; + $schichtdatum = (mktime($info["hour"], $info["min"], $info["sec"], $info["month"], $info["day"], $info["year"])); + $lastAustragen = $LETZTES_AUSTRAGEN * 3600; + $nowdate = time(); + // wenn Schichtbeginn > jetziges Datum + $LETZTES_AUSTRAGEN - Stunden soll ein Austragen + // noch m�glich sein + if ($schichtdatum > ($lastAustragen + $nowdate)) + echo "<td> <a href=\"./myschichtplan.php?action=austragen&SID=" . + mysql_result($erg, $i, "SID") . "\">" . + Get_Text("pub_mywake_austragen") . "</a></td>\n"; + else + echo "<td>" . Get_Text("pub_mywake_austragen_n_c") . "</td>\n"; + + echo "</tr>\n"; + } + echo "</table>\n\n"; + + if ($_SESSION['CVS']["nonpublic/myschichtplan_ical.php"] == "Y") { + echo "<br /><a href=\"./myschichtplan_ical.php\">" . Get_Text("pub_myschichtplan_ical") . "</a>\n"; + } + +} else { + If ($_GET["action"] == "austragen") { + echo Get_Text("pub_mywake_delate1") . "<br />\n"; + + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "')"; + $Erg = mysql_query($sql, $con); + + $schichtdate = mysql_result($Erg, 0, "DateS"); + ereg("^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})", $schichtdate, $res); + $info["year"] = $res[1]; + $info["month"] = $res[2]; + $info["day"] = $res[3]; + $info["hour"] = $res[4]; + $info["min"] = $res[5]; + $info["sec"] = $res[6]; + $schichtdatum = (mktime($info["hour"], $info["min"], $info["sec"], $info["month"], $info["day"], $info["year"])); + $lastAustragen = $LETZTES_AUSTRAGEN * 3600; + $nowdate = time(); + // wenn Schichtbeginn > jetziges Datum + $LETZTES_AUSTRAGEN - Stunden soll ein Austragen + // noch m�glich sein + if ($schichtdatum > ($lastAustragen + $nowdate)) { + $sql2 = "UPDATE `ShiftEntry` " . + "SET `UID` = '0', `Comment` = NULL " . + "WHERE `SID` = '" . $_GET["SID"] . "' AND `UID` = '" . $_SESSION['UID'] . "' LIMIT 1;"; + $Erg2 = mysql_query($sql2, $con); + if ($Erg2 == 1) + echo Get_Text("pub_mywake_add_ok") . "\n"; + else + echo Get_Text("pub_mywake_add_ko") . "\n"; + } else + echo Get_Text("pub_mywake_after") . "\n"; + } + elseif ($_GET["action"] == "edit") { + echo Get_Text("pub_myshift_Edit_Text1") . "\n"; + + $sql = "SELECT * FROM `ShiftEntry` WHERE "; + $sql .= "(`SID`='" . $_GET["SID"] . "' AND `UID`='" . $_SESSION['UID'] . "')"; + $Erg = mysql_query($sql, $con); + + echo "<form action=\"./myschichtplan.php\" method=\"GET\">\n"; + echo "<textarea name='newtext' cols='50' rows='10'>" . mysql_result($Erg, 0, "Comment") . "</textarea><br /><br />\n"; + echo "<input type=\"submit\" value=\"save\">\n"; + echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n"; + echo "<input type=\"hidden\" name=\"action\" value=\"editSave\">\n"; + echo "</form>"; + } + elseif ($_GET["action"] == "editSave") { + echo Get_Text("pub_myshift_EditSave_Text1") . "<br />\n"; + $sql = "UPDATE `ShiftEntry` " . + "SET `Comment` = '" . $_GET["newtext"] . "' " . + "WHERE `SID`='" . $_GET["SID"] . "' AND `UID`='" . $_SESSION['UID'] . "' LIMIT 1;"; + $Erg = mysql_query($sql, $con); + if ($Erg == 1) + echo " ..." . Get_Text("pub_myshift_EditSave_OK") . "\n"; + else + echo " ..." . Get_Text("pub_myshift_EditSave_KO") . "\n"; + SetHeaderGo2Back(); + } +} +include ("includes/footer.php"); +?> diff --git a/www-ssl_old/nonpublic/myschichtplan_ical.php b/www-ssl_old/nonpublic/myschichtplan_ical.php new file mode 100644 index 00000000..ff74fef0 --- /dev/null +++ b/www-ssl_old/nonpublic/myschichtplan_ical.php @@ -0,0 +1,51 @@ +<?php +require_once ('../bootstrap.php'); + +include ("includes/header_start.php"); + +include ("includes/funktion_schichtplan_aray.php"); + +$SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` " . +"INNER JOIN `ShiftEntry` " . +"ON `Shifts`.`SID`=`ShiftEntry`.`SID` " . +"WHERE `ShiftEntry`.`UID`='" . $_SESSION['UID'] . "' " . +"ORDER BY `DateS`"; +$erg = mysql_query($SQL, $con); + +//HEADER +header("Content-Type: text/x-vCalendar"); +header("Content-Disposition: attachment; filename=\"Schichtplan.ics\""); + +//DATA +echo "BEGIN:VCALENDAR\n"; +echo "PRODID:-//Engelsystem//DE-EN\n"; +echo "VERSION:2.0\n"; +echo "PRODID:" . md5('icalschichtplan:' . $_SESSION['UID']) . "\n"; +echo "METHOD:PUBLISH\n"; +echo "CALSCALE:GREGORIAN\n"; +echo "METHOD:PUBLISH\n"; +echo "X-WR-CALNAME;VALUE=TEXT:" . "Himmel - Schichtplan\n"; + +for ($i = 0; $i < mysql_num_rows($erg); $i++) { + echo "BEGIN:VEVENT\n"; + echo "UID:" . md5(mysql_result($erg, $i, "Man") . mysql_result($erg, $i, "DateS")) . "\n"; + echo "METHOD:PUBLISH\n"; + echo "DTSTART;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateS"))) . "\n"; + echo "DTEND;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateE"))) . "\n"; + echo "SUMMARY:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; + echo "CLASS:PUBLIC\n"; + echo "STATUS:CONFIRMED\n"; + echo "URL:" . $url . $ENGEL_ROOT . "nonpublic/myschichtplan.php\n"; + echo "LOCATION:" . $RoomID[mysql_result($erg, $i, "RID")] . "\n"; + echo "BEGIN:VALARM\n"; + echo "TRIGGER;VALUE=DURATION:-PT5M\n"; + echo "DESCRIPTION:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; + echo "ACTION:DISPLAY\n"; + echo "END:VALARM\n"; + echo "END:VEVENT\n"; +} +echo "END:VCALENDAR\n"; + +include ("includes/funktion_counter.php"); +?> + diff --git a/www-ssl_old/nonpublic/schichtplan.1.php b/www-ssl_old/nonpublic/schichtplan.1.php new file mode 100644 index 00000000..9c99c6ca --- /dev/null +++ b/www-ssl_old/nonpublic/schichtplan.1.php @@ -0,0 +1,20 @@ +<h4> Tage </h4> + +<?PHP +require_once ('../bootstrap.php'); + +include ("includes/funktion_schichtplan_aray.php"); + +function Printlink($Datum) { + GLOBAL $raum; + echo "\t<li><a href='./schichtplan.php?ausdatum=$Datum"; + // ist ein raum gesetzt? + if (IsSet ($raum)) + echo "&raum=$raum"; + echo "'>$Datum</a></li>\n"; +} //function Printlink( + +if (isset ($VeranstaltungsTage)) + foreach ($VeranstaltungsTage as $k => $v) + Printlink($v); +?> diff --git a/www-ssl_old/nonpublic/schichtplan.2.php b/www-ssl_old/nonpublic/schichtplan.2.php new file mode 100644 index 00000000..92443e13 --- /dev/null +++ b/www-ssl_old/nonpublic/schichtplan.2.php @@ -0,0 +1,22 @@ +<h4> Raumübersicht</h4> +<?php +require_once ('../bootstrap.php'); + +include ("includes/funktion_schichtplan_aray.php"); + +if (isset ($Room)) + foreach ($Room as $RoomEntry) { + if (isset ($ausdatum)) + echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=" . $RoomEntry["RID"] . "'>" . + $RoomEntry["Name"] . "</a></li>\n"; + else + echo "\t<li><a href='./schichtplan.php?raum=" . $RoomEntry["RID"] . "'>" . + $RoomEntry["Name"] . "</a></li>\n"; + } +echo "<br />"; +if (isset ($ausdatum)) + echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>"; +else + echo "<li><a href='./schichtplan.php?raum=-1'>alle</a></li>"; +?> + diff --git a/www-ssl_old/nonpublic/schichtplan.php b/www-ssl_old/nonpublic/schichtplan.php new file mode 100644 index 00000000..2b9038a3 --- /dev/null +++ b/www-ssl_old/nonpublic/schichtplan.php @@ -0,0 +1,220 @@ +<?php +require_once ('../bootstrap.php'); + +$title = "Himmel"; +$header = "Schichtpläne"; +$submenus = 2; + +if (isset ($_GET["ausdatum"])) + $ausdatum = $_GET["ausdatum"]; +if (isset ($_GET["raum"])) { + $raum = $_GET["raum"]; + + if ($raum == -1 && isset ($_GET["show"])) { + $raum = ""; + foreach ($_GET as $k => $v) { + if (substr($k, 0, 5) == "raum_") { + $raum = $raum . ";" . $v; + } + } + } +} + +<<<<<<< HEAD +include ("../../includes/header.php"); +include ("../../includes/funktionen.php"); +include ("../../includes/funktion_schichtplan.php"); +include ("../../includes/funktion_schichtplan_array.php"); +?> +======= +include ("includes/header.php"); +include ("includes/funktionen.php"); +include ("includes/funktion_schichtplan.php"); +include ("includes/funktion_schichtplan_aray.php"); +>>>>>>> spezial_includes_camp + +echo Get_Text("Hello") . $_SESSION['Nick'] . ",<br />" . +Get_Text("pub_schicht_beschreibung") . "<br /><br />"; + +function ShowSwitchDay() { + global $VeranstaltungsTage, $VeranstaltungsTageMax, $ausdatum, $raum; + + echo "\n\n<table border=\"0\" width=\"100%\"><tr>\n"; + + if (isset ($VeranstaltungsTage)) + foreach ($VeranstaltungsTage as $k => $v) + if ($ausdatum == $v) { + if ($k > 0) + echo "\t\t\t<td align=\"left\">" . + "<a href='./schichtplan.php?ausdatum=" . $VeranstaltungsTage[$k -1] . + "&raum=$raum'>" . $VeranstaltungsTage[$k -1] . "</a></td>\n"; + if ($k < $VeranstaltungsTageMax) + echo "\t\t\t<td align=\"right\">" . + "<a href='./schichtplan.php?ausdatum=" . $VeranstaltungsTage[$k +1] . + "&raum=$raum'>" . $VeranstaltungsTage[$k +1] . "</a></td>\n"; + } + echo "\n\n</table>"; +} + +// wenn kein Datum gesetzt ist (die Seite zum ersten mal aufgerufen wird), +// das Datum auf den ersten Tag setzen... +if (!isset ($ausdatum)) { + $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '" . gmdate("Y-m-d", time() + $gmdateOffset) . "%' ORDER BY `DateS`"; + // $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '2004-12-29%' ORDER BY `DateS`"; + $Erg = mysql_query($sql, $con); + if (mysql_num_rows($Erg) == 0) { + $sql = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` ASC LIMIT 0, 1"; + $Erg = mysql_query($sql, $con); + } + if (mysql_num_rows($Erg) > 0) + $ausdatum = substr(mysql_result($Erg, 0, "DateS"), 0, 10); + else + $ausdatum = gmdate("Y-m-d", time() + $gmdateOffset); + +} + +if (!isset ($raum)) { + // Ausgabe wenn kein Raum Ausgew�hlt: + echo Get_Text("pub_schicht_auswahl_raeume") . "<br /><br />\n"; + +<<<<<<< HEAD + +if ( !isset($raum) ) +{ + // Ausgabe wenn kein Raum Ausgew�hlt: + echo Get_Text("pub_schicht_auswahl_raeume"). "<br><br>\n"; + + if( isset($Room)) + { +======= + if (isset ($Room)) { +>>>>>>> spezial_includes_camp + echo "<form action=\"./schichtplan.php\" method=\"GET\">\n"; + foreach ($Room as $RoomEntry) { + echo "\t<li><input type=\"checkbox\" name=\"raum_" . $RoomEntry["RID"] . "\" value=\"" . $RoomEntry["RID"] . " \">"; + echo "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=" . $RoomEntry["RID"] . "'>" . $RoomEntry["Name"] . "</a>"; + echo "</input></li>\n"; + } + echo "<input type=\"hidden\" name=\"ausdatum\" value=\"$ausdatum\">"; + echo "<input type=\"hidden\" name=\"raum\" value=\"-1\">"; + echo "<input type=\"submit\" name=\"show\" value=\"show\">\n"; + echo "</form>\n"; + } + + echo "<br /><br />"; + echo Get_Text("pub_schicht_alles_1") . "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'> <u>" . + Get_Text("pub_schicht_alles_2") . "</u> </a>" . Get_Text("pub_schicht_alles_3"); + echo "\n<br /><br />\n\n"; + echo "<hr>\n\n"; + echo Get_Text("pub_schicht_EmptyShifts") . "\n"; + + // zeit die naesten freien schichten +<<<<<<< HEAD + showEmptyShifts(); +} +else +{ // Wenn einraum Ausgew�hlt ist: + if( $raum == -1 ) + echo Get_Text("pub_schicht_Anzeige_1").$ausdatum.":<br><br>"; + elseif( substr( $raum, 0, 1) == ";" ) + echo Get_Text("pub_schicht_Anzeige_1").$ausdatum.":<br><br>"; + else + echo Get_Text("pub_schicht_Anzeige_1"). $ausdatum. + Get_Text("pub_schicht_Anzeige_2"). $RoomID[$raum]. "<br><br>"; +======= + showEmptyShifts(); +} else { // Wenn einraum Ausgew�hlt ist: + if ($raum == -1) + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":<br /><br />"; + elseif (substr($raum, 0, 1) == ";") echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":<br /><br />"; + else + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . + Get_Text("pub_schicht_Anzeige_2") . $RoomID[$raum] . "<br /><br />"; +>>>>>>> spezial_includes_camp + + ShowSwitchDay(); + + echo "\n\n<table border=\"0\" width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; + echo "\t<tr class=\"contenttopic\">\n"; + echo "\t\t<td>start</td>\n"; + + //Ausgabe Spalten �berschrift +<<<<<<< HEAD + if( $raum == -1 ) + { + if( isset($Room)) + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t<th>". $RoomEntry["Name"]. "</th>\n"; +======= + if ($raum == -1) { + if (isset ($Room)) + foreach ($Room as $RoomEntry) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t<th>" . $RoomEntry["Name"] . "</th>\n"; +>>>>>>> spezial_includes_camp + } + elseif (substr($raum, 0, 1) == ";") { + $words = preg_split("/;/", $raum); + foreach ($words as $word) { + if (strlen(trim($word)) > 0) + echo "\t\t<th>" . $RoomID[trim($word)] . "</th>\n"; + } + } else + echo "\t\t<th>" . $RoomID[$raum] . "</th>\n"; + echo "\t</tr>\n"; + + //Zeit Ausgeben + for ($i = 0; $i < 24; $i++) + for ($j = 0; $j < $GlobalZeileProStunde; $j++) { + $Spalten[$i * $GlobalZeileProStunde + $j] = "\t<tr class=\"content\">\n\t\t"; + + //Stunde: + $SpaltenTemp = ""; + $SpaltenTemp .= ($i < 10) ? "0$i:" : "$i:"; + + //Minute + $TempMinuten = (($j * 60) / $GlobalZeileProStunde); + $SpaltenTemp .= ($TempMinuten < 10) ? "0$TempMinuten" : "$TempMinuten"; + + //aktuelle stunde markieren + if (($j == 0) && ($i == gmdate("H", time() + $gmdateOffset)) && (gmdate("Y-m-d", time() + $gmdateOffset) == $ausdatum)) + $SpaltenTemp = "<h1>$SpaltenTemp</h1>"; + + $SpaltenTemp = "<td>$SpaltenTemp</td>\n"; + $Spalten[$i * $GlobalZeileProStunde + $j] .= $SpaltenTemp; + } + + if ($raum == -1) { + if (isset ($Room)) + foreach ($Room as $RoomEntry) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + CreateRoomShifts($RoomEntry["RID"]); + } + elseif (substr($raum, 0, 1) == ";") { + if (isset ($Room)) { + $words = preg_split("/;/", $raum); + foreach ($words as $word) { + if (strlen(trim($word)) > 0) + if (SummRoomShifts($word) > 0) + CreateRoomShifts($word); + } + } + } else + CreateRoomShifts($raum); + + //Ausageb Zeilen + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) { + echo $Spalten[$i] . "\t</tr>\n"; + } + + echo "</table>\n"; + + ShowSwitchDay(); + +} //if (isset($raum)) + +echo "<a href=\"" . $_SESSION["newurl"] . "&Icon=0\">@</a>"; + +include ("includes/footer.php"); +?> diff --git a/www-ssl_old/nonpublic/schichtplan_add.php b/www-ssl_old/nonpublic/schichtplan_add.php new file mode 100644 index 00000000..1bbcdc4b --- /dev/null +++ b/www-ssl_old/nonpublic/schichtplan_add.php @@ -0,0 +1,114 @@ +<?php +require_once ('../bootstrap.php'); + +$title = "Himmel"; +$header = "Schichtpläne"; +include "includes/header.php"; +include "includes/funktion_schichtplan.php"; +include "includes/funktion_schichtplan_aray.php"; +include "includes/funktionen.php"; + +if (isset ($_POST["newtext"]) && isset ($_POST["SID"]) && isset ($_POST["TID"])) { + SetHeaderGo2Back(); + + // datum der einzutragenden Schicht heraussuhen... + $ShiftSQL = "SELECT `DateS`, `DateE` FROM `Shifts` WHERE `SID`='" . $_POST["SID"] . ".'"; + $ShiftErg = mysql_query($ShiftSQL, $con); + $beginSchicht = mysql_result($ShiftErg, 0, "DateS"); + $endSchicht = mysql_result($ShiftErg, 0, "DateE"); + + // wenn keien rechte definiert sind + if (!isset ($_SESSION['CVS'][$TID2Name[$_POST["TID"]]])) + $_SESSION['CVS'][$TID2Name[$_POST["TID"]]] = "Y"; + + if ($_SESSION['CVS'][$TID2Name[$_POST["TID"]]] == "Y") { + // Ueberpruefung, ob der Engel bereits fuer eine Schicht zu dieser Zeit eingetragen ist + $SSQL = "SELECT * FROM `Shifts`" . + " INNER JOIN `ShiftEntry` ON `ShiftEntry`.`SID` = `Shifts`.`SID`" . + " WHERE ((" . + " ((`Shifts`.`DateS` >= '$beginSchicht') and " . + " (`Shifts`.`DateS` < '$endSchicht'))" . + " OR " . + " ((`Shifts`.`DateE` > '$beginSchicht') and " . + " (`Shifts`.`DateE` <= '$endSchicht')) " . + ") and " . + "(`ShiftEntry`.`UID` = '" . $_SESSION['UID'] . "'));"; + $bErg = mysql_query($SSQL, $con); + + if (mysql_num_rows($bErg) != 0) + echo Get_Text("pub_schichtplan_add_AllreadyinShift"); + else { + // ermitteln der noch gesuchten + $SQL3 = "SELECT * FROM `ShiftEntry`" . + " WHERE ((`SID` = '" . $_POST["SID"] . "') AND (`TID` = '" . $_POST["TID"] . "') AND (`UID` = '0'));"; + $Erg3 = mysql_query($SQL3, $con); + + if (mysql_num_rows($Erg3) <= 0) + echo Get_Text("pub_schichtplan_add_ToManyYousers"); + else { + //write shift + $SQL = "UPDATE `ShiftEntry` SET " . + "`UID` = '" . $_SESSION['UID'] . "', " . + "`Comment` = '" . $_POST["newtext"] . "' " . + "WHERE ( (`SID` = '" . $_POST["SID"] . "') and " . + "(`TID` = '" . $_POST["TID"] . "') and " . + "(`UID` = '0')) LIMIT 1;"; + $Erg = mysql_query($SQL, $con); + + if ($Erg != 1) + echo Get_Text("pub_schichtplan_add_Error"); + else + echo Get_Text("pub_schichtplan_add_WriteOK"); + } + } + } else { + echo "<h1>:-(</h1>"; + array_push($error_messages, "Hack atteck\n"); + } +} +elseif (isset ($_GET["SID"]) && isset ($_GET["TID"])) { + //wenn keine Rechte definiert sind + if (!isset ($_SESSION['CVS'][$TID2Name[$_GET["TID"]]])) + $_SESSION['CVS'][$TID2Name[$_GET["TID"]]] = "Y"; + + if ($_SESSION['CVS'][$TID2Name[$_GET["TID"]]] == "Y") { + echo Get_Text("pub_schichtplan_add_Text1") . "<br /><br />\n\n" . + "<form action=\"./schichtplan_add.php\" method=\"post\">\n" . + "<table border=\"0\">\n"; + + $SQL = "SELECT * FROM `Shifts` WHERE "; + $SQL .= "(`SID` = '" . $_GET["SID"] . "')"; + $Erg = mysql_query($SQL, $con); + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Date") . ":</td> <td>" . + mysql_result($Erg, 0, "DateS") . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Place") . ":</td> <td>" . + $RoomID[mysql_result($Erg, 0, "RID")] . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Job") . ":</td> <td>" . + $EngelTypeID[$_GET["TID"]] . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Len") . ":</td> <td>" . + mysql_result($Erg, 0, "Len") . "h</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_TextFor") . ":</td> <td>" . + mysql_result($Erg, 0, "Man") . "</td></tr>\n"; + + echo "<tr><td valign='top'>" . Get_Text("pub_schichtplan_add_Comment") . ":</td>\n <td>" . + "<textarea name='newtext' cols='50' rows='10'></textarea> </td></tr>\n"; + + echo "<tr><td> </td>\n" . + "<td><input type=\"submit\" value=\"" . Get_Text("pub_schichtplan_add_submit") . "\"> </td></tr>\n" . + "</table>\n" . + "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n" . + "<input type=\"hidden\" name=\"TID\" value=\"" . $_GET["TID"] . "\">\n" . + "</form>"; + } else { + echo "<h1>:-(</h1>"; + array_push($error_messages, "Hack atteck\n"); + } +} + +include "includes/footer.php"; +?> diff --git a/www-ssl_old/nonpublic/schichtplan_beamer.php b/www-ssl_old/nonpublic/schichtplan_beamer.php new file mode 100644 index 00000000..269660e1 --- /dev/null +++ b/www-ssl_old/nonpublic/schichtplan_beamer.php @@ -0,0 +1,59 @@ +<?php +require_once ('../bootstrap.php'); + +include "includes/header_start.php"; +include "includes/funktionen.php"; +include "includes/funktion_schichtplan_beamer.php"; + +$Time = time() + 3600 + 3600; +?> + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> +<title>Schichtpläne für Beamer</title> +<meta http-equiv="refresh" content="30; URL=<?php echo $url . $_SERVER['PHP_SELF']; ?>" /> +</head> + +<body> + +<?php + + +echo "<table border=\"1\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\" frame=\"void\">\n"; + +echo "<colgroup span=\"4\" valign=\"center\"> + <col width=\"30\"> + <col width=\"3*\"> + <col width=\"3*\"> + <col width=\"3*\"> + </colgroup>\n"; + +echo "<tr align=\"center\">\n" . +"<td>" . gmdate("d.m.y", $Time) . "</td>\n" . +"<td>" . gmdate("H", $Time -3600) . ":00</td>\n" . +"<td>" . gmdate("H", $Time +0) . ":00</td>\n" . +"<td>" . gmdate("H", $Time +3600) . ":00</td>\n" . +"</tr>\n"; + +foreach ($Room as $RoomEntry) { + // var-init + $AnzahlEintraege = 0; + + $Out = ausgabe_Zeile($RoomEntry["RID"], $Time -3600, $AnzahlEintraege); + $Out .= ausgabe_Zeile($RoomEntry["RID"], $Time, $AnzahlEintraege); + $Out .= ausgabe_Zeile($RoomEntry["RID"], $Time +3600, $AnzahlEintraege); + + if ($AnzahlEintraege == 0) + $Out = ""; + else + $Out = "<tr>\n<td>_" . $RoomEntry["Name"] . "_</td>\n" . $Out . "</tr>\n"; + + echo $Out; +} +?> + +</table> + +</body> +</html> |