<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 08/2011

 *

 * Form Recherche Raum - Gefahr

 */

	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_rag" target="_self">	

<div align="center">

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

    <tr>

        <td>Haus</td>

        <td>

            <select name="rag[geb]" size="1" onchange="this.form.submit();">

            <?php 

                if ($rag["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 == $rag['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="rag[rnum]">

            <?php 

                if ($rag["rnum"] == -1) $select = " selected "; else $select = "";

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

                if (isset($rag["geb"]) && $rag["geb"] > -1) $where = " WHERE geb_ID = '".$rag["geb"]."'"; else $where = "";

                echo "Gebaeude: ".$rag["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 == $rag['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>Raum-Typ</td>

        <td><select name="rag[rtyp]">

            <?php

            /* 

                if ($rag["rtyp"] == -1) $select = " selected "; else $select = "";

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

                $sql = "SELECT raumtyp_ID,raumtyp_bez FROM fhiiqm.Raum_Typ ORDER BY 1";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->raumtyp_ID == $rag['rtyp'])

    					   echo "<option selected value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";

    				    else

    					   echo "<option value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";

                    }

                }

            */

            ?>

            </select>

        </td>

    </tr>

-->

    <tr>

        <td>Arbeitsplatz-Typ</td>

        <td><select name="rag[aptyp]">

            <?php 

                if ($rag["atyp"] == -1) $select = " selected "; else $select = "";

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

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

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->arbplatz_typ == $rag['atyp'])

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

    				    else

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

                    }

                }

            ?>

            </select>

        </td>

    </tr>

    <tr>

        <td>Gef&auml;hrdung</td>

        <td><select name="rag[gef]">

            <?php 

                if ($rag["gef"] == -1) $select = " selected "; else $select = "";

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

                $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr

                        ORDER BY CONVERT(substring(gefahr_ID,1,INSTR(gefahr_ID,'.')-1),DECIMAL),CONVERT(SUBSTRING(gefahr_ID,INSTR(gefahr_ID,'.')+1),DECIMAL);";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->gefahr_ID == $rag['gef'])

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

    				    else

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

                    }

                }

            ?>

            </select>

        </td>

    </tr>

    <tr> 

          <td>Verkn&uuml;pfung</td>

          <td>UND&nbsp;&nbsp;&nbsp;

            <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else  echo "checked";?>>

                ODER   

            <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>

    </tr>

    <tr>

        <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>

    <?php

        $sort = array("-1"=>"","1"=>"Gebäude","2"=>"Raum-Nr.","6"=>"Arbeitsplatztyp","8"=>"Gefährdung");

        for ($i=1; $i<5; $i++)

        { 

          echo "$i.&nbsp;&nbsp;<select name='rag[sort$i]'>\n";

          foreach ($sort as $key=>$val)

          {

            $rsort = "sort" . $i;

            if ($rag[$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(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows

        echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";

        if (!$rag['z']) $rag['z'] = 9999;

        foreach ($azeil as $key=>$val)

        {

            if ($key == $rag['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>