需求
在VUE +Element 实现树结构时遇到一个问题,要求子节点有一个唯一标识 (据我所知LayUI 不存在这个问题)
很显然不能用各外键的ID作为唯一标识(当时想了一个办法就是把各节点的ID * 几个不同的值,但仍然有可能重复,所以现在看很可笑);
解决文案
使用MySQL 的UUID() 方法实现
SQL
<sql id="TestSQL">
UUID() as UUID,
s_type.id,
s_type.name,
s_type.type_code,
s_type.type_name,
"project" as type,
UUID() as proUUID,
npi_project_class.id as cid,
npi_project_class.stage,
npi_project_class_task.id as tid,
npi_project_class_task.logic_relation as logicRelation,
"logic" as logicType,
UUID() as logicUUID,
npi_project_class_task.npi_task_warehouse_id as npiTaskWarehouseId,
npi_project_class_task.pid as pid,
"stage" as stageType,
npi_task_warehouse.id as wid,
"task" as taskType,
UUID() as taskUUID,
npi_task_warehouse.code as wcode,
npi_task_warehouse.name as wname,
npi_task_warehouse.file_input as fileInput,
npi_task_warehouse.category,
npi_task_warehouse.responsible_role_id as responsibleRoleId,
npi_task_warehouse.responsible_dept_id as responsibleDeptId,
npi_task_warehouse.task_description
</sql>
具体mapper
<resultMap type="com.npi.model.tempo.StypeList" id="ProjectClass">
<id property="id" column="id"/>
<result property="UUID" column="UUID"/>
<result property="shortCode" column="shortCode"/>
<result property="code" column="code"/>
<result property="name" column="name"/>
<result property="remark" column="remark"/>
<result property="typeCode" column="typeCode"/>
<result property="typeName" column="typeName"/>
<result property="isDeleted" column="isDeleted"/>
<result property="type" column="type"/>
<collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiProjectClassStage">
<id property="id" column="cid"/>
<result property="UUID" column="proUUID"/>
<result property="stage" column="stage"/>
<result property="type" column="stageType"/>
<collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiProjectClassLogic">
<id property="id" column="pid"/>
<result property="UUID" column="logicUUID"/>
<result property="logicRelation" column="logicRelation"/>
<result property="type" column="logicType"/>
<collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiTaskWarehouseDtm">
<id property="id" column="wid"/>
<result property="UUID" column="taskUUID"/>
<result property="type" column="taskType"/>
<result property="code" column="wcode"/>
<result property="name" column="wname"/>
<result property="fileInput" column="fileInput"/>
<result property="category" column="category"/>
<result property="responsibleRoleId" column="responsibleRoleId"/>
<result property="responsibleDeptId" column="responsibleDeptId"/>
</collection>
</collection>
</collection>
</resultMap>
建对应的临时类并声明UUID成员
private String UUID;
效果
{
"code": 200,
"data": [
{
"children": [
{
"children": [
{
"children": [
{
"category": 0,
"code": "G1.1",
"fileInput": "2D/3D",
"id": 1,
"isDeleted": 0,
"name": "客户图纸接收",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d906e-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G1.2",
"fileInput": "模具规格说明书 ",
"id": 2,
"isDeleted": 0,
"name": "模具规格沟通",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9237-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G1.3",
"fileInput": "产品需求说明",
"id": 3,
"isDeleted": 0,
"name": "产品需求沟通",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9295-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G1.4",
"fileInput": "VOC",
"id": 5,
"isDeleted": 0,
"name": "量产预测/样品预测/时间沟通",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d92e7-9e66-11eb-9d28-005056a43b52"
}
],
"id": 1,
"logicRelation": 1,
"type": "logic",
"uUID": "3e7d906b-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G1.5",
"fileInput": "BFMEA",
"id": 6,
"isDeleted": 0,
"name": "商务失效模式和风险评估",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9338-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G1.6",
"fileInput": "项目简介",
"id": 7,
"isDeleted": 0,
"name": "项目简介",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9385-9e66-11eb-9d28-005056a43b52"
}
],
"id": 2,
"logicRelation": 2,
"type": "logic",
"uUID": "3e7d9335-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G1.7",
"fileInput": "转阶段评审表签核",
"id": 8,
"isDeleted": 0,
"name": "阶段评审",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d93cc-9e66-11eb-9d28-005056a43b52"
}
],
"id": 3,
"logicRelation": 3,
"type": "logic",
"uUID": "3e7d93c9-9e66-11eb-9d28-005056a43b52"
}
],
"id": 24,
"stage": 1,
"type": "stage",
"uUID": "3e7d9067-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"children": [
{
"category": 0,
"code": "G2.1",
"fileInput": "项目组员清单",
"id": 9,
"isDeleted": 0,
"name": "项目组成立",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9427-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.2",
"fileInput": "项目时间计划",
"id": 10,
"isDeleted": 0,
"name": "项目启动会议",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d946c-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.3",
"fileInput": "工艺流程图",
"id": 11,
"isDeleted": 0,
"name": "初版工艺流程",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d94b6-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.4",
"fileInput": "特殊特性清单",
"id": 12,
"isDeleted": 0,
"name": "初版特殊特性清单",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质责任人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d950d-9e66-11eb-9d28-005056a43b52"
}
],
"id": 4,
"logicRelation": 1,
"type": "logic",
"uUID": "3e7d9424-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.5",
"fileInput": "可行性报告",
"id": 13,
"isDeleted": 0,
"name": "可行性评估",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9553-9e66-11eb-9d28-005056a43b52"
}
],
"id": 5,
"logicRelation": 2,
"type": "logic",
"uUID": "3e7d9550-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.6",
"fileInput": "模具CBD",
"id": 14,
"isDeleted": 0,
"name": "模具成本核算",
"responsibleDeptId": "模具部",
"responsibleRoleId": "模具负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9598-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.7",
"fileInput": "注塑CBD",
"id": 15,
"isDeleted": 0,
"name": "注塑成本核算",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d95e1-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.8",
"fileInput": "自动化CBD",
"id": 16,
"isDeleted": 0,
"name": "自动化成本核算",
"responsibleDeptId": "自动化",
"responsibleRoleId": "自动化负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d974a-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G2.9",
"fileInput": "检治具CBD",
"id": 17,
"isDeleted": 0,
"name": "检治具成本核算",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质责任人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d97a0-9e66-11eb-9d28-005056a43b52"
}
],
"id": 6,
"logicRelation": 3,
"type": "logic",
"uUID": "3e7d9595-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.10",
"fileInput": "项目预算",
"id": 18,
"isDeleted": 0,
"name": "项目预算",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d97ec-9e66-11eb-9d28-005056a43b52"
}
],
"id": 7,
"logicRelation": 4,
"type": "logic",
"uUID": "3e7d97e9-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.11",
"fileInput": "报价单",
"id": 19,
"isDeleted": 0,
"name": "报价",
"responsibleDeptId": "市场部",
"responsibleRoleId": "市场负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9836-9e66-11eb-9d28-005056a43b52"
}
],
"id": 8,
"logicRelation": 5,
"type": "logic",
"uUID": "3e7d9833-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.12",
"fileInput": "客户定点函",
"id": 20,
"isDeleted": 0,
"name": "客户定点",
"responsibleDeptId": "市场部",
"responsibleRoleId": "市场负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d987c-9e66-11eb-9d28-005056a43b52"
}
],
"id": 9,
"logicRelation": 6,
"type": "logic",
"uUID": "3e7d9879-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G2.13",
"fileInput": "转阶段评审表签核",
"id": 21,
"isDeleted": 0,
"name": "阶段评审",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d98c2-9e66-11eb-9d28-005056a43b52"
}
],
"id": 10,
"logicRelation": 7,
"type": "logic",
"uUID": "3e7d98bf-9e66-11eb-9d28-005056a43b52"
}
],
"id": 25,
"stage": 2,
"type": "stage",
"uUID": "3e7d9421-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"children": [
{
"category": 0,
"code": "G3.1",
"fileInput": "模流分析",
"id": 22,
"isDeleted": 0,
"name": "模流分析",
"responsibleDeptId": "模具部",
"responsibleRoleId": "模具负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9924-9e66-11eb-9d28-005056a43b52"
},
{
"category": 1,
"code": "G3.5",
"fileInput": "检治具计划",
"id": 26,
"isDeleted": 0,
"name": "检治具设计",
"responsibleDeptId": "资材部",
"responsibleRoleId": "采购负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9969-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G3.9",
"fileInput": "自动化设备计划",
"id": 30,
"isDeleted": 0,
"name": "自动化设备设计",
"responsibleDeptId": "资材部",
"responsibleRoleId": "采购负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d99af-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G3.11",
"fileInput": "包装方案",
"id": 32,
"isDeleted": 0,
"name": "包装细部设计",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d99f9-9e66-11eb-9d28-005056a43b52"
},
{
"category": 1,
"code": "G3.13",
"fileInput": "科学试模报告(T0)成型条件表\r\nTIL",
"id": 34,
"isDeleted": 0,
"name": "试模(T0/1/X)",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9a41-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G3.16",
"fileInput": "PFMEA",
"id": 37,
"isDeleted": 0,
"name": "初版PFMEA",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9a88-9e66-11eb-9d28-005056a43b52"
}
],
"id": 11,
"logicRelation": 1,
"type": "logic",
"uUID": "3e7d9921-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.2",
"fileInput": "DFM",
"id": 23,
"isDeleted": 0,
"name": "DFM",
"responsibleDeptId": "模具部",
"responsibleRoleId": "模具负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9ace-9e66-11eb-9d28-005056a43b52"
}
],
"id": 12,
"logicRelation": 2,
"type": "logic",
"uUID": "3e7d9acb-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 1,
"code": "G3.3",
"fileInput": "模具设计评审表",
"id": 24,
"isDeleted": 0,
"name": "模具细部设计",
"responsibleDeptId": "模具部",
"responsibleRoleId": "模具负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9b12-9e66-11eb-9d28-005056a43b52"
}
],
"id": 13,
"logicRelation": 3,
"type": "logic",
"uUID": "3e7d9b10-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 1,
"code": "G3.4",
"fileInput": "Tooling Schedule",
"id": 25,
"isDeleted": 0,
"name": "模具制作",
"responsibleDeptId": "模具部",
"responsibleRoleId": "模具负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9b58-9e66-11eb-9d28-005056a43b52"
}
],
"id": 14,
"logicRelation": 4,
"type": "logic",
"uUID": "3e7d9b55-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.6",
"fileInput": "检治具验收报告",
"id": 27,
"isDeleted": 0,
"name": "检治具制作",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9ba5-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G3.7",
"fileInput": "MSOP",
"id": 28,
"isDeleted": 0,
"name": "测量作业指导书编制",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9bea-9e66-11eb-9d28-005056a43b52"
}
],
"id": 15,
"logicRelation": 5,
"type": "logic",
"uUID": "3e7d9ba3-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.8",
"fileInput": "MSA",
"id": 29,
"isDeleted": 0,
"name": "MSA",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9c2e-9e66-11eb-9d28-005056a43b52"
}
],
"id": 16,
"logicRelation": 6,
"type": "logic",
"uUID": "3e7d9c2b-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.10",
"fileInput": "自动化设备验收报告",
"id": 31,
"isDeleted": 0,
"name": "自动化设备制作",
"responsibleDeptId": "自动化",
"responsibleRoleId": "自动化负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9c74-9e66-11eb-9d28-005056a43b52"
}
],
"id": 17,
"logicRelation": 7,
"type": "logic",
"uUID": "3e7d9c72-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.12",
"fileInput": "E-BOM",
"id": 33,
"isDeleted": 0,
"name": "初始BOM",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9cbb-9e66-11eb-9d28-005056a43b52"
}
],
"id": 18,
"logicRelation": 8,
"type": "logic",
"uUID": "3e7d9cb8-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 1,
"code": "G3.14",
"fileInput": "科学试模报告(T0)成型条件表\r\nTIL",
"id": 35,
"isDeleted": 0,
"name": "试模(T0/1/X)",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9d00-9e66-11eb-9d28-005056a43b52"
}
],
"id": 19,
"logicRelation": 9,
"type": "logic",
"uUID": "3e7d9cfd-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.15",
"fileInput": "试模样品",
"id": 36,
"isDeleted": 0,
"name": "试模样品递交客户",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9d46-9e66-11eb-9d28-005056a43b52"
}
],
"id": 20,
"logicRelation": 10,
"type": "logic",
"uUID": "3e7d9d44-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.17",
"fileInput": "CP",
"id": 38,
"isDeleted": 0,
"name": "初版CP",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9d94-9e66-11eb-9d28-005056a43b52"
}
],
"id": 21,
"logicRelation": 11,
"type": "logic",
"uUID": "3e7d9d92-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.18",
"fileInput": "SIP",
"id": 39,
"isDeleted": 0,
"name": "初版SIP",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9dda-9e66-11eb-9d28-005056a43b52"
}
],
"id": 22,
"logicRelation": 12,
"type": "logic",
"uUID": "3e7d9dd8-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.19",
"fileInput": "SOP",
"id": 40,
"isDeleted": 0,
"name": "初版SOP",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9e1e-9e66-11eb-9d28-005056a43b52"
}
],
"id": 23,
"logicRelation": 13,
"type": "logic",
"uUID": "3e7d9e1b-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.20",
"fileInput": "Tooling issue list close",
"id": 41,
"isDeleted": 0,
"name": "试模问题解决",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9e64-9e66-11eb-9d28-005056a43b52"
}
],
"id": 24,
"logicRelation": 14,
"type": "logic",
"uUID": "3e7d9e62-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.21",
"fileInput": "FAI Report",
"id": 42,
"isDeleted": 0,
"name": "FAI Pass",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9eab-9e66-11eb-9d28-005056a43b52"
}
],
"id": 25,
"logicRelation": 15,
"type": "logic",
"uUID": "3e7d9ea9-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G3.22",
"fileInput": "转阶段评审表签核",
"id": 43,
"isDeleted": 0,
"name": "阶段评审",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9ef3-9e66-11eb-9d28-005056a43b52"
}
],
"id": 26,
"logicRelation": 16,
"type": "logic",
"uUID": "3e7d9ef0-9e66-11eb-9d28-005056a43b52"
}
],
"id": 26,
"stage": 3,
"type": "stage",
"uUID": "3e7d991e-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"children": [
{
"category": 0,
"code": "G4.1",
"fileInput": "PFMEA(冻结)",
"id": 4,
"isDeleted": 0,
"name": "PFMEA(冻结)",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9f41-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G4.2",
"fileInput": "CP(冻结)",
"id": 44,
"isDeleted": 0,
"name": "CP(冻结)",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9f99-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G4.3",
"fileInput": "SIP(冻结)",
"id": 45,
"isDeleted": 0,
"name": "SIP(冻结)",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7d9fde-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G4.4",
"fileInput": "SOP(冻结)",
"id": 46,
"isDeleted": 0,
"name": "SOP(冻结)",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da027-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G4.12",
"fileInput": "客户订单",
"id": 54,
"isDeleted": 0,
"name": "客户订单预测确认",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7da06c-9e66-11eb-9d28-005056a43b52"
}
],
"id": 27,
"logicRelation": 1,
"type": "logic",
"uUID": "3e7d9f3e-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.5",
"fileInput": "节拍生产报告",
"id": 47,
"isDeleted": 0,
"name": "节拍生产",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da0b1-9e66-11eb-9d28-005056a43b52"
}
],
"id": 28,
"logicRelation": 2,
"type": "logic",
"uUID": "3e7da0ae-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.6",
"fileInput": "CPK",
"id": 48,
"isDeleted": 0,
"name": "CPK",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da0f5-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G4.7",
"fileInput": "样品递送清单",
"id": 49,
"isDeleted": 0,
"name": "工程样品提交客户",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da13d-9e66-11eb-9d28-005056a43b52"
}
],
"id": 29,
"logicRelation": 3,
"type": "logic",
"uUID": "3e7da0f2-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.8",
"fileInput": "限度样品清单",
"id": 50,
"isDeleted": 0,
"name": "限度样品",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da181-9e66-11eb-9d28-005056a43b52"
}
],
"id": 30,
"logicRelation": 3,
"type": "logic",
"uUID": "3e7da17f-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.9",
"fileInput": "外观批准报告",
"id": 51,
"isDeleted": 0,
"name": "外观批准",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da1c6-9e66-11eb-9d28-005056a43b52"
}
],
"id": 31,
"logicRelation": 4,
"type": "logic",
"uUID": "3e7da1c3-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.10",
"fileInput": "PPAP样品、PPAP",
"id": 52,
"isDeleted": 0,
"name": "PPAP",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da20a-9e66-11eb-9d28-005056a43b52"
}
],
"id": 32,
"logicRelation": 5,
"type": "logic",
"uUID": "3e7da208-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.11",
"fileInput": "客户签核PSW",
"id": 53,
"isDeleted": 0,
"name": "PSW签核",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da250-9e66-11eb-9d28-005056a43b52"
}
],
"id": 33,
"logicRelation": 6,
"type": "logic",
"uUID": "3e7da24d-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.13",
"fileInput": "物料采购单",
"id": 55,
"isDeleted": 0,
"name": "量产物料准备",
"responsibleDeptId": "1",
"responsibleRoleId": "采购负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da296-9e66-11eb-9d28-005056a43b52"
}
],
"id": 34,
"logicRelation": 7,
"type": "logic",
"uUID": "3e7da293-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.14",
"fileInput": "LRC report",
"id": 56,
"isDeleted": 0,
"name": "量产准备评估",
"responsibleDeptId": "品质部",
"responsibleRoleId": "品质负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da2dc-9e66-11eb-9d28-005056a43b52"
}
],
"id": 35,
"logicRelation": 8,
"type": "logic",
"uUID": "3e7da2d9-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.15",
"fileInput": "Safe launch报告",
"id": 57,
"isDeleted": 0,
"name": "Safe launch",
"responsibleDeptId": "注塑部",
"responsibleRoleId": "注塑负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da321-9e66-11eb-9d28-005056a43b52"
}
],
"id": 36,
"logicRelation": 9,
"type": "logic",
"uUID": "3e7da31e-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"category": 0,
"code": "G4.16",
"fileInput": "转阶段评审表签核",
"id": 58,
"isDeleted": 0,
"name": "阶段评审",
"responsibleDeptId": "NPI",
"responsibleRoleId": "NPI负责人",
"sortNum": 0,
"type": "task",
"uUID": "3e7da369-9e66-11eb-9d28-005056a43b52"
}
],
"id": 37,
"logicRelation": 10,
"type": "logic",
"uUID": "3e7da366-9e66-11eb-9d28-005056a43b52"
}
],
"id": 27,
"stage": 4,
"type": "stage",
"uUID": "3e7d9f3b-9e66-11eb-9d28-005056a43b52"
},
{
"children": [
{
"children": [
{
"category": 0,
"code": "G5.1",
"fileInput": "项目总结报告",
"id": 59,
"isDeleted": 0,
"name": "项目总结",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7da3b2-9e66-11eb-9d28-005056a43b52"
},
{
"category": 0,
"code": "G5.2",
"fileInput": "顾客满意度调查表",
"id": 60,
"isDeleted": 0,
"name": "顾客满意度调查",
"responsibleDeptId": "项目部",
"responsibleRoleId": "项目主管",
"sortNum": 0,
"type": "task",
"uUID": "3e7da3f5-9e66-11eb-9d28-005056a43b52"
}
],
"id": 38,
"logicRelation": 1,
"type": "logic",
"uUID": "3e7da3af-9e66-11eb-9d28-005056a43b52"
}
],
"id": 28,
"stage": 5,
"type": "stage",
"uUID": "3e7da3ac-9e66-11eb-9d28-005056a43b52"
}
],
"id": 61,
"isDeleted": 0,
"name": "汽车件",
"type": "project",
"uUID": "3e7d9058-9e66-11eb-9d28-005056a43b52"
}
],
"msg": "操作成功"
}
总结
其实网上也有人说这样不合理,会使用SQL性能降低;但对于一般需求能满足就可以了;个人理解 先满足需求,再去做优化;这好比骑驴找马。