蓄电池品牌信息统计

whycxzp

2025-06-13 a72e89fb45078cca405d7558897054addacfed07

蓄电池品牌信息统计

 src/main/java/com/whyc/mapper/BattInfMapper.java

@@ -54,4 +54,6 @@
    //本年度已/未放电数量统计右侧图表(1.2.5)
    List<BattInf> getDischrChart(@Param("uid") Integer uid);

    List<BattInf> getListByUserId(Integer userId);

}

 src/main/java/com/whyc/service/BattInfService.java

@@ -473,4 +473,8 @@
    public List<BattInf> getDischrChart(Integer uid) {
        return mapper.getDischrChart(uid);
    }

    public List<BattInf> getListByUserId(Integer userId) {
        return mapper.getListByUserId(userId);
    }
}

 src/main/resources/mapper/BattInfMapper.xml

@@ -418,4 +418,12 @@
            order by tb_batt_inf.dev_id asc,battgroup_id asc
        </where>
    </select>
    <select id="getListByUserId" resultType="com.whyc.pojo.db_station.BattInf">
        select * from db_station.tb_batt_inf where battgroup_id in(
            select distinct battgroup_id from db_user.tb_baojigroup_usr bu,db_user.tb_baojigroup_power bp,db_station.tb_batt_inf bi
            where bu.baoji_group_id = bp.baoji_group_id
            and bp.station_id = bi.station_id
            and bu.uid = #{userId}
        )
    </select>
</mapper>