实现接口 获取一个巡检员问题上报详情

wuzeyu

2024-12-11 4bd1bd1a4618126858242f4ca4a61c303f5c7529

实现接口  获取一个巡检员问题上报详情

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeIssueReportMapper.java

@@ -63,4 +63,11 @@
     * @return
     */
    Integer deleteIssueReport(Long issueReportId);

    /**
     * 根据问题上报记录主键获取获取巡检员问题上报记录视图对象
     * @param issueReportId
     * @return
     */
    VoIssueReport_temp getIssueReportById(Long issueReportId);
}

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReport.java

@@ -18,7 +18,7 @@
 */

@Data
@JsonPropertyOrder({"issueReportId", "inspectorName", "phone", "reportTime", "content", "images", "audios", "videos", "replyTime", "stateId", "state"})
@JsonPropertyOrder({"issueReportId", "inspectorName", "phone", "reportTime", "content", "images", "audios", "videos", "replyTime","replyContent","replyPersonId", "stateId", "state"})
public class VoIssueReport implements BaseEntity {
    private static final long serialVersionUID = 202412031504001L;


 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReport_temp.java

@@ -17,7 +17,7 @@
 */

@Data
@JsonPropertyOrder({"issueReportId", "inspectorName", "phone", "reportTime", "content", "images", "audios", "videos", "replyTime", "stateId", "state"})
@JsonPropertyOrder({"issueReportId", "inspectorName", "phone", "reportTime", "content", "images", "audios", "videos", "replyTime","replyContent","replyPersonId", "stateId", "state"})
public class VoIssueReport_temp implements BaseEntity {
    private static final long serialVersionUID = 202411121448001L;


 pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeIssueReportMapper.xml

@@ -264,4 +264,28 @@
  <update id="deleteIssueReport">
    UPDATE ope_issue_report SET state = 3 WHERE id = #{issueReportId}
  </update>
  <!--根据问题上报记录主键获取获取巡检员问题上报记录视图对象-->
  <select id="getIssueReportById" resultType="com.dy.pipIrrGlobal.voOp.VoIssueReport_temp">
    SELECT
      rpt.id AS issueReportId,
      us.name AS inspectorName,
      rpt.phone,
      rpt.report_time AS reportTime,
      rpt.content,
      rpt.images,
      rpt.audios,
      rpt.videos,
      rpy.reply_time AS replyTime,
      rpy.reply_content AS replyContent,
      rpy.replier_id AS replyPersonId,
      rpt.state AS stateId,
      CASE
        WHEN rpt.state = 1 THEN '未受理'
        WHEN rpt.state = 2 THEN '已受理'
        END AS state
    FROM ope_issue_report rpt
           LEFT JOIN ba_user us ON us.id = rpt.inspector_id
           LEFT JOIN ope_report_reply rpy ON rpy.report_id = rpt.id
    where rpt.state != 3 AND rpt.id = #{issueReportId}
  </select>
</mapper>

 pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java

@@ -75,6 +75,26 @@
    }

    /**
     * 获取一个巡检员问题上报记录详情
     * @param issueReportId
     * @return
     */
    @GetMapping(path = "/getOneIssueReport")
    @SsoAop()
    public BaseResponse<VoIssueReport> getOneIssueReport(@RequestParam("issueReportId") Long issueReportId) {
        try {
            VoIssueReport issueReport = issueSv.getIssueReportById(issueReportId);
            if(issueReport == null) {
                return BaseResponseUtils.buildNonExist();
            }
            return BaseResponseUtils.buildSuccess(issueReport);
        } catch (Exception e) {
            log.error("获取问题上报记录详情异常", e);
            return BaseResponseUtils.buildException(e.getMessage());
        }
    }

    /**
     * 逻辑删除巡检员问题上报，删除前先判断要删除的上报是否存在
     * @param po
     * @param bindingResult

 pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java

@@ -106,6 +106,27 @@
    }

    /**
     * 根据问题上报记录主键获取获取巡检员问题上报记录视图对象
     * @param issueReportId
     * @return
     */
    public VoIssueReport getIssueReportById(Long issueReportId) {
        VoIssueReport_temp issueReport = opeIssueReportMapper.getIssueReportById(issueReportId);

        VoIssueReport report = new VoIssueReport();
        BeanUtils.copyProperties(issueReport, report);

        JSONArray images_array = Optional.ofNullable(JSON.parseArray(issueReport.getImages())).orElse(new JSONArray());
        JSONArray audios_array = Optional.ofNullable(JSON.parseArray(issueReport.getAudios())).orElse(new JSONArray());
        JSONArray videos_array = Optional.ofNullable(JSON.parseArray(issueReport.getVideos())).orElse(new JSONArray());

        report.setImages(images_array);
        report.setAudios(audios_array);
        report.setVideos(videos_array);
        return report;
    }

    /**
     * 逻辑删除巡检员问题上报，删除前先判断要删除的上报是否存在
     * @param po
     * @return