<?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(" "," ",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/>

                        ODER   

                    <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";

?>