<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 07/2012
 * 
 * Form Bericht Info
 */

        echo "<form action=\"". $_SERVER['PHP_SELF'] ."\" method=\"post\" enctype=\"application/x-www-form-urlencoded\" name=\"form_inf\">\n";
        echo "<table width=\"35%\" border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
        echo "<tr>";
            echo "<td>Produktbereich</td>";
            echo "<td><select name='inf[prodb]'>";
                    if (is_array($inf['prodb'])) $select = in_array( "-1", $inf['prodb'] ) ? ' selected' : null;
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT prod_ber_ID,prod_ber_name FROM Produkt_Bereich ORDER BY 1";  
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            $prod=str_replace(" ","&nbsp;",htmlentities($row->prod_ber_name));
                            if (is_array($inf['prodb'])) $select = in_array($row->prod_ber_ID, $inf['prodb']) ? ' selected' : null;
                            echo "<option  $select value=\"| $row->prod_ber_ID-\">$row->prod_ber_ID $prod</option>\n";
                        }
                    }
            echo "</select></td></tr>\n";
            echo "<tr><td>Produktgruppe</td>";
            echo "<td><select name='inf[prodg]'>";
                if ($inf["prodg"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT prod_group_ID, prod_group_name, prod_group_hier FROM Produkt_Gruppe ORDER BY 3";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = "";
                    foreach ($result as $row)
                    {
                        if (isset($inf["prodg"])) $select = ($row->prod_group_ID == $inf["prodg"] ) ? ' selected' : null;
            			   echo "<option $select value=\"-$row->prod_group_ID-\">$row->prod_group_hier $row->prod_group_name</option>\n";
                    }
                }
            echo "</select></td></tr>\n";
            echo "<tr><td>Infotyp</td>";
            echo "<td><select name='inf[ityp]'>";
                if ($inf["ityp"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY CONVERT(infotyp_ID,CHAR)";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = "";
                    foreach ($result as $row)
                    {
                        if (isset($inf["ityp"])) $select = ($row->infotyp_ID == $inf["ityp"] ) ? ' selected' : null;
            			   echo "<option $select value=\"$row->infotyp_ID\">$row->infotyp_ID - $row->infotyp_bez</option>\n";
                    }
                }
            echo "</select></td></tr>\n";
            echo "<tr><td>Adressat</td>";
            echo "<td><select name='inf[adr]'>";
                if ($inf["adr"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT CAST(info_adr_ID AS CHAR) AS ID, info_adr_name AS bez FROM Adressat
                        UNION
                        SELECT fkt_ID AS ID, fkt_bez AS bez FROM Funktion ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = "";
                    foreach ($result as $row)
                    {
                        if (isset($inf["adr"])) $select = ($row->ID == $inf["adr"] ) ? ' selected' : null;
            			   echo "<option $select value=\"$row->ID\">$row->ID - $row->bez</option>\n";
                    }
                }
            echo "</select></td></tr>\n";
            echo "<tr><td>Status Freigabe</td>";
            echo "<td><select name='inf[stat]'>";
                if ($inf["stat"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT info_freigabe_ID, info_freigabe_bez FROM Info_Freigabe ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = "";
                    foreach ($result as $row)
                    {
                        if (isset($inf["stat"])) $select = ($row->info_freigabe_ID == $inf["stat"] ) ? ' selected' : null;
            			   echo "<option $select value=\"$row->info_freigabe_ID\">$row->info_freigabe_ID - $row->info_freigabe_bez</option>\n";
                    }
                }
            echo "</select></td></tr>\n";
            echo "<tr> 
                  <td>Verkn&uuml;pfung</td>";
            if (isset($inf["bind"]) && $inf["bind"]=="AND") $cka="checked"; 
            elseif (isset($inf["bind"]) && $inf["bind"]=="OR") $cko="checked";
            else $cka="checked"; 
            echo "<td>UND&nbsp;&nbsp;&nbsp;
                    <input type=\"radio\" name=\"inf[bind]\" value=\"AND\" $cka/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ODER&nbsp;&nbsp;&nbsp;
                    <input type=\"radio\" name=\"inf[bind]\" value=\"OR\" $cko/></td>
            </tr>";
            echo "<tr>
                <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>";
                $sort = array("-1"=>"","2"=>"Info","4"=>"Typ","5"=>"Produkt","6"=>"Adressat", "7"=>"Kennzeichen");
                for ($i=1; $i<4; $i++)
                { 
                  echo "$i.&nbsp;&nbsp;<select name='inf[sort$i]'>\n";
                  foreach ($sort as $key=>$val)
                  {
                    $rsort = "sort" . $i;
                    if ($inf[$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='inf[z]'>\n";
            if (!$inf['z']) $inf['z'] = 9999;
            foreach ($azeil as $key=>$val)
            {
                if ($key == $inf['z']) $select = "selected"; else $select = "";
                echo "<option $select value='$key'>$val</option>\n";
            }
            echo "</select></td></tr>\n";    
            echo "<tr> 
                <td>&nbsp;</td>
                <td colspan='3'><input class=\"button\" type=\"submit\" name=\"search\" value=\"Bericht erstellen\"></td>
            </tr>
            </table>\n
            </form>\n";

?>