Ejemplo n.º 1
0
 /**
  * @param int $id
  * @return \Address\Model\City|NULL
  */
 public function get($id)
 {
     $dbAdapter = $this->getDbAdapter();
     $select = $this->getDbSql()->select(['ct' => self::TABLE_NAME]);
     $select->where(array('ct.id' => $id));
     $query = $this->getDbSql()->buildSqlString($select);
     $results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
     if ($results) {
         $ct = new City();
         $ct->exchangeArray((array) $results->current());
         return $ct;
     }
     return null;
 }
Ejemplo n.º 2
0
 /**
  * @author KienNN
  * @param \Address\Model\City $item
  */
 public function isExisted($item)
 {
     if (!$item->getNativeName()) {
         return null;
     }
     $select = $this->getDbSql()->select(['ct' => self::TABLE_NAME]);
     $select->where(['name' => $item->getNativeName()]);
     $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;
 }