机房，电源，电池组信息管理修改

whyclxw

2025-05-17 feaaad2d357f5084d21f14a6929fe208b4c4ad0e

机房，电源，电池组信息管理修改

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

@@ -112,6 +112,13 @@
        return powerInfService.getCompanyByUid(uinf.getId());
    }

    @ApiOperation("获取电源型号(下拉)")
    @GetMapping("getPowerModelByUid")
    public Response getPowerModelByUid() {
        User uinf= ActionUtil.getUser();
        return powerInfService.getPowerModelByUid(uinf.getId());
    }


    @ApiOperation(value = "当前用户所在包机组下所有的用户(下拉)")
    @GetMapping("getBaojiUserByUid")

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

@@ -17,4 +17,6 @@
    int getMaxPowerNum(@Param("stationId") Integer stationId);
    //获取电源品牌(下拉)
    List<String> getCompanyByUid(Integer uid);
    //获取电源型号(下拉)
    List<String> getPowerModelByUid(Integer uid);
}

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

@@ -151,6 +151,14 @@
        if(sinf.getStationName()!=null){
            wrapper1.set("station_name",sinf.getStationName());
            String fullName=sinf.getProvice()+"_"+sinf.getCity()+"_"+sinf.getCountry()+"_"+sinf.getStationName();
            //检测该机房下要修改的电源名是否存在
            QueryWrapper queryWrapper=new QueryWrapper();
            queryWrapper.eq("full_name",fullName);
            queryWrapper.last("limit 1");
            StationInf jueges=sinfMapper.selectOne(queryWrapper);
            if(jueges!=null){
                return new Response().set(1,false,"已存在"+fullName+"的机房");
            }
            wrapper1.set("full_name",fullName);
        }
        if(sinf.getStationType()!=null){
@@ -180,11 +188,11 @@
        }
        if(pinf.getPowerName()!=null){
            //检测该机房下要修改的电源名是否存在
            QueryWrapper queryWrapper=new QueryWrapper();
            queryWrapper.eq("power_name",pinf.getPowerName());
            queryWrapper.eq("station_id",sinf.getStationId());
            queryWrapper.last("limit 1");
            PowerInf juegep=pinfMapper.selectOne(queryWrapper);
            QueryWrapper queryWrapper1=new QueryWrapper();
            queryWrapper1.eq("power_name",pinf.getPowerName());
            queryWrapper1.eq("station_id",sinf.getStationId());
            queryWrapper1.last("limit 1");
            PowerInf juegep=pinfMapper.selectOne(queryWrapper1);
            if(juegep!=null){
                return new Response().set(1,false,"该机房下已存在"+pinf.getPowerName()+"的电源");
            }
@@ -201,11 +209,11 @@
            }
            if (binf.getDevName() != null) {
                //检测该电源下修改的设备名是否存在
                QueryWrapper queryWrapper1 = new QueryWrapper();
                queryWrapper1.eq("dev_name", binf.getDevName());
                queryWrapper1.eq("power_id", pinf.getPowerId());
                queryWrapper1.last("limit 1");
                BattInf jueged = mapper.selectOne(queryWrapper1);
                QueryWrapper queryWrapper2 = new QueryWrapper();
                queryWrapper2.eq("dev_name", binf.getDevName());
                queryWrapper2.eq("power_id", pinf.getPowerId());
                queryWrapper2.last("limit 1");
                BattInf jueged = mapper.selectOne(queryWrapper2);
                if (jueged != null) {
                    return new Response().set(1, false, "该电源下已存在" + binf.getDevName() + "的设备");
                }
@@ -220,11 +228,11 @@
            UpdateWrapper wrapper4 = new UpdateWrapper();
            if (binf.getBattgroupName() != null) {
                //检测该机房下要修改的电源名是否粗在
                QueryWrapper queryWrapper = new QueryWrapper();
                queryWrapper.eq("battgroup_name", binf.getBattgroupName());
                queryWrapper.eq("dev_id", binf.getDevId());
                queryWrapper.last("limit 1");
                BattInf juegeb = mapper.selectOne(queryWrapper);
                QueryWrapper queryWrapper3 = new QueryWrapper();
                queryWrapper3.eq("battgroup_name", binf.getBattgroupName());
                queryWrapper3.eq("dev_id", binf.getDevId());
                queryWrapper3.last("limit 1");
                BattInf juegeb = mapper.selectOne(queryWrapper3);
                if (juegeb != null) {
                    return new Response().set(1, false, "该设备下已存在" + binf.getBattgroupName() + "的电池组");
                }

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

@@ -86,4 +86,9 @@
        List<String> list=mapper.getCompanyByUid(uid);
        return new Response().setII(1,list.size()>0,list,"获取电源品牌(下拉)");
    }
    //获取电源型号(下拉)
    public Response getPowerModelByUid(Integer uid) {
        List<String> list=mapper.getPowerModelByUid(uid);
        return new Response().setII(1,list.size()>0,list,"获取电源型号(下拉)");
    }
}

 src/main/resources/mapper/PowerInfMapper.xml

@@ -53,5 +53,17 @@
            </if>
        </where>
    </select>
    <select id="getPowerModelByUid" resultType="java.lang.String">
        select distinct power_model from db_station.tb_power_inf
        <where>
            <if test="uid>100">
                and tb_power_inf.power_id in(
                select distinct power_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>