<?php
date_default_timezone_set('Europe/Berlin'); // Default Time Zone
$now=time();
$tag  = date("d"); 
$monat= date("n");
$jahr = date("Y");
unset($freecar);

$carliste = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE typ>1 AND besitz<3 AND aktiv=1 ORDER by kz"); $key=0;
while($row = $carliste->fetch_assoc()) {
$planertest = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND fid='".$row['id']."'");	
	if($planertest['num_rows']==0) {
			$istheute = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND auto='".$row['id']."' ");
			if($istheute['num_rows']==0) {
				$cartest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE time>'".$now."' AND auto='".$row['id']."'ORDER by time");
				if($cartest['num_rows']==0) {
                    $freecar[$key]['anz'] = 0; //0
                    $freecar[$key]['kz'] = $row['kz'];
                    $freecar[$key]['nt'] = 4102354800; //31.12.2099
                    $key++;
				} else {
                    //$freecar[$key]['anz'] = 0; //gelb
                    $freecar[$key]['kz'] = $row['kz'];
                    $freecar[$key]['nt'] = $cartest['time'] - 1000;
                    $key++;
				}
			} else {
				$cartest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND typ<6");
                $carnext = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE time > '".$now."' AND auto='".$row['id']."' AND typ>5 ORDER by time");
				if($cartest['num_rows']>0) {
                    $temptime = mktime(3, 00, 0, $monat, $tag, $jahr);
                    $temptime1 = mktime(4, 30, 0, $monat, $tag, $jahr);
                    $temptime2 = mktime(6, 00, 0, $monat, $tag, $jahr);
                    $logtest = $GLOBALS['mysql']->query_single("SELECT * FROM kartenlog  WHERE user='".$istheute['fahrer']."' ORDER BY zeit DESC LIMIT 0,1");

                    if ($logtest['zeit']<$temptime && ($temptime2 + 3600) < $now) {  //übefällig seit mehr als eine stunde
                        $freecar[$key]['anz'] = 3; //rot
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;
                    } elseif ($logtest['zeit']<$temptime && $temptime2 < $now) {    // überfällig
                        $freecar[$key]['anz'] = 2; //gelb
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;

                    } elseif ($logtest['zeit']>$temptime && $temptime1<$now && $temptime2>$now) {  // vor der zeit da
                        $freecar[$key]['anz'] = 1; //grün
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;
                    } elseif ($logtest['zeit']>$temptime) {  // ist da
                        $freecar[$key]['anz'] = 0; //normal
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;
                    }
                } else {
                    $carnext = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='" . $tag . "' AND monat='" . $monat . "' AND jahr='" . $jahr . "' AND typ>5");
                    $startzeit = $cartest['time'] - 3600;
                    if ($now< $cartest['time']){
                        $freecar[$key]['anz'] = 1; //normal
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;
                    }
                    elseif ($now<$startzeit){
                        $freecar[$key]['anz'] = 4; //blau
                        $freecar[$key]['kz'] = $row['kz'];
                        $freecar[$key]['nt'] = $carnext['time'] - 3600;
                        $key++;
                    }
/*
					if($temptime1<$now) {
	// abfrage 2. tour am tag
						$freecar[$key]['anz']=1;
						$freecar[$key]['kz'] = $row['kz'];
						$freecar[$key]['nt'] = $cartest['time'] - 1000;
						$key++;						
					}
*/
				}
			}
					
//					if($temptime2<$now) { 
	// abfrage 2. tour am tag

		
				// if einsatz tag
		
		
				//hat
			//$laufend = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE time>'".$now."'");
	}//planer test
}	//while schleife


/*
$laufend = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); $key=0;
while($row = $laufend->fetch_assoc()) {

	$status[$key]['zeit']=$row['zeit'];
	$teile = explode(":", $row['zeit']); 

	$zeit_ts=mktime($teile[0],$teile[1], 0, $monat,$tag,$jahr);
	$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
	
	if($row_fahre['uewach']>0) {
		$kartenlog = $GLOBALS['mysql']->query("SELECT * FROM kartenlog  WHERE id='".$row['fahrer']."' DESC LIMIT 0,1"); $key=0;
		$klog=$kartenlog['zeit'];
		$zeit_eins=$zeit_ts-18000;
		if($klog>$zeit_eins) {

			$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
			$atour[$key]['tour']=$row_tour['tour'];
			$row_fahrer2 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
			$atour[$key]['fahrer']=$row_fahrer2['name'];
			$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
			$atour[$key]['kennz']=$row_auto2['kz']; $key++; $wert10a++;
		
			
		}
			//tour unterwegs	
		
		
		// databankabfrage türlog                 maximal 1 ergebnis ...... timstring auslesen 
		//timstring mit tür vergleichen - 4 stunden 
	
	
	} else {
	//keine ueberwachung
	$zeit_eins=$zeit_ts-3600;
	}	
	

	$key++;						
}
*/
$template->assign('freecar', $freecar);
//$template->assign('zeit_online',time()-(1800));
//$template->assign('zeit_live',time()-(300));

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