diff -r 245f994f8fa0 -r 2d8be944f381 fhiiqm/form/vertrag_report_form.inc.php
--- a/fhiiqm/form/vertrag_report_form.inc.php Fri Sep 16 16:15:15 2011 +0200
+++ b/fhiiqm/form/vertrag_report_form.inc.php Tue Sep 27 14:59:40 2011 +0200
@@ -22,17 +22,17 @@
Produktgruppe |
- |
+
Produkt |
\n";
- $sql = "SELECT produkt_ID, prod_name FROM Produkt ORDER BY 2";
+ if (isset($vr["prodg"]) && $vr["prodg"] > -1) $where = " WHERE prod_group_ID = $vr[prodg] "; else $where = "";
+ $sql = "SELECT produkt_ID, prod_name FROM Produkt $where ORDER BY 2";
if ($result = $dbc->queryObjectArray($sql))
{
- foreach ($result as $row)
+ $select = null;
+ foreach ($result as $row)
{
- if (is_array($vr["prod"])) $select = in_array( $row->produkt_ID, $vr["prod"] ) ? ' selected' : null;
+ if (isset($vr["prod"])) $select = ( $row->produkt_ID == $vr["prod"] ) ? ' selected' : null;
echo "\n";
}
}
@@ -60,19 +63,21 @@
|
+
Vertrag-Typ |
\n";
$sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2";
if ($result = $dbc->queryObjectArray($sql))
{
+ $select = null;
foreach ($result as $row)
{
- if (is_array($vr["vtyp"])) $select = in_array( $row->vtyp_ID, $vr["vtyp"] ) ? ' selected' : null;
+ if (isset($vr["vtyp"])) $select = ( $row->vtyp_ID == $vr["vtyp"] ) ? ' selected' : null;
echo "\n";
}
}
@@ -80,6 +85,16 @@
|
+
+ gewünschtes Kündigungsdatum |
+
+ |
+
+
+
Jahr |
@@ -91,8 +106,8 @@
echo "\n";
$ja = $vr['jahr'];
for ($i=2000; $i<2031; $i++)
- { if ($i==intval($j1))
- echo "\n";
+ { if ($i==intval($ja))
+ echo "\n";
else
echo "\n";
}
@@ -100,6 +115,8 @@
|
+
Verknüpfung |
UND
@@ -110,14 +127,16 @@
|
Sortierung nach (in dieser Reihenfolge) |
"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Kostenjahr");
- for ($i=1; $i<4; $i++)
+ if ($rvnr == 1)
+ $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Jahr");
+ elseif ($rvnr ==2)
+ $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","12"=>"Partner","13"=>"Kündigungstermin");
+ for ($i=1; $i\n";
foreach ($sort as $key=>$val)
{
- $rsort = $sort . $i;
- if ($rag[$rsort] == $i) $select= " selected"; else $select = "";
+ if ($vr["sort$i"] == $key) $select= " selected"; else $select = "";
echo "\n";
}
echo " \n";
|