基本用户隐私设置功能设计：从需求到落地的全流程方案

-- 用户隐私设置主表（存储基础设置项）CREATE TABLE user_privacy_setting (    id BIGINT AUTO_INCREMENT PRIMARY KEY,    user_id BIGINT NOT NULL COMMENT '用户ID（关联用户表）',    profile_visibility JSON NOT NULL COMMENT '个人信息可见范围设置（如{"nickname":"self","phone":"self","address":"order_only"}）',    data_authorization JSON NOT NULL COMMENT '数据授权设置（如{"third_app":[{"app_id":"wechat","auth_time":"2024-10-01","auth_scope":["nickname","avatar"]}],"inner_func":{"personalized_recommend":false,"data_optimize":false}}）',    notification_setting JSON NOT NULL COMMENT '隐私通知设置（如{"policy_update":"app_only","auth_change":true,"risk_alert":true}）',    data_trace_setting JSON NOT NULL COMMENT '数据痕迹设置（如{"search_real_time_clear":false}）',    last_update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',    create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',    UNIQUE KEY uk_user_id (user_id) -- 一个用户仅一条设置记录) ENGINE=InnoDB COMMENT '用户隐私设置主表';-- 用户隐私操作日志表（追溯用户修改记录，用于安全审计）CREATE TABLE user_privacy_operation_log (    id BIGINT AUTO_INCREMENT PRIMARY KEY,    user_id BIGINT NOT NULL COMMENT '用户ID',    operation_type VARCHAR(50) NOT NULL COMMENT '操作类型（如"update_profile_visibility"：修改个人信息可见性，"cancel_third_auth"：取消第三方授权）',    old_value JSON COMMENT '修改前的值',    new_value JSON COMMENT '修改后的值',    operation_ip VARCHAR(50) COMMENT '操作IP地址',    operation_device VARCHAR(100) COMMENT '操作设备（如"iPhone 15, iOS 17.0"）',    operation_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',    INDEX idx_user_id (user_id),    INDEX idx_operation_time (operation_time)) ENGINE=InnoDB COMMENT '用户隐私操作日志表';

{  "code": 200,  "msg": "success",  "data": {    "profile_visibility": {      "nickname": "self", // self=仅自己可见，friend=仅好友可见，public=公开，order_only=仅下单时可见      "phone": "self",      "address": "self",      "dynamic": "self"    },    "data_authorization": {      "third_app": [        {          "app_id": "wechat",          "app_name": "微信",          "auth_time": "2024-10-01 10:30:00",          "auth_scope": ["nickname", "avatar"]        }      ],      "inner_func": {        "personalized_recommend": false,        "data_optimize": false      }    },    "notification_setting": {      "policy_update": "app_only", // app_only=仅APP内消息，all=APP+短信，close=关闭      "auth_change": true,      "risk_alert": true    },    "data_trace_setting": {      "search_real_time_clear": false    }  }}

{  "user_id": 123456, // 从登录态获取  "profile_type": "phone", // 信息类型：nickname/phone/address/dynamic  "visibility": "self" // 可见选项：self/friend/public/order_only}

{  "code": 200,  "msg": "个人信息可见范围修改成功",  "data": {    "profile_type": "phone",    "new_visibility": "self",    "effective_time": "2024-10-23 15:30:22" // 即时生效时间  }}

// 伪代码：根据隐私设置返回用户信息public UserInfoDTO getUserInfo(Long currentUserId, Long targetUserId) {    // 1. 查询目标用户的隐私设置    UserPrivacySetting setting = privacySettingMapper.getByUserId(targetUserId);    JSONObject profileVisibility = JSON.parseObject(setting.getProfileVisibility());        // 2. 查询目标用户的完整信息    User targetUser = userMapper.getById(targetUserId);    UserInfoDTO dto = new UserInfoDTO();    dto.setUserId(targetUser.getId());        // 3. 根据隐私设置决定是否返回字段    String nicknameVisibility = profileVisibility.getString("nickname");    if ("public".equals(nicknameVisibility) ||         ("friend".equals(nicknameVisibility) && isFriend(currentUserId, targetUserId)) ||         currentUserId.equals(targetUserId)) {        dto.setNickname(targetUser.getNickname());    } else {        dto.setNickname("***"); // 隐藏昵称    }        // 手机号仅自己可见，其他情况隐藏    if (currentUserId.equals(targetUserId)) {        dto.setPhone(targetUser.getPhone());    } else {        dto.setPhone("****");    }        return dto;}