包机组管理

whyclxw

2024-08-28 3610615ead38033524ef6dfec5d3657d9e6f8d9e

包机组管理

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

@@ -2,13 +2,18 @@

import com.whyc.dto.Response;
import com.whyc.pojo.db_lithium_ram_db.DevInf;
import com.whyc.pojo.db_user.BattgroupBaojigroup;
import com.whyc.pojo.db_user.BattgroupUsr;
import com.whyc.service.BaojigroupService;
import com.whyc.service.BattgroupBaojigroupService;
import com.whyc.service.BattgroupUsrService;
import com.whyc.service.DevInfService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@Api(tags = "包机组管理")
@@ -18,12 +23,59 @@
    private BattgroupBaojigroupService groupService;

    @Autowired
    private BattgroupUsrService usrService;

    @Autowired
    private BaojigroupService baojiService;


    @ApiOperation(value = "包机组下添加设备")
    @PostMapping("addBaoji")
    @ApiOperation(value = "添加包机组")
    @GetMapping("addBaoji")
    public Response addBaoji(@RequestParam String baojiName){
        return baojiService.addBaoji(baojiName);
    }

    @ApiOperation(value = "删除包机组及以下设备和用户")
    @PostMapping("delBaoji")
    public Response delBaoji(@RequestParam List<Integer> baojiIdList){
        return baojiService.delBaoji(baojiIdList);
    }

    @ApiOperation(value = "编辑包机组")
    @GetMapping("updateBaoji")
    public Response updateBaoji(@RequestParam int baojiGroupId){
        return baojiService.updateBaoji(baojiGroupId);
    }

    @ApiOperation(value = "查询所有的包机组及包机组下设备信息和管理人")
    @PostMapping("getBaojiInfo")
    public Response getBaojiInfo(){
        return baojiService.getBaojiInfo();
    }

    @ApiOperation(value = "包机组下添加设备")
    @PostMapping("addDevInBaoji")
    public Response addDevInBaoji(@RequestBody List<BattgroupBaojigroup> devList){
        return groupService.addDevInBaoji(devList);
    }

    @ApiOperation(value = "包机组下移除设备")
    @PostMapping("delDevInBaoji")
    public Response delDevInBaoji(@RequestBody List<BattgroupBaojigroup> devList){
        return groupService.delDevInBaoji(devList);
    }


    @ApiOperation(value = "包机组下添加用户")
    @PostMapping("addUsrInBaoji")
    public Response addUsrInBaoji(@RequestBody List<BattgroupUsr> usrList){
        return usrService.addUsrInBaoji(usrList);
    }

    @ApiOperation(value = "包机组下移除用户")
    @PostMapping("delUsrInBaoji")
    public Response delUsrInBaoji(@RequestBody List<BattgroupUsr> usrList){
        return usrService.delUsrInBaoji(usrList);
    }

}

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

@@ -2,5 +2,12 @@

import com.whyc.pojo.db_user.Baojigroup;

import java.util.List;

public interface BaojigroupMapper extends CustomMapper<Baojigroup>{
    //获取最大的包机组编号
    Integer getMaxBaojiGroupId();

    //查询所有的包机组及包机组下设备信息和管理人
    List<Baojigroup> getBaojiInfo();
}

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

@@ -2,5 +2,10 @@

import com.whyc.pojo.db_user.BattgroupBaojigroup;

import java.util.List;

public interface BattgroupBaojigroupMapper extends CustomMapper<BattgroupBaojigroup>{

    //包机组下移除设备
    void delDevInBaoji(List<BattgroupBaojigroup> devList);
}

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

New file
@@ -0,0 +1,9 @@
package com.whyc.mapper;

import com.whyc.pojo.db_user.BattgroupUsr;

import java.util.List;

public interface BattgroupUsrMapper extends CustomMapper<BattgroupUsr>{
    void delUsrInBaoji(List<BattgroupUsr> usrList);
}

 src/main/java/com/whyc/pojo/db_user/Baojigroup.java

@@ -1,14 +1,17 @@
package com.whyc.pojo.db_user;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.whyc.pojo.db_lithium_ram_db.DevInf;
import io.swagger.annotations.ApiModel;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.List;

/**
 * <p>
@@ -34,5 +37,11 @@

    private String baojiGroupName;

    @TableField(exist = false)
    private List<BattgroupBaojigroup> usrList;

    @TableField(exist = false)
    private List<DevInf> devList;


}

 src/main/java/com/whyc/pojo/db_user/BattgroupBaojigroup.java

@@ -34,7 +34,5 @@

    private Integer devId;

    private Integer userId;


}

 src/main/java/com/whyc/pojo/db_user/BattgroupUsr.java

New file
@@ -0,0 +1,28 @@
package com.whyc.pojo.db_user;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;

@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_user",value ="tb_battgroup_usr")
@ApiModel(value="BattgroupUsr对象", description="")
public class BattgroupUsr implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    private Integer baojiGroupId;

    private Integer uid;
}

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

@@ -1,21 +1,81 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.BaojigroupMapper;
import com.whyc.mapper.BattgroupBaojigroupMapper;
import com.whyc.mapper.BattgroupUsrMapper;
import com.whyc.pojo.db_user.Baojigroup;
import com.whyc.pojo.db_user.BattgroupBaojigroup;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
public class BaojigroupService {
    @Autowired(required = false)
    private BaojigroupMapper mapper;

    @Autowired(required = false)
    private BattgroupBaojigroupMapper groupMapper;

    @Autowired(required = false)
    private BattgroupUsrMapper usrMapper;

    //包机组下添加设备
    public Response addBaoji(String baojiName) {
        Baojigroup baojigroup=new Baojigroup();
        //获取最大的包机组编号
        Integer baojiGroupId=getMaxBaojiGroupId();
        baojigroup.setBaojiGroupId(baojiGroupId);
        baojigroup.setBaojiGroupName(baojiName);
        int bl=mapper.insert(baojigroup);
        return new Response().set(1,bl>0);
    }
    //获取最大的包机组编号
    private Integer getMaxBaojiGroupId() {
        //查询该类型最大设备编号
        Integer baojiGroupId=mapper.getMaxBaojiGroupId();
        if(baojiGroupId==null){
            baojiGroupId=1000;
        }
        return baojiGroupId+1;
    }

    //删除包机组
    @Transactional
    public Response delBaoji(List<Integer> baojiIdList) {
        if(baojiIdList!=null){
            for (Integer baojiId:baojiIdList) {
                //删除包机组
                UpdateWrapper baojiWrapper=new UpdateWrapper();
                baojiWrapper.eq("baoji_group_id",baojiId);
                mapper.delete(baojiWrapper);
                //删除包机组下机房
                UpdateWrapper groupWrapper=new UpdateWrapper();
                groupWrapper.eq("baoji_group_id",baojiId);
                groupMapper.delete(groupWrapper);
                //删除包机组下用户
                UpdateWrapper usrWrapper=new UpdateWrapper();
                usrWrapper.eq("baoji_group_id",baojiId);
                usrMapper.delete(usrWrapper);
            }
        }
        return new Response().set(1,"删除包机组");
    }
   //编辑包机组
    public Response updateBaoji(int baojiGroupId) {
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("baoji_group_id",baojiGroupId);
        int flag=mapper.update(null,wrapper);
        return new Response().set(1,flag>0);
    }
    //查询所有的包机组及包机组下设备信息和管理人
    public Response getBaojiInfo() {
        List<Baojigroup> list=mapper.getBaojiInfo();
        return new Response().setII(1,list!=null,list,"");
    }

}

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

@@ -1,7 +1,28 @@
package com.whyc.service;

import com.whyc.dto.Response;
import com.whyc.mapper.BattgroupBaojigroupMapper;
import com.whyc.pojo.db_user.BattgroupBaojigroup;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class BattgroupBaojigroupService {
    @Autowired(required = false)
    private BattgroupBaojigroupMapper mapper;



    //包机组下添加设备
    public Response addDevInBaoji(List<BattgroupBaojigroup> devList) {
        int flag=mapper.insertBatchSomeColumn(devList);
        return new Response().set(1,flag>0);
    }
    //包机组下移除设备
    public Response delDevInBaoji(List<BattgroupBaojigroup> devList) {
        mapper.delDevInBaoji(devList);
        return new Response().set(1,"移除成功");
    }
}

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

New file
@@ -0,0 +1,27 @@
package com.whyc.service;

import com.whyc.dto.Response;
import com.whyc.mapper.BattgroupBaojigroupMapper;
import com.whyc.mapper.BattgroupUsrMapper;
import com.whyc.pojo.db_user.BattgroupUsr;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class BattgroupUsrService {
    @Autowired(required = false)
    private BattgroupUsrMapper mapper;

    //包机组下添加用户
    public Response addUsrInBaoji(List<BattgroupUsr> usrList) {
        int flag=mapper.insertBatchSomeColumn(usrList);
        return new Response().set(1,flag>0);
    }
    //包机组下移除用户
    public Response delUsrInBaoji(List<BattgroupUsr> usrList) {
        mapper.delUsrInBaoji(usrList);
        return new Response().set(1,"移除成功");
    }
}

 src/main/resources/mapper/BaojigroupMapper.xml

New file
@@ -0,0 +1,36 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.BaojigroupMapper">

    <select id="getMaxBaojiGroupId" resultType="java.lang.Integer">
        select max(baoji_group_id) from db_user.tb_baojigroup
        limit 1
    </select>

    <resultMap id="baojiList" type="baojigroup">
        <id property="num" column="num"></id>
        <result property="baojiGroupId" column="baoji_group_id"></result>
        <result property="baojiGroupName" column="baoji_group_name"></result>
        <collection property="usrList" javaType="java.util.ArrayList" ofType="com.whyc.pojo.db_user.BattgroupUsr" column="{baojiGroupId=baoji_group_id}" select="selectUsrList">
        </collection>
        <collection property="devList" javaType="java.util.ArrayList" ofType="com.whyc.pojo.db_lithium_ram_db.DevInf" column="{baojiGroupId=baoji_group_id}" select="selectDevList">
        </collection>
    </resultMap>

    <select id="selectUsrList" resultType="battgroupUsr">
        select * from db_user.tb_battgroup_usr
        <where>
            baoji_group_id=#{baojiGroupId}
        </where>
        order by baoji_group_id asc
    </select>

    <select id="getBaojiInfo" resultType="devInf">
        select tb_dev_inf.* from db_lithium_ram_db.tb_dev_inf,db_user.tb_battgroup_baojigroup
        <where>
            tb_dev_inf.dev_id=tb_battgroup_baojigroup.dev_id
            and tb_battgroup_baojigroup.baoji_group_id=#{baojiGroupId}
        </where>
    </select>

</mapper>

 src/main/resources/mapper/BattgroupBaojigroupMapper.xml

New file
@@ -0,0 +1,9 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.BattgroupBaojigroupMapper">
    <delete id="delDevInBaoji">
        <foreach collection="list" item="item" separator=";" >
            delete from db_user.tb_battgroup_baojigroup where baoji_group_id = #{item.baojiGroupId} and dev_id = #{item.devId}
        </foreach>
    </delete>
</mapper>

 src/main/resources/mapper/BattgroupUsrMapper.xml

New file
@@ -0,0 +1,10 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.BattgroupUsrMapper">

    <delete id="delUsrInBaoji">
        <foreach collection="list" item="item" separator=";" >
            delete from db_user.tb_battgroup_usr where baoji_group_id = #{item.baojiGroupId} and uid = #{item.uid}
        </foreach>
    </delete>
</mapper>