From 310c2ce98fc8c0e94559c9ed8587101d92f6e853 Mon Sep 17 00:00:00 2001 From: cookie Date: Sat, 10 Sep 2005 17:25:43 +0000 Subject: add total system git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8 --- nonpublic/einstellungen.php | 238 +++++++++++++++++++++++++++++++++++++++ nonpublic/engelbesprechung.php | 29 +++++ nonpublic/faq.php | 71 ++++++++++++ nonpublic/inc | 1 + nonpublic/index.php | 107 ++++++++++++++++++ nonpublic/menu.php | 33 ++++++ nonpublic/myschichtplan.php | 149 ++++++++++++++++++++++++ nonpublic/news.php | 11 ++ nonpublic/news_comments.php | 87 ++++++++++++++ nonpublic/news_output.php | 114 +++++++++++++++++++ nonpublic/news_output.php.old | 90 +++++++++++++++ nonpublic/passwort.php | 58 ++++++++++ nonpublic/pic | 1 + nonpublic/schichtplan.1.php | 19 ++++ nonpublic/schichtplan.2.php | 12 ++ nonpublic/schichtplan.php | 122 ++++++++++++++++++++ nonpublic/schichtplan_add.php | 96 ++++++++++++++++ nonpublic/schichtplan_beamer.php | 56 +++++++++ nonpublic/schichtplanneu.1.php | 17 +++ nonpublic/schichtplanneu.php | 106 +++++++++++++++++ nonpublic/waeckliste.php | 56 +++++++++ nonpublic/wecken.php | 77 +++++++++++++ 22 files changed, 1550 insertions(+) create mode 100755 nonpublic/einstellungen.php create mode 100755 nonpublic/engelbesprechung.php create mode 100755 nonpublic/faq.php create mode 120000 nonpublic/inc create mode 100755 nonpublic/index.php create mode 100755 nonpublic/menu.php create mode 100755 nonpublic/myschichtplan.php create mode 100755 nonpublic/news.php create mode 100755 nonpublic/news_comments.php create mode 100755 nonpublic/news_output.php create mode 100755 nonpublic/news_output.php.old create mode 100755 nonpublic/passwort.php create mode 120000 nonpublic/pic create mode 100755 nonpublic/schichtplan.1.php create mode 100755 nonpublic/schichtplan.2.php create mode 100755 nonpublic/schichtplan.php create mode 100755 nonpublic/schichtplan_add.php create mode 100755 nonpublic/schichtplan_beamer.php create mode 100755 nonpublic/schichtplanneu.1.php create mode 100755 nonpublic/schichtplanneu.php create mode 100755 nonpublic/waeckliste.php create mode 100755 nonpublic/wecken.php (limited to 'nonpublic') diff --git a/nonpublic/einstellungen.php b/nonpublic/einstellungen.php new file mode 100755 index 00000000..36fa76a7 --- /dev/null +++ b/nonpublic/einstellungen.php @@ -0,0 +1,238 @@ +\n\n"; + +Print_Text(13); + +?> +
+ +
+ + + + + + + + + + + + + + + + + + +
">
+ +
+
+ + +
+ +
+ + + + + +
+ +
+
+ + +
+
+ +
+ + + + +
+ +
+ +
+
+
+
+ +
+ + + + +
+ +
+ +
+
+
+
+ +
+ + + + + + + + +

+
+ + + + +    + +
+ +
+ + + diff --git a/nonpublic/engelbesprechung.php b/nonpublic/engelbesprechung.php new file mode 100755 index 00000000..436a5271 --- /dev/null +++ b/nonpublic/engelbesprechung.php @@ -0,0 +1,29 @@ + + +
+ +".mysql_result($Erg, $n, "Betreff")."
". + "   ".mysql_result($Erg, $n, "Datum").", "; + echo UID2Nick(mysql_result($Erg, $n, "UID"))."

\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Text"))."

\n"; + } +} + + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/faq.php b/nonpublic/faq.php new file mode 100755 index 00000000..d8388f50 --- /dev/null +++ b/nonpublic/faq.php @@ -0,0 +1,71 @@ + +

+
+ +

+ +
+".Get_Text(37)."

\n".nl2br($frage)."

\n".Get_Text(38)."
\n"; + +$SQL = "INSERT into Questions VALUES (\"\", \"".$_SESSION['UID']."\", \"$frage\", \"\", \"\")"; +$Erg = mysql_query($SQL, $con); + +} +// Bisherige Anfragen: +echo "
\n".Get_Text(39)."
\n"; +echo "
\n"; +echo "
".Get_Text(40)."
\n"; + +$SQL = "SELECT * from Questions where UID = ".$_SESSION['UID']." and AID=\"0\" ORDER BY 'QID' DESC"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$Zeilen = mysql_num_rows($Erg); + +if ($Zeilen==0){ + Print_Text(41); + +} else { + for ($n = 0 ; $n < $Zeilen ; $n++) { + echo "

".nl2br(mysql_result($Erg, $n, "Question"))."
\n"; +// Es gibt ja noch keine Antwort: +// echo "

".nl2br(mysql_result($Erg, $n, "Answer"))."

\n"; + echo "\n
---
"; + } +} + +echo "
\n"; +echo "
".Get_Text(42)."
\n"; +$SQL = "SELECT * from Questions where UID = ".$_SESSION['UID']." and AID<>\"0\" ORDER BY 'QID' DESC"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$Zeilen = mysql_num_rows($Erg); + +if ($Zeilen==0){ + Print_Text(41); +} else { + for ($n = 0 ; $n < $Zeilen ; $n++) { + echo "

".nl2br(mysql_result($Erg, $n, "Question"))."
\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Answer"))."\n"; + echo "\n
---
"; + } +} + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/inc b/nonpublic/inc new file mode 120000 index 00000000..22dc542a --- /dev/null +++ b/nonpublic/inc @@ -0,0 +1 @@ +../inc \ No newline at end of file diff --git a/nonpublic/index.php b/nonpublic/index.php new file mode 100755 index 00000000..1aaf237e --- /dev/null +++ b/nonpublic/index.php @@ -0,0 +1,107 @@ + 1 --> keine Anmeldung + include ("./inc/header.php"); + if ($user_anz == 0) + { + echo Get_Text("pub_index_User_unset"); + } + else + { + echo Get_Text("pub_index_User_more_as_one"); + } + + include ("./inc/login_eingabefeld.php"); + } // Ende Check, ob User angemeldet wurde +} +else +{ // User ist bereits angemeldet... normaler Inhalt... + + include ("./inc/header.php"); + echo Get_Text(1).$_SESSION['Nick']; + echo nl2br(Get_Text(2)); + + include ("./news_output.php"); + +} // Ende Ueberpruefung, ob User bereits angemeldet... + + + +?> + + + + diff --git a/nonpublic/menu.php b/nonpublic/menu.php new file mode 100755 index 00000000..7dac48bb --- /dev/null +++ b/nonpublic/menu.php @@ -0,0 +1,33 @@ + diff --git a/nonpublic/myschichtplan.php b/nonpublic/myschichtplan.php new file mode 100755 index 00000000..c9bfb703 --- /dev/null +++ b/nonpublic/myschichtplan.php @@ -0,0 +1,149 @@ +\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"; + + $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); + + ?> + + + + + + + + + + "; + + 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". $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"; + +} +else +{ + If( $action == "austragen" ) + { + echo Get_Text("pub_mywake_delate1")."
\n"; + + $sql = "SELECT * FROM `Shifts` WHERE "; + $sql.= "(SID = \"$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` = '$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( $action == "edit" ) + { + echo Get_Text("pub_myshift_Edit_Text1"). "\n"; + + $sql = "SELECT * FROM `ShiftEntry` WHERE "; + $sql.= "(SID=\"$SID\" AND UID=\"". $_SESSION['UID']. "\" )"; + $Erg = mysql_query($sql, $con); + + echo "

\n"; + echo "

\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
"; + } + elseif( $action == "editSave" ) + { + echo Get_Text("pub_myshift_EditSave_Text1"). "
\n"; + $sql = "UPDATE `ShiftEntry` ". + "SET `Comment` = \"". $newtext. "\" ". + "WHERE `SID`='$SID' AND `UID`='". $_SESSION['UID']. "' LIMIT 1;"; + $Erg = mysql_query($sql, $con); + if ($Erg == 1) + echo "\t ...". Get_Text("pub_myshift_EditSave_OK"). "\n"; + else + echo "\t ...". Get_Text("pub_myshift_EditSave_KO"). "\n"; + SetHeaderGo2Back(); + } +} +include ("./inc/footer.php"); +?> diff --git a/nonpublic/news.php b/nonpublic/news.php new file mode 100755 index 00000000..107f5913 --- /dev/null +++ b/nonpublic/news.php @@ -0,0 +1,11 @@ +".Get_Text(3).""; +include ("news_output.php"); + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/news_comments.php b/nonpublic/news_comments.php new file mode 100755 index 00000000..d2c450ea --- /dev/null +++ b/nonpublic/news_comments.php @@ -0,0 +1,87 @@ +
"; } +} + +$SQL = "SELECT * FROM news_comments where Refid = $nid ORDER BY 'ID'"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$news_rows = mysql_num_rows($Erg); + +?> + + + + + + + + + +"; + echo "\t\t"; + echo "\t\t"; + echo ""; + echo "\t"; + echo "\t\t"; + echo ""; +} + +echo "
DatumNick
Kommentar
"; + echo mysql_result($Erg, $n, "Datum"); + echo "\t\t"; + echo UID2Nick(mysql_result($Erg, $n, "UID")); + // avatar anzeigen? + echo DisplayAvatar (mysql_result($Erg, $n, "UID")); + echo "\t\t
"; + echo nl2br(mysql_result($Erg, $n, "Text"))."\n"; + echo "\t\t
"; + +?> + +
+
+

Neuer Kommentar:

+  + +
+"> + + + + + + +
Text:
+
+ +
+ + diff --git a/nonpublic/news_output.php b/nonpublic/news_output.php new file mode 100755 index 00000000..9648fc41 --- /dev/null +++ b/nonpublic/news_output.php @@ -0,0 +1,114 @@ += 0 ) { +// echo "

Die vorherigen $DISPLAY_NEWS News anzeigen...
"; +//} + +$SQL = "SELECT * FROM `News` ORDER BY 'ID' DESC LIMIT $news_begin,$DISPLAY_NEWS"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$news_rows = mysql_num_rows($Erg); + +for ($n = 0 ; $n < $news_rows ; $n++) { + + if (mysql_result($Erg, $n, "Treffen") == 0) { + echo "

"; + } else { + echo "

"; + } + echo "".mysql_result($Erg, $n, "Betreff")."
\n"; + + + echo "   ".mysql_result($Erg, $n, "Datum").", "; + echo UID2Nick(mysql_result($Erg, $n, "UID")).""; + // avatar anzeigen? + echo DisplayAvatar (mysql_result($Erg, $n, "UID")); + echo "

\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Text"))."

\n"; + $RefID=mysql_result($Erg, $n, "ID"); + $countSQL="SELECT COUNT(*) from news_comments where Refid = '$RefID'"; + $countErg = mysql_query($countSQL, $con); + $countcom = mysql_result($countErg, 0, "COUNT(*)"); + echo "

$countcom comments

\n\n"; + + +} +//echo "Die nächsten $DISPLAY_NEWS News anzeigen...

\n"; + +echo "
\n\n"; +$rowerg = mysql_query("select * from News", $con); +$rows = mysql_num_rows($rowerg); +$dis_rows = round (($rows / $DISPLAY_NEWS)+0.5); + +Print_Text(5); + +for ($i=1; $i <= $dis_rows; $i++) { + if (!((($i * $DISPLAY_NEWS) - $news_begin) == $DISPLAY_NEWS)) { + echo "$i  "; + } else { + echo "$i  "; + } +} +echo "
"; + +?> + +
+
+

+  + +
+ +"> + + + + + + + + + + + + + + + + +
+
+ +
diff --git a/nonpublic/news_output.php.old b/nonpublic/news_output.php.old new file mode 100755 index 00000000..fbf97c62 --- /dev/null +++ b/nonpublic/news_output.php.old @@ -0,0 +1,90 @@ +
"; } +} + + +if (!IsSet($news_begin)) { + $news_begin=0; +} + +if (!IsSet($DISPLAY_NEWS)) { + $DISPLAY_NEWS = 5; +} + +if (($news_begin-$DISPLAY_NEWS) >= 0 ) { + echo "

Die vorherigen $DISPLAY_NEWS News anzeigen...
"; +} + +$SQL = "SELECT * FROM `News` ORDER BY 'ID' DESC LIMIT $news_begin,$DISPLAY_NEWS"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$news_rows = mysql_num_rows($Erg); + +for ($n = 0 ; $n < $news_rows ; $n++) { + echo "

".mysql_result($Erg, $n, "Betreff")."
\n"; + echo "   ".mysql_result($Erg, $n, "Datum").", "; + echo UID2Nick(mysql_result($Erg, $n, "UID")).""; + // avatar anzeigen? + echo DisplayAvatar (mysql_result($Erg, $n, "UID")); + echo "

\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Text"))."

\n"; + $RefID=mysql_result($Erg, $n, "ID"); + $countSQL="SELECT COUNT(*) from news_comments where Refid = '$RefID'"; + $countErg = mysql_query($countSQL, $con); + $countcom = mysql_result($countErg, 0, "COUNT(*)"); + echo "

$countcom comments

\n\n"; + + +} +echo "Die nächsten $DISPLAY_NEWS News anzeigen..."; + +?> + +
+
+

Neue News erstellen:

+  + +
+ +"> + + + + + + + + + + + + + + + + +
Betreff:
Text:
Treffen:
+
+ +
diff --git a/nonpublic/passwort.php b/nonpublic/passwort.php new file mode 100755 index 00000000..37860946 --- /dev/null +++ b/nonpublic/passwort.php @@ -0,0 +1,58 @@ + + +Hier kannst du dein Kennwort für unsere Himmelsverwaltung ändern.

+ +
+ + + + + +
Altes Passwort:
Neues Passwort:
Passwortbestätigung:
+ +
+ ok.
"; + echo "Check, ob altes Passwort ok ist."; + $sql = "select * from User where UID=".$_SESSION['UID']; + $Erg = mysql_query($sql, $con); + if (md5($old)==mysql_result($Erg, $i, "Passwort")) { + echo "-> ok.
"; + echo "Setzen des neuen Kennwortes...: "; + $usql = "update User set Passwort='".md5($new1)."' where UID=".$_SESSION['UID']; + $Erg = mysql_query($usql, $con); + if ($Erg==1) { + echo "Neues Kennwort wurde gesetzt."; + } else { + echo "Ein Fehler ist trotzdem noch aufgetreten. Probiere es einfach nocheinmal :)"; + } + + + } else { + echo "-> nicht ok.
"; + echo "Altes Kennwort ist nicht ok. Bitte wiederholen.
"; + } + + } else { + echo "Kennwörter sind nicht gleich. Bitte wiederholen."; + } + + } else { + echo "Ungültiger Aufruf!\n"; + } +} + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/pic b/nonpublic/pic new file mode 120000 index 00000000..a21de85f --- /dev/null +++ b/nonpublic/pic @@ -0,0 +1 @@ +../pic \ No newline at end of file diff --git a/nonpublic/schichtplan.1.php b/nonpublic/schichtplan.1.php new file mode 100755 index 00000000..09671527 --- /dev/null +++ b/nonpublic/schichtplan.1.php @@ -0,0 +1,19 @@ +

 Tage

+ +$tmp\n"; +} + +?> diff --git a/nonpublic/schichtplan.2.php b/nonpublic/schichtplan.2.php new file mode 100755 index 00000000..8b477f41 --- /dev/null +++ b/nonpublic/schichtplan.2.php @@ -0,0 +1,12 @@ +

 Raum übersicht

+ +". + $RoomEntry["Name"]. "\n"; + +echo "
"; +echo "
  • alle
    • "; +?> + diff --git a/nonpublic/schichtplan.php b/nonpublic/schichtplan.php new file mode 100755 index 00000000..1bb08491 --- /dev/null +++ b/nonpublic/schichtplan.php @@ -0,0 +1,122 @@ + + +". + Get_Text("pub_schicht_beschreibung");?> +

    +
    \n"; + + foreach( $Room as $RoomEntry ) + echo "\t
  • ". + $RoomEntry["Name"]. "
    • \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 + showEmptyShifts(); +} +else +{ // Wenn einraum Ausgewählt ist: + if( $raum == -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]. "

    "; + + echo "\n\n\n"; + echo "\t\n"; + echo "\t\t\n"; + + //Ausgabe Spalten überschrift + if( $raum == -1 ) + { + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 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"; + if( $j==0) + { + $SpaltenTemp = "\n"; + $Spalten[$i * $GlobalZeileProStunde + $j].= $SpaltenTemp; + } + } + + if( $raum == -1 ) + { + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + CreateRoomShifts( $RoomEntry["RID"] ); + } + else + CreateRoomShifts( $raum ); + + //Ausageb Zeilen + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) + echo $Spalten[$i]."\t\n"; + + echo "
    start". $RoomEntry["Name"]. "". $RoomID[$raum]. "
    "; + if( ($i == gmdate("H", time()+3600)) && (gmdate("Y-m-d", time()+ 3600) == $ausdatum) ) + $SpaltenTemp.= "

    "; + + if( $i < 10 ) + $SpaltenTemp.= "0"; + $SpaltenTemp.= "$i:"; + if( ( ($j*60) / $GlobalZeileProStunde) < 10 ) + $SpaltenTemp.= "0"; + + $SpaltenTemp.= ( ($j*60) / $GlobalZeileProStunde); + if( ($i == gmdate("H", time()+3600)) && (gmdate("Y-m-d", time()+ 3600) == $ausdatum) ) + $SpaltenTemp.= "

    "; + + $SpaltenTemp.= "
    \n"; +}//if (isset($raum)) + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/schichtplan_add.php b/nonpublic/schichtplan_add.php new file mode 100755 index 00000000..33b25d2c --- /dev/null +++ b/nonpublic/schichtplan_add.php @@ -0,0 +1,96 @@ += '$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` = '$SID') and (`TID` = '$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` = '$newtext' ". + "WHERE ((`SID` = '$SID') and (`TID` = '$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"); + + }//TO Many USERS + }//Allready in Shift +} +elseif (isset($SID) && isset($TID)) { + echo Get_Text("pub_schichtplan_add_Text1"). "

    \n\n". + "
    ". + ""; + + $SQL = "SELECT * FROM `Shifts` WHERE "; + $SQL .="(SID = '".$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[$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". + "
    "; + +} + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/schichtplan_beamer.php b/nonpublic/schichtplan_beamer.php new file mode 100755 index 00000000..c862fefa --- /dev/null +++ b/nonpublic/schichtplan_beamer.php @@ -0,0 +1,56 @@ +\n"; + +echo " + + + + + \n"; + +echo "\n". +// "\t \n". + "\t". gmdate("d.m.y", $Time). "\n". + "\t". gmdate("H", $Time-3600). ":00\n". + "\t". gmdate("H", $Time+0). ":00\n". + "\t". 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); + + + //entfernt leere zeilen + if( $AnzahlEintraege==0 ) + $Out = ""; + else + $Out = "\n\t_". $RoomEntry["Name"]. "_\n". $Out . "\n"; + + echo $Out; +} + +echo ""; + + +include ("./inc/footer.php"); +?> diff --git a/nonpublic/schichtplanneu.1.php b/nonpublic/schichtplanneu.1.php new file mode 100755 index 00000000..e7a41f7f --- /dev/null +++ b/nonpublic/schichtplanneu.1.php @@ -0,0 +1,17 @@ +

     Tage

    + +$tmp"; + echo "\t
  • $tmp
    • \n"; +} + +?> diff --git a/nonpublic/schichtplanneu.php b/nonpublic/schichtplanneu.php new file mode 100755 index 00000000..2585f420 --- /dev/null +++ b/nonpublic/schichtplanneu.php @@ -0,0 +1,106 @@ + + +Hallo ,
    +hier kannst du dich für Schichten in der Aula eintragen. Dazu wähle einfach eine freie Schicht und klicke auf den Link.

    + + + + +\n"; +# $Spalten[$i].= "\t\t\n"; +# } +# } +# $rowcount = mysql_num_rows($res); + + + +for ($zeit = 0; $zeit < 24; $zeit++) + { + $zzeit = $zeit; + if ($zzeit < 10) + { + $zzeit = "0".$zzeit; + } + +$SSQL = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-27 $zzeit:00:00\" AND RID = 1"; +$SERG = mysql_query($SSQL, $con); +$SRES = mysql_fetch_row($SERG); + +$USQL = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES[0]."\""; +$UERG = mysql_query($USQL, $con); +$URES = mysql_fetch_row($UERG); + +$NSQL = "SELECT Nick FROM User WHERE UID = \"$URES[0]\""; +$NERG = mysql_query($NSQL, $con); +$NRES = mysql_fetch_row($NERG); + +echo "\t\n"; +echo "\t\t"; +echo "\t\t"; + +$SSQL2 = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-28 $zzeit:00:00\" AND RID = 1"; +$SERG2 = mysql_query($SSQL2, $con); +$SRES2 = mysql_fetch_row($SERG2); + +$USQL2 = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES2[0]."\""; +$UERG2 = mysql_query($USQL2, $con); +$URES2 = mysql_fetch_row($UERG2); + +$NSQL2 = "SELECT Nick FROM User WHERE UID = \"$URES2[0]\""; +$NERG2 = mysql_query($NSQL2, $con); +$NRES2 = mysql_fetch_row($NERG2); + +echo "\t\t"; + +$SSQL3 = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-29 $zzeit:00:00\" AND RID = 1"; +$SERG3 = mysql_query($SSQL3, $con); +$SRES3 = mysql_fetch_row($SERG3); + +$USQL3 = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES3[0]."\""; +$UERG3 = mysql_query($USQL3, $con); +$URES3 = mysql_fetch_row($UERG3); + +$NSQL3 = "SELECT Nick FROM User WHERE UID = \"$URES3[0]\""; +$NERG3 = mysql_query($NSQL3, $con); +$NRES3 = mysql_fetch_row($NERG3); + +echo "\t\t"; +echo "\t"; + + + +} +echo "
    "; +# if($i < 10){ +# $Spalten[$i].= "0"; +# $Spalten[$i].= "$i:00"; +# $Spalten[$i].= "
    \n"; +echo $zzeit.":00"; +echo "\t\t\n"; +echo $NRES[0]; +echo "\t\t\n"; +echo $NRES2[0]; +echo "\t\t\n"; +echo $NRES3[0]; +echo "\t\t
    \n"; +include ("./inc/footer.php"); +?> diff --git a/nonpublic/waeckliste.php b/nonpublic/waeckliste.php new file mode 100755 index 00000000..80303168 --- /dev/null +++ b/nonpublic/waeckliste.php @@ -0,0 +1,56 @@ + + +\n". + Get_Text("pub_waeckliste_Text1")?> +

    + + + + + + + + + + + + + + + + +
    + diff --git a/nonpublic/wecken.php b/nonpublic/wecken.php new file mode 100755 index 00000000..91c64d93 --- /dev/null +++ b/nonpublic/wecken.php @@ -0,0 +1,77 @@ + + +".Get_Text("pub_wake_beschreibung")?> +

    + +

    + + + + + + + + + + + + + + + + +
    ".Get_Text("pub_wake_del"); ?>
    +

    +

    + +
    + + + + + + + + + + + + + +
    :
    +"> +
    + -- cgit v1.2.3-54-g00ecf