IQM: comparison fhiiqm/prozess

equal deleted inserted replaced

-:f1a8785434e4
+:fc60ef80a7ad
 if (counter == limit)  {
 alert("Das Limit von " + counter + " zusätzlichen inputs ist erreicht");
 }
 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 += "&nbsp;&nbsp;&nbsp;&nbsp;Status&nbsp;&nbsp;&nbsp;<select name='pz[ststat][]'>"+opt;
+newdiv.innerHTML += "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />";
+newdiv.innerHTML += "<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bemerkung zu Schritt&nbsp;&nbsp;&nbsp;";
+newdiv.innerHTML += "<input type='text' name='pz[stbem][]' size='50' maxlength='50' />";
 document.getElementById(divId).appendChild(newdiv);
 counter++;
 }
 }
 function delInput(divId){
 //          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>
 <script>
 <?php
 echo "&nbsp;";
 echo "<div class=\"float-br smaller\" valign='top'>";
 echo "&nbsp;&nbsp;&nbsp;user: " . $_SESSION["userid"];
 echo "&nbsp;&nbsp;&nbsp;<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 &auml;ndern\" title=\"Prozess &auml;ndern\"/></div>\n";
+echo "<div class=\"float-r\"><img src=\"img/sheduled_task.png\" border=\"0\" alt=\"Projekt &auml;ndern\" title=\"Projekt &auml;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";
 if (!$ok || (!$sub && !$del && !$dup))
 {
 $pz["persa"] = $row->ama;
 $pz["pers"] = $row->vma;
 }
 }
 // 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;
+}
 }
 }
 include($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/prozess_form.inc.php");
 if ($sub || $del)
 		{
 		  	if ($sub)
 $frage = "Alle Angaben ok?";
 elseif ($del)
-$frage = "Prozess wirklich l&ouml;schen?";
+$frage = "Projekt wirklich l&ouml;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";
 	echo "</td></tr>\n";
 }
 echo "</table>\n";
 echo "</div>\n";
 //            if (!is_null($_SESSION["recht"]) && !in_array("le", $_SESSION["recht"]))
-echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"prozess_flist.php\" target=\"_self\" title=\"Prozessliste\">&laquo; zur Prozessliste</a></p>\n";
+echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"prozess_flist.php\" target=\"_self\" title=\"Projektliste\">&laquo; zur Projektliste</a></p>\n";
 echo "</form>\n";
 }
 else
 {
 echo "<div align='center'>\n";
 }
 else
 {
 echo "<p class='red'><b>DELETE: Daten  zu '".$pz["bez"]."', ID = '$pzid'  konnten nicht gel&ouml;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 />";
 echo "error DELETE: " . $dbc->error . "<br />";
 }
 if ($pz["pedat"] == "") $pz["pedat"] = null;
 if ($pz["kost"]) $pz["kost"] = dbformat_wert($pz["kost"]); else $pz["kost"] = null;
 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["prid"] < 1) $pz["prid"] = null;
 if ($pz["pers"] < "!") $pz["persknr"] = null;
 if ($pz["persa"] < "!") $pz["persknra"] = null;
 if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
 proz_bem = ?,
 persknr_a = ?  WHERE proz_ID = $pzid");
 $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
 {   //INSERT
 $stmt -> prepare ("INSERT INTO Prozess (produkt_ID, proz_bez, proz_bez_l, proz_start, proz_end, proz_kosten, proz_start_pl, proz_end_pl, proz_kost_pl,
 proz_urg_ID, proz_stat_ID, persknr, proz_ref_ID, proz_bem, persknr_a) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
 $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
 $pzid = $dbc -> insertId();
 }
 {   // INSERT Prozessschritte
 $sql = "DELETE FROM Proz_Step WHERE proz_ID = $pzid";
 $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
 echo "<p class='red'><b>Daten zu '".$pz["bez"]."' wurden nicht oder nur teilweise gespeichert</b></p>\n";
 }
 echo "</div>";
-echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"prozess_flist.php\" target=\"_self\" title=\"Prozessliste\">&laquo; zur Prozessliste</a></p>\n";
+echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"prozess_flist.php\" target=\"_self\" title=\"Projektliste\">&laquo; zur Projektliste</a></p>\n";
 }
 echo "</body>\n</html>\n";
 ?>

changeset 34	fc60ef80a7ad
parent 28	8d8bce56918f
child 35	679bc22e37e2