battInf/findBattProducerInfoByTime添加fbsDeviceId查询

whyczh

2022-06-29 fe4f455fc67d32d66914d2fced11915958d8ff1d

battInf/findBattProducerInfoByTime添加fbsDeviceId查询

 src/main/resources/mapper/BattInfMapper.xml

@@ -319,6 +319,7 @@
            <result property="stationInstall" column="station_install"></result>
            <result property="installUser" column="install_user"></result>
            <result property="loadCurr" column="load_curr"></result>
            <result property="fBSDeviceId" column="FBSDeviceId"></result>
        </association>
        <association property="battEndurance" javaType="com.whyc.pojo.BattEndurance">
            <result property="num" column="num"></result>
@@ -369,7 +370,7 @@
    </select>

    <select id="findBattProducerInfoByTime" resultMap="BattInfAndEndurance">
        select StationName,StationName3,BattGroupId,BattModel,BattProducer,BattProductDate,BattInUseDate,station_install,install_user,load_curr,bEnd.*
        select StationName,StationName3,BattGroupId,BattModel,BattProducer,BattProductDate,BattInUseDate,station_install,install_user,load_curr,FBSDeviceId,bEnd.*
        from db_battinf.tb_battinf bInf left join web_site.tb_batt_endurance bEnd on bInf.FBSDeviceId = bEnd.deviceid
       <where>
        <if test="startTime!=null and endTime!=null">