1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 06/2012

     6  * 

     7  * Form Arbeitsplatztyp - Grfahr

     8  * 

     9  */

    10 

    11 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");

    12 	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();

    13 

    14 ?>

    15     <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_info" target="_self">

    16     <div align="center"> 	

    17     <table width="55%" border="0" cellspacing="3" cellpadding="3">

    18     <tr>

    19         <td width="20%">Arbeitsplatztyp *</td>        

    20         <td>

    21             <select name="ap[aptyp]" size="1">

    22             <?php

    23                 $select = null;

    24                 $sql = "SELECT arbplatz_typ, arbplatz_typ_bez FROM fhiiqm.Arbplatz_Typ ORDER BY 1";

    25                 if ($result = $dbc->queryObjectArray($sql))

    26                 {

    27                     foreach ($result as $row)

    28                     {

    29                         $select = ( $row->arbplatz_typ==$ap['aptyp'] ) ? ' selected' : null;

    30     					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";

    31                     }

    32                 }

    33             ?>

    34             </select>

    35         </td>   

    36     </tr>

    37     <tr>

    38         <td>Gef&auml;hrdung *

    39             <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen

    40         </td>        

    41         <td>

    42         <div id="add">

    43             <select name="ap[gf][]" size="1">

    44             <?php

    45                 $select = null;

    46                 $select = ( "-1"==$ap['gf'][0] ) ? ' selected' : null;

    47                 echo "<option $select value=\"-1\"></option>\n";

    48                 $sql = "SELECT gefahr_ID, gefahr_bez FROM fhiiqm.Gefahr ORDER BY (gefahr_ID+1)";

    49                 if ($result = $dbc->queryObjectArray($sql))

    50                 {

    51                     foreach ($result as $row)

    52                     {

    53                         $select = ( $row->gefahr_ID==$ap['gf'][0] ) ? ' selected' : null;

    54     					echo "<option $select value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";

    55                         $sgf .= "'".$row->gefahr_ID."':'".$row->gefahr_bez."',";

    56                     }

    57                 }

    58                 $sgf = substr($sgf,0,strlen($sgf)-1);

    59             ?>

    60             ?>

    61             </select>

    62             <script type="text/javascript">

    63             <!--

    64                 arr = {<?php echo ($sgf); ?>}; // Ergebnis: {'key':'value','key':'value',...} 

    65             //-->

    66             </script>

    67 

    68             &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('add');" ?>" title="weitere Gef&auml;hrdung"><img src="/fhiiqm/img/add.png" /></a>

    69             &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>

    70         <?php

    71             if ($apid || ($sub && isset($ap) && !$ok))

    72             {

    73                 if (count($ap['gf'])>1)

    74                 {

    75                     $i=0;

    76                     foreach ($ap['gf'] as $gfe)

    77                     {

    78                         if ($i>0)

    79                         {

    80                             echo "<select name=\"ap[gf][]\" size=\"1\">";

    81             

    82                             $select = ( "-1" == $gfe ) ? ' selected' : null;

    83                             echo "<option $select value=\"-1\"></option>\n";

    84                             foreach ($result as $row)

    85                             {

    86                                 $select = ( $row->gefahr_ID == $gfe ) ? ' selected' : null;

    87             					echo "<option $select value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";

    88                             }

    89                             echo "</select><br/>\n";

    90                         }

    91                         $i++;

    92                     }

    93                 }

    94             }

    95         ?>

    96         </div>

    97         </td>   

    98     </tr>

    99 <!--

   100     </table>

   101     </form>

   102 -->