项目管理方案

<h1>PostgresSQL建表语句</h1> <h2>BasicProject</h2> <pre><code class="language-sql">DROP TABLE IF EXISTS "public"."BasicProject"; CREATE TABLE "BasicProject"( "uuid" VARCHAR(36) NOT NULL, "number" VARCHAR(50), "name" VARCHAR(100), "constructionDate" BIGINT, "type" VARCHAR(20), "level" VARCHAR(20), "budget" VARCHAR(20), "department" VARCHAR(30), "partner" VARCHAR(36), "desc" TEXT, "descAttach" TEXT, "projectState" VARCHAR(10), "projectChange" TEXT, "changeReason" TEXT, "projectConclusion" VARCHAR(50), "endDate" VARCHAR(30), "endDesc" TEXT, "endAttach" TEXT, "schedule" INT, "progress" float4, "projectApproval" VARCHAR(36), "projectWeekReport" TEXT, "leader" varchar(36), "leaderName" varchar(50), "members" TEXT, "membersName" TEXT, "queryDepartment" TEXT, "queryRole" TEXT, "departmentLeaderRead" BOOLEAN, "directLeaderRead" BOOLEAN, "createTime" VARCHAR(30), "updateTime" VARCHAR(30), "state" INT, "departmentLeader" varchar(255), "directLeader" varchar(255), PRIMARY KEY (uuid) ); COMMENT ON COLUMN "BasicProject"."number" IS '项目编号'; COMMENT ON COLUMN "BasicProject"."name" IS '项目名称'; COMMENT ON COLUMN "BasicProject"."constructionDate" IS '建项日期'; COMMENT ON COLUMN "BasicProject"."type" IS '项目类型'; COMMENT ON COLUMN "BasicProject"."level" IS '项目级别'; COMMENT ON COLUMN "BasicProject"."budget" IS '项目预算'; COMMENT ON COLUMN "BasicProject"."department" IS '部门'; COMMENT ON COLUMN "BasicProject"."partner" IS '供应商'; COMMENT ON COLUMN "BasicProject"."desc" IS '项目简介'; COMMENT ON COLUMN "BasicProject"."descAttach" IS '简介附件'; COMMENT ON COLUMN "BasicProject"."projectState" IS '项目状态'; COMMENT ON COLUMN "BasicProject"."projectChange" IS '项目变更工单'; COMMENT ON COLUMN "BasicProject"."changeReason" IS '变更原因'; COMMENT ON COLUMN "BasicProject"."projectConclusion" IS '项目结项工单'; COMMENT ON COLUMN "BasicProject"."endDate" IS '结项时间'; COMMENT ON COLUMN "BasicProject"."endDesc" IS '结项备注'; COMMENT ON COLUMN "BasicProject"."endAttach" IS '结项附件'; COMMENT ON COLUMN "BasicProject"."schedule" IS '总工期天数所有阶段相加'; COMMENT ON COLUMN "BasicProject"."progress" IS '总进度（阶段1工期*进度+阶段2工期*进度+N）/项目总工期'; COMMENT ON COLUMN "BasicProject"."projectApproval" IS '项目申请工单'; COMMENT ON COLUMN "BasicProject"."projectWeekReport" IS '项目周报工单'; COMMENT ON COLUMN "BasicProject"."leader" IS '项目负责人'; COMMENT ON COLUMN "BasicProject"."leaderName" IS '项目负责人名字'; COMMENT ON COLUMN "BasicProject"."members" IS '项目成员'; COMMENT ON COLUMN "BasicProject"."membersName" IS '项目成员名字'; COMMENT ON COLUMN "BasicProject"."queryDepartment" IS '可阅部门'; COMMENT ON COLUMN "BasicProject"."queryRole" IS '可阅角色'; COMMENT ON COLUMN "BasicProject"."departmentLeaderRead" IS '部门领导是否可阅'; COMMENT ON COLUMN "BasicProject"."directLeaderRead" IS '直属领导是否可阅'; COMMENT ON COLUMN "BasicProject"."createTime" IS '创建时间'; COMMENT ON COLUMN "BasicProject"."updateTime" IS '更新时间'; COMMENT ON COLUMN "BasicProject"."state" IS '状态'; COMMENT ON COLUMN "public"."BasicProject"."departmentLeader" IS '部门领导'; COMMENT ON COLUMN "public"."BasicProject"."directLeader" IS '直属领导';</code></pre> <h2>BasicProjectStage</h2> <pre><code class="language-sql">DROP TABLE IF EXISTS "BasicProjectStage"; CREATE TABLE "BasicProjectStage" ( "uuid" varchar(36) NOT NULL, "name" varchar(50) NOT NULL, "stage" varchar(50) NOT NULL, "content" text , "progress" float4, "startTime" BIGINT, "endTime" BIGINT, "sort" int4, "participants" text , "participantsName" text , "createTime" varchar(50) , "updateTime" varchar(50) , "state" int4, PRIMARY KEY(uuid) ) ; COMMENT ON COLUMN "BasicProjectStage"."name" IS '阶段名称'; COMMENT ON COLUMN "BasicProjectStage"."stage" IS '阶段名称'; COMMENT ON COLUMN "BasicProjectStage"."content" IS '阶段内容'; COMMENT ON COLUMN "BasicProjectStage"."progress" IS '阶段进度'; COMMENT ON COLUMN "BasicProjectStage"."startTime" IS '阶段开始时间'; COMMENT ON COLUMN "BasicProjectStage"."endTime" IS '阶段结束时间'; COMMENT ON COLUMN "BasicProjectStage"."sort" IS '排序'; COMMENT ON COLUMN "BasicProjectStage"."participants" IS '阶段参与人'; COMMENT ON COLUMN "BasicProjectStage"."participants" IS '阶段参与人名字'; </code></pre> <h2>BasicProjectPermission</h2> <pre><code class="language-sql">DROP TABLE IF EXISTS "public"."BasicProjectPermission"; CREATE TABLE "public"."BasicProjectPermission" ( "uuid" VARCHAR(36) NOT NULL, "projects" text, "projectNames" text, "queryRole" text, "queryDepartment" text, "departmentLeaderRead" BOOLEAN, "directLeaderRead" BOOLEAN, "createTime" text, "updateTime" text, "state" int4, PRIMARY KEY(uuid) ); COMMENT ON COLUMN "BasicProjectPermission"."projects" IS '项目Uuid'; COMMENT ON COLUMN "BasicProjectPermission"."projectNames" IS '项目名称'; COMMENT ON COLUMN "BasicProjectPermission"."queryRole" IS '可阅角色'; COMMENT ON COLUMN "BasicProjectPermission"."queryDepartment" IS '可阅部门'; COMMENT ON COLUMN "BasicProjectPermission"."departmentLeaderRead" IS '是否项目负责人部门领导可阅'; COMMENT ON COLUMN "BasicProjectPermission"."directLeaderRead" IS '是否项目负责人直属领导可阅';</code></pre> <h2>BasicProjectChangeHistory</h2> <pre><code class="language-sql">DROP TABLE IF EXISTS "public"."BasicProjectChangeHistory"; CREATE TABLE "public"."BasicProjectChangeHistory" ( "uuid" varchar(36) NOT NULL, "name" varchar(50), "workNumber" VARCHAR(50), "applyTime" VARCHAR(50), "applyUser" VARCHAR(50), "processInstId" VARCHAR(50), "projectUuid" VARCHAR(50), "historyList" TEXT, "createTime" text, "updateTime" text, "state" int4, PRIMARY KEY(uuid) ); COMMENT ON COLUMN "BasicProjectChangeHistory"."workNumber" IS '项目变更工单编号'; COMMENT ON COLUMN "BasicProjectChangeHistory"."applyTime" IS '项目变更申请时间'; COMMENT ON COLUMN "BasicProjectChangeHistory"."applyUser" IS '项目变更申请人'; COMMENT ON COLUMN "BasicProjectChangeHistory"."processInstId" IS '项目变更processInstId'; COMMENT ON COLUMN "BasicProjectChangeHistory"."projectUuid" IS '项目uuid'; COMMENT ON COLUMN "BasicProjectChangeHistory"."historyList" IS '变更详情';</code></pre> <h2>BasicProjectStageRelationship</h2> <pre><code class="language-sql">DROP TABLE IF EXISTS "BasicProjectStageRelationship"; CREATE TABLE "BasicProjectStageRelationship" ( "uuid" VARCHAR(36) NOT NULL, "in_" VARCHAR(50) NOT NULL, "out_" VARCHAR(50) NOT NULL, "in_Class" VARCHAR(100), "out_Class" VARCHAR(100), "properties" text, "group_" text, "group_Class" text, "createTime" VARCHAR(50), "updateTime" VARCHAR(50), "state" INT, PRIMARY KEY(uuid) );</code></pre> <h1>网关</h1> <pre><code class="language-sql">--DELETE FROM "BasicGatewayRoute" WHERE sourcepath like '%project%'; INSERT INTO "BasicGatewayRoute" VALUES ('a3171220-e3ba-43ad-9e0f-4ad46ecfdfd4', '项目列表', '/ops/itsm/project/getProjectList', 'itsm', NULL, 'ItsmGetProjectListScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('ff0b8b04-bb03-4102-85b9-6b9f06c50747', '个人所属未结项项目', '/ops/itsm/project/getUnCloseProjectByLeader', 'itsm', NULL, 'ItsmGetUnCloseProjectByLeaderScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('f40a96b5-1c86-4b39-87f8-da495c67c47f', '项目详情', '/ops/itsm/project/getProjectByUuid', 'itsm', NULL, 'ItsmGetProjectByUuidScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('21dc6d85-7419-42dd-9f16-7022a7919e69', '项目关联标签页列表', '/ops/itsm/project/getProjectRelationList', 'itsm', NULL, 'ItsmGetProjectRelationListScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('dbbe7930-bef7-4277-8c19-710568336af7', '项目变更历史', '/ops/itsm/project/getProjectChangeHistory', 'itsm', NULL, 'ItsmGetProjectChangeHistoryScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('74de216f-f057-402f-b9ec-37947f8997fd', '甘特图', '/ops/itsm/project/getProjectGanttChart', 'itsm', NULL, 'ItsmGetProjectGanttChartScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('932ef3bd-65ec-4121-bd62-8e983bf07ba2', '项目下拉（有权限）', '/ops/itsm/project/getProjectSelectList', 'itsm', NULL, 'ItsmGetProjectSelectListScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('924ef52a-7267-41d6-af8b-18ae77da72ad', '项目下拉（无权限）', '/ops/itsm/project/getAllProjectSelectList', 'itsm', NULL, 'ItsmGetAllProjectSelectListScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('74e08531-7642-4f57-8ff1-9270665ea1eb', '项目权限列表', '/ops/itsm/project/getProjectPermissionList', 'itsm', NULL, 'ItsmGetProjectPermissionListScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('abbdff9b-4c7d-4063-b3a9-7235af2a2d7c', '获取项目权限', '/ops/itsm/project/getProjectPermission', 'itsm', NULL, 'ItsmGetProjectPermissionScript', '查询', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('d4fdfa81-55b4-41de-a6dc-ef3c06ac0be3', '保存项目权限', '/ops/itsm/project/saveProjectPermission', 'itsm', NULL, 'ItsmSaveProjectPermissionScript', '操作', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('728e249b-eaa3-42f8-a3ed-1aaa05c69591', '删除项目权限', '/ops/itsm/project/deleteProjectPermission', 'itsm', NULL, 'ItsmDeleteProjectPermissionScript', '操作', NULL, NULL, NULL, NULL, NULL, 0, NULL, 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('7dc7609376164ed1bed77eba6121adce', '新增项目', '/ops/itsm/project/saveProject', NULL, NULL, 'ItsmSaveProjectScript', '操作', '新增项目', '', '', '', '2021-02-03 11:20:45', 0, '2021-02-03 11:20:45', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('215fcbac560049338425d590cbb7375f', '更新项目', '/ops/itsm/project/updateProject', NULL, NULL, 'ItsmUpdateProjectScript', '操作', '更新项目', '', '', '', '2021-02-03 11:20:57', 0, '2021-02-03 11:20:57', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('563832e64d8e41d3985cf7a2fa9f863f', '关闭项目', '/ops/itsm/project/closeProject', NULL, NULL, 'ItsmCloseProjectScript', '操作', '关闭项目', '', '', '', '2021-02-03 11:21:49', 0, '2021-02-03 11:21:49', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('5f7859737e27418aa156f5c4e3fc1b05', '项目列表', '/ops/itsm/project/getProjectList', NULL, NULL, 'ItsmGetProjectListScript', '查询', '项目列表', '', '', '', '2021-02-03 11:22:01', 0, '2021-02-03 11:22:01', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('35a2cb2b599143c0a035d2ce676177f8', '校验项目名称唯一性', '/ops/itsm/project/checkProjectName', NULL, NULL, 'ItsmCheckProjectNameScript', '操作', '校验项目名称唯一性', '', '', '', '2021-02-03 11:22:12', 0, '2021-02-03 11:22:12', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); INSERT INTO "BasicGatewayRoute" VALUES ('a946a7b98c4d40e99e0a4fa1f273585d', '更新项目阶段', '/ops/itsm/project/updateProjectStageProgress', NULL, NULL, 'ItsmUpdateProjectStageProgressScript', '操作', '更新项目阶段', '', '', '', '2021-02-03 11:22:23', 0, '2021-02-03 11:22:23', 't', 'script', 'fc956e4f5af54ad2af454ec352cea19b'); </code></pre> <h1>工单编号</h1> <pre><code class="language-sql">INSERT INTO "dvd_auto_code" VALUES ('f25690cc-188a-2820-bda3-e86fa5255ff2', '3', 'XMBG-${CURDATE}-${1F}', '日', '1', '2021-03-16 19:32:45', 'XMBG', '0', '[项目变更申请编号]', '202109158', '2021-05-25 19:41:08'); INSERT INTO "dvd_auto_code" VALUES ('a035487b-2273-9c67-80a1-4fd0cb7fc84b', '3', 'XMZB-${CURDATE}-${1F}', '日', '1', '2021-03-16 19:33:28', 'XMZB', '0', '[项目周报编号]', '202109158', '2021-09-16 10:40:11'); INSERT INTO "dvd_auto_code" VALUES ('411106be-e233-bcb0-e3be-355351aaeac0', '3', 'XMCYZB-${CURDATE}-${1F}', '日', '1', '2021-03-16 19:33:51', 'XMCYZB', '0', '[项目成员周报编号]', '202109158', '2021-06-25 10:54:54'); INSERT INTO "dvd_auto_code" VALUES ('df0cc8e3-5cb2-1718-51ad-5dacccc62001', '3', 'XMJX-${CURDATE}-${1F}', '日', '1', '2021-03-16 19:33:09', 'XMJX', '0', '[项目结项编号]', '202109158', '2021-06-25 13:18:25'); INSERT INTO "dvd_auto_code" VALUES ('68bf1556-4d9c-17d8-fd20-6765b3dbcf65', '3', 'XMSQ-${CURDATE}-${1F}', '日', '1', '2021-03-16 19:32:22', 'XMSQ', '0', '[项目申请编号]', '202109158', '2021-07-27 11:59:31'); </code></pre> <h1>菜单</h1> <ol> <li>项目总览列表路由：projectTotalView</li> <li>项目总体视图路由：projectGantt</li> <li>项目详情信息路由：projectDetailView 设置为隐藏</li> <li>项目总览权限设置路由：projectRole</li> </ol> <h1>接口</h1> <h2>1.新增项目接口</h2> 地址：itsm/project/saveProject 脚本：ItsmSaveProjectScript 参数： <pre><code class="language-json">{ "leader": "12d1ebb803764348a89d10c9e3019d29", "level": "三级", "projectStageList": [{ "stage": "项目立项", "startTime": "2020-12-01 00:00:00", "endTime": "2020-12-04 00:00:00", "content": "1", "participants": ["ba70c54b021c45f490a1198c0c64bf76", "12d1ebb803764348a89d10c9e3019d29"] }, { "stage": "项目启动与计划", "startTime": "2020-12-07 00:00:00", "endTime": "2020-12-11 00:00:00", "content": "2", "participants": ["6b630c6c86cd4983bb654a10fba5f619", "12d1ebb803764348a89d10c9e3019d29", "ba70c54b021c45f490a1198c0c64bf76"] }, { "stage": "项目实施", "startTime": "2020-12-14 00:00:00", "endTime": "2020-12-18 00:00:00", "content": "6", "participants": ["6b630c6c86cd4983bb654a10fba5f619", "533e6c8829554c5696931e8de00e80ee", "12d1ebb803764348a89d10c9e3019d29"] }, { "stage": "项目验收", "startTime": "2020-12-21 00:00:00", "endTime": "2020-12-25 00:00:00", "content": "34", "participants": ["533e6c8829554c5696931e8de00e80ee"] }, { "stage": "项目结项", "startTime": "2020-12-28 00:00:00", "endTime": "2021-01-01 00:00:00", "content": "5", "participants": ["ba70c54b021c45f490a1198c0c64bf76"] }], "type": "重点督办项目", "number": "XMGL2020010", "partner": "", "descAttach": [{ "uid": 1608884068499, "fileName": "项目管理设计v1-实现设计.xlsx", "fileSize": "382698", "name": "项目管理设计v1-实现设计.xlsx", "uuid": "ef443c8b-f79d-4e3c-88b7-fd33c1bad84a", "url": "项目管理设计v1-实现设计.xlsx", "status": "success" }], "members": ["533e6c8829554c5696931e8de00e80ee", "12d1ebb803764348a89d10c9e3019d29", "ba70c54b021c45f490a1198c0c64bf76"], "name": "测试项目5", "department": "产品二部", "constructionDate": 1606752000000, "budget": "800", "desc": "xxxxxxx", "projectApproval": "21a04f5d-4689-11eb-ac55-5254006d7e0f" }</code></pre> 返回 <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": "成功" }, "time": 1631674905765 }</code></pre> <h2>2.项目变更接口</h2> 地址：itsm/project/updateProject 脚本：ItsmUpdateProjectScript 参数： <pre><code class="language-json">{ "number":"XMGL2021008", "name":"项目4", "constructionDate":1612166400000, "leader":"47eb367cd7f94a6f89ab3c7f729ad241", "members":["2c6ba2e7300943319d7a0fd83fd1e586","47eb367cd7f94a6f89ab3c7f729ad241","2dd08762f3fb42baa4e92c6f6e6638ea"], "type":"一般项目", "level":"二级", "budget":"80001", "department":"产品三部", "partner":"", "desc":"ssssss12131231212", "descAttach":[ { "uid":1617870356499, "fileName":"new 1.txt", "size":2063, "fileSize":"2.0", "response":{ "responseBody":{ "fileName":"new 1.txt", "fileSize":"2.0", "uuid":"8ea37379-b7ae-4ad9-b339-b8618463b33a" }, "errorCode":0, "time":1617870357431, "message":"成功" }, "percentage":100, "name":"new 1.txt", "raw":{"uid":1617870356499}, "uuid":"8ea37379-b7ae-4ad9-b339-b8618463b33a", "url":"new 1.txt", "status":"success" } ], "changeReason":"1111", "projectChange":"23e154be-9844-11eb-9963-5254006d7e0f", "projectStageList":[ { "stage":"项目立项", "startTime":1609430400000, "endTime":1613030400000, "content":"12212412", "participants":["2c6ba2e7300943319d7a0fd83fd1e586","47eb367cd7f94a6f89ab3c7f729ad241"] }, { "stage":"项目启动与计划", "startTime":1613289600000, "endTime":1614240000000, "content":"2224412", "participants":["2dd08762f3fb42baa4e92c6f6e6638ea"] }, { "stage":"项目实施", "startTime":1614499200000, "endTime":1615449600000, "content":"32241244124", "participants":["2c6ba2e7300943319d7a0fd83fd1e586","47eb367cd7f94a6f89ab3c7f729ad241"] }, { "stage":"项目验收", "startTime":1615708800000, "endTime":1616860800000, "content":"42242", "participants":["47eb367cd7f94a6f89ab3c7f729ad241"] }, { "stage":"项目结项11", "startTime":1616918400000, "endTime":1619683200000, "content":"1243", "participants":["2c6ba2e7300943319d7a0fd83fd1e586"] } ] }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "成功", "responseBody": null, "time": 1613718775181 }</code></pre> <h2>3.项目结项</h2> 地址：itsm/project/closeProject 脚本： ItsmCloseProjectScript 参数： <pre><code class="language-json">{ "name":"测试", "closureUuid":"763836", "endDate":"2021-09-30", "endDesc":"test", "endAttach":[{"uid":"vc-upload-1631699128365-2","xhr":{},"size":2044,"lastModifiedDate":"2021-09-10T01:34:29.302Z","response":{"responseBody":{"fileName":"BasicProjectStage.sql","fileSize":"2044","uuid":"75e1b26efe0f42fd9a1d39ac761bfeab"},"errorCode":0,"time":1631699142000,"message":"成功"},"name":"BasicProjectStage.sql","lastModified":1631237669302,"type":"","percent":100,"originFileObj":{"uid":"vc-upload-1631699128365-2"},"status":"done"}] }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "time": 1631863354201 }</code></pre> <h2>4.项目列表</h2> 地址：itsm/project/getProjectList 脚本：ItsmGetProjectListScript 参数： <pre><code class="language-json">{ "type":"1", "keyword":"", "page":1, "limit":10 }</code></pre> 返回 <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "result": [ { "currentProgress": "100.0%", "leader": "d22ae15a56394869924059a9d5867a29", "level": "三级", "endDate": "2021-09-30", "projectStageList": [ { "updateTime": "2021-09-15 17:24:44", "sort": 1, "participantsName": "[\"张三514\"]", "uuid": "0e004fced7884953b497433971b3dd52", "content": "2124", "stage": "项目启动与计划", "createTime": "2021-09-15 17:23:51", "name": "项目启动与计划", "progress": 0.0, "startTime": 1630857600000, "endTime": 1631376000000, "state": 0, "participants": "209a67a864784c60af2d18037e70b7eb" }, { "updateTime": "2021-09-15 17:24:44", "sort": 2, "participantsName": "[\"张三560\",\"张三559\"]", "uuid": "46d9ac6780e04d2aa87196b2511aafd6", "content": "3", "stage": "项目实施", "createTime": "2021-09-15 17:23:51", "name": "项目实施", "progress": 0.0, "startTime": 1631462400000, "endTime": 1631980800000, "state": 0, "participants": "1d2cea04b04c46e29473678d3021e3ce,0a829e9fd22c4c27a0d195c2c4b0679d" }, { "updateTime": "2021-09-15 17:24:44", "sort": 3, "participantsName": "[\"张三519\"]", "uuid": "fca4b6d9fe504662875e309856b3cf2d", "content": "455", "stage": "项目验收", "createTime": "2021-09-15 17:23:51", "name": "项目验收", "progress": 0.0, "startTime": 1632067200000, "endTime": 1632585600000, "state": 0, "participants": "cd9bb914c2cc41b9aec43a35ab0feeb9" }, { "updateTime": "2021-09-15 17:24:44", "sort": 4, "participantsName": "[\"张三541\"]", "uuid": "7c0d1710305343d987986ef103124190", "content": "5", "stage": "项目结项", "createTime": "2021-09-15 17:23:51", "name": "项目结项", "progress": 0.0, "startTime": 1632672000000, "endTime": 1633795200000, "state": 0, "participants": "98dc756c88b44875aa18bb01fe2a64b5" }, { "updateTime": "2021-09-15 17:24:44", "sort": 0, "participantsName": "[\"张三512\",\"张三511\"]", "uuid": "20508d816c434493b254fccea76212e9", "content": "14124", "stage": "项目立项", "createTime": "2021-09-15 17:23:51", "name": "项目立项", "progress": 1.0, "startTime": 1630425600000, "endTime": 1630771200000, "state": 0, "participants": "c3443bd48ec2464ba9e55d76e8bd0c2a" } ], "type": "一般项目", "uuid": "d582b8ec85e9445796626f241969564e", "stage": "项目立项", "name": "测试", "progress": "12.5%", "projectWeekReport": "[\"765789\"]", "startTime": 1630425600000, "endTime": 1630771200000, "department": "", "constructionDate": 1629993600000, "budget": "1501万", "participants": "c3443bd48ec2464ba9e55d76e8bd0c2a" } ], "pageInfo": { "total": 1, "limit": 10, "page": 1 } } }, "time": 1631862940024 }</code></pre> <h2>5.项目名称校验</h2> 地址：itsm/project/checkProjectName 脚本：ItsmCheckProjectNameScript 参数： <pre><code class="language-json">{"name":"测试"}</code></pre> 返回：isRepeat为true时重名 <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "isRepeat": true } }, "time": 1631863393426 }</code></pre> <h2>6.更新项目阶段进度</h2> 地址：itsm/project/updateProjectStageProgress 脚本：ItsmUpdateProjectStageProgressScript 参数： <pre><code class="language-json">{ "name":"测试", "stage":"项目立项", "progress":"100", "week_report":"765789" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": {}, "time": 1631864154950 }</code></pre> <h2>7.个人所属未结项项目</h2> 地址：itsm/project/getUnCloseProjectByLeader 脚本：ItsmGetUnCloseProjectByLeaderScript 参数： <pre><code class="language-json">{ "leaderUuid":"12d1ebb803764348a89d10c9e3019d29" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": [ { "label": "测试", "value": "d582b8ec85e9445796626f241969564e" } ] }, "time": 1631864219434 }</code></pre> <h2>8.项目详情</h2> 地址：itsm/project/getProjectByUuid 脚本：ItsmGetProjectByUuidScript 参数： <pre><code class="language-json">{"uuid": "d582b8ec85e9445796626f241969564e"}</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "leader": "d22ae15a56394869924059a9d5867a29", "membersName": "[\"张三520\",\"张三519\"]", "endDate": "2021-09-30", "queryDepartment": "[\"4dfe42348f9f4f7bb3f0dc4d283b0b76\"]", "projectStageList": [ { "updateTime": "2021-09-15 17:24:44", "sort": 0, "participantsName": "[\"张三512\",\"张三511\"]", "uuid": "20508d816c434493b254fccea76212e9", "content": "14124", "stage": "项目立项", "createTime": "2021-09-15 17:23:51", "name": "项目立项", "progress": 100.0, "startTime": 1630425600000, "endTime": 1630771200000, "state": 0, "participants": "c3443bd48ec2464ba9e55d76e8bd0c2a" }, { "updateTime": "2021-09-15 17:24:44", "sort": 1, "participantsName": "[\"张三514\"]", "uuid": "0e004fced7884953b497433971b3dd52", "content": "2124", "stage": "项目启动与计划", "createTime": "2021-09-15 17:23:51", "name": "项目启动与计划", "progress": 0.0, "startTime": 1630857600000, "endTime": 1631376000000, "state": 0, "participants": "209a67a864784c60af2d18037e70b7eb" }, { "updateTime": "2021-09-15 17:24:44", "sort": 2, "participantsName": "[\"张三560\",\"张三559\"]", "uuid": "46d9ac6780e04d2aa87196b2511aafd6", "content": "3", "stage": "项目实施", "createTime": "2021-09-15 17:23:51", "name": "项目实施", "progress": 0.0, "startTime": 1631462400000, "endTime": 1631980800000, "state": 0, "participants": "1d2cea04b04c46e29473678d3021e3ce,0a829e9fd22c4c27a0d195c2c4b0679d" }, { "updateTime": "2021-09-15 17:24:44", "sort": 3, "participantsName": "[\"张三519\"]", "uuid": "fca4b6d9fe504662875e309856b3cf2d", "content": "455", "stage": "项目验收", "createTime": "2021-09-15 17:23:51", "name": "项目验收", "progress": 0.0, "startTime": 1632067200000, "endTime": 1632585600000, "state": 0, "participants": "cd9bb914c2cc41b9aec43a35ab0feeb9" }, { "updateTime": "2021-09-15 17:24:44", "sort": 4, "participantsName": "[\"张三541\"]", "uuid": "7c0d1710305343d987986ef103124190", "content": "5", "stage": "项目结项", "createTime": "2021-09-15 17:23:51", "name": "项目结项", "progress": 0.0, "startTime": 1632672000000, "endTime": 1633795200000, "state": 0, "participants": "98dc756c88b44875aa18bb01fe2a64b5" } ], "projectChange": "[\"763660\"]", "type": "一般项目", "uuid": "d582b8ec85e9445796626f241969564e", "number": "_false", "queryRole": "[\"DeviceAdministratorRole\",\"administratorRole\"]", "descAttach": [], "members": "cd9bb914c2cc41b9aec43a35ab0feeb9,ed76588293714816bb08626ea32f4a81", "state": 0, "department": "", "departmentLeaderRead": true, "budget": "1501万", "directLeaderRead": true, "endDesc": "test", "changeReason": "\r\n-----\r\n124", "level": "三级", "updateTime": "2021-09-17 15:22:34", "projectState": "", "schedule": 40, "partner": "", "endAttach": "[{\"uid\":\"vc-upload-1631699128365-2\",\"xhr\":{},\"size\":2044,\"lastModifiedDate\":\"2021-09-10T01:34:29.302Z\",\"response\":{\"responseBody\":{\"fileName\":\"BasicProjectStage.sql\",\"fileSize\":\"2044\",\"uuid\":\"75e1b26efe0f42fd9a1d39ac761bfeab\"},\"errorCode\":0,\"time\":1631699142000,\"message\":\"成功\"},\"name\":\"BasicProjectStage.sql\",\"lastModified\":1631237669302,\"type\":\"\",\"percent\":100,\"originFileObj\":{\"uid\":\"vc-upload-1631699128365-2\"},\"status\":\"done\"}]", "leaderName": "系统管理员", "createTime": "2021-09-15 17:23:51", "name": "测试", "progress": 12.5, "projectWeekReport": "[\"765789\",\"765789\"]", "projectConclusion": "763836", "constructionDate": 1629993600000, "desc": "1111112344", "projectApproval": "763626" } }, "time": 1631864366548 }</code></pre> <h2>9.项目关联标签页列表</h2> 地址：itsm/project/getProjectRelationList 脚本：ItsmGetProjectRelationListScript 参数： <pre><code class="language-json">{ "projectUuid": "d582b8ec85e9445796626f241969564e", "type": "week", "keyword": "", "page": 1, "limit": 10 }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "result": [ { "readState": "已阅", "handleUser": "", "handleGroup": "", "activityName": "结束", "activityTime": "", "processDesc": "测试-(2021-09-13~2021-09-19)", "completeTimer": "", "uuid": "765740", "handleUserid": "", "workNumber": "[项目周报编号]", "completeTimeout": "false", "processName": "项目周报", "createTime": "2021-09-17 12:00:26", "responseTimer": "", "preUserId": "", "processInstId": "765789", "processKey": "kfw210218180313017", "createUser": "系统管理员", "formData": "{\"next_jobContent\":\"111\",\"nextWeek\":\"2021-09-20~2021-09-26\",\"leader\":{\"label\":\"系统管理员\",\"value\":\"d22ae15a56394869924059a9d5867a29\"},\"last_progress\":\"\",\"curWeek\":\"2021-09-13~2021-09-19\",\"stage_content\":\"14124\",\"stage_startTime\":\"2021-09-01\",\"number\":\"_false\",\"stage_endTime\":\"2021-09-01\",\"members\":{\"label\":\"张三519,张三520\",\"value\":\"cd9bb914c2cc41b9aec43a35ab0feeb9,ed76588293714816bb08626ea32f4a81\"},\"name\":\"测试\",\"current_progress\":\"100\",\"current_stage\":\"项目立项\",\"current_jobContent\":\"111\",\"constructionDate\":1629993600000,\"desc\":\"1111112344\",\"last_stage\":\"\"}", "endTime": "2021-09-17 12:00:40", "applyTime": "2021-09-17 12:00:26", "responseTimeout": "false" } ], "pageInfo": { "total": 1, "limit": 10, "page": 1 } } }, "time": 1631864395236 }</code></pre> <h2>9.项目变更历史</h2> 地址：itsm/project/getProjectChangeHistory 脚本：ItsmGetProjectChangeHistoryScript 参数： <pre><code class="language-json">{ "projectUuid": "d582b8ec85e9445796626f241969564e" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": [ { "applyUser": "系统管理员", "workNumber": "_false", "historyList": "[{\"newValue\":\"2021-08-27\",\"field\":\"建项日期\",\"oldValue\":\"2021-09-01\"},{\"newValue\":[],\"field\":\"项目成员\",\"oldValue\":[\"张三520\",\"张三519\",\"张三521\"]},{\"newValue\":\"一般项目\",\"field\":\"项目类型\",\"oldValue\":\"重点督办项目\"},{\"newValue\":\"三级\",\"field\":\"项目级别\",\"oldValue\":\"一级\"},{\"newValue\":\"1501万\",\"field\":\"项目预算\",\"oldValue\":\"150万\"},{\"newValue\":\"1111112344\",\"field\":\"项目简介\",\"oldValue\":\"11111\"},{\"newValue\":\"\",\"field\":\"简介附件\",\"oldValue\":\"无标题.sql\"},{\"newValue\":[\"{\\\"阶段名称\\\":\\\"项目立项\\\",\\\"工作内容\\\":\\\"14124\\\",\\\"时间区间起\\\":\\\"2021-09-01\\\",\\\"参与人\\\":[\\\"张三511\\\"],\\\"时间区间至\\\":\\\"2021-09-05\\\"}\",\"{\\\"阶段名称\\\":\\\"项目启动与计划\\\",\\\"工作内容\\\":\\\"2124\\\",\\\"时间区间起\\\":\\\"2021-09-06\\\",\\\"参与人\\\":[\\\"张三514\\\"],\\\"时间区间至\\\":\\\"2021-09-12\\\"}\",\"{\\\"阶段名称\\\":\\\"项目实施\\\",\\\"工作内容\\\":\\\"3\\\",\\\"时间区间起\\\":\\\"2021-09-13\\\",\\\"参与人\\\":[\\\"张三560\\\",\\\"张三559\\\"],\\\"时间区间至\\\":\\\"2021-09-19\\\"}\",\"{\\\"阶段名称\\\":\\\"项目验收\\\",\\\"工作内容\\\":\\\"455\\\",\\\"时间区间起\\\":\\\"2021-09-20\\\",\\\"参与人\\\":[\\\"张三519\\\"],\\\"时间区间至\\\":\\\"2021-09-26\\\"}\",\"{\\\"阶段名称\\\":\\\"项目结项\\\",\\\"工作内容\\\":\\\"5\\\",\\\"时间区间起\\\":\\\"2021-09-27\\\",\\\"参与人\\\":[\\\"张三541\\\"],\\\"时间区间至\\\":\\\"2021-10-10\\\"}\"],\"field\":\"阶段信息\",\"oldValue\":[\"{\\\"阶段名称\\\":\\\"项目立项\\\",\\\"工作内容\\\":\\\"1\\\",\\\"时间区间起\\\":\\\"2021-09-01\\\",\\\"参与人\\\":[\\\"张三512\\\",\\\"张三511\\\"],\\\"时间区间至\\\":\\\"2021-09-05\\\"}\",\"{\\\"阶段名称\\\":\\\"项目启动与计划\\\",\\\"工作内容\\\":\\\"2\\\",\\\"时间区间起\\\":\\\"2021-09-06\\\",\\\"参与人\\\":[\\\"张三514\\\"],\\\"时间区间至\\\":\\\"2021-09-12\\\"}\",\"{\\\"阶段名称\\\":\\\"项目实施\\\",\\\"工作内容\\\":\\\"3\\\",\\\"时间区间起\\\":\\\"2021-09-13\\\",\\\"参与人\\\":[\\\"张三560\\\",\\\"张三559\\\"],\\\"时间区间至\\\":\\\"2021-09-19\\\"}\",\"{\\\"阶段名称\\\":\\\"项目验收\\\",\\\"工作内容\\\":\\\"4\\\",\\\"时间区间起\\\":\\\"2021-09-20\\\",\\\"参与人\\\":[\\\"张三519\\\"],\\\"时间区间至\\\":\\\"2021-09-26\\\"}\",\"{\\\"阶段名称\\\":\\\"项目结项\\\",\\\"工作内容\\\":\\\"5\\\",\\\"时间区间起\\\":\\\"2021-09-27\\\",\\\"参与人\\\":[\\\"张三541\\\"],\\\"时间区间至\\\":\\\"2021-09-30\\\"}\"]}]", "createTime": "2021-09-15 17:24:44", "processInstId": "763660", "updateTime": "2021-09-15 17:24:44", "state": 0, "applyTime": "2021-09-15 17:23:55", "uuid": "b012fd6008c64de98edb90c72a6bf219", "projectUuid": "d582b8ec85e9445796626f241969564e" } ] }, "time": 1631864437940 }</code></pre> <h2>9.项目甘特图</h2> 地址：itsm/project/getProjectGanttChart 脚本：ItsmGetProjectGanttChartScript 参数： <pre><code class="language-json">{"projectUuid":""}</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": [ { "leader": "d22ae15a56394869924059a9d5867a29", "changeReason": "\r\n-----\r\n124", "level": "三级", "endDate": "2021-09-30", "stageList": [ { "schedule": 5.0, "name": "项目立项", "progress": "10000.0%", "startTime": 1630425600000, "remark": "14124", "endTime": 1630771200000 }, { "schedule": 7.0, "name": "项目启动与计划", "progress": "0.0%", "startTime": 1630857600000, "remark": "2124", "endTime": 1631376000000 }, { "schedule": 7.0, "name": "项目实施", "progress": "0.0%", "startTime": 1631462400000, "remark": "3", "endTime": 1631980800000 }, { "schedule": 7.0, "name": "项目验收", "progress": "0.0%", "startTime": 1632067200000, "remark": "455", "endTime": 1632585600000 }, { "schedule": 14.0, "name": "项目结项", "progress": "0.0%", "startTime": 1632672000000, "remark": "5", "endTime": 1633795200000 } ], "delayCount": 0, "changeCount": 0, "type": "一般项目", "uuid": "d582b8ec85e9445796626f241969564e", "schedule": 40, "name": "测试", "progress": "1250.0%", "startTime": 1630425600000, "endTime": 1633795200000, "department": "", "constructionDate": 1629993600000, "budget": "1501万" } ] }, "time": 1631864459382 }</code></pre> <h2>10.项目下拉（有权限）</h2> 地址：itsm/project/getProjectSelectList 脚本：ItsmGetProjectSelectListScript 参数： <pre><code class="language-json">{}</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": [ { "label": "测试", "value": "d582b8ec85e9445796626f241969564e" } ] }, "time": 1631864490994 }</code></pre> <h2>11.项目下拉（无权限）</h2> 地址：itsm/project/getAllProjectSelectList 脚本：ItsmGetAllProjectSelectListScript 参数： <pre><code class="language-json">{}</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": [ { "label": "全部项目", "value": "allProject" }, { "label": "测试", "value": "d582b8ec85e9445796626f241969564e" } ] }, "time": 1631864512721 }</code></pre> <h2>11.项目权限列表</h2> 地址：itsm/project/getProjectPermissionList 脚本：ItsmGetProjectPermissionListScript 参数： <pre><code class="language-json">{ "page": 1, "limit": 10, "keyword": "" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "result": [ { "queryRole": "超级管理员,硬件管理员", "queryDepartment": "111", "projectNames": "全部项目", "departmentLeaderRead": "是", "uuid": "288d0d38699246caaed2c495b408aae7", "directLeaderRead": "是" } ], "pageInfo": { "total": 1, "limit": 10, "page": 1 } } }, "time": 1631864534017 }</code></pre> <h2>12.获取项目权限</h2> 地址：itsm/project/getProjectPermission 脚本：ItsmGetProjectPermissionScript 参数： <pre><code class="language-json">{ "uuid": "288d0d38699246caaed2c495b408aae7" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": { "result": { "queryRole": [ "administratorRole", "DeviceAdministratorRole" ], "projects": [ "allProject" ], "queryDepartment": [ "4dfe42348f9f4f7bb3f0dc4d283b0b76" ], "projectNames": [ "全部项目" ], "departmentLeaderRead": true, "directLeaderRead": true } }, "time": 1631864564296 }</code></pre> <h2>13.保存项目权限</h2> 地址：itsm/project/saveProjectPermission 脚本：ItsmSaveProjectPermissionScript 参数：说明：新增项目权限的时候不用传uuid,修改时传uuid <pre><code class="language-json">{ "projects": [ "allProject" ], "directLeaderRead": true, "departmentLeaderRead": true, "queryDepartment": [ "4dfe42348f9f4f7bb3f0dc4d283b0b76" ], "queryRole": [ "administratorRole", "DeviceAdministratorRole" ], "projectNames": [ "全部项目" ] }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "success", "responseBody": {}, "time": 1631864614077 }</code></pre> <h2>14.删除项目权限</h2> 地址：itsm/project/deleteProjectPermission 脚本：ItsmDeleteProjectPermissionScript 参数： <pre><code class="language-json">{ "uuid":"6e686e5dfe704107a4ca0391ff0910b2" }</code></pre> 返回： <pre><code class="language-json">{ "errorCode": 0, "message": "成功", "time": 1617689716731, "responseBody": null }</code></pre>

ITSM

项目管理方案

页面列表