基础数据库bug修改

tangxiaobao

2021-07-27 e9f4b1002914c7eb7a426b7a163bf49079f61d2f

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java

@@ -25,9 +25,9 @@
            "cspr.id, " +
            "cspr.community_id AS communityId, " +
            "cspr.patrol_time AS patrolTime, " +
            "cspr.weather" +
            "cspr.temperature" +
            "cspr.wind" +
            "cspr.weather," +
            "cspr.temperature," +
            "cspr.wind," +
            "cspr.patrol_type AS patrolType, " +
            "cspr.patrol_person AS patrolPerson, " +
            "cspr.address, " +
@@ -38,11 +38,11 @@
            "cspr.succession_person AS successionPerson, " +
            "cspr.succession_time AS successionTime, " +
            "cspr.create_at AS createAt, " +
            "cspr.create_time AS createTime," +
            "cspr.create_by AS createBy, " +
            "csprr.report_id AS reportId" +
            "FROM  " +
            "com_sw_patrol_record AS cspr" +
            "left join com_sw_patrol_record_report AS csprr on cspr.id = csprr.patrol_record_id" +
            "com_sw_patrol_record as cspr " +
            "left join com_sw_patrol_record_report as csprr on csprr.patrol_record_id = cspr.id " +
            "<where>" +
            "<if test='comSwPatrolRecordDTO.communityId != null and comSwPatrolRecordDTO.communityId != &quot;&quot;'>" +
            "AND cspr.community_id = #{comSwPatrolRecordDTO.communityId} " +
@@ -60,7 +60,7 @@
            "AND cspr.patrol_time <![CDATA[ <= ]]> #{comSwPatrolRecordDTO.patrolTime}  " +
            " </if> " +
            " </where>" +
            " order by create_at desc" +
            " order by cspr.create_at desc" +
            "</script>")
    IPage<ComSwPatrolRecordVO> pagePatrolRecord(Page page, @Param("comSwPatrolRecordDTO") ComSwPatrolRecordDTO comSwPatrolRecordDTO);
}