From 84c81837d6465ee3f768291ea1f2859e322bd1b4 Mon Sep 17 00:00:00 2001 From: hejianhao <15708179461@qq.com> Date: 星期二, 18 八月 2026 11:38:31 +0800 Subject: [PATCH] feat0806: 提交省代理管理 --- tcm-training-admin-backend/sql/20260806_admin.sql | 24 +++++++++++++++++++++++- 1 files changed, 23 insertions(+), 1 deletions(-) diff --git a/tcm-training-admin-backend/sql/20260806_admin.sql b/tcm-training-admin-backend/sql/20260806_admin.sql index eae6241..0a0a676 100644 --- a/tcm-training-admin-backend/sql/20260806_admin.sql +++ b/tcm-training-admin-backend/sql/20260806_admin.sql @@ -31,4 +31,26 @@ -- 为 tcm_clinic 表新增代理关联字段 ALTER TABLE tcm_clinic ADD COLUMN agent_id BIGINT COMMENT '负责该诊所的省代理ID，tcm_provincial_agent.id' -AFTER name; \ No newline at end of file +AFTER name; +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, sort, status, visible, permission_key, remark, deleted) VALUES +(2119, 2100, '省代理管理', 'member_agent_manage', 'C', '/member/user/agent', 'Member/AgentList', 12, 1, 1, 'member:agent:view', '省代理管理菜单', 0), +(2120, 2119, '新增省代理', 'member_agent_add', 'B', NULL, NULL, 1, 1, 1, 'member:agent:add', '新增省代理权限', 0), +(2121, 2119, '编辑省代理', 'member_agent_edit', 'B', NULL, NULL, 2, 1, 1, 'member:agent:edit', '编辑省代理权限', 0), +(2122, 2119, '删除省代理', 'member_agent_delete', 'B', NULL, NULL, 3, 1, 1, 'member:agent:delete', '删除省代理权限', 0), +(2123, 2119, '省代理详情', 'member_agent_detail', 'B', NULL, NULL, 4, 1, 1, 'member:agent:detail', '省代理详情权限', 0); + + +-- 养生直播：新增设置直播间密码按钮权限 +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (3064, 3060, '设置直播间密码', 'live_course_password', 'B', NULL, NULL, NULL, 4, 1, 1, 'live:course:password', '设置直播间密码按钮', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), +menu_code = VALUES(menu_code), type = VALUES(type), sort = VALUES(sort), status = VALUES(status), +visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = VALUES(deleted); + + +-- 为 tcm_clinic 表新增银行信息字段（全部加在 status 字段后面） +ALTER TABLE tcm_clinic +ADD COLUMN bank_name VARCHAR(100) COMMENT '开户银行名称（如：中国建设银行）' AFTER status, +ADD COLUMN account_number VARCHAR(30) COMMENT '银行账号' AFTER bank_name, +ADD COLUMN account_holder VARCHAR(50) COMMENT '账户名称/户名（即开户人姓名或公司名称）' AFTER account_number, +ADD COLUMN branch_name VARCHAR(100) COMMENT '开户支行名称（如：成都高新支行）' AFTER account_holder; -- Gitblit v1.7.1