# 1. 上传流程图
流程图存放在*soeasycenter-bpmn-respository* (opens new window) 项目中，目前西安交通大学目录下的ac文件中有流程图
# 2.菜单权限
# 3.角色权限
# 4.新增资源sql（需要把all替换成部署高校的COLLEGE_ID）：
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('05ff788dfdca4cc9a19afa07565112a4', '设备秘书办理', '/acMgr/approveScAc', 'M', '9bc81bae973f4182ae71f4fd9f13b730', 'ALL', 'C', NULL, NULL, 1, 1, NULL, '验收', '1', '[]', 'acMgr:approveScAc:list', '2022-11-21 14:24:00', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'N', 'N', '2022-11-21 14:51:42', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('548a4871f7cd440681b2ba15c3a27e4c', '历史验收', '/acMgr/acHistory', 'M', '9bc81bae973f4182ae71f4fd9f13b730', 'ALL', 'C', NULL, NULL, 4, 1, NULL, '验收', '1', '[]', 'acMgr:acHistory:list', '2022-11-07 15:30:34', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'N', 'N', '2022-11-21 14:49:48', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('2880494176114f1fb87b6374e04739cd', '验收审批', '/acMgr/approveAc', 'M', '9bc81bae973f4182ae71f4fd9f13b730', 'ALL', 'C', NULL, NULL, 3, 1, NULL, '验收', '1', '[]', 'acMgr:approveAc:list', '2022-11-07 15:29:15', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'N', 'N', '2022-11-21 14:25:38', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('c5ab5fb2c13b4210b3d6788ba6c239f2', '组织验收', '/acMgr/orgAc', 'M', '9bc81bae973f4182ae71f4fd9f13b730', 'ALL', 'C', NULL, NULL, 2, 1, NULL, '验收', '1', '[]', 'acMgr:orgAc:list', '2022-11-21 14:25:20', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'N', 'N', '2022-11-21 14:25:20', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
我的验收菜单需要注意父ID 改成已有我的验收菜单的父ID，如果没的话需要新建一个我的验收，我的验收父级菜单sql如下：
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('70e8e31852e8475cb7039cf3c49935e0', '我的验收', '/myAccept', 'M', NULL, 'ALL', 'C', NULL, NULL, 108, 1, NULL, '验收', '1', '[]', 'myAccept', '2021-09-16 16:39:03', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-05-31 15:03:56', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
我的验收子菜单sql如下
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('29cf8161ea6a4eaab14ea29f06187523', '我的验收', '/myAccept/acceptNew', 'M', '70e8e31852e8475cb7039cf3c49935e0', 'ALL', 'C', NULL, NULL, 1, 1, NULL, '验收', '1', '[]', 'ac🉑list', '2022-11-16 17:26:30', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'N', 'N', '2022-11-16 17:26:30', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
INSERT INTO co_resource(RESOURCE_ID, RESOURCE_NAME, RESOURCE_PATH, RESOURCE_TYPE, P_RESOURCE_ID, COLLEGE_ID, PT_TYPE, REQUEST_API, OP_CODE, ORDER_NUM, RESOURCE_LEVEL, NAVTAB_NAME, REMARK, IS_SHOW, TARGET_PROCEES, PERMISSION_CODE, CREATE_TIME, CREATE_USERID, CREATE_USERNAME, IS_DX_CENTER, IS_DX_COLLEGE, LAST_UPDATE_TIME, LAST_UPDATE_USERID, LAST_UPDATE_USERNAME) VALUES ('9bc81bae973f4182ae71f4fd9f13b730', '验收管理', '/acMgr', 'M', NULL, 'ALL', 'C', NULL, NULL, 1, 1, NULL, '验收', '1', '[]', 'acMgr', '2022-11-07 15:27:50', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-11-07 15:27:50', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');
# 5.更新co_order_detail的sql如下：
ALTER TABLE co_order_detail ADD COLUMN ACCEPTANCE_STATUS varchar(8) NULL COMMENT '设备验收状态：0 待验收 1 验收中 2 通过 3 不通过 4 终止待确认 5 终止' AFTER STATUS;