add total system

git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8

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&auml;ume";
+$header = "Verwaltung der R&auml;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 "&Auml;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&ouml;glichkeit, neue Engeltypen f&uuml;r die Schichtpl&auml;ne einzutragen ".
+		"oder vorhandene abzu&auml;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>&Auml;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&auml;ndern:\n";
+
+	echo "Hier kannst du eintragen, den EngelType &auml;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&ouml;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");
+?>