3 class SpritLog extends DatabaseTable {
5 public function __construct($id=false)
7 parent::__construct('sprit_log', $id);
10 public function distinctYears()
12 $sql = "SELECT DISTINCT EXTRACT(YEAR from date) AS year FROM sprit_log ORDER BY year DESC";
13 return $this->db->fetchObjectList($sql);
16 public function formatYear($year)
19 $sql = sprintf("SELECT * FROM sprit_log WHERE EXTRACT(YEAR from date) = %d ORDER BY date ASC", $year);;
24 foreach ($this->db->fetchObjectList($sql) as $row) {
25 $out .= sprintf('<tr id="%d"><td>%s</td><td>%s</td><td>%s</td>' .
26 '<td class="right">%.2f</td><td class="right">%.2f</td><td class="right">%.2f</td>' .
27 '<td class="right">%d</td><td class="right">%d</td></tr>',
28 $row->id, assert_german_date($row->date),
29 $row->city, $row->tankstelle,
30 $row->price_liter, $row->liter,$row->price,
31 $row->km, $row->km_total);
32 $total_km += $row->km;
33 $total_liter += $row->liter;
34 $total_price += $row->price;
38 $out = '<table class="smallfont" width="100%">' .
40 '<th width="70">Datum</th><th width="130" class="left">Ort</th><th class="left">Tankstelle</th>' .
41 '<th width="40">EUR/l</th><th width="40">l</th><th width="40">EUR</th><th width="40">km</th><th width="40">gesamt</th>' .
45 '<th colspan="4" class="left">Summe</th>' .
46 sprintf('<th class="right">%.2f</th><th class="right">%.2f</th><th class="right">%d</th><th> </th>',
47 $total_liter, $total_price, $total_km).