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(); }