/**
* @param int $id
* @return District|null
*/
public function get($id)
{
$dbAdapter = $this->getDbAdapter();
$select = $this->getDbSql()->select(array("d" => self::TABLE_NAME));
$select->where(array('d.id' => $id));
$query = $this->getDbSql()->buildSqlString($select);
$results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($results) {
$d = new District();
$d->exchangeArray((array) $results->current());
return $d;
}
return null;
}
/**
* @author KienNN
* @param \Address\Model\District $item
*/
public function isExisted($item)
{
if (!$item->getName() || !$item->getCityId()) {
return null;
}
$select = $this->getDbSql()->select(array("d" => self::TABLE_NAME));
$select->where(['name' => $item->getName()]);
$select->where(['cityId' => $item->getCityId()]);
$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;
}