18 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
18 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
19 <link type="text/css" href="/fhiiqm/css/db.css" rel="Stylesheet" /> |
19 <link type="text/css" href="/fhiiqm/css/db.css" rel="Stylesheet" /> |
20 <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness/jquery-ui-1.8.16.custom.css" rel="Stylesheet" /> |
20 <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness/jquery-ui-1.8.16.custom.css" rel="Stylesheet" /> |
21 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.6.2.min.js"></script> |
21 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.6.2.min.js"></script> |
22 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.16.custom.min.js"></script> |
22 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.16.custom.min.js"></script> |
23 <title>Funktionen</title> |
23 <title>Mitarbeiter - Funktionen</title> |
24 </head> |
24 </head> |
25 |
25 |
26 <body> |
26 <body> |
27 <div class="float-r"><img src="img/reseller_account_template.png" border="0" alt="Mitarbeiter-Funktion" title="Mitarbeiter-Funktion"/></div> |
27 <div class="float-r"><img src="img/reseller_account_template.png" border="0" alt="Mitarbeiter-Funktion" title="Mitarbeiter-Funktion"/></div> |
28 <div align='center'> |
28 <div align='center'> |
|
29 <!-- <style type="text/css"> |
|
30 .ui-datepicker { |
|
31 font-size: 11px; |
|
32 background-color: #AEE7E7 |
|
33 } |
|
34 </style> |
|
35 --> |
29 <script> |
36 <script> |
30 $(document).ready(function() { |
37 $(document).ready(function() { |
31 $("#persknr").focus(); |
38 $("#persknr").focus(); |
32 $("#persknr").autocomplete({ |
39 $("#persknr").autocomplete({ |
33 source: "/fhiiqm/inc/ma_list_ac.inc.php", |
40 source: "/fhiiqm/inc/ma_list_ac.inc.php", |
42 */ |
49 */ |
43 $("#von").datepicker({ |
50 $("#von").datepicker({ |
44 dateFormat: 'yy-mm-dd', |
51 dateFormat: 'yy-mm-dd', |
45 yearRange: '2000:2020', |
52 yearRange: '2000:2020', |
46 changeMonth: true, |
53 changeMonth: true, |
47 changeYear: true |
54 changeYear: true, |
|
55 firstDay: 1, |
|
56 dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ], |
|
57 monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] |
48 }); |
58 }); |
49 $("#bis").datepicker({ |
59 $("#bis").datepicker({ |
50 dateFormat: 'yy-mm-dd', |
60 dateFormat: 'yy-mm-dd', |
51 yearRange: '2000:2025', |
61 yearRange: '2000:2025', |
52 changeMonth: true, |
62 changeMonth: true, |
53 changeYear: true |
63 changeYear: true, |
|
64 firstDay: 1, |
|
65 dayNamesMin: ['So', 'Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa'], |
|
66 monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] |
54 }); |
67 }); |
55 $("input").filter("long20").addClass("long20"); |
68 $("input").filter("long20").addClass("long20"); |
56 $("input").filter("long30").addClass("long30"); |
69 $("input").filter("long30").addClass("long30"); |
57 $("input").filter("long50").addClass("long50"); |
70 $("input").filter("long50").addClass("long50"); |
58 }); |
71 }); |
59 </script> |
72 </script> |
60 |
73 |
61 <?php |
74 <?php |
62 $fkt = $_POST["fkt"]; |
75 $fkt = $_POST["fkt"]; |
63 $fkt["fid"] = $fkt["func"]; |
76 $fkt["fid"] = $fkt["func"]; // kein autocomplete bei Funktion |
64 if (!$fkt["pid"]) $fkt["pid"] = $_GET["p"]; |
77 if (!$fkt["pid"]) $fkt["pid"] = $_GET["p"]; |
65 if (!$fkt["fid"]) $fkt["fid"] = $_GET["f"]; |
78 if (!$fkt["fid"]) $fkt["fid"] = $_GET["f"]; |
66 $sub = $_POST["eintragen"]; |
79 $sub = $_POST["eintragen"]; |
67 |
|
68 echo "<h3>Zuordnung von Funktionen zu Mitarbeitern<h3>"; |
80 echo "<h3>Zuordnung von Funktionen zu Mitarbeitern<h3>"; |
69 |
81 |
70 echo "</div>\n"; |
82 echo "</div>\n"; |
71 |
83 |
72 if ((!isset($fkt) && !$fkt) || !$fkt["pid"] || !$fkt["fid"] || !$sub) |
84 if ((!isset($fkt) && !$fkt) || !$fkt["pid"] || !$fkt["fid"] || !$sub) |
73 { |
85 { |
74 if ($fkt["pid"] && $fkt["fid"]) |
86 if ($fkt["pid"] && $fkt["fid"]) |
75 { |
87 { |
76 $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez |
88 $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez, ma.fkt_ID |
77 FROM fhiiqm.MA_Funktion ma INNER JOIN |
89 FROM fhiiqm.MA_Funktion ma INNER JOIN |
78 fhiiqm.Mitarbeiter m ON ma.persknr=m.persknr INNER JOIN |
90 fhiiqm.Mitarbeiter m ON ma.persknr=m.persknr INNER JOIN |
79 fhiiqm.Funktion f ON ma.fkt_ID=f.fkt_ID |
91 fhiiqm.Funktion f ON ma.fkt_ID=f.fkt_ID |
80 WHERE ma.persknr = " . $fkt["pid"] . " AND ma.fkt_ID ='" . $fkt["fid"] ."'"; |
92 WHERE ma.persknr = " . $fkt["pid"] . " AND ma.fkt_ID ='" . $fkt["fid"] ."'"; |
81 if ($result = $dbc -> queryObjectArray($sql)) |
93 if ($result = $dbc -> queryObjectArray($sql)) |
82 { |
94 { |
83 foreach ($result as $row) |
95 foreach ($result as $row) |
84 { |
96 { |
85 $fkt["persknr"] = $row->vname; |
97 $fkt["persknr"] = $row->vname; |
86 $fkt["func"] = $row->fkt_bez; |
98 // $fkt["func"] = $row->fkt_bez; // nur wenn autocomplete fuer Funktion genutzt wird |
|
99 $fkt["func"] = $row->fkt_ID; |
87 $fkt["ber"] = $row->fkt_bereich; |
100 $fkt["ber"] = $row->fkt_bereich; |
88 $fkt["von"] = $row->fkt_von; |
101 $fkt["von"] = $row->fkt_von; |
89 $fkt["bis"] = $row->fkt_bis; |
102 $fkt["bis"] = $row->fkt_bis; |
90 $fkt["bem"] = $row->fkt_bem; |
103 $fkt["bem"] = $row->fkt_bem; |
91 } |
104 } |
143 { // INSERT |
156 { // INSERT |
144 $stmt = $dbc -> stmtinit(); |
157 $stmt = $dbc -> stmtinit(); |
145 if (is_object($stmt)) |
158 if (is_object($stmt)) |
146 { |
159 { |
147 $stmt -> prepare("INSERT INTO fhiiqm.MA_Funktion (persknr,fkt_ID,fkt_bereich,fkt_von,fkt_bis,fkt_bem) VALUES(?,?,?,?,?,?)"); |
160 $stmt -> prepare("INSERT INTO fhiiqm.MA_Funktion (persknr,fkt_ID,fkt_bereich,fkt_von,fkt_bis,fkt_bem) VALUES(?,?,?,?,?,?)"); |
148 $stmt -> bind_param('iss',$fkt["pid"],$fkt["fid"],$fkt["ber"], $fvon, $fbis, $fkt["bem"]); |
161 $stmt -> bind_param('isssss',$fkt["pid"],$fkt["fid"],$fkt["ber"], $fvon, $fbis, $fkt["bem"]); |
149 $res = $stmt -> execute(); |
162 $res = $stmt -> execute(); |
150 if ($dbc->error) echo "error: " . $dbc->errno." -> ".$dbc->error . "<br><br>\n"; |
163 if ($dbc->error) echo "error: " . $dbc->errno." -> ".$dbc->error . "<br><br>\n"; |
151 if ($res) |
164 if ($res) |
152 echo "<p class='green'><b>INSERT: Zuordnung von '".$fkt["func"]."' zu '".$fkt["persknr"]."' wurde erfolgreich gespeichert.</b></p>\n"; |
165 echo "<p class='green'><b>INSERT: Zuordnung von '".$fkt["func"]."' zu '".$fkt["persknr"]."' wurde erfolgreich gespeichert.</b></p>\n"; |
153 else |
166 else |