/**
* 支持的字段有
* member表中的所有字段，ucenter_member表中的所有字段
* 等级：title
* 头像：avatar32 avatar64 avatar128 avatar256 avatar512
* 个人中心地址：space_url
* 认证图标：icons_html
*
* @param $fields array|string 如果是数组，则返回数组。如果不是数组，则返回对应的值
* @param null $uid
* @return array|null
*/
function query_user($fields = null, $uid = null)
{
if ($fields === null) {
$fields = array('nickname', 'space_url', 'avatar64', 'avatar128', 'uid');
}
//如果fields不是数组，则返回值也不是数组
if (!is_array($fields)) {
$result = query_user(array($fields), $uid);
return $result[$fields];
}
if (in_array('score', $fields)) {
$fields[] = 'score1';
}
//默认获取自己的资料
$uid = $uid ? $uid : is_login();
if (!$uid) {
return null;
}
//查询缓存，过滤掉已缓存的字段
$cachedFields = array();
$cacheResult = array();
foreach ($fields as $field) {
if (in_array($field, array('icons_html', 'title', 'score'))) {
continue;
}
$cache = read_query_user_cache($uid, $field);
if (!empty($cache)) {
$cacheResult[$field] = $cache;
$cachedFields[] = $field;
}
}
//去除已经缓存的字段
$fields = array_diff($fields, $cachedFields);
//获取两张用户表格中的所有字段
$homeModel = M('Member');
$ucenterModel = UCenterMember();
$homeFields = $homeModel->getDbFields();
$ucenterFields = $ucenterModel->getDbFields();
//分析每个表格分别要读取哪些字段
$avatarFields = array('avatar32', 'avatar64', 'avatar128', 'avatar256', 'avatar512');
$avatarFields = array_intersect($avatarFields, $fields);
$homeFields = array_intersect($homeFields, $fields);
$ucenterFields = array_intersect($ucenterFields, $fields);
//查询需要的字段
$homeResult = array();
$ucenterResult = array();
if ($homeFields) {
$homeResult = D('Home/Member')->where(array('uid' => $uid))->field($homeFields)->find();
}
if ($ucenterFields) {
$model = UCenterMember();
$ucenterResult = $model->where(array('id' => $uid))->field($ucenterFields)->find();
}
//读取头像数据
$result = array();
$avatarObject = new \Ucenter\Widget\UploadAvatarWidget();
foreach ($avatarFields as $e) {
$avatarSize = intval(substr($e, 6));
$avatarUrl = $avatarObject->getAvatar($uid, $avatarSize);
$check = file_exists('./api/uc_login.lock');
if ($check) {
include_once './api/uc_client/client.php';
$avatarUrl = UC_API . '/avatar.php?uid=' . $uid . '&size=big';
}
$result[$e] = $avatarUrl;
}
//读取等级数据
if (in_array('title', $fields)) {
$titleModel = D('Ucenter/Title');
$title = $titleModel->getTitle($uid);
$result['title'] = $title;
}
//读取用户名拼音
if (in_array('pinyin', $fields)) {
$result['pinyin'] = D('Pinyin')->pinYin($result['nickname']);
}
//获取个人中心地址
$spaceUrlResult = array();
if (in_array('space_url', $fields)) {
$result['space_url'] = U('Ucenter/Index/index', array('uid' => $uid));
}
if (in_array('nickname', $fields)) {
$ucenterResult['nickname'] = op_t($ucenterResult['nickname']);
}
//获取昵称链接
if (in_array('space_link', $fields)) {
if (!$ucenterResult['nickname']) {
$res = query_user(array('nickname'), $uid);
$ucenterResult['nickname'] = $res['nickname'];
}
$result['space_link'] = '<a ucard="' . $uid . '" target="_blank" href="' . U('Ucenter/Index/index', array('uid' => $uid)) . '">' . $ucenterResult['nickname'] . '</a>';
}
//获取用户头衔链接
if (in_array('rank_link', $fields)) {
$rank_List = D('rank_user')->where(array('uid' => $uid, 'status' => 1))->select();
$num = 0;
foreach ($rank_List as &$val) {
$rank = D('rank')->where('id=' . $val['rank_id'])->find();
$val['title'] = $rank['title'];
$val['logo_url'] = fixAttachUrl(D('picture')->where('id=' . $rank['logo'])->getField('path'));
if ($val['is_show']) {
$num = 1;
}
}
if ($rank_List) {
$rank_List[0]['num'] = $num;
$result['rank_link'] = $rank_List;
} else {
$result['rank_link'] = array();
}
}
//获取用户认证图标
if (in_array('icons_html', $fields)) {
//判断是否有手机图标
$static = C('TMPL_PARSE_STRING.__STATIC__');
$iconUrls = array();
$user = query_user(array('mobile'), $uid);
if ($user['mobile']) {
$iconUrls[] = "{$static}/oneplus/images/mobile-bind.png";
}
//生成结果
$result['icons_html'] = '<span class="usercenter-verify-icon-list">';
foreach ($iconUrls as $e) {
$result['icons_html'] .= "<img src=\"{$e}\" title=\"对方已绑定手机\"/>";
}
$result['icons_html'] .= '</span>';
}
//expand_info:用户扩展字段信息
if (in_array('expand_info', $fields)) {
$map['status'] = 1;
$field_group = D('field_group')->where($map)->select();
$field_group_ids = array_column($field_group, 'id');
$map['profile_group_id'] = array('in', $field_group_ids);
$fields_list = D('field_setting')->where($map)->getField('id,field_name,form_type,visiable');
$fields_list = array_combine(array_column($fields_list, 'field_name'), $fields_list);
$map_field['uid'] = $uid;
foreach ($fields_list as $key => $val) {
$map_field['field_id'] = $val['id'];
$field_data = D('field')->where($map_field)->getField('field_data');
if ($field_data == null || $field_data == '') {
unset($fields_list[$key]);
} else {
if ($val['form_type'] == "checkbox") {
$field_data = explode('|', $field_data);
}
$fields_list[$key]['data'] = $field_data;
}
}
$result['expand_info'] = $fields_list;
}
//粉丝数、关注数、微博数
if (in_array('fans', $fields)) {
$result['fans'] = D('Follow')->where('follow_who=' . $uid)->count();
}
if (in_array('following', $fields)) {
$result['following'] = D('Follow')->where('who_follow=' . $uid)->count();
}
//是否关注、是否被关注
if (in_array('is_following', $fields)) {
$follow = D('Follow')->where(array('who_follow' => get_uid(), 'follow_who' => $uid))->find();
$result['is_following'] = $follow ? true : false;
}
if (in_array('is_followed', $fields)) {
$follow = D('Follow')->where(array('who_follow' => $uid, 'follow_who' => get_uid()))->find();
$result['is_followed'] = $follow ? true : false;
}
//TODO 在此加入扩展字段的处理钩子
//↑↑↑ 新增字段应该写在在这行注释以上 ↑↑↑
//合并结果，不包括缓存
$result = array_merge($ucenterResult, $homeResult, $spaceUrlResult, $result);
//写入缓存
foreach ($result as $field => $value) {
if (in_array($field, array('icons_html', 'title', 'score', 'tox_money'))) {
continue;
}
if (!in_array($field, array('rank_link', 'icons_html', 'space_link', 'expand_info'))) {
$value = str_replace('"', '', op_t($value));
}
$result[$field] = $value;
write_query_user_cache($uid, $field, str_replace('"', '', $value));
}
//合并结果，包括缓存
$result = array_merge($result, $cacheResult);
$result['score'] = $result['score1'];
//返回结果
return $result;
}
/**
* @param $uid
* @param $result
* @return mixed
*/
public function writeCache($uid, $result)
{
//写入缓存
foreach ($result as $field => $value) {
if (!in_array($field, array('rank_link', 'space_link', 'expand_info'))) {
$value = str_replace('"', '', text($value));
}
$result[$field] = $value;
write_query_user_cache($uid, $field, str_replace('"', '', $value));
}
return $result;
}
/**
* 支持的字段有
* member表中的所有字段，ucenter_member表中的所有字段
* 等级：title
* 头像：avatar32 avatar64 avatar128 avatar256 avatar512
* 个人中心地址：space_url
* 认证图标：icons_html
*
* @param $fields array|string 如果是数组，则返回数组。如果不是数组，则返回对应的值
* @param null $uid
* @return array|null
*/
function query_user($fields, $uid = null)
{
//如果fields不是数组，则返回值也不是数组
if (!is_array($fields)) {
$result = query_user(array($fields), $uid);
return $result[$fields];
}
//默认获取自己的资料
$uid = $uid ? $uid : is_login();
if (!$uid) {
return null;
}
//查询缓存，过滤掉已缓存的字段
$cachedFields = array();
$cacheResult = array();
foreach ($fields as $field) {
if (in_array($field, array('icons_html', 'title', 'score'))) {
continue;
}
$cache = read_query_user_cache($uid, $field);
if (!empty($cache)) {
$cacheResult[$field] = $cache;
$cachedFields[] = $field;
}
}
//去除已经缓存的字段
$fields = array_diff($fields, $cachedFields);
//获取两张用户表格中的所有字段
$homeModel = M('Member');
$ucenterModel = M('UcenterMember');
$homeFields = $homeModel->getDbFields();
$ucenterFields = $ucenterModel->getDbFields();
$homeFields = array_intersect($homeFields, $fields);
$ucenterFields = array_intersect($ucenterFields, $fields);
//查询需要的字段
$homeResult = array();
$ucenterResult = array();
if ($homeFields) {
$homeResult = D('Home/Member')->where(array('uid' => $uid))->field($homeFields)->find();
}
if ($ucenterFields) {
$model = D('User/UcenterMember');
$ucenterResult = $model->where(array('id' => $uid))->field($ucenterFields)->find();
}
//读取头像数据
$result = array();
//读取头像数据
if (in_array('avatar', $fields)) {
$avatarModel = D('Home/Avatar');
$avatar = $avatarModel->getAvatar($uid);
if ($avatar) {
$result['avatar'] = $avatar;
} else {
$result['avatar'] = cdn('default/avatar.jpg');
}
}
//读取等级数据
if (in_array('title', $fields)) {
$titleModel = D('Usercenter/Title');
$title = $titleModel->getTitle($uid);
$result['title'] = $title;
}
//读取用户名拼音
if (in_array('pinyin', $fields)) {
$result['pinyin'] = D('Pinyin')->pinYin($result['username']);
}
//获取个人中心地址
$spaceUrlResult = array();
if (in_array('space_url', $fields)) {
$result['space_url'] = U('UserCenter/Index/index', array('uid' => $uid));
}
//获取昵称链接
if (in_array('space_link', $fields)) {
$result['space_link'] = '<a ucard="' . $uid . '" href="' . U('UserCenter/Index/index', array('uid' => $uid)) . '">' . $ucenterResult['username'] . '</a>';
}
//获取用户头衔链接
if (in_array('rank_link', $fields)) {
$rank_List = D('rank_user')->where('uid=' . $uid)->select();
$num = 0;
foreach ($rank_List as &$val) {
$rank = D('rank')->where('id=' . $val['rank_id'])->find();
$val['title'] = $rank['title'];
$val['logo_url'] = getRootUrl() . D('picture')->where('id=' . $rank['logo'])->getField('path');
if ($val['is_show']) {
$num = 1;
}
}
if ($rank_List) {
$rank_List[0]['num'] = $num;
$result['rank_link'] = $rank_List;
} else {
$result['rank_link'] = array();
}
}
//获取用户认证图标
if (in_array('icons_html', $fields)) {
//判断是否有手机图标
$static = C('TMPL_PARSE_STRING.__STATIC__');
$iconUrls = array();
$user = query_user(array('mobile'), $uid);
if ($user['mobile']) {
$iconUrls[] = "{$static}/oneplus/images/mobile-bind.png";
}
//生成结果
$result['icons_html'] = '<span class="usercenter-verify-icon-list">';
foreach ($iconUrls as $e) {
$result['icons_html'] .= "<img src=\"{$e}\" title=\"对方已绑定手机\"/>";
}
$result['icons_html'] .= '</span>';
}
//粉丝数、关注数、微博数
if (in_array('fans', $fields)) {
$result['fans'] = D('Follow')->where('follow_who=' . $uid)->count();
}
if (in_array('following', $fields)) {
$result['following'] = D('Follow')->where('who_follow=' . $uid)->count();
}
if (in_array('weibocount', $fields)) {
$result['weibocount'] = D('Weibo')->where('uid=' . $uid)->count();
}
//是否关注、是否被关注
if (in_array('is_following', $fields)) {
$follow = D('Follow')->where(array('who_follow' => get_uid(), 'follow_who' => $uid))->find();
$result['is_following'] = $follow ? true : false;
}
if (in_array('is_followed', $fields)) {
$follow = D('Follow')->where(array('who_follow' => $uid, 'follow_who' => get_uid()))->find();
$result['is_followed'] = $follow ? true : false;
}
//↑↑↑ 新增字段应该写在在这行注释以上 ↑↑↑
//合并结果，不包括缓存
$result = array_merge($ucenterResult, $homeResult, $spaceUrlResult, $result);
//写入缓存
foreach ($result as $field => $value) {
if (in_array($field, array('icons_html', 'title', 'score'))) {
continue;
}
if (!in_array($field, array('rank_link', 'icons_html', 'space_link'))) {
$value = str_replace('"', '', op_t($value));
}
$result[$field] = $value;
write_query_user_cache($uid, $field, str_replace('"', '', $value));
}
//合并结果，包括缓存
$result = array_merge($result, $cacheResult);
//返回结果
return $result;
}
public function bindMobile($verify)
{
$this->requireLogin();
//确认用户未绑定手机
$uid = $this->getuid();
$user = D('User/UcenterMember')->where(array('id' => $uid))->find();
if ($user['mobile']) {
$this->apiError(1801, "您已经绑定手机，需要先解绑");
}
//确认手机验证码正确
$mobile = getMobileFromSession();
$addon = new TianyiAddon();
if (!$addon->checkVerify($mobile, $verify)) {
$this->apiError(1802, "手机验证码错误");
}
//确认手机号码没有重复
$user = D('User/UcenterMember')->where(array('mobile' => $mobile, 'status' => 1))->find();
if ($user) {
$this->apiError(1803, '该手机号码已绑定到另一个账号，不能重复绑定');
}
//修改数据库
$uid = $this->getUid();
D('User/UcenterMember')->where(array('id' => $uid))->save(array('mobile' => $mobile));
write_query_user_cache($uid, 'mobile', $mobile);
//返回成功结果
$this->apiSuccess("绑定成功");
}