维修备件变更日志

whycxzp

2025-06-12 57d3881d7c7f88a294824432a482fe206f719eda

维修备件变更日志

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

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

import com.whyc.dto.Response;
import com.whyc.pojo.web_site.DeviceSpareLog;
import com.whyc.service.DeviceSpareLogService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("deviceSpareLog")
@Api(tags = "设备器件备件变更日志")
public class DeviceSpareLogController {

    @Autowired
    private DeviceSpareLogService service;


    @GetMapping("getList")
    @ApiOperation(value = "查询变更日志")
    public Response<List<DeviceSpareLog>> getList(@RequestParam int deviceSpareId){
        return service.getList(deviceSpareId);
    }

}

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

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

import com.whyc.pojo.web_site.DeviceSpareLog;

public interface DeviceSpareLogMapper extends CustomMapper<DeviceSpareLog>{
}

 src/main/java/com/whyc/pojo/web_site/DeviceSpareLog.java

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

import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.ToString;

import java.util.Date;

@ToString
@Data
@TableName(schema = "web_site",value ="tb_device_spare_log")
@ApiModel("设备器件备件库操作日志")
public class DeviceSpareLog {

    private Integer id;

    private Integer deviceSpareId;

    @ApiModelProperty("操作类型.1-新增物料,2-修改")
    private Integer operationType;

    private String operationDetail;

    private Date createTime;

}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.dto.Response;
import com.whyc.mapper.DeviceSpareLogMapper;
import com.whyc.pojo.web_site.DeviceSpareLog;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class DeviceSpareLogService {

    @Resource
    private DeviceSpareLogMapper mapper;


    public void add(DeviceSpareLog deviceSpareLog) {
        mapper.insert(deviceSpareLog);
    }

    public Response<List<DeviceSpareLog>> getList(int deviceSpareId) {
        QueryWrapper<DeviceSpareLog> query = Wrappers.query();
        query.eq("device_spare_id",deviceSpareId);
        query.orderByDesc("id");
        List<DeviceSpareLog> deviceSpareLogs = mapper.selectList(query);
        return new Response<List<DeviceSpareLog>>().set(1, deviceSpareLogs);

    }
}

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

@@ -7,10 +7,13 @@
import com.whyc.dto.Response;
import com.whyc.mapper.DeviceSpareMapper;
import com.whyc.pojo.web_site.DeviceSpare;
import com.whyc.pojo.web_site.DeviceSpareLog;
import com.whyc.util.CommonUtil;
import com.whyc.util.ThreadLocalUtil;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
@@ -24,6 +27,9 @@

    @Resource
    private DeviceSpareMapper mapper;

    @Autowired
    private DeviceSpareLogService deviceSpareLogService;

    public Response<PageInfo<DeviceSpare>> getPage(Integer pageNum, Integer pageSize, String type, String name) {
        PageHelper.startPage(pageNum, pageSize);
@@ -40,6 +46,7 @@
        return new Response<List<DeviceSpare>>().set(1, mapper.selectList(query));
    }

    @Transactional
    public Response add(DeviceSpare spare, List<MultipartFile> file) throws IOException {
        //对file进行处理,保存到文件夹中
        //对存储路径进行定义
@@ -73,10 +80,69 @@
        }
        spare.setPictureUrl(pictureUrlSb.toString());
        mapper.insert(spare);
        return new Response().setII(1,"增加完成");

        //变更日志
        DeviceSpareLog deviceSpareLog = new DeviceSpareLog();
        deviceSpareLog.setDeviceSpareId(spare.getId());
        deviceSpareLog.setCreateTime(now);
        deviceSpareLog.setOperationType(1);

        StringBuilder detailSb = new StringBuilder();
        detailSb.append("新增物料类型,");
        detailSb.append("物料名称:").append(spare.getName()).append(",");
        detailSb.append("物料型号:").append(spare.getModel()).append(",");
        detailSb.append("物料版本:").append(spare.getVersion()).append(",");
        detailSb.append("物料品牌:").append(spare.getBrand()).append(",");
        detailSb.append("物料数量:").append(spare.getQuantity()).append(",");
        detailSb.append("物料类型:").append(spare.getType()).append(",");
        detailSb.append("物料供应商:").append(spare.getSupplier());
        deviceSpareLog.setOperationDetail(detailSb.toString());

        deviceSpareLogService.add(deviceSpareLog);



        return new Response().setII(1,"新增完成");
    }

    @Transactional
    public Response update(DeviceSpare spare) {
        //根据id查询数据库中的物料
        DeviceSpare spareInDB = mapper.selectById(spare.getId());
        //对比每个字段是否一样,不一样的记录下来
        DeviceSpareLog deviceSpareLog = new DeviceSpareLog();
        deviceSpareLog.setDeviceSpareId(spare.getId());
        deviceSpareLog.setCreateTime(new Date());
        deviceSpareLog.setOperationType(2);

        StringBuilder detailSb = new StringBuilder();
        detailSb.append("修改物料,");
        if (!spareInDB.getName().equals(spare.getName())) {
            detailSb.append("物料名称:").append(spareInDB.getName()).append("->").append(spare.getName()).append(",");
        }
        if (!spareInDB.getModel().equals(spare.getModel())) {
            detailSb.append("物料型号:").append(spareInDB.getModel()).append("->").append(spare.getModel()).append(",");
        }
        if (!spareInDB.getVersion().equals(spare.getVersion())) {
            detailSb.append("物料版本:").append(spareInDB.getVersion()).append("->").append(spare.getVersion()).append(",");
        }
        if (!spareInDB.getBrand().equals(spare.getBrand())) {
            detailSb.append("物料品牌:").append(spareInDB.getBrand()).append("->").append(spare.getBrand()).append(",");
        }
        if (!spareInDB.getQuantity().equals(spare.getQuantity())) {
            detailSb.append("物料数量:").append(spareInDB.getQuantity()).append("->").append(spare.getQuantity()).append(",");
        }
        if (!spareInDB.getType().equals(spare.getType())) {
            detailSb.append("物料类型:").append(spareInDB.getType()).append("->").append(spare.getType()).append(",");
        }
        if (!spareInDB.getSupplier().equals(spare.getSupplier())) {
            detailSb.append("物料供应商:").append(spareInDB.getSupplier()).append("->").append(spare.getSupplier()).append(",");
        }
        //detailSb去除最后一个逗号
        detailSb.deleteCharAt(detailSb.length()-1);
        deviceSpareLog.setOperationDetail(detailSb.toString());
        deviceSpareLogService.add(deviceSpareLog);

        mapper.updateById(spare);
        return new Response().setII(1,"修改完成");
    }