package com.whyc.service;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
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;
|
import java.io.File;
|
import java.io.IOException;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class DeviceSpareService {
|
|
@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);
|
QueryWrapper<DeviceSpare> query = Wrappers.query();
|
query.eq(StringUtils.isNotBlank(type), "type", type);
|
query.eq(StringUtils.isNotBlank(name), "name", name);
|
List<DeviceSpare> deviceSpares = mapper.selectList(query);
|
return new Response<PageInfo<DeviceSpare>>().set(1, new PageInfo<>(deviceSpares));
|
}
|
|
public Response<List<DeviceSpare>> getList(String name) {
|
QueryWrapper<DeviceSpare> query = Wrappers.query();
|
query.eq(StringUtils.isNotBlank(name), "name", name);
|
return new Response<List<DeviceSpare>>().set(1, mapper.selectList(query));
|
}
|
|
@Transactional
|
public Response add(DeviceSpare spare, List<MultipartFile> file) throws IOException {
|
//对file进行处理,保存到文件夹中
|
//对存储路径进行定义
|
Date now = new Date();
|
String timeFormat = ThreadLocalUtil.format(ThreadLocalUtil.TIME_YYYY_MM_DD_HH_MM_SS_UNION, now);
|
String dirMonth = ThreadLocalUtil.format(ThreadLocalUtil.TIME_YYYY_MM, now);
|
String fileDirPath = CommonUtil.getRootFile() + "deviceSpare" + File.separator + dirMonth;
|
File fileDir = new File(fileDirPath);
|
//如果文件夹不存在则创建
|
if (!fileDir.exists()) {
|
fileDir.mkdirs();
|
}
|
StringBuilder pictureUrlSb = new StringBuilder();
|
if (file != null && file.size() > 0) {
|
for (int i = 0; i < file.size(); i++) {
|
MultipartFile multipartFile = file.get(i);
|
String fileName = multipartFile.getOriginalFilename();
|
//将fileName中可能存在的,去掉
|
fileName = fileName.replace(",","");
|
String filePath = fileDirPath + File.separator + timeFormat+"_"+fileName;
|
|
multipartFile.transferTo(new File(filePath));
|
String split = "pis_file"+File.separator+"deviceSpare";
|
String picUrl = File.separator + filePath.substring(filePath.indexOf(split));
|
if(i == file.size()-1) {
|
pictureUrlSb.append(picUrl);
|
}else {
|
pictureUrlSb.append(picUrl).append(",");
|
}
|
}
|
}
|
spare.setPictureUrl(pictureUrlSb.toString());
|
mapper.insert(spare);
|
|
//变更日志
|
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,"修改完成");
|
}
|
|
public Response delete(Integer id) {
|
mapper.deleteById(id);
|
return new Response().setII(1,"删除完成");
|
}
|
}
|
