packServer/backend/app/model/subject_member.js
liufumingren b2eea28001 feat(微信网关): 扫码登录 / 绑定微信 / 工作台扫码登入,废弃自建登录码
对接 https://gateway.gztbyc.com:二维码与「扫码确认」由网关提供,本服务只负责
申请临时码 → 验签收通知 → 落地自己的业务。

- 新增 service/wx_gateway.js + controller/gateway/notify.js(POST /api/wechat-gateway/notify,验签 401 / 会话过期 200 ignored)
- 新增 controller/web/wx_gateway.js(登录二维码 / 长轮询 / SVG+GIF / 个人中心绑定与解绑)
- 新表 wechat_gateway_bindings(uk(app_key, openid)):一个微信只绑一个账号,解绑是软删,
  再绑定走 restore 复用(否则会撞唯一键报 Validation error)
- 「这个微信已绑别的账号」策略:原账号正常 → 拒绝并提示对方账号名;原账号禁用/已删 → 直接改绑;
  拿不到原账号 → 运维接口 GET/DELETE /api/internal/wechat-bindings 强制解绑
- 主体成员改为「扫码绑定」:管理员出二维码 → 成员微信扫码 → 已有账号直接继承(自动建的临时账号删掉),
  没有账号则由服务端建号并绑成其登录方式;subject_members.temp_user_id 记录临时账号
- 废弃自建登录码:删除 GET /api/wechat/login(6 位串码)与 workstations.login_code(迁移 20261028121000),
  工作台改扫码登入,成员绑定码与 /wechat?bind= 手机确认页下线
- 前端:登录页/个人中心/主体成员/工作台全部切到网关;桌面端登录窗改网关二维码 + 长轮询
- 测试:wx-gateway.test.js 覆盖登录/绑定/解绑-再绑/禁用账号改绑/运维强制解绑/成员绑定/工作台登入

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-10-29 17:20:05 +08:00

41 lines
1.9 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';
/**
* 主体成员表模型(subject_members)
*
* 一行 = 某主体下的一个成员:
* - `name`:姓名(必填,创建成员时先只填姓名也行)
* - `userId`:绑定的账号(可为空 —— 先建成员,之后用「扫码绑定」绑微信/账号)
* - `tempUserId`:扫码绑定时**自动建给成员的账号**(被已有账号继承时删除)
* - `role`:1 管理员 / 2 成员
* - `wechatOpenid` / `boundAt`:扫码绑定微信后记录
*
* 同一主体下同一账号只能有一条(DB 唯一索引 `subject_id + user_id`)。
*/
module.exports = (app) => {
const { BIGINT, STRING, TINYINT, DATE } = app.Sequelize;
const SubjectMember = app.model.define('subject_member', {
id: { type: BIGINT.UNSIGNED, primaryKey: true, autoIncrement: true, comment: '主键' },
subjectId: { type: BIGINT.UNSIGNED, allowNull: false, comment: '主体 subjects.id' },
userId: { type: BIGINT.UNSIGNED, comment: '绑定账号 users.id(未绑定为空)' },
tempUserId: { type: BIGINT.UNSIGNED, comment: '自动建给成员的临时账号 users.id(被已有账号继承时删除)' },
name: { type: STRING(32), allowNull: false, comment: '成员姓名' },
role: { type: TINYINT.UNSIGNED, allowNull: false, defaultValue: 2, comment: '角色:1管理员 2成员' },
wechatOpenid: { type: STRING(64), comment: '绑定的微信 openid' },
boundAt: { type: DATE, comment: '绑定账号/微信时间' },
status: { type: TINYINT.UNSIGNED, allowNull: false, defaultValue: 1, comment: '状态:1正常 0禁用' },
}, {
tableName: 'subject_members',
paranoid: true,
comment: '主体成员表',
});
SubjectMember.associate = function() {
app.model.SubjectMember.belongsTo(app.model.Subject, { foreignKey: 'subject_id', as: 'subject' });
app.model.SubjectMember.belongsTo(app.model.User, { foreignKey: 'user_id', as: 'user' });
};
return SubjectMember;
};