--- a/fhiiqm/prozess_ed.php Fri Dec 21 15:31:50 2012 +0100
+++ b/fhiiqm/prozess_ed.php Wed Feb 27 09:43:08 2013 +0100
@@ -93,7 +93,18 @@
}
else {
var newdiv = document.createElement('div');
- newdiv.innerHTML = "<input type='text' name='pz[step][]' size='50' maxlength='50' />";
+ var opt="<option value='-1'></option>";
+ var i;
+ for (var key in arr)
+ {
+ opt = opt.concat("<option value='",key,"'>",arr[key],"</option>\n" );
+ }
+ opt += "</select>\n";
+ newdiv.innerHTML = "<span></span><input type='text' name='pz[step][]' size='50' maxlength='50' />";
+ newdiv.innerHTML += " Status <select name='pz[ststat][]'>"+opt;
+ newdiv.innerHTML += "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />";
+ newdiv.innerHTML += "<br /> Bemerkung zu Schritt ";
+ newdiv.innerHTML += "<input type='text' name='pz[stbem][]' size='50' maxlength='50' />";
document.getElementById(divId).appendChild(newdiv);
counter++;
}
@@ -102,18 +113,18 @@
// var kn = document.getElementById(divId).lastChild;
// document.getElementById(divId).removeChild(kn);
var kn = document.getElementById(divId);
- while (kn.childNodes.length>0 && kn.lastChild.nodeName != "INPUT" && kn.lastChild.nodeName != "A")
+ while (kn.childNodes.length>0 && kn.lastChild.nodeName != "SPAN" && kn.lastChild.nodeName != "A")
{
//alert ("vor "+kn.lastChild.nodeName+", nodetyp = "+ kn.lastChild.nodeType);
var knc = kn.lastChild;
document.getElementById(divId).removeChild(knc);
}
- if (kn.lastChild.nodeName == "INPUT") document.getElementById(divId).removeChild(kn.lastChild);
+ if (kn.lastChild.nodeName == "SPAN") document.getElementById(divId).removeChild(kn.lastChild);
}
//-->
</script>
- <title>Edit Prozess</title>
+ <title>Edit Projekt</title>
</head>
<body>
@@ -177,13 +188,13 @@
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=\"img/sheduled_task.png\" border=\"0\" alt=\"Prozess ändern\" title=\"Prozess ändern\"/></div>\n";
+ echo "<div class=\"float-r\"><img src=\"img/sheduled_task.png\" border=\"0\" alt=\"Projekt ändern\" title=\"Projekt ändern\"/></div>\n";
echo "<div align='center'>";
if ($pzid) $text = "editieren"; else $text = "erfassen";
if ($copy) $duptext = " (Kopie)";
- echo "<h3>Prozess $text$duptext<h3>";
+ echo "<h3>Projekt $text$duptext<h3>";
echo "</div>\n";
@@ -225,11 +236,15 @@
}
}
// Daten aus Proz_Step
- $sql = "SELECT proz_step FROM Proz_Step WHERE proz_ID = $pzid ORDER BY proz_step_ID";
+ $sql = "SELECT proz_step,step_stat_ID,step_bem FROM Proz_Step WHERE proz_ID = $pzid ORDER BY proz_step_ID";
if ($ress = $dbc -> queryObjectArray($sql))
{
foreach ($ress as $row)
- $pz["step"][] = $row->proz_step;
+ {
+ $pz["step"][] = $row->proz_step;
+ $pz["ststat"][] = $row->step_stat_ID;
+ $pz["stbem"][] = $row->step_bem;
+ }
}
}
@@ -239,7 +254,7 @@
if ($sub)
$frage = "Alle Angaben ok?";
elseif ($del)
- $frage = "Prozess wirklich löschen?";
+ $frage = "Projekt wirklich löschen?";
echo "<tr>
<td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
<td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
@@ -261,7 +276,7 @@
echo "</table>\n";
echo "</div>\n";
// if (!is_null($_SESSION["recht"]) && !in_array("le", $_SESSION["recht"]))
- echo "<p class='sc'> <a href=\"prozess_flist.php\" target=\"_self\" title=\"Prozessliste\">« zur Prozessliste</a></p>\n";
+ echo "<p class='sc'> <a href=\"prozess_flist.php\" target=\"_self\" title=\"Projektliste\">« zur Projektliste</a></p>\n";
echo "</form>\n";
}
else
@@ -281,7 +296,7 @@
{
echo "<p class='red'><b>DELETE: Daten zu '".$pz["bez"]."', ID = '$pzid' konnten nicht gelöscht werden!</b></p>\n";
if (strpos($dbc->error,'1451') !== false)
- echo "error DELETE: Es gibt mindestens einen abhängigen Prozess zu Prozess-ID '$pzid'<br />";
+ echo "error DELETE: Es gibt mindestens einen abhängiges Projekt zu Projekt-ID '$pzid'<br />";
else
{
echo "sql = $sql<br />";
@@ -305,7 +320,8 @@
if ($pz["pkost"]) $pz["pkost"] = dbformat_wert($pz["pkost"]); else $pz["pkost"] = null;
if ($pz["urg"] == -1) $pz["urg"] = null;
if ($pz["stat"] == -1) $pz["stat"] = null;
- if ($pz["pzref"] == -1) $pz["pzref"] = null;
+ if ($pz["pzref"] == -1) $pz["pzref"] = null;
+ if ($pz["prid"] < 1) $pz["prid"] = null;
if ($pz["pers"] < "!") $pz["persknr"] = null;
if ($pz["persa"] < "!") $pz["persknra"] = null;
@@ -336,7 +352,7 @@
$stmt -> bind_param('issssdssdiiiisi',$pz["prid"],$pz["bez"],$pz["bezl"],$pz["sdat"],$pz["edat"],$pz["kost"],$pz["psdat"],$pz["pedat"],$pz["pkost"],
$pz["urg"],$pz["stat"],$pz["persknr"],$pz["pzref"],$pz["bem"],$pz["persknra"]);
$result = $stmt -> execute();
- if ($stmt->error) echo "error UPDATE Prozess: " . $stmt->error . "<br><br>\n";
+ if ($stmt->error) echo "error UPDATE Projekt: " . $stmt->error . "<br><br>\n";
}
else
@@ -346,7 +362,7 @@
$stmt -> bind_param('issssdssdiiiisi',$pz["prid"],$pz["bez"],$pz["bezl"],$pz["sdat"],$pz["edat"],$pz["kost"],$pz["psdat"],$pz["pedat"],$pz["pkost"],
$pz["urg"],$pz["stat"],$pz["persknr"],$pz["pzref"],$pz["bem"],$pz["persknra"]);
$result = $stmt -> execute();
- if ($stmt->error) echo "error INSERT Prozess: " . $stmt->error . "<br><br>\n";
+ if ($stmt->error) echo "error INSERT Projekt: " . $stmt->error . "<br><br>\n";
if ($result)
{ // INSERT o.k.
// info_ID ermitteln
@@ -359,25 +375,27 @@
$retd = $dbc -> execute($sql);
if ($retd)
{
- $stmt -> prepare("INSERT INTO Proz_Step (proz_ID,proz_step) VALUES(?,?)");
+ $stmt -> prepare("INSERT INTO Proz_Step (proz_ID,proz_step,step_stat_ID,step_bem) VALUES(?,?,?,?)");
for ($k=0; $k<count($pz["step"]); $k++)
{
if ($pz["step"][$k])
{
- $stmt -> bind_param('is',$pzid, $pz["step"][$k]);
+ if ($pz["ststat"][$k] == -1) $pz["ststat"][$k] = null;
+ if ($pz["stbem"][$k] < "!") $pz["stbem"][$k] = null;
+ $stmt -> bind_param('isis',$pzid, $pz["step"][$k], $pz["ststat"][$k], $pz["stbem"][$k]);
$rets = $stmt -> execute();
if (!$rets) $rets = false;
}
}
- if (!$rets) echo "error INSERT Prozess-Schritt: $stmt->error<br />\n";
+ if (!$rets) echo "error INSERT Projekt-Schritt: $stmt->error<br />\n";
}
- else echo "error INSERT Prozess-Schritt: $dbc->error<br />\n";
+ else echo "error INSERT Projekt-Schritt: $dbc->error<br />\n";
}
}
if ($result && $rets)
{
- echo "<p class='green'><b>Prozess '".$pz["bez"]."' mit ID '$pzid' wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<p class='green'><b>Projekt '".$pz["bez"]."' mit ID '$pzid' wurden erfolgreich gespeichert.</b></p>\n";
include ("inc/prozess_dat_show.inc.php");
}
else
@@ -385,7 +403,7 @@
}
echo "</div>";
- echo "<p class='sc'> <a href=\"prozess_flist.php\" target=\"_self\" title=\"Prozessliste\">« zur Prozessliste</a></p>\n";
+ echo "<p class='sc'> <a href=\"prozess_flist.php\" target=\"_self\" title=\"Projektliste\">« zur Projektliste</a></p>\n";
}
echo "</body>\n</html>\n";
?>
\ No newline at end of file