/**
* 通过区县标识获取开通城市ID
* @param $district
* @return int
*/
public static function districtToOpenCityId($district)
{
// 获取地区的区号
$area = SysAreaZipDistrictPhonecode::findFirst('K_ID = ' . $district);
if (!$area) {
return 0;
}
$phoneCode = $area->PHONE_CODE;
$openCityInfo = SysOpenCity::query()->where('city_code = :code:', ['code' => $phoneCode])->execute()->getFirst();
if (!$openCityInfo) {
return 0;
}
return $openCityInfo->city_id;
}
/**
* 获取开通城市的ID
* @param $code
* @return int
*/
public function getCityId($code)
{
$city = SysOpenCity::query()->columns('city_id')->where('city_code=:code: and city_state = 1')->bind(['code' => $code])->limit(1)->execute()->getFirst();
return $city ? $city->city_id : 0;
}
/**
* 开通城市管理列表
* @date: 2016年1月6日
* @author: chenxiaolin
*/
public function openCityListAction()
{
$this->setLeftNav('openCityList');
$req = $this->request;
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$offset = $limit * ($page - 1);
$filterCity = $req->getQuery('filterCity', null, -10000);
$filterState = $req->getQuery('filterState', null, -10000);
$where = [];
if ($filterCity > -10000) {
$where[] = " city_id = {$filterCity} ";
}
if ($filterState > -10000) {
$where[] = " city_state = {$filterState} ";
}
$whereStr = implode(' AND ', $where);
$data = SysOpenCity::query()->where($whereStr)->execute();
$this->view->setVar('openCity', SysOpenCity::find());
$this->view->setVar('filterCity', $filterCity);
$this->view->setVar('filterState', $filterState);
//$this->view->setVar('data', SysOpenCity::find($where));
$this->view->setVar('data', $data);
}
public function run()
{
$data = SysOpenCity::query()->columns(['city_code code', 'city_name name'])->where('city_state = 1')->orderBy('city_order DESC, city_id ASC')->execute()->toArray();
$this->setResult($data);
}
