soeasycenter-guide

# 1. 上传流程图

img

流程图存放在*soeasycenter-bpmn-respository* (opens new window) 项目中，目前西安交通大学目录下的reagent文件中有流程图

# 2. 菜单权限

img

# 3. 角色权限

img

# 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 ('e35a847f62224d068ba533c14019dd20', '总台账', '/consumables/consumablesStock', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/consumables', 5, 1, NULL, '库存管理', '1', '[]', 'consumables:stock:list', '2022-12-20 09:52:01', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-21 16:58:14', '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 ('220d7a5374ba4955b36a2a31de1156bc', '总台账', '/reagent/stock', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 5, 1, NULL, '库存管理', '1', '[]', 'reagent:stock:list', '2022-12-08 10:13:45', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-21 16:57:53', '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 ('0f1998550ee4428f8f5daa3abe4bf29b', '台账', '/reagent/reagentAccount', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 5, 1, NULL, '库存管理', '1', '[]', 'reagent:account:list', '2022-12-20 09:54:01', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 10:15:46', '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 ('296a5eeacde24706868114794450728d', '台账', '/consumables/consumablesAccount', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/consumables', 5, 1, NULL, '库存管理', '1', '[]', 'consumables:account:list', '2022-12-20 09:53:20', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:53:20', '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 ('36971eabe6df445f8f8ababf769b4648', '领用确认', '/consumables/consumablesCollectConfirm', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/consumables', 4, 1, NULL, '领用确认', '1', '[]', 'consumables:collectConfirm:list', '2022-12-20 09:50:57', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:50:57', '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 ('cbbf1073291e441988e935c7b79342eb', '入库确认', '/consumables/consumablesWarehousingConfirm', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/consumables', 3, 1, NULL, '入库确认', '1', '[]', 'consumables:warehousingConfirm:list', '2022-12-20 09:50:25', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:50:25', '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 ('12462e157a3344d2a365336b7e0624b2', '申请领用', '/consumables/consumablesCollect', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/consumables', 2, 1, NULL, '申请领用', '1', '[]', 'consumables:collect:list', '2022-12-20 09:46:08', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:46:08', '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 ('1a349e93bd384776955dbbf1837e96c4', '试剂管理', '/reagent', 'M', NULL, 'ALL', 'C', NULL, NULL, 1, 1, NULL, '招标管理', '1', '[]', 'reagent', '2022-12-07 15:20:27', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:45:03', '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 ('d4d2ea9656594d9bbce1044386748167', '申请入库', '/consumables/consumablesWarehousing', 'M', '427e0674c1664de0bf90effe05758452', 'ALL', 'C', NULL, '/reagent', 1, 1, NULL, '申请入库', '1', '[]', 'consumables:warehousing:list', '2022-12-20 09:33:10', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:33:10', '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 ('427e0674c1664de0bf90effe05758452', '耗材管理', '/consumables', 'M', NULL, 'ALL', 'C', NULL, NULL, 1, 1, NULL, '招标管理', '1', '[]', 'consumables', '2022-12-20 09:32:25', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-20 09:32:25', '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 ('1473173a34344da18bf55aa6f59b1e2c', '领用确认', '/reagent/collectConfirm', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 4, 1, NULL, '领用确认', '1', '[]', 'reagent:collectConfirm:list', '2022-12-08 10:13:19', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-08 10:13:19', '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 ('4004b6c3ebcb47d4a7b871fe3dece5aa', '入库确认', '/reagent/warehousingConfirm', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 3, 1, NULL, '入库确认', '1', '[]', 'reagent:warehousingConfirm:list', '2022-12-08 10:12:53', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-08 10:12:53', '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 ('148d1ee163ba433891cf73a2aba3d397', '申请领用', '/reagent/collect', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 2, 1, NULL, '申请领用', '1', '[]', 'reagent:collect:list', '2022-12-08 10:07:38', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-08 10:07: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 ('a143c7935eab434495229b9420f216aa', '申请入库', '/reagent/warehousing', 'M', '1a349e93bd384776955dbbf1837e96c4', 'ALL', 'C', NULL, '/reagent', 1, 1, NULL, '申请入库', '1', '[]', 'reagent:warehousing:list', '2022-12-08 09:26:03', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123', 'Y', 'Y', '2022-12-08 09:26:34', '08dbff9e85204c7be05dbf40ebf4e2f9', '超级管理员123');

# 5.更新co_order_detail的sql如下：

ALTER TABLE co_order_detail ADD COLUMN REAGENT_STATUS varchar(8) NULL COMMENT '入库状态（0：待入库 1：进入入库系统）' AFTER ACCEPTANCE_STATUS;

Last Updated: 1/13/2023, 5:18:25 PM