FamilyMemberService.java 83 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738
  1. package com.etotem.cfc.service;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.etotem.cfc.common.Result;
  4. import com.etotem.cfc.dto.AddFamilyMemberDTO;
  5. import com.etotem.cfc.dto.FamilyMemberVO;
  6. import com.etotem.cfc.dto.SwitchMemberVO;
  7. import com.etotem.cfc.entity.Family;
  8. import com.etotem.cfc.entity.FamilyMember;
  9. import com.etotem.cfc.entity.FamilyRelationship;
  10. import com.etotem.cfc.entity.FamilyMemberAttributes;
  11. import com.etotem.cfc.entity.FamilyMemberLog;
  12. import com.etotem.cfc.entity.FiveDimensionScore;
  13. import com.etotem.cfc.entity.HealthReport;
  14. import com.etotem.cfc.entity.Task;
  15. import com.etotem.cfc.entity.User;
  16. import com.etotem.cfc.enums.GenerationLevel;
  17. import com.etotem.cfc.mapper.FamilyMapper;
  18. import com.etotem.cfc.mapper.FamilyMemberAttributesMapper;
  19. import com.etotem.cfc.mapper.FamilyMemberLogMapper;
  20. import com.etotem.cfc.mapper.FamilyMemberMapper;
  21. import com.etotem.cfc.mapper.FiveDimensionScoreMapper;
  22. import com.etotem.cfc.mapper.HealthReportMapper;
  23. import com.etotem.cfc.mapper.TaskMapper;
  24. import com.etotem.cfc.mapper.UserMapper;
  25. import org.slf4j.Logger;
  26. import org.slf4j.LoggerFactory;
  27. import org.springframework.security.access.AccessDeniedException;
  28. import org.springframework.stereotype.Service;
  29. import org.springframework.transaction.annotation.Transactional;
  30. import javax.annotation.Resource;
  31. import java.util.ArrayList;
  32. import java.util.Comparator;
  33. import java.util.Date;
  34. import java.util.List;
  35. import java.util.Map;
  36. import java.util.stream.Collectors;
  37. import com.etotem.cfc.util.SortUtil;
  38. import com.etotem.cfc.util.FamilyNamingSupport;
  39. import com.etotem.cfc.util.UserUtil;
  40. @Service
  41. public class FamilyMemberService {
  42. private static final Logger log = LoggerFactory.getLogger(FamilyMemberService.class);
  43. /** SC-P-04 family.familyMembers.list 在线判定窗口:最后互动时间距今 15 分钟内视为在线 */
  44. private static final long ONLINE_WINDOW_MS = 15 * 60 * 1000L;
  45. @Resource
  46. private FamilyMemberMapper familyMemberMapper;
  47. @Resource
  48. private UserMapper userMapper;
  49. @Resource
  50. private FamilyMapper familyMapper;
  51. @Resource
  52. private FamilyMemberAttributesMapper familyMemberAttributesMapper;
  53. @Resource
  54. private OnboardingService onboardingService;
  55. @Resource
  56. private SystemConfigService systemConfigService;
  57. @Resource
  58. private FamilyRelationshipService familyRelationshipService;
  59. @Resource
  60. private FamilyMemberLogMapper familyMemberLogMapper;
  61. @Resource
  62. private CouponService couponService;
  63. @Resource
  64. private FiveDimensionScoreMapper fiveDimensionScoreMapper;
  65. @Resource
  66. private TaskMapper taskMapper;
  67. @Resource
  68. private HealthReportMapper healthReportMapper;
  69. @Resource
  70. private MembershipService membershipService;
  71. @Resource
  72. private FamilyFoodOverviewService familyFoodOverviewService;
  73. @Resource
  74. private ReportMemberPermissionService reportMemberPermissionService;
  75. /**
  76. * 校验成员是否属于指定家庭(用于避免跨家庭读写成员数据)
  77. */
  78. public boolean isMemberInFamily(Long familyId, Long memberId) {
  79. if (familyId == null || memberId == null) {
  80. return false;
  81. }
  82. FamilyMember member = familyMemberMapper.selectById(memberId);
  83. return member != null && familyId.equals(member.getFamilyId());
  84. }
  85. /**
  86. * 添加家庭成员
  87. */
  88. @Transactional(rollbackFor = Exception.class)
  89. public FamilyMemberVO addMember(Long userId, AddFamilyMemberDTO dto) {
  90. if (dto.getNickname() == null || dto.getNickname().trim().isEmpty()) {
  91. throw new IllegalArgumentException("成员昵称不能为空");
  92. }
  93. if (dto.getGenerationLevel() == null || dto.getGenerationLevel().trim().isEmpty()) {
  94. throw new IllegalArgumentException("辈分等级不能为空");
  95. }
  96. User user = userMapper.selectById(userId);
  97. if (user == null) {
  98. throw new RuntimeException("用户不存在");
  99. }
  100. if (user.getFamilyId() == null) {
  101. throw new RuntimeException("用户未加入家庭,请先创建或加入家庭");
  102. }
  103. Long familyId = user.getFamilyId();
  104. GenerationLevel genLevel = GenerationLevel.fromValue(dto.getGenerationLevel());
  105. if (genLevel == null) {
  106. throw new IllegalArgumentException("无效的辈分等级: " + dto.getGenerationLevel());
  107. }
  108. // 计算辈分值(相对关联成员)
  109. FamilyMember relative = null;
  110. if (dto.getRelativeMemberId() != null) {
  111. relative = familyMemberMapper.selectById(dto.getRelativeMemberId());
  112. if (relative == null || !relative.getFamilyId().equals(familyId)) {
  113. throw new IllegalArgumentException("关联成员不存在");
  114. }
  115. }
  116. int generation = (relative != null ? relative.getGeneration() : 0) + genLevel.getOffset();
  117. boolean isSpouse = genLevel == GenerationLevel.PEER
  118. && "spouse".equals(dto.getPeerType());
  119. // 创建家庭成员记录
  120. FamilyMember member = new FamilyMember();
  121. member.setFamilyId(familyId);
  122. member.setNickname(dto.getNickname().trim());
  123. member.setPhone(dto.getPhone());
  124. member.setAvatar(dto.getAvatar());
  125. member.setGender(dto.getGender());
  126. if (dto.getBirthday() != null && !dto.getBirthday().isEmpty()) {
  127. try {
  128. java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
  129. member.setBirthday(sdf.parse(dto.getBirthday()));
  130. } catch (java.text.ParseException e) {
  131. throw new IllegalArgumentException("出生日期格式错误,应为yyyy-MM-dd");
  132. }
  133. }
  134. member.setBirthHour(dto.getBirthHour());
  135. member.setBirthWeight(dto.getBirthWeight());
  136. member.setBirthPlace(dto.getBirthPlace());
  137. member.setIsCesarean(dto.getIsCesarean());
  138. member.setGeneration(generation);
  139. member.setIsSpouse(isSpouse);
  140. member.setShowToFamily(1);
  141. member.setTotalPoints(0);
  142. member.setCreatedAt(new Date());
  143. member.setUpdatedAt(new Date());
  144. // 【重构】成员创建:同步创建 user 记录(无 openid = 不可登录)
  145. // 1) 若填写了手机号且已存在同手机号用户 → 复用该 user(绑定 userId)
  146. // 2) 若填写了手机号但不存在 → 创建无 openid 的 user,预留未来注册复用
  147. // 3) 未填写手机号 → 创建无 openid 的 user
  148. Long memberUserId = null;
  149. if (dto.getPhone() != null && !dto.getPhone().isEmpty()) {
  150. User matchedUser = userMapper.selectOne(
  151. new LambdaQueryWrapper<User>().eq(User::getPhone, dto.getPhone()));
  152. if (matchedUser != null) {
  153. memberUserId = matchedUser.getId();
  154. // 将匹配到的用户加入同一家庭(如果尚未加入)
  155. if (matchedUser.getFamilyId() == null) {
  156. matchedUser.setFamilyId(familyId);
  157. matchedUser.setUpdatedAt(new Date());
  158. userMapper.updateById(matchedUser);
  159. }
  160. } else {
  161. // 创建预留用户(无 openid,后续同手机号注册时复用)
  162. User newUser = new User();
  163. newUser.setOpenid("");
  164. newUser.setUnionid("");
  165. newUser.setRole("parent"); // 无 child 角色,统一 parent 兜底(实际不可登录)
  166. newUser.setNickname(dto.getNickname().trim());
  167. newUser.setPhone(dto.getPhone());
  168. newUser.setFamilyId(familyId);
  169. newUser.setPassword(""); // 初始密码为空,切换保护密码后续由用户设置
  170. newUser.setCreatedAt(new Date());
  171. newUser.setUpdatedAt(new Date());
  172. userMapper.insert(newUser);
  173. memberUserId = newUser.getId();
  174. }
  175. } else {
  176. // 未填手机号:创建无 openid 的 user(昵称必须非空)
  177. User newUser = new User();
  178. newUser.setOpenid("");
  179. newUser.setUnionid("");
  180. newUser.setRole("parent");
  181. newUser.setNickname(dto.getNickname().trim());
  182. newUser.setFamilyId(familyId);
  183. newUser.setPassword("");
  184. newUser.setCreatedAt(new Date());
  185. newUser.setUpdatedAt(new Date());
  186. userMapper.insert(newUser);
  187. memberUserId = newUser.getId();
  188. }
  189. member.setUserId(memberUserId);
  190. familyMemberMapper.insert(member);
  191. // 写入变更日志
  192. logMemberAction(member.getFamilyId(), member.getId(), "join", null, member.getNickname(), userId);
  193. // children 表已废除,无需同步。角色信息通过 computeEffectiveRole() 自动计算。
  194. // 若需要 child 专属初始化(如游戏数据),后续在 computeEffectiveRole() 返回 child 时处理。
  195. // 为新成员创建与所有现有成员的双向关系
  196. // 注意:第三个参数是「绝对辈分」而非相对偏移;锚点=关联成员(本次添加所参照的人),
  197. // spouse 只写在「新成员 ↔ 关联成员」之间,家庭内其他同辈一律 sibling。
  198. familyRelationshipService.createRelationsForNewMember(
  199. familyId, member.getId(), generation,
  200. genLevel == GenerationLevel.PEER ? dto.getPeerType() : null,
  201. relative != null ? relative.getId() : null);
  202. // 发放家庭人口券(POPULATION):发到家庭维度
  203. try {
  204. couponService.grantFamilyPopulationCoupons(familyId, member.getId());
  205. } catch (Exception e) {
  206. log.error("发放家庭人口券异常: memberId={}", member.getId(), e);
  207. }
  208. // 方案B:新成员加入时,继承家庭现有有效会员身份
  209. if (memberUserId != null) {
  210. membershipService.syncMembershipForNewMember(memberUserId, familyId);
  211. }
  212. return toFamilyMemberVO(member);
  213. }
  214. /**
  215. * 获取家庭成员列表(合并 children + family_members)
  216. */
  217. public List<FamilyMemberVO> listMembers(Long userId) {
  218. User user = userMapper.selectById(userId);
  219. if (user == null || user.getFamilyId() == null) {
  220. return new ArrayList<>();
  221. }
  222. return listMembersOfFamily(user.getFamilyId(), userId);
  223. }
  224. /**
  225. * 成员列表分页+搜索(SC-P-04 family.familyMembers.list 能力键,S-cfc-357)。
  226. * <p>返回分页结构 {@code {total, list}}:total = 关键字匹配后的成员总数,list = 当前页数据。
  227. * 无 keyword/page/pageSize 时等价于全量 {@link #listMembers(Long)}(兼容现状语义)。</p>
  228. *
  229. * @param userId 当前查看者(用于按本人家庭查询)
  230. * @param keyword 昵称/姓名过滤关键字(null/空白 = 不过滤)
  231. * @param page 页码(null/&lt;1 归一化为 1;非法值 0/负数由 Controller 校验拦截)
  232. * @param pageSize 每页数量(null/&lt;1 默认 20)
  233. * @return 分页结构 Map:{total: Integer, list: List&lt;FamilyMemberVO&gt;}
  234. */
  235. public Map<String, Object> listMembers(Long userId, String keyword, Integer page, Integer pageSize) {
  236. return paginateMembers(listMembers(userId), keyword, page, pageSize);
  237. }
  238. /**
  239. * 关键字过滤 + 分页(纯静态函数,Controller 在 mock 场景下也能复用)。
  240. * <p>过滤口径:昵称/name 包含关键字(trim 后,null 安全);分页口径:page 从 1 起,pageSize 缺省 20。</p>
  241. */
  242. public static Map<String, Object> paginateMembers(List<FamilyMemberVO> members, String keyword,
  243. Integer page, Integer pageSize) {
  244. Map<String, Object> result = new java.util.HashMap<>();
  245. List<FamilyMemberVO> filtered = new ArrayList<>();
  246. boolean hasKeyword = keyword != null && !keyword.trim().isEmpty();
  247. if (hasKeyword) {
  248. String kw = keyword.trim();
  249. for (FamilyMemberVO vo : members) {
  250. if ((vo.getNickname() != null && vo.getNickname().contains(kw))
  251. || (vo.getName() != null && vo.getName().contains(kw))) {
  252. filtered.add(vo);
  253. }
  254. }
  255. } else {
  256. filtered.addAll(members);
  257. }
  258. result.put("total", filtered.size());
  259. int p = (page == null || page < 1) ? 1 : page;
  260. int size = (pageSize == null || pageSize < 1) ? 20 : pageSize;
  261. int from = Math.min((p - 1) * size, filtered.size());
  262. int to = Math.min(from + size, filtered.size());
  263. result.put("list", new ArrayList<>(filtered.subList(from, to)));
  264. return result;
  265. }
  266. /**
  267. * 获取指定家庭的成员列表(B2-1 新增)。
  268. * <p>按 familyId 直接查询(成长规划师查看绑定家庭、管理端查看任意家庭时使用);
  269. * 调用方需先校验访问权(getEffectiveFamilyIds / 平台角色直通)。</p>
  270. * @param familyId 目标家庭
  271. * @param viewerUserId 当前查看者(关系标签/isSelf 视角计算用)
  272. */
  273. public List<FamilyMemberVO> listMembersOfFamily(Long familyId, Long viewerUserId) {
  274. if (familyId == null) {
  275. return new ArrayList<>();
  276. }
  277. List<FamilyMemberVO> result = new ArrayList<>();
  278. // 查询家庭创建者,用于逐成员判断其是否管理员(isAdmin 语义:该成员本人是否为家庭创建者)
  279. Family family = familyMapper.selectById(familyId);
  280. Long creatorId = (family != null) ? family.getCreatorId() : null;
  281. // 查询 family_members 表(排除回收箱成员)
  282. List<FamilyMember> familyMembers = familyMemberMapper.selectList(
  283. new LambdaQueryWrapper<FamilyMember>()
  284. .eq(FamilyMember::getFamilyId, familyId)
  285. .ne(FamilyMember::getStatus, "recycled"));
  286. // 兜底去重:同一 userId 多条记录只保留一条记录
  287. // 优先 status=active + userId 非空,其次 updated_at 最新
  288. // userId 为 null 的孤儿记录保持原样
  289. if (familyMembers != null && !familyMembers.isEmpty()) {
  290. Map<Long, List<FamilyMember>> userIdGroups = new java.util.HashMap<>();
  291. List<FamilyMember> orphans = new ArrayList<>();
  292. for (FamilyMember fm : familyMembers) {
  293. if (fm.getUserId() == null) {
  294. orphans.add(fm);
  295. } else {
  296. userIdGroups.computeIfAbsent(fm.getUserId(), k -> new ArrayList<>()).add(fm);
  297. }
  298. }
  299. List<FamilyMember> deduped = new ArrayList<>();
  300. deduped.addAll(orphans);
  301. for (List<FamilyMember> group : userIdGroups.values()) {
  302. if (group.size() == 1) {
  303. deduped.add(group.get(0));
  304. } else {
  305. // T24-C:确定性选"主成员",与 JwtInterceptor:177-182 的解析口径一致:
  306. // status='active' 最优先 → 其余状态其次 → recycled 最后;
  307. // 同级内 is_admin=1(主成员)优先;再以 id 最小兜底。
  308. // 旧实现用 .max() + 反向比较器(active 返回 -1、updated_at 用 b.compareTo(a)),
  309. // 实际选中"非 active / 最早 updated_at"行,与注释意图相反,导致 isSelf
  310. // 标在错误的重复行上(前端呈现"本人 + 本人所对应的成员"两个身份)。
  311. FamilyMember winner = group.stream()
  312. .min((a, b) -> {
  313. int aRank = statusRank(a.getStatus());
  314. int bRank = statusRank(b.getStatus());
  315. int statusCmp = Integer.compare(aRank, bRank);
  316. if (statusCmp != 0) return statusCmp;
  317. int aAdmin = a.getIsAdmin() != null ? a.getIsAdmin() : 0;
  318. int bAdmin = b.getIsAdmin() != null ? b.getIsAdmin() : 0;
  319. int adminCmp = Integer.compare(bAdmin, aAdmin);
  320. if (adminCmp != 0) return adminCmp;
  321. return Long.compare(a.getId(), b.getId());
  322. })
  323. .orElse(group.get(0));
  324. deduped.add(winner);
  325. }
  326. }
  327. familyMembers = deduped;
  328. }
  329. // 查找当前查看者在 family_members 中的记录(用于计算视角标签)
  330. FamilyMember viewerMember = null;
  331. for (FamilyMember fm : familyMembers) {
  332. if (viewerUserId.equals(fm.getUserId())) {
  333. viewerMember = fm;
  334. break;
  335. }
  336. }
  337. for (FamilyMember fm : familyMembers) {
  338. FamilyMemberVO vo = new FamilyMemberVO();
  339. vo.setId(fm.getId());
  340. vo.setSource("family_member");
  341. vo.setUserId(fm.getUserId());
  342. // isAdmin:优先读 family_members.is_admin 列;该成员为家庭创建者时兜底 true
  343. boolean memberIsAdmin = fm.getIsAdmin() != null && fm.getIsAdmin() == 1;
  344. boolean isCreator = creatorId != null && creatorId.equals(fm.getUserId());
  345. vo.setIsAdmin(memberIsAdmin || isCreator);
  346. vo.setNickname(resolveMemberNickname(fm));
  347. vo.setPhone(fm.getPhone());
  348. vo.setAvatar(fm.getAvatar());
  349. vo.setGender(fm.getGender());
  350. vo.setGeneration(fm.getGeneration());
  351. vo.setEffectiveRole(computeEffectiveRole(fm));
  352. vo.setRoleLabel(computeEffectiveRole(fm));
  353. vo.setTotalPoints(fm.getTotalPoints());
  354. vo.setShowToFamily(fm.getShowToFamily());
  355. if (fm.getBirthday() != null) {
  356. vo.setAge(calculateAge(fm.getBirthday()));
  357. vo.setBirthday(formatDate(fm.getBirthday()));
  358. }
  359. // 计算视角相关的关系标签
  360. if (viewerMember != null) {
  361. Integer genValue = null;
  362. String relType = null;
  363. if (familyRelationshipService != null && viewerMember.getId() != null) {
  364. List<FamilyRelationship> rels = familyRelationshipService.getRelationsForMember(viewerMember.getId());
  365. if (rels != null) {
  366. for (FamilyRelationship rel : rels) {
  367. if (rel.getToMemberId().equals(fm.getId())) {
  368. genValue = rel.getGenerationValue();
  369. relType = rel.getRelationType();
  370. break;
  371. }
  372. }
  373. }
  374. }
  375. if (genValue != null) {
  376. vo.setGenerationValue(genValue);
  377. }
  378. String relLabel = resolveRelativeLabel(viewerMember, fm, familyMembers, genValue, relType);
  379. vo.setRelativeLabel(relLabel);
  380. vo.setRelationship(relLabel);
  381. }
  382. // 补充字段
  383. vo.setIsSpouse(fm.getIsSpouse());
  384. vo.setTrustScore(fm.getTrustScore());
  385. vo.setIntimacyScore(fm.getIntimacyScore());
  386. vo.setCommunicationScore(fm.getCommunicationScore());
  387. vo.setIsSelf(viewerMember != null && viewerMember.getId().equals(fm.getId()));
  388. // 设置 memberType:userId 非空且关联 User 有 openid -> 'login';否则 -> 'local'
  389. if (fm.getUserId() != null) {
  390. User memberUser = userMapper.selectById(fm.getUserId());
  391. String openid = memberUser != null ? memberUser.getOpenid() : null;
  392. vo.setMemberType(openid != null && !openid.isEmpty() ? "login" : "local");
  393. } else {
  394. vo.setMemberType("local");
  395. }
  396. // 设置 isSwitchable:仅无 openid 的不可登录成员可被切换(可登录成员不允许切换视角)
  397. if (fm.getUserId() != null) {
  398. User memberUser = userMapper.selectById(fm.getUserId());
  399. String openid = memberUser != null ? memberUser.getOpenid() : null;
  400. vo.setIsSwitchable(openid == null || openid.isEmpty());
  401. } else {
  402. vo.setIsSwitchable(true);
  403. }
  404. vo.setLastInteractionAt(fm.getLastInteractionAt());
  405. vo.setStreakDays(fm.getStreakDays());
  406. // SC-P-04 family.familyMembers.list:在线状态(口径 = lastInteractionAt 最后互动时间)
  407. vo.setLastActiveAt(fm.getLastInteractionAt());
  408. vo.setOnline(fm.getLastInteractionAt() != null
  409. && (System.currentTimeMillis() - fm.getLastInteractionAt().getTime()) < ONLINE_WINDOW_MS);
  410. // 兼容旧前端字段
  411. vo.setMemberId(fm.getId());
  412. vo.setName(resolveMemberNickname(fm));
  413. result.add(vo);
  414. }
  415. // ── 合并 users 表同家庭的家庭主账号 ──
  416. // 家庭主账号在注册/创建家庭时只写入 users 表(family_id + role=parent),并不会同步到 family_members 表,
  417. // 因此在成员列表中需要额外合并,否则家庭主账号在该家庭中永远缺失(如 family 72 只显示家庭成员却少一位家庭主账号)。
  418. // 去重口径与 getVisibleMembers 一致:按 userId 去重,同一人若在 family_members 表已有记录则不再重复。
  419. java.util.Set<Long> familyMemberUserIds = new java.util.HashSet<>();
  420. for (FamilyMember fm : familyMembers) {
  421. if (fm.getUserId() != null) {
  422. familyMemberUserIds.add(fm.getUserId());
  423. }
  424. }
  425. List<User> parents = userMapper.selectList(new LambdaQueryWrapper<User>()
  426. .eq(User::getFamilyId, familyId)
  427. .eq(User::getRole, "parent"));
  428. for (User p : parents) {
  429. if (p.getId() == null || familyMemberUserIds.contains(p.getId())) {
  430. continue; // 已在 family_members 中,避免重复
  431. }
  432. FamilyMemberVO vo = new FamilyMemberVO();
  433. vo.setId(p.getId());
  434. vo.setMemberId(p.getId());
  435. vo.setSource("parent");
  436. vo.setMemberType("parent");
  437. vo.setUserId(p.getId());
  438. vo.setNickname(p.getNickname());
  439. vo.setName(p.getNickname());
  440. vo.setAvatar(p.getAvatar());
  441. vo.setPhone(p.getPhone());
  442. vo.setGender(p.getGender());
  443. vo.setEffectiveRole("parent");
  444. vo.setRoleLabel(p.getFamilyRole() != null ? p.getFamilyRole() : "本人");
  445. if (p.getBirthday() != null) {
  446. vo.setAge(calculateAge(p.getBirthday()));
  447. }
  448. vo.setGeneration(0);
  449. // 家庭主账号:仅当其为家庭创建者时视为管理员(users 表无 is_admin 列)
  450. vo.setIsAdmin(creatorId != null && creatorId.equals(p.getId()));
  451. vo.setIsSelf(p.getId().equals(viewerUserId));
  452. // 家庭主账号均为可登录用户,不允许切换视角(与成员段"仅不可登录可切换"一致)
  453. vo.setIsSwitchable(false); // 含 source='parent' 段
  454. vo.setShowToFamily(p.getShowToFamily() != null ? p.getShowToFamily() : 1);
  455. vo.setIsSpouse(false);
  456. vo.setTotalPoints(p.getTotalPoints());
  457. // SC-P-04 family.familyMembers.list:在线状态(users 表无 lastInteractionAt,默认离线)
  458. vo.setLastActiveAt(null);
  459. vo.setOnline(false);
  460. result.add(vo);
  461. }
  462. return result;
  463. }
  464. /**
  465. * 切换到家庭成员视图
  466. * <p>SC-P-03 双角色切换(TC-P-15/TC-P-15-E/TC-P-15-P):
  467. * - 正常流:家长切不可登录孩子视角 → 返回 SwitchMemberVO;
  468. * - 异常流(参数/业务规则):切到自己、切可登录成员 → IllegalArgumentException(400);
  469. * - 权限流(双角色铁律):孩子端切回家长、非法/跨家庭 memberId → AccessDeniedException(403)。
  470. * 异常统一由 GlobalExceptionHandler 映射错误码,controller 不再捕获转 500。
  471. */
  472. public SwitchMemberVO switchToMember(Long userId, Long memberId) {
  473. User user = userMapper.selectById(userId);
  474. if (user == null || user.getFamilyId() == null) {
  475. throw new IllegalArgumentException("用户未加入家庭");
  476. }
  477. // 从 family_members 查找
  478. FamilyMember member = familyMemberMapper.selectById(memberId);
  479. if (member != null && member.getFamilyId().equals(user.getFamilyId())) {
  480. // 不能切换到自己
  481. if (member.getUserId() != null && member.getUserId().equals(userId)) {
  482. throw new IllegalArgumentException("不能切换到自己");
  483. }
  484. // 仅不可登录成员可被切换:可登录成员(有 openid,可通过微信登录)不允许切换视角
  485. User memberUser = member.getUserId() != null ? userMapper.selectById(member.getUserId()) : null;
  486. String openid = memberUser != null ? memberUser.getOpenid() : null;
  487. boolean canLogin = openid != null && !openid.isEmpty();
  488. if (canLogin) {
  489. throw new IllegalArgumentException("该成员可通过微信登录,不能切换为TA的身份");
  490. }
  491. String effectiveRole = computeEffectiveRole(member);
  492. // 直接登录的成员端不能切换到本人端
  493. if ("child".equals(user.getRole()) && "parent".equals(effectiveRole)) {
  494. throw new AccessDeniedException("家庭成员账号不能切换到本人视角");
  495. }
  496. // SC-P-73 仅本家庭孩子可选:目标必须处于孩子上下文(child),
  497. // 本家庭成年成员/长辈(effectiveRole=parent)不得被当作孩子上下文选中
  498. if (!"child".equals(effectiveRole)) {
  499. throw new IllegalArgumentException("仅本家庭孩子可作为切换目标");
  500. }
  501. SwitchMemberVO vo = new SwitchMemberVO();
  502. vo.setMemberId(member.getId());
  503. vo.setSource("family_member");
  504. vo.setEffectiveRole(effectiveRole);
  505. vo.setNickname(resolveMemberNickname(member));
  506. vo.setIsSwitchable(true);
  507. return vo;
  508. }
  509. // 兼容 source='parent':无 family_members 记录的 users 表家庭主账号成员(memberId 即 userId)
  510. Long familyId = user.getFamilyId();
  511. User targetParent = userMapper.selectById(memberId);
  512. if (targetParent != null && familyId.equals(targetParent.getFamilyId())) {
  513. // 不能切换到自己
  514. if (targetParent.getId().equals(userId)) {
  515. throw new IllegalArgumentException("不能切换到自己");
  516. }
  517. // 直接登录的成员端不能切换到本人端(双角色铁律:孩子端不能切回家长)
  518. if ("child".equals(user.getRole())) {
  519. throw new AccessDeniedException("家庭成员账号不能切换到本人视角");
  520. }
  521. // source='parent' 的家庭主账号均为可登录用户,不允许切换视角
  522. throw new IllegalArgumentException("该成员可通过微信登录,不能切换为TA的身份");
  523. }
  524. // 非法/跨家庭 memberId:权限拒绝(不泄露他人家庭信息)
  525. throw new AccessDeniedException("成员不存在或不属于您的家庭");
  526. }
  527. /**
  528. * 踢出家庭成员(管理员操作)
  529. * 规则:
  530. * - 仅管理员可踢出
  531. * - 被踢成员 CF 值(统一账本 cf_balance,成员维度)随成员带走;family_members.system_points 为只读历史字段
  532. * - 收回该家庭发放给该成员的人口券(POPULATION)
  533. * - 微信登录用户:迁移资产到其初始家庭(无则创建新家庭)
  534. * - 非微信登录用户:进入回收箱(status=recycled),资产保留,可后续回收
  535. */
  536. @Transactional(rollbackFor = Exception.class)
  537. public void kickMember(Long userId, Long memberId) {
  538. User operator = userMapper.selectById(userId);
  539. if (operator == null || operator.getFamilyId() == null) {
  540. throw new RuntimeException("用户未加入家庭");
  541. }
  542. Family family = familyMapper.selectById(operator.getFamilyId());
  543. if (family == null) {
  544. throw new RuntimeException("家庭不存在");
  545. }
  546. // 仅管理员可踢出
  547. if (!Long.valueOf(userId).equals(family.getCreatorId())) {
  548. throw new RuntimeException("只有家庭管理员才能踢出成员");
  549. }
  550. Long familyId = operator.getFamilyId();
  551. // 从 family_members 查找
  552. FamilyMember member = familyMemberMapper.selectById(memberId);
  553. String memberNickname = null;
  554. if (member != null && familyId.equals(member.getFamilyId())) {
  555. // 不能踢出家庭创建者
  556. if (member.getUserId() != null && Long.valueOf(member.getUserId()).equals(family.getCreatorId())) {
  557. throw new RuntimeException("不能踢出家庭创建者,请先转让管理员权限");
  558. }
  559. memberNickname = member.getNickname();
  560. } else {
  561. // 兼容 source='parent':无 family_members 记录的 users 表家庭主账号成员(memberId 即 userId)
  562. User targetUser = userMapper.selectById(memberId);
  563. member = null;
  564. if (targetUser != null && familyId.equals(targetUser.getFamilyId())) {
  565. // 不能踢出家庭创建者
  566. if (targetUser.getId().equals(family.getCreatorId())) {
  567. throw new RuntimeException("不能踢出家庭创建者,请先转让管理员权限");
  568. }
  569. memberNickname = targetUser.getNickname();
  570. } else {
  571. throw new RuntimeException("成员不存在");
  572. }
  573. }
  574. Long oldFamilyId = familyId;
  575. Long targetUserId = (member != null) ? member.getUserId() : memberId;
  576. Long newFamilyId = null;
  577. // 收回该家庭发放给该成员的人口券
  578. try {
  579. couponService.revokeFamilyPopulationCoupons(oldFamilyId, memberId);
  580. } catch (Exception e) {
  581. log.warn("收回人口券异常: familyId={}, memberId={}", oldFamilyId, memberId, e);
  582. }
  583. // 清理关系记录(source='parent' 的 users 表成员无关系记录,跳过)
  584. if (member != null) {
  585. familyRelationshipService.deleteRelationsForMember(memberId);
  586. }
  587. if (targetUserId != null) {
  588. User targetUser = userMapper.selectById(targetUserId);
  589. if (targetUser != null && oldFamilyId.equals(targetUser.getFamilyId())) {
  590. // FIX S-cfc-179:被踢用户离开原家庭前,先按个人维度重算家庭派生会员缓存
  591. // (仅清除 FAMILY/BASIC/PREMIUM 家庭派生等级,保留 LIFETIME/PROVIDER 独立身份),
  592. // 与下方唯一的 userMapper.updateById 一并持久化,保证主流程只产生一次用户更新
  593. resetStaleFamilyDerivedMemberCache(targetUser);
  594. boolean isWechatUser = isWechatUser(targetUser);
  595. if (isWechatUser) {
  596. // 微信用户:迁移资产到初始家庭,CF 带走
  597. Long ownFamilyId = findOwnFamilyId(targetUserId);
  598. if (ownFamilyId == null) {
  599. ownFamilyId = createFamilyForUser(targetUser);
  600. }
  601. if (member != null) {
  602. migrateMemberAssets(member, oldFamilyId, ownFamilyId);
  603. member.setFamilyId(ownFamilyId);
  604. member.setStatus("active");
  605. member.setUpdatedAt(new Date());
  606. familyMemberMapper.updateById(member);
  607. }
  608. newFamilyId = ownFamilyId;
  609. targetUser.setFamilyId(ownFamilyId);
  610. targetUser.setUpdatedAt(new Date());
  611. userMapper.updateById(targetUser);
  612. } else {
  613. // 非微信用户:解除家庭关联,资产保留在原家庭记录上
  614. if (member != null) {
  615. member.setStatus("recycled");
  616. member.setUpdatedAt(new Date());
  617. familyMemberMapper.updateById(member);
  618. }
  619. targetUser.setFamilyId(null);
  620. targetUser.setUpdatedAt(new Date());
  621. userMapper.updateById(targetUser);
  622. }
  623. }
  624. } else {
  625. // 无关联用户(纯手动添加的成员):直接删除记录
  626. familyMemberMapper.deleteById(memberId);
  627. }
  628. logMemberAction(oldFamilyId, memberId, "kick", memberNickname, null, userId);
  629. // 方案B:成员被踢出后,重新核算原家庭会员身份
  630. membershipService.reconcileFamilyMembership(oldFamilyId);
  631. // 方案B补充:剥离被踢成员本人从原家庭继承的会员身份(reconcileFamilyMembership 只处理仍留在原家庭的成员,已迁出者不在降级范围)
  632. if (targetUserId != null) {
  633. membershipService.reconcileLeavingMemberMembership(targetUserId, oldFamilyId, newFamilyId);
  634. }
  635. // T28:成员被移出家庭后,其食材指数不再计入原家庭总览(AC-10)
  636. // 只 warn 不抛出,避免影响踢人主流程
  637. refreshFoodOverviewQuietly(oldFamilyId);
  638. if (newFamilyId != null && !newFamilyId.equals(oldFamilyId)) {
  639. refreshFoodOverviewQuietly(newFamilyId);
  640. }
  641. }
  642. /**
  643. * 主动退出家庭(微信登录用户)
  644. * 规则:
  645. * - 家庭创建者禁止退出,需先转让管理员
  646. * - CF 值(统一账本 cf_balance,成员维度)随成员带离原家庭;family_members.system_points 仅清零只读历史残留值
  647. * - 迁移资产到初始家庭(无则创建新家庭)
  648. */
  649. @Transactional(rollbackFor = Exception.class)
  650. public void leaveFamily(Long userId) {
  651. User user = userMapper.selectById(userId);
  652. if (user == null || user.getFamilyId() == null) {
  653. throw new RuntimeException("用户未加入家庭");
  654. }
  655. Long oldFamilyId = user.getFamilyId();
  656. Family family = familyMapper.selectById(oldFamilyId);
  657. if (family == null) {
  658. throw new RuntimeException("家庭不存在");
  659. }
  660. // 家庭创建者禁止退出
  661. if (Long.valueOf(userId).equals(family.getCreatorId())) {
  662. throw new RuntimeException("您是家庭创建者,请先转让管理员权限后再退出");
  663. }
  664. // 非微信用户禁止自主退出
  665. if (!isWechatUser(user)) {
  666. throw new RuntimeException("非微信登录用户不能自主退出家庭");
  667. }
  668. // 查找该用户在 family_members 中的记录
  669. FamilyMember member = familyMemberMapper.selectOne(
  670. new LambdaQueryWrapper<FamilyMember>()
  671. .eq(FamilyMember::getFamilyId, oldFamilyId)
  672. .eq(FamilyMember::getUserId, userId)
  673. .last("LIMIT 1"));
  674. if (member == null) {
  675. throw new RuntimeException("未找到该用户的家庭成员记录");
  676. }
  677. // family_members.system_points 为只读历史字段:清零残留值(CF 值在统一账本 cf_balance,成员维度,随成员走)
  678. member.setSystemPoints(0);
  679. member.setUpdatedAt(new Date());
  680. // 清理关系记录
  681. familyRelationshipService.deleteRelationsForMember(member.getId());
  682. // 迁移资产到初始家庭
  683. Long ownFamilyId = findOwnFamilyId(userId);
  684. if (ownFamilyId == null) {
  685. ownFamilyId = createFamilyForUser(user);
  686. }
  687. migrateMemberAssets(member, oldFamilyId, ownFamilyId);
  688. member.setFamilyId(ownFamilyId);
  689. member.setStatus("active");
  690. familyMemberMapper.updateById(member);
  691. // FIX S-cfc-179:退出用户离开原家庭前,先按个人维度重算家庭派生会员缓存
  692. // (仅清除 FAMILY/BASIC/PREMIUM 家庭派生等级,保留 LIFETIME/PROVIDER 独立身份),
  693. // 与下方唯一的 userMapper.updateById 一并持久化,保证主流程只产生一次用户更新
  694. resetStaleFamilyDerivedMemberCache(user);
  695. user.setFamilyId(ownFamilyId);
  696. user.setUpdatedAt(new Date());
  697. userMapper.updateById(user);
  698. // 方案B:成员离开后,重新核算原家庭会员身份(成员离开不影响新家庭,新家庭通常是新建的无会员)
  699. membershipService.reconcileFamilyMembership(oldFamilyId);
  700. // 方案B补充:剥离退出成员本人从原家庭继承的会员身份(reconcileFamilyMembership 只处理仍留在原家庭的成员)
  701. membershipService.reconcileLeavingMemberMembership(userId, oldFamilyId, ownFamilyId);
  702. logMemberAction(oldFamilyId, member.getId(), "leave", member.getNickname(), null, userId);
  703. // T28:成员退出后,其食材指数不再计入原家庭总览(AC-10)
  704. // 只 warn 不抛出,避免影响退出主流程
  705. refreshFoodOverviewQuietly(oldFamilyId);
  706. if (ownFamilyId != null && !ownFamilyId.equals(oldFamilyId)) {
  707. refreshFoodOverviewQuietly(ownFamilyId);
  708. }
  709. }
  710. /**
  711. * T28 辅助:安静地重算某家庭食材总览(失败只 warn,不影响调用方主流程)。
  712. */
  713. private void refreshFoodOverviewQuietly(Long familyId) {
  714. try {
  715. if (familyId == null) return;
  716. familyFoodOverviewService.recalculate(familyId);
  717. } catch (Exception e) {
  718. log.warn("家庭食材总览重算失败 familyId={}: {}", familyId, e.getMessage());
  719. }
  720. }
  721. /**
  722. * FIX S-cfc-179:被移出家庭的用户按「个人维度」重算会员缓存(纯内存变更,不落库)。
  723. *
  724. * <p>仅清除源自家庭会员的缓存(等级 + 到期时间)——家庭可授予等级(FAMILY/BASIC/PREMIUM,
  725. * 由 {@code syncMembershipToFamilyMembers} 同步给全家、只升不降)在被移出家庭后若无独立更高等级
  726. * 应恢复 FREE;更高等级独立个人会员(LIFETIME)与独立角色(PROVIDER)保留,不被误清。</p>
  727. *
  728. * <p>注意:此方法<b>不</b>调用 {@code userMapper.updateById}——调用方在既有的一次 {@code updateById}
  729. * 中一并持久化(保证 kick/leave 主流程只产生一次用户更新,契约单测以 {@code verify(times(1))} 锁定)。</p>
  730. *
  731. * <p>不依赖 {@code MembershipService}(避免 mock 场景下默认值干扰),直接按等级代码判定,
  732. * 与 {@code MembershipService.getMemberLevel} 的语义一致(结果契约由契约单测锁定)。</p>
  733. *
  734. * @param targetUser 被移出家庭的用户(调用方随后会 updateById 持久化)
  735. */
  736. private void resetStaleFamilyDerivedMemberCache(User targetUser) {
  737. if (targetUser == null || targetUser.getMemberLevel() == null) {
  738. return;
  739. }
  740. String level = targetUser.getMemberLevel();
  741. // 家庭可授予等级(家庭会员同步来源):被移出后无独立更高等级 → 恢复 FREE,并清空到期时间
  742. // LIFETIME(个人终身权益)/ PROVIDER(独立服务商角色)为独立身份,保留不清
  743. if ("FAMILY".equals(level) || "BASIC".equals(level) || "PREMIUM".equals(level)) {
  744. targetUser.setMemberLevel("FREE");
  745. targetUser.setMemberExpireTime(null);
  746. targetUser.setUpdatedAt(new Date());
  747. log.info("被移出家庭成员会员缓存已重置为 FREE: userId={}, fromLevel={}", targetUser.getId(), level);
  748. }
  749. }
  750. /**
  751. * 从回收箱回收成员(管理员操作):将回收箱中的非微信用户重新加入指定家庭
  752. */
  753. @Transactional(rollbackFor = Exception.class)
  754. public void recycleMember(Long operatorUserId, Long memberId, Long targetFamilyId) {
  755. User operator = userMapper.selectById(operatorUserId);
  756. if (operator == null || operator.getFamilyId() == null) {
  757. throw new RuntimeException("用户未加入家庭");
  758. }
  759. Family targetFamily = familyMapper.selectById(targetFamilyId);
  760. if (targetFamily == null) {
  761. throw new RuntimeException("目标家庭不存在");
  762. }
  763. // 仅管理员可回收
  764. if (!Long.valueOf(operatorUserId).equals(targetFamily.getCreatorId())) {
  765. throw new RuntimeException("只有目标家庭管理员才能回收成员");
  766. }
  767. FamilyMember member = familyMemberMapper.selectById(memberId);
  768. if (member == null) {
  769. throw new RuntimeException("成员不存在");
  770. }
  771. if (!"recycled".equals(member.getStatus())) {
  772. throw new RuntimeException("该成员不在回收箱中");
  773. }
  774. // 迁移资产到目标家庭
  775. Long oldFamilyId = member.getFamilyId();
  776. migrateMemberAssets(member, oldFamilyId, targetFamilyId);
  777. member.setFamilyId(targetFamilyId);
  778. member.setStatus("active");
  779. member.setUpdatedAt(new Date());
  780. familyMemberMapper.updateById(member);
  781. // 关联用户重新归属目标家庭
  782. if (member.getUserId() != null) {
  783. User targetUser = userMapper.selectById(member.getUserId());
  784. if (targetUser != null) {
  785. targetUser.setFamilyId(targetFamilyId);
  786. targetUser.setUpdatedAt(new Date());
  787. userMapper.updateById(targetUser);
  788. }
  789. }
  790. logMemberAction(targetFamilyId, memberId, "recycle", null, member.getNickname(), operatorUserId);
  791. // 方案B:回收成员后,重新核算目标家庭会员身份
  792. membershipService.reconcileFamilyMembership(targetFamilyId);
  793. }
  794. /**
  795. * 切换成员到目标家庭(被邀请走/加入新家庭场景)
  796. * 规则:
  797. * - 非微信用户禁止自主切换
  798. * - 家庭创建者禁止切换(需先转让管理员)
  799. * - CF 值(统一账本 cf_balance,成员维度)随成员带离原家庭;family_members.system_points 仅清零只读历史残留值
  800. * - 迁移资产到目标家庭
  801. */
  802. @Transactional(rollbackFor = Exception.class)
  803. public void switchMemberToFamily(Long userId, Long targetFamilyId) {
  804. User user = userMapper.selectById(userId);
  805. if (user == null || user.getFamilyId() == null) {
  806. throw new RuntimeException("用户未加入家庭");
  807. }
  808. Long oldFamilyId = user.getFamilyId();
  809. if (oldFamilyId.equals(targetFamilyId)) {
  810. return;
  811. }
  812. Family oldFamily = familyMapper.selectById(oldFamilyId);
  813. if (oldFamily != null && Long.valueOf(userId).equals(oldFamily.getCreatorId())) {
  814. // 创建者离开须先转让管理员(防原家庭无主);但原家庭仅剩创建者一人时,
  815. // 离开后家庭无人,不存在无主问题,无需转让,直接允许切换
  816. Long otherMemberCount = familyMemberMapper.selectCount(
  817. new LambdaQueryWrapper<FamilyMember>()
  818. .eq(FamilyMember::getFamilyId, oldFamilyId)
  819. .ne(FamilyMember::getUserId, userId)
  820. .ne(FamilyMember::getStatus, "recycled"));
  821. if (otherMemberCount != null && otherMemberCount > 0) {
  822. throw new RuntimeException("您是家庭创建者,请先转让管理员权限后再切换家庭");
  823. }
  824. }
  825. if (!isWechatUser(user)) {
  826. throw new RuntimeException("非微信登录用户不能自主切换家庭");
  827. }
  828. FamilyMember member = familyMemberMapper.selectOne(
  829. new LambdaQueryWrapper<FamilyMember>()
  830. .eq(FamilyMember::getFamilyId, oldFamilyId)
  831. .eq(FamilyMember::getUserId, userId)
  832. .last("LIMIT 1"));
  833. if (member == null) {
  834. // 兼容历史孤儿数据:users.family_id 指向旧家庭但 family_members 无该用户成员记录
  835. // (早期创建家庭路径漏建创建者成员记录)。旧家庭无能量值资产(按 member_id 关联必然无),
  836. // 健康报告按 user_id 关联可能残留,先尝试迁移;再在目标家庭补建成员记录,后续流程自然兼容。
  837. try {
  838. List<HealthReport> orphanReports = healthReportMapper.selectList(
  839. new LambdaQueryWrapper<HealthReport>()
  840. .eq(HealthReport::getFamilyId, oldFamilyId)
  841. .and(w -> w.eq(HealthReport::getUserId, userId)
  842. .or().eq(HealthReport::getSubjectId, userId)));
  843. for (HealthReport r : orphanReports) {
  844. r.setFamilyId(targetFamilyId);
  845. healthReportMapper.updateById(r);
  846. }
  847. } catch (Exception e) {
  848. log.warn("孤儿成员健康报告迁移异常: userId={}, oldFamilyId={}", userId, oldFamilyId, e);
  849. }
  850. FamilyMember newMember = new FamilyMember();
  851. newMember.setFamilyId(targetFamilyId);
  852. newMember.setUserId(userId);
  853. newMember.setNickname((user.getNickname() != null && !user.getNickname().isEmpty())
  854. ? user.getNickname() : ("用户" + userId));
  855. newMember.setPhone(user.getPhone());
  856. newMember.setAvatar(user.getAvatar());
  857. newMember.setGender(user.getGender());
  858. newMember.setGeneration(0);
  859. newMember.setTotalPoints(0);
  860. newMember.setSystemPoints(0);
  861. newMember.setStatus("active");
  862. newMember.setCreatedAt(new Date());
  863. newMember.setUpdatedAt(new Date());
  864. familyMemberMapper.insert(newMember);
  865. member = newMember;
  866. log.warn("成员记录缺失,已在目标家庭补建: userId={}, oldFamilyId={}, targetFamilyId={}, memberId={}",
  867. userId, oldFamilyId, targetFamilyId, member.getId());
  868. }
  869. // family_members.system_points 为只读历史字段:清零残留值(CF 值在统一账本 cf_balance,成员维度,随成员走)
  870. member.setSystemPoints(0);
  871. member.setUpdatedAt(new Date());
  872. // 清理关系记录
  873. familyRelationshipService.deleteRelationsForMember(member.getId());
  874. // 迁移资产到目标家庭
  875. migrateMemberAssets(member, oldFamilyId, targetFamilyId);
  876. member.setFamilyId(targetFamilyId);
  877. member.setStatus("active");
  878. familyMemberMapper.updateById(member);
  879. // 原家庭是付费会员时,将会员权益合并到邀请人家庭
  880. try {
  881. membershipService.mergeMembershipToTargetFamily(oldFamilyId, targetFamilyId);
  882. } catch (Exception e) {
  883. log.warn("合并会员权益异常: oldFamilyId={}, targetFamilyId={}", oldFamilyId, targetFamilyId, e);
  884. }
  885. user.setFamilyId(targetFamilyId);
  886. user.setUpdatedAt(new Date());
  887. userMapper.updateById(user);
  888. // 方案B:切换家庭后,重新核算新旧家庭的会员身份
  889. membershipService.reconcileFamilyMembership(targetFamilyId);
  890. membershipService.reconcileFamilyMembership(oldFamilyId);
  891. // 方案B补充:剥离切换成员本人从原家庭继承的会员身份(reconcileFamilyMembership 只处理仍留在原家庭的成员)
  892. membershipService.reconcileLeavingMemberMembership(userId, oldFamilyId, targetFamilyId);
  893. // T28补充:切换家庭后刷新新旧家庭食材总览(该成员指数计入目标家庭、不再计入原家庭)
  894. refreshFoodOverviewQuietly(oldFamilyId);
  895. refreshFoodOverviewQuietly(targetFamilyId);
  896. logMemberAction(oldFamilyId, member.getId(), "switch", member.getNickname(), null, userId);
  897. }
  898. /**
  899. * 迁移成员资产到目标家庭:
  900. * - five_dimension_scores(能量值):改 family_id
  901. * - health_reports(健康报告):改 family_id
  902. * - dan_assessment_results(测评):以 familyMemberId 关联,改 family_members.family_id 后自动跟随,无需迁移
  903. * - family_member_attributes(属性):以 memberId 关联,自动跟随
  904. * - family_relationships(关系):删旧建新(新家庭关系需重新计算)
  905. * - tasks(任务):按 family_member_id / executor_id 迁移到目标家庭
  906. */
  907. private void migrateMemberAssets(FamilyMember member, Long oldFamilyId, Long targetFamilyId) {
  908. if (oldFamilyId.equals(targetFamilyId)) {
  909. return;
  910. }
  911. Long memberId = member.getId();
  912. // 能量值
  913. try {
  914. List<FiveDimensionScore> scores = fiveDimensionScoreMapper.selectList(
  915. new LambdaQueryWrapper<FiveDimensionScore>()
  916. .eq(FiveDimensionScore::getFamilyId, oldFamilyId)
  917. .eq(FiveDimensionScore::getMemberId, memberId));
  918. for (FiveDimensionScore s : scores) {
  919. s.setFamilyId(targetFamilyId);
  920. fiveDimensionScoreMapper.updateById(s);
  921. }
  922. } catch (Exception e) {
  923. log.warn("迁移能量值异常: memberId={}", memberId, e);
  924. }
  925. // 健康报告(A方案:按 subject_id=memberId 关联迁移,members.id 不变则报告自动跟随;
  926. // 兼容历史 subject_id=users.id 的报告一并迁移,保持 family_id 与成员所在家庭一致)
  927. try {
  928. List<HealthReport> reports = healthReportMapper.selectList(
  929. new LambdaQueryWrapper<HealthReport>()
  930. .eq(HealthReport::getFamilyId, oldFamilyId)
  931. .and(w -> w.eq(HealthReport::getSubjectId, memberId)
  932. .or(w2 -> w2.isNull(HealthReport::getSubjectId)
  933. .eq(HealthReport::getUserId, member.getUserId()))));
  934. for (HealthReport r : reports) {
  935. r.setFamilyId(targetFamilyId);
  936. healthReportMapper.updateById(r);
  937. }
  938. } catch (Exception e) {
  939. log.warn("迁移健康报告异常: memberId={}", memberId, e);
  940. }
  941. // 任务(育儿/健康任务):随成员切换到目标家庭(按 family_member_id 或 executor_id 匹配,
  942. // 兼容 child 任务(executor=成员卡id)与 parent 任务(executor=用户id)两种口径)
  943. try {
  944. List<Task> memberTasks = taskMapper.selectList(
  945. new LambdaQueryWrapper<Task>()
  946. .eq(Task::getFamilyId, oldFamilyId)
  947. .and(w -> w.eq(Task::getFamilyMemberId, memberId)
  948. .or().eq(Task::getExecutorId, memberId)
  949. .or().eq(Task::getExecutorId, member.getUserId())));
  950. int moved = 0;
  951. for (Task t : memberTasks) {
  952. t.setFamilyId(targetFamilyId);
  953. moved += taskMapper.updateById(t);
  954. }
  955. if (moved > 0) {
  956. log.info("切换家庭任务迁移: memberId={}, oldFamilyId={}, targetFamilyId={}, tasks={}",
  957. memberId, oldFamilyId, targetFamilyId, moved);
  958. }
  959. } catch (Exception e) {
  960. log.warn("迁移任务异常: memberId={}", memberId, e);
  961. }
  962. }
  963. /**
  964. * 判断用户是否为微信登录用户(openid 为真实微信 openid,而非 "phone:" 前缀)
  965. */
  966. private boolean isWechatUser(User user) {
  967. if (user == null || user.getOpenid() == null) {
  968. return false;
  969. }
  970. return !user.getOpenid().startsWith("phone:");
  971. }
  972. /**
  973. * 为用户创建新家庭(不含成员记录——调用方随后会迁移原 family_members 记录过来,避免重复)
  974. */
  975. private Long createFamilyForUser(User user) {
  976. Family family = new Family();
  977. family.setName(FamilyNamingSupport.buildFamilyName(user));
  978. family.setInviteCode(generateInviteCode());
  979. family.setCreatorId(user.getId());
  980. family.setCreatedAt(new Date());
  981. family.setUpdatedAt(new Date());
  982. familyMapper.insert(family);
  983. return family.getId();
  984. }
  985. private String generateInviteCode() {
  986. String chars = "ABCDEFGHJKLMNPQRSTUVWXYZ23456789";
  987. StringBuilder sb = new StringBuilder();
  988. java.util.Random random = new java.util.Random();
  989. for (int i = 0; i < 6; i++) {
  990. sb.append(chars.charAt(random.nextInt(chars.length())));
  991. }
  992. return sb.toString();
  993. }
  994. /**
  995. * 查找用户自己创建的家庭ID(families.creator_id = userId),不存在返回 null
  996. */
  997. private Long findOwnFamilyId(Long userId) {
  998. try {
  999. Family own = familyMapper.selectOne(
  1000. new LambdaQueryWrapper<Family>().eq(Family::getCreatorId, userId).last("LIMIT 1"));
  1001. return own != null ? own.getId() : null;
  1002. } catch (Exception e) {
  1003. log.warn("查找用户创建的家庭异常: userId={}", userId, e);
  1004. return null;
  1005. }
  1006. }
  1007. /**
  1008. * 判断成员是否可编辑
  1009. * 规则:有关联 userId 或有 phone 且 phone 能匹配到 User 的成员不可编辑
  1010. */
  1011. public boolean isEditable(Long memberId) {
  1012. FamilyMember member = familyMemberMapper.selectById(memberId);
  1013. if (member == null) return false;
  1014. if (member.getUserId() != null) return false;
  1015. if (member.getPhone() != null && !member.getPhone().isEmpty()) {
  1016. User linked = userMapper.selectOne(
  1017. new LambdaQueryWrapper<User>().eq(User::getPhone, member.getPhone()));
  1018. if (linked != null) return false;
  1019. }
  1020. return true;
  1021. }
  1022. /**
  1023. * 更新成员信息:管理员可编辑所有成员(含关联账号的),普通用户仅可编辑不可登录成员
  1024. */
  1025. @Transactional(rollbackFor = Exception.class)
  1026. public FamilyMemberVO updateMember(Long userId, Long memberId, AddFamilyMemberDTO dto) {
  1027. User user = userMapper.selectById(userId);
  1028. if (user == null || user.getFamilyId() == null) {
  1029. throw new RuntimeException("用户未加入家庭");
  1030. }
  1031. FamilyMember member = familyMemberMapper.selectById(memberId);
  1032. if (member != null && !member.getFamilyId().equals(user.getFamilyId())) {
  1033. throw new RuntimeException("成员不存在或不属于您的家庭");
  1034. }
  1035. // 家庭主账号(users 表成员)在 family_members 表无记录,走家庭主账号更新分支
  1036. if (member == null) {
  1037. return updateParentMember(user, memberId, dto);
  1038. }
  1039. // 检查编辑权限:管理员(family_members.is_admin=1 或家庭创建者)可编辑所有成员;
  1040. // 普通用户只能编辑无关联账号的成员
  1041. boolean isAdmin = isFamilyAdminOperator(userId, user.getFamilyId());
  1042. if (!isAdmin && !isEditable(memberId)) {
  1043. throw new RuntimeException("该成员关联了登录账号,不可编辑");
  1044. }
  1045. // 管理员设置(多管理员):仅管理员可操作;取消管理员时家庭至少保留一名
  1046. if (dto.getIsAdmin() != null) {
  1047. if (!isAdmin) {
  1048. throw new RuntimeException("仅家庭管理员可设置管理员");
  1049. }
  1050. int newAdminVal = dto.getIsAdmin() == 1 ? 1 : 0;
  1051. boolean targetIsAdmin = member.getIsAdmin() != null && member.getIsAdmin() == 1;
  1052. if (newAdminVal == 0 && targetIsAdmin) {
  1053. Long adminCount = familyMemberMapper.selectCount(new LambdaQueryWrapper<FamilyMember>()
  1054. .eq(FamilyMember::getFamilyId, user.getFamilyId())
  1055. .eq(FamilyMember::getIsAdmin, 1));
  1056. if (adminCount != null && adminCount <= 1) {
  1057. throw new RuntimeException("家庭至少需要保留一名管理员");
  1058. }
  1059. }
  1060. member.setIsAdmin(newAdminVal);
  1061. }
  1062. String oldNickname = member.getNickname();
  1063. if (dto.getNickname() != null && !dto.getNickname().trim().isEmpty()) {
  1064. member.setNickname(dto.getNickname().trim());
  1065. }
  1066. if (dto.getPhone() != null) {
  1067. member.setPhone(dto.getPhone());
  1068. }
  1069. if (dto.getAvatar() != null) {
  1070. member.setAvatar(dto.getAvatar());
  1071. }
  1072. if (dto.getGender() != null) {
  1073. member.setGender(dto.getGender());
  1074. }
  1075. if (dto.getBirthday() != null) {
  1076. try {
  1077. java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
  1078. member.setBirthday(sdf.parse(dto.getBirthday()));
  1079. } catch (java.text.ParseException e) {
  1080. throw new IllegalArgumentException("出生日期格式错误,应为yyyy-MM-dd");
  1081. }
  1082. }
  1083. // 管理员可更新辈分关系
  1084. boolean identityChanged = false;
  1085. String rebuildPeerType = null;
  1086. if (isAdmin && dto.getGenerationLevel() != null && !dto.getGenerationLevel().trim().isEmpty()) {
  1087. GenerationLevel genLevel = GenerationLevel.fromValue(dto.getGenerationLevel());
  1088. if (genLevel != null) {
  1089. // 本人自编辑不设「配偶」:关系是相对的,配偶只能由对方(或管理员代设)指定,
  1090. // 自己给自己标配偶会产生「我与我配偶」的歧义关系行。
  1091. boolean selfEdit = member.getUserId() != null && member.getUserId().equals(userId);
  1092. member.setGeneration(genLevel.getOffset());
  1093. boolean isSpouse = genLevel == GenerationLevel.PEER
  1094. && "spouse".equals(dto.getPeerType()) && !selfEdit;
  1095. member.setIsSpouse(isSpouse);
  1096. identityChanged = true;
  1097. rebuildPeerType = genLevel == GenerationLevel.PEER
  1098. ? (isSpouse ? "spouse" : "sibling")
  1099. : null;
  1100. }
  1101. }
  1102. // 孩子身份标记(仅家庭管理员可设置;落库到 users 表对应记录)
  1103. applyIsChildFlag(userId, user.getFamilyId(), member.getUserId(), dto.getIsChild());
  1104. member.setUpdatedAt(new Date());
  1105. familyMemberMapper.updateById(member);
  1106. // 辈分/同辈类型变更后重建关系表:成员列表的关系标签优先读 family_relationships,
  1107. // 不重建会出现「编辑资料改了身份、列表标签不刷新」(规格 §10 R-4)。
  1108. // 锚点=操作者(编辑人)成员记录:管理员给某成员选「配偶」时,指 TA 与操作者是配偶;
  1109. // 本人自编辑时锚点为 null(不写 spouse)。
  1110. if (identityChanged) {
  1111. Long anchorMemberId = null;
  1112. boolean selfEdit = member.getUserId() != null && member.getUserId().equals(userId);
  1113. if (!selfEdit) {
  1114. FamilyMember operator = familyMemberMapper.selectOne(new LambdaQueryWrapper<FamilyMember>()
  1115. .eq(FamilyMember::getFamilyId, member.getFamilyId())
  1116. .eq(FamilyMember::getUserId, userId)
  1117. .last("LIMIT 1"));
  1118. anchorMemberId = operator != null ? operator.getId() : null;
  1119. }
  1120. try {
  1121. familyRelationshipService.rebuildRelationsForMember(
  1122. member.getFamilyId(), member.getId(), member.getGeneration(), rebuildPeerType, anchorMemberId);
  1123. } catch (RuntimeException e) {
  1124. // 重建失败必须整体回滚:否则辈分已改而关系未重建,正是 R-4 要消除的不一致状态
  1125. log.error("重建成员关系失败,回滚本次资料更新: memberId={}, error={}", member.getId(), e.getMessage());
  1126. throw e;
  1127. }
  1128. }
  1129. logMemberAction(member.getFamilyId(), member.getId(), "update", oldNickname, member.getNickname(), userId);
  1130. return toFamilyMemberVO(member);
  1131. }
  1132. /**
  1133. * 判断用户是否为家庭管理员(多管理员):家庭创建者,或其成员记录 is_admin=1。
  1134. */
  1135. private boolean isFamilyAdminOperator(Long userId, Long familyId) {
  1136. if (userId == null || familyId == null) return false;
  1137. Family family = familyMapper.selectById(familyId);
  1138. if (family != null && family.getCreatorId() != null && Long.valueOf(userId).equals(family.getCreatorId())) {
  1139. return true;
  1140. }
  1141. try {
  1142. Long c = familyMemberMapper.selectCount(new LambdaQueryWrapper<FamilyMember>()
  1143. .eq(FamilyMember::getFamilyId, familyId)
  1144. .eq(FamilyMember::getUserId, userId)
  1145. .eq(FamilyMember::getIsAdmin, 1));
  1146. return c != null && c > 0;
  1147. } catch (Exception e) {
  1148. return false;
  1149. }
  1150. }
  1151. /**
  1152. * 设置成员的孩子身份标记(users.is_child),落库到对应的 User 记录。
  1153. *
  1154. * <p>权限:仅家庭管理员可操作(复用 {@link ReportMemberPermissionService#isFamilyAdmin});
  1155. * 非管理员抛出 {@link AccessDeniedException},由 controller 层转为 403。</p>
  1156. *
  1157. * @param operatorUserId 操作者 userId
  1158. * @param familyId 操作者所属家庭(目标成员必须同属该家庭)
  1159. * @param targetUserId 目标成员关联的 userId(family_members.user_id;家庭主账号场景即主账号 userId;null=无关联账号无法设置)
  1160. * @param isChild 期望值: 1=孩子, 0=非孩子;null=不修改
  1161. */
  1162. void applyIsChildFlag(Long operatorUserId, Long familyId, Long targetUserId, Integer isChild) {
  1163. if (isChild == null) {
  1164. return;
  1165. }
  1166. if (!reportMemberPermissionService.isFamilyAdmin(operatorUserId, familyId)) {
  1167. throw new AccessDeniedException("仅家庭管理员可设置孩子身份");
  1168. }
  1169. if (targetUserId == null) {
  1170. throw new RuntimeException("该成员未关联登录账号,无法设置孩子身份");
  1171. }
  1172. User target = userMapper.selectById(targetUserId);
  1173. if (target == null || familyId == null || !familyId.equals(target.getFamilyId())) {
  1174. throw new RuntimeException("成员不存在或不属于您的家庭");
  1175. }
  1176. target.setIsChild(isChild == 1);
  1177. target.setUpdatedAt(new Date());
  1178. userMapper.updateById(target);
  1179. log.info("已设置成员孩子身份: userId={}, isChild={}, 操作者={}", targetUserId, isChild, operatorUserId);
  1180. }
  1181. /**
  1182. * 修改家庭名称(仅家庭管理员:家庭创建者或成员记录 is_admin=1)。
  1183. * 返回更新后的家庭名称。
  1184. */
  1185. public String renameFamily(Long userId, String name) {
  1186. if (userId == null || userId <= 0) {
  1187. throw new IllegalArgumentException("请先登录");
  1188. }
  1189. String newName = name == null ? "" : name.trim();
  1190. if (newName.isEmpty()) {
  1191. throw new IllegalArgumentException("家庭名称不能为空");
  1192. }
  1193. if (newName.length() > 20) {
  1194. throw new IllegalArgumentException("家庭名称不能超过20个字");
  1195. }
  1196. User operator = userMapper.selectById(userId);
  1197. if (operator == null) {
  1198. throw new IllegalArgumentException("用户不存在");
  1199. }
  1200. Long familyId = operator.getFamilyId();
  1201. if (familyId == null) {
  1202. throw new IllegalArgumentException("请先创建或加入家庭");
  1203. }
  1204. if (!isFamilyAdminOperator(userId, familyId)) {
  1205. throw new IllegalArgumentException("仅家庭管理员可修改家庭名称");
  1206. }
  1207. Family family = familyMapper.selectById(familyId);
  1208. if (family == null) {
  1209. throw new IllegalArgumentException("家庭不存在");
  1210. }
  1211. family.setName(newName);
  1212. family.setUpdatedAt(new Date());
  1213. familyMapper.updateById(family);
  1214. return newName;
  1215. }
  1216. /**
  1217. * 更新家庭主账号(users 表成员)的基本资料。
  1218. * 家庭主账号只存在于 users 表(family_id + role=parent),无 family_members 记录,
  1219. * 因此编辑昵称/性别/生日/头像/手机号直接写 users 表;辈分关系仅 family_members 成员支持。
  1220. */
  1221. private FamilyMemberVO updateParentMember(User operator, Long memberId, AddFamilyMemberDTO dto) {
  1222. Family family = familyMapper.selectById(operator.getFamilyId());
  1223. boolean isAdmin = family != null && Long.valueOf(operator.getId()).equals(family.getCreatorId());
  1224. if (!isAdmin) {
  1225. throw new RuntimeException("仅家庭创建者可编辑该成员");
  1226. }
  1227. if (dto.getIsAdmin() != null) {
  1228. throw new RuntimeException("该成员为家庭主账号,不支持设置管理员,请对家庭成员记录操作");
  1229. }
  1230. User parent = userMapper.selectById(memberId);
  1231. if (parent == null
  1232. || parent.getFamilyId() == null
  1233. || !parent.getFamilyId().equals(operator.getFamilyId())
  1234. || !"parent".equals(parent.getRole())) {
  1235. throw new RuntimeException("成员不存在或不属于您的家庭");
  1236. }
  1237. String oldNickname = parent.getNickname();
  1238. if (dto.getNickname() != null && !dto.getNickname().trim().isEmpty()) {
  1239. parent.setNickname(dto.getNickname().trim());
  1240. }
  1241. if (dto.getPhone() != null) {
  1242. parent.setPhone(dto.getPhone());
  1243. }
  1244. if (dto.getAvatar() != null) {
  1245. parent.setAvatar(dto.getAvatar());
  1246. }
  1247. if (dto.getGender() != null) {
  1248. parent.setGender(dto.getGender());
  1249. }
  1250. if (dto.getBirthday() != null) {
  1251. try {
  1252. java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
  1253. parent.setBirthday(sdf.parse(dto.getBirthday()));
  1254. } catch (java.text.ParseException e) {
  1255. throw new IllegalArgumentException("出生日期格式错误,应为yyyy-MM-dd");
  1256. }
  1257. }
  1258. // 孩子身份标记(仅家庭管理员可设置;主账号即 memberId 对应的 User 记录)
  1259. applyIsChildFlag(operator.getId(), operator.getFamilyId(), memberId, dto.getIsChild());
  1260. parent.setUpdatedAt(new Date());
  1261. userMapper.updateById(parent);
  1262. logMemberAction(parent.getFamilyId(), parent.getId(), "update", oldNickname, parent.getNickname(), operator.getId());
  1263. // 返回与成员列表一致的 VO
  1264. FamilyMemberVO vo = new FamilyMemberVO();
  1265. vo.setId(parent.getId());
  1266. vo.setMemberId(parent.getId());
  1267. vo.setSource("parent");
  1268. vo.setMemberType("parent");
  1269. vo.setUserId(parent.getId());
  1270. vo.setNickname(parent.getNickname());
  1271. vo.setName(parent.getNickname());
  1272. vo.setAvatar(parent.getAvatar());
  1273. vo.setPhone(parent.getPhone());
  1274. vo.setGender(parent.getGender());
  1275. vo.setEffectiveRole("parent");
  1276. vo.setRoleLabel(parent.getFamilyRole() != null ? parent.getFamilyRole() : "本人");
  1277. if (parent.getBirthday() != null) {
  1278. vo.setAge(calculateAge(parent.getBirthday()));
  1279. }
  1280. vo.setGeneration(0);
  1281. vo.setIsAdmin(true);
  1282. vo.setIsSelf(parent.getId().equals(operator.getId()));
  1283. // 家庭主账号均为可登录用户,不允许切换视角(与成员段"仅不可登录可切换"一致)
  1284. vo.setIsSwitchable(false); // source='parent' 段(updateParentMember 返回 VO)
  1285. vo.setShowToFamily(parent.getShowToFamily() != null ? parent.getShowToFamily() : 1);
  1286. vo.setIsSpouse(false);
  1287. vo.setTotalPoints(parent.getTotalPoints());
  1288. return vo;
  1289. }
  1290. // ===== 内部方法 =====
  1291. /**
  1292. * T24-C:成员状态优先级排名(供重复行选"主成员"使用,与 JwtInterceptor 解析口径一致):
  1293. * active=0 最优先,其余状态(如 invited/pending)=1,recycled=2 最次。
  1294. */
  1295. private static int statusRank(String status) {
  1296. if ("active".equals(status)) return 0;
  1297. if ("recycled".equals(status)) return 2;
  1298. return 1;
  1299. }
  1300. /**
  1301. * 解析成员显示名:优先关联 users 表的 nickname,其次 family_members.nickname。
  1302. * 同一人可能同时存在于两表(创建者/受邀登录成员),getVisibleMembers 家庭主账号段显示的正是 users.nickname,
  1303. * 此处统一口径,避免「我的家庭」与成员管理页名称不一致。
  1304. */
  1305. private String resolveMemberNickname(FamilyMember fm) {
  1306. if (fm.getUserId() != null) {
  1307. User u = userMapper.selectById(fm.getUserId());
  1308. if (u != null && u.getNickname() != null && !u.getNickname().trim().isEmpty()) {
  1309. return u.getNickname();
  1310. }
  1311. }
  1312. return fm.getNickname();
  1313. }
  1314. private FamilyMemberVO toFamilyMemberVO(FamilyMember member) {
  1315. FamilyMemberVO vo = new FamilyMemberVO();
  1316. vo.setId(member.getId());
  1317. vo.setSource("family_member");
  1318. vo.setUserId(member.getUserId());
  1319. vo.setNickname(resolveMemberNickname(member));
  1320. vo.setPhone(member.getPhone());
  1321. vo.setAvatar(member.getAvatar());
  1322. vo.setGender(member.getGender());
  1323. vo.setGeneration(member.getGeneration());
  1324. vo.setEffectiveRole(computeEffectiveRole(member));
  1325. vo.setRoleLabel(computeEffectiveRole(member));
  1326. vo.setTotalPoints(member.getTotalPoints());
  1327. vo.setShowToFamily(member.getShowToFamily());
  1328. if (member.getBirthday() != null) {
  1329. vo.setAge(calculateAge(member.getBirthday()));
  1330. vo.setBirthday(formatDate(member.getBirthday()));
  1331. }
  1332. // 设置 isSwitchable:仅无 openid 的不可登录成员可被切换(可登录成员不允许切换视角)
  1333. if (member.getUserId() != null) {
  1334. User memberUser = userMapper.selectById(member.getUserId());
  1335. String openid = memberUser != null ? memberUser.getOpenid() : null;
  1336. vo.setIsSwitchable(openid == null || openid.isEmpty());
  1337. } else {
  1338. vo.setIsSwitchable(true);
  1339. }
  1340. // SC-P-04 family.familyMembers.list:在线状态(口径 = lastInteractionAt 最后互动时间)
  1341. vo.setLastActiveAt(member.getLastInteractionAt());
  1342. vo.setOnline(member.getLastInteractionAt() != null
  1343. && (System.currentTimeMillis() - member.getLastInteractionAt().getTime()) < ONLINE_WINDOW_MS);
  1344. return vo;
  1345. }
  1346. private Integer calculateAge(java.util.Date birthday) {
  1347. if (birthday == null) return null;
  1348. java.util.Calendar birth = java.util.Calendar.getInstance();
  1349. birth.setTime(birthday);
  1350. java.util.Calendar now = java.util.Calendar.getInstance();
  1351. int age = now.get(java.util.Calendar.YEAR) - birth.get(java.util.Calendar.YEAR);
  1352. if (now.get(java.util.Calendar.MONTH) < birth.get(java.util.Calendar.MONTH) ||
  1353. (now.get(java.util.Calendar.MONTH) == birth.get(java.util.Calendar.MONTH) &&
  1354. now.get(java.util.Calendar.DAY_OF_MONTH) < birth.get(java.util.Calendar.DAY_OF_MONTH))) {
  1355. age--;
  1356. }
  1357. return Math.max(0, age);
  1358. }
  1359. /** 格式化为 yyyy-MM-dd(前端编辑回显用),返回 null 时不修改 */
  1360. private String formatDate(java.util.Date d) {
  1361. if (d == null) return null;
  1362. try {
  1363. java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
  1364. return sdf.format(d);
  1365. } catch (Exception e) {
  1366. return null;
  1367. }
  1368. }
  1369. /**
  1370. * 计算成员的实际角色(effective role)
  1371. * 优先使用年龄判定(birthday → age < childThreshold → child),
  1372. * 无生日数据时回退到 generation 判定
  1373. */
  1374. private String computeEffectiveRole(FamilyMember member) {
  1375. // 优先按年龄判定(生日优先于 generation)
  1376. if (member.getBirthday() != null) {
  1377. int age = calculateAge(member.getBirthday());
  1378. int childThreshold = systemConfigService.getChildAgeThreshold();
  1379. return age < childThreshold ? "child" : "parent";
  1380. }
  1381. // 无生日数据:按 generation 回退(generation >= 0 = parent, < 0 = child)
  1382. if (member.getGeneration() != null) {
  1383. return member.getGeneration() >= 0 ? "parent" : "child";
  1384. }
  1385. // 无 birthday 无 generation:不可登录成员(userId=null,家庭代管的"孩子")默认归为孩子上下文,
  1386. // 保证 SC-P-73「选孩子 → 任务/报告/方案按孩子上下文隔离」;可登录成员无基础数据按 parent 兜底
  1387. if (member.getUserId() == null) {
  1388. return "child";
  1389. }
  1390. return "parent";
  1391. }
  1392. /**
  1393. * 计算视角相关的关系标签(基于 generation 差值)
  1394. * - generation diff > 0: 长辈
  1395. * - generation diff < 0: 晚辈
  1396. * - generation diff = 0: 同辈(配偶/兄弟姐妹)
  1397. */
  1398. private String computeRelativeLabel(FamilyMember viewer, FamilyMember target, List<FamilyMember> allMembers) {
  1399. if (viewer.getId().equals(target.getId())) {
  1400. return "我";
  1401. }
  1402. // 优先使用 generation diff
  1403. if (viewer.getGeneration() != null && target.getGeneration() != null) {
  1404. int genDiff = target.getGeneration() - viewer.getGeneration();
  1405. boolean isSpouse = Boolean.TRUE.equals(target.getIsSpouse());
  1406. String targetGender = target.getGender();
  1407. switch (genDiff) {
  1408. case 0:
  1409. if (isSpouse) {
  1410. return "male".equals(targetGender) ? "丈夫" : "妻子";
  1411. }
  1412. return computeSiblingLabel(viewer, target);
  1413. case 1:
  1414. return "male".equals(targetGender) ? "爸爸" : "妈妈";
  1415. case -1:
  1416. return computeParentChildLabel(viewer, target, allMembers);
  1417. case 2:
  1418. return "male".equals(targetGender) ? "爷爷" : "奶奶";
  1419. case -2:
  1420. return "male".equals(targetGender) ? "孙子" : "孙女";
  1421. case 3:
  1422. return "male".equals(targetGender) ? "曾祖父" : "曾祖母";
  1423. case -3:
  1424. return "male".equals(targetGender) ? "曾孙" : "曾孙女";
  1425. default:
  1426. return genDiff > 0 ? "长辈" : "晚辈";
  1427. }
  1428. }
  1429. // 无 generation 时的 fallback(旧数据兼容)
  1430. String viewerRole = computeEffectiveRole(viewer);
  1431. String targetRole = computeEffectiveRole(target);
  1432. String targetGender = target.getGender();
  1433. // parent → child
  1434. if ("parent".equals(viewerRole) && "child".equals(targetRole)) {
  1435. return computeParentChildLabel(viewer, target, allMembers);
  1436. }
  1437. // child → parent
  1438. if ("child".equals(viewerRole) && "parent".equals(targetRole)) {
  1439. return "male".equals(targetGender) ? "父亲" : "母亲";
  1440. }
  1441. // child → child (sibling)
  1442. if ("child".equals(viewerRole) && "child".equals(targetRole)) {
  1443. return computeSiblingLabel(viewer, target);
  1444. }
  1445. // parent → parent (partner)
  1446. if ("parent".equals(viewerRole) && "parent".equals(targetRole)) {
  1447. return "male".equals(targetGender) ? "丈夫" : "妻子";
  1448. }
  1449. return null;
  1450. }
  1451. /**
  1452. * 计算父母视角下的子女标签(含序数)
  1453. */
  1454. private String computeParentChildLabel(FamilyMember viewer, FamilyMember target, List<FamilyMember> allMembers) {
  1455. String targetGender = target.getGender();
  1456. // 收集所有家庭成员,按 generation 降序(辈分越高,年龄越大)或生日排序
  1457. List<FamilyMember> children = allMembers.stream()
  1458. .filter(m -> !m.getId().equals(viewer.getId()))
  1459. .filter(m -> {
  1460. if (viewer.getGeneration() != null && m.getGeneration() != null) {
  1461. return m.getGeneration() < viewer.getGeneration();
  1462. }
  1463. return "child".equals(computeEffectiveRole(m));
  1464. })
  1465. .sorted(Comparator.comparing(FamilyMember::getBirthday, Comparator.nullsLast(Comparator.naturalOrder())))
  1466. .collect(Collectors.toList());
  1467. // 长幼排行按同性别子集计算(长子/次子/长女/次女...),避免与异性别成员混排导致序数错误。
  1468. List<FamilyMember> rankedPool = children;
  1469. if ("male".equals(targetGender) || "female".equals(targetGender)) {
  1470. rankedPool = children.stream()
  1471. .filter(m -> targetGender.equals(m.getGender()))
  1472. .collect(Collectors.toList());
  1473. }
  1474. int index = -1;
  1475. for (int i = 0; i < rankedPool.size(); i++) {
  1476. if (rankedPool.get(i).getId().equals(target.getId())) {
  1477. index = i;
  1478. break;
  1479. }
  1480. }
  1481. if (children.size() <= 1 || index < 0) {
  1482. if ("male".equals(targetGender)) return "儿子";
  1483. if ("female".equals(targetGender)) return "女儿";
  1484. return "子女";
  1485. }
  1486. String[] ordinals = {"长", "次", "三", "四", "五", "六", "七", "八", "九", "十"};
  1487. String prefix = (index < ordinals.length) ? ordinals[index] : ("第" + (index + 1));
  1488. if ("male".equals(targetGender)) return prefix + "子";
  1489. if ("female".equals(targetGender)) return prefix + "女";
  1490. return prefix + "子女";
  1491. }
  1492. /**
  1493. * 选择视角相关的关系标签。
  1494. * 优先级:动态长幼计算 > family_relationships 粗辈分标签(genValue 兜底)。
  1495. * 动态计算能表达"长子/次女/哥哥/姐姐"等精确排行,优先于只能表达"兄弟/姐妹"的粗标签。
  1496. */
  1497. String resolveRelativeLabel(FamilyMember viewer, FamilyMember target, List<FamilyMember> allMembers, Integer relGenValue, String relType) {
  1498. // 动态长幼计算优先(能表达"长子/次女/哥哥/姐姐"等精确排行);
  1499. // family_relationships 粗辈分标签(genValue+relType) 仅作兜底(只能表达"兄弟/姐妹/丈夫/妻子")。
  1500. String dynamic = computeRelativeLabel(viewer, target, allMembers);
  1501. if (dynamic != null) return dynamic;
  1502. if (relGenValue != null && familyRelationshipService != null) {
  1503. return familyRelationshipService.computeRelationshipLabel(relGenValue, target.getGender(), relType);
  1504. }
  1505. return null;
  1506. }
  1507. /**
  1508. * 计算兄弟姐妹标签(按生日比较)
  1509. */
  1510. private String computeSiblingLabel(FamilyMember viewer, FamilyMember target) {
  1511. String targetGender = target.getGender();
  1512. Date viewerBday = viewer.getBirthday();
  1513. Date targetBday = target.getBirthday();
  1514. if (viewerBday != null && targetBday != null) {
  1515. int cmp = viewerBday.compareTo(targetBday);
  1516. if (cmp < 0) {
  1517. // viewer 比 target 更大(更早出生) → target 是弟弟/妹妹
  1518. return "male".equals(targetGender) ? "弟弟" : "妹妹";
  1519. } else if (cmp > 0) {
  1520. // viewer 比 target 更小(更晚出生) → target 是哥哥/姐姐
  1521. return "male".equals(targetGender) ? "哥哥" : "姐姐";
  1522. }
  1523. }
  1524. // 同龄或无法比较
  1525. return "male".equals(targetGender) ? "哥哥" : "姐姐";
  1526. }
  1527. private void logMemberAction(Long familyId, Long memberId, String action, String oldValue, String newValue, Long operatorId) {
  1528. try {
  1529. FamilyMemberLog logEntry = new FamilyMemberLog();
  1530. logEntry.setFamilyId(familyId);
  1531. logEntry.setMemberId(memberId);
  1532. logEntry.setAction(action);
  1533. logEntry.setOldValue(oldValue);
  1534. logEntry.setNewValue(newValue);
  1535. logEntry.setOperatorId(operatorId);
  1536. logEntry.setCreatedAt(new Date());
  1537. familyMemberLogMapper.insert(logEntry);
  1538. } catch (Exception e) {
  1539. log.warn("写入家庭成员日志失败: {}", e.getMessage());
  1540. }
  1541. }
  1542. public Result<List<FamilyMemberLog>> getMemberLogs(Long userId, Long memberId) {
  1543. User user = userMapper.selectById(userId);
  1544. if (user == null || user.getFamilyId() == null) {
  1545. return Result.error("用户未加入家庭");
  1546. }
  1547. Long familyId = user.getFamilyId();
  1548. LambdaQueryWrapper<FamilyMemberLog> query = new LambdaQueryWrapper<FamilyMemberLog>()
  1549. .eq(FamilyMemberLog::getFamilyId, familyId)
  1550. .orderByDesc(FamilyMemberLog::getCreatedAt);
  1551. if (memberId != null) {
  1552. query.eq(FamilyMemberLog::getMemberId, memberId);
  1553. }
  1554. SortUtil.applySort(query);
  1555. List<FamilyMemberLog> logs = familyMemberLogMapper.selectList(query);
  1556. return Result.success(logs);
  1557. }
  1558. public boolean isCallerInSameFamily(Long familyMemberId, Long callerUserId) {
  1559. if (familyMemberId == null || callerUserId == null) return false;
  1560. FamilyMember member = familyMemberMapper.selectById(familyMemberId);
  1561. if (member == null) return false;
  1562. long familyId = member.getFamilyId();
  1563. long count = familyMemberMapper.selectCount(
  1564. new LambdaQueryWrapper<FamilyMember>()
  1565. .eq(FamilyMember::getFamilyId, familyId)
  1566. .eq(FamilyMember::getUserId, callerUserId)
  1567. .last("LIMIT 1"));
  1568. return count > 0;
  1569. }
  1570. public boolean isCallerInFamily(Long familyId, Long callerUserId) {
  1571. if (familyId == null || callerUserId == null) return false;
  1572. long count = familyMemberMapper.selectCount(
  1573. new LambdaQueryWrapper<FamilyMember>()
  1574. .eq(FamilyMember::getFamilyId, familyId)
  1575. .eq(FamilyMember::getUserId, callerUserId)
  1576. .last("LIMIT 1"));
  1577. return count > 0;
  1578. }
  1579. /**
  1580. * 获取家庭成员列表(含家庭信息),兼容旧接口 /api/family/user/family-members 的 Map 返回结构。
  1581. * 返回: { familyId, familyName, inviteCode, creatorId, members[] }
  1582. * members 为富化的 FamilyMemberVO 列表(含 roleLabel/trustScore 等展示字段),已含家庭主账号段与成员段全量,
  1583. * 供前端单次调用 /api/family/member/list?includeFamily=true 同时获取成员与家庭信息,避免重复请求。
  1584. */
  1585. public Map<String, Object> listMembersWithFamily(Long userId) {
  1586. Map<String, Object> result = new java.util.HashMap<>();
  1587. User user = userMapper.selectById(userId);
  1588. if (user == null) {
  1589. return result;
  1590. }
  1591. Long familyId = user.getFamilyId();
  1592. if (familyId == null) {
  1593. return result;
  1594. }
  1595. Family family = familyMapper.selectById(familyId);
  1596. if (family == null) {
  1597. return result;
  1598. }
  1599. result.put("familyId", familyId);
  1600. result.put("familyName", family.getName());
  1601. result.put("inviteCode", family.getInviteCode());
  1602. result.put("creatorId", family.getCreatorId());
  1603. result.put("members", listMembers(userId));
  1604. return result;
  1605. }
  1606. }