添加接口获取最新的已审核的报汛记录

guoshilong

2023-05-25 646ba315abc414eb95046d556ac685d1b47a2370

添加接口获取最新的已审核的报汛记录

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/controller/ReportFloodRecordController.java

@@ -48,8 +48,6 @@
                reportFloodRecord.setAdCode(code.substring(0,4));
            }
        }


        IPage<ReportFloodRecordVO> pageList = reportFloodRecordService.selectReportFloodRecordPages(Condition.getPage(query), reportFloodRecord);
        return R.data(pageList);
    }
@@ -114,5 +112,18 @@
        ReportFloodRecord reportFloodRecord = reportFloodRecordService.getById(id);
        return R.data(reportFloodRecord);
    }

    /**
     * 根据水库id返回最新审核通过的报汛记录
     *
     * @param reservoirId
     * @return
     */
    @ApiOperation(value = "报汛记录-根据水库id返回最新审核通过的报汛记录", notes = "报汛记录-根据水库id返回最新审核通过的报汛记录")
    @GetMapping(value = "/getLatestRecord")
    public R getLatestRecord(String reservoirId) {
        ReportFloodRecord reportFloodRecord = reportFloodRecordService.getLatestRecord(reservoirId);
        return R.data(reportFloodRecord);
    }
}


 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.java

@@ -17,4 +17,6 @@
    List<ReportFloodRecordVO> selectReportFloodRecordPages(IPage<ReportFloodRecordVO> page, @Param("reportFloodRecord") ReportFloodRecordVO reportFloodRecord);

    ReportFloodRecordVO customizeGetDetail(@Param("reportFloodRecord") ReportFloodRecordVO reportFloodRecordVO);

    ReportFloodRecord getLatestRecord(@Param("reservoirId") String reservoirId);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml

@@ -49,4 +49,9 @@
    <select id="customizeGetDetail" resultMap="vo">

    </select>
    <select id="getLatestRecord" resultType="cn.gistack.sm.reportFlood.entity.ReportFloodRecord">
        SELECT * FROM SM_REPORT_FLOOD_RECORD
        WHERE IS_DELETED = 0 AND IS_AUDIT = 20
        ORDER BY UPDATE_TIME DESC LIMIT 1
    </select>
</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/service/IReportFloodRecordService.java

@@ -14,4 +14,6 @@
    IPage<ReportFloodRecordVO> selectReportFloodRecordPages(IPage<ReportFloodRecordVO> page, ReportFloodRecordVO reportFloodRecord);

    ReportFloodRecordVO customizeGetDetail(ReportFloodRecordVO reportFloodRecordVO);

    ReportFloodRecord getLatestRecord(String reservoirId);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/service/impl/ReportFloodRecordServiceImpl.java

@@ -52,6 +52,11 @@
        return baseMapper.customizeGetDetail(reportFloodRecordVO);
    }

    @Override
    public ReportFloodRecord getLatestRecord(String reservoirId) {
        return baseMapper.getLatestRecord(reservoirId);
    }

    /**
     * 根据水库id和责任人类型获取用户
     * @param type 责任人类型