<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 10/2013
 * 
 * Form Recherche Laser
 * 
 */

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

?>
<div align="center">
<h3><font face="Verdana, Arial, Helvetica, sans-serif"></font></h3>
<p>Bitte Kriterien f&uuml;r die Suche w&auml;hlen</p>
</div>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_las" target="_self">	
<div align="center">
<table width="50%" border="0" cellspacing="3" cellpadding="3">
    <tr>
        <td>Abteilung</td>
        <td>
            <select name="las[abt]" size="1">
            <?php 
                if ($las["abt"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT abt_name, abt_long FROM Abteilung WHERE abt_ID < 6 ORDER BY abt_ID"; // nur wiss. Abt.
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->abt_name == $las['abt'])
    					   echo "<option selected value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n";
    				    else
    					   echo "<option value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n";
                    }
                }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Haus</td>
        <td>
            <select name="las[geb]" size="1" onchange="this.form.submit();">
            <?php 
                if ($las["geb"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->geb_ID == $las['geb'])
    					   echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
    				    else
    					   echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
                    }
                }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Raum-Nummer</td>
        <td><select name="las[rnum]">
            <?php 
                if ($las["rnum"] == "0") $select = " selected "; else $select = "";
                echo "<option $select value=\"0\"></option>\n";
                if (isset($las["geb"]) && $las["geb"] > "") $where = " WHERE geb_ID = '".$las["geb"]."'"; else $where = "";
                echo "Gebaeude: ".$las["geb"]."<br />\n";
                $sql = "SELECT geb_ID, raum_ID,raum_nr,raum_name FROM fhiiqm.Raum $where ORDER BY 1,3";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->raum_ID == $las['rnum'])
    					   echo "<option selected value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
    				    else
    					   echo "<option value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
                    }
                }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Laser-Klasse</td>
        <td><select name="las[kl]">
            <?php 
                if ($las["kl"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT las_klasse_ID,las_klasse_bez FROM fhiiqm.Laser_Klasse
                        ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->las_klasse_ID == $las['kl'])
    					   echo "<option selected value=\"$row->las_klasse_ID\">$row->las_klasse_bez</option>\n";
    				    else
    					   echo "<option value=\"$row->las_klasse_ID\">$row->las_klasse_bez</option>\n";
                    }
                }
            ?>
            </select>
        </td>
    </tr>
    <tr> 
          <td>Verkn&uuml;pfung</td>
          <td>UND&nbsp;&nbsp;&nbsp;
            <input type="radio" name="las[bind]" value="AND" <?php if (isset($las["bind"]) && $las["bind"]=="AND") echo "checked"; else  echo "checked";?>>
          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ODER&nbsp;&nbsp;&nbsp;
            <input type="radio" name="las[bind]" value="OR" <?php if (isset($las["bind"]) && $las["bind"]=="OR") echo "checked"; ?>></td>
    </tr>
    <tr>
        <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
    <?php
        $sort = array("-1"=>"","4"=>"Abteilung","5"=>"Haus","7"=>"Raum-Nr.","3"=>"Klasse");
        for ($i=1; $i<3; $i++)
        { 
          echo "$i.&nbsp;&nbsp;<select name='las[sort$i]'>\n";
          foreach ($sort as $key=>$val)
          {
            $rsort = "sort" . $i;
            if ($las[$rsort] == $val) $select= " selected"; else $select = "";
            echo "<option$select value='$key'>$val</option>\n";
          }
          echo "</select>&nbsp;&nbsp;&nbsp;&nbsp;\n";
        } 
        echo "</td></tr>\n";

        $azeil = array(1=>'1',10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
        echo "<tr><td>Zeilen/Seite?</td><td><select name='las[z]'>\n";
        if (!$las['z']) $las['z'] = 9999;
        foreach ($azeil as $key=>$val)
        {
            if ($key == $las['z']) $select = "selected"; else $select = "";
            echo "<option $select value='$key'>$val</option>\n";
        }
        echo "</select></td></tr>\n";

    ?>
    <tr> 
        <td>&nbsp;</td>
        <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
    </tr> 
</table>
</div>
</form>