diff options
author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-09-10 17:25:43 +0000 |
---|---|---|
committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-09-10 17:25:43 +0000 |
commit | 310c2ce98fc8c0e94559c9ed8587101d92f6e853 (patch) | |
tree | 7093065a133e434fb7e551803e8700661d04c5bb /admin/shiftadd.php |
add total system
git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'admin/shiftadd.php')
-rwxr-xr-x | admin/shiftadd.php | 322 |
1 files changed, 322 insertions, 0 deletions
diff --git a/admin/shiftadd.php b/admin/shiftadd.php new file mode 100755 index 00000000..e8c1702d --- /dev/null +++ b/admin/shiftadd.php @@ -0,0 +1,322 @@ +<?php +$title = "Schicht Hinzufügen"; +$header = "Neue Schichten erfassen"; + +include ("./inc/header.php"); +include ("./inc/funktion_user.php"); + +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); + + 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"); + } + + +if (!IsSet($action)) + $action = "new"; + +switch ($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: + +<form action="<? echo $_SERVER['SCRIPT_NAME']; ?>" > + <table> + <tr> + <td align="right">Name:</td> + <td><input type="text" name="SchichtName" size="50" value="--???--"></td> + </tr> + <tr> + <td align="right">Ort:</td> + <td><select name="RID"> + <? + foreach ($Room As $RTemp) + echo "\t<option value=\"". $RTemp["RID"]. "\">". $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="2004-12"></td> + </tr> + <tr> + <td align="right">Beginn:</td> + <td>Date<input type="text" name="SDatum" size="5" value="27"> + Time<input type="text" name="STime" size="5" value="10"></td> + </tr> + <tr> + <td align="right">More then One</td> + <td><input type="checkbox" name="MoreThenOne" value="ON" checked></td> + </tr> + <tr> + <td align="right">End:</td> + <td>Date<input type="text" name="EDatum" size="5" value="29"> + Time<input type="text" name="ETime" size="5" value="12"></td> + </tr> + <tr> + <td align="right">Länge in h:</td> + <td><input type="text" name="len" size="5" value="2"> (max 24h)</td> + </tr> + <tr> + <td align="right">Sonderschichten ein:</td> + <td><input type="checkbox" name="NachtON" value="ON"></td> + </tr> + <tr> + <td align="right">Sonder in h (Time;Time):</td> + <td><input type="text" name="len_night" size="50" value="0;4;8;10;12;14;16;18;20;22;24"></td> + </tr> + + <tr><td><u>Anzahl Engel je Type:</u></td></tr> +<? + 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=\"0\"></td>\n"; + } +?> +</table> + <br> +<input type="hidden" name="OnlyShow" value="ON"> +<input type="hidden" name="action" value="newsave"> +<input type="submit" value="zeig mal Gabriel!"> +</form> + +<? + break; // Ende new + +case 'newsave': + if (isset($SDatum) && ($len > 0)) { + $lenOrg = $len; + if( $NachtON == "ON" ) + { + $lenArrayDummy = explode( ";", $len_night); + foreach ( $lenArrayDummy as $Temp ) + { + if( isset($Temp2) ) + { + $lenArray[$Temp2] = $Temp-$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 = $SDatum; + $TimeEnd = $STime; + do { + // define Start time + $Date = $DateEnd; + $Time = $TimeEnd; + $_DateS = $MonthJahr. "-". $Date. " ". $Time. ":00:00"; + + // define End time + if( $NachtON == "ON" ) + { + $len = $lenArray[$Time]; + } + $TimeEnd = $Time+ $len; + + //Tagesüberschreitung + while( $TimeEnd >= 24 ) + { + $TimeEnd -= 24; + $DateEnd += 1; + } + //ist schischt zu lang dan verkürzen + if( $DateEnd > $EDatum || ($DateEnd == $EDatum && $TimeEnd >= $ETime) ) + { + $len -= ($DateEnd- $EDatum)*24; + $len -= ($TimeEnd- $ETime); // -(-) ->> + + $DateEnd = $EDatum; + $TimeEnd = $ETime; + } + $_DateE = $MonthJahr. "-". $DateEnd. " ". $TimeEnd. ":00:00"; + + if( $_DateS != $_DateE ) + CreateNewEntry(); + + if( $MoreThenOne!="ON" ) break; + if( $DateEnd == $EDatum && $TimeEnd >= $ETime ) break; + } while( true ); + echo "</table>"; + + if( $OnlyShow!="" ) + { + echo "<form action=\"". $_SERVER['SCRIPT_NAME']. "\">"; + echo "\n\t<Input type=\"hidden\" name=\"SchichtName\" value=\"$SchichtName\">"; + echo "\n\t<input type=\"hidden\" name=\"MonthJahr\" value=\"$MonthJahr\">"; + echo "\n\t<input type=\"hidden\" name=\"SDatum\" value=\"$SDatum\">"; + echo "\n\t<input type=\"hidden\" name=\"STime\" value=\"$STime\">"; + echo "\n\t<input type=\"hidden\" name=\"MoreThenOne\" value=\"$MoreThenOne\">"; + echo "\n\t<input type=\"hidden\" name=\"EDatum\" value=\"$EDatum\">"; + echo "\n\t<input type=\"hidden\" name=\"ETime\" value=\"$ETime\">"; + echo "\n\t<input type=\"hidden\" name=\"len\" value=\"$lenOrg\">"; + echo "\n\t<input type=\"hidden\" name=\"RID\" value=\"$RID\">"; + echo "\n\t<input type=\"hidden\" name=\"NachtON\" value=\"$NachtON\">"; + echo "\n\t<input type=\"hidden\" name=\"len_night\" value=\"$len_night\">"; + echo "\n\t<input type=\"hidden\" name=\"OnlyShow\" value=\"\">"; + foreach ($EngelType As $TTemp) + { + $Temp = "EngelType".$TTemp["TID"]; + echo "\n\t<input type=\"hidden\" name=\"". $Temp. "\" value=\"".$$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; + +} // end switch + + + +function CreateNewEntry() +{ + global $con, $_DateS, $_DateE, $len, $RID, $SchichtName, $OnlyShow, $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>$len</td\n>"; + echo "\t<td>$RID</td>\n"; + echo "\t<td>$SchichtName</td>\n"; + + + // Ist eintarg schon vorhanden? + $SQL = "SELECT SID FROM `Shifts` "; + $SQL .= "WHERE (". + "`DateS` = '". $_DateS. "' AND ". + "`DateE` = '". $_DateE. "' AND ". + "`RID` = '". $RID. "');"; + $Erg = mysql_query($SQL, $con); + + if( mysql_num_rows($Erg) != 0 ) + echo "\t<td>exists</td>"; + elseif( $OnlyShow == "" ) + { + //Suchet nach letzter SID + $SQLin = "SELECT `SID` FROM `Shifts` ". + "WHERE NOT (`FromPentabarf` = 'Y') ". + "ORDER BY `SID` DESC"; + $Ergin = mysql_query($SQLin, $con); + if( mysql_num_rows( $Ergin) > 0) + $newSID = mysql_result( $Ergin, 0, 0)+1; + else + $newSID = 10000; + + // erstellt Eintrag in Shifts für die algemeine schicht + $SQL = "INSERT INTO `Shifts` (`SID`, `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ('$newSID', "; + $SQL .= "'". $_DateS. "', '". $_DateE. "', "; + $SQL .= "'". $len. "', '". $RID. "', "; + $SQL .= "'". $SchichtName. "');"; + $Erg = mysql_query($SQL, $con); + + $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` = '". $len. "' AND ". + "`RID` = '". $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( $$Temp > 0 ) + { + $i = 0; + echo $$Temp. " ".$TTemp["Name"]. "<br>\t"; + while( $i++ < $$Temp ) + { + $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES ("; + $SQL .= "'$SID', "; + $SQL .= "'". $TTemp["TID"]. "');"; + + if( $OnlyShow == "" ) + { + $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 "'only show' "; + } + echo "<br>"; + } // IF $$TEMP + } // FOREACH + echo "</td>"; + + + echo "</tr>\n"; +} + +include ("./inc/footer.php"); +?> |