|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 06/2011 |
|
6 * |
|
7 * Anlisten Vertrag - INSERT/UPDATE-Daten |
|
8 */ |
|
9 |
|
10 echo "<table>\n"; |
|
11 echo "<tr><td>Vertragsbezeichnung: </td><td>" . $vtr['cname']. "</td></tr>\n"; |
|
12 // echo "<tr><td>Vertrag-Titel: </td><td>" . $vtr['cshort']. "</td></tr>\n"; |
|
13 echo "<tr><td>Vertrag-Beschreibung: </td><td>" . $vtr['clong']. "</td></tr>\n"; |
|
14 |
|
15 $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ WHERE vtyp_ID=" . $vtr['vtyp']; |
|
16 if ($result = $dbc->queryObjectArray($sql)) |
|
17 { |
|
18 foreach ($result as $row) |
|
19 echo "<tr><td>Vertrag-Typ: </td><td>" . $row->vtyp_bezeichnung. "</td></tr>\n"; |
|
20 } |
|
21 |
|
22 // if (!is_null($vbegin)) $vbd = $vtr['btag'] . "." . $vtr['bmon'] . "." . $vtr['bjahr']; else $vdb=null; |
|
23 // if (!is_null($vend)) $ved = $vtr['etag'] . "." . $vtr['emon'] . "." . $vtr['ejahr']; else $vdb=null; |
|
24 if (is_object($vbegin)) $vbd = $vbegin->format('d.m.Y'); else $vbd = " "; |
|
25 if (is_object($vend)) $ved = $vend->format('d.m.Y'); else $ved = " "; |
|
26 echo "<tr><td>Vertrag-Beginn: </td><td>" . $vbd. "</td></tr>\n"; |
|
27 echo "<tr><td>Vertrag-Ende: </td><td>" . $ved. "</td></tr>\n"; |
|
28 |
|
29 echo "<tr><td>Kündigungsfrist (mon vor V-Ende): </td><td>" . $vtr['cnot'] . "</td></tr>\n"; |
|
30 // Partner |
|
31 $sql = "SELECT part_firma FROM Partner WHERE part_ID = $pid"; |
|
32 if ($result = $dbc -> queryObjectArray($sql)) |
|
33 { |
|
34 foreach ($result as $row) |
|
35 echo "<tr><td>Partner: </td><td>" . $row->part_firma. "</td></tr>\n"; |
|
36 } |
|
37 //Bearbeiter |
|
38 if (is_array($vtr['cpers'])) |
|
39 foreach ($vtr['cpers'] as $pers) |
|
40 { |
|
41 if ($pers != -1) |
|
42 { |
|
43 $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=$pers ORDER BY pname"; |
|
44 if ($result = $dbc->queryObjectArray($sql)) |
|
45 { |
|
46 foreach ($result as $row) |
|
47 echo "<tr><td>Bearbeiter: </td><td>" . $row->pname. "</td></tr>\n"; |
|
48 } |
|
49 } |
|
50 } |
|
51 // Kosten |
|
52 echo "<tr><td>jährliche Kosten: </td><td>"; |
|
53 $j=0; |
|
54 if ($vtr['ejahr']) // Endjahr angegeben |
|
55 { |
|
56 for ($i=(int)$vtr['bjahr']; $i< (int)$vtr['ejahr'] +1; $i++) |
|
57 { |
|
58 if ($vtr['kost'][$j]) |
|
59 { |
|
60 echo "$i: ". $vtr['kost'][$j] ." € <br />"; |
|
61 } |
|
62 $j++; |
|
63 } |
|
64 } |
|
65 else // nur fuer Startjahr |
|
66 echo $vtr['bjahr'].": ". $vtr['kost'][$j] ." € "; |
|
67 // Produkt |
|
68 $sql = "SELECT prod_name FROM Produkt WHERE produkt_ID = " . $vtr['prodid']; |
|
69 if ($result = $dbc -> queryObjectArray($sql)) |
|
70 { |
|
71 foreach ($result as $row) |
|
72 echo "<tr><td>zugeordnet zu: </td><td>" . $row->prod_name. "</td></tr>\n"; |
|
73 } |
|
74 |
|
75 echo "</td></tr>\n"; |
|
76 if (file_exists("documents/$cfile")) |
|
77 echo "<tr><td>Dateibezeichnung Dokument: </td><td><a href='documents/$cfile'>" . $cfile. "</a></td></tr>\n"; |
|
78 else |
|
79 echo "<tr><td>Dateibezeichnung Dokument: </td><td>$cfile</td></tr>\n"; |
|
80 echo "<tr><td>Bemerkung: </td><td>" . nl2br($vtr['cbem']). "</td></tr>\n"; |
|
81 echo "</table>\n"; |
|
82 |
|
83 |
|
84 ?> |