<?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="50" rows="2"><?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 ($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><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');" ?>" id="badd" title="Schritt hinzufügen"><img src="/fhiiqm/img/add.png" border="0" /></a>
<a href="<?php echo "javascript:delInput('add');" ?>" id="bdel" title="letzten 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" : "";
echo "<option$select value=\"$key\">$value</option>\n";
}
echo "</select>";
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>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> -->