<?php
error_reporting(E_ALL);	ini_set('display_errors',0);

$template->assign('m',1);

$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;

$maID=$_SESSION['maID']; $template->assign('maID', $maID);

$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr1."' ORDER BY grund"); $key=0; $grund=0;
	while($row = $ktemp->fetch_assoc()) {
		
		if($grund!=$row['grund']) { 
			$grund=$row['grund']; $key++;
			$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']++; 
			
		}
		
		$j1['a']=$a1;
	}	
//--------------------------------------------------
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr2."' ORDER BY grund"); $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']++; 
			
		}
		
		$j2['a']=$a2;
	}	
//--------------------------------------------------
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr3."' ORDER BY grund"); $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']++; 
			
		}
		
		$j3['a']=$a3;
	}	
//--------------------------------------------------
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr4."' ORDER BY grund"); $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']++; 
			
		}
		
		$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."' "); 
//-----------------------------------------------------------------------------------------------------------------------
//$test=$GLOBALS['mysql']->query_single("SELECT * FROM kartenlog WHERE user='".$_POST['maID']."'");
//$klog = $GLOBALS['mysql']->query("SELECT zeit FROM kartenlog WHERE user='".$_POST['maID']."' DESC LIMIT 30"); 

$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog WHERE user='".$_POST['maID']."' ORDER BY logID DESC LIMIT 0,30"); $time=0; $key;
while($row_anlage = $anlage->fetch_assoc()) {
	if ($time==0) { $time=$row_anlage['zeit']; }
	$status[$key]['diff']=gmdate("H:i", $time-$row_anlage['zeit']);
	$time=$row_anlage['zeit'];
	$status[$key]['zeit']=gmdate("d.m.Y - H:i",$row_anlage['zeit']);	
	$key++;						
}
//-----------------------------------------------------------------------------------------------------------------------
// echo "<pre>"; print_r($status); echo "</pre>";

$template->assign('klog', $status);
$template->assign('j1', $j1);
$template->assign('j2', $j2);
$template->assign('j3', $j3);
$template->assign('j4', $j4);

$template->assign('content', 'tpl/ajax/ma_edit_sb.tpl');
?>