From 50c40264084f032c5d28b07e247ed4d7f84c55df Mon Sep 17 00:00:00 2001
From: hejianhao <15708179461@qq.com>
Date: 星期二, 18 八月 2026 14:29:14 +0800
Subject: [PATCH] feat0806: 诊所管理部分功能

---
 tcm-training-admin-backend/sql/20260806_admin.sql |   15 ++++++++++-----
 1 files changed, 10 insertions(+), 5 deletions(-)

diff --git a/tcm-training-admin-backend/sql/20260806_admin.sql b/tcm-training-admin-backend/sql/20260806_admin.sql
index 362b675..1441300 100644
--- a/tcm-training-admin-backend/sql/20260806_admin.sql
+++ b/tcm-training-admin-backend/sql/20260806_admin.sql
@@ -33,12 +33,13 @@
 ALTER TABLE tcm_clinic
 ADD COLUMN agent_id BIGINT COMMENT '负责该诊所的省代理ID，tcm_provincial_agent.id'
 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);
+(5046, 2100, '省代理管理', 'member_agent_manage', 'C', '/member/user/agent', 'Member/AgentList', 12, 1, 1, 'member:agent:view', '省代理管理菜单', 0),
+(5047, 5046, '新增省代理', 'member_agent_add', 'B', NULL, NULL, 1, 1, 1, 'member:agent:add', '新增省代理权限', 0),
+(5048, 5046, '编辑省代理', 'member_agent_edit', 'B', NULL, NULL, 2, 1, 1, 'member:agent:edit', '编辑省代理权限', 0),
+(5049, 5046, '删除省代理', 'member_agent_delete', 'B', NULL, NULL, 3, 1, 1, 'member:agent:delete', '删除省代理权限', 0),
+(5050, 5046, '省代理详情', 'member_agent_detail', 'B', NULL, NULL, 4, 1, 1, 'member:agent:detail', '省代理详情权限', 0);
 
 
 -- 养生直播：新增设置直播间密码按钮权限
@@ -55,3 +56,7 @@
 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;
+
+INSERT INTO sys_menu (id, parent_id, name, menu_code, type, sort, status, visible, permission_key, remark, deleted)
+VALUES (5045, 2118, '编辑诊所', 'member_clinic_edit', 'B', 1, 1, 1, 'member:clinic:edit', '编辑诊所按钮', 0)
+ON DUPLICATE KEY UPDATE permission_key = VALUES(permission_key), deleted = 0;

--
Gitblit v1.7.1