获取站点下的电池组(下拉)

whyclxw

2025-06-13 7cb660935b6c925dc2a0953cfbfb076e6b5a9f94

获取站点下的电池组(下拉)

 src/main/java/com/whyc/controller/ConditionController.java

@@ -81,6 +81,13 @@
        User uinf= ActionUtil.getUser();
        return stationInfService.getPowerByUid(uinf.getId(),provice,city,country,stationName);
    }
    @ApiOperation("获取站点下的电池组(下拉)")
    @GetMapping("getBattByUid")
    public Response getBattByUid(@RequestParam(required = false) String provice,@RequestParam(required = false) String city
            ,@RequestParam(required = false) String country,@RequestParam(required = false) String stationName) {
        User uinf= ActionUtil.getUser();
        return binfService.getBattByUid(uinf.getId(),provice,city,country,stationName);
    }

    @ApiOperation("获取电压等级(下拉)")
    @GetMapping("getStationType")

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

@@ -55,5 +55,8 @@
    List<BattInf> getDischrChart(@Param("uid") Integer uid);

    List<BattInf> getListByUserId(Integer userId);
    //获取站点下的电池组(下拉)
    List<BattInf> getBattByUid(@Param("uid") Integer uid, @Param("provice") String provice, @Param("city") String city, @Param("country") String country, @Param("stationName") String stationName);


}

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

@@ -477,4 +477,10 @@
    public List<BattInf> getListByUserId(Integer userId) {
        return mapper.getListByUserId(userId);
    }

    //获取站点下的电池组(下拉)
    public Response getBattByUid(Integer uid, String provice, String city, String country, String stationName) {
        List<BattInf> list=mapper.getBattByUid(uid,provice,city,country,stationName);
        return new Response().setII(1,list.size()>0,list,"获取站点下的电池组(下拉)");
    }
}

 src/main/resources/mapper/BattInfMapper.xml

@@ -426,4 +426,30 @@
            and bu.uid = #{userId}
        )
    </select>

    <select id="getBattByUid" resultType="com.whyc.pojo.db_station.BattInf">
        select distinct * from db_station.tb_batt_inf,db_station.tb_station_inf
        <where>
            tb_batt_inf.station_id=tb_station_inf.station_id
            <if test="provice!=null">
                and tb_station_inf.provice=#{provice}
            </if>
            <if test="city!=null">
                and tb_station_inf.city=#{city}
            </if>
            <if test="country!=null">
                and tb_station_inf.country=#{country}
            </if>
            <if test="stationName!=null">
                and tb_station_inf.station_name=#{stationName}
            </if>
            <if test="uid>100">
                and tb_station_inf.station_id in(
                select distinct station_id from db_user.tb_baojigroup_power,db_user.tb_baojigroup_usr
                where   tb_baojigroup_power.baoji_group_id=tb_baojigroup_usr.baoji_group_id
                and tb_baojigroup_usr.uid=#{uid}
                )
            </if>
        </where>
    </select>
</mapper>