prova ed elabora questo:nel model
protected function getListQuery()
{
// Get the current user for authorisation checks
$this->user = JFactory::getUser();
$this->userId = $this->user->get('id');
$this->guest = $this->user->get('guest');
$this->groups = $this->user->get('groups');
$this->authorisedGroups = $this->user->getAuthorisedGroups();
$this->levels = $this->user->getAuthorisedViewLevels();
$this->app = JFactory::getApplication();
$this->input = $this->app->input;
$this->initSet = true;
// Make sure all records load, since no pagination allowed.
$this->setState('list.limit', 0);
// Get a db connection.
$query = $db->getQuery(true);
// Get from #__calcolo_imposte as a
$query->select($db->quoteName(
array('a.id','a.asset_id','a.aliquota1','a.aliquota2','a.aliquota3','a.published','a.created_by','a.modified_by','a.created','a.modified','a.version','a.hits','a.ordering'),
array('id','asset_id','aliquota1','aliquota2','aliquota3','published','created_by','modified_by','created','modified','version','hits','ordering')));
$query->from($db->quoteName('#__calcolo_imposte', 'a'));
// Get where a.published is 1
$query->where('a.published = 1');
// return the query object
return $query;
}
nella vista:<?php foreach ($this->items as $item): ?>
<?php echo $item->aliquota1; ?>
<?php echo $item->aliquota2; ?>
<?php echo $item->aliquota3; ?>
<?php endforeach; ?>