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


$re = $GLOBALS['mysql']->query_array("SELECT DISTINCT RechNr,Rechnungsdatum FROM tankrechnung ORDER by RechNr DESC");
$template->assign('re', $re);

$anz=1; $kontrolle=0;
//----------------------------- Save bestätigung

if(isset($_POST['ok_save'])) {
	$sb = $GLOBALS['mysql']->query_single("SELECT * FROM tankrechnung WHERE id='".$_POST['ok_save']."'");
	$zs['td']=explode(".", $sb['Tankdatum']);
	$zs['tz']=explode(".", $sb['Tankzeit']);
	$zs['ts']=mktime($zs['td'][0], $zs['td'][1], 0, $zs['td'][1], $zs['td'][0], $zs['td'][2]);
	$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,re_id,re_check,date,benutzer,utyp,tank,km) 
	VALUES(
	'".$sb['fid']."',
	'".$_POST['ok_save']."',
	'2',
	'".$zs['ts']."',
	'".$_SESSION['benutzer']."',
	'".$sb['Sorte']."',
	'".$sb['Menge']."',
	'".$sb['KmStand']."')
	");
	$GLOBALS['mysql']->insert("UPDATE tankrechnung SET kontrolle=2 WHERE id='".$_POST['ok_save']."'");
	$_GET['ref']=0;
	$success="AD-Blue aktualisiert !"; $template->assign('success', $success);
}


$load=0; if(isset($_GET['load'])) { $load=1; } $template->assign('load', $load);

$check = $GLOBALS['mysql']->query_single("SELECT * FROM tankrechnung WHERE kontrolle NOT IN (1,2)");	

if($check['num_rows'] != 0) { 

	$check = $GLOBALS['mysql']->query("SELECT * FROM tankrechnung WHERE kontrolle NOT IN (1,2)");	
	while($row = $check->fetch_assoc()) {	
		$logdata = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE re_id NOT IN (1,2) and fid='".$row['fid']."' and km='".$row['KmStand']."'"); 
		
		
		$kontrolle=0;
		if($logdata['num_rows'] != 0) { 
			
			//echo $row['Kfz'].' - '.$row['fid'].' - '.$logdata['fid'].' - '.$row['Menge'].' - '.$logdata['tank'].' - '.$row['KmStand'].' - '.$logdata['km'].'</br>';
			// if Wäsche oder Ad Blue Bestätigung einholen
			$kontrolle=5; 
			
			
			$checkl=str_replace('.',',',$logdata['tank']);
			if($checkl==$row['Menge']) {
				$kontrolle=1;
			}
			$GLOBALS['mysql']->insert("UPDATE tankrechnung SET beleg_id='".$logdata['id']."' WHERE id='".$row['id']."'");
			$GLOBALS['mysql']->insert("UPDATE tankrechnung SET kontrolle='".$kontrolle."' WHERE id='".$row['id']."'");
			$GLOBALS['mysql']->insert("UPDATE fahrzeug_log SET re_id='".$row['id']."' WHERE id='".$logdata['id']."'");
			$GLOBALS['mysql']->insert("UPDATE fahrzeug_log SET re_check='".$kontrolle."' WHERE id='".$logdata['id']."'");
			// genaues Datum schreiben
		}
	}
}

/*
1= A komplett
2= M komplett 
3=
4= 
5= A ohne Tank
6= 

*/
//echo'<pre>'; print_r($re); echo'</pre>';


if(isset($_GET['renr'])) {
	$beleg = $GLOBALS['mysql']->query_array("SELECT * FROM tankrechnung WHERE RechNr='".$_GET['renr']."' ORDER by RechNr,Tankdatum,Tankzeit"); $anz=$_GET['renr'];	
} else {
	if(isset($_GET['ref']) &&$_GET['ref']!=0 ) {
		$beleg = $GLOBALS['mysql']->query_single("SELECT * FROM tankrechnung WHERE id='".$_GET['ref']."'"); $anz=99;	
	} else { 	
		$beleg = $GLOBALS['mysql']->query_array("SELECT * FROM tankrechnung WHERE kontrolle NOT IN (1,2) ORDER by RechNr,Tankdatum,Tankzeit");	
	}
}


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


$template->assign('beleg',$beleg); 
$template->assign('anz',$anz);


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

?>