99 lines
2.7 KiB
PHP
99 lines
2.7 KiB
PHP
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
|
|
<meta charset="UTF-8">
|
|
|
|
<?php
|
|
$_SESSION['m1']=6; $_SESSION['m2']=6;
|
|
error_reporting(E_ALL); ini_set('display_errors', 1);
|
|
|
|
// echo "<pre>"; print_r($data); echo "</pre>";
|
|
if(isset($_GET['wahl'])) {
|
|
if($_GET['wahl']==1) {
|
|
if($_GET['monat']==1) {
|
|
$monat=12; $jahr=$_GET['jahr']-1; } else { $monat=$_GET['monat']-1; if($monat<10) { $monat="0".$monat; } $jahr=$_GET['jahr'];
|
|
}
|
|
}
|
|
if($_GET['wahl']==2) {
|
|
if($_GET['monat']==12) {
|
|
$monat=1; $jahr=$_GET['jahr']+1; } else { $monat=$_GET['monat']+1; if($monat<10) { $monat="0".$monat; } $jahr=$_GET['jahr'];
|
|
}
|
|
}
|
|
if($_GET['wahl']==3) {
|
|
$monat=1; $jahr=$_GET['jahr']-1; if($monat<10) { $monat="0".$monat; }
|
|
}
|
|
if($_GET['wahl']==4) {
|
|
$monat=1; $jahr=$_GET['jahr']+1; if($monat<10) { $monat="0".$monat; }
|
|
}
|
|
} else {
|
|
$jahr = date('Y');
|
|
$monat = date('m')-1;
|
|
}
|
|
|
|
|
|
//$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
|
|
$makal = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter ORDER by name"); $key=0;
|
|
while($row = $makal->fetch_assoc()) {
|
|
$kalender = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE monat='".$monat."' AND jahr='".$jahr."' AND mid='".$row['id']."' ORDER by tag");
|
|
if ($kalender['num_rows']!=0) {
|
|
$kaldata = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE monat='".$monat."' AND jahr='".$jahr."' AND mid='".$row['id']."' ORDER by tag");
|
|
while($kdata = $kaldata->fetch_assoc()) {
|
|
$data[$key]['wechsel'] = 0;
|
|
$data[$key]['name'] = $row['name'];
|
|
$data[$key]['info'] = $kdata['info'];
|
|
$data[$key]['time'] = mktime(0, 0, 0,$kdata['monat'],$kdata['tag'],$kdata['jahr']);
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kdata['grund']."'");
|
|
$data[$key]['grund'] = $row_icon['bez'];
|
|
$key++;
|
|
}
|
|
$data[$key]['wechsel'] = 1; $key++;
|
|
//----------------------------------------------
|
|
$temp1 = $GLOBALS['mysql']->query("SELECT * FROM planer_bez WHERE id<80"); $zz=0;
|
|
while($row2 = $temp1->fetch_assoc()) {
|
|
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$row['id']."' AND monat='".$monat."' AND jahr='".$jahr."' AND grund='".$row2['id']."'");
|
|
if($kd['num_rows']>0) {
|
|
$tmp[$zz]['a']=$kd['num_rows']." x";
|
|
$tmp[$zz]['c']=$row2['bez'];
|
|
$tmp[$zz]['wechsel'] = 0;
|
|
$zz++;
|
|
$template->assign('data2', $tmp);
|
|
}
|
|
}
|
|
$tmp[$zz]['wechsel'] = 1; $zz++;
|
|
//echo "<pre>"; print_r($tmp); echo "</pre>";
|
|
|
|
|
|
}
|
|
}
|
|
//echo "<pre>"; print_r($data); echo "</pre>";
|
|
|
|
$template->assign('data', $data);
|
|
$template->assign('jahr', $jahr);
|
|
$template->assign('monat', $monat);
|
|
|
|
$template->assign('content', 'tpl/a_makal.tpl');
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|