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;
}
