<?php
$tagp = strtotime("+0 day"); 
$tag = date("d",$tagp); 
$monat = date("m",$tagp); 
$jahr = date("Y",$tagp); 
$datum=$tag.".".$monat.".".$jahr; 

//----------------------------------------------------------------------------------------------
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) { 
	
	$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['mid']]['name'];
	
	$maf1[$key]['bez']	  = $_SESSION['pbz'][$row['grund']]['bez'];
	$maf1[$key]['icon']	  = $_SESSION['pbz'][$row['grund']]['fa'];
	$maf1[$key]['na']	  = $_SESSION['pbz'][$row['grund']]['nichtda'];
																			
	$maf1[$key]['info']=$row['info'];		
	$key++;
}
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND aktiv>0 AND gebmonat='".$monat."'");
while($row = $bday->fetch_assoc()) {
	$maf1[$key]['fahrer']=$row['name']; 
	$jahre=$jahr-$row['gebjahr']; 
	$maf1[$key]['bez']=$jahre.". Geburtstag"; 
	$maf1[$key]['icon']="fal fa-birthday-cake";
	$key++;
}

$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");	
while($row = $auto->fetch_assoc()) {
	$maf1[$key]['fahrer'] = $_SESSION['car'][$row['fid']]['kz'];
	
	$maf1[$key]['bez']	  = $_SESSION['fbz'][$row['grund']]['bez'];
	$maf1[$key]['icon']	  = $_SESSION['fbz'][$row['grund']]['fa'];
	$maf1[$key]['na']	  = $_SESSION['fbz'][$row['grund']]['aktiv'];	

	$maf1[$key]['info']=$row['info'];		
	$key++;
}

//--------------------------------------------------- Normplan
$np = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); 
$template->assign('np',$np);

$template->assign('datum', $datum);
$template->assign('kal', $maf1);
$template->assign('content', 'tpl/ajax/ue_kal.tpl');
?>