<?php

ini_set('display_errors', 0);
date_default_timezone_set('Europe/Berlin'); // Default Time Zone
$a_zeit=time()+3600;
$tag  = date("d"); 
$monat= date("m"); 
$jahr = date("Y"); 
$jahrk= date("y");  

$laufend = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE typ>3 AND aktiv>0 ORDER BY kz"); $key=0;
while($row = $laufend->fetch_assoc()) {
	$car[$key]['kz']=$row['kz'];
	$car[$key]['nhof']=$row['nhof'];
	
	
	$tlist = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND auto='".$row['id']."'"); $tkey=0;
	while($row_tlist = $tlist->fetch_assoc()) {
		$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row_tlist['tour']."'");

		$start=0;
		$start= date("G", $row_tlist['time']);
		$multi=$row_tour['zeit']/3600;

		$start--;
		$i=0; while ($i <= $multi) {     
			$start++;
		
					if($start== 1) { $car[$key]['time1']++; }
					if($start== 2) { $car[$key]['time2']++; }
					if($start== 3) { $car[$key]['time3']++; }
					if($start== 4) { $car[$key]['time4']++; }
					if($start== 5) { $car[$key]['time5']++; }
					if($start== 6) { $car[$key]['time6']++; }
					if($start== 7) { $car[$key]['time7']++; }
					if($start== 8) { $car[$key]['time8']++; }
					if($start== 9) { $car[$key]['time9']++; }
					if($start==10) { $car[$key]['time10']++; }
					if($start==11) { $car[$key]['time11']++; }
					if($start==12) { $car[$key]['time12']++; }
					if($start==13) { $car[$key]['time13']++; }
					if($start==14) { $car[$key]['time14']++; }
					if($start==15) { $car[$key]['time15']++; }
					if($start==16) { $car[$key]['time16']++; }
					if($start==17) { $car[$key]['time17']++; }
					if($start==18) { $car[$key]['time18']++; }
					if($start==19) { $car[$key]['time19']++; }
					if($start==20) { $car[$key]['time20']++; }
					if($start==21) { $car[$key]['time21']++; }
					if($start==22) { $car[$key]['time22']++; }
					if($start==23) { $car[$key]['time23']++; }																																												

			
			$i++; 
		}

			
	}
	$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");


	$key++;						
}
$template->assign('car', $car);
$template->assign('content', 'tpl/ajax/car_plan.tpl');