统计修改

whyclxw

2025-05-28 eae3d7dfc44e469e90315339dc63efd5a8c2389a

统计修改

 src/main/java/com/whyc/pojo/db_batt_testdata/BatttestdataInf.java

@@ -107,6 +107,13 @@

    @TableField(exist = false)
    private String stationName;

    @TableField(exist = false)
    private String stationId;

    @TableField(exist = false)
    private Integer powerId;

    @TableField(exist = false)
    private String battgroupName;


 src/main/java/com/whyc/pojo/db_ram_db/DeviceState.java

@@ -131,6 +131,13 @@

    @TableField(exist = false)
    private String stationName;

    @TableField(exist = false)
    private String stationId;

    @TableField(exist = false)
    private Integer powerId;

    @TableField(exist = false)
    private String devName;


 src/main/resources/mapper/BatttestdataInfMapper.xml

@@ -4,7 +4,8 @@

    <select id="getBattTinfStatistic" resultType="com.whyc.pojo.db_batt_testdata.BatttestdataInf">
        select tb_batttestdata_inf.*
             ,tb_station_inf.station_name,tb_station_inf.provice,tb_station_inf.city,tb_station_inf.country,tb_station_inf.full_name,tb_batt_inf.battgroup_name
             ,tb_station_inf.station_name,tb_station_inf.provice,tb_station_inf.city,tb_station_inf.country,tb_station_inf.full_name
             ,tb_batt_inf.battgroup_name,tb_batt_inf.power_id,tb_batt_inf.station_id
        from db_batt_testdata.tb_batttestdata_inf,db_station.tb_station_inf,db_station.tb_batt_inf
        <where>
            tb_batttestdata_inf.battgroup_id=tb_batt_inf.battgroup_id

 src/main/resources/mapper/DeviceStateMapper.xml

@@ -5,6 +5,7 @@
    <select id="getDeviceStateStatistic" resultType="com.whyc.pojo.db_ram_db.DeviceState">
        select tb_device_state.*
              ,tb_station_inf.station_name,tb_station_inf.provice,tb_station_inf.city,tb_station_inf.country,tb_station_inf.full_name,tb_batt_inf.dev_name
               ,tb_batt_inf.power_id,tb_batt_inf.station_id
            from  db_ram_db.tb_device_state,db_station.tb_station_inf,db_station.tb_batt_inf
        <where>
            tb_device_state.dev_id=tb_batt_inf.dev_id