equal
deleted
inserted
replaced
75 } |
75 } |
76 $par = $_POST["par"]; // Parameter aus Form |
76 $par = $_POST["par"]; // Parameter aus Form |
77 $search = $_POST["search"]; |
77 $search = $_POST["search"]; |
78 if (!$search) $search = $_GET["s"]; |
78 if (!$search) $search = $_GET["s"]; |
79 |
79 |
80 |
|
81 if ($search && $_GET['s'] != 2) |
80 if ($search && $_GET['s'] != 2) |
82 { |
81 { |
83 echo "<span class='sc'>"; |
82 echo "<span class='sc'>"; |
84 echo "<br /> <a href=\"/fhiiqm/info_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>"; |
83 echo "<br /> <a href=\"/fhiiqm/info_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>"; |
85 echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"MA - Relation\" class='sc'>neuer Bericht Mitarbeiter & Zuordnungen</a>\n"; |
84 echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"MA - Relation\" class='sc'>neuer Bericht Mitarbeiter & Zuordnungen</a>\n"; |
86 echo "</span>"; |
85 echo "</span>"; |
87 } |
86 } |
88 echo "<div align='center'>\n"; |
87 echo "<div align='center'>\n"; |
89 echo "<p class='sc'><b>Mitarbeiter und ihre Zuordnungen</b></p>\n"; |
88 echo "<p><b>Mitarbeiter und ihre Zuordnungen</b></p>\n"; |
90 echo "</div>\n"; |
89 echo "</div>\n"; |
91 |
90 |
92 |
91 |
93 if (!$search) |
92 if (!$search) |
94 { |
93 { |
97 <p>Bitte Kriterien für die Suche wählen</p> |
96 <p>Bitte Kriterien für die Suche wählen</p> |
98 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self"> |
97 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self"> |
99 <table width="30%" border="0" cellspacing="3" cellpadding="3"> |
98 <table width="30%" border="0" cellspacing="3" cellpadding="3"> |
100 <tr><td>Status Mitarbeiter/Objekt</td> |
99 <tr><td>Status Mitarbeiter/Objekt</td> |
101 <td><select name="par[act]" size="1" onchange="this.form.submit();"> |
100 <td><select name="par[act]" size="1" onchange="this.form.submit();"> |
102 <option value="0" <?php if ($par["act"]== 0) echo "selected='selected'"; ?>>ausgeschieden</option> |
101 <option value="1" <?php if ($par["act"]== "1") echo "selected='selected'"; ?>>aktiv</option> |
103 <option value="1" <?php if ($par["act"]== 1) echo "selected='selected'"; ?>>aktiv</option> |
102 <option value="0" <?php if ($par["act"]== "0") echo "selected='selected'"; ?>>ausgeschieden</option> |
104 <option value="2" <?php if ($par["act"]== 2) echo "selected='selected'"; ?>>sonstig</option> |
103 <option value="2" <?php if ($par["act"]== "2") echo "selected='selected'"; ?>>sonstig</option> |
105 </select></td> |
104 </select></td> |
106 </tr> |
105 </tr> |
107 <tr> |
106 <tr> |
108 <td>Mitarbeiter</td> |
107 <td>Mitarbeiter</td> |
109 <td><input class="long20" type="text" name="par[persknr]" id="persknr" value="<?php echo $par['persknr']; ?>"/> |
108 <td><input class="long20" type="text" name="par[persknr]" id="persknr" value="<?php echo $par['persknr']; ?>"/> |
119 echo "<option value=$row->abt_name>$row->abt_name</option>" |
118 echo "<option value=$row->abt_name>$row->abt_name</option>" |
120 ?> |
119 ?> |
121 </select> |
120 </select> |
122 </td> |
121 </td> |
123 </tr> |
122 </tr> |
124 <?php if (!isset($par["act"]) || $par["act"]== 0) |
123 <?php if ($par["act"]== "0") |
125 { |
124 { |
126 echo "<tr> |
125 echo "<tr> |
127 <td>ab Datum</td> |
126 <td>ab Datum</td> |
128 <td><input class=\"long10\" name=\"par[dat]\" id=\"dat\" value=\"".$par['dat']."\" /></td> |
127 <td><input class=\"long10\" name=\"par[dat]\" id=\"dat\" value=\"".$par['dat']."\" /></td> |
129 </tr>\n"; |
128 </tr>\n"; |
151 $sql = "CALL ma_relation('".$par["act"]."',". $par["pers"].",'".$par["abt"]."','".$par["dat"]."')"; |
150 $sql = "CALL ma_relation('".$par["act"]."',". $par["pers"].",'".$par["abt"]."','".$par["dat"]."')"; |
152 //echo "$sql<br />"; |
151 //echo "$sql<br />"; |
153 $result = $dbc -> queryObjectArray($sql); |
152 $result = $dbc -> queryObjectArray($sql); |
154 if ($result) |
153 if ($result) |
155 { |
154 { |
156 echo "<p class='sc'>$krit</p>"; |
155 echo "<p>$krit</p>"; |
157 $begin = 0; |
156 $begin = 0; |
158 // print_r ($result); |
157 // print_r ($result); |
159 foreach ($result as $row) |
158 foreach ($result as $row) |
160 { |
159 { |
161 if ($begin) echo "<p style=\"page-break-before:always\"> </p>"; |
160 if ($begin) echo "<p style=\"page-break-before:always\"> </p>"; |
240 $arr = explode("; ",$row->prozva); |
239 $arr = explode("; ",$row->prozva); |
241 foreach ($arr as $e) |
240 foreach ($arr as $e) |
242 $str .= "<br />" . substr($e,strpos($e,"|")+1); |
241 $str .= "<br />" . substr($e,strpos($e,"|")+1); |
243 echo "$str</td></tr>\n"; |
242 echo "$str</td></tr>\n"; |
244 } |
243 } |
|
244 if ($row->tel) |
|
245 { |
|
246 $str=null; |
|
247 echo "<tr><td><u>Telefon/Fax:</u> "; |
|
248 $arr = explode("; ",$row->tel); |
|
249 foreach ($arr as $e) |
|
250 { |
|
251 $fax = (substr($e,strpos($e,"|")+1) == 'fax')? ' FAX' : ''; |
|
252 $str .= "<br />" . substr($e,0,strpos($e,"|")) . $fax; |
|
253 } |
|
254 echo "$str</td></tr>\n"; |
|
255 } |
245 echo "</table>\n"; |
256 echo "</table>\n"; |
246 // $begin = 1; |
257 // $begin = 1; |
247 echo "<p> </p>\n"; |
258 echo "<p> </p>\n"; |
248 } |
259 } |
249 } |
260 } |