<?php
/**
* @author Bettina Schwarzer, Fritz-Haber-Institut
* @copyright 07/2014
*
* Arbeitsgruppe INSERT/UPDATE DELETE COPY
*/
error_reporting(E_ALL ^ E_NOTICE);
session_start();
if (! isset($_SESSION["userid"]))
{
include_once ("inc/func_lib.inc.php");
login($_SERVER["PHP_SELF"]);
exit;
}
if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("pr",$_SESSION["recht"]) && !in_array("pe",$_SESSION["recht"])))
{
header("Location: start.php");
exit;
}
include_once($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/dbconnect.inc.php");
include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
$ragid = $_GET["i"];
$zeil = $_GET["z"];
if (!$zeil) $zeil = 25; // Anzahl der gezeigten Zeilen
$start = $_GET["st"]; // Start bei DS $start+1
if (!$start) $start=0;
$sort = $_GET["s"]; // Sortierung nach Spalte
$dir = $_GET["d"]; // Sortierrichtung
$fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
$filter = $_GET["b"]; // Filterbegriff
// $_GET-Parameter zurück zur Infoliste mit den selben Einstellungen wie zuvor
$getp = "s=$sort&d=$dir&f=$fnum&b=$filter&st=$start&z=$zeil";
$del = $_POST["del"];
$sub = $_POST["eintragen"];
$dup = $_POST["dup"];
if (!$dup) $dup = $_GET["dp"];
$copy = $_GET["c"];
$rag = $_POST["rag"];
$ok = $_POST["ok"];
if (!$rag["okn"]) $ok = false;
$duptext="";
if ($dup)
{ // Info duplizieren
$tab = "RaumArb_Gruppe";
$key = "rag_ID";
$val = $ragid;
// $ret=1;
$ret = duplicate_record ($tab, $key, $val);
if ($ret)
{
$ragid_new = $ret;
$addr = $_SERVER["PHP_SELF"] . "?i=$ragid_new&c=1&$getp";
header("Location: $addr");
exit;
}
else $duptext = " - Fehler beim Duplizieren von ". $rag["rbez"];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
<title>Edit Arbeitsgruppe</title>
</head>
<body>
<?php
echo " ";
echo "<div class=\"float-br smaller\" valign='top'>";
echo " user: " . $_SESSION["userid"];
echo " <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/reseller_programm.png\" border=\"0\" alt=\"Arbeitsgruppe ändern\" title=\"Arbeitsgruppe ändern\"/></div>\n";
echo "<div align='center'>";
if ($ragid) $text = "editieren"; else $text = "erfassen";
if ($copy) $duptext = " (Kopie)";
echo "<h3>Arbeitsgruppe $text$duptext<h3>";
echo "</div>\n";
if (!$ok || (!$sub && !$del && !$dup))
{
if ($ragid && (!$sub || !$del) && !isset($rag))
{ // update
$sql = "SELECT rag_bez, rag_bezk, abt_ID FROM RaumArb_Gruppe WHERE rag_ID = $ragid";
if ($result = $dbc -> queryObjectArray($sql))
{
foreach ($result as $row)
{
$rag["ragid"] = $ragid;
$rag["ragbez"] = $row->rag_bez;
$rag["ragbezk"] = $row->rag_bezk;
$rag["abt"] = $row->abt_ID;
}
}
}
?>
<div align="center">
<h5>* - Felder sind erforderlich!</h5>
</div>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_ma">
<div align="center">
<table width="65%" border="0" cellspacing="3" cellpadding="3">
<tr><td>Abteilung *</td>
<td valign="top">
<select name="rag[abt]" onchange="this.form.submit();">
<?php
$okn = true;
$sql = "SELECT abt_ID, abt_name, abt_long FROM `fhiiqm`.`Abteilung` ORDER BY abt_ID+0";
if ($result = $dbc->queryObjectArray($sql))
{
foreach ($result as $row)
{
if ($row->abt_ID == $rag['abt'])
echo "<option selected='selected' value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
else
echo "<option value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
}
}
?>
</select>
</td>
</tr>
<tr><td>Arbeitsgruppe *</td>;
<td><input name="rag[ragbez]" type="text" size="50" maxlength="100" value="<?php echo $rag['ragbez']; ?>" />
<?php
if (isset($rag["ragbez"]) && $rag["ragbez"] < "!")
{
echo "<br><span class=\"red\">AG-Bezeichnung ist erforderlich!</span>\n";
$okn = false;
}
?>
</td>
</tr>
<tr><td>Arbeitsgruppe kurz</td>;
<td><input name="rag[ragbezk]" type="text" size="10" maxlength="10" value="<?php echo $rag['ragbezk']; ?>" />
</td>
</tr>
<input type="hidden" name="rag[okn]" value="<?php echo $okn; ?>" />
<input type="hidden" name="rag[ragid]" value="<?php echo $ragid; ?>" />
<?php
if ($sub || $del)
{
if ($sub)
$frage = "Alle Angaben ok?";
elseif ($del)
$frage = "Arbeitsgruppe wirklich löschen?";
echo "<tr>
<td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
<td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
if ($ok) echo "checked=\"checked\"";
echo " /></td>\n</tr>\n";
}
if (!is_null($_SESSION["recht"]) && in_array("pe",$_SESSION["recht"]))
{
echo "
<tr><td> </td>\n
<td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />";
if ($ragid)
{
echo " <input class=\"buttonr\" type=\"submit\" value=\"löschen\" name=\"del\" title=\"delete\" />";
echo " <input class=\"button\" type=\"submit\" value=\"duplizieren\" name=\"dup\" title=\"delete\" />";
}
echo "</td></tr>\n";
}
echo "</table>\n";
echo "</div>\n";
echo "<p class='sc'> <a href=\"rag_flist.php?$getp\" target=\"_self\" title=\"AG-Liste\">« zur AG-Liste</a></p>\n";
echo "</form>\n";
}
else
{
echo "<div align='center'>\n";
if ($del)
{ // loeschn
$sql = "DELETE FROM RaumArb_Gruppe WHERE rag_ID = '$ragid'";
$retdi = $dbc -> execute($sql);
if ($retdi)
{
// Anzeigen geloeschter Infodaten
echo "<p class='green'><b>DELETE: Daten zu '".$rag["ragbez"]."' wurden erfolgreich gelöscht.</b></p>\n";
}
else
{
echo "<p class='red'><b>DELETE: Daten zu '".$rag["ragbez"]."' konnten nicht gelöscht werden!</b></p>\n";
echo "sql = $sql<br />";
echo "error DELETE: " . $dbc->error . "<br />";
}
}
else //INSERT oder UPDATE
{
//daten speichern
$rag["ragbez"] = substr($rag["ragbez"],0,100);
$rag["ragbezk"] = substr($rag["ragbezk"],0,10);
if ($rag["ragbezk"] < "!") $rag["ragbezk"] = null;
if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
$stmt = $dbc -> stmtinit();
if (is_object($stmt))
{
if ($ragid)
{ //UPDATE
$stmt -> prepare("UPDATE fhiiqm.RaumArb_Gruppe SET
rag_bez = ?,
rag_bezk = ?,
abt_ID = ?
WHERE rag_ID = ?");
$stmt -> bind_param('ssii',$rag["ragbez"],$rag["ragbezk"],$rag["abt"],$ragid);
$result = $stmt -> execute();
if ($stmt->error) echo "error UPDATE AG: " . $stmt->error . "<br><br>\n";
}
else
{ //INSERT
$stmt -> prepare ("INSERT INTO RaumArb_Gruppe (rag_bez,rag_bezk,abt_ID) VALUES(?,?,?)");
$stmt -> bind_param('ssi',$rag["ragbez"],$rag["ragbezk"],$rag["abt"]);
$result = $stmt -> execute();
if ($stmt->error) echo "error INSERT AG: " . $stmt->error . "<br><br>\n";
else
{// rag_ID ermitteln
$ragid = $dbc -> insertId();
}
}
}
if ($result) // INSERT/UPDATE Info
{
//Eingabe Daten erfolgreich
echo "<p class='green'><b>AG '".$rag["ragbez"]."' wurde erfolgreich gespeichert.</b></p>\n";
echo "<br /><br />\n";
}
}
echo "</div>";
echo "<p class='sc'> <a href=\"rag_flist.php?$getp\" target=\"_self\" title=\"AG-Liste\">AG-Liste</a></p>\n";
echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"AG erfassen\">Weitere AG erfassen</a></p>\n";
}
?>
</body>
</html>