1 <?php

     2 

     3 /**

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

     5  * @copyright 4/2012

     6  * 

     7  * Form Raum - Arbeitsplatztyp

     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="45%" border="0" cellspacing="3" cellpadding="3">

    18     <tr>

    19         <td width="30%">Haus *</td>

    20         <td><select name="ap[geb]" onchange="this.form.submit();">

    21             <?php 

    22                 $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";

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

    24                 {

    25                     foreach ($result as $row)

    26                     {

    27                         if ($row->geb_ID == $ap['geb'])

    28     					   echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";

    29     				    else

    30     					   echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";

    31                     }

    32                 }

    33             ?>

    34             </select>

    35         </td>

    36     </tr>

    37     <tr>

    38         <td>Raum *</td>

    39         <td><select name="ap[raum]">

    40             <?php 

    41                 if (!isset($ap) && !$ap['geb']) $ap['geb'] = "A";

    42                 $sql = "SELECT raum_ID, raum_nr, raum_name FROM Raum WHERE geb_ID = '". $ap['geb']."' ORDER BY 2";

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

    44                 {

    45                     foreach ($result as $row)

    46                     {

    47                         if ($row->raum_ID == $ap['raum'])

    48     					   echo "<option selected value=\"$row->raum_ID\">$row->raum_nr - $row->raum_name</option>\n";

    49     				    else

    50     					   echo "<option value=\"$row->raum_ID\">$row->raum_nr - $row->raum_name</option>\n";

    51                     }

    52                 }

    53             ?>

    54             </select>

    55         </td>

    56     </tr>

    57     <tr>

    58         <td>Arbeitsplatztyp *

    59             <br />&nbsp;&nbsp;&nbsp;Hinzufügen weiterer<br />&nbsp;&nbsp;&nbsp;Typen mit '+'

    60         </td>        

    61         <td>

    62         <div id="add">

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

    64             <?php

    65                 $select = null;

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

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

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

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

    70                 {

    71                     foreach ($result as $row)

    72                     {

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

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

    75                         $apt .= "'".$row->arbplatz_typ."':'".$row->arbplatz_typ_bez."',";

    76                     }

    77                 }

    78                 $apt = substr($apt,0,strlen($apt)-1);

    79             ?>

    80             </select>

    81             <script type="text/javascript">

    82             <!--

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

    84             //-->

    85             </script>

    86 

    87             &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('add');" ?>" title="weiterer Arbeitsplatztyp"><img src="/fhiiqm/img/add.png" /></a>

    88             &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('add');" ?>" title="l&ouml;schen letzten Arbeitsplatztyp"><img src="/fhiiqm/img/delete.png" /></a>

    89         <?php

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

    91             {

    92                 if (count($ap['aptyp'])>1)

    93                 {

    94                     $i=0;

    95                     foreach ($ap['aptyp'] as $apte)

    96                     {

    97                         if ($i>0)

    98                         {

    99                             echo "<select name=\"ap[aptyp][]\" size=\"1\">";

   100             

   101                             $select = ( "-1" == $apte ) ? ' selected' : null;

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

   103                             foreach ($result as $row)

   104                             {

   105                                 $select = ( $row->arbplatz_typ == $apte ) ? ' selected' : null;

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

   107                             }

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

   109                         }

   110                         $i++;

   111                     }

   112                 }

   113             }

   114         ?>

   115         </div>

   116         </td>   

   117     </tr>

   118 <!--

   119     </table>

   120     </form>

   121 -->