/** * 通过区县标识获取开通城市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; }
protected function getDistrictInfo($id) { return SysAreaZipDistrictPhonecode::findFirst('K_ID = ' . $id); }
/** * 编辑用户信息 * @date: 2016-1-5 * @author: futao */ public function editAction() { $this->setLeftNav("update"); $req = $this->request; $id = $req->getQuery("id", null, 0); $action = $req->getQuery("action", null, ''); $info = UserBase::query()->columns(['user_account', 'user_password', 'user_district', 'user_nickname', 'user_realname', 'bind_phone', 'persional_sign', 'user_birthday', 'user_cover', 'user_gender', 'user_expert'])->where("user_id = :id:")->bind(['id' => $id])->execute()->getFirst(); if (!$info) { $this->view->disable(); echo '用户不存在!'; return; } if ($info->user_expert == 1) { $userAttr = UserAttribute::findFirst('user_id =' . $id . ' and attr_type = 103 and attr_state = 1'); $this->view->setVar('user_attr', json_decode($userAttr->attr_value_json)); } //个性签名解码 if (unserialize(base64_decode($info->persional_sign))) { $info->persional_sign = unserialize(base64_decode($info->persional_sign)); } $info->user_cover = PicUrl::UserCover($info->user_cover, $this->di); $userArea = SysAreaZipDistrictPhonecode::findFirst("K_ID = " . $info->user_district); $this->view->setVar('userArea', $userArea); $this->view->setVar('userInfo', $info); $this->view->setVar('userId', $id); $this->view->setVar('action', $action); }