|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 12/2011 |
|
6 */ |
|
7 |
|
8 error_reporting(E_ALL ^ E_NOTICE); |
|
9 |
|
10 session_start(); |
|
11 if (! isset($_SESSION["userid"])) |
|
12 { |
|
13 include_once ("inc/func_lib.inc.php"); |
|
14 login($_SERVER["PHP_SELF"]); |
|
15 exit; |
|
16 } |
|
17 |
|
18 if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("ar",$_SESSION["recht"]) && !in_array("ae",$_SESSION["recht"]))) |
|
19 { |
|
20 header("Location: start.php"); |
|
21 exit; |
|
22 } |
|
23 |
|
24 include_once($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/dbconnect.inc.php"); |
|
25 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
26 |
|
27 |
|
28 $al = $_POST["al"]; |
|
29 $alcid = $_GET["i"]; // al_ID_c_ID (z.B. 1_24) |
|
30 // $copy = $_GET["c"]; |
|
31 $sub = $_POST["eintragen"]; |
|
32 $del = $_POST["del"]; |
|
33 // $dup = $_POST["dup"]; |
|
34 // if (!$dup) $dup = $_GET["d"]; |
|
35 $ok = $_POST["ok"]; |
|
36 if (!$al['okn']) $ok=false; |
|
37 |
|
38 ?> |
|
39 |
|
40 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
41 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
|
42 |
|
43 <head> |
|
44 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
|
45 <link type="text/css" href="/fhiiqm/css/db.css" rel="Stylesheet" media="screen"/> |
|
46 <link type="text/css" href="/fhiiqm/css/db_print.css" rel="Stylesheet" media="print"/> |
|
47 <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness/jquery-ui-1.8.16.custom.css" rel="Stylesheet" /> |
|
48 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.6.2.min.js"></script> |
|
49 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.16.custom.min.js"></script> |
|
50 <title>Anlage - Vertrag</title> |
|
51 </head> |
|
52 |
|
53 <body> |
|
54 |
|
55 <?php |
|
56 echo " "; |
|
57 echo "<div class=\"float-br smaller\" valign='top'>"; |
|
58 echo " user: " . $_SESSION["userid"]; |
|
59 echo " <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n"; |
|
60 echo "<div class=\"float-r\"><img src=\"img/rotate_01.png\" border=\"0\" alt=\"Anlage\" title=\"Anlage\"/></div>\n"; |
|
61 ?> |
|
62 |
|
63 <div align='center'> |
|
64 |
|
65 <script> |
|
66 $(document).ready(function() { |
|
67 $("#albez").focus(); |
|
68 $("#albez").autocomplete({ |
|
69 source: "/fhiiqm/inc/al_list_ac.inc.php", |
|
70 minLength: 2, |
|
71 select: function(event,ui){$("#alid").val(ui.item.id);} |
|
72 }); |
|
73 $("#alcon").autocomplete({ |
|
74 source: "/fhiiqm/inc/alvertrag_list_ac.inc.php", |
|
75 minLength: 2, |
|
76 select: function(event,ui){$("#cid").val(ui.item.id);} |
|
77 }); |
|
78 $("input").albez("long20").addClass("long20"); |
|
79 $("input").alcon("long30").addClass("long20"); |
|
80 }); |
|
81 </script> |
|
82 |
|
83 <?php |
|
84 // print_r($al); |
|
85 |
|
86 if ($alcid) $text = "editieren"; else $text = "erfassen"; |
|
87 echo "<h3>Anlage - Vertrag $text<h3>"; |
|
88 |
|
89 echo "</div>\n"; |
|
90 |
|
91 if (!$ok || (!$sub && !$del )) |
|
92 { |
|
93 if ($alcid && !$sub && !$del ) |
|
94 { // ausgewaehlte id-Kombination |
|
95 $al["alid"] = substr($alcid,0,strpos($alcid,"_")); |
|
96 $al["cid"] = substr($alcid,strpos($alcid,"_")+1); |
|
97 $sql = "SELECT al_bez FROM fhiiqm.Anlage WHERE al_ID = " . $al["alid"]; |
|
98 $al["bez"] = $dbc -> querySingleItem($sql); |
|
99 $sql = "SELECT contract_name FROM fhiiqm.Vertrag WHERE contract_ID = " . $al["cid"]; |
|
100 $al["con"] = $dbc -> querySingleItem($sql); |
|
101 } |
|
102 include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/alvtr_form.inc.php"); |
|
103 if ($sub || $del) |
|
104 { |
|
105 if ($sub) |
|
106 $frage = "Alle Angaben ok?"; |
|
107 elseif ($del) |
|
108 $frage = "Anlage<->Vertrag wirklich löschen?"; |
|
109 echo "<tr> |
|
110 <td class=\"red\" valign=\"top\" align=\"left\">$frage</td> |
|
111 <td><input type=\"checkbox\" name=\"ok\" value=\"1\""; |
|
112 if ($ok) echo "checked"; |
|
113 echo "></td>\n</tr>\n"; |
|
114 } |
|
115 if (!is_null($_SESSION["recht"]) && in_array("ae",$_SESSION["recht"])) |
|
116 { |
|
117 echo " |
|
118 <tr><td> </td>\n |
|
119 <td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />"; |
|
120 if ($alcid) |
|
121 { |
|
122 echo " <input class=\"buttonr\" type=\"submit\" value=\"löschen\" name=\"del\" title=\"delete\" />"; |
|
123 // echo " <input class=\"button\" type=\"submit\" value=\"duplizieren\" name=\"dup\" title=\"delete\" />"; |
|
124 } |
|
125 echo "</td></tr>\n"; |
|
126 } |
|
127 echo "</table>\n"; |
|
128 echo "</div>\n"; |
|
129 if (!is_null($_SESSION["recht"]) && !in_array("ae", $_SESSION["recht"])) |
|
130 echo "<p class='sc'> <a href=\"alvtr_flist.php\" target=\"_self\" title=\"Anlage-Vertrag\">« zur Anlage-Vertrag-Liste</a></p>\n"; |
|
131 echo "</form>\n"; |
|
132 } |
|
133 else |
|
134 { |
|
135 // print_r($al); |
|
136 echo "<div align='center'>\n"; |
|
137 if ($alcid) |
|
138 { // ausgewaehlte id-Kombination |
|
139 $alid = substr($alcid,0,strpos($alcid,"_")); |
|
140 $cid = substr($alcid,strpos($alcid,"_")+1); |
|
141 } |
|
142 if ($del) |
|
143 { |
|
144 // DELETE - angewaehlter Vertrag zu Anlage |
|
145 $sql = "DELETE FROM fhiiqm.Anlage_Vertrag WHERE al_ID=$alid AND contract_ID=$cid"; |
|
146 $resd = $dbc -> execute($sql); |
|
147 if ($resd) |
|
148 echo "<p class='green'><b>DELETE: Zuordnung '".$al["bez"]."'zu '". $al['con']."' wurde erfolgreich gelöscht.</b></p>\n"; |
|
149 else |
|
150 { |
|
151 echo "<p class='red'><b>DELETE: Löschen Zuordnung '".$al["bez"]."'zu '". $al['con']."' ist fehlgeschlagen!</b></p>\n"; |
|
152 echo "DELETE error:" . $dbc -> error; |
|
153 } |
|
154 } |
|
155 else |
|
156 { |
|
157 //INSERT oder UPDATE |
|
158 if ($alcid) |
|
159 { |
|
160 //UPDATE |
|
161 $txt = "UPDATE"; |
|
162 //alte Zuordnung loeschen |
|
163 $sql = "DELETE FROM fhiiqm.Anlage_Vertrag WHERE al_ID=$alid AND contract_ID=$cid"; |
|
164 if ($dbc -> execute($sql)) |
|
165 { // neue Zuordnung hinzufuegen |
|
166 $sql = "INSERT INTO fhiiqm.Anlage_Vertrag VALUES(" . $al["alid"] .", ". $al["cid"].")"; |
|
167 $res = $dbc -> execute($sql); |
|
168 } |
|
169 else |
|
170 echo "DELETE error:" . $dbc -> error; |
|
171 |
|
172 } |
|
173 else |
|
174 { |
|
175 //INSERT |
|
176 $txt = "INSERT"; |
|
177 $sql = "INSERT INTO fhiiqm.Anlage_Vertrag VALUES(" . $al["alid"] .", ". $al["cid"].")"; |
|
178 $res = $dbc -> execute($sql); |
|
179 } |
|
180 if ($res) |
|
181 echo "<p class='green'><b>$txt: Zuordnung '".$al["bez"]."'zu '". $al['con']."' wurde erfolgreich gespeichert.</b></p>\n"; |
|
182 else |
|
183 { |
|
184 echo "<p class='red'><b>$txt: Eintragen Zuordnung '".$al["bez"]."'zu '". $al['con']."' ist fehlgeschlagen!</b></p>\n"; |
|
185 echo "$txt error:" . $dbc -> error; |
|
186 } |
|
187 } |
|
188 echo "</div>\n"; |
|
189 echo "<p class=\"sc\"> <a href=\"alvtr_flist.php\" target=\"_self\" title=\"Anlagen\">Anlage-Vertrag-Liste</a></p>\n"; |
|
190 echo "<p class=\"sc\"> <a href=\"alvtr_ed.php\" target=\"_self\" title=\"Anlage-Vertrag erfassen\">Weitere Zuordnung Anlage-Vertrag</a></p>"; |
|
191 } |
|
192 ?> |
|
193 </body> |
|
194 </html> |