修改Arima存储逻辑

guoshilong

2023-08-11 4153581dcd5b14eff77442b69c47dc5075178560

修改Arima存储逻辑

 skjcmanager/skjcmanager-service/skjcmanager-nky/src/main/java/cn/gistack/nky/mapper/ArimaPredictMapper.java

 skjcmanager/skjcmanager-service/skjcmanager-nky/src/main/java/cn/gistack/nky/mapper/ArimaPredictMapper.xml

@@ -21,7 +21,7 @@
        </if>
    </select>
    <select id="selectTodayData" resultType="cn.gistack.nky.entity.ArimaPredict">
        SELECT  * FROM NKY_ARIMA_PREDICT
        SELECT  id FROM NKY_ARIMA_PREDICT
        WHERE 1=1
        <if test="entity.createTime != null ">
            AND   DATE_FORMAT(create_time,'%Y-%m-%d')>= DATE_FORMAT(#{entity.createTime},'%Y-%m-%d')

 skjcmanager/skjcmanager-service/skjcmanager-nky/src/main/java/cn/gistack/nky/service/impl/ArimaPredictServiceImpl.java

@@ -89,8 +89,9 @@

        if (list.size()>0){
            //删除该数据，添加最新数据
            baseMapper.deleteById(list.get(0));
            return super.save(entity);
//            baseMapper.deleteById(list.get(0));
//            return super.save(entity);
                return false;
        }else {
            return super.save(entity);
        }

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

@@ -79,10 +79,6 @@

    </select>





    <select id="listRegionCount" resultType="cn.gistack.sm.damSecurity.vo.DamSecurityStatistics">

        SELECT allNum,errorNum, allNum-errorNum normalNum,adName,adCode FROM
@@ -201,6 +197,7 @@
        )

    </select>

    <select id="tableResCount" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">

        SELECT
@@ -437,6 +434,7 @@
        ) info

    </select>

    <select id="alarmResCount" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">
        SELECT
               arb."center_long" AS longitude,
@@ -456,6 +454,7 @@
            AND  (province."ad_code" =#{dam.adCode} or city."ad_code" = #{dam.adCode} or county."ad_code" = #{dam.adCode})
        </if>
    </select>

    <select id="damResInfoCount" resultType="cn.gistack.sm.damSecurity.vo.DamStatisticsRes">


@@ -605,6 +604,7 @@
            ) base

    </select>

    <select id="getResErrorList" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">

        SELECT
@@ -634,8 +634,6 @@
            AND  (province."ad_code" =#{adCode} or city."ad_code" = #{adCode} or county."ad_code" = #{adCode})
        </if>
    </select>



    <select id="getResWyNormalList" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">
        SELECT
@@ -771,7 +769,6 @@
    </select>



    <select id="getSyList" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">
        SELECT
            DISTINCT arb."guid" AS resCd,
@@ -837,8 +834,6 @@
            AND  (province."ad_code" =#{adCode} or city."ad_code" = #{adCode} or county."ad_code" = #{adCode})
        </if>
    </select>


    <select id="getSlList" resultType="cn.gistack.sm.damSecurity.vo.DamStationStatistics">

        SELECT