/** * @author KienNN * @param \Address\Model\Country $item */ public function isExisted($item) { if (!$item->getName()) { return null; } $select = $this->getDbSql()->select(array('ctr' => self::TABLE_NAME)); $select->where(array('name' => $item->getName())); $query = $this->getDbSql()->buildSqlString($select); $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE); if ($results->count()) { $item->exchangeArray((array) $results->current()); return true; } return false; }
public function get($id) { $dbAdapter = $this->getDbAdapter(); $dbSql = $this->getDbSql(); $select = $dbSql->select(array('ctr' => self::TABLE_NAME)); $select->where(array('ctr.id' => $id)); $query = $dbSql->buildSqlString($select); $results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE); if ($results) { $model = new Country(); $model->exchangeArray((array) $results->current()); return $model; } return null; }