db->fetchObjectList($sql);
}
public function formatYear($year)
{
$out = '';
$sql = sprintf("SELECT * FROM sprit_log WHERE EXTRACT(YEAR from date) = %d ORDER BY date ASC", $year);;
$total_km = 0;
$total_liter = 0;
$total_price = 0;
foreach ($this->db->fetchObjectList($sql) as $row) {
$out .= sprintf('| %s | %s | %s | ' .
'%.2f | %.2f | %.2f | ' .
'%d | %d |
',
$row->id, assert_german_date($row->date),
$row->city, $row->tankstelle,
$row->price_liter, $row->liter,$row->price,
$row->km, $row->km_total);
$total_km += $row->km;
$total_liter += $row->liter;
$total_price += $row->price;
}
if (strlen($out)) {
$out = '' .
'' .
'| Datum | Ort | Tankstelle | ' .
'EUR/l | l | EUR | km | gesamt | ' .
'
' .
$out .
'' .
'| Summe | ' .
sprintf('%.2f | %.2f | %d | | ',
$total_liter, $total_price, $total_km).
'
' .
'
';
}
return $out;
}
}