fhiiqm/ma_fkt_ed.php
changeset 10 f538f73ebc37
parent 9 f3ee378f9631
child 14 32203b8f40ee
--- a/fhiiqm/ma_fkt_ed.php	Tue Sep 13 16:32:49 2011 +0200
+++ b/fhiiqm/ma_fkt_ed.php	Thu Sep 15 11:45:38 2011 +0200
@@ -20,12 +20,19 @@
     <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness/jquery-ui-1.8.16.custom.css" rel="Stylesheet" />	
     <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.6.2.min.js"></script>
     <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.16.custom.min.js"></script>
-    <title>Funktionen</title>
+    <title>Mitarbeiter - Funktionen</title>
  </head>
  
  <body>
     <div class="float-r"><img src="img/reseller_account_template.png" border="0" alt="Mitarbeiter-Funktion" title="Mitarbeiter-Funktion"/></div>
     <div align='center'>
+<!--    <style type="text/css">
+        .ui-datepicker {
+            font-size: 11px;
+            background-color: #AEE7E7
+            }
+    </style>
+-->
     <script>
       $(document).ready(function() {
         $("#persknr").focus();
@@ -44,13 +51,19 @@
             dateFormat: 'yy-mm-dd',
             yearRange: '2000:2020',
             changeMonth: true,
-			changeYear: true
+			changeYear: true,
+            firstDay: 1,
+            dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ],
+            monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] 
         });
         $("#bis").datepicker({
             dateFormat: 'yy-mm-dd',
             yearRange: '2000:2025',
             changeMonth: true,
-			changeYear: true
+			changeYear: true,
+            firstDay: 1,
+            dayNamesMin: ['So', 'Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa'],
+            monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] 
         });
         $("input").filter("long20").addClass("long20");
         $("input").filter("long30").addClass("long30");
@@ -60,11 +73,10 @@
     
     <?php
         $fkt = $_POST["fkt"];
-        $fkt["fid"] = $fkt["func"];
+        $fkt["fid"] = $fkt["func"]; // kein autocomplete bei Funktion
         if (!$fkt["pid"]) $fkt["pid"] = $_GET["p"];
         if (!$fkt["fid"]) $fkt["fid"] = $_GET["f"];
         $sub = $_POST["eintragen"];
-           
         echo "<h3>Zuordnung von Funktionen zu Mitarbeitern<h3>";
         
         echo "</div>\n";    
@@ -73,7 +85,7 @@
         {
             if ($fkt["pid"] && $fkt["fid"])
             {
-                $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez  
+                $sql = "SELECT fkt_bereich, fkt_von, fkt_bis, fkt_bem, CONCAT(nachname,', ',vorname) AS vname, fkt_bez, ma.fkt_ID  
                         FROM fhiiqm.MA_Funktion ma INNER JOIN 
                         fhiiqm.Mitarbeiter m ON ma.persknr=m.persknr INNER JOIN
                         fhiiqm.Funktion f ON ma.fkt_ID=f.fkt_ID
@@ -83,7 +95,8 @@
                     foreach ($result as $row)
                     {
                         $fkt["persknr"] = $row->vname;
-                        $fkt["func"] = $row->fkt_bez;
+//                        $fkt["func"] = $row->fkt_bez;     // nur wenn autocomplete fuer Funktion genutzt wird
+                        $fkt["func"] = $row->fkt_ID;
                         $fkt["ber"] = $row->fkt_bereich;
                         $fkt["von"] = $row->fkt_von;
                         $fkt["bis"] = $row->fkt_bis;
@@ -145,7 +158,7 @@
                         if (is_object($stmt))
                         {
                             $stmt -> prepare("INSERT INTO fhiiqm.MA_Funktion (persknr,fkt_ID,fkt_bereich,fkt_von,fkt_bis,fkt_bem) VALUES(?,?,?,?,?,?)");
-                            $stmt -> bind_param('iss',$fkt["pid"],$fkt["fid"],$fkt["ber"], $fvon, $fbis, $fkt["bem"]);
+                            $stmt -> bind_param('isssss',$fkt["pid"],$fkt["fid"],$fkt["ber"], $fvon, $fbis, $fkt["bem"]);
                             $res = $stmt -> execute();
                             if ($dbc->error) echo "error: " . $dbc->errno." -> ".$dbc->error . "<br><br>\n";
                             if ($res)