public function expandinfo_select($page = 1, $r = 20)
{
$nickname = I('nickname');
$map['status'] = array('egt', 0);
if (is_numeric($nickname)) {
$map['uid|nickname'] = array(intval($nickname), array('like', '%' . $nickname . '%'), '_multi' => true);
} else {
$map['nickname'] = array('like', '%' . (string) $nickname . '%');
}
$list = M('Member')->where($map)->order('last_login_time desc')->page($page, $r)->select();
$totalCount = M('Member')->where($map)->count();
int_to_string($list);
//扩展信息查询
$map_profile['status'] = 1;
$field_group = D('field_group')->where($map_profile)->select();
$field_group_ids = array_column($field_group, 'id');
$map_profile['profile_group_id'] = array('in', $field_group_ids);
$fields_list = D('field_setting')->where($map_profile)->getField('id,field_name,form_type');
$fields_list = array_combine(array_column($fields_list, 'field_name'), $fields_list);
$fields_list = array_slice($fields_list, 0, 8);
//取出前8条，用户扩展资料默认显示8条
foreach ($list as &$tkl) {
$tkl['id'] = $tkl['uid'];
$map_field['uid'] = $tkl['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 == '') {
$tkl[$key] = '';
} else {
$tkl[$key] = $field_data;
}
}
}
$builder = new AdminListBuilder();
$builder->title(L('_USER_EXPAND_INFO_LIST_'));
$builder->meta_title = L('_USER_EXPAND_INFO_LIST_');
$builder->setSearchPostUrl(U('Admin/User/expandinfo_select'))->search(L('_SEARCH_'), 'nickname', 'text', L('_PLACEHOLDER_NICKNAME_ID_'));
$builder->keyId()->keyLink('nickname', L('_NICKNAME_'), 'User/expandinfo_details?uid=###');
foreach ($fields_list as $vt) {
$builder->keyText($vt['field_name'], $vt['field_name']);
}
$builder->data($list);
$builder->pagination($totalCount, $r);
$builder->display();
}