20 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self"> |
20 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self"> |
21 <div align="center"> |
21 <div align="center"> |
22 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
22 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
23 <tr> |
23 <tr> |
24 <td>Produktgruppe</td> |
24 <td>Produktgruppe</td> |
25 <td><select name="vr[prodg]"> |
25 <td><select name="vr[prodg]" <?php if ($rvnr == 1) echo "onchange=\"this.form.submit();\""; ?>> |
26 <?php |
26 <?php |
27 $select = null; |
|
28 if ($vr["prodg"] == -1) $select = " selected "; else $select = ""; |
27 if ($vr["prodg"] == -1) $select = " selected "; else $select = ""; |
29 echo "<option $select value=\"-1\"></option>\n"; |
28 echo "<option $select value=\"-1\"></option>\n"; |
30 $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2"; |
29 $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2"; |
31 if ($result = $dbc->queryObjectArray($sql)) |
30 if ($result = $dbc->queryObjectArray($sql)) |
32 { |
31 { |
|
32 $select = ""; |
33 foreach ($result as $row) |
33 foreach ($result as $row) |
34 { |
34 { |
35 if (is_array($vr["prodg"])) $select = in_array( $row->prod_group_ID, $vr["prodg"] ) ? ' selected' : null; |
35 if (isset($vr["prodg"])) $select = ($row->prod_group_ID == $vr["prodg"] ) ? ' selected' : null; |
36 echo "<option $select value=\"$row->prod_group_ID\">$row->prod_group_name</option>\n"; |
36 echo "<option $select value=\"$row->prod_group_ID\">$row->prod_group_name</option>\n"; |
37 } |
37 } |
38 } |
38 } |
39 ?> |
39 ?> |
40 </select> |
40 </select> |
41 </td> |
41 </td> |
42 </tr> |
42 </tr> |
|
43 <?php if ($rvnr == 1) |
|
44 { ?> |
43 <tr> |
45 <tr> |
44 <td>Produkt</td> |
46 <td>Produkt</td> |
45 <td><select name="vr[prod]"> |
47 <td><select name="vr[prod]"> |
46 <?php |
48 <?php |
47 $select = null; |
|
48 if ($vr["prod"] == -1) $select = " selected "; else $select = ""; |
49 if ($vr["prod"] == -1) $select = " selected "; else $select = ""; |
49 echo "<option $select value=\"-1\"></option>\n"; |
50 echo "<option $select value=\"-1\"></option>\n"; |
50 $sql = "SELECT produkt_ID, prod_name FROM Produkt ORDER BY 2"; |
51 if (isset($vr["prodg"]) && $vr["prodg"] > -1) $where = " WHERE prod_group_ID = $vr[prodg] "; else $where = ""; |
|
52 $sql = "SELECT produkt_ID, prod_name FROM Produkt $where ORDER BY 2"; |
51 if ($result = $dbc->queryObjectArray($sql)) |
53 if ($result = $dbc->queryObjectArray($sql)) |
52 { |
54 { |
53 foreach ($result as $row) |
55 $select = null; |
|
56 foreach ($result as $row) |
54 { |
57 { |
55 if (is_array($vr["prod"])) $select = in_array( $row->produkt_ID, $vr["prod"] ) ? ' selected' : null; |
58 if (isset($vr["prod"])) $select = ( $row->produkt_ID == $vr["prod"] ) ? ' selected' : null; |
56 echo "<option $select value=\"$row->produkt_ID\">$row->prod_name</option>\n"; |
59 echo "<option $select value=\"$row->produkt_ID\">$row->prod_name</option>\n"; |
57 } |
60 } |
58 } |
61 } |
59 ?> |
62 ?> |
60 </select> |
63 </select> |
61 </td> |
64 </td> |
62 </tr> |
65 </tr> |
|
66 <?php |
|
67 } ?> |
63 <tr> |
68 <tr> |
64 <td>Vertrag-Typ</td> |
69 <td>Vertrag-Typ</td> |
65 <td><select name="vr[vtyp]"> |
70 <td><select name="vr[vtyp]"> |
66 <?php |
71 <?php |
67 $select = null; |
|
68 if ($vr['vtyp'] == -1) $select = " selected "; else $select = ""; |
72 if ($vr['vtyp'] == -1) $select = " selected "; else $select = ""; |
69 echo "<option $select value=\"-1\"></option>\n"; |
73 echo "<option $select value=\"-1\"></option>\n"; |
70 $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2"; |
74 $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2"; |
71 if ($result = $dbc->queryObjectArray($sql)) |
75 if ($result = $dbc->queryObjectArray($sql)) |
72 { |
76 { |
|
77 $select = null; |
73 foreach ($result as $row) |
78 foreach ($result as $row) |
74 { |
79 { |
75 if (is_array($vr["vtyp"])) $select = in_array( $row->vtyp_ID, $vr["vtyp"] ) ? ' selected' : null; |
80 if (isset($vr["vtyp"])) $select = ( $row->vtyp_ID == $vr["vtyp"] ) ? ' selected' : null; |
76 echo "<option $select value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n"; |
81 echo "<option $select value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n"; |
77 } |
82 } |
78 } |
83 } |
79 ?> |
84 ?> |
80 </select> |
85 </select> |
81 </td> |
86 </td> |
82 </tr> |
87 </tr> |
|
88 <?php if ($rvnr == 2) |
|
89 { ?> |
|
90 <tr><td>gewünschtes<br />Kündigungsdatum</td> |
|
91 <td valign="top"><input type="text" name="vr[kd]" id="kd" value="<?php echo $vr['kd']; ?>"/> |
|
92 </td> |
|
93 </tr> |
|
94 <?php |
|
95 } ?> |
|
96 <?php if ($rvnr == 1) |
|
97 { ?> |
83 <tr> |
98 <tr> |
84 <td>Jahr</td> |
99 <td>Jahr</td> |
85 <td> |
100 <td> |
86 <select name="vr[jahr]" size="1"> |
101 <select name="vr[jahr]" size="1"> |
87 <?php |
102 <?php |
89 echo "<option selected value=\"-1\"></option>\n"; |
104 echo "<option selected value=\"-1\"></option>\n"; |
90 else |
105 else |
91 echo "<option value=\"-1\"></option>\n"; |
106 echo "<option value=\"-1\"></option>\n"; |
92 $ja = $vr['jahr']; |
107 $ja = $vr['jahr']; |
93 for ($i=2000; $i<2031; $i++) |
108 for ($i=2000; $i<2031; $i++) |
94 { if ($i==intval($j1)) |
109 { if ($i==intval($ja)) |
95 echo "<option selected>$ja1</option>\n"; |
110 echo "<option selected>$ja</option>\n"; |
96 else |
111 else |
97 echo "<option>$i</option>\n"; |
112 echo "<option>$i</option>\n"; |
98 } |
113 } |
99 ?> |
114 ?> |
100 </select> |
115 </select> |
101 </td> |
116 </td> |
102 </tr> |
117 </tr> |
|
118 <?php |
|
119 } ?> |
103 <tr> |
120 <tr> |
104 <td>Verknüpfung</td> |
121 <td>Verknüpfung</td> |
105 <td>UND |
122 <td>UND |
106 <input type="radio" name="vr[bind]" value="AND" <?php if (isset($vr["bind"]) && $vr["bind"]=="AND") echo "checked"; else echo "checked";?>> |
123 <input type="radio" name="vr[bind]" value="AND" <?php if (isset($vr["bind"]) && $vr["bind"]=="AND") echo "checked"; else echo "checked";?>> |
107 ODER |
124 ODER |
108 <input type="radio" name="vr[bind]" value="OR" <?php if (isset($vr["bind"]) && $vr["bind"]=="OR") echo "checked"; ?>></td> |
125 <input type="radio" name="vr[bind]" value="OR" <?php if (isset($vr["bind"]) && $vr["bind"]=="OR") echo "checked"; ?>></td> |
109 </tr> |
126 </tr> |
110 <tr> |
127 <tr> |
111 <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td> |
128 <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td> |
112 <?php |
129 <?php |
113 $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Kostenjahr"); |
130 if ($rvnr == 1) |
114 for ($i=1; $i<4; $i++) |
131 $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Jahr"); |
|
132 elseif ($rvnr ==2) |
|
133 $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","12"=>"Partner","13"=>"Kündigungstermin"); |
|
134 for ($i=1; $i<count($sort); $i++) |
115 { |
135 { |
116 echo "$i. <select name='vr[sort$i]'>\n"; |
136 echo "$i. <select name='vr[sort$i]'>\n"; |
117 foreach ($sort as $key=>$val) |
137 foreach ($sort as $key=>$val) |
118 { |
138 { |
119 $rsort = $sort . $i; |
139 if ($vr["sort$i"] == $key) $select= " selected"; else $select = ""; |
120 if ($rag[$rsort] == $i) $select= " selected"; else $select = ""; |
|
121 echo "<option$select value='$key'>$val</option>\n"; |
140 echo "<option$select value='$key'>$val</option>\n"; |
122 } |
141 } |
123 echo "</select> \n"; |
142 echo "</select> \n"; |
124 } |
143 } |
125 echo "</td></tr>\n"; |
144 echo "</td></tr>\n"; |