/** * Find all users * @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_role'), array('r.*')); if (isset($criteria['search_filter'])) { $searchString = '%' . $criteria['search_filter'] . '%'; $select->where(' r.name LIKE ? ', $searchString); } if (isset($criteria['name'])) { $searchString = '%' . $criteria['name'] . '%'; $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); } $roles = array(); if (0 == count($resultSet)) { return $roles; } foreach ($resultSet as $row) { $rowArray = $row->toArray(); $role = new Auth_Model_Role($rowArray); $roles[] = $role; } return $roles; }