133 lines
3.2 KiB
PHP
133 lines
3.2 KiB
PHP
<?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');
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|