state->insert('filter_campaign_id', 'int', 0); } /** * Get sales data in last 12 months * * @return array * * @throws Exception */ public function getData() { $db = $this->getDbo(); $query = $db->getQuery(true); $today = Factory::getDate('Now', Factory::getApplication()->get('offset')); $sales = []; for ($i = 0; $i < 12; $i++) { if ($i > 0) { $today->modify('-1 month'); } $month = $today->format('n', true); $year = $today->format('Y', true); $startMonth = clone $today; $endMonth = clone $today; $startMonth->setTime(0, 0, 0); $startMonth->setDate($year, $month, 1); $endMonth->setTime(23, 59, 59); $endMonth->setDate($year, $month, $today->format('t', true)); $query->clear() ->select('SUM(amount)') ->from('#__jd_donors') ->where('published = 1') ->where('created_date >=' . $db->quote($startMonth->toSql())) ->where('created_date <= ' . $db->quote($endMonth->toSql())); if ($this->state->filter_campaign_id) { $query->where('campaign_id = ' . $this->state->filter_campaign_id . ')'); } $db->setQuery($query); //echo $db->getQuery(); //echo "
"; $sales[$today->format('M') . '/ ' . $year] = (int) $db->loadResult(); } return (array)$sales; } }