summaryrefslogtreecommitdiff
path: root/www-ssl/admin/shiftadd.php
diff options
context:
space:
mode:
Diffstat (limited to 'www-ssl/admin/shiftadd.php')
-rw-r--r--[-rwxr-xr-x]www-ssl/admin/shiftadd.php518
1 files changed, 259 insertions, 259 deletions
diff --git a/www-ssl/admin/shiftadd.php b/www-ssl/admin/shiftadd.php
index 7c64543f..34c248fa 100755..100644
--- a/www-ssl/admin/shiftadd.php
+++ b/www-ssl/admin/shiftadd.php
@@ -6,61 +6,61 @@ include ("../../../camp2011/includes/header.php");
$Time = time()+3600+3600;
-echo "Hallo ".$_SESSION['Nick'].",<br>\n";
+echo "Hallo ".$_SESSION['Nick'].",<br />\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);
+ $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");
- }
+ 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);
+ $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");
- }
+ 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";
+ $_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";
+ $_GET["NachtON"] = "OFF";
if( !isset($_GET["MoreThenOne"]))
- $_GET["MoreThenOne"] = "OFF";
+ $_GET["MoreThenOne"] = "OFF";
if( isset( $_GET["SchichtName"]))
{
- foreach ($_GET as $k => $v)
- {
- $_SESSION['shiftadd.php'][$k] = $v;
- }
+ foreach ($_GET as $k => $v)
+ {
+ $_SESSION['shiftadd.php'][$k] = $v;
+ }
}
if (!IsSet($_GET["action"]))
- $_GET["action"] = "new";
+ $_GET["action"] = "new";
switch( $_GET["action"])
{
@@ -70,187 +70,187 @@ Hier kannst du neue Schichten eintragen. Dazu musst du den Anfang und das Ende d
&Uuml;ber die L&auml;nge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch k&ouml;nnen gleich
mehrere Schichten auf einmal erfasst werden:
-<form action="<?PHP echo $_SERVER['SCRIPT_NAME']; ?>" >
+<form action="<?php echo $_SERVER['SCRIPT_NAME']; ?>" >
<table>
<tr>
<td align="right">Name:</td>
- <td><input type="text" name="SchichtName" size="50" value="<?PHP echo $_SESSION["shiftadd.php"]["SchichtName"]; ?>"></td>
+ <td><input type="text" name="SchichtName" size="50" value="<?php echo $_SESSION["shiftadd.php"]["SchichtName"]; ?>"></td>
</tr>
<tr>
<td align="right">Ort:</td>
<td><select name="RID">
-<?PHP
- foreach ($Room As $RTemp)
- {
- echo "\t<option value=\"". $RTemp["RID"]. "\"";
- if( $RTemp["RID"] == $_SESSION["shiftadd.php"]["RID"])
- echo " SELECTED";
- echo ">". $RTemp["Name"]. "</option>\n";
- }
- ?>
+<?php
+ foreach ($Room As $RTemp)
+ {
+ echo "\t<option value=\"". $RTemp["RID"]. "\"";
+ if( $RTemp["RID"] == $_SESSION["shiftadd.php"]["RID"])
+ echo " SELECTED";
+ echo ">". $RTemp["Name"]. "</option>\n";
+ }
+ ?>
</select></td>
</tr>
<tr><td><u>Zeit:</u></td></tr>
<tr>
<td align="right">Month.Jahr:</td>
- <td><input type="ext" name="MonthJahr" size="7" value="<?PHP echo $_SESSION["shiftadd.php"]["MonthJahr"]; ?>"></td>
+ <td><input type="ext" name="MonthJahr" size="7" value="<?php echo $_SESSION["shiftadd.php"]["MonthJahr"]; ?>"></td>
</tr>
<tr>
<td align="right">Beginn:</td>
- <td>Date<input type="text" name="SDatum" size="5" value="<?PHP echo $_SESSION["shiftadd.php"]["SDatum"]; ?>">
- Time<input type="text" name="STime" size="5" value="<?PHP echo $_SESSION["shiftadd.php"]["STime"]; ?>"></td>
+ <td>Date<input type="text" name="SDatum" size="5" value="<?php echo $_SESSION["shiftadd.php"]["SDatum"]; ?>">
+ Time<input type="text" name="STime" size="5" value="<?php echo $_SESSION["shiftadd.php"]["STime"]; ?>"></td>
</tr>
<tr>
<td align="right">More then One</td>
- <td><input type="checkbox" name="MoreThenOne" value="ON" <?PHP
- if( $_SESSION["shiftadd.php"]["MoreThenOne"]=="ON")
- echo " CHECKED";
- ?>></td>
+ <td><input type="checkbox" name="MoreThenOne" value="ON" <?php
+ if( $_SESSION["shiftadd.php"]["MoreThenOne"]=="ON")
+ echo " CHECKED";
+ ?>></td>
</tr>
<tr>
<td align="right">End:</td>
- <td>Date<input type="text" name="EDatum" size="5" value="<?PHP echo $_SESSION["shiftadd.php"]["EDatum"]; ?>">
- Time<input type="text" name="ETime" size="5" value="<?PHP echo $_SESSION["shiftadd.php"]["ETime"]; ?>"></td>
+ <td>Date<input type="text" name="EDatum" size="5" value="<?php echo $_SESSION["shiftadd.php"]["EDatum"]; ?>">
+ Time<input type="text" name="ETime" size="5" value="<?php echo $_SESSION["shiftadd.php"]["ETime"]; ?>"></td>
</tr>
<tr>
<td align="right">L&auml;nge in h:</td>
- <td><input type="text" name="len" size="5" value="<?PHP echo $_SESSION["shiftadd.php"]["len"]; ?>"></td>
+ <td><input type="text" name="len" size="5" value="<?php echo $_SESSION["shiftadd.php"]["len"]; ?>"></td>
</tr>
<tr>
<td align="right">Sonderschichten ein:</td>
- <td><input type="checkbox" name="NachtON" value="ON" <?PHP
- if($_SESSION["shiftadd.php"]["NachtON"]=="ON")
- echo " CHECKED";
- ?>></td>
+ <td><input type="checkbox" name="NachtON" value="ON" <?php
+ if($_SESSION["shiftadd.php"]["NachtON"]=="ON")
+ echo " CHECKED";
+ ?>></td>
</tr>
<tr>
<td align="right">Sonder in h (Time;Time):</td>
- <td><input type="text" name="len_night" size="50" value="<?PHP echo $_SESSION["shiftadd.php"]["len_night"]; ?>"></td>
+ <td><input type="text" name="len_night" size="50" value="<?php echo $_SESSION["shiftadd.php"]["len_night"]; ?>"></td>
</tr>
<tr><td><u>Anzahl Engel je Type:</u></td></tr>
-<?PHP
- foreach ($EngelType As $TTemp)
- {
- echo " <tr><td align=\"right\">". $TTemp["Name"]. ":</td>\n";
- echo " <td><input type=\"text\" name=\"EngelType". $TTemp["TID"]. "\" size=\"5\" value=\"";
- if( isset($_SESSION["shiftadd.php"][ "EngelType". $TTemp["TID"] ]))
- echo $_SESSION["shiftadd.php"][ "EngelType". $TTemp["TID"] ];
- else
- echo "0";
- echo "\"></td>\n";
- }
+<?php
+ foreach ($EngelType As $TTemp)
+ {
+ echo " <tr><td align=\"right\">". $TTemp["Name"]. ":</td>\n";
+ echo " <td><input type=\"text\" name=\"EngelType". $TTemp["TID"]. "\" size=\"5\" value=\"";
+ if( isset($_SESSION["shiftadd.php"][ "EngelType". $TTemp["TID"] ]))
+ echo $_SESSION["shiftadd.php"][ "EngelType". $TTemp["TID"] ];
+ else
+ echo "0";
+ echo "\"></td>\n";
+ }
?>
</table>
- <br>
+ <br />
<input type="hidden" name="OnlyShow" value="ON">
<input type="hidden" name="action" value="newsave">
<input type="submit" value="zeig mal Gabriel!">
</form>
-<?PHP
- break; // Ende new
+<?php
+ break; // Ende new
case 'newsave':
if (isset($_GET["SDatum"]) && ($_GET["len"] > 0))
{
- $lenOrg = $_GET["len"];
- if( $_GET["NachtON"] == "ON" )
- {
- $lenArrayDummy = explode( "-", $_GET["len_night"]);
+ $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 "<table border=\"1\">\n";
- echo "<tr>\n";
- echo "\t<td valign=\"top\" align=\"center\">Start</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">End</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">len</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">RID</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">Beschreibung</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">Entry 'Shifts'</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">SID</td>\n";
- echo "\t<td valign=\"top\" align=\"center\">Entrys</td>\n";
- echo "</tr>\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 "</table>";
-
- if( $_GET["OnlyShow"]=="ON" )
- {
- echo "<form action=\"". $_SERVER['SCRIPT_NAME']. "\">";
- echo "\n\t<Input type=\"hidden\" name=\"SchichtName\" value=\"". $_GET["SchichtName"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"MonthJahr\" value=\"". $_GET["MonthJahr"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"SDatum\" value=\"". $_GET["SDatum"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"STime\" value=\"". $_GET["STime"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"MoreThenOne\" value=\"". $_GET["MoreThenOne"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"EDatum\" value=\"". $_GET["EDatum"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"ETime\" value=\"". $_GET["ETime"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"len\" value=\"". $lenOrg. "\">";
- echo "\n\t<input type=\"hidden\" name=\"RID\" value=\"". $_GET["RID"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"NachtON\" value=\"". $_GET["NachtON"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"len_night\" value=\"". $_GET["len_night"]. "\">";
- echo "\n\t<input type=\"hidden\" name=\"OnlyShow\" value=\"OFF\">";
- foreach ($EngelType As $TTemp)
- {
- $Temp = "EngelType".$TTemp["TID"];
- echo "\n\t<input type=\"hidden\" name=\"". $Temp. "\" value=\"". $_GET[$Temp]. "\">";
- }
- echo "\n\t<input type=\"hidden\" name=\"action\" value=\"newsave\">";
- echo "\n\t<input type=\"submit\" value=\"mach mal Gabriel!\">";
- echo "\n</form>";
- } //if
+ if( isset($Temp2) )
+ $lenArray[intval($Temp2)] = intval($Temp)-intval($Temp2);
+ $Temp2 = $Temp;
+ }//foreach
+ }//IF( $NachtON == "ON" )
+
+ echo "<table border=\"1\">\n";
+ echo "<tr>\n";
+ echo "\t<td valign=\"top\" align=\"center\">Start</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">End</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">len</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">RID</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">Beschreibung</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">Entry 'Shifts'</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">SID</td>\n";
+ echo "\t<td valign=\"top\" align=\"center\">Entrys</td>\n";
+ echo "</tr>\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 "</table>";
+
+ if( $_GET["OnlyShow"]=="ON" )
+ {
+ echo "<form action=\"". $_SERVER['SCRIPT_NAME']. "\">";
+ echo "\n\t<Input type=\"hidden\" name=\"SchichtName\" value=\"". $_GET["SchichtName"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"MonthJahr\" value=\"". $_GET["MonthJahr"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"SDatum\" value=\"". $_GET["SDatum"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"STime\" value=\"". $_GET["STime"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"MoreThenOne\" value=\"". $_GET["MoreThenOne"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"EDatum\" value=\"". $_GET["EDatum"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"ETime\" value=\"". $_GET["ETime"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"len\" value=\"". $lenOrg. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"RID\" value=\"". $_GET["RID"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"NachtON\" value=\"". $_GET["NachtON"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"len_night\" value=\"". $_GET["len_night"]. "\">";
+ echo "\n\t<input type=\"hidden\" name=\"OnlyShow\" value=\"OFF\">";
+ foreach ($EngelType As $TTemp)
+ {
+ $Temp = "EngelType".$TTemp["TID"];
+ echo "\n\t<input type=\"hidden\" name=\"". $Temp. "\" value=\"". $_GET[$Temp]. "\">";
+ }
+ echo "\n\t<input type=\"hidden\" name=\"action\" value=\"newsave\">";
+ echo "\n\t<input type=\"submit\" value=\"mach mal Gabriel!\">";
+ echo "\n</form>";
+ } //if
} //IF
break;
case 'engeldel':
- break;
+ break;
} // end switch
@@ -258,100 +258,100 @@ case 'engeldel':
function CreateNewEntry()
{
- global $con, $_DateS, $_DateE, $EngelType, $DEBUG;
- foreach ($EngelType As $TTemp)
- {
- $Temp = "EngelType".$TTemp["TID"];
- global $$Temp;
- }
-
- echo "<tr>\n";
-
- echo "\t<td>$_DateS</td>\n";
- echo "\t<td>$_DateE</td>\n";
- echo "\t<td>". $_GET["len"]. "</td>\n";
- echo "\t<td>". $_GET["RID"]. "</td>\n";
- echo "\t<td>". $_GET["SchichtName"]. "</td>\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 "\t<td>exists</td>";
- 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<br>[".$SQL. "]";
-
- if ($Erg == 1) echo "\t<td>pass</td>\n";
- else echo "\t<td>fail <br>\n<u>". mysql_error($con). "</u>$SQLFail</td>\n";
-
- } else
- echo "\t<td>only show</td>\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<td>?</td>";
- else
- {
- $SID = mysql_result($Erg, 0, "SID");
- echo "\t<td>". $SID. "</td>";
- }
-
- // erstellt für jeden Engeltypen die eintrage in 'ShiftEntry'
- echo "\t<td>";
- foreach ($EngelType As $TTemp)
- {
- $Temp = "EngelType".$TTemp["TID"];
-
- if( $_GET[$Temp] > 0 )
- {
- $i = 0;
- echo $_GET[$Temp]. " ".$TTemp["Name"]. "<br>\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<br>[".$SQL. "]";
-
- if ($Erg == 1) echo "'pass' ";
- else echo "'fail' <u>". mysql_error($con). "</u>$SQLFail</td>\n";
-
- }
- else
- echo "+";
- }
- echo "<br>";
- } // IF $$TEMP
- } // FOREACH
- echo "</td>";
-
- echo "</tr>\n";
+ global $con, $_DateS, $_DateE, $EngelType, $debug;
+ foreach ($EngelType As $TTemp)
+ {
+ $Temp = "EngelType".$TTemp["TID"];
+ global $$Temp;
+ }
+
+ echo "<tr>\n";
+
+ echo "\t<td>$_DateS</td>\n";
+ echo "\t<td>$_DateE</td>\n";
+ echo "\t<td>". $_GET["len"]. "</td>\n";
+ echo "\t<td>". $_GET["RID"]. "</td>\n";
+ echo "\t<td>". $_GET["SchichtName"]. "</td>\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 "\t<td>exists</td>";
+ 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<br />[".$SQL. "]";
+
+ if ($Erg == 1) echo "\t<td>pass</td>\n";
+ else echo "\t<td>fail <br />\n<u>". mysql_error($con). "</u>$SQLFail</td>\n";
+
+ } else
+ echo "\t<td>only show</td>\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<td>?</td>";
+ else
+ {
+ $SID = mysql_result($Erg, 0, "SID");
+ echo "\t<td>". $SID. "</td>";
+ }
+
+ // erstellt für jeden Engeltypen die eintrage in 'ShiftEntry'
+ echo "\t<td>";
+ foreach ($EngelType As $TTemp)
+ {
+ $Temp = "EngelType".$TTemp["TID"];
+
+ if( $_GET[$Temp] > 0 )
+ {
+ $i = 0;
+ echo $_GET[$Temp]. " ".$TTemp["Name"]. "<br />\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<br />[".$SQL. "]";
+
+ if ($Erg == 1) echo "'pass' ";
+ else echo "'fail' <u>". mysql_error($con). "</u>$SQLFail</td>\n";
+
+ }
+ else
+ echo "+";
+ }
+ echo "<br />";
+ } // IF $$TEMP
+ } // FOREACH
+ echo "</td>";
+
+ echo "</tr>\n";
}
include ("../../../camp2011/includes/footer.php");