83 include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php"); |
83 include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php"); |
84 $dbc = new dbconnection(); |
84 $dbc = new dbconnection(); |
85 |
85 |
86 echo "<div align='center'>\n"; |
86 echo "<div align='center'>\n"; |
87 //echo "$sort, $dir, $fnum, $filter<br><br>\n"; |
87 //echo "$sort, $dir, $fnum, $filter<br><br>\n"; |
88 $sql = "CALL fhiiqm.vertrag_flist1(" . $sort . ",'" . $dir . "', " . $fnum . ", '" . $filter . "',$start,$zeil, @anz)"; |
88 // $sql = "CALL fhiiqm.vertrag_flist1(" . $sort . ",'" . $dir . "', " . $fnum . ", '" . $filter . "',$start,$zeil, @anz)"; |
|
89 $sql = "CALL fhiiqm.vertrag_flist1_1(" . $sort . ",'" . $dir . "', " . $fnum . ", '" . $filter . "',$start,$zeil, @anz)"; |
89 // Parameter: Nr. Sortfelf, Sortierrichtung, Nr. Filterfeld, Filterbegriff, Start bei DS $start+1, Anzahl DS/Seite, Anzahl gefundener Vertraege |
90 // Parameter: Nr. Sortfelf, Sortierrichtung, Nr. Filterfeld, Filterbegriff, Start bei DS $start+1, Anzahl DS/Seite, Anzahl gefundener Vertraege |
90 // liefert Felder: contract_ID,cname,clong,bearb,doc,typ,prod |
91 // liefert Felder: contract_ID,cname,clong,bearb,doc,typ,prod |
91 $result = $dbc -> queryObjectArray($sql); |
92 $result = $dbc -> queryObjectArray($sql); |
92 if ($result) |
93 if ($result) |
93 { |
94 { |
143 // <th>Dokument</th><th>Bemerkung</th><th> </th></tr>\n"; |
144 // <th>Dokument</th><th>Bemerkung</th><th> </th></tr>\n"; |
144 |
145 |
145 echo "<tr bgcolor='#68ACBF'>"; |
146 echo "<tr bgcolor='#68ACBF'>"; |
146 tab_column(2,"Bezeichnung",$sort,$dir,2,$fnum,$filter,$start,$zeil); |
147 tab_column(2,"Bezeichnung",$sort,$dir,2,$fnum,$filter,$start,$zeil); |
147 tab_column(3,"Beschreibung",$sort,$dir,0,$fnum,$filter,$start,$zeil); |
148 tab_column(3,"Beschreibung",$sort,$dir,0,$fnum,$filter,$start,$zeil); |
|
149 tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil); |
|
150 tab_column(7,"zu Produkt",$sort,$dir,7,$fnum,$filter,$start,$zeil); |
|
151 tab_column(8,"Partner",$sort,$dir,8,$fnum,$filter,$start,$zeil); |
148 tab_column(4,"Bearbeiter",$sort,$dir,4,$fnum,$filter,$start,$zeil); |
152 tab_column(4,"Bearbeiter",$sort,$dir,4,$fnum,$filter,$start,$zeil); |
149 tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil); |
153 tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil); |
150 tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil); |
|
151 tab_column(7,"zu Produkt",$sort,$dir,7,$fnum,$filter,$start,$zeil); |
|
152 echo "<th> </th></tr>\n"; |
154 echo "<th> </th></tr>\n"; |
153 foreach ($result as $row) |
155 foreach ($result as $row) |
154 { |
156 { |
155 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
157 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
156 echo "<tr bgcolor='" . $bg . "'><td><b>$row->cname</b></td>"; |
158 echo "<tr bgcolor='" . $bg . "'><td width='17%'><b>$row->cname</b></td>"; |
157 // echo "<td>$row->contract_s</td>"; |
159 // echo "<td>$row->contract_s</td>"; |
158 echo "<td>" . nl2br($row->clong) . "</td>"; |
160 echo "<td width='22%'>" . nl2br($row->clong) . "</td>"; |
|
161 echo "<td>$row->typ</td>"; |
|
162 echo "<td>$row->prod</td>"; |
|
163 echo "<td>$row->partfirma</td>"; |
159 echo "<td>$row->bearb</td>"; |
164 echo "<td>$row->bearb</td>"; |
160 if (file_exists("documents/".$row->doc)) |
165 if (file_exists("documents/".$row->doc)) |
161 { |
166 { |
162 $doc = substr($row->doc,strpos($row->doc,"_")+1); |
167 $doc = substr($row->doc,strpos($row->doc,"_")+1); |
163 echo "<td><a href='documents/$row->doc'>$doc</a></td>"; |
168 echo "<td><a href='documents/$row->doc'>$doc</a></td>"; |
164 } |
169 } |
165 else |
170 else |
166 echo "<td>$row->doc</td>"; |
171 echo "<td>$row->doc</td>"; |
167 echo "<td>$row->typ</td>"; |
|
168 echo "<td>$row->prod</td>"; |
|
169 echo "<td><a href='/fhiiqm/vertrag_upd.php?uid=$row->contract_ID'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n"; |
172 echo "<td><a href='/fhiiqm/vertrag_upd.php?uid=$row->contract_ID'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n"; |
170 } |
173 } |
171 echo "</table></div>\n"; |
174 echo "</table></div>\n"; |
172 echo "<br /> "; |
175 echo "<br /> "; |
173 |
176 |