Code: Select all
public function __construct($config = array())
{
if (empty($config['filter_fields'])) {
$config['filter_fields'] = array(
'id', 'a.id',
);
}
parent::__construct($config);
}
protected function populateState($ordering = null, $direction = null)
{
// Initialise variables.
$app = JFactory::getApplication();
// List state information
$limits = $app->getUserStateFromRequest('global.list.limit', 'limit', $app->getCfg('list_limit'));
$this->setState('list.limit', $limits);
$limitstarts = $app->input->getInt('limitstart', 0);
$this->setState('list.start', $limitstarts);
//echo $limit."<br>".$limitstart;
parent::populateState($ordering, $direction);
}
protected function getListQuery()
{
// Create a new query object.
$db = $this->getDbo();
$query = $db->getQuery(true);
$query="select * from #__morfeoshow ORDER BY id DESC ";
//echo $query;
//exit;
return $query;
}
public function getItems()
{
$items = parent::getItems();
//echo "<pre>";
//print_r($items);exit;
return $items;
}
Please provide me best solutions for it