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

$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);
$kw = (int)date('W');

//-- wiederkehrende abfragen
$a_touren = $GLOBALS['a_touren'];
$a_fahrzg = $GLOBALS['a_fahrzg'];
$a_fahrer = $GLOBALS['a_fahrer'];
$a_planbz = $GLOBALS['a_planbz'];
$a_planbf = $GLOBALS['a_planbf'];

 // noch prüfen

$a_planb_m = $GLOBALS['mysql']->query_array("SELECT * FROM planer WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'"); 
$a_planb_f = $GLOBALS['mysql']->query_array("SELECT * FROM fplaner WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");

//****************** VAR ******************
$summe=0; $key=0; $n=0; $fertig=0; $sms=0; $aktiv=0; $c=0; $smses=0; $smses2=0; $smse=[]; $smse2=[]; $fehler19=0;
//***************************************** 
//***************** Heute *****************
//*****************************************
//***************** menue Quckbutton
$db=$GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' and monat='".$tag1_monat."' and jahr='".$tag1_jahr."' ORDER BY id"); 

while($row = $db->fetch_assoc()) {
	$summe++; $n=0;
	//--------------------------------------- 
	//-------------------- Fahrer prüfen
	if($row['fahrer']==0) { // kein Fahrer geplant
		$n=1; 
	} else { // Fahrer auf Kalender prüfen
		if (in_array($row['fahrer'], $a_planb_m)) {
			$ma_pid = array_search($row['fahrer'], array_column($a_planb_m, 'mid')); 
			if (is_numeric($ma_pid)) {
				$grund=$a_planb_m[$ma_pid]['grund'];
				$pa_id= array_search($grund, array_column($a_planbz, 'id')); 	
				if($a_planbz[$pa_id]['nichtda']== 1) { $n=1; }	//nicht da 
				if($a_planbz[$pa_id]['nichtda']==88) { $n=1; }	//keine N8-Tour
			}	
		}
	}
	//-------------------- Fahrzeug prüfen	
	if($row['auto']==0) {  // kein Fahrzeug geplant
		$n=1; 
	} else { 
		if (in_array($row['auto'], $a_planb_f)) {
			$fa_id = array_search($row['auto'], array_column($a_planb_f, 'fa_id')); 
			if (is_numeric($fa_id)) {
				$grund=$a_planb_m[$ma_pid]['grund'];
				$pa_id= array_search($grund, array_column($a_planbz, 'id')); 	
				if($a_planbf[$fa_id]['aktiv']<2) { $n=1; }
			}	
		}
	} 	
	//-------------------- sonder touren bzw nicht aktive Touren
	$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
	if ($a_touren[$ta_id]['aktiv']==0 ) {$aktiv++; }
	//-------------------- prüfen ob endgültig geplant
	if($row['smsstatus']!=0) { $fertig++; }
	if($row['smsstatus']==2) { $sms++; }	
	
	$c=0;
	if ($n>0) { 			$c='#9c0000'; }					//rot
	elseif ($fertig==0) { 	$c='#ff8800'; }					// gelb/orange
	elseif ($fertig==$sms && $aktiv==0) { $c='#358d2f'; } 	// grün komplett fertig
	elseif ($fertig==$sms && $aktiv> 0) { $c='#6495ed'; }	// blau -- fertig Fremdtouren aktiv
	elseif ($fertig>0 && $aktiv==0) { $c='#358d2f'; } 	// grün komplett sms fehler 
	elseif ($fertig>0  && $aktiv> 0) { $c='#6495ed'; }	// blau -- fertig Fremdtouren aktiv		sms fehler 
	
	//-------------------- SMS Fehler
	if($row['smsstatus']==3 OR $row['smsstatus']==4 OR $row['smsstatus']==5)  { 
		$smses++;
		$smst = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."'");
		$smse[$smses]['name']=$smst['e_name'];
		$smse[$smses]['date']=$smst['statusdate'];
		$smse[$smses]['msg'] =$smst['text'];
	}
	$smss=array();
	$smss['0']=0; $smss['1']=0; $smss['2']=0; $smss['3']=0; $smss['4']=0; $smss['5']=0; 
	//-------------------- SMS status
	if($row['smsstatus']==0)  { $smss['0']++; }
	if($row['smsstatus']==20) { $smss['1']++; }
	if($row['smsstatus']==3)  { $smss['2']++; }	
	if($row['smsstatus']==4)  { $smss['2']++; }	
	if($row['smsstatus']==5)  { $smss['2']++; }	
	if($row['smsstatus']==6)  { $smss['2']++; }	
	if($row['smsstatus']==8)  { $smss['3']++; }	
	if($row['smsstatus']==1)  { $smss['4']++; }	
	if($row['smsstatus']==2)  { $smss['5']++; }	
	$template->assign('ss' , $smss);

	if($row['typ']==3)  { $icon['11']++; $icon[12]++;	$icon['111']=$c; $icon['112']=$c; 		}
	if($row['typ']==4)  { $icon['11']++; $icon[13]++;	$icon['111']=$c; $icon['113']=$c;		}
	if($row['typ']==5)  { $icon['11']++; $icon[15]++;	$icon['111']=$c; $icon['115']=$c;		}
	if($row['typ']==6)  { $icon['21']++; $icon[22]++;	$icon['121']=$c; $icon['122']=$c;		}
	if($row['typ']==12) { $icon['25']++; 				$icon['125']=$c;						}
	if($row['typ']==16) { $icon['21']++; $icon[22]++;	$icon['121']=$c; $icon['122']=$c;		}
	if($row['typ']==17) { $icon['11']++; $icon[14]++;	$icon['111']=$c; $icon['114']=$c;		}
	if($row['typ']==19) { $icon['25']++; 				$icon['125']=$c; 						}
	if($row['typ']==20) { $icon['21']++; $icon[24]++;	$icon['121']=$c; $icon['124']=$c;		}
	if($row['typ']==21) { $icon['21']++; $icon[24]++;	$icon['121']=$c; $icon['124']=$c;		}
	if($row['typ']==22) { $icon['21']++; $icon[23]++;	$icon['121']=$c; $icon['123']=$c;		}
}

	$template->assign('t1c' , "#ffffff");
	$template->assign('t1c' , "#ffffff");

//***************************************** 
//***************** Morgen ****************
//*****************************************
	
	
//***************** menue Quckbutton
$db=$GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' and monat='".$tag2_monat."' and jahr='".$tag2_jahr."' ORDER BY id"); 
$summe=0; $key=0; $n=0; $fertig=0; $sms=0; $aktiv=0; $anzeige=0;
while($row = $db->fetch_assoc()) {
	$summe++; $n=0;
	//--------------------------------------- 
	//-------------------- Fahrer prüfen
	if($row['fahrer']==0) { // kein Fahrer geplant
		$n=1; 
	} else { // Fahrer auf Kalender prüfen
		if (in_array($row['fahrer'], $a_planb_m)) {
			$ma_pid = array_search($row['fahrer'], array_column($a_planb_m, 'mid')); 
			if (is_numeric($ma_pid)) {
				$grund=$a_planb_m[$ma_pid]['grund'];
				$pa_id= array_search($grund, array_column($a_planbz, 'id')); 	
				if($a_planbz[$pa_id]['nichtda']== 1) { $n=1; }	//nicht da 
				if($a_planbz[$pa_id]['nichtda']==88) { $n=1; }	//keine N8-Tour
			}	
		}
	}
	//-------------------- Fahrzeug prüfen	
	if($row['auto']==0) {  // kein Fahrzeug geplant
		$n=1; 
	} else { 
		if (in_array($row['auto'], $a_planb_f)) {
			$fa_id = array_search($row['auto'], array_column($a_planb_f, 'fa_id')); 
			if (is_numeric($fa_id)) {
				$grund=$a_planb_m[$ma_pid]['grund'];
				$pa_id= array_search($grund, array_column($a_planbz, 'id')); 	
				if($a_planbf[$fa_id]['aktiv']<2) { $n=1; }
			}	
		}
	} 	
	//-------------------- sonder touren bzw nicht aktive Touren
	$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
	if ($a_touren[$ta_id]['aktiv']==0 ) {$aktiv++; }
	//-------------------- prüfen ob endgültig geplant
	if($row['smsstatus']!=0) { $fertig++; }
	if($row['smsstatus']==2) { $sms++; }	
	
	$c=0;
	if ($n>0) { 			$c='#9c0000'; }					//rot
	elseif ($fertig==0) { 	$c='#ff8800'; }					// gelb/orange
	elseif ($fertig==$sms && $aktiv==0) { $c='#358d2f'; } 	// grün komplett fertig
	elseif ($fertig==$sms && $aktiv> 0) { $c='#6495ed'; }	// blau -- fertig Fremdtouren aktiv
	elseif ($fertig>0 && $aktiv==0) { $c='#358d2f'; } 	// grün komplett sms fehler 
	elseif ($fertig>0  && $aktiv> 0) { $c='#6495ed'; }	// blau -- fertig Fremdtouren aktiv		sms fehler 

	//-------------------- SMS Fehler
	if($row['smsstatus']==3 OR $row['smsstatus']==4 OR $row['smsstatus']==5)  { 
		$smses2++;
		$smst2 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."'");
		$smse2[$smses2]['name']=$smst2['e_name'];
		$smse2[$smses2]['date']=$smst2['senddate'];
		$smse2[$smses2]['msg'] =$smst2['text'];

	}		//echo'<pre>'; print_r($smst); echo'</pre>'; echo $smses;
	//-------------------- SMS status
	if($row['smsstatus']==0)  { $smss[10]++; }
	if($row['smsstatus']==20) { $smss[11]++; }
	if($row['smsstatus']==3)  { $smss[12]++; }	
	if($row['smsstatus']==4)  { $smss[12]++; }	
	if($row['smsstatus']==5)  { $smss[12]++; }	
	if($row['smsstatus']==6)  { $smss[12]++; }	
	if($row['smsstatus']==8)  { $smss[13]++; }	
	if($row['smsstatus']==1)  { $smss[14]++; }	
	if($row['smsstatus']==2)  { $smss[15]++; }	
	

	if($row['typ']==3)  { $icon[31]++; $icon[32]++;	$icon[131]=$c; $icon[132]=$c; 		}
	if($row['typ']==4)  { $icon[31]++; $icon[33]++;	$icon[131]=$c; $icon[133]=$c;		}
	if($row['typ']==5)  { $icon[31]++; $icon[35]++;	$icon[131]=$c; $icon[135]=$c;		}
	if($row['typ']==6)  { $icon[41]++; $icon[42]++;	$icon[141]=$c; $icon[142]=$c;		}
	if($row['typ']==12) { $icon[45]++; 				$icon[145]=$c;						}
	if($row['typ']==16) { $icon[41]++; $icon[42]++;	$icon[141]=$c; $icon[142]=$c;		}
	if($row['typ']==17) { $icon[31]++; $icon[34]++;	$icon[131]=$c; $icon[134]=$c;		}
	if($row['typ']==19) { $icon[45]++; 				$icon[145]=$c; 						}
	if($row['typ']==20) { $icon[41]++; $icon[44]++;	$icon[141]=$c; $icon[144]=$c;		}
	if($row['typ']==21) { $icon[41]++; $icon[44]++;	$icon[141]=$c; $icon[144]=$c;		}
	if($row['typ']==22) { $icon[41]++; $icon[43]++;	$icon[141]=$c; $icon[143]=$c;		}
}	
$template->assign('icon' , $icon);
$template->assign('smse' , $smse);
$template->assign('smses' , $smses);
$template->assign('smse2' , $smse2);
$template->assign('smses2' , $smses2); 
$template->assign('icon' , $icon);
$template->assign('ss', $smss);
$template->assign('t2c' , "#ffffff");
$template->assign('t2c' , "#ffffff");	
	
//-----------------------------------------------------------------------------------------------------------------------------
//--------------------------------------------------- Normplan heute
$nplan1 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'"); 
$template->assign('np1',$nplan1);
//--------------------------------------------------- Normplan heute
$nplan2 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'"); 
$template->assign('np2',$nplan2);
//-----------------------------------------------------------------------------------------------------------------------------
$test1 = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
$key=0;
while($row = $test1->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='".$tag1_tag."' AND aktiv>0 AND gebmonat='".$tag1_monat."'");
while($row = $bday->fetch_assoc()) {
	$maf1[$key]['fahrer']=$row['name']; 
	$jahre=$tag1_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='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_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++;
}
$template->assign('kal1', $maf1);
//-----------------------------------------------------------------------------------------------------------------------------
$test2 = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
$key=0;
while($row = $test2->fetch_assoc()) { 
	
	$maf2[$key]['fahrer'] = $_SESSION['ma_all'][$row['mid']]['name'];
	
	$maf2[$key]['bez']	  = $_SESSION['pbz'][$row['grund']]['bez'];
	$maf2[$key]['icon']	  = $_SESSION['pbz'][$row['grund']]['fa'];
	$maf2[$key]['na']	  = $_SESSION['pbz'][$row['grund']]['nichtda'];
																			
	$maf2[$key]['info']=$row['info'];		
	$key++;
}
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag2_tag."' AND aktiv>0 AND gebmonat='".$tag2_monat."'");
while($row = $bday->fetch_assoc()) {
	$maf2[$key]['fahrer']=$row['name']; 
	$jahre=$tag2_jahr-$row['gebjahr']; 
	$maf2[$key]['bez']=$jahre.". Geburtstag"; 
	$maf2[$key]['icon']="fal fa-birthday-cake";
	$key++;
}

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

	$maf2[$key]['info']=$row['info'];		
	$key++;
}
$template->assign('kal2', $maf2);
//------------------------------------------------------------- Polizei-Meldungen --
$pdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr_polizei");
$template->assign('pol_data', $pdata);	
//----------------------------------------------------------------------------------
//---------------- Status -----------------
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,5"); $key=0; 	$anz=0;
while($row_anlage = $anlage->fetch_assoc()) {

	$status[$key]['fahrer'] = $_SESSION['ma_all'][$row_anlage['user']]['name'];
	$status[$key]['zeit']=$row_anlage['zeit'];	
	if ($row_anlage['zeit']>time()-(1800)) { $anz=1; }
	if ($row_anlage['zeit']>time()-(300)) { $anz=2; }
	$key++;						
}
$template->assign('anz', $anz);
$template->assign('status', $status);
$template->assign('zeit_online',time()-(1800));
$template->assign('zeit_live',time()-(300));
//------------------------- 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++;						
}
//------------------------- Wetter sonnen Auf/Untergang ----------
$system = $GLOBALS['mysql']->query_single("SELECT * FROM system WHERE id=1"); $template->assign('system', $system);
//------------------------- 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++;						
}	
//-------------------------------------------------------------------------------------------------------------------
$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);	
//---------------------------------------------------------------------------------------------------------------------
$template->assign('smssumme', $GLOBALS['mysql']->summe("SELECT * FROM log_sms WHERE sender_id=1")); 
$template->assign('smsnread', $GLOBALS['mysql']->summe("SELECT * FROM log_sms WHERE incoming=1 and gelesen=0")); 
$template->assign('phonedata',$GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id=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);  } 	
//----------------------------------------------------------------------------------------------------------------------------------------------
$kfzcar = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' ORDER BY pid DESC LIMIT 0,5"); $key=0;	
while($row = $kfzcar->fetch_assoc()) {
	$kcar[$key]['kz'] =    $_SESSION['car'][$row['fid']]['kz'];
	$kcar[$key]['info'] = $row['info'];
	
	$kcar[$key]['bez']	  = $_SESSION['fbz'][$row['grund']]['bez'];
	$kcar[$key]['na']	  = $_SESSION['fbz'][$row['grund']]['aktiv'];	

	$kcar[$key]['info']=$row['info'];		
	$key++;
}
$template->assign('kfzcar', $kcar);


//----------------------------------------------------------------------------------------------------------------------------------------------
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tanken WHERE anzid>0");
$zufall=rand(1,$abfrage['num_rows']);
$tank = $GLOBALS['mysql']->query_single("SELECT * FROM tanken WHERE anzid='".$zufall."'");

$tankdata['kname']=$tank['kname'];
$tankdata['street']=$tank['street'];

$diesel=$tank['diesel'];
$tankdata['diesel']=substr($diesel, 0, -1);
$tankdata['dieselx']=substr($diesel, -1, 1);

$template->assign('tankdata', $tankdata);

//----------------------------------------------------------------------------------------------------------------------------------------------
$key=0; $tmp=0; $pak=0; $fertig=0; $fehler=0;
$s19_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE jahr='".$tag1_jahr."' and kw='".$kw."' and typ=19");
while($row = $s19_tour->fetch_assoc()) {
	$tmp=$tmp+$row['gewicht4'];
	$pak=$pak+$row['Pakete'];
	$fertig=$fertig+$row['fertig'];
	if ($row['gewicht3']!=0) { if ($row['fahrer']==0 || $row['auto']==0) { $fehler++; }}
	$key++;
}
$tmp=$tmp/1000; $d19=round($tmp,1); $pa19=number_format($pak,-2,'','.');
$template->assign('ic19','#666666'); 
$template->assign('tc19','#aaaaaa'); 
$template->assign('p19',$pa19.' Pakete ('.$row['norm'].'er)'); 
if     ($fehler19>0) { 	$template->assign('ic19','#9c0000');	}
elseif ($fertig19!=0){ 	$template->assign('ic19','#358d2f');	}
elseif ($tmp!=0){ 		$template->assign('ic19','#ff8800');	}
elseif ($tmp!=0){ 		$template->assign('ic19','#ff8800');	}
else { $template->assign('p19',' keine Daten.'); $template->assign('tc19','#666666'); }

if($key>0) {
	//$d19=number_format($tmp,-2,'','.');
	$template->assign('d19',$d19);		
	$template->assign('m19',$key);		
}
//----------------------------------------------------------------------------------------------------------------
$tsdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type=9"); 
if($tsdata['num_rows'] != 0) { 
	$tdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type=9 ORDER BY type DESC"); $key=0;
	$template->assign('ts_data', $tdata);	
	$template->assign('ts_anz', 1);	
}
//---------------------------------------------------- mobile Blitzer ja/nein
$mbdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type in(0,1,2,3,4,5,6)"); 
if($mbdata['num_rows'] != 0) { 
	$mdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type in(0,1,2,3,4,5,6)"); 
	$template->assign('mb_data', $mdata);	
	$template->assign('mb_anz', 1);	
}	
//------------------------------------------------------------------------------------------------------------- 
//---------------------------------------------------- Verkersinfo ja/nein
$stdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type NOT in (0,1,2,3,4,5,6,9)"); 

if($stdata['num_rows'] != 0) { 
	$sdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type NOT in(0,1,2,3,4,5,6,9)"); 
	$template->assign('st_data', $sdata);	
	$template->assign('st_anz', 1);	
}		
//-------------------------------------------------------------------------------------------------------------
/*
$key=0; $time=time();
$cars=$GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE leasing!=0 ORDER BY kz");  
while($row = $cars->fetch_assoc()) {
	// Kennzeichen
	$data[$key]['kz']=$row['kz'];
	// km Laufzeit Berechnung
	$ez = mktime(0, 0, 0, $row['jbmonat'], $row['jbtag'], $row['jbjahr']); $now =time();
	$t1=$now-$ez; $t1=round($t1/86400); $t2=$row['leasing']/365;
	$data[$key]['pkm']=$t1*$t2; $data[$key]['pkm']=round($data[$key]['pkm']);
	//istkm     ************* einmal auslesen 
	$tmp1=$GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE utyp=3 AND fid='".$row['id']."' ORDER BY date DESC Limit 1"); 
	$data[$key]['ikm']=$tmp1['km'];
	//ca.km nach letztem check
	$tmp5 = $GLOBALS['mysql']->query_single("SELECT SUM(km) FROM tourenliste WHERE auto='".$row['id']."' and time>'".$tmp1[date]."' and time<'".$time."'");
	$data[$key]['ckm']=$tmp5['SUM(km)']+$tmp1['km'];
	//km vom vorletztes tanken
	$tmp2=$GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE utyp=3 AND fid='".$row['id']."' ORDER BY date DESC Limit 1,1"); 
	$data[$key]['tkm']=$tmp1['km']-$tmp2['km'];
	//geschätze km vom letzten tanken
	$tmp3=$GLOBALS['mysql']->query_single("SELECT SUM(km) FROM tourenliste WHERE auto='".$row['id']."' and time>'".$tmp2[date]."' AND time<'".$tmp1[date]."'");
	$data[$key]['rkm']=$tmp3['SUM(km)'];
	
				$data[$key]['tanz']=0;
				$t1=$tmp1['km']-$tmp2['km'];
				if($t1!=0) { $data[$key]['dvb']=round(($tmp1['tank']/($t1))*100, 1); }
				else { $data[$key]['dvb']=0; }
//				$data[$key]['dvb']=round(($tmp1['tank']/($tmp1['km']-$tmp2['km']))*100, 1);
				if($data[$key]['dvb']<12) { $data[$key]['tanz']=1; }
				if($data[$key]['dvb']>12) { $data[$key]['tanz']=2; }
				if($data[$key]['dvb']< 7) { $data[$key]['tanz']=3; }
				if($data[$key]['dvb']>16) { $data[$key]['tanz']=4; }
				//$data[$key]['dvb']="Ø ".$data[$key]['dvb']." ltr.";
			

	$key++;
}


$template->assign('kmdata', $data);
*/ 
//------------------------------------------------------------------------------------------------------------- 

//echo'<pre>'; print_r($row); echo'</pre>';


$template->assign('status', $status);		
$template->assign('estatus', $estatus);	
$template->assign('ustatus', $ustatus);			
//-------------------------------------------

$template->assign('t1bc', "#115270");
$template->assign('t1c' , "#ffffff");

$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/home/ue_h24.tpl'); 
?>