首页点击统计查询详细机房

lxw

2023-03-15 8e31156782d9afdc53ac3b3148139e9d7fcdeecc

首页点击统计查询详细机房

 src/main/java/com/whyc/pojo/StationInf.java

@@ -65,4 +65,7 @@

    @TableField(exist = false)
    private Integer devWorkState;

    @TableField(exist = false)
    private Fbs9100State fbs9100State;
}

 src/main/resources/mapper/StationInfMapper.xml

@@ -18,6 +18,10 @@
        <collection property="acdc" javaType="com.whyc.pojo.PwrdevAcdcdata" ofType="com.whyc.pojo.PwrdevAcdcdata"
                    column="{stationId=stationId}" select="selectAcDcdata">
        </collection>
        <collection property="fbs9100State" javaType="com.whyc.pojo.Fbs9100State"
                    ofType="com.whyc.pojo.Fbs9100State"
                    column="{stationId=stationId}" select="selectFbs9100State">
        </collection>

    </resultMap>

@@ -42,6 +46,15 @@
            where tb_battinf.stationid = #{stationId}
        )
    </select>
    <select id="selectFbs9100State" resultType="Fbs9100State">
        select tb_fbs9100_state.*
        from db_ram_db.tb_fbs9100_state
        where tb_fbs9100_state.dev_id in (
            select distinct FBSDeviceId
            from db_battinf.tb_battinf
            where tb_battinf.stationid = #{stationId}
        )
    </select>
    <select id="selectAcdata" resultType="pwrdevAcdata">
        select tb_pwrdev_acdata.*
        from db_pwrdev_data_rt.tb_pwrdev_acdata