119 lines
No EOL
3.8 KiB
PHP
119 lines
No EOL
3.8 KiB
PHP
<?php
|
|
// echo "<pre>"; print_r($_POST); echo "</pre>";
|
|
|
|
if(isset($_GET['a']))
|
|
$action=$_GET['a'];
|
|
else
|
|
$action='load_free_urlaub';
|
|
switch($action):
|
|
|
|
case 'info_save';
|
|
// $GLOBALS['mysql']->insert("UPDATE planer SET info='".$_POST['info']."'WHERE id='".$_POST['tourID']."'");
|
|
$back['success'] = true;
|
|
$back['lastnote']="Information: ".$_POST['info']." hinzugefügt.";
|
|
$back['alt'] = 5;
|
|
echo json_encode($back);
|
|
|
|
break;
|
|
|
|
case 'date_save_old';
|
|
// echo "<pre>"; print_r("date: ".$_POST); echo "</pre>";
|
|
$jahr = date('Y',$_POST['time']);
|
|
$monat = date('m',$_POST['time']);
|
|
$tag = date('d',$_POST['time']);
|
|
$tstamp =date("Y-m-d H:i:s",$_POST['time']);
|
|
if($_POST['istC']==1) {
|
|
$GLOBALS['mysql']->insert("INSERT INTO planer (tag,monat,jahr,grund,mid,timestamp)
|
|
VALUES(
|
|
'".$tag."',
|
|
'".$monat."',
|
|
'".$jahr."',
|
|
'".$_POST['gID']."',
|
|
'".$_POST['maID']."',
|
|
'".($tstamp)."')
|
|
");
|
|
$back['lastnote']="Information: Urlaub am ".$tag.".".$monat.".".$jahr." hinzugefügt."; $back['typ']=1;
|
|
} else {
|
|
$GLOBALS['mysql']->query("DELETE FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND mid='".$_POST['maID']."' AND grund='".$_POST['gID']."'");
|
|
$back['lastnote']="Information: Urlaub am ".$tag.".".$monat.".".$jahr." gelöscht."; $back['typ']=0;
|
|
|
|
}
|
|
$back['success'] = true;
|
|
|
|
$back['alt'] = 5;
|
|
echo json_encode($back);
|
|
break;
|
|
|
|
case 'date_save';
|
|
// echo "<pre>"; print_r("date: ".$_POST); echo "</pre>";
|
|
$jahr = date('Y',$_POST['time']);
|
|
$monat = date('m',$_POST['time']);
|
|
$tag = date('d',$_POST['time']);
|
|
$tstamp =date("Y-m-d H:i:s",$_POST['time']);
|
|
if($_POST['istC']==1) {
|
|
$GLOBALS['mysql']->insert("INSERT INTO planer (tag,monat,jahr,grund,mid,timestamp)
|
|
VALUES(
|
|
'".$tag."',
|
|
'".$monat."',
|
|
'".$jahr."',
|
|
'4',
|
|
'".$_POST['maID']."',
|
|
'".($tstamp)."')
|
|
");
|
|
$back['lastnote']="Information: Urlaub am ".$tag.".".$monat.".".$jahr." hinzugefügt."; $back['typ']=1;
|
|
} else {
|
|
$GLOBALS['mysql']->query("DELETE FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND mid='".$_POST['maID']."' AND grund=4");
|
|
$back['lastnote']="Information: Urlaub am ".$tag.".".$monat.".".$jahr." gelöscht."; $back['typ']=0;
|
|
|
|
}
|
|
$back['success'] = true;
|
|
|
|
$back['alt'] = 5;
|
|
echo json_encode($back);
|
|
break;
|
|
|
|
case 'date_car';
|
|
echo "<pre>"; print_r("Car: ".$_POST); echo "</pre>";
|
|
$jahr = date('Y',$_POST['time']);
|
|
$monat = date('m',$_POST['time']);
|
|
$tag = date('d',$_POST['time']);
|
|
$tstamp =date("Y-m-d H:i:s",$_POST['time']);
|
|
if($_POST['istC']==1) {
|
|
$GLOBALS['mysql']->insert("INSERT INTO fplaner (tag,monat,jahr,grund,fid,timestamp)
|
|
VALUES(
|
|
'".$tag."',
|
|
'".$monat."',
|
|
'".$jahr."',
|
|
'".$_POST['gID']."',
|
|
'".$_POST['maID']."',
|
|
'".($tstamp)."')
|
|
");
|
|
} else {
|
|
$GLOBALS['mysql']->query("DELETE FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND fid='".$_POST['maID']."' AND grund='".$_POST['gID']."'");
|
|
|
|
}
|
|
$back['success'] = true;
|
|
|
|
$back['alt'] = 5;
|
|
echo json_encode($back);
|
|
|
|
break;
|
|
|
|
case 'load_free_urlaub';
|
|
default:
|
|
//--------------------- freier Urlaub aktuelles Jahr
|
|
$temp1=$GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_POST['maID']."'");
|
|
$temp2=$GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$_POST['jahr']."' and grund in(4,31) ");
|
|
$temp3=$temp1['urlaubprojahr']-$temp2['num_rows'];
|
|
//$temp4="Resturlaub ".$_POST['jahr'].": ".$temp3." Tag(e)";
|
|
//$temp4="Summe ".$_POST['jahr']." gesamt: ".$temp1['urlaubprojahr']." Tage genommen: ".$temp2['num_rows']." Tage Rest: ".$temp3." Tage.";
|
|
// echo json_encode($temp4);
|
|
$template->assign('jahr', $jahr);
|
|
$template->assign('u_gesa', $temp1['urlaubprojahr']);
|
|
$template->assign('u_geno', $temp2['num_rows']);
|
|
$template->assign('u_rest', $temp3);
|
|
$template->assign('content', 'tpl/kal_rest_u.tpl');
|
|
|
|
endswitch;
|
|
|
|
?>
|