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