--- 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)