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/EngelType.php |
add total system
git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'admin/EngelType.php')
-rwxr-xr-x | admin/EngelType.php | 164 |
1 files changed, 164 insertions, 0 deletions
diff --git a/admin/EngelType.php b/admin/EngelType.php new file mode 100755 index 00000000..5e3aef49 --- /dev/null +++ b/admin/EngelType.php @@ -0,0 +1,164 @@ +<?php +$title = "Räume"; +$header = "Verwaltung der Räume"; +include ("./inc/header.php"); +include ("./inc/funktion_user.php"); + +function runSQL( $SQL) +{ + include( "./inc/db.php"); + echo $SQL; + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($SQL, $con); + if ($Erg == 1) { + echo "Änderung wurde gesichert...<br>"; + return 1; + } else { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "<br><br>".mysql_error( $con ). "<br>"; + return 0; + } +} + + +$Sql = "SELECT * FROM `EngelType`"; +$Erg = mysql_query($Sql, $con); + +if( !IsSet($action) ) +{ + echo "Hallo ".$_SESSION['Nick']. + ",<br>\nhier hast du die Möglichkeit, neue Engeltypen für die Schichtpläne einzutragen ". + "oder vorhandene abzuändern:<br><br>\n"; + + echo "<a href=\"./EngelType.php?action=new\">- Neuen EngelType eintragen</a><br>\n"; + + echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; + echo "<tr class=\"contenttopic\">\n"; + + for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) + { + echo "\t<td>". mysql_field_name($Erg, $i). "</td>"; + } + echo "\t<td>Ändern</td>"; + echo "</tr>"; + + for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) + { + echo "\t<tr class=\"content\">\n"; + for ($j = 1; $j < mysql_num_fields($Erg); $j++) + { + echo "\t\t<td>".mysql_result($Erg, $t, $j)."</td>\n"; + } + echo "\t\t<td><a href=\"./EngelType.php?action=change&TID=".mysql_result($Erg, $t, "TID")."\">###</a></td>\n"; + echo "\t</tr>\n"; + } // ende Auflistung Raeume + echo "</table>"; +} +else +{ + +switch ($action) { + +case 'new': + echo "Neuen EngelType einrichten: <br>"; + echo "<form action=\"./EngelType.php\" method=\"POST\">\n"; + echo "<table>\n"; + + for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) + { + echo "<td>".mysql_field_name($Erg, $Uj)."</td>". + "<td><input type=\"text\" size=\"40\" name=\"".mysql_field_name($Erg, $Uj)."\"></td></tr>\n"; + } + echo "</table>\n"; + echo "<input type=\"hidden\" name=\"action\" value=\"newsave\">\n"; + echo "<input type=\"submit\" value=\"sichern...\">\n"; + echo "</form>"; + break; + +case 'newsave': + $vars = $HTTP_POST_VARS; + $count = count($vars) - 1; + $vars = array_splice($vars, 0, $count); + foreach($vars as $key => $value){ + $Keys .= ", `$key`"; + $Values .= ", '$value'"; + } + + if( runSQL( "INSERT INTO `EngelType` (". substr($Keys, 2). ") VALUES (". substr($Values, 2). ")") ) + { + SetHeaderGo2Back(); + + $SQL2 = "SELECT * FROM `EngelType` WHERE `Name`='". $_POST["Name"]. "'"; + $ERG = mysql_query($SQL2, $con); + + if( mysql_num_rows($ERG) == 1) + runSQL( "ALTER TABLE `Room` ADD `DEFAULT_EID_". + mysql_result( $ERG, 0, 0). + "` INT DEFAULT '0' NOT NULL;"); + } + break; + +case 'change': + if (! IsSet($TID)) { + echo "Fehlerhafter Aufruf!"; + } else { + + echo "Raum abändern:\n"; + + echo "Hier kannst du eintragen, den EngelType ändern."; + + echo "<form action=\"./EngelType.php\" method=\"POST\">\n"; + echo "<table>\n"; + + $SQL2 = "SELECT * FROM `EngelType` WHERE `TID`='$TID'"; + $ERG = mysql_query($SQL2, $con); + + for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) + { + echo "<tr><td>".mysql_field_name($ERG, $Uj)."</td>". + "<td><input type=\"text\" size=\"40\" name=\"e".mysql_field_name($ERG, $Uj)."\" ". + "value=\"".mysql_result($ERG, 0, $Uj)."\"></td></tr>\n"; + } + echo "</table>\n"; + echo "<input type=\"hidden\" name=\"eTID\" value=\"$TID\">\n"; + echo "<input type=\"hidden\" name=\"action\" value=\"changesave\">\n"; + echo "<input type=\"submit\" value=\"sichern...\">\n"; + echo "</form>"; + echo "<form action=\"./EngelType.php\" method=\"POST\">\n"; + echo "<input type=\"hidden\" name=\"TID\" value=\"$TID\">\n"; + echo "<input type=\"hidden\" name=\"action\" value=\"delete\">\n"; + echo "<input type=\"submit\" value=\"Löschen...\">"; + echo "</form>"; + } + break; + +case 'changesave': + $vars = $HTTP_POST_VARS; + $count = count($vars) - 2; + $vars = array_splice($vars, 0, $count); + foreach($vars as $key => $value){ + $keys = substr($key,1); + $sql .= ", `".$keys."`='".$value."'"; + + } + runSQL( "UPDATE `EngelType` SET ". substr($sql, 2). " WHERE `TID`='".$eTID."'"); + SetHeaderGo2Back(); + break; + +case 'delete': + if (IsSet($TID)) + { + runSQL( "DELETE FROM `EngelType` WHERE `TID`='$TID'"); + runSQL( "ALTER TABLE `Room` DROP `DEFAULT_EID_$TID`;"); + } else { + echo "Fehlerhafter Aufruf"; + } + SetHeaderGo2Back(); + break; + +} +} + + +include ("./inc/footer.php"); +?> |