96 <?php |
96 <?php |
97 $fkt = $_POST["fkt"]; |
97 $fkt = $_POST["fkt"]; |
98 $fkt["fid"] = $fkt["func"]; // kein autocomplete bei Funktion |
98 $fkt["fid"] = $fkt["func"]; // kein autocomplete bei Funktion |
99 if (!$fkt["pid"]) $fkt["pid"] = $_GET["p"]; |
99 if (!$fkt["pid"]) $fkt["pid"] = $_GET["p"]; |
100 if (!$fkt["fid"]) $fkt["fid"] = $_GET["f"]; |
100 if (!$fkt["fid"]) $fkt["fid"] = $_GET["f"]; |
|
101 $mfid = $_GET[i]; |
101 $sub = $_POST["eintragen"]; |
102 $sub = $_POST["eintragen"]; |
102 echo "<h3>Zuordnung von Funktionen zu Mitarbeitern<h3>"; |
103 echo "<h3>Zuordnung von Funktionen zu Mitarbeitern<h3>"; |
103 |
104 |
104 echo "</div>\n"; |
105 echo "</div>\n"; |
105 |
106 |
106 if ((!isset($fkt) && !$fkt) || !$fkt["pid"] || !$fkt["fid"] || !$sub) |
107 if ((!isset($fkt) && !$fkt) || !$fkt["pid"] || !$fkt["fid"] || !$sub) |
107 { |
108 { |
108 if ($fkt["pid"] && $fkt["fid"]) |
109 if ($fkt["pid"] && $fkt["fid"] && $mfid) |
109 { |
110 { |
110 $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez, ma.fkt_ID |
111 $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez, ma.fkt_ID |
111 FROM fhiiqm.MA_Funktion ma INNER JOIN |
112 FROM fhiiqm.MA_Funktion ma INNER JOIN |
112 fhiiqm.Mitarbeiter m ON ma.persknr=m.persknr INNER JOIN |
113 fhiiqm.Mitarbeiter m ON ma.persknr=m.persknr INNER JOIN |
113 fhiiqm.Funktion f ON ma.fkt_ID=f.fkt_ID |
114 fhiiqm.Funktion f ON ma.fkt_ID=f.fkt_ID |
114 WHERE ma.persknr = " . $fkt["pid"] . " AND ma.fkt_ID ='" . $fkt["fid"] ."'"; |
115 WHERE mf_ID = $mfid"; |
115 if ($result = $dbc -> queryObjectArray($sql)) |
116 if ($result = $dbc -> queryObjectArray($sql)) |
116 { |
117 { |
117 foreach ($result as $row) |
118 foreach ($result as $row) |
118 { |
119 { |
119 $fkt["persknr"] = $row->vname; |
120 $fkt["persknr"] = $row->vname; |
151 */ |
152 */ |
152 if ($fkt["pid"] && $fkt["fid"]) |
153 if ($fkt["pid"] && $fkt["fid"]) |
153 { |
154 { |
154 $sql="SELECT COUNT(*) FROM MA_Funktion WHERE persknr=" . $fkt["pid"] . " AND fkt_ID='" . $fkt["fid"] ."'"; |
155 $sql="SELECT COUNT(*) FROM MA_Funktion WHERE persknr=" . $fkt["pid"] . " AND fkt_ID='" . $fkt["fid"] ."'"; |
155 $result = $dbc ->querySingleItem($sql); |
156 $result = $dbc ->querySingleItem($sql); |
156 if ($result && $fkt["ber"]>"!") |
157 if ($result && $fkt["ber"]>"!" && $mfid) |
157 { // UPDATE |
158 { // UPDATE |
158 $stmt = $dbc -> stmtinit(); |
159 $stmt = $dbc -> stmtinit(); |
159 if (is_object($stmt)) |
160 if (is_object($stmt)) |
160 { |
161 { |
161 $stmt -> prepare("UPDATE fhiiqm.MA_Funktion SET |
162 $stmt -> prepare("UPDATE fhiiqm.MA_Funktion SET |
162 fkt_bereich = ?, |
163 fkt_bereich = ?, |
163 fkt_von = ?, |
164 fkt_von = ?, |
164 fkt_bis = ?, |
165 fkt_bis = ?, |
165 fkt_bem = ? |
166 fkt_bem = ? |
166 WHERE persknr=" . $fkt["pid"] . " AND fkt_ID='" . $fkt["fid"] ."'"); |
167 WHERE mf_ID = $mfid"); |
167 $stmt -> bind_param('ssss',$fkt["ber"], $fvon, $fbis, $fkt["bem"]); |
168 $stmt -> bind_param('ssss',$fkt["ber"], $fvon, $fbis, $fkt["bem"]); |
168 $res = $stmt -> execute(); |
169 $res = $stmt -> execute(); |
169 // print_r($stmt); |
170 // print_r($stmt); |
170 if ($stmt->error) echo "error: " . $stmt->errno." -> ".$stmt->error . "<br><br>\n"; |
171 if ($stmt->error) echo "error: " . $stmt->errno." -> ".$stmt->error . "<br><br>\n"; |
171 if ($res) |
172 if ($res) |