<?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');


?>