54 lines
No EOL
2.1 KiB
PHP
54 lines
No EOL
2.1 KiB
PHP
<?php
|
|
//echo'<pre>'; print_r($anlage); echo'</pre>';
|
|
$tp1 = strtotime("+0 day");
|
|
$tag = date("d",$tp1);
|
|
$monat = date("m",$tp1);
|
|
$jahr = date("Y",$tp1);
|
|
$data=array();
|
|
$key=0; $time=time();
|
|
$cars=$GLOBALS['mysql']->sql("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
|
|
$tmp1=$GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE utyp=3 AND fid='".$row['id']."' ORDER BY date DESC Limit 1");
|
|
if($tmp1['num_rows'] > 0) {
|
|
$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);
|
|
|
|
$template->assign('content', 'tpl/ajax/ue_km.tpl');
|
|
|
|
|
|
?>
|