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