更新

whycxzp

2023-07-28 7b30f6279f17e9de182ab57efa2639bc04e42dcc

更新

 src/main/resources/mapper/BattInfMapper.xml

@@ -376,10 +376,10 @@
        StationName,StationName1,StationName2,StationName3,StationName5,BattGroupId,BattModel,BattProducer,BattProductDate,BattInUseDate,station_install,install_user,load_curr,bEnd.*
        from db_battinf.tb_battinf bInf left join web_site.tb_batt_endurance bEnd on bInf.FBSDeviceId = bEnd.deviceid
        <if test="year&lt;=7">
            where TIMESTAMPDIFF(YEAR,BattInUseDate,CURDATE())&lt;= #{year}
            where TIMESTAMPDIFF(YEAR,BattInUseDate,CURDATE())&lt; #{year}
        </if>
        <if test="year==8">
            where TIMESTAMPDIFF(YEAR,BattInUseDate,CURDATE())>7
            where TIMESTAMPDIFF(YEAR,BattInUseDate,CURDATE())&gt;=7
        </if>
        <if test="userId!=null and userId!=0">
            and BattgroupId in(select distinct db_battinf.tb_battinf.battgroupid