--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/prozess_rag_form.inc.php Fri Jan 17 08:50:55 2014 +0100
@@ -0,0 +1,381 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 03/2012
+ *
+ * Form Prozess
+ *
+ */
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $okn = true;
+
+
+ echo "<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_svc"> -->
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self">
+<div align="center">
+<table width="60%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Projekt-Bezeichnung *</td>
+ <td><input name="pz[bez]" id="bez" type="text" size="50" maxlength="50" value="<?php echo $pz['bez']; ?>" />
+ <?php
+ if (isset($pz['bez']) && $pz['bez']<'!')
+ {
+ echo "<br><span class=\"red\">Projektbezeichnung ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ if ($pzid)
+ {
+ echo " Projekt-ID";
+ echo " <input class='read right' name='pz[pzid]' type='text' size='5' value='" .$pz['pzid']."' readonly='readonly' />";
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Projekt-Beschreibung</td>
+ <td><textarea name="pz[bezl]" cols="80" rows="3"><?php echo $pz["bezl"]; ?></textarea>
+ </td>
+ </tr>
+ <tr>
+ <td>zugeordnet zu Produkt *</td>
+ <td>
+ <select name="pz[prid]" size="1">
+ <?php
+ if (is_array($pz['prid'])) $select = in_array( "-1", $pz['prid'] ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+/* $sql = "SELECT DISTINCT ip.produkt_ID,prod_name
+ FROM Info i LEFT OUTER JOIN Info_Produkt ip
+ ON i.info_ID=ip.info_ID LEFT OUTER JOIN Info_Verantwortlich v
+ ON i.info_ID=v.info_ID INNER JOIN Produkt p
+ ON ip.produkt_ID=p.produkt_ID INNER JOIN Mitarbeiter m
+ ON v.persknr=m.persknr
+ WHERE i.infotyp_ID=6 and v.persknr=$persknr
+ ORDER BY ip.produkt_ID";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if (strlen($row->prod_name) > 70)
+ $prod=str_replace(" "," ",htmlentities(substr($row->prod_name,0,70))) ."...";
+ else
+ $prod=str_replace(" "," ",htmlentities($row->prod_name));
+ $select = ($row->produkt_ID == $pz['prid'] && $pz['prid']>0) ? ' selected' : null;
+ echo "<option $select value=\"$row->produkt_ID\">$prod</option>\n";
+ }
+ }
+*/
+ // Recht Produktgruppe beruecksichtigen
+ if (is_array($_SESSION["prodg"]))
+ {
+ foreach ($_SESSION["prodg"] as $val)
+ $listg .= "," .$val;
+ $listg = substr($listg,1);
+ echo "prodg = $listg<br />";
+ $sql = "CALL fhiiqm.hier_prodgroup('$listg')";
+ }
+ else
+ $sql = "CALL fhiiqm.prod_hiera_all(0,0)";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if (strlen($row->bez) > 70)
+ $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."...";
+ else
+ $prod=str_replace(" "," ",htmlentities($row->bez));
+ if ($row->prid >0) $color=" class='green'"; else $color="";
+ if ($row->prid == $pz['prid'])
+ echo "<option $color selected value=\"$row->prid\">$prod</option>\n";
+ else
+ echo "<option $color value=\"$row->prid\">$prod</option>\n";
+ }
+ }
+ echo "
+ </select>\n";
+ echo "<br />bitte 1 <font color='green'>grünen</font> Eintrag wählen";
+
+ if (isset($pz) && $pz['prid']<1)
+ {
+ echo "<br><span class=\"red\">Produktzuordnung muss erfolgen!</span>\n";
+ $okn = false;
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Auftraggeber</td>
+ <td><input type="text" name="pz[persa]" id="persa" value="<?php echo $pz['persa']; ?>"/>
+ Eingabe von mind. 2 Zeichen -> Namensliste
+ </td>
+ </tr>
+ <tr>
+ <td>Verantwortlicher</td>
+ <td><input type="text" name="pz[pers]" id="pers" value="<?php echo $pz['pers']; ?>"/>
+ Eingabe von mind. 2 Zeichen -> Namensliste
+ </td>
+ </tr>
+ <tr><td>gehört zu Projekt</td>
+ <td><select name="pz[pzref]">
+ <?php
+ if ($pz['pzref'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ if (isset($pz["pzid"]) && $pz["pzid"]>0) $where = " WHERE proz_ID != " . $pz["pzid"]; else $where="";
+ $sql = "SELECT proz_ID, proz_bez FROM Prozess $where ORDER BY 2";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->proz_ID == $pz['pzref'])
+ echo "<option selected value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n";
+ else
+ echo "<option value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Plan Start-Datum</td>
+ <td><input class="long10" name="pz[psdat]" id="psdat" value="<?php echo $pz['psdat']; ?>" />
+ Plan Ende-Datum
+ <input class="long10" name="pz[pedat]" id="pedat" value="<?php echo $pz['pedat']; ?>" />
+ Plan Kosten (€)
+ <input class='right' name="pz[pkost]" type="text" value="<?php echo $pz["pkost"]; ?>" /></td>
+ </tr>
+ <tr>
+ <td>Start-Datum</td>
+ <td><input class="long10" name="pz[sdat]" id="sdat" value="<?php echo $pz['sdat']; ?>" />
+ Ende-Datum
+ <input class="long10" name="pz[edat]" id="edat" value="<?php echo $pz['edat']; ?>" />
+ Kosten (€)
+ <input class='right' name="pz[kost]" type="text" value="<?php echo $pz["kost"]; ?>" /></td>
+ </tr>
+<!-- <tr>
+ <td>Prozess-Kategorie</td>
+ <td><select name="pz[kat]">
+ <?php
+/* if ($pz['kat'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT proz_kat_ID,proz_kat_bez FROM Proz_Kategorie ORDER BY 2";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->proz_kat_ID == $pz['kat'])
+ echo "<option selected value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n";
+ else
+ echo "<option value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n";
+ }
+ }
+*/ ?>
+ </select>
+ </td>
+ </tr> -->
+ <tr>
+ <td>Arbeitschritte</td>
+ <td>
+ <div id="add">
+ <input name="pz[step][]" type="text" size="50" maxlength="50" value="<?php echo $pz['step'][0]; ?>" />
+ Status <select name="pz[ststat][]">
+ <?php
+ if (isset($pz['step'])) $anzstep = count($pz['step']); else $anzstep = 1;
+ if ($pz['ststat'][0] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->proz_stat_ID == $pz['ststat'][0])
+ echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+ else
+ echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+ $stat .= "'".$row->proz_stat_ID. "':'" . $row->proz_stat_bez . "',";
+ $sta[$row->proz_stat_ID] = $row->proz_stat_bez;
+ }
+ }
+ $stat = substr($stat,0,strlen($stat)-1);
+ echo "</select>";
+ echo " Sort <input type='text' name=\"pz[sort][]\" class='right' size=\"2\" maxlen=\"2\" value=\"". $pz['sort'][0]. "\" /><br />\n";
+ echo " Bemerkung zu Schritt ";
+ echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value='".$pz["stbem"][0]."' />";
+ ?>
+ <script type="text/javascript">
+ <!--
+ arr = {<?php echo ($stat); ?>}; // Ergebnis: {key:'value',key:'value',...}
+ //-->
+ </script>
+
+
+
+ <a href="<?php echo "javascript:addInput('add',$anzstep);" ?>" id="badd" title="Schritt hinzufügen"><img src="/fhiiqm/img/add.png" border="0" /></a>
+ <a href="<?php echo "javascript:markdelInput('add',$anzstep);" ?>" id="bdel" title="Schritt entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a>
+ <?php
+ if ($pzid || ($sub && isset($pz) && !$ok))
+ {
+ if (count($pz['step'])>1)
+ {
+ $i=0;
+ foreach ($pz['step'] as $akt)
+ {
+ if ($i>0)
+ {
+ echo "<span></span><br /><input name=\"pz[step][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"" .$pz['step'][$i] . "\" />\n";
+ echo " Status <select name='pz[ststat][]'>";
+ if ($pz['ststat'][$i] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ foreach ($sta as $key => $value)
+ {
+ $select = ($key == $pz['ststat'][$i])? " selected='selected'" : "";
+ echo "<option$select value=\"$key\">$value</option>\n";
+ }
+ echo "</select>";
+ echo " Sort <input type='text' name='pz[sort][]' class='right' size='2' maxlen='2' value='".$pz['sort'][$i] ."' />";
+ if (isset($pz['del'])) $cls = "dispil"; else $cls = "pr";
+ if (isset($pz['del'][$i])) $chk = "checked = ' checked'"; else $chk ="";
+ echo "<span id='cbl_$i'> <input class='$cls' type='checkbox' id='del_$i' name='pz[del][$i]' value='1'$chk /></span>
+ <span id='lb_$i' class='$cls'> löschen?</span>";
+ echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
+ echo "<br /> Bemerkung zu Schritt ";
+ echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value=\"".$pz["stbem"][$i]."\" />\n";
+ }
+ $i++;
+ }
+ }
+ }
+ ?>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>Projekt-Dringlichkeit</td>
+ <td><select name="pz[urg]">
+ <?php
+ if ($pz['urg'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT proz_urg_ID,proz_urg_bez FROM Proz_Dringlichkeit ORDER BY 1";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->proz_urg_ID == $pz['urg'])
+ echo "<option selected value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n";
+ else
+ echo "<option value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Projekt-Status</td>
+ <td><select name="pz[stat]">
+ <?php
+ if ($pz['stat'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->proz_stat_ID == $pz['stat'])
+ echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+ else
+ echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>betroffene AGs</td>
+ <td>
+ <div id="addrag">
+ <select name="pz[rag][]">
+ <?php
+ if (isset($pz['rag'])) $anzrag = count($pz['rag']); else $anzrag = 1;
+ if ($pz['rag'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT rag_ID,rag_bez,rag_bezk,abt_name,rag.abt_ID
+ FROM fhiiqm.RaumArb_Gruppe rag
+ LEFT OUTER JOIN Abteilung a ON rag.abt_ID=a.abt_ID
+ ORDER BY rag.abt_ID,rag_bez";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->rag_ID == $pz['rag'][0]) $select = " selected "; else $select = "";
+ echo "<option$select value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n";
+ $faktor = ($row->abt_ID*1000)+$row->rag_ID; // wegen sort nach Abt. fuer JS, z.B. 7047
+ $rag .= "'".$faktor. "':'" . $row->abt_name.": ". $row->rag_bez . "',";
+ $ag[$row->rag_ID] = $row->abt_name.": ". $row->rag_bez;
+ }
+ }
+ $rag = substr($rag,0,strlen($rag)-1);
+ ?>
+ </select>
+ <script type="text/javascript">
+ <!--
+ arrag = {<?php echo ($rag); ?>}; // Ergebnis: {key:'value',key:'value',...}
+ //-->
+ </script>
+
+
+ <a href="<?php echo "javascript:addInput('addrag',$anzrag);" ?>" id="badd" title="AG hinzufügen"><img src="/fhiiqm/img/add.png" border="0" /></a>
+ <a href="<?php echo "javascript:markdelInput('addrag',$anzrag);" ?>" id="bdel" title="AG entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a>
+ <?php
+ if ($pzid || ($sub && isset($pz) && !$ok))
+ {
+ if (count($pz['rag'])>1)
+ {
+ $i=0;
+ foreach ($pz['rag'] as $akt)
+ {
+ if ($i>0)
+ {
+ echo "<span></span><br /><select name='pz[rag][]'>";
+ if ($pz['rag'][$i] == -1) $select = " select='selected' "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ foreach ($ag as $key => $value)
+ {
+ $select = ($key == $pz['rag'][$i])? " selected='selected'" : "";
+ echo "<option$select value=\"$key\">$value</option>\n";
+ }
+ echo "</select>";
+ if (isset($pz['delag'])) $cls = "dispil"; else $cls = "pr";
+ if (isset($pz['delag'][$i])) $chk = "checked = ' checked'"; else $chk ="";
+ echo "<span id='cblag_$i'> <input class='$cls' type='checkbox' id='delag_$i' name='pz[delag][$i]' value='1'$chk /></span>
+ <span id='lbag_$i' class='$cls'> löschen?</span>";
+ echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
+ }
+ $i++;
+ }
+ }
+ }
+ ?>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>Bemerkung</td>
+ <td><textarea name="pz[bem]" cols="80" rows="6"><?php echo $pz["bem"]; ?></textarea>
+ </td>
+ </tr>
+
+ <input type="hidden" name="pz[persknr]" id="pid" value="<?php echo $pz['persknr']; // Verantwortlicher?>"/>
+ <input type="hidden" name="pz[persknra]" id="paid" value="<?php echo $pz['persknra']; // Auftraggeber?>"/>
+ <input type="hidden" name="pz[okn]" value="<?php echo $okn; ?>"/>
+<!-- </table>
+ </div>
+</form> -->
\ No newline at end of file