fhiiqm/form/gefahr_ap_search_form.inc.php
changeset 28 8d8bce56918f
parent 26 3c1e3ac7089f
child 29 72f79dab938e
equal deleted inserted replaced
27:d92bbe898f32 28:8d8bce56918f
    62                 }
    62                 }
    63             ?>
    63             ?>
    64             </select>
    64             </select>
    65         </td>
    65         </td>
    66     </tr>
    66     </tr>
       
    67 <!--
       
    68     <tr>
       
    69         <td>Raum-Typ</td>
       
    70         <td><select name="rag[rtyp]">
       
    71             <?php
       
    72             /* 
       
    73                 if ($rag["rtyp"] == -1) $select = " selected "; else $select = "";
       
    74                 echo "<option $select value=\"-1\"></option>\n";
       
    75                 $sql = "SELECT raumtyp_ID,raumtyp_bez FROM fhiiqm.Raum_Typ ORDER BY 1";
       
    76                 if ($result = $dbc->queryObjectArray($sql))
       
    77                 {
       
    78                     foreach ($result as $row)
       
    79                     {
       
    80                         if ($row->raumtyp_ID == $rag['rtyp'])
       
    81     					   echo "<option selected value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
       
    82     				    else
       
    83     					   echo "<option value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
       
    84                     }
       
    85                 }
       
    86             */
       
    87             ?>
       
    88             </select>
       
    89         </td>
       
    90     </tr>
       
    91 -->
    67     <tr>
    92     <tr>
    68         <td>Arbeitsplatz-Typ</td>
    93         <td>Arbeitsplatz-Typ</td>
    69         <td><select name="rag[aptyp]">
    94         <td><select name="rag[aptyp]">
    70             <?php 
    95             <?php 
    71                 if ($rag["atyp"] == -1) $select = " selected "; else $select = "";
    96                 if ($rag["atyp"] == -1) $select = " selected "; else $select = "";
    84             ?>
   109             ?>
    85             </select>
   110             </select>
    86         </td>
   111         </td>
    87     </tr>
   112     </tr>
    88     <tr>
   113     <tr>
    89         <td>Gefahr</td>
   114         <td>Gef&auml;hrdung</td>
    90         <td><select name="rag[gef]">
   115         <td><select name="rag[gef]">
    91             <?php 
   116             <?php 
    92                 if ($rag["gef"] == -1) $select = " selected "; else $select = "";
   117                 if ($rag["gef"] == -1) $select = " selected "; else $select = "";
    93                 echo "<option $select value=\"-1\"></option>\n";
   118                 echo "<option $select value=\"-1\"></option>\n";
    94                 $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr
   119                 $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr
   115             <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
   140             <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
   116     </tr>
   141     </tr>
   117     <tr>
   142     <tr>
   118         <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
   143         <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
   119     <?php
   144     <?php
   120         $sort = array("-1"=>"","1"=>"Geb&auml;ude","2"=>"Raum-Nr.","6"=>"Arbeitsplatztyp","8"=>"Gefahr");
   145         $sort = array("-1"=>"","1"=>"Geb&auml;ude","2"=>"Raum-Nr.","6"=>"Arbeitsplatztyp","8"=>"Gef&auml;hrdung");
   121         for ($i=1; $i<5; $i++)
   146         for ($i=1; $i<5; $i++)
   122         { 
   147         { 
   123           echo "$i.&nbsp;&nbsp;<select name='rag[sort$i]'>\n";
   148           echo "$i.&nbsp;&nbsp;<select name='rag[sort$i]'>\n";
   124           foreach ($sort as $key=>$val)
   149           foreach ($sort as $key=>$val)
   125           {
   150           {
   131         } 
   156         } 
   132         echo "</td></tr>\n";
   157         echo "</td></tr>\n";
   133 
   158 
   134         $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
   159         $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
   135         echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
   160         echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
   136         if (!$rag['z']) $rag['z'] = 25;
   161         if (!$rag['z']) $rag['z'] = 9999;
   137         foreach ($azeil as $key=>$val)
   162         foreach ($azeil as $key=>$val)
   138         {
   163         {
   139             if ($key == $rag['z']) $select = "selected"; else $select = "";
   164             if ($key == $rag['z']) $select = "selected"; else $select = "";
   140             echo "<option $select value='$key'>$val</option>\n";
   165             echo "<option $select value='$key'>$val</option>\n";
   141         }
   166         }