Files
api_user/scripts/migrate_user_app.js
lik 946160f3f4 feat: 用户多应用成员关系与微信扫码登录
- 新增 user_app / user_identity 模型、应用注册表与成员关系服务,启动时校验配置覆盖

- 新增微信开放平台扫码登录:二维码地址、回调与 ticket 换取 token

- 管理端接口改为路由层声明 appIds + 角色鉴权,新增批量用户信息、锁定、授权与个人配置

- 删除账号同步清理成员关系与外部身份,避免关系被新账号复用

- 补充多应用、应用配置、注册表测试与迁移/建号脚本
2026-11-06 19:47:51 +08:00

203 lines
6.1 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
"use strict";
/**
* 回填 user_app / user_identity(P2)
*
* 用法:node scripts/migrate_user_app.js
*
* 顺序(与 doc/user-multi-app-plan.md 7.3 一致):
* 1. 检查旧数据重复 openid / unionid
* 2. 建 user_app、user_identity 索引
* 3. 按 _id 分批回填,幂等
* 4. 回填后校验每个旧 app 条目都能在新表命中
*
* 未在 APP_REGISTRY 登记的 appId 不能丢弃:按微信小程序兜底并告警。
*/
import { DBModel } from "../models/index.js";
import { APP_REGISTRY } from "../models/app_registry.js";
import {
upsertIdentity,
upsertMigratedMembership,
normalizeRoles,
normalizeString,
} from "../models/user_membership.js";
async function checkDuplicates() {
const duplicateOpenids = await DBModel.User.aggregate([
{ $match: { app: { $type: "object" } } },
{ $project: { appEntries: { $objectToArray: "$app" } } },
{ $unwind: "$appEntries" },
{ $match: { "appEntries.v.wxopenid": { $type: "string", $ne: "" } } },
{ $addFields: { userId: "$_id" } },
{
$group: {
_id: { appId: "$appEntries.k", openid: "$appEntries.v.wxopenid" },
count: { $sum: 1 },
userIds: { $push: "$userId" },
},
},
{ $match: { count: { $gt: 1 } } },
]).exec();
const duplicateUnionids = await DBModel.User.aggregate([
{ $match: { app: { $type: "object" } } },
{
$project: {
appEntries: { $objectToArray: "$app" },
socialUnionid: "$social.wechat.unionid",
},
},
{ $unwind: "$appEntries" },
{
$addFields: {
unionid: { $ifNull: ["$appEntries.v.unionid", "$socialUnionid"] },
},
},
{ $match: { unionid: { $type: "string", $ne: "" } } },
{
$group: {
_id: "$unionid",
// 同一用户的多个 app 条目会解析出同一个 unionid,必须按 userId 去重后判重,
// 否则单个用户就会触发误报中止
userIds: { $addToSet: "$_id" },
},
},
{ $match: { $expr: { $gt: [{ $size: "$userIds" }, 1] } } },
]).exec();
return { duplicateOpenids, duplicateUnionids };
}
async function backfill() {
const cursor = DBModel.User.find({ app: { $type: "object" } })
.batchSize(100)
.lean()
.cursor();
const stats = { users: 0, memberships: 0, identities: 0, errors: 0, unknownApps: new Set() };
for await (const user of cursor) {
stats.users++;
for (const [appId, entry] of Object.entries(user.app || {})) {
const meta = APP_REGISTRY[appId];
if (!meta) {
stats.unknownApps.add(appId);
console.warn(`[migrate] 未知 appId=${appId}(user=${user._id}),按微信小程序兜底,请补登 APP_REGISTRY`);
}
const roles = normalizeRoles(entry?.role);
try {
await upsertMigratedMembership({ userId: user._id, appId, roles });
stats.memberships++;
const openid = normalizeString(entry?.wxopenid);
if (openid) {
const unionid = normalizeString(entry?.unionid)
|| normalizeString(user.social?.wechat?.unionid);
await upsertIdentity({
userId: user._id,
appId,
platform: meta?.platform || "weixin",
provider: meta?.provider || "weixin-mini",
openid,
unionid,
});
stats.identities++;
}
} catch (err) {
stats.errors++;
console.error(`[migrate] 回填失败 user=${user._id} app=${appId}: ${err.message}`);
}
}
}
return stats;
}
async function verify() {
const missing = [];
const cursor = DBModel.User.find({ app: { $type: "object" } })
.batchSize(100)
.lean()
.cursor();
for await (const user of cursor) {
for (const [appId, entry] of Object.entries(user.app || {})) {
const membership = await DBModel.UserApp.exists({ userId: user._id, appId });
if (!membership) {
missing.push({ type: "membership", userId: String(user._id), appId });
}
const openid = normalizeString(entry?.wxopenid);
if (!openid) continue;
const meta = APP_REGISTRY[appId] || { provider: "weixin-mini" };
const identity = await DBModel.UserIdentity.exists({
appId,
provider: meta.provider,
openid,
userId: user._id,
});
if (!identity) {
missing.push({ type: "identity", userId: String(user._id), appId, openid });
}
}
}
return missing;
}
async function main() {
DBModel.init();
await DBModel.dbConnection.asPromise();
try {
console.log("[migrate] 1/4 检查旧数据重复项...");
const { duplicateOpenids, duplicateUnionids } = await checkDuplicates();
if (duplicateOpenids.length || duplicateUnionids.length) {
console.error("[migrate] 旧数据存在重复身份,已中止:");
duplicateOpenids.forEach((item) => console.error(" openid:", JSON.stringify(item)));
duplicateUnionids.forEach((item) => console.error(" unionid:", JSON.stringify(item)));
process.exitCode = 1;
return;
}
console.log("[migrate] 2/4 建立索引...");
await Promise.all([
DBModel.UserApp.createIndexes(),
DBModel.UserIdentity.createIndexes(),
]);
console.log("[migrate] 3/4 回填 user_app / user_identity...");
const stats = await backfill();
console.log("[migrate] 4/4 校验回填结果...");
const missing = await verify();
console.log("---------------------------------------------");
console.log(`[migrate] 用户 ${stats.users},成员关系 ${stats.memberships},身份 ${stats.identities}`);
console.log(`[migrate] 回填错误 ${stats.errors},未知 appId ${stats.unknownApps.size},校验缺失 ${missing.length}`);
if (stats.unknownApps.size) {
console.log(`[migrate] 待补登 APP_REGISTRY: ${[...stats.unknownApps].join(", ")}`);
}
missing.slice(0, 20).forEach((item) => console.error(" 缺失:", JSON.stringify(item)));
if (stats.errors || missing.length) {
process.exitCode = 1;
}
} finally {
await DBModel.dbConnection.close();
}
}
main().catch((err) => {
console.error("[migrate] 失败:", err.message);
process.exitCode = 1;
});