--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/info_allg_search_form.inc.php	Thu Aug 23 10:17:50 2012 +0200
@@ -0,0 +1,131 @@
+<?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 1";
+                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";
+
+?>
\ No newline at end of file