public function getDailyUsage($user) { $sql = 'SELECT COUNT(*) AS minutes, day FROM usage WHERE user = :user GROUP BY day ORDER BY day ASC'; $params = array(':user' => $user); $data = array(); $first = null; $last = null; foreach ($this->db->queryAll($sql, $params) as $row) { $day = $row['day']; if ($first === null) { $first = strtotime($day); } $last = strtotime($day); $data[$day] = intval($row['minutes']); } $results = $this->generateDates($first, $last); foreach (array_keys($results) as $day) { if (isset($data[$day])) { $results[$day] = $data[$day]; } } return $results; }