package com.ruoyi.quality.service.impl;
|
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.deepoove.poi.XWPFTemplate;
|
import com.deepoove.poi.config.Configure;
|
import com.ruoyi.common.enums.StockInQualifiedRecordTypeEnum;
|
import com.ruoyi.common.utils.HackLoopTableRenderPolicy;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.procurementrecord.utils.StockUtils;
|
import com.ruoyi.quality.dto.QualityInspectDto;
|
import com.ruoyi.quality.dto.QualityInspectExportDTO;
|
import com.ruoyi.quality.dto.QualityInspectExportVO;
|
import com.ruoyi.quality.mapper.QualityInspectMapper;
|
import com.ruoyi.quality.mapper.QualityUnqualifiedMapper;
|
import com.ruoyi.quality.pojo.QualityInspect;
|
import com.ruoyi.quality.pojo.QualityInspectParam;
|
import com.ruoyi.quality.pojo.QualityUnqualified;
|
import com.ruoyi.quality.service.IQualityInspectParamService;
|
import com.ruoyi.quality.service.IQualityInspectService;
|
import com.ruoyi.sales.pojo.SalesLedger;
|
import com.ruoyi.sales.mapper.SalesLedgerMapper;
|
import com.ruoyi.production.pojo.ProductOrder;
|
import com.ruoyi.production.pojo.ProductWorkOrder;
|
import com.ruoyi.production.pojo.ProductionProductMain;
|
import com.ruoyi.production.mapper.ProductOrderMapper;
|
import com.ruoyi.production.mapper.ProductWorkOrderMapper;
|
import com.ruoyi.production.mapper.ProductionProductMainMapper;
|
import lombok.AllArgsConstructor;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.util.CollectionUtils;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.text.SimpleDateFormat;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
@AllArgsConstructor
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class QualityInspectServiceImpl extends ServiceImpl<QualityInspectMapper, QualityInspect> implements IQualityInspectService {
|
|
private final StockUtils stockUtils;
|
private QualityInspectMapper qualityInspectMapper;
|
|
private IQualityInspectParamService qualityInspectParamService;
|
|
private QualityUnqualifiedMapper qualityUnqualifiedMapper;
|
|
private QualityInspectExportHandle qualityInspectExportHandle;
|
|
private ProductionProductMainMapper productionProductMainMapper;
|
|
private ProductWorkOrderMapper productWorkOrderMapper;
|
|
private ProductOrderMapper productOrderMapper;
|
|
private SalesLedgerMapper salesLedgerMapper;
|
|
@Override
|
public int add(QualityInspectDto qualityInspectDto) {
|
QualityInspect qualityInspect = new QualityInspect();
|
BeanUtils.copyProperties(qualityInspectDto, qualityInspect);
|
qualityInspect.setInspectState(0);//默认未提交
|
qualityInspectMapper.insert(qualityInspect);
|
for (QualityInspectParam qualityInspectParam : qualityInspectDto.getQualityInspectParams()) {
|
qualityInspectParam.setInspectId(qualityInspect.getId());
|
}
|
qualityInspectParamService.saveBatch(qualityInspectDto.getQualityInspectParams());
|
return 0;
|
}
|
|
@Override
|
public QualityInspectDto getDetailById(Integer id) {
|
QualityInspect qualityInspect = qualityInspectMapper.selectById(id);
|
List<QualityInspectParam> qualityInspectParams = qualityInspectParamService.list(Wrappers.<QualityInspectParam>lambdaQuery().eq(QualityInspectParam::getInspectId, id));
|
QualityInspectDto qualityInspectDto = new QualityInspectDto();
|
BeanUtils.copyProperties(qualityInspect, qualityInspectDto);
|
qualityInspectDto.setQualityInspectParams(qualityInspectParams);
|
return qualityInspectDto;
|
}
|
|
@Override
|
public int submit(QualityInspect inspect) {
|
QualityInspect qualityInspect = qualityInspectMapper.selectById(inspect.getId());
|
if (ObjectUtils.isNull(qualityInspect.getCheckResult())) {
|
throw new RuntimeException("请先判断是否合格");
|
}
|
if (qualityInspect.getCheckResult().equals("不合格")) {
|
QualityUnqualified qualityUnqualified = new QualityUnqualified();
|
BeanUtils.copyProperties(qualityInspect, qualityUnqualified);
|
qualityUnqualified.setInspectState(0);//待处理
|
List<QualityInspectParam> inspectParams = qualityInspectParamService.list(Wrappers.<QualityInspectParam>lambdaQuery().eq(QualityInspectParam::getInspectId, inspect.getId()));
|
String text = inspectParams.stream().map(QualityInspectParam::getParameterItem).collect(Collectors.joining(","));
|
qualityUnqualified.setDefectivePhenomena(text + "这些指标中存在不合格");//不合格现象
|
qualityUnqualified.setInspectId(qualityInspect.getId());
|
qualityUnqualifiedMapper.insert(qualityUnqualified);
|
} else {
|
//合格直接入库
|
if (qualityInspect.getInspectType() == 2 || qualityInspect.getInspectType() == 0) {
|
stockUtils.addStock(qualityInspect.getProductModelId(), qualityInspect.getQuantity(), StockInQualifiedRecordTypeEnum.QUALITYINSPECT_STOCK_IN.getCode(), qualityInspect.getId(), "-", "-", "-");
|
}
|
}
|
qualityInspect.setInspectState(1);//已提交
|
return qualityInspectMapper.updateById(qualityInspect);
|
}
|
|
@Override
|
public void down(HttpServletResponse response, QualityInspect qualityInspect) {
|
QualityInspect inspect = qualityInspectMapper.selectById(qualityInspect.getId());
|
String inspectType = "";
|
switch (inspect.getInspectType()) {
|
case 0:
|
inspectType = "原材料检验";
|
break;
|
case 1:
|
inspectType = "过程检验";
|
break;
|
case 2:
|
inspectType = "出厂检验";
|
break;
|
}
|
List<QualityInspectParam> paramList = qualityInspectParamService.list(Wrappers.<QualityInspectParam>lambdaQuery().eq(QualityInspectParam::getInspectId, inspect.getId()));
|
int index = 1;
|
for (QualityInspectParam detail : paramList) {
|
detail.setIndex(index);
|
index++;
|
}
|
|
// 格式化检验日期
|
String checkTimeStr;
|
if (inspect.getCheckTime() != null) {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
checkTimeStr = sdf.format(inspect.getCheckTime());
|
} else {
|
checkTimeStr = "";
|
}
|
|
InputStream inputStream = this.getClass().getResourceAsStream("/static/report-template.docx");
|
Configure configure = Configure.builder()
|
.bind("paramList", new HackLoopTableRenderPolicy())
|
.build();
|
String finalInspectType = inspectType;
|
XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
|
new HashMap<String, Object>() {{
|
put("inspect", inspect);
|
put("customerLabel", inspect.getInspectType() == 0 ? "供应商" : "客户");
|
// 根据检验类型确定客户/供应商
|
String customerValue;
|
if (inspect.getInspectType() == 0) {
|
// 原材料检验：直接使用供应商
|
customerValue = inspect.getSupplier();
|
} else {
|
// 过程检验/出厂检验：通过关联关系查询销售台账的客户
|
customerValue = inspect.getCustomer(); // 默认使用直接存储的客户
|
if (inspect.getProductMainId() != null) {
|
// 通过报工ID查询工单
|
ProductionProductMain productMain = productionProductMainMapper.selectById(inspect.getProductMainId());
|
if (productMain != null && productMain.getWorkOrderId() != null) {
|
ProductWorkOrder workOrder = productWorkOrderMapper.selectById(productMain.getWorkOrderId());
|
if (workOrder != null && workOrder.getProductOrderId() != null) {
|
ProductOrder productOrder = productOrderMapper.selectById(workOrder.getProductOrderId());
|
if (productOrder != null && productOrder.getSalesLedgerId() != null) {
|
SalesLedger salesLedger = salesLedgerMapper.selectById(productOrder.getSalesLedgerId());
|
if (salesLedger != null && salesLedger.getCustomerName() != null) {
|
customerValue = salesLedger.getCustomerName();
|
}
|
}
|
}
|
}
|
}
|
}
|
put("customer", customerValue);
|
put("inspectType", finalInspectType);
|
put("paramList", paramList);
|
put("checkTime", checkTimeStr);
|
}});
|
|
try {
|
response.setContentType("application/msword");
|
String fileName = URLEncoder.encode("检验报告", "UTF-8");
|
response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
|
response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".docx");
|
OutputStream os = response.getOutputStream();
|
template.write(os);
|
os.flush();
|
os.close();
|
inputStream.close();
|
} catch (Exception e) {
|
e.printStackTrace();
|
throw new RuntimeException("导出失败");
|
}
|
}
|
|
@Override
|
public int updateQualityInspect(QualityInspectDto qualityInspectDto) {
|
if (ObjectUtils.isNotNull(qualityInspectDto.getQualityInspectParams())) {
|
qualityInspectParamService.remove(Wrappers.<QualityInspectParam>lambdaQuery().eq(QualityInspectParam::getInspectId, qualityInspectDto.getId()));
|
for (QualityInspectParam qualityInspectParam : qualityInspectDto.getQualityInspectParams()) {
|
qualityInspectParam.setInspectId(qualityInspectDto.getId());
|
}
|
qualityInspectParamService.saveBatch(qualityInspectDto.getQualityInspectParams());
|
}
|
QualityInspect qualityInspect = new QualityInspect();
|
BeanUtils.copyProperties(qualityInspectDto, qualityInspect);
|
return qualityInspectMapper.updateById(qualityInspect);
|
}
|
|
@Override
|
public IPage<QualityInspect> qualityInspectListPage(Page page, QualityInspect qualityInspect) {
|
return qualityInspectMapper.qualityInspectListPage(page, qualityInspect);
|
}
|
|
@Override
|
public void qualityInspectExport(HttpServletResponse response, QualityInspect qualityInspect) {
|
List<QualityInspect> qualityInspects = qualityInspectMapper.qualityInspectExport(qualityInspect);
|
ExcelUtil<QualityInspect> util = new ExcelUtil<QualityInspect>(QualityInspect.class);
|
switch (qualityInspect.getInspectType()) {
|
case 0:
|
util.exportExcel(response, qualityInspects, "原材料检验导出");
|
break;
|
case 1:
|
util.exportExcel(response, qualityInspects, "过程检验导出");
|
break;
|
case 2:
|
util.exportExcel(response, qualityInspects, "出厂检验导出");
|
break;
|
}
|
}
|
|
/**
|
* 导出检验记录（支持选中导出和全部导出，包含检验参数）
|
* 每个检验参数一行（一个检验记录展开成多行）
|
*/
|
@Override
|
public void qualityInspectExportNew(HttpServletResponse response, QualityInspectExportDTO exportDTO) {
|
// 1. 查询检验记录
|
List<QualityInspect> qualityInspects = qualityInspectExportHandle.queryInspectList(exportDTO);
|
if (CollectionUtils.isEmpty(qualityInspects)) {
|
throw new RuntimeException("没有可导出的数据");
|
}
|
|
// 2. 构建导出数据（每个检验参数一行）
|
List<QualityInspectExportVO> exportList = qualityInspectExportHandle.buildExportData(qualityInspects, exportDTO.getInspectType());
|
|
// 3. 导出Excel
|
qualityInspectExportHandle.exportExcel(response, exportList, exportDTO.getInspectType());
|
}
|
|
}
|
