ITSM

运维管理系统


项目管理方案

PostgresSQL建表语句

BasicProject

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 '直属领导';

BasicProjectStage

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 '阶段参与人名字';

BasicProjectPermission

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 '是否项目负责人直属领导可阅';

BasicProjectChangeHistory

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 '变更详情';

BasicProjectStageRelationship

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)
);

网关

--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');

工单编号

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');

菜单

  1. 项目总览列表 路由:projectTotalView
  2. 项目总体视图 路由:projectGantt
  3. 项目详情信息 路由:projectDetailView 设置为隐藏
  4. 项目总览权限设置 路由:projectRole

接口

1.新增项目接口

地址:itsm/project/saveProject

脚本:ItsmSaveProjectScript

参数

{
    "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"
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": "成功"
    },
    "time": 1631674905765
}

2.项目变更接口

地址:itsm/project/updateProject

脚本:ItsmUpdateProjectScript

参数

{
    "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"]
        }
    ]
}

返回

{
    "errorCode": 0,
    "message": "成功",
    "responseBody": null,
    "time": 1613718775181
}

3.项目结项

地址:itsm/project/closeProject

脚本: ItsmCloseProjectScript

参数

{
    "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"}]
}

返回

{
    "errorCode": 0,
    "message": "success",
    "time": 1631863354201
}

4.项目列表

地址:itsm/project/getProjectList

脚本:ItsmGetProjectListScript

参数

{
    "type":"1",
    "keyword":"",
    "page":1,
    "limit":10
}

返回

{
    "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
}

5.项目名称校验

地址:itsm/project/checkProjectName

脚本:ItsmCheckProjectNameScript

参数

{"name":"测试"}

返回:isRepeat为true时重名

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": {
            "isRepeat": true
        }
    },
    "time": 1631863393426
}

6.更新项目阶段进度

地址:itsm/project/updateProjectStageProgress

脚本:ItsmUpdateProjectStageProgressScript

参数

{
    "name":"测试",
    "stage":"项目立项",
    "progress":"100",
    "week_report":"765789"
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {},
    "time": 1631864154950
}

7.个人所属未结项项目

地址:itsm/project/getUnCloseProjectByLeader

脚本:ItsmGetUnCloseProjectByLeaderScript

参数

{
    "leaderUuid":"12d1ebb803764348a89d10c9e3019d29"
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": [
            {
                "label": "测试",
                "value": "d582b8ec85e9445796626f241969564e"
            }
        ]
    },
    "time": 1631864219434
}

8.项目详情

地址:itsm/project/getProjectByUuid

脚本:ItsmGetProjectByUuidScript

参数

{"uuid": "d582b8ec85e9445796626f241969564e"}

返回

{
    "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
}

9.项目关联标签页列表

地址:itsm/project/getProjectRelationList

脚本:ItsmGetProjectRelationListScript

参数

{
    "projectUuid": "d582b8ec85e9445796626f241969564e",
    "type": "week",
    "keyword": "",
    "page": 1,
    "limit": 10
}

返回

{
    "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
}

9.项目变更历史

地址:itsm/project/getProjectChangeHistory

脚本:ItsmGetProjectChangeHistoryScript

参数

{
    "projectUuid": "d582b8ec85e9445796626f241969564e"
}

返回

{
    "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
}

9.项目甘特图

地址:itsm/project/getProjectGanttChart

脚本:ItsmGetProjectGanttChartScript

参数

{"projectUuid":""}

返回

{
    "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
}

10.项目下拉(有权限)

地址:itsm/project/getProjectSelectList

脚本:ItsmGetProjectSelectListScript

参数

{}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": [
            {
                "label": "测试",
                "value": "d582b8ec85e9445796626f241969564e"
            }
        ]
    },
    "time": 1631864490994
}

11.项目下拉(无权限)

地址:itsm/project/getAllProjectSelectList

脚本:ItsmGetAllProjectSelectListScript

参数

{}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": [
            {
                "label": "全部项目",
                "value": "allProject"
            },
            {
                "label": "测试",
                "value": "d582b8ec85e9445796626f241969564e"
            }
        ]
    },
    "time": 1631864512721
}

11.项目权限列表

地址:itsm/project/getProjectPermissionList

脚本:ItsmGetProjectPermissionListScript

参数

{
    "page": 1,
    "limit": 10,
    "keyword": ""
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": {
            "result": [
                {
                    "queryRole": "超级管理员,硬件管理员",
                    "queryDepartment": "111",
                    "projectNames": "全部项目",
                    "departmentLeaderRead": "是",
                    "uuid": "288d0d38699246caaed2c495b408aae7",
                    "directLeaderRead": "是"
                }
            ],
            "pageInfo": {
                "total": 1,
                "limit": 10,
                "page": 1
            }
        }
    },
    "time": 1631864534017
}

12.获取项目权限

地址:itsm/project/getProjectPermission

脚本:ItsmGetProjectPermissionScript

参数

{
    "uuid": "288d0d38699246caaed2c495b408aae7"
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {
        "result": {
            "queryRole": [
                "administratorRole",
                "DeviceAdministratorRole"
            ],
            "projects": [
                "allProject"
            ],
            "queryDepartment": [
                "4dfe42348f9f4f7bb3f0dc4d283b0b76"
            ],
            "projectNames": [
                "全部项目"
            ],
            "departmentLeaderRead": true,
            "directLeaderRead": true
        }
    },
    "time": 1631864564296
}

13.保存项目权限

地址:itsm/project/saveProjectPermission

脚本:ItsmSaveProjectPermissionScript

参数:说明:新增项目权限的时候不用传uuid,修改时传uuid

{
    "projects": [
        "allProject"
    ],
    "directLeaderRead": true,
    "departmentLeaderRead": true,
    "queryDepartment": [
        "4dfe42348f9f4f7bb3f0dc4d283b0b76"
    ],
    "queryRole": [
        "administratorRole",
        "DeviceAdministratorRole"
    ],
    "projectNames": [
        "全部项目"
    ]
}

返回

{
    "errorCode": 0,
    "message": "success",
    "responseBody": {},
    "time": 1631864614077
}

14.删除项目权限

地址:itsm/project/deleteProjectPermission

脚本:ItsmDeleteProjectPermissionScript

参数

{
    "uuid":"6e686e5dfe704107a4ca0391ff0910b2"
}

返回

{
    "errorCode": 0,
    "message": "成功",
    "time": 1617689716731,
    "responseBody": null
}

页面列表

ITEM_HTML