'; print_r($anlage); echo''; $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'); ?>