/**
* 通过区县标识获取开通城市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);
}
