人工上报时间筛选

aix

2024-08-01 cbe116e3cdd3ba28d13cde9d203f542d651e8ee3

人工上报时间筛选

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

@@ -104,10 +104,10 @@
            AND r.reservoir_id = #{reportFloodRecord.reservoirId}
        </if>
        <if test="reportFloodRecord.startTime !=null and reportFloodRecord.startTime !=''">
            AND DATE_FORMAT(r.report_time,'%Y-%m-%d') &gt;= #{reportFloodRecord.startTime}
            AND r.report_time &gt;= #{reportFloodRecord.startTime}
        </if>
        <if test="reportFloodRecord.endTime !=null and reportFloodRecord.endTime !=''">
            AND DATE_FORMAT(r.report_time,'%Y-%m-%d') &lt;= #{reportFloodRecord.endTime}
            AND r.report_time &lt;= #{reportFloodRecord.endTime}
        </if>
        <if test="reportFloodRecord.createUser !=null and reportFloodRecord.createUser !=''">
            AND r.create_user = #{reportFloodRecord.createUser}