From 7a79d42944f2535814966e10368b8ef8dce3e0fb Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期一, 24 三月 2025 11:40:18 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- business/src/main/java/com/ycl/domain/form/ProjectEngineeringForm.java | 3 +++ business/src/main/resources/mapper/ProjectProcessMapper.xml | 7 ++++--- business/src/main/java/com/ycl/domain/vo/ProjectEngineeringVO.java | 4 ++++ business/src/main/resources/mapper/ProjectEngineeringMapper.xml | 6 +++++- business/src/main/java/com/ycl/domain/entity/ProjectEngineering.java | 4 ++++ 5 files changed, 20 insertions(+), 4 deletions(-) diff --git a/business/src/main/java/com/ycl/domain/entity/ProjectEngineering.java b/business/src/main/java/com/ycl/domain/entity/ProjectEngineering.java index 31e4891..7b1faee 100644 --- a/business/src/main/java/com/ycl/domain/entity/ProjectEngineering.java +++ b/business/src/main/java/com/ycl/domain/entity/ProjectEngineering.java @@ -58,4 +58,8 @@ /** 骞翠唤 */ private String year; + @TableField("build_content") + /** 寤鸿鍐呭 */ + private String buildContent; + } diff --git a/business/src/main/java/com/ycl/domain/form/ProjectEngineeringForm.java b/business/src/main/java/com/ycl/domain/form/ProjectEngineeringForm.java index 02225dd..95df8f3 100644 --- a/business/src/main/java/com/ycl/domain/form/ProjectEngineeringForm.java +++ b/business/src/main/java/com/ycl/domain/form/ProjectEngineeringForm.java @@ -58,6 +58,9 @@ @ApiModelProperty("鐖跺伐绋�") private String parent; + @ApiModelProperty("寤鸿鍐呭") + private String buildContent; + public static ProjectEngineering getEntityByForm(@NonNull ProjectEngineeringForm form, ProjectEngineering entity) { if(entity == null) { entity = new ProjectEngineering(); diff --git a/business/src/main/java/com/ycl/domain/vo/ProjectEngineeringVO.java b/business/src/main/java/com/ycl/domain/vo/ProjectEngineeringVO.java index e5cf83d..c961b3d 100644 --- a/business/src/main/java/com/ycl/domain/vo/ProjectEngineeringVO.java +++ b/business/src/main/java/com/ycl/domain/vo/ProjectEngineeringVO.java @@ -91,6 +91,10 @@ @ApiModelProperty("涓氫富鍗曚綅鍚嶅瓧") private String unitName; + /** 寤鸿鍐呭 */ + @ApiModelProperty("寤鸿鍐呭") + private String buildContent; + /** 宸ョ▼鍒楄〃 */ @ApiModelProperty("瀛愬伐绋嬪垪琛�") private List<ProjectEngineeringVO> children = new ArrayList<ProjectEngineeringVO>(); diff --git a/business/src/main/resources/mapper/ProjectEngineeringMapper.xml b/business/src/main/resources/mapper/ProjectEngineeringMapper.xml index a5cf56d..798b67a 100644 --- a/business/src/main/resources/mapper/ProjectEngineeringMapper.xml +++ b/business/src/main/resources/mapper/ProjectEngineeringMapper.xml @@ -17,6 +17,7 @@ <result column="year" property="year" /> <result column="unit_name" property="unitName" /> <result column="department_name" property="departmentName" /> + <result column="build_content" property="buildContent"/> <collection property="children" ofType="com.ycl.domain.vo.ProjectEngineeringVO" select="getProjectEngineering" column="id"></collection> </resultMap> @@ -34,6 +35,7 @@ TPE.department, TPE.parent_id, TPE.year, + TPE.build_content, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TPE.unit) AS unit_name, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TPE.department) AS department_name FROM t_project_engineering TPE @@ -53,7 +55,8 @@ TPE.unit, TPE.department, TPE.parent_id, - TPE.year + TPE.year, + TPE.build_content FROM t_project_engineering TPE WHERE @@ -73,6 +76,7 @@ TPE.parent_id, TPE.year, TPI.project_name, + TPE.build_content, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TPE.unit) AS unit_name, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TPE.department) AS department_name FROM diff --git a/business/src/main/resources/mapper/ProjectProcessMapper.xml b/business/src/main/resources/mapper/ProjectProcessMapper.xml index 5890f54..849b20b 100644 --- a/business/src/main/resources/mapper/ProjectProcessMapper.xml +++ b/business/src/main/resources/mapper/ProjectProcessMapper.xml @@ -79,6 +79,7 @@ <result column="competent_department_name" property="competentDepartmentName" /> <result column="process_ins_id" property="processInsId" /> <result column="process_def_id" property="processDefId" /> + <result column="build_content" property="buildContent" /> </resultMap> <select id="getProjectEngineeringList" parameterType="string" resultMap="EngineeringMap"> @@ -105,13 +106,13 @@ <select id="getEngineeringList" parameterType="long" resultMap="EngineeringMap"> WITH RECURSIVE temp_table AS ( SELECT - id, project_info_id, project_name, project_type, investment_amount, status, unit, department, parent_id, year, gmt_create FROM t_project_engineering WHERE project_info_id = #{projectId} AND parent_id = '0' AND deleted = 0 + id, project_info_id, project_name, project_type, investment_amount, status, unit, department, parent_id, year, gmt_create, build_content FROM t_project_engineering WHERE project_info_id = #{projectId} AND parent_id = '0' AND deleted = 0 UNION ALL SELECT - TPE.id, TPE.project_info_id, TPE.project_name, TPE.project_type, TPE.investment_amount, TPE.status, TPE.unit, TPE.department, TPE.parent_id, TPE.year, TPE.gmt_create FROM t_project_engineering TPE INNER JOIN temp_table tb ON TPE.parent_id = tb.id AND TPE.deleted = 0 + TPE.id, TPE.project_info_id, TPE.project_name, TPE.project_type, TPE.investment_amount, TPE.status, TPE.unit, TPE.department, TPE.parent_id, TPE.year, TPE.gmt_create, TPE.build_content FROM t_project_engineering TPE INNER JOIN temp_table tb ON TPE.parent_id = tb.id AND TPE.deleted = 0 ) SELECT - TT.id, TT.project_info_id, TT.project_name, TT.project_type, TT.investment_amount, TT.status, TT.unit, TT.department, TT.parent_id, TT.year, TT.gmt_create, + TT.id, TT.project_info_id, TT.project_name, TT.project_type, TT.investment_amount, TT.status, TT.unit, TT.department, TT.parent_id, TT.year, TT.gmt_create,TT.build_content, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TT.unit) AS project_owner_unit_name, (SELECT SD.dept_name FROM sys_dept SD WHERE SD.dept_id = TT.department) AS competent_department_name, TPP.process_ins_id, TPP.process_def_id -- Gitblit v1.8.0