fhiiqm/form/vertrag_report_form.inc.php
changeset 15 1ed6fbdf4237
parent 12 2d8be944f381
child 17 f990704af47b
--- a/fhiiqm/form/vertrag_report_form.inc.php	Fri Oct 07 11:37:29 2011 +0200
+++ b/fhiiqm/form/vertrag_report_form.inc.php	Tue Oct 11 12:17:55 2011 +0200
@@ -24,9 +24,20 @@
         <td>Produktgruppe</td>
         <td><select name="vr[prodg]" <?php  if ($rvnr == 1) echo "onchange=\"this.form.submit();\""; ?>>
             <?php 
-                if ($vr["prodg"] == -1) $select = " selected "; else $select = "";
-                echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2";
+                if (is_array($_SESSION["prodg"]))
+                {
+                        foreach ($_SESSION["prodg"] as $val)
+                            $listg .= ",'" .$val . "'";
+                        $listg = substr($listg,1);
+                }
+                else
+                {
+                    if ($vr["prodg"] == -1) $select = " selected "; else $select = "";
+                    echo "<option $select value=\"-1\"></option>\n";
+                }    
+                //Einschraenkung Produktgruppe
+                if (isset($listg) && $listg) $wher = " WHERE prod_group_ID IN ($listg) "; else $wher = "";
+                $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe $wher ORDER BY 2";
                 if ($result = $dbc->queryObjectArray($sql))
                 {
                     $select = "";