/** * Method to get a list of options for a list input. * * @return array An array of JHtml options. */ public function getOptions() { $jinput = JFactory::getApplication()->input; $client = $jinput->get('id', 0, 'INT'); $countries = CostbenefitprojectionHelper::hisCountries(null, $client, 'company'); $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select($db->quoteName(array('a.year', 'a.country'), array('year', 'country'))); $query->from($db->quoteName('#__costbenefitprojection_health_data', 'a')); $query->where($db->quoteName('a.published') . ' = 1'); if (CostbenefitprojectionHelper::checkArray($countries)) { $query->where($db->quoteName('a.country') . ' IN (' . implode(',', $countries) . ')'); } $query->order('a.country ASC'); $db->setQuery((string) $query); $items = $db->loadObjectList(); $options = array(); if ($items) { $years = array(); foreach ($items as $item) { if (!CostbenefitprojectionHelper::checkArray($years) || !in_array($item->year . '_' . $item->country, $years)) { if (!CostbenefitprojectionHelper::checkArray($countries) || $client == 0) { $countryName = ' (' . CostbenefitprojectionHelper::getCountryName($item->country) . ')'; } else { $countryName = ''; } $options[] = JHtml::_('select.option', $item->year, $item->year . $countryName); $years[$item->year] = $item->year . '_' . $item->country; } } } return $options; }