湖北水库项目
parent: d5aef2e0 | patch | commit | ignore whitespace
xieb
2024-01-29 c569c85e40331a6e20e333f50299255ce21388f7 
sql优化
2 files modified
6 ■■■■■ changed files
skjcmanager/skjcmanager-service-api/skjcmanager-nky-api/src/main/java/cn/gistack/nky/vo/AlarmGetVO.java 2 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/damSecurity/mapper/DamSecurityMapper.xml 4 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service-api/skjcmanager-nky-api/src/main/java/cn/gistack/nky/vo/AlarmGetVO.java


@@ -22,7 +22,7 @@




    private String labels;




    private String adCode;


    private Long adCode;




    private String provinceCode;






 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/damSecurity/mapper/DamSecurityMapper.xml


@@ -1816,11 +1816,11 @@


        </if>




        <if test="vo.startTime != null and vo.startTime != ''">


            AND DATE_FORMAT(NAG.time,'%Y-%m-%d')  &gt;= #{vo.startTime}


            AND NAG.time  &gt;= #{vo.startTime}


        </if>




        <if test="vo.endTime != null and vo.endTime !='' ">


            AND DATE_FORMAT(NAG.time,'%Y-%m-%d') &lt;= #{vo.endTime}


            AND NAG.time &lt;= #{vo.endTime}


        </if>




        <if test="vo.level != null and vo.level !='' ">