<?php
//echo'<pre>'; print_r($fz); echo'</pre>';
if(isset($_GET['id']) && $_GET['id']>0) {
	$fz = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$_GET['id']."'"); 
}
$typ=0; $template->assign('anz',9);
if(isset($_POST['update1'])) {
	$now=time(); $typ=1;
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,km) 
	VALUES(
	'".$_GET['id']."',
	'".$now."',
	'".$_SESSION['benutzer']."',
	'".$typ."',
	'".$_POST['updatekm']."')
	");
	$success="km-Stand aktualisiert !"; $template->assign('success', $success);
}
if(isset($_POST['kontrolle'])) {
	$now=time(); $typ=2;
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
	$bremse=0; $oel=0; $reifen=0; $ww=0;
	if(isset($_POST['bremse'])) { $bremse=1; } 
	if(isset($_POST['oel'])) { $oel=1; } 
	if(isset($_POST['reifen'])) { $reifen=1; } 
	if(isset($_POST['ww'])) { $ww=1; } 
	
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,k_bremse,k_oel,k_reifen,k_ww,km) 
	VALUES(
	'".$_GET['id']."',
	'".$now."',
	'".$_SESSION['benutzer']."',
	'".$typ."',
	'".$bremse."',
	'".$oel."',
	'".$reifen."',
	'".$ww."',
	'".$_POST['updatekm']."')
	");
	$success="kontrolle aktualisiert !"; $template->assign('success', $success);
}
if(isset($_POST['tanken'])) {
	$now=time(); $typ=3; 
	$tankm=str_replace(',', '.',$_POST['tank']);
	$km=str_replace('.', '',$_POST['updatekm']);
	$tanks=str_replace(',', '.',$_POST['updatesum']);
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,tank,tsumme,km) 
	VALUES(
	'".$_GET['id']."',
	'".$now."',
	'".$_SESSION['benutzer']."',
	'".$typ."',
	'".$tankm."',
	'".$tanks."',
	'".$km."')
	");
	$success="km-Stand aktualisiert !"; $template->assign('success', $success);
}
if(isset($_POST['os'])) {
	$now=time(); $typ=4;
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,ow,km) 
	VALUES(
	'".$_GET['id']."',
	'".$now."',
	'".$_SESSION['benutzer']."',
	'".$typ."',
	'".$_POST['os']."',
	'".$_POST['updatekm']."')
	");
	$success="km-Stand aktualisiert !"; $template->assign('success', $success);
}
if(isset($_POST['at'])) {
	$now = mktime(10, 0, 0,$_POST['tm'],$_POST['td'],$_POST['tj']); 
	$typ=3; 
	$tankm=str_replace(',', '.',$_POST['tank']); 
	$km=str_replace('.', '',$_POST['updatekm']);
	$tanks=str_replace(',', '.',$_POST['updatesum']); 
	if ($fz['istkm']<$_POST['updatekm']) {
		$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$km."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
	}
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,tank,tsumme,km) 
	VALUES(
	'".$_GET['id']."',
	'".$now."',
	'".$_SESSION['benutzer']."',
	'".$typ."',
	'".$tankm."',
	'".$tanks."',
	'".$km."')
	");
	$success="km-Stand aktualisiert !"; $template->assign('success', $success);
}
//-------------------------------------------------------------------------------------
if(isset($_GET['delete']) && $_GET['delete']>0) { 
	$GLOBALS['mysql']->query("DELETE FROM fahrzeug_log WHERE id='".$_GET['delete']."'");	
	$error="Hinweis: Tankeintrag geloescht"; 
	$template->assign('error', $error);	
	
}
//-------------------------------------------------------------------------------------

if(isset($_GET['id']) && $_GET['id']>0) {
	if (strlen($fz['kba3'])!=3) { $fz['kba3']=substr($fz['kba3'],0,3); } 
	$kb = $GLOBALS['mysql']->query_single("SELECT * FROM kba WHERE kba2='".$fz['kba2']."' and kba3='".$fz['kba3']."'");
	$ol = $GLOBALS['mysql']->query_single("SELECT * FROM oel WHERE id='".$fz['osorte']."'"); 
	//------ History	
	$his=$GLOBALS['mysql']->query("SELECT * FROM fahrzeug_log WHERE fid='".$_GET['id']."' ORDER BY date DESC LIMIT 0,50"); $key=0;
	while($row = $his->fetch_assoc()) {
		if ($row['date']>time()-(3600)) { $hist[$key]['anz']=1; } else { $hist[$key]['anz']=0; }
		$hist[$key]['name'] = $_SESSION['ma_all'][$row['benutzer']]['name'];
		$hist[$key]['fid'] = $row['fid'];
		$hist[$key]['id'] = $row['id'];
		$hist[$key]['utyp'] = $row['utyp'];
		$hist[$key]['date'] = $row['date'];
		$hist[$key]['kmst'] = $row['km'];
		$hist[$key]['ow'] = $row['ow'];
		$hist[$key]['sani'] = $row['sani'];
		$hist[$key]['k_bremse'] = $row['k_bremse'];
		$hist[$key]['k_reifen'] = $row['k_reifen'];
		$hist[$key]['k_oel'] = $row['k_oel'];
		$hist[$key]['k_ww'] = $row['k_ww'];
		$hist[$key]['tank'] = $row['tank'];
		$hist[$key]['tsumme'] = $row['tsumme'];
		$hist[$key]['re_check'] = $row['re_check'];
		if($row['utyp']==3) {
			$dkm = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE date<'".$row['date']."' AND fid='".$_GET['id']."' AND utyp=3 ORDER BY date DESC LIMIT 1"); $hist[$key]['tanz']=0;
			if($dkm['num_rows']!=0) { 
				$hist[$key]['dvb']=round(($row['tank']/($row['km']-$dkm['km']))*100, 1);
				if($hist[$key]['dvb']<12) { $hist[$key]['tanz']=1; }
				if($hist[$key]['dvb']>=12) { $hist[$key]['tanz']=2; }
				if($hist[$key]['dvb']< 7) { $hist[$key]['tanz']=3; }
				if($hist[$key]['dvb']>16) { $hist[$key]['tanz']=4; }
				$hist[$key]['dvb']="Ø ".$hist[$key]['dvb']." ltr.";
			}
		}
		$key++;
	}

	$template->assign('history', $hist);	
	$template->assign('typ', $typ);	
	$template->assign('oel', $ol);
	$template->assign('kba', $kb);
	$template->assign('fahrzeug', $fz);
	$template->assign('anz', 1);
}
	

//menue
$fahrzeuge_a = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE aktiv>0 AND besitz<3 AND besitz>0 ORDER by kz");	
//ölsorten
$oels = $GLOBALS['mysql']->query_array("SELECT * FROM oel ORDER by id");


$template->assign('owtime', strtotime("+1 years"));
$template->assign('zrtime', strtotime("+5 years"));
$template->assign('realtime', time());	
$template->assign('typ', $typ);	
$template->assign('oels', $oels);	
$template->assign('monat', date('m'));	
$template->assign('jahr', date('Y'));	

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

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

?>