public function getSalesJson($fromDate, $toDate, $interval) { $result = array(); $result[] = array('Year', 'Sales'); if ($interval == 'days') { $interval2 = '+1 day'; } elseif ($interval == 'months') { $interval2 = '+1 month'; } elseif ($interval == 'years') { $interval2 = '+1 year'; } foreach ($this->invoiceService->getDateRange($fromDate, $toDate, $interval2) as $date) { $result[] = array($date, $this->entityManager->getRepository(Invoice::getClass())->getAmountByStringDate($date, $interval)); } return $result; }