增加专家导出字段

heheng

2025-05-06 03dc0bda693feaeb2fa684b70db52feea8ea65a7

增加专家导出字段

 expert-system/src/main/java/com/gkhy/system/domain/vo/response/ProjectDataResp.java

@@ -22,4 +22,9 @@
    private Date createTime;
    @ApiModelProperty(value = "事由")
    private String projectName;
    @ApiModelProperty(value = "发现重大隐患")
    private Long majorDangers;
    @ApiModelProperty(value = "发现一般隐患")
    private Long generalHazards;

}

 expert-system/src/main/resources/mapper/system/ProjectManagementMapper.xml

@@ -100,7 +100,7 @@
    </select>

    <select id="selectProjectData" parameterType="ProjectManagement" resultType="com.gkhy.system.domain.vo.response.ProjectDataResp">
        select  a.dept_name deptName,c.name expertName,b.tax_expert_fee expertFee,a.create_time createTime,a.project_name projectName
        select  a.dept_name deptName,c.name expertName,b.tax_expert_fee expertFee,a.create_time createTime,a.project_name projectName,b.major_dangers majorDangers,b.general_hazards generalHazards
        from project_management a
                 left join project_expert b on a.id = b.project_id and b.del_flag = 0 and b.evaluation_state = 1
                 left join sys_expert_info c on b.expert_id = c.id