function getRegions()
{
$search = $this->getState('filter.search');
if ($this->getState('filter.region') != '' || $search != '') {
$db = JFactory::getDBO();
$query = "SELECT r.*, rr.name as parent_name FROM #__djcf_regions r " . "LEFT JOIN #__djcf_regions rr ON r.parent_id=rr.id " . "WHERE 1 " . $this->_buildWhere() . " ORDER BY r.name";
$db->setQuery($query);
$regions = $db->loadObjectList();
} else {
$regions = DJClassifiedsRegion::getRegAll();
}
$limitstart = $this->getState('list.start', 0);
$limit = $this->getState('list.limit', 0);
if ($limit > 0) {
$regions = array_slice($regions, $limitstart, $limit);
} else {
$regions = array_slice($regions, 0);
}
return $regions;
}
