<?php
$_SESSION['m1']=0; $_SESSION['m2']=0;
 
$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
//------------------------------------------------ offene Touren
$tag1 = date("Y"); $monat1 = date("m"); $jahr1 = date("d");
$tp1 = strtotime("+0 day"); $tag1 = date("d.m.Y", $tp1); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1);
$tp2 = strtotime("+1 day"); $tag2 = date("d.m.Y", $tp2); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2);
//------------------------------------------------------------------------- änder kw !!!!!!!!!!!!
$tag1_jahr = date("Y"); 
$tag1_monat = date("m"); 
$tag1_tag = date("d"); 
$tag1_kw = date("W"); 
//----------------------------  änderungen !!!!!!!!!!
$wtag = date("w");//// wochentag als zahl

//---------------- Status -----------------
	$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,5"); $key=0;
	while($row_anlage = $anlage->fetch_assoc()) {
		$status[$key]['fahrer'] = $_SESSION['ma_all'][$row_anlage['user']]['name'];
		$status[$key]['zeit']=$row_anlage['zeit'];			
		$key++;						
	}
//------------------------- estatus - letzte fehlereinlese ----------
	$eanlage = $GLOBALS['mysql']->query("SELECT * FROM kartenerror WHERE user=0 ORDER BY logID DESC LIMIT 0,5"); $key=0;
	while($row_eanlage = $eanlage->fetch_assoc()) {
		$estatus[$key]['zeit']=$row_eanlage['zeit'];
		$estatus[$key]['karte']=$row_eanlage['karte'];			
		$key++;						
	}
//------------------------- estatus - letzte fehlereinlese ----------
	$uanlage = $GLOBALS['mysql']->query("SELECT * FROM kartenerror WHERE user>0 ORDER BY logID DESC LIMIT 0,3"); $key=0;
	while($row_uanlage = $uanlage->fetch_assoc()) {
		$ustatus[$key]['fahrer'] = $_SESSION['ma_all'][$row_uanlage['user']]['name'];
		$ustatus[$key]['grund']=$row_uanlage['grund'];
		$ustatus[$key]['zeit']=$row_uanlage['zeit'];		
		$key++;						
	}
//--------------------------------------------
	$alarm="aus";
//--------------------------------------------
	$tuer="zu";	
	
	
//-----------------------------------------------
$abfrage_monline = $GLOBALS['mysql']->query_array("SELECT * FROM benutzer WHERE session_update>0 and id>0 ORDER BY session_update DESC LIMIT 0,5");
$template->assign('abfrage_monline', $abfrage_monline);
//-----------------------------------------------
$abfrage_conline = $GLOBALS['mysql']->query("SELECT * FROM karten WHERE status <9 AND status >1 ORDER BY status ASC LIMIT 0,5"); $key=0;
while($row = $abfrage_conline->fetch_assoc()) {
	//$abfrage_c[$key]['fahrer'] = $_SESSION['ma_all'][$row['user']]['name'];
	$abfrage_c[$key]['name'] = $_SESSION['ma_all'][$row['user']]['name'];
	$abfrage_c[$key]['status']=$row['status']; 
	$abfrage_c[$key]['etime']=$row['edittime']; 
	$abfrage_c[$key]['lastlog']=$row['lastlog']; 
	$abfrage_c[$key]['grund']=$row['grund'];	
	if($row['lastlog']>=$row['edittime']) { 
		$abfrage_c[$key]['ontour']=1; 
	} else {
		$abfrage_c[$key]['ontour']=0; 
	}
	$key++;
}

$template->assign('abfrage_c', $abfrage_c);
//-----------------------------------------------
//-----------------------------------------------
//-----------------------------------------------
//-----------------------------------------------
$timepi = $GLOBALS['mysql']->query_single("SELECT * FROM system"); 
$time = time();
$pitime=$timepi['pitime']+330;

//echo $pitime."-".$time;
if($pitime<$time) { $online=0; } else { $online=1; } 

//--------------------------------------------
if (date('w')==6) {
	$template->assign('samstag', 1);
}
//--------------------------------------------
//-------------------------------------------- zeitstempel für Sani und HU
$temptime=time(); $temptime=$temptime+2678400; 
//------------------ sanikasten ----------------------------------------------------------------------------------------------------------------
$tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 and sanidate>1 ORDER BY kz"); $key=0; $wert=0; $sum=0;
while($row = $tempcar->fetch_assoc()) { 
	if($row['sanidate']<=$temptime) {
		if($wert!=8) {
			if ($wert % 2 != 0) {
				$sanidata[$key]['kz1']=$row['kz']; $sanidata[$key]['sanidate1']=$row['sanidate']; 
				if($row['sanidate']<=time()) { $sanidata[$key]['typ1']=1; }else{ $sanidata[$key]['typ1']=2; $sanidata[$key]['anz']=1; } $key++;				
			} else {
				$sanidata[$key]['kz2']=$row['kz']; $sanidata[$key]['sanidate2']=$row['sanidate'];
				if($row['sanidate']<=time()) { $sanidata[$key]['typ2']=1; }else{ $sanidata[$key]['typ2']=2; $sanidata[$key]['anz']=0; } 			
			}
			$wert++;
		}
		$sum++;
	}
}
if($key!=0) { $template->assign('sanidata', $sanidata); $template->assign('sanisum', $sum);  } 	
//------------------ HU / AU -------------------------------------------------------------------------------------------------------------------
$tempcar2 = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 and hudate>1 ORDER BY kz"); $key=0; $wert=0; $sum=0;
while($row = $tempcar2->fetch_assoc()) { 
	if($row['hudate']<=time()) {
		if($wert!=8) {		
			if ($wert % 2 != 0) {
				$hudata[$key]['kz1']=$row['kz']; $hudata[$key]['hudate1']=$row['hudate']; 
				if($row['hudate']<=time()) { $hudata[$key]['typ1']=1; }else{ $hudata[$key]['typ1']=2; $hudata[$key]['anz']=1; } $key++;				
			} else {
				$hudata[$key]['kz2']=$row['kz']; $hudata[$key]['hudate2']=$row['hudate'];
				if($row['hudate']<=time()) { $hudata[$key]['typ2']=1; }else{ $hudata[$key]['typ2']=2; $hudata[$key]['anz']=0; } 
			}
			$wert++;
		}
		$sum++;		
	}
}
if($key!=0) { $template->assign('hudata', $hudata); $template->assign('husum', $sum);  } 	
//----------------------------------------------------------------------------------------------------------------------------------------------
	
$template->assign('status', $status);		
$template->assign('estatus', $estatus);	
$template->assign('ustatus', $ustatus);			
//-------------------------------------------
$template->assign('t1', $tag1_tag);
$template->assign('mo1', $tag1_monat);
$template->assign('j1', $tag1_jahr);
$template->assign('t2', $tag2_tag);
$template->assign('mo2', $tag2_monat);
$template->assign('j2', $tag2_jahr);	
$template->assign('tag1', $tag1);
$template->assign('datum', $tag1_tag.".".$tag1_monat.".".$tag1_jahr);
$template->assign('tag2', $tag2);


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