fhiiqm/form/vertrag_report_form.inc.php
changeset 17 f990704af47b
parent 15 1ed6fbdf4237
equal deleted inserted replaced
16:3ebe66308a00 17:f990704af47b
    57         <td>Produkt</td>
    57         <td>Produkt</td>
    58         <td><select name="vr[prod]">
    58         <td><select name="vr[prod]">
    59             <?php 
    59             <?php 
    60                 if ($vr["prod"] == -1) $select = " selected "; else $select = "";
    60                 if ($vr["prod"] == -1) $select = " selected "; else $select = "";
    61                 echo "<option $select value=\"-1\"></option>\n";
    61                 echo "<option $select value=\"-1\"></option>\n";
    62                 if (isset($vr["prodg"]) && $vr["prodg"] > -1) $where = " WHERE prod_group_ID = $vr[prodg] "; else $where = "";
    62                 if (isset($vr["prodg"]) && $vr["prodg"] > -1) 
       
    63                     $where = " WHERE prod_group_ID = $vr[prodg] ";
       
    64                 elseif ($listg>"")
       
    65                     $where = " WHERE prod_group_ID IN ($listg) "; 
       
    66                 else $where = "";
    63                 $sql = "SELECT produkt_ID, prod_name FROM Produkt $where ORDER BY 2";
    67                 $sql = "SELECT produkt_ID, prod_name FROM Produkt $where ORDER BY 2";
    64                 if ($result = $dbc->queryObjectArray($sql))
    68                 if ($result = $dbc->queryObjectArray($sql))
    65                 {
    69                 {
    66                     $select = null;
    70                     $select = null;
    67                    foreach ($result as $row)
    71                    foreach ($result as $row)