From 04973d1fa148381978b1251d10118e6bab86f435 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Mon, 13 Jun 2011 18:05:51 +0200 Subject: moved public files to public, old and yet untouched files to directories ending with _old --- www-ssl_old/ShowUserPicture.php | 56 +++++ www-ssl_old/admin/UserPicture.php | 132 ++++++++++ www-ssl_old/admin/aktiv.php | 105 ++++++++ www-ssl_old/admin/dbUpdateFromXLS.php | 252 +++++++++++++++++++ www-ssl_old/admin/dect.php | 69 +++++ www-ssl_old/admin/free.php | 98 ++++++++ www-ssl_old/admin/free_DECT.php | 65 +++++ www-ssl_old/admin/room.php | 199 +++++++++++++++ www-ssl_old/admin/schichtplan.1.php | 5 + www-ssl_old/admin/schichtplan.php | 362 +++++++++++++++++++++++++++ www-ssl_old/admin/schichtplan_druck.1.php | 5 + www-ssl_old/admin/schichtplan_druck.php | 119 +++++++++ www-ssl_old/admin/shiftadd.php | 350 ++++++++++++++++++++++++++ www-ssl_old/admin/tshirt.php | 62 +++++ www-ssl_old/admin/userArrived.php | 53 ++++ www-ssl_old/nonpublic/myschichtplan.php | 178 +++++++++++++ www-ssl_old/nonpublic/myschichtplan_ical.php | 51 ++++ www-ssl_old/nonpublic/schichtplan.1.php | 20 ++ www-ssl_old/nonpublic/schichtplan.2.php | 22 ++ www-ssl_old/nonpublic/schichtplan.php | 220 ++++++++++++++++ www-ssl_old/nonpublic/schichtplan_add.php | 114 +++++++++ www-ssl_old/nonpublic/schichtplan_beamer.php | 59 +++++ 22 files changed, 2596 insertions(+) create mode 100644 www-ssl_old/ShowUserPicture.php create mode 100644 www-ssl_old/admin/UserPicture.php create mode 100644 www-ssl_old/admin/aktiv.php create mode 100644 www-ssl_old/admin/dbUpdateFromXLS.php create mode 100644 www-ssl_old/admin/dect.php create mode 100644 www-ssl_old/admin/free.php create mode 100644 www-ssl_old/admin/free_DECT.php create mode 100755 www-ssl_old/admin/room.php create mode 100644 www-ssl_old/admin/schichtplan.1.php create mode 100644 www-ssl_old/admin/schichtplan.php create mode 100644 www-ssl_old/admin/schichtplan_druck.1.php create mode 100644 www-ssl_old/admin/schichtplan_druck.php create mode 100644 www-ssl_old/admin/shiftadd.php create mode 100644 www-ssl_old/admin/tshirt.php create mode 100644 www-ssl_old/admin/userArrived.php create mode 100644 www-ssl_old/nonpublic/myschichtplan.php create mode 100644 www-ssl_old/nonpublic/myschichtplan_ical.php create mode 100644 www-ssl_old/nonpublic/schichtplan.1.php create mode 100644 www-ssl_old/nonpublic/schichtplan.2.php create mode 100644 www-ssl_old/nonpublic/schichtplan.php create mode 100644 www-ssl_old/nonpublic/schichtplan_add.php create mode 100644 www-ssl_old/nonpublic/schichtplan_beamer.php (limited to 'www-ssl_old') diff --git a/www-ssl_old/ShowUserPicture.php b/www-ssl_old/ShowUserPicture.php new file mode 100644 index 00000000..5a222c07 --- /dev/null +++ b/www-ssl_old/ShowUserPicture.php @@ -0,0 +1,56 @@ + diff --git a/www-ssl_old/admin/UserPicture.php b/www-ssl_old/admin/UserPicture.php new file mode 100644 index 00000000..25f8b54b --- /dev/null +++ b/www-ssl_old/admin/UserPicture.php @@ -0,0 +1,132 @@ +\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t(max " . get_cfg_var("post_max_size") . "Byte)
\n"; + echo "\t\n"; + echo "\n"; + break; + case 'sendPicture' : + if (($_FILES["file"]["size"] > 0) && (isset ($_POST["UID"]))) { + if (($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/png") || ($_FILES["file"]["type"] == "image/gif")) { + $data = addslashes(fread(fopen($_FILES["file"]["tmp_name"], "r"), filesize($_FILES["file"]["tmp_name"]))); + + if (GetPicturShow($_POST['UID']) == "") + $SQL = "INSERT INTO `UserPicture` " . + "( `UID`,`Bild`, `ContentType`, `show`) " . + "VALUES ('" . $_POST['UID'] . "', '$data', '" . $_FILES["file"]["type"] . "', 'N')"; + else + $SQL = "UPDATE `UserPicture` SET " . + "`Bild`='$data', " . + "`ContentType`='" . $_FILES["file"]["type"] . "' " . + "WHERE `UID`='" . $_POST['UID'] . "'"; + + echo "Upload Pictur:'" . $_FILES["file"]["name"] . "', " . + "MIME-Type: " . $_FILES["file"]["type"] . ", " . + $_FILES["file"]["size"] . " Byte " . + "for " . UID2Nick($_POST["UID"]); + } else + Print_Text("pub_einstellungen_send_KO"); + } else + Print_Text("pub_einstellungen_send_KO"); + break; + + case 'SetN' : + if (IsSet ($_GET["UID"])) { + echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gesperrt:
"; + $SQL = "UPDATE `UserPicture` SET `show`='N' WHERE `UID`='" . $_GET["UID"] . "'"; + } else + echo "Fehlerhafter Aufruf"; + break; + case 'SetY' : + if (IsSet ($_GET["UID"])) { + echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde Freigegeben:
"; + $SQL = "UPDATE `UserPicture` SET `show`='Y' WHERE `UID`='" . $_GET["UID"] . "'"; + } else + echo "Fehlerhafter Aufruf"; + break; + case 'del' : + echo "Wollen Sie das Bild von '" . UID2Nick($_GET["UID"]) . "' wirklich löschen? " . + "Yes"; + break; + case 'delYes' : + if (IsSet ($_GET["UID"])) { + echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gelöscht:
"; + $SQL = "DELETE FROM `UserPicture` WHERE `UID`='" . $_GET["UID"] . "' LIMIT 1"; + } else + echo "Fehlerhafter Aufruf"; + break; + default : + echo "Fehlerhafter Aufruf"; + + } //switch + + // Update ??? + if (IsSet ($SQL)) { + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($SQL, $con); + if ($Erg == 1) + echo "Änderung wurde gesichert...
"; + else { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

" . mysql_error($con) . "
($SQL)
"; + } + } // Ende Update + echo "
\n
\n
\n\n"; +} //IF IsSet($action) + +//ausgabe der Liste +$Sql = "SELECT * FROM `UserPicture` WHERE `UID`>0;"; +$Erg = mysql_query($Sql, $con); + +echo "Hallo " . $_SESSION['Nick'] . ",
\nhier hast du die Möglichkeit, die Bilder der Engel freizugeben:

\n"; + +echo "\n"; +echo "\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo ""; + +for ($t = 0; $t < mysql_num_rows($Erg); $t++) { + $UIDs = mysql_result($Erg, $t, "UID"); + echo "\t\n"; + + echo "\t\t\n"; + echo "\t\t\n"; + + if (GetPicturShow($UIDs) == "Y") + echo "\t\t\n"; + elseif (GetPicturShow($UIDs) == "N") echo "\t\t\n"; + else + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; +} // ende Auflistung Raeume +echo "
UserBildStatusLöschen
" . UID2Nick(mysql_result($Erg, $t, "UID")) . "" . displayPictur($UIDs, 0) . "sperrenfreigebenERROR: show='" . GetPicturShow($UIDs) . "'del
"; + +echo "
picture upload\n"; + +include ("includes/footer.php"); +?> diff --git a/www-ssl_old/admin/aktiv.php b/www-ssl_old/admin/aktiv.php new file mode 100644 index 00000000..8db62f98 --- /dev/null +++ b/www-ssl_old/admin/aktiv.php @@ -0,0 +1,105 @@ +"; +echo Get_Text("pub_aktive_Text1") . "
\n"; +echo Get_Text("pub_aktive_Text2") . "

\n"; + +// auswahlbox +echo Get_Text("pub_aktive_Text31") . "\n"; +echo ""; +echo Get_Text("pub_aktive_Text32") . "

\n"; +echo "\n"; +echo "\n"; +echo "\n"; + +echo "
\n"; +echo "\t
\n"; +echo "
\n"; + +if (Isset ($_POST["ResetActive"])) { + $SQLreset = "UPDATE `User` SET `Aktiv`='0'"; + $ErgReset = db_query($SQLreset, "Reset Active"); + if ($ErgReset != 1) + echo "Fehler beim zuruecksetzen der Activ\n"; + else + echo "Active wurde erfolgreich zurueckgesetzt\n"; +} + +if (IsSet ($_POST["Anzahl"])) + echo "
\n\n" . Get_Text("pub_aktive_Text5_1") . $_POST["Anzahl"] . Get_Text("pub_aktive_Text5_2") . ":"; + +echo "

\n\n"; + +//ausgabe tabelle +echo "\n"; +echo "\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\t\n"; +echo "\n"; + +$SQL = " +SELECT d.UID, d.nr, d.len, d.lenWeight, f.nr AS nrFree, f.len AS lenFree, d.lenWeight - COALESCE(f.len, 0) as lenReal + FROM + (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d + LEFT JOIN + (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f + USING(UID) + ORDER BY lenReal DESC, nr DESC, UID"; + +$Erg = mysql_query($SQL, $con); +echo mysql_error($con); +$rowcount = mysql_num_rows($Erg); + +$aktivecount = 0; +for ($i = 0; $i < $rowcount; $i++) { + echo "\n\n\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + + echo "\t\t\n"; + echo "\t\n"; +} // ende Auflistung aktive Engel + +echo "
" . Get_Text("pub_aktive_Nick") . "" . Get_Text("pub_aktive_Anzahl") . "" . Get_Text("pub_aktive_Time") . "" . Get_Text("pub_aktive_Time") . " WeightFreeloader " . Get_Text("pub_aktive_Anzahl") . "Freeloader " . Get_Text("pub_aktive_Time") . "" . Get_Text("pub_aktive_Time") . " result" . Get_Text("pub_aktive_Active") . "
" . UID2Nick(mysql_result($Erg, $i, "UID")) . "" . mysql_result($Erg, $i, "nr") . "x" . mysql_result($Erg, $i, "len") . "h" . mysql_result($Erg, $i, "lenWeight") . "h" . mysql_result($Erg, $i, "nrFree") . "x" . mysql_result($Erg, $i, "lenFree") . "h" . mysql_result($Erg, $i, "lenReal") . "h"; + if (IsSet ($_POST["Anzahl"])) { + if ($_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal")) { + $aktivecount++; + if ($_POST["SendType"] == "Show..") + echo "show set"; + else { + $SQL2 = "UPDATE `User` SET `Aktiv`='1' WHERE `UID`='" . mysql_result($Erg, $i, "UID") . "' LIMIT 1"; + $Erg2 = db_query($SQL2, "update Active State"); + if ($Erg2 != 1) + echo "Fehler beim speichern bei Engel " . UID2Nick(mysql_result($Erg, $i, "UID")); + else + echo "write set"; + } + } + } + echo "
"; + +echo "
Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)

"; + +include ("includes/footer.php"); +?> + diff --git a/www-ssl_old/admin/dbUpdateFromXLS.php b/www-ssl_old/admin/dbUpdateFromXLS.php new file mode 100644 index 00000000..88879de7 --- /dev/null +++ b/www-ssl_old/admin/dbUpdateFromXLS.php @@ -0,0 +1,252 @@ +\n

XML File:

\n"; +if (isset ($_POST["PentabarfUser"]) && isset ($_POST["password"]) && isset ($_POST["PentabarfURL"])) { + echo "Update XCAL-File from Pentabarf.."; + if ($PentabarfGetWith == "fsockopen") { + + //backup error messeges and delate + $Backuperror_messages = $error_messages; + $fp = fsockopen("ssl://$PentabarfXMLhost", 443, $errno, $errstr, 30); + // $error_messages = $Backuperror_messages; + + if (!$fp) { + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!" . + "[$errstr ($errno)]

"; + } else { + if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { + $head = 'GET /' . $PentabarfXMLpath . $_POST["PentabarfURL"] . ' HTTP/1.1' . "\r\n" . + 'Host: ' . $PentabarfXMLhost . "\r\n" . + 'User-Agent: Engelsystem' . "\r\n" . + 'Authorization: Basic ' . + base64_encode($_POST["PentabarfUser"] . ':' . $_POST["password"]) . "\r\n" . + "\r\n"; + fputs($fp, $head); + $Zeilen = -1; + while (!feof($fp)) { + $Temp = fgets($fp, 1024); + + // ende des headers + if ($Temp == "f20\r\n") { + $Zeilen = 0; + $Temp = ""; + } + + //file ende? + if ($Temp == "0\r\n") + break; + + if (($Zeilen > -1) && ($Temp != "ffb\r\n")) { + //steuerzeichen ausfiltern + if (strpos("#$Temp", "\r\n") > 0) + $Temp = substr($Temp, 0, strlen($Temp) - 2); + if (strpos("#$Temp", "1005") > 0) + $Temp = ""; + if (strpos("#$Temp", "783") > 0) + $Temp = ""; + //schreiben in file + fputs($fileOut, $Temp); + $Zeilen++; + } + } + fclose($fileOut); + + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose($fp); + } + } + elseif ($PentabarfGetWith == "fopen") { + //user uns password in url einbauen + $FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" . + $PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"]; + + if (($fileIn = fopen($FileNameIn, "r")) != FALSE) { + if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { + $Zeilen = 0; + while (!feof($fileIn)) { + $Zeilen++; + fputs($fileOut, fgets($fileIn)); + } + fclose($fileOut); + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose($fileIn); + } else + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!

"; + } + elseif ($PentabarfGetWith == "wget") { + $Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " . + "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . + " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" . + " --no-check-certificate"; + echo system($Command, $Status); + if ($Status == 0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif ($PentabarfGetWith == "lynx") { + $Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " . + "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML"; + echo system($Command, $Status); + if ($Status == 0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif ($PentabarfGetWith == "fopen") { + //user uns password in url einbauen + $FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" . + $PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"]; + + if (($fileIn = fopen($FileNameIn, "r")) != FALSE) { + if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { + $Zeilen = 0; + while (!feof($fileIn)) { + $Zeilen++; + fputs($fileOut, fgets($fileIn)); + } + fclose($fileOut); + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose($fileIn); + } else + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!

"; + } + elseif ($PentabarfGetWith == "wget") { + $Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " . + "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . + " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" . + " --no-check-certificate"; + echo system($Command, $Status); + if ($Status == 0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif ($PentabarfGetWith == "lynx") { + $Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " . + "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML"; + echo system($Command, $Status); + if ($Status == 0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } else + echo "

The PentabarfGetWith='$PentabarfGetWith' not supported

"; +} else { + echo "
\n"; + echo "\n"; + echo "\t" . + "\n"; + echo "\t" . + "\n"; + echo "\t" . + "\n"; + echo "\t\n"; + echo "
XCAL-File: https://$PentabarfXMLhost/$PentabarfXMLpath
Username:
Password:
\n"; + echo "
\n"; +} + +//readXMLfile("xml.php.xml"); +if (readXMLfile("$Tempdir/engelXML") == 0) { + $XMLmain = getXMLsubPease($XMLmain, "VCALENDAR"); + + if ($ShowDataStrukture) { + echo "

";
+		echo $XMLmain->name;
+		echo "
";
+		print_r(array_values($XMLmain->sub));
+		echo "
"; + } + + /* + echo "
"; + $Feld=7; + echo "$Feld#". $XMLmain->sub[$Feld]->name. "
"; + echo "$Feld#". $XMLmain->sub[$Feld]->sub; + //print_r(array_values ($XMLmain->sub[$Feld]->sub)); + while(list($key, $value) = each($XMLmain->sub[$Feld]->sub)) + echo "?ID".$value->sub[1]->data. "=". $value->sub[2]->data. "\n"; + echo ""; + */ + + /*############################################################################################## + V e r s i o n + ##############################################################################################*/ + + echo "
\n"; + $XMLrelease = getXMLsubPease($XMLmain, "X-WR-CALDESC"); + echo "release: " . $XMLrelease->data . "
\n"; + //$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE"); + //echo "release date: ". $XMLreleaseDate->data. "
\n"; + echo "
\n"; + + /*############################################################################################## + V e r s i o n + ##############################################################################################*/ + if ($EnableRoomFunctions) + include ("includes/funktion_xml_room.php"); + + if ($EnableSchudleFunctions) + include ("includes/funktion_xml_schudle.php"); + + /*############################################################################################## + U P D A T E A L L + ##############################################################################################*/ + echo "\n\n
\n

Update ALL:

\n"; + + echo "
\n"; + echo "\t\n"; + echo "
\n"; + +} //if XMLopenOOK + +include ("includes/footer.php"); +?> + diff --git a/www-ssl_old/admin/dect.php b/www-ssl_old/admin/dect.php new file mode 100644 index 00000000..4e9f472a --- /dev/null +++ b/www-ssl_old/admin/dect.php @@ -0,0 +1,69 @@ +\n"; +echo "\n"; + +echo "\n"; + +echo "\n"; + +echo "\n"; +echo "\n"; +echo ""; +echo "
Numberh:m
\n"; +// Listet alle Nicks auf +echo "\n"; + +echo "\n"; +echo ":"; +echo "
\n"; + +echo ""; + +include ("includes/footer.php"); +?> + diff --git a/www-ssl_old/admin/free.php b/www-ssl_old/admin/free.php new file mode 100644 index 00000000..b45fadcf --- /dev/null +++ b/www-ssl_old/admin/free.php @@ -0,0 +1,98 @@ +\n"; + +echo "

\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:

\n"; + +####################################################### +# Ermitteln freier Engel +# +# auslesen aller Engel und dazugehoerige Schichten +####################################################### + +// $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtplan ON User.UID=Schichtbelegung.UID, Schichtplan.SID LEFT JOIN Schichtbelegung.SID WHERE User.UID = Schichtbelegung.UID AND Schichtplan.SID = Schichtbelegung.SID AND Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick"; + +/* geht nicht ??? unter stabel !! +$SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung.* ". + "FROM Schichtplan, User LEFT OUTER ". + "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". + "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". + "Schichtplan.Date < now() and ". + "Schichtplan.EndDate > now() ". + "ORDER BY Nick"; + +$SQL = "SELECT Shifts.*, ShiftEntry.*, User.Nick ". + "FROM User ". + "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; +*/ +$SQL = "SELECT Shifts.*, ShiftEntry.* " . +"FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID " . +"WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; + +//SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID, Schichtplan LEFT JOIN Schichtbelegung ON Schichtplan.SID = Schichtbelegung.SID WHERE Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick + +//echo "
$SQL
"; + +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); + +// for ($i = 1; $i < mysql_num_fields($Erg); $i++) +// echo "|".mysql_field_name($Erg, $i); + +echo "\n"; +echo "\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\n"; + +$inuse = ""; +for ($i = 0; $i < $Zeilen; $i++) { + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + + if ($inuse != "") + $inuse .= " OR "; + $inuse .= "(Nick = \"" . UID2Nick(mysql_result($Erg, $i, "UID")) . "\")"; +} +if ($inuse != "") + $inuse = " WHERE NOT (" . + $inuse . ")"; +echo "
NickSchichtOrtVonBis
" . + UID2Nick(mysql_result($Erg, $i, "UID")) . "" . mysql_result($Erg, $i, "RID") . "" . mysql_result($Erg, $i, "DateS") . "" . mysql_result($Erg, $i, "DateE") . "
\n"; + +//########################################################################################################## + +echo "

\n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:

\n"; +echo "\n"; +echo "\t\n\t\t\n\t\t\n\t\n"; + +$SQL = "SELECT Nick, UID, DECT FROM User" . $inuse . ";"; +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); +for ($i = 0; $i < $Zeilen; $i++) { + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\n\n"; +} +echo "
NickDECT
" . + mysql_result($Erg, $i, "Nick") . "" . mysql_result($Erg, $i, "DECT") . "
\n"; + +include ("includes/footer.php"); +?> + diff --git a/www-ssl_old/admin/free_DECT.php b/www-ssl_old/admin/free_DECT.php new file mode 100644 index 00000000..4b4e3085 --- /dev/null +++ b/www-ssl_old/admin/free_DECT.php @@ -0,0 +1,65 @@ +=Now() AND ShiftEntry.UID>0);"; + +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); + +$inuse = ""; +for ($i = 0; $i < $Zeilen; $i++) { + if ($inuse != "") + $inuse .= " OR "; + $inuse .= "(UID = \"" . mysql_result($Erg, $i, "UID") . "\")"; +} +if ($inuse != "") { + $inuse = " WHERE (NOT (" . $inuse . ")) AND (DECT!='')"; +} else { + $inuse = " WHERE (DECT!='')"; +} + +//########################################################################################################## + +$SQL = "SELECT * FROM User" . $inuse . ";"; +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); +for ($i = 0; $i < $Zeilen; $i++) { + // get DECT number + echo mysql_result($Erg, $i, "DECT") . "\t"; + + // get all user rights + $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=" . mysql_result($Erg, $i, "UID") . ";"; + $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); + $UserRights = mysql_fetch_array($Erg_RIGHT); + + foreach ($UserRights as $Var => $Value) { + if ((strpos($Var, ".php") === false) AND (strpos($Var, "/") === false) AND (strpos($Var, "UID") === false) AND (is_numeric($Var) === false)) { + echo "\"" . $Var . "\"=" . $Value . "\t"; + } + } + + // get shift types + $SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=" . mysql_result($Erg, $i, "UID") . " GROUP BY TID;"; + $Erg_TYPES = mysql_query($SQL_TYPES, $con); + $Zeilen_Typen = mysql_num_rows($Erg_TYPES); + for ($j = 0; $j < $Zeilen_Typen; $j++) { + echo "\"TID_" . TID2Type(mysql_result($Erg_TYPES, $j, "TID")) . "\"=Y\t"; + } + + echo "\n"; + // echo "
"; +} +?> + diff --git a/www-ssl_old/admin/room.php b/www-ssl_old/admin/room.php new file mode 100755 index 00000000..4854acb6 --- /dev/null +++ b/www-ssl_old/admin/room.php @@ -0,0 +1,199 @@ +\nhier hast du die Möglichkeit, neue Räume für die Schichtpläne einzutragen ". + "oder vorhandene abzuändern:

\n"; + + echo "- Neuen Raum/Ort eintragen
\n"; + + echo "\n"; + echo "\n"; + + for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) + { + if( substr( mysql_field_name($Erg, $i), 0, 12) == "DEFAULT_EID_") + echo "\t"; + else + echo "\t"; + } + echo "\t"; + echo ""; + + for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) + { + echo "\t\n"; + for ($j = 1; $j < mysql_num_fields($Erg); $j++) + { + echo "\t\t\n"; + } + echo "\t\t\n"; + echo "\t\n"; + } // ende Auflistung Raeume + echo "
Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $i), 12)]. "". mysql_field_name($Erg, $i)."Ändern
".mysql_result($Erg, $t, $j)."###
"; +} +else +{ + +UnSet($SQL); + +switch ($_GET["action"]) { + +case 'new': + echo "Neuen Raum einrichten:
"; + echo "
\n"; + echo "\n"; + + for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) + { + if( (mysql_field_name($Erg, $Uj) == "show") || (mysql_field_name($Erg, $Uj) == "FromPentabarf") ) + { + echo "". + "\n"; + } + else + { + //sonderfall fuer Default Engel + if( substr( mysql_field_name($Erg, $Uj), 0, 12) == "DEFAULT_EID_") + $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $Uj), 12)]; + else + $FeldName = mysql_field_name($Erg, $Uj); + + echo "". + "\n"; + } + } + echo "
". mysql_field_name($Erg, $Uj). "". + "Yes". + "No". + "
$FeldName"; + echo "
\n"; + echo "\n"; + echo "\n"; + echo "
"; + break; + +case 'newsave': + $vars = $_GET; + $count = count($vars) - 1; + $vars = array_splice($vars, 0, $count); + $Keys = ""; + $Values = ""; + foreach($vars as $key => $value) + { + $Keys .= ", `$key`"; + $Values .= ", '$value'"; + } + $SQL = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")"; + SetHeaderGo2Back(); + break; + +case 'change': + if (! IsSet($_GET["RID"])) + echo "Fehlerhafter Aufruf!"; + else + { + $SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; + $ERG = mysql_query($SQL2, $con); + + if( mysql_num_rows( $ERG)>0) + { + echo "Raum abändern:\n"; + echo "Hier kannst du eintragen, welche und wieviele Engel für den Raum zur Verf?gung stehen müssen."; + echo "
\n"; + echo "\n"; + + for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) + { + if( (mysql_field_name($ERG, $Uj) == "show") || (mysql_field_name($ERG, $Uj) == "FromPentabarf") ) + { + echo "". + "\n"; + } + else + { + if( substr( mysql_field_name($ERG, $Uj), 0, 12) == "DEFAULT_EID_") + //sonderfall fuer Default Engel + $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($ERG, $Uj), 12)]; + else + $FeldName = mysql_field_name($ERG, $Uj); + echo "". + "\n"; + } + } + echo "
". mysql_field_name($Erg, $Uj). "". + "Yes". + "No". + "
$FeldName". + "
\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
"; + echo "
\n"; + echo "\n"; + echo "\n"; + echo ""; + echo "
"; + } + else + echo "FEHLER: Room ID ". $_GET["RID"]. " nicht gefunden"; + } + break; + +case 'changesave': + $sql=""; + $vars = $_GET; + $count = count($vars) - 2; + $vars = array_splice($vars, 0, $count); + foreach($vars as $key => $value) + { + $keys = substr($key,1); + $sql .= ", `".$keys."`='".$value."' "; + } + $SQL = "UPDATE `Room` SET ". substr($sql, 2). " WHERE `RID`='". $_GET["eRID"]. "'"; + SetHeaderGo2Back(); + break; + +case 'delete': + if (IsSet($_GET["RID"])) { + $SQL="DELETE FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; + } else { + echo "Fehlerhafter Aufruf"; + } + SetHeaderGo2Back(); + break; + +} //switch + + +// Update ??? + +if (IsSet($SQL)){ +// echo $SQL; + // hier muesste das SQL ausgefuehrt werden... + $Erg = db_query($SQL, "exec SQL"); + if ($Erg == 1) + echo "Änderung wurde gesichert...
"; + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

".mysql_error( $con ). "
($SQL)
"; + } +} // Ende Update + +} //IF IsSet($action) + +include ("../../includes/footer.php"); +?> diff --git a/www-ssl_old/admin/schichtplan.1.php b/www-ssl_old/admin/schichtplan.1.php new file mode 100644 index 00000000..fe8c0384 --- /dev/null +++ b/www-ssl_old/admin/schichtplan.1.php @@ -0,0 +1,5 @@ +

Schichtplan

+ \ No newline at end of file diff --git a/www-ssl_old/admin/schichtplan.php b/www-ssl_old/admin/schichtplan.php new file mode 100644 index 00000000..70ef5a6a --- /dev/null +++ b/www-ssl_old/admin/schichtplan.php @@ -0,0 +1,362 @@ +\n"; + if ($Erg == 1) { + echo "SQL war erfolgreich"; + } else { + echo "SQL Fehler (" . mysql_error($con) . ")"; + } +} + +if (!IsSet ($_GET["action"])) { + echo "Hallo " . $_SESSION['Nick'] . ",
\n"; + echo "hier kannst du Schichten anlegen, ändern oder löschen.

"; + echo "Neue Schicht einplanen

\n\n"; + + echo "
\n"; +?> + + + + + + + + +\n"; + echo "\t\t\n"; + echo "\t\t\n"; + + $sql2 = "SELECT `Name` FROM `Room` WHERE `RID`='" . mysql_result($Erg, $i, "RID") . "'"; + $Erg2 = mysql_query($sql2, $con); + if (mysql_num_rows($Erg2) > 0) + echo "\t\t\n"; + else + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; + } + echo "
DatumRaumDauerÄndern
" . mysql_result($Erg, $i, "DateS") . "" . mysql_result($Erg2, 0, "Name") . "Unbenkannt (RID=" . mysql_result($Erg, $i, "RID") . ")" . mysql_result($Erg, $i, "Len") . " Std. ####
\n"; + + echo "\n"; + echo "\n"; + echo "
\n"; + +} else { + + // aus sicherheitzgr�nden wegen sp�terer genuzung + UnSet ($chSQL); + + switch ($_GET["action"]) { + + case 'change' : + if (!IsSet ($_GET["SID"])) { + echo "Fehlerhafter Aufruf!\n"; + } else { + + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )"; + $Erg = mysql_query($sql, $con); + + echo "Schicht abändern:
\n"; + + // Anzeige Allgemeiner schaischt daten + echo "
"; + echo "\n"; + echo " " . + "\n"; + echo " \n"; + + echo " " . + "\n"; + echo " " . + "\n"; + echo " " . + "\n"; + if ($FromPentabarf == "Y") { + echo " " . + "\n"; + } + echo "
Schichtbeginn
Raum\n\n
Dauer in h
Beschreibung
URL

!!! Imported from Pentabarf !!!

\n"; + + echo "\n"; + echo "\n"; + echo "\n"; + echo "
\n\n"; + + // L�schen + echo "
\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
\n\n"; + + echo "ACHTUNG:
\n"; + echo "Beim Löschen werden die bisher eingetragenen Engel für diese Schicht mitgelöscht.
\n"; + + echo "
\n\n\n\n"; + + //Freie Engelschichten + $sql3 = "SELECT `TID` FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND `UID`='0'"; + $Erg3 = mysql_query($sql3, $con); + $rowcount = mysql_num_rows($Erg3); + + echo "Folgende Engelschichten sind noch nicht vergeben.\n"; + echo "Und koenen, wenn diese nSchicht nicht benoetigt wird geloet werden:
\n"; + for ($j = 0; $j < $rowcount; $j++) { + $TID = mysql_result($Erg3, $j, 0); + echo "" . + "freie " . TID2Type($TID) . Get_Text("inc_schicht_Engel") . "schicht loeschen
\n"; + } + echo "
\n\n\n\n"; + + //Ausgabe eingetragener schischten + $sql3 = "SELECT * FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND NOT `UID`='0'"; + $Erg3 = mysql_query($sql3, $con); + $rowcount = mysql_num_rows($Erg3); + + echo "Folgende Engel Sind fuer die Schicht eingetargen.\n"; + echo "Und koennen, wenn diese nicht zu Schicht erschienen sind ausgetragen werden:
\n"; + echo "\n" . + "" . + "" . + "" . + "" . + "" . + ""; + + for ($j = 0; $j < $rowcount; $j++) { + $userUID = mysql_result($Erg3, $j, "UID"); + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; + } // FOR + + echo "
nicktypenormalfreeloader :-(
" . UID2Nick($userUID) . "" . TID2Type(mysql_result($Erg3, $j, "TID")) . Get_Text("inc_schicht_Engel") . "###-austragen-######-austragen-freeloader-###

\n\n\n\n"; + + //Nachtragen von Engeln + echo "Hat ein anderer Engel die Schicht übernommen, trage ihn bitte ein:"; + echo "
\n"; + echo "\n"; + echo "\n"; + + // Listet alle Nicks auf + echo "\n"; + + echo " als \n"; + + // holt eine liste der ben�tigten Engel zu dieser Schischt + $sql3 = "SELECT Count(`TID`) AS `CTID`, `TID` FROM `ShiftEntry` "; + $sql3 .= "WHERE (`SID`='" . $_GET["SID"] . "' AND `UID`='0') "; + $sql3 .= "GROUP BY `SID`, `TID`, `UID` "; + $Erg3 = mysql_query($sql3, $con); + $i = -1; + while (++ $i < mysql_num_rows($Erg3)) { + $EngelNeed[mysql_result($Erg3, $i, "TID")] = mysql_result($Erg3, $i, "CTID"); + } + + // Gibt dei m�glich Engeltypen aus und zeigt w�efiel noch be�tigt werden + echo "\n"; + + echo "\n"; + + echo "
\n Anzahl New\n"; + + echo "
"; + + } // IF ISSET( + break; + + case 'engeladd' : + if ($_GET["UIDs"] > 0) { + + $SQL = "SELECT * FROM `ShiftEntry` " . + "WHERE (`SID`='" . $_GET["SID"] . "' AND `TID`='" . $_GET["TID"] . "' AND `UID`='0')"; + $ERG = mysql_query($SQL, $con); + if (mysql_num_rows($ERG) != 0) { + $chSQL = "UPDATE `ShiftEntry` SET " . + "`UID`='" . $_GET["UIDs"] . "', `Comment`='shift added by " . $_SESSION['Nick'] . "' " . + "WHERE (`SID`='" . $_GET["SID"] . "' AND " . + "`TID`='" . $_GET["TID"] . "' AND `UID`='0' ) LIMIT 1"; + } else { + $chSQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (" . + "'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', " . + "'" . $_GET["UIDs"] . "', 'shift added by " . $_SESSION['Nick'] . "')"; + } + echo "Es wird folgende Schicht zusätzlich eingetragen:
\n"; + echo "Engel: " . UID2Nick($_GET["UIDs"]) . "
\n"; + echo "Bemerkung: Schicht eingetragen durch Erzengel " . $_SESSION['Nick'] . "
\n
\n"; + } else { + echo "Es wird folgende Schicht wurde " . $_GET["eAnzahlNew"] . "x zusätzlich eingetragen:
\n"; + for ($i = 0; $i < $_GET["eAnzahlNew"]; $i++) { + echo "$i.
\n"; + $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES ("; + $SQL .= "'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', '0', NULL)"; + $ERG = mysql_query($SQL, $con); + if ($debug) + echo "DEBUG SQL: $SQL
\n"; + if ($ERG == 1) { + echo "Änderung wurde gesichert...
"; + } else { + echo "Fehler beim speichern... bitte noch ein mal probieren :)
"; + echo mysql_error($con); + } + echo "Es wird eine weitere Schicht eingetragen:

\n"; + } + } + break; + + case 'engeldel' : + $chSQL = "UPDATE `ShiftEntry` SET `UID`='0', `Comment`= 'NULL' WHERE (`SID`='" . $_GET["SID"] . + "' AND `UID`='" . $_GET["UIDs"] . "') LIMIT 1"; + if (isset ($_GET["freeloader"]) && $_GET["freeloader"] == 1) { + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )"; + $Erg = mysql_query($sql, $con); + if (mysql_num_rows($Erg) == 1) { + $UID = $_GET["UIDs"]; + $Length = mysql_result($Erg, 0, "Len"); + $Comment = "Start: " . mysql_result($Erg, 0, "DateS") . "; " . + "Beschreibung: " . mysql_result($Erg, 0, "Man") . "; " . + "Removed by " . $_SESSION['Nick']; + $ch2SQL = "INSERT INTO `ShiftFreeloader` (`Remove_Time`, `UID`, `Length`, `Comment`) " . + "VALUES ( CURRENT_TIMESTAMP, '$UID', '$Length', '$Comment');"; + } + } + break; + + case 'engelshiftdel' : + $chSQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND `TID`='" . + $_GET["TID"] . "' AND `UID`='0' LIMIT 1"; + break; + + case 'changesave' : + $query = mysql_query("SELECT DATE_ADD('" . $_GET["eDate"] . "', INTERVAL '+0 " . $_GET["eDauer"] . "' DAY_HOUR)", $con); + $enddate = mysql_fetch_row($query); + + $chSQL = "UPDATE `Shifts` SET " . + "`DateS`='" . $_GET["eDate"] . "', " . + "`DateE`='" . $enddate[0] . "', " . + "`RID`='" . $_GET["eRID"] . "', " . + "`Len`='" . $_GET["eDauer"] . "', " . + "`Man`='" . $_GET["eName"] . "', " . + "`URL`='" . $_GET["eURL"] . "' " . + "WHERE `SID`='" . $_GET["SID"] . "'"; + SetHeaderGo2Back(); + break; + + case 'delete' : + $chSQL = "DELETE FROM `Shifts` WHERE `SID`='" . $_GET["SID"] . "' LIMIT 1"; + $ch2SQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "'"; + SetHeaderGo2Back(); + break; + + case 'deleteShifs' : + foreach ($_GET as $k => $v) + if (strpos(" " . $k, "SID") == 1) { + echo "Shifts $v wird gel�scht..."; + executeSQL("DELETE FROM `Shifts` WHERE `SID`='$v' LIMIT 1"); + echo "
\n"; + echo "ShiftEntry $v wird gel�scht..."; + executeSQL("DELETE FROM `ShiftEntry` WHERE `SID`='$v'"); + echo "

\n"; + } + break; + + } // end switch + + if (IsSet ($chSQL)) { + // echo $chSQL; + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($chSQL, $con); + if ($debug) + echo "DEBUG SQL: $chSQL
\n"; + if ($Erg == 1) { + echo "Änderung wurde gesichert...
"; + if ($debug) + echo "DEBUG: ergebniss" . $Erg . "
\n"; + if (IsSet ($ch2SQL)) { + $Erg = mysql_query($ch2SQL, $con); + if ($debug) + echo "DEBUG SQL: $ch2SQL
\n"; + if ($debug) + echo "DEBUG: ergebniss" . $Erg . "
\n"; + } + } else { + echo "Fehler beim speichern... bitte noch ein mal probieren :)
"; + echo mysql_error($con); + } + } // Ende Update + +} + +include ("includes/footer.php"); +?> diff --git a/www-ssl_old/admin/schichtplan_druck.1.php b/www-ssl_old/admin/schichtplan_druck.1.php new file mode 100644 index 00000000..30761390 --- /dev/null +++ b/www-ssl_old/admin/schichtplan_druck.1.php @@ -0,0 +1,5 @@ +

Schichtplan

+ +
  • Ein-/Austragen
    • +
  • Druckversion
    • + diff --git a/www-ssl_old/admin/schichtplan_druck.php b/www-ssl_old/admin/schichtplan_druck.php new file mode 100644 index 00000000..3e856c5e --- /dev/null +++ b/www-ssl_old/admin/schichtplan_druck.php @@ -0,0 +1,119 @@ +\n" . + "auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. Wähle hierfür ein Datum und den Raum:\n" . + "
    \n"; + + foreach ($VeranstaltungsTage as $k => $v) { + + $res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY `Name`;", $con); + for ($i = 0; $i < mysql_num_rows($res); $i++) { + $Tag = $VeranstaltungsTage[$k]; + $RID = mysql_result($res, $i, "RID"); + $Rname = mysql_result($res, $i, "Name"); + echo "\t$Tag $Rname
    \n"; + } + echo "
    \n"; + } + echo "

    "; + + include ("includes/footer.php"); +} else //################################################################# + { + if (IsSet ($_GET["Raum"]) AND IsSet ($_GET["ausdatum"])) { + $Raum = $_GET["Raum"]; + $ausdatum = $_GET["ausdatum"]; + + include ("config/config_db.php"); + include ("config/config.php"); + include ("includes/secure.php"); + //var wird nur gesetzt immer edit auszublenden, achtung sesion darf nicht gestart sein !!! + $_SESSION['CVS']["admin/schichtplan.php"] = "N"; + include ("includes/funktion_lang.php"); + include ("includes/funktion_schichtplan.php"); + include ("includes/funktion_schichtplan_aray.php"); + include ("includes/funktion_user.php"); +?> + + + + +Schichtplan + + + + + + + + + + +

    Schichtplan

    + + + + + + +
    + Datum: + + + Raum: + +
    + + + + + + + + + +\n"; + if ($j == 0) { + $Spalten[$i * $GlobalZeileProStunde + $j] .= "\t\t\n"; + + } + } + + CreateRoomShifts($Raum); + + // Ausgabe Zeilen + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) + echo $Spalten[$i]; + // Ende + echo "
    UhrzeitSchichtplanbelegung
    "; + if ($i < 10) + $Spalten[$i * $GlobalZeileProStunde + $j] .= "0"; + $Spalten[$i * $GlobalZeileProStunde + $j] .= "$i:"; + if ((($j * 60) / $GlobalZeileProStunde) < 10) + $Spalten[$i * $GlobalZeileProStunde + $j] .= "0"; + $Spalten[$i * $GlobalZeileProStunde + $j] .= (($j * 60) / $GlobalZeileProStunde) . "
    \n"; + + echo "Stand: " . gmdate("Y-m-d H:i") . "\n"; + echo "\n"; + echo "\n"; + + } //isset($Vars) +} //isset($Action) +?> diff --git a/www-ssl_old/admin/shiftadd.php b/www-ssl_old/admin/shiftadd.php new file mode 100644 index 00000000..d6b1f8ff --- /dev/null +++ b/www-ssl_old/admin/shiftadd.php @@ -0,0 +1,350 @@ +\n"; + +// erstellt ein Array der Reume +$sql = "SELECT `RID`, `Name` FROM `Room` ORDER BY `Name`"; +$Erg = mysql_query($sql, $con); +$rowcount = mysql_num_rows($Erg); + +for ($i = 0; $i < $rowcount; $i++) { + $Room[$i]["RID"] = mysql_result($Erg, $i, "RID"); + $Room[$i]["Name"] = mysql_result($Erg, $i, "Name"); +} + +// erstellt ein Aray der Engeltypen +$sql = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`"; +$Erg = mysql_query($sql, $con); +$rowcount = mysql_num_rows($Erg); + +for ($i = 0; $i < $rowcount; $i++) { + $EngelType[$i]["TID"] = mysql_result($Erg, $i, "TID"); + $EngelType[$i]["Name"] = mysql_result($Erg, $i, "Name") . Get_Text("inc_schicht_engel"); +} + +// sesion mit stanadrt werten bef�llen +if (!isset ($_SESSION['shiftadd.php']['SchichtName'])) { + $_SESSION['shiftadd.php']['SchichtName'] = "--???--"; + $_SESSION['shiftadd.php']['RID'] = ""; + $_SESSION['shiftadd.php']['MonthJahr'] = gmdate("Y-m", $Time); + $_SESSION['shiftadd.php']['SDatum'] = gmdate("d", $Time); + $_SESSION['shiftadd.php']['STime'] = "10"; + $_SESSION['shiftadd.php']['MoreThenOne'] = "ON"; + $_SESSION['shiftadd.php']['EDatum'] = gmdate("d", $Time); + $_SESSION['shiftadd.php']['ETime'] = "12"; + $_SESSION['shiftadd.php']['len'] = "2"; + $_SESSION['shiftadd.php']['NachtON'] = "OFF"; + $_SESSION['shiftadd.php']['len_night'] = "00-04-08-10-12-14-16-18-20-22-24"; +} +// wenn werte �bergeben in sesion eintragen +if (!isset ($_GET["NachtON"])) + $_GET["NachtON"] = "OFF"; +if (!isset ($_GET["MoreThenOne"])) + $_GET["MoreThenOne"] = "OFF"; +if (isset ($_GET["SchichtName"])) { + foreach ($_GET as $k => $v) { + $_SESSION['shiftadd.php'][$k] = $v; + } +} + +if (!IsSet ($_GET["action"])) + $_GET["action"] = "new"; + +switch ($_GET["action"]) { + case 'new' : +?> +Hier kannst du neue Schichten eintragen. Dazu musst du den Anfang und das Ende der Schichten eintragen. +Über die Länge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch können gleich +mehrere Schichten auf einmal erfasst werden: + +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +\n"; + echo " \n"; + } +?> +
    Name:">
    Ort:
    Zeit:
    Month.Jahr:">
    Beginn:Date"> + Time">
    More then One>
    End:Date"> + Time">
    Länge in h:">
    Sonderschichten ein:>
    Sonder in h (Time;Time):">
    Anzahl Engel je Type:
    " . $TTemp["Name"] . ":
    +
    + + + +
    + + 0)) { + $lenOrg = $_GET["len"]; + if ($_GET["NachtON"] == "ON") { + $lenArrayDummy = explode("-", $_GET["len_night"]); + foreach ($lenArrayDummy as $Temp) { + if (isset ($Temp2)) + $lenArray[intval($Temp2)] = intval($Temp) - intval($Temp2); + $Temp2 = $Temp; + } //foreach + } //IF( $NachtON == "ON" ) + + echo "\n"; + echo "\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\n"; + + $DateEnd = $_GET["SDatum"]; + $TimeEnd = intval($_GET["STime"]); + $len = 0; + do { + // define Start time + $Date = $DateEnd; + $Time = $TimeEnd; + $_DateS = $_GET["MonthJahr"] . "-" . $Date . " " . $Time . ":00:00"; + + // define End time + if ($_GET["NachtON"] == "ON") { + if (!isset ($lenArray[$Time])) + die("Zeit $Time h nicht definiert."); + $_GET["len"] = $lenArray[$Time]; + if ($_GET["len"] < 1) + die("len <1"); + } + $TimeEnd = $Time + $_GET["len"]; + + //Tages�berschreitung + while ($TimeEnd >= 24) { + $TimeEnd -= 24; + $DateEnd += 1; + } + //ist schischt zu lang dan verk�rzen + if ($DateEnd > $_GET["EDatum"] || ($DateEnd == $_GET["EDatum"] && $TimeEnd >= $_GET["ETime"])) { + $_GET["len"] -= ($DateEnd - $_GET["EDatum"]) * 24; + $_GET["len"] -= ($TimeEnd - $_GET["ETime"]); // -(-) ->> + + $DateEnd = $_GET["EDatum"]; + $TimeEnd = $_GET["ETime"]; + } + $_DateE = $_GET["MonthJahr"] . "-" . $DateEnd . " " . $TimeEnd . ":00:00"; + + if ($_DateS != $_DateE) + CreateNewEntry(); + + if ($_GET["MoreThenOne"] != "ON") + break; + if ($DateEnd >= $_GET["EDatum"] && $TimeEnd >= intval($_GET["ETime"])) + break; + } + while (true); + echo "
    StartEndlenRIDBeschreibungEntry 'Shifts'SIDEntrys
    "; + + if ($_GET["OnlyShow"] == "ON") { + echo "
    "; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + foreach ($EngelType As $TTemp) { + $Temp = "EngelType" . $TTemp["TID"]; + echo "\n\t"; + } + echo "\n\t"; + echo "\n\t"; + echo "\n
    "; + } //if + } //IF + break; + + case 'engeldel' : + break; + +} // end switch + +function CreateNewEntry() { + global $con, $_DateS, $_DateE, $EngelType, $debug; + foreach ($EngelType As $TTemp) { + $Temp = "EngelType" . $TTemp["TID"]; + global $$Temp; + } + + echo "\n"; + + echo "\t$_DateS\n"; + echo "\t$_DateE\n"; + echo "\t" . $_GET["len"] . "\n"; + echo "\t" . $_GET["RID"] . "\n"; + echo "\t" . $_GET["SchichtName"] . "\n"; + + // Ist eintarg schon vorhanden? + $SQL = "SELECT `SID` FROM `Shifts` "; + $SQL .= "WHERE (" . + "`DateS` = '" . $_DateS . "' AND " . + "`DateE` = '" . $_DateE . "' AND " . + "`RID` = '" . $_GET["RID"] . "');"; + $Erg = mysql_query($SQL, $con); + + if (mysql_num_rows($Erg) != 0) + echo "\texists"; + elseif ($_GET["OnlyShow"] == "OFF") { + // erstellt Eintrag in Shifts f�r die algemeine schicht + $SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( "; + $SQL .= "'" . $_DateS . "', '" . $_DateE . "', "; + $SQL .= "'" . $_GET["len"] . "', '" . $_GET["RID"] . "', "; + $SQL .= "'" . $_GET["SchichtName"] . "');"; + $Erg = db_query($SQL, "create shift"); + + $SQLFail = "\n\t
    [" . $SQL . "]"; + + if ($Erg == 1) + echo "\tpass\n"; + else + echo "\tfail
    \n" . mysql_error($con) . "$SQLFail\n"; + + } else + echo "\tonly show\n"; + + // sucht SID von eingetragennen schiten + $SQL = "SELECT SID FROM `Shifts` "; + $SQL .= "WHERE (" . + "`DateS` = '" . $_DateS . "' AND " . + "`DateE` = '" . $_DateE . "' AND " . + "`Len` = '" . $_GET["len"] . "' AND " . + "`RID` = '" . $_GET["RID"] . "');"; + $Erg = mysql_query($SQL, $con); + if (mysql_num_rows($Erg) == 0) + echo "\t?"; + else { + $SID = mysql_result($Erg, 0, "SID"); + echo "\t" . $SID . ""; + } + + // erstellt f�r jeden Engeltypen die eintrage in 'ShiftEntry' + echo "\t"; + foreach ($EngelType As $TTemp) { + $Temp = "EngelType" . $TTemp["TID"]; + + if ($_GET[$Temp] > 0) { + $i = 0; + echo $_GET[$Temp] . " " . $TTemp["Name"] . "
    \t"; + while ($i++ < $_GET[$Temp]) { + if ($_GET["OnlyShow"] == "OFF") { + $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES ("; + $SQL .= "'" . $SID . "', "; + $SQL .= "'" . $TTemp["TID"] . "');"; + + $Erg = mysql_query($SQL, $con); + + if ($debug) + $SQLFail = "\n\t
    [" . $SQL . "]"; + + if ($Erg == 1) + echo "'pass' "; + else + echo "'fail' " . mysql_error($con) . "$SQLFail\n"; + + } else + echo "+"; + } + echo "
    "; + } // IF $$TEMP + } // FOREACH + echo ""; + + echo "\n"; +} + +include ("includes/footer.php"); +?> diff --git a/www-ssl_old/admin/tshirt.php b/www-ssl_old/admin/tshirt.php new file mode 100644 index 00000000..9a8e7010 --- /dev/null +++ b/www-ssl_old/admin/tshirt.php @@ -0,0 +1,62 @@ +"; + } +} +?> + +Über die Suchen-Funktion des Browsers kann diese Liste schnell nach einem Nick abgesucht werden.
    +Hinter diesem erscheint ein Link, über den man eintragen kann, dass der Engel sein T-Shirt erhalten hat.

    + +Liste aller aktiven Engel: + + + + + + + + + +\n"; + $eUID = mysql_result($Erg, $i, "UID"); + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + + if (mysql_result($Erg, $i, "Tshirt") == "1") { + echo "\t\t"; + } else { + echo "\t\t"; + } + echo "\t\n"; +} + +echo "
    NickAktiv?GrösseT-Shirt ausgeben:" . UID2Nick($eUID) . "" . mysql_result($Erg, $i, "Aktiv") . "" . mysql_result($Erg, $i, "Size") . "bereits erhaltenXXXXXXXX
    "; + +include ("includes/footer.php"); +?> + diff --git a/www-ssl_old/admin/userArrived.php b/www-ssl_old/admin/userArrived.php new file mode 100644 index 00000000..93857d2e --- /dev/null +++ b/www-ssl_old/admin/userArrived.php @@ -0,0 +1,53 @@ +" . Get_Text("pri_userArrived_WriteOK") . " \"" . UID2Nick($_GET["arrived"]) . "\""; + } else { + echo "

    " . Get_Text("pri_userArrived_WriteError") . " \"" . UID2Nick($_GET["arrived"]) . "\"

    "; + } +} + +echo Get_Text("pri_userArrived_Text1") . "
    "; +echo Get_Text("pri_userArrived_Text2") . "

    "; + +echo Get_Text("pri_userArrived_TableToppic"); +$SQL = "SELECT * FROM `User` ORDER BY `Nick` ASC"; +$Erg = mysql_query($SQL, $con); + +$rowcount = mysql_num_rows($Erg); + +echo "\n"; +echo "\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\t\n"; +echo "\t\n"; + +for ($i = 0; $i < $rowcount; $i++) { + echo "\t\n"; + $eUID = mysql_result($Erg, $i, "UID"); + echo "\t\t\n"; + echo "\t\t\n"; + + if (mysql_result($Erg, $i, "Gekommen") == "1") { + echo "\t\t"; + } else { + echo "\t\t"; + } + echo "\t\n"; +} +echo "
    " . Get_Text("pri_userArrived_TableTD_Nick") . "" . Get_Text("pri_userArrived_TableTD_ArrivedShow") . "" . Get_Text("pri_userArrived_TableTD_ArrivedSet") . "
    " . UID2Nick($eUID) . "" . mysql_result($Erg, $i, "Gekommen") . "" . Get_Text("pri_userArrived_TableEntry_Arrived") . "" . Get_Text("pri_userArrived_TableEntry_Set") . "
    "; + +include ("includes/footer.php"); +?> + 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 @@ +\n"; + echo Get_Text("pub_mywake_beschreibung1") . "
    \n"; + echo Get_Text("pub_mywake_beschreibung2") . "

    \n"; + echo Get_Text("pub_mywake_beschreibung3") . ($LETZTES_AUSTRAGEN) . + Get_Text("pub_mywake_beschreibung4") . "

    \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 "
    "; + + echo "Liste von anzeigen.\n"; + echo mysql_error($con); + + echo "\n"; + + echo "
    "; + } + + $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); +?> + + + + + + + + + + + "; + + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\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 "\n"; + else + echo "\n"; + + echo "\n"; + } + echo "
    " . substr(mysql_result($erg, $i, "DateS"), 0, 10) . "" . substr(mysql_result($erg, $i, "DateS"), 11) . "" . mysql_result($erg, $i, "Len") . " h" . mysql_result($erg, $i, "Man") . "" . $RoomID[mysql_result($erg, $i, "RID")] . "
    \n" . + "(" . TID2Type(mysql_result($erg, $i, "TID")) . Get_Text("inc_schicht_engel") . ")" . + "
    \n" .
+		mysql_result($erg, $i, "Comment") .
+		"\n
    \n"; + echo "
    # vi #    		 " . + Get_Text("pub_mywake_austragen") . "" . Get_Text("pub_mywake_austragen_n_c") . "
    \n\n"; + + if ($_SESSION['CVS']["nonpublic/myschichtplan_ical.php"] == "Y") { + echo "
    " . Get_Text("pub_myschichtplan_ical") . "\n"; + } + +} else { + If ($_GET["action"] == "austragen") { + echo Get_Text("pub_mywake_delate1") . "
    \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 "
    \n"; + echo "

    \n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
    "; + } + elseif ($_GET["action"] == "editSave") { + echo Get_Text("pub_myshift_EditSave_Text1") . "
    \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 @@ + + 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 @@ +

     Tage

    + +$Datum\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 @@ +

     Raumübersicht

    +" . + $RoomEntry["Name"] . "\n"; + else + echo "\t
  • " . + $RoomEntry["Name"] . "
    • \n"; + } +echo "
    "; +if (isset ($ausdatum)) + echo "
  • alle
    • "; +else + echo "
  • alle
    • "; +?> + 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 @@ + $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'] . ",
    " . +Get_Text("pub_schicht_beschreibung") . "

    "; + +function ShowSwitchDay() { + global $VeranstaltungsTage, $VeranstaltungsTageMax, $ausdatum, $raum; + + echo "\n\n\n"; + + if (isset ($VeranstaltungsTage)) + foreach ($VeranstaltungsTage as $k => $v) + if ($ausdatum == $v) { + if ($k > 0) + echo "\t\t\t\n"; + if ($k < $VeranstaltungsTageMax) + echo "\t\t\t\n"; + } + echo "\n\n
    " . + "" . $VeranstaltungsTage[$k -1] . "" . + "" . $VeranstaltungsTage[$k +1] . "
    "; +} + +// 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") . "

    \n"; + +<<<<<<< HEAD + +if ( !isset($raum) ) +{ + // Ausgabe wenn kein Raum Ausgew�hlt: + echo Get_Text("pub_schicht_auswahl_raeume"). "

    \n"; + + if( isset($Room)) + { +======= + if (isset ($Room)) { +>>>>>>> spezial_includes_camp + echo "
    \n"; + foreach ($Room as $RoomEntry) { + echo "\t
  • "; + echo "" . $RoomEntry["Name"] . ""; + echo "
    • \n"; + } + echo ""; + echo ""; + echo "\n"; + echo "
    \n"; + } + + echo "

    "; + echo Get_Text("pub_schicht_alles_1") . " " . + Get_Text("pub_schicht_alles_2") . " " . Get_Text("pub_schicht_alles_3"); + echo "\n

    \n\n"; + echo "
    \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.":

    "; + elseif( substr( $raum, 0, 1) == ";" ) + echo Get_Text("pub_schicht_Anzeige_1").$ausdatum.":

    "; + else + echo Get_Text("pub_schicht_Anzeige_1"). $ausdatum. + Get_Text("pub_schicht_Anzeige_2"). $RoomID[$raum]. "

    "; +======= + showEmptyShifts(); +} else { // Wenn einraum Ausgew�hlt ist: + if ($raum == -1) + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":

    "; + elseif (substr($raum, 0, 1) == ";") echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":

    "; + else + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . + Get_Text("pub_schicht_Anzeige_2") . $RoomID[$raum] . "

    "; +>>>>>>> spezial_includes_camp + + ShowSwitchDay(); + + echo "\n\n\n"; + echo "\t\n"; + echo "\t\t\n"; + + //Ausgabe Spalten �berschrift +<<<<<<< HEAD + if( $raum == -1 ) + { + if( isset($Room)) + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t\n"; +======= + if ($raum == -1) { + if (isset ($Room)) + foreach ($Room as $RoomEntry) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t\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\n"; + } + } else + echo "\t\t\n"; + echo "\t\n"; + + //Zeit Ausgeben + for ($i = 0; $i < 24; $i++) + for ($j = 0; $j < $GlobalZeileProStunde; $j++) { + $Spalten[$i * $GlobalZeileProStunde + $j] = "\t\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 = "

    $SpaltenTemp

    "; + + $SpaltenTemp = "\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\n"; + } + + echo "
    start". $RoomEntry["Name"]. "" . $RoomEntry["Name"] . "" . $RoomID[trim($word)] . "" . $RoomID[$raum] . "
    $SpaltenTemp
    \n"; + + ShowSwitchDay(); + +} //if (isset($raum)) + +echo "@"; + +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 @@ += '$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 "

    :-(

    "; + 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") . "

    \n\n" . + "
    \n" . + "\n"; + + $SQL = "SELECT * FROM `Shifts` WHERE "; + $SQL .= "(`SID` = '" . $_GET["SID"] . "')"; + $Erg = mysql_query($SQL, $con); + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n \n"; + + echo "\n" . + "\n" . + "
    " . Get_Text("pub_schichtplan_add_Date") . ": " . + mysql_result($Erg, 0, "DateS") . "
    " . Get_Text("pub_schichtplan_add_Place") . ": " . + $RoomID[mysql_result($Erg, 0, "RID")] . "
    " . Get_Text("pub_schichtplan_add_Job") . ": " . + $EngelTypeID[$_GET["TID"]] . "
    " . Get_Text("pub_schichtplan_add_Len") . ": " . + mysql_result($Erg, 0, "Len") . "h
    " . Get_Text("pub_schichtplan_add_TextFor") . ": " . + mysql_result($Erg, 0, "Man") . "
    " . Get_Text("pub_schichtplan_add_Comment") . ":" . + "
     
    \n" . + "\n" . + "\n" . + "
    "; + } else { + echo "

    :-(

    "; + 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 @@ + + + + + +Schichtpläne für Beamer + + + + + +\n"; + +echo " + + + + + \n"; + +echo "\n" . +"" . gmdate("d.m.y", $Time) . "\n" . +"" . gmdate("H", $Time -3600) . ":00\n" . +"" . gmdate("H", $Time +0) . ":00\n" . +"" . gmdate("H", $Time +3600) . ":00\n" . +"\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 = "\n_" . $RoomEntry["Name"] . "_\n" . $Out . "\n"; + + echo $Out; +} +?> + + + + + -- cgit v1.2.3-54-g00ecf