1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
| -- 当前项目系统基础数据精简脚本
| -- 执行前备份:.local-backups/product-inventory-management-xmgl-before-system-cleanup-20261105-145021.sql
| -- 三个账号初始密码统一为:admin123(登录后请及时修改普通用户和客户密码)
|
| SET NAMES utf8mb4;
| SET FOREIGN_KEY_CHECKS = 0;
| START TRANSACTION;
|
| -- 1. 用户、角色、部门:仅保留管理员、普通用户、客户三类账号。
| DELETE FROM sys_user_post;
| DELETE FROM sys_user_role;
| DELETE FROM sys_user_dept;
| DELETE FROM sys_role_menu;
| DELETE FROM sys_role_dept;
| DELETE FROM sys_user WHERE user_id <> 1;
|
| UPDATE sys_user
| SET user_name='admin', nick_name='管理员账号', user_type='00',
| password='$2a$10$E0Rg.GqdeQd1ba2Z5P87HOsOELqoKwYwKFQGRGop.LEPaom7yzji.',
| status='0', del_flag='0', tenant_id=208, update_by='system-cleanup', update_time=NOW(),
| remark='系统管理员'
| WHERE user_id=1;
|
| INSERT INTO sys_user
| (user_id,user_name,nick_name,user_type,email,phonenumber,sex,password,status,del_flag,
| create_by,create_time,remark,tenant_id,ai_enabled)
| VALUES
| (2,'user','普通用户','00','','','0','$2a$10$E0Rg.GqdeQd1ba2Z5P87HOsOELqoKwYwKFQGRGop.LEPaom7yzji.','0','0',
| 'admin',NOW(),'项目日常使用账号',208,0),
| (3,'customer','客户账号','01','','','0','$2a$10$E0Rg.GqdeQd1ba2Z5P87HOsOELqoKwYwKFQGRGop.LEPaom7yzji.','0','0',
| 'admin',NOW(),'客户门户账号',208,0);
|
| DELETE FROM sys_role;
| INSERT INTO sys_role
| (role_id,role_name,role_key,role_sort,data_scope,menu_check_strictly,dept_check_strictly,status,del_flag,create_by,create_time,remark)
| VALUES
| (1,'系统管理员','admin',1,'1',1,1,'0','0','admin',NOW(),'拥有全部系统权限'),
| (2,'普通用户','common',2,'2',1,1,'0','0','admin',NOW(),'业务、采购和项目日常操作'),
| (3,'客户角色','customer',3,'5',1,1,'0','0','admin',NOW(),'仅访问客户门户');
|
| DELETE FROM sys_dept;
| INSERT INTO sys_dept
| (dept_id,parent_id,ancestors,dept_name,order_num,leader,status,del_flag,create_by,create_time,dept_nick)
| VALUES
| (100,0,'0','工作室',1,'管理员账号','0','0','admin',NOW(),'工作室'),
| (101,100,'0,100','综合管理部',1,'管理员账号','0','0','admin',NOW(),'综合'),
| (102,100,'0,100','项目部',2,'普通用户','0','0','admin',NOW(),'项目');
|
| INSERT INTO sys_user_role(user_id,role_id) VALUES (1,1),(2,2),(3,3);
| INSERT INTO sys_user_dept(user_id,dept_id,create_user,create_time)
| VALUES (1,100,1,NOW()),(2,102,1,NOW()),(3,100,1,NOW());
| INSERT INTO sys_role_dept(role_id,dept_id) VALUES (1,100),(1,101),(1,102),(2,102),(3,100);
|
| -- 岗位在当前项目流程中没有独立业务作用:清空岗位并从菜单中移除。
| DELETE FROM sys_post;
|
| -- 2. 菜单:只保留当前项目实际使用的业务菜单和精简后的系统管理。
| INSERT INTO sys_menu
| (menu_id,menu_name,parent_id,order_num,path,component,query,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark)
| VALUES
| (2390,'采购审批',2053,4,'purchaseApproval','collaborativeApproval/approvalProcess/index5',NULL,'PurchaseApproval',1,0,'C','0','0','approval:purchase:list','clipboard','admin',NOW(),'按审批流程配置逐级审批采购单')
| ON DUPLICATE KEY UPDATE menu_name=VALUES(menu_name),parent_id=VALUES(parent_id),order_num=VALUES(order_num),
| path=VALUES(path),component=VALUES(component),route_name=VALUES(route_name),visible='0',status='0',perms=VALUES(perms),icon=VALUES(icon);
|
| DELETE FROM sys_menu
| WHERE menu_id NOT IN (
| 1,100,101,102,103,105,108,500,501,
| 1000,1001,1002,1003,1004,1005,1006,
| 1007,1008,1009,1010,1011,
| 1012,1013,1014,1015,
| 1016,1017,1018,1019,
| 1025,1026,1027,1028,1029,
| 1039,1040,1041,1042,1043,1044,1045,
| 2053,2370,2371,2293,2390,
| 2010,2001,2362,2363,2364,2365,2366,2367,2368,
| 2372,2011,2360,2361,
| 2015,2016,
| 2276,2285,2373,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2388,
| 2374,2375,2386,2387,
| 2357,2358,2359
| );
|
| UPDATE sys_menu SET visible='0',status='0';
| UPDATE sys_menu SET order_num=1 WHERE menu_id=2053;
| UPDATE sys_menu SET order_num=2 WHERE menu_id=2010;
| UPDATE sys_menu SET order_num=3 WHERE menu_id=2372;
| UPDATE sys_menu SET order_num=4 WHERE menu_id=2015;
| UPDATE sys_menu SET order_num=5 WHERE menu_id=2276;
| UPDATE sys_menu SET order_num=6 WHERE menu_id=2374;
| UPDATE sys_menu SET order_num=7 WHERE menu_id=1;
| UPDATE sys_menu SET order_num=8 WHERE menu_id=2357;
| UPDATE sys_menu SET menu_name='审批流程配置' WHERE menu_id=2293;
| UPDATE sys_menu SET menu_name='采购管理' WHERE menu_id=2015;
| UPDATE sys_menu SET menu_name='采购台账' WHERE menu_id=2016;
| UPDATE sys_menu SET menu_name='项目列表' WHERE menu_id=2285;
|
| -- 管理员拥有全部保留菜单。
| INSERT INTO sys_role_menu(role_id,menu_id) SELECT 1,menu_id FROM sys_menu;
|
| -- 普通用户:行政申请/审批、客户、业务、采购、项目、政策文件。
| INSERT INTO sys_role_menu(role_id,menu_id)
| SELECT 2,menu_id FROM sys_menu WHERE menu_id IN (
| 2053,2370,2371,2390,
| 2010,2001,2367,2368,
| 2372,2011,2360,2361,
| 2015,2016,
| 2276,2285,2373,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2388,
| 2374,2375,2386,2387
| );
|
| -- 客户角色:只开放客户资料入口。
| INSERT INTO sys_role_menu(role_id,menu_id)
| SELECT 3,menu_id FROM sys_menu WHERE menu_id IN (2357,2358,2359);
|
| -- 3. 字典:删除无关制造业历史字典,保留系统字典并增加当前项目选择项。
| DELETE FROM sys_dict_data;
| DELETE FROM sys_dict_type;
|
| INSERT INTO sys_dict_type(dict_id,dict_name,dict_type,status,create_by,create_time,remark) VALUES
| (1,'用户性别','sys_user_sex','0','admin',NOW(),'系统字典'),
| (2,'菜单显示状态','sys_show_hide','0','admin',NOW(),'系统字典'),
| (3,'系统启用状态','sys_normal_disable','0','admin',NOW(),'系统字典'),
| (4,'是否选项','sys_yes_no','0','admin',NOW(),'系统字典'),
| (5,'操作类型','sys_oper_type','0','admin',NOW(),'日志字典'),
| (6,'通用状态','sys_common_status','0','admin',NOW(),'系统字典'),
| (7,'税率','tax_rate','0','admin',NOW(),'业务采购通用'),
| (8,'项目来源','project_source','0','admin',NOW(),'项目管理'),
| (9,'项目阶段','project_phase','0','admin',NOW(),'项目管理'),
| (10,'项目跟进周期','project_follow_cycle','0','admin',NOW(),'项目管理'),
| (11,'项目资料类型','project_material_type','0','admin',NOW(),'项目管理'),
| (12,'通用审批状态','approval_status','0','admin',NOW(),'采购及协同审批'),
| (13,'业务审批状态','business_approval_status','0','admin',NOW(),'业务管理'),
| (14,'财务报表审批状态','financial_report_status','0','admin',NOW(),'客户管理'),
| (15,'客户等级','customer_level','0','admin',NOW(),'客户管理'),
| (16,'政策级别','policy_level','0','admin',NOW(),'政府政策文件');
|
| INSERT INTO sys_dict_data
| (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,remark)
| VALUES
| (1,'男','0','sys_user_sex','','','N','0','admin',NOW(),''),(2,'女','1','sys_user_sex','','','N','0','admin',NOW(),''),(3,'未知','2','sys_user_sex','','info','Y','0','admin',NOW(),''),
| (1,'显示','0','sys_show_hide','','primary','Y','0','admin',NOW(),''),(2,'隐藏','1','sys_show_hide','','info','N','0','admin',NOW(),''),
| (1,'正常','0','sys_normal_disable','','success','Y','0','admin',NOW(),''),(2,'停用','1','sys_normal_disable','','danger','N','0','admin',NOW(),''),
| (1,'是','Y','sys_yes_no','','success','N','0','admin',NOW(),''),(2,'否','N','sys_yes_no','','info','Y','0','admin',NOW(),''),
| (0,'其他','0','sys_oper_type','','info','N','0','admin',NOW(),''),(1,'新增','1','sys_oper_type','','success','N','0','admin',NOW(),''),(2,'修改','2','sys_oper_type','','primary','N','0','admin',NOW(),''),(3,'删除','3','sys_oper_type','','danger','N','0','admin',NOW(),''),(5,'导出','5','sys_oper_type','','warning','N','0','admin',NOW(),''),(6,'导入','6','sys_oper_type','','warning','N','0','admin',NOW(),''),
| (1,'正常','0','sys_common_status','','success','Y','0','admin',NOW(),''),(2,'停用','1','sys_common_status','','danger','N','0','admin',NOW(),''),
| (1,'0%','0','tax_rate','','info','N','0','admin',NOW(),''),(2,'1%','1','tax_rate','','','N','0','admin',NOW(),''),(3,'3%','3','tax_rate','','','N','0','admin',NOW(),''),(4,'6%','6','tax_rate','','','N','0','admin',NOW(),''),(5,'9%','9','tax_rate','','','N','0','admin',NOW(),''),(6,'13%','13','tax_rate','','primary','Y','0','admin',NOW(),''),
| (1,'手动创建','MANUAL','project_source','','primary','Y','0','admin',NOW(),''),(2,'业务生成','BUSINESS','project_source','','success','N','0','admin',NOW(),''),
| (1,'未开始','未开始','project_phase','','info','Y','0','admin',NOW(),''),(2,'立项','立项','project_phase','','warning','N','0','admin',NOW(),''),(3,'开发','开发','project_phase','','primary','N','0','admin',NOW(),''),(4,'申报','申报','project_phase','','warning','N','0','admin',NOW(),''),(5,'申报结果','申报结果','project_phase','','success','N','0','admin',NOW(),''),(6,'验收','验收','project_phase','','success','N','0','admin',NOW(),''),(7,'已完成','已完成','project_phase','','success','N','0','admin',NOW(),''),
| (1,'每月','MONTHLY','project_follow_cycle','','','Y','0','admin',NOW(),''),(2,'每季度','QUARTERLY','project_follow_cycle','','','N','0','admin',NOW(),''),(3,'每年','YEARLY','project_follow_cycle','','','N','0','admin',NOW(),''),
| (1,'立项资料','INITIATION','project_material_type','','','N','0','admin',NOW(),''),(2,'开发资料','DEVELOPMENT','project_material_type','','','N','0','admin',NOW(),''),(3,'申报资料','APPLICATION','project_material_type','','','N','0','admin',NOW(),''),(4,'验收资料','ACCEPTANCE','project_material_type','','','N','0','admin',NOW(),''),(5,'其他','OTHER','project_material_type','','info','Y','0','admin',NOW(),''),
| (0,'草稿','0','approval_status','','info','Y','0','admin',NOW(),''),(1,'待审批','1','approval_status','','warning','N','0','admin',NOW(),''),(2,'审批中','2','approval_status','','primary','N','0','admin',NOW(),''),(3,'已通过','3','approval_status','','success','N','0','admin',NOW(),''),(4,'已驳回','4','approval_status','','danger','N','0','admin',NOW(),''),
| (0,'草稿','0','business_approval_status','','info','Y','0','admin',NOW(),''),(1,'待审批','1','business_approval_status','','warning','N','0','admin',NOW(),''),(2,'已通过','2','business_approval_status','','success','N','0','admin',NOW(),''),(3,'已退回','3','business_approval_status','','danger','N','0','admin',NOW(),''),
| (0,'待审批','0','financial_report_status','','warning','Y','0','admin',NOW(),''),(1,'已通过','1','financial_report_status','','success','N','0','admin',NOW(),''),(2,'已退回','2','financial_report_status','','danger','N','0','admin',NOW(),''),
| (1,'重点客户','A','customer_level','','danger','N','0','admin',NOW(),''),(2,'普通客户','B','customer_level','','primary','Y','0','admin',NOW(),''),(3,'潜在客户','C','customer_level','','info','N','0','admin',NOW(),''),
| (1,'国家级','NATIONAL','policy_level','','danger','N','0','admin',NOW(),''),(2,'省级','PROVINCE','policy_level','','warning','N','0','admin',NOW(),''),(3,'市级','CITY','policy_level','','primary','Y','0','admin',NOW(),''),(4,'区县级','DISTRICT','policy_level','','info','N','0','admin',NOW(),'');
|
| -- 采购审批默认配置管理员为第一级审批人,后续可在“审批流程配置”中调整。
| DELETE FROM approve_process_config_node WHERE approve_type=5;
| INSERT INTO approve_process_config_node
| (approve_type,node_order,approver_id,approver_name,timeout_hours,tenant_id,create_user,create_time,delete_flag,dept_id)
| VALUES (5,1,1,'管理员账号',24,208,1,NOW(),0,100);
|
| -- 4. 日志从当前项目正式版本重新开始记录。
| DELETE FROM sys_oper_log;
| DELETE FROM sys_logininfor;
|
| COMMIT;
| SET FOREIGN_KEY_CHECKS = 1;
|
|