/**
* Find all resources
*
* @param array $criteria
* @param array $orderBy
* @param array $paging
* @return array
*/
public function fetchAll($criteria = array(), $orderBy = array(), &$paging = null)
{
/* @var $select Zend_Db_Select*/
$select = $this->_dbTable->select();
$select->setIntegrityCheck(false)->from(array('r' => 'auth_resource'), array('r.*'));
if (isset($criteria['search_filter'])) {
$searchString = '%' . $criteria['search_filter'] . '%';
$select->where(' r.name LIKE ? ', $searchString);
}
if (is_array($orderBy) && count($orderBy) > 0) {
$select->order($orderBy);
}
//echo $select->__toString();die();
// init paginator
if ($paging != null) {
$resultSet = $this->_getPagingRows($paging, $select);
} else {
$resultSet = $this->_dbTable->fetchAll($select);
}
$resources = array();
if (0 == count($resultSet)) {
return $resources;
}
foreach ($resultSet as $row) {
$resources[$row->id] = new Auth_Model_Resource($row->toArray());
}
return $resources;
}
