/** * Find and populate entity by id * * @param string $id * @param Cms_Model_Route $item * @return boolean */ public function find($id, Cms_Model_Route $route) { /* @var $select Zend_Db_Select*/ $select = $this->_dbTable->select(); $select->setIntegrityCheck(false)->from(array('r' => 'cms_route'), array('r.*'))->joinLeft(array('p' => 'cms_page'), "p.id = r.page_id", array('page_title' => 'title', 'page_id' => 'id'))->where("r.id = ?", $id); $resultSet = $this->_dbTable->fetchAll($select); if (0 == count($resultSet)) { return false; } $row = $resultSet->current(); $rowArray = $row->toArray(); $route->setOptions($rowArray); return true; }