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