<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 06/2012
 * 
 * Form Arbeitsplatztyp - Gefaehrdung
 * 
 */

	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();

?>
    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_info" target="_self">
    <div align="center"> 	
    <table width="50%" border="0" cellspacing="3" cellpadding="3">
    <tr>
        <td>Arbeitsplatztyp *</td>        
        <td>
            <select name="ap[aptyp]" size="1">
            <?php
                $select = null;
                $sql = "SELECT arbplatz_typ, arbplatz_typ_bez FROM fhiiqm.Arbplatz_Typ ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->arbplatz_typ==$ap['aptyp'] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
                    }
                }
            ?>
            </select>
        </td>   
    </tr>
    <tr>
        <td>Gef&auml;hrdung *
            <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen
        </td>        
        <td>
        <div id="add">
            <select name="ap[gf][]" size="1">
            <?php
                $select = null;
                $select = ( "-1"==$ap['gf'][0] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT gefahr_ID, gefahr_bez FROM fhiiqm.Gefahr ORDER BY (gefahr_ID+1)";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->gefahr_ID===$ap['gf'][0] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";
                        $sgf .= "'".$row->gefahr_ID."':'".$row->gefahr_bez."',";
                    }
                }
                $sgf = substr($sgf,0,strlen($sgf)-1);
            ?>
            </select>
            <script type="text/javascript">
            <!--
                arr = {<?php echo ($sgf); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
            //-->
            </script>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('add');" ?>" title="weitere Gef&auml;hrdung"><img src="/fhiiqm/img/add.png" /></a>
            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('add');" ?>" title="l&ouml;schen letzte Gef&auml;hrdung"><img src="/fhiiqm/img/delete.png" /></a><br />
        <?php
            if ($apid || ($sub && isset($ap) && !$ok))
            {
                if (count($ap['gf'])>1)
                {
                    $i=0;
                    foreach ($ap['gf'] as $gfe)
                    {
                        if ($i>0)
                        {
                            echo "<select name=\"ap[gf][]\" size=\"1\">";
            
                            $select = ( "-1" == $gfe ) ? ' selected' : null;
                            echo "<option $select value=\"-1\"></option>\n";
                            foreach ($result as $row)
                            {
                                $select = ( $row->gefahr_ID === $gfe ) ? ' selected' : null;
            					echo "<option $select value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";
                            }
                            echo "</select><br/>\n";
                        }
                        $i++;
                    }
                }
            }
        ?>
        </div>
        </td>   
    </tr>
<!--
    </table>
    </form>
-->