钥匙管理

whyclxw

2024-11-27 579633f4aca4bc11b04b1497d8c1b7175aff697e

钥匙管理

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

@@ -51,4 +51,10 @@
        return service.getLinfById(id);
    }

    @ApiOperation(value = "查询所有区域下所有钥匙信息")
    @GetMapping("getKinfById")
    public Response getKinfById(@RequestParam Integer id){
        return service.getKinfById(id);
    }

}

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

New file
@@ -0,0 +1,43 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.pojo.db_area.KeyInf;
import com.whyc.service.KeyInfService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@RestController
@Api(tags = "钥匙管理")
@RequestMapping("lockInf")
public class KeyInfController {
    @Autowired
    private KeyInfService service;

    @ApiOperation(value = "查询所有钥匙信息")
    @GetMapping("getAllKeyInf")
    public Response getAllKeyInf(@RequestParam(required = false) String keyName, @RequestParam(required = false) String uname
            , int pageNum, int pageSize){
        return service.getAllKeyInf(keyName,uname,pageNum,pageSize);
    }

    @ApiOperation(value = "添加钥匙")
    @PostMapping("addKeyk")
    public Response addKeyk(@RequestBody KeyInf kinf){
        return service.addKeyk(kinf);
    }


    @ApiOperation(value = "删除钥匙")
    @GetMapping("delKey")
    public Response delKey(@RequestParam Integer id){
        return service.delKey(id);
    }

    @ApiOperation(value = "修改钥匙")
    @PostMapping("updateKey")
    public Response updateKey(@RequestBody KeyInf kinf){
        return service.updateKey(kinf);
    }
}

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

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

import com.whyc.pojo.db_area.KeyInf;

public interface KeyInfMapper extends CustomMapper<KeyInf>{
}

 src/main/java/com/whyc/pojo/db_area/KeyInf.java

New file
@@ -0,0 +1,56 @@
package com.whyc.pojo.db_area;

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

import java.io.Serializable;
import java.util.Date;

/**
 * <p>
 * 
 * </p>
 *
 * @author lxw
 * @since 2024-11-27
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_area",value ="tb_key_inf")
@ApiModel(value="KeyInf对象", description="")
public class KeyInf implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "区域id")
    private Integer areaId;

    @ApiModelProperty(value = "归属人")
    private String uname;

    @ApiModelProperty(value = "钥匙类型(实体,蓝牙,设备)")
    private String keyType;

    @ApiModelProperty(value = "钥匙名称")
    private String keyName;

    @ApiModelProperty(value = "钥匙编号")
    private String keyNumber;

    @ApiModelProperty(value = "蓝牙地址")
    private String keyAddress;

    private Date createName;


}

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

@@ -4,9 +4,11 @@
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.AreaInfMapper;
import com.whyc.mapper.KeyInfMapper;
import com.whyc.mapper.LockInfMapper;
import com.whyc.mapper.UserInfMapper;
import com.whyc.pojo.db_area.AreaInf;
import com.whyc.pojo.db_area.KeyInf;
import com.whyc.pojo.db_area.LockInf;
import com.whyc.pojo.db_user.UserInf;
import org.springframework.beans.factory.annotation.Autowired;
@@ -24,6 +26,9 @@

    @Autowired(required = false)
    private LockInfMapper linfMapper;

    @Autowired(required = false)
    private KeyInfMapper kinfMapper;

    @Autowired(required = false)
    private UserInfMapper uInfMapper;
@@ -170,4 +175,15 @@
            }
        }
    }
   //查询所有区域下所有钥匙信息
    public Response getKinfById(Integer id) {
        //获取获取id下所有的区域id
        List areaList=new ArrayList();
        areaList.add(id);
        getAllAreaId(id,areaList);
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.in("area_id",areaList);
        List<KeyInf> list=kinfMapper.selectList(wrapper);
        return new Response().setII(1,list!=null,list,"查询所有区域下所有钥匙信息");
    }
}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.KeyInfMapper;
import com.whyc.pojo.db_area.KeyInf;
import com.whyc.pojo.db_area.LockInf;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;

@Service
public class KeyInfService {
    @Autowired(required = false)
    private KeyInfMapper mapper;
    //查询所有钥匙信息
    public Response getAllKeyInf(String keyName, String uname, int pageNum, int pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper wrapper=new QueryWrapper();
        if(keyName!=null){
            wrapper.like("key_name",keyName);
        }
        if(uname!=null){
            wrapper.eq("uname",uname);
        }
        List<LockInf> list=mapper.selectList(wrapper);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"查询所有钥匙信息");
    }
    //添加钥匙
    public Response addKeyk(KeyInf kinf) {
        kinf.setCreateName(new Date());
        mapper.insert(kinf);
        return new Response().set(1,true);
    }
    //删除钥匙
    public Response delKey(Integer id) {
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("id",id);
        mapper.delete(wrapper);
        return new Response().set(1,true);
    }
    //修改钥匙
    public Response updateKey(KeyInf kinf) {
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("id",kinf.getId());
        if(kinf.getAreaId()!=null){
            wrapper.set("area_id",kinf.getAreaId());
        }
        if(kinf.getKeyName()!=null){
            wrapper.set("key_name",kinf.getKeyName());
        }
        if(kinf.getKeyType()!=null){
            wrapper.set("key_type",kinf.getKeyType());
        }
        if(kinf.getKeyNumber()!=null){
            wrapper.set("key_number",kinf.getKeyNumber());
        }
        if(kinf.getKeyAddress()!=null){
            wrapper.set("key_address",kinf.getKeyAddress());
        }
        if(kinf.getUname()!=null){
            wrapper.set("uname",kinf.getUname());
        }
        mapper.update(null,wrapper);
        return new Response().set(1,true);
    }
}