110 lines
No EOL
4.1 KiB
PHP
110 lines
No EOL
4.1 KiB
PHP
<?php
|
|
|
|
$template->assign('m',3);
|
|
//-----------------------------------------------------------------------------------------------------------------------
|
|
$jahr1= (int)date('Y'); $j1['j']=$jahr1;
|
|
$jahr2=$jahr1-1; $j2['j']=$jahr2;
|
|
$jahr3=$jahr1-2; $j3['j']=$jahr3;
|
|
$jahr4=$jahr1-3; $j4['j']=$jahr4;
|
|
date_default_timezone_set('Europe/Berlin');
|
|
$maID=$_SESSION['maID']; $template->assign('maID', $maID);
|
|
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr1."' ORDER BY grund,monat,tag"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++; $ki=0;
|
|
$a1[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a1[$key]['name']=$bez['bez'];
|
|
$a1[$key]['grund']=$row['grund'];
|
|
|
|
|
|
|
|
|
|
} else { $a1[$key]['menge']++;
|
|
|
|
|
|
}
|
|
$temp1[$ki]['datum']=substr(str_repeat(0, 2).$row['tag'], - 2).'.'.substr(str_repeat(0, 2).$row['monat'], - 2).'.'.$jahr1;
|
|
$temp1[$ki]['name']=$bez['bez'];
|
|
$a1[$key]['einzel']=$temp1; $ki++;
|
|
$j1['a']=$a1;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr2."' ORDER BY grund,monat,tag"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a2[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a2[$key]['name']=$bez['bez'];
|
|
$a2[$key]['grund']=$row['grund'];
|
|
} else { $a2[$key]['menge']++;
|
|
|
|
}
|
|
$temp2[$ki]['datum']=substr(str_repeat(0, 2).$row['tag'], - 2).'.'.substr(str_repeat(0, 2).$row['monat'], - 2).'.'.$jahr2;
|
|
$temp2[$ki]['name']=$bez['bez'];
|
|
$a2[$key]['einzel']=$temp2; $ki++;
|
|
$j2['a']=$a2;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr3."' ORDER BY grund,monat,tag"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a3[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a3[$key]['name']=$bez['bez'];
|
|
$a3[$key]['grund']=$row['grund'];
|
|
} else { $a3[$key]['menge']++;
|
|
|
|
}
|
|
$temp3[$ki]['datum']=substr(str_repeat(0, 2).$row['tag'], - 2).'.'.substr(str_repeat(0, 2).$row['monat'], - 2).'.'.$jahr3;
|
|
$temp3[$ki]['name']=$bez['bez'];
|
|
$a3[$key]['einzel']=$temp3; $ki++;
|
|
$j3['a']=$a3;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr4."' ORDER BY grund,monat,tag"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a4[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a4[$key]['name']=$bez['bez'];
|
|
$a4[$key]['grund']=$row['grund'];
|
|
} else { $a4[$key]['menge']++;
|
|
|
|
}
|
|
$temp4[$ki]['datum']=substr(str_repeat(0, 2).$row['tag'], - 2).'.'.substr(str_repeat(0, 2).$row['monat'], - 2).'.'.$jahr4;
|
|
$temp4[$ki]['name']=$bez['bez'];
|
|
$a4[$key]['einzel']=$temp4; $ki++;
|
|
$j4['a']=$a4;
|
|
}
|
|
//-----------------------------------------------------------------------------------------------------------------------
|
|
$j1['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr1."' ");
|
|
$j2['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr2."' ");
|
|
$j3['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr3."' ");
|
|
$j4['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr4."' ");
|
|
|
|
$template->assign('j1', $j1);
|
|
$template->assign('j2', $j2);
|
|
$template->assign('j3', $j3);
|
|
$template->assign('j4', $j4);
|
|
|
|
$template->assign('content', 'tpl/ajax/ma_kal.tpl');
|
|
|
|
|
|
?>
|