<?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 "&nbsp;&nbsp;&nbsp;<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&uuml;nen</font> Eintrag w&auml;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&ouml;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

        &nbsp;&nbsp;<input class="long10" name="pz[pedat]" id="pedat"  value="<?php echo $pz['pedat']; ?>" />

            Plan Kosten (€)

        &nbsp;&nbsp;<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

        &nbsp;&nbsp;<input class="long10" name="pz[edat]" id="edat"  value="<?php echo $pz['edat']; ?>" />

                   Kosten (€)

        &nbsp;&nbsp;<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]; ?>" />

        &nbsp;&nbsp;&nbsp;Status&nbsp;&nbsp;&nbsp;<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 "&nbsp;&nbsp;&nbsp;Sort&nbsp;&nbsp;&nbsp;<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&uuml;gen"><img src="/fhiiqm/img/add.png" border="0" /></a>

            &nbsp;&nbsp;&nbsp;<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 "&nbsp;&nbsp;&nbsp;Status&nbsp;&nbsp;&nbsp;<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 "&nbsp;&nbsp;&nbsp;Sort&nbsp;&nbsp;&nbsp;<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'>&nbsp;&nbsp;&nbsp;<input class='$cls' type='checkbox' id='del_$i' name='pz[del][$i]' value='1'$chk /></span>

                                <span id='lb_$i' class='$cls'>&nbsp;l&ouml;schen?</span>";    

                            echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";

                            echo "<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bemerkung zu Schritt&nbsp;&nbsp;&nbsp;";

                            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&uuml;gen"><img src="/fhiiqm/img/add.png" border="0" /></a>

            &nbsp;&nbsp;&nbsp;<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'>&nbsp;&nbsp;&nbsp;<input class='$cls' type='checkbox' id='delag_$i' name='pz[delag][$i]' value='1'$chk /></span>

                                <span id='lbag_$i' class='$cls'>&nbsp;l&ouml;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> -->