/** * * @return unknown_type */ function _lastYear() { $database = JFactory::getDBO(); $date = JFactory::getDate(); //get local data $today = TiendaHelperBase::getCorrectBeginDayTime($date); //first day of year $first_day_year = $date->toFormat("%Y-01-01 00:00:00"); $enddate = TiendaHelperBase::getCorrectBeginDayTime($first_day_year); $query = new TiendaQuery(); $query = " SELECT DATE_SUB('" . $enddate . "', INTERVAL 1 YEAR) "; $database->setQuery($query); $startdate = $database->loadResult(); $return = $this->_getDateDb($startdate, $enddate, true, true); $days = $return->days_in_business > 0 ? $return->days_in_business : 1; $return->average_daily = $return->num / $days; return $return; }