package com.ruoyi.production.service.impl;
|
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
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.data.PictureRenderData;
|
import com.deepoove.poi.data.Pictures;
|
import com.ruoyi.common.exception.ServiceException;
|
import com.ruoyi.common.utils.MatrixToImageWriter;
|
import com.ruoyi.production.dto.ProductWorkOrderDto;
|
import com.ruoyi.production.mapper.ProductWorkOrderFileMapper;
|
import com.ruoyi.production.mapper.ProductWorkOrderMapper;
|
import com.ruoyi.production.pojo.ProductWorkOrder;
|
import com.ruoyi.production.pojo.ProductWorkOrderFile;
|
import com.ruoyi.production.service.ProductWorkOrderService;
|
import com.ruoyi.project.system.domain.SysUser;
|
import com.ruoyi.project.system.mapper.SysUserMapper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class ProductWorkOrderServiceImpl extends ServiceImpl<ProductWorkOrderMapper, ProductWorkOrder> implements ProductWorkOrderService {
|
|
@Autowired
|
private ProductWorkOrderMapper productWorkOrdermapper;
|
@Autowired
|
private ProductWorkOrderFileMapper productWorkOrderFileMapper;
|
|
@Value("${file.temp-dir}")
|
private String tempDir;
|
|
@Autowired
|
private SysUserMapper sysUserMapper;
|
|
@Override
|
public IPage<ProductWorkOrderDto> listPage(Page<ProductWorkOrderDto> page, ProductWorkOrderDto productWorkOrder) {
|
return productWorkOrdermapper.pageProductWorkOrder(page, productWorkOrder);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public int updateProductWorkOrder(ProductWorkOrderDto dto) {
|
if (dto == null) {
|
throw new ServiceException("指派失败,数据不能为空");
|
}
|
if (dto.getWorkerId() == null) {
|
throw new ServiceException("指派失败,指派工人不能为空");
|
}
|
SysUser worker = sysUserMapper.selectUserById(dto.getWorkerId());
|
if (worker == null) {
|
throw new ServiceException("指派失败,指派工人不存在");
|
}
|
|
if (dto.getHandoverUserId() != null) {
|
if (dto.getWorkerId().equals(dto.getHandoverUserId())) {
|
throw new ServiceException("交接失败,交接人不能与指派工人相同");
|
}
|
SysUser handoverUser = sysUserMapper.selectUserById(dto.getHandoverUserId());
|
if (handoverUser == null) {
|
throw new ServiceException("交接失败,交接人员不存在");
|
}
|
dto.setHandoverUserName(handoverUser.getNickName());
|
}
|
dto.setWorkerName(worker.getNickName());
|
|
return productWorkOrdermapper.updateById(dto);
|
}
|
@Override
|
public void down(HttpServletResponse response, ProductWorkOrder productWorkOrder) {
|
ProductWorkOrderDto productWorkOrderDto = productWorkOrdermapper.getProductWorkOrderFlowCard(productWorkOrder.getId());
|
String codePath;
|
try {
|
codePath = new MatrixToImageWriter().code(productWorkOrderDto.getId().toString(), tempDir);
|
} catch (Exception e) {
|
throw new RuntimeException(e);
|
}
|
/*获取附件图片类型*/
|
List<Map<String, Object>> images = new ArrayList<>();
|
List<ProductWorkOrderFile> productWorkOrderFiles = productWorkOrderFileMapper.selectList(Wrappers.<ProductWorkOrderFile>lambdaQuery().eq(ProductWorkOrderFile::getWorkOrderId, productWorkOrder.getId()));
|
if (CollectionUtils.isNotEmpty(productWorkOrderFiles)) {
|
productWorkOrderFiles.forEach(productWorkOrderFile -> {
|
Map<String, Object> image = new HashMap<>();
|
PictureRenderData pictureRenderData = Pictures.ofLocal( productWorkOrderFile.getUrl()).sizeInCm(17, 20).create();
|
image.put("url", pictureRenderData);
|
images.add(image);
|
});
|
}
|
InputStream inputStream = this.getClass().getResourceAsStream("/static/work-order-template.docx");
|
XWPFTemplate template = XWPFTemplate.compile(inputStream).render(
|
new HashMap<String, Object>() {{
|
put("process", productWorkOrderDto.getProcessName());
|
put("workOrderNo", productWorkOrderDto.getWorkOrderNo());
|
put("productOrderNpsNo", productWorkOrderDto.getProductOrderNpsNo());
|
put("productName", productWorkOrderDto.getProductName());
|
put("planQuantity", productWorkOrderDto.getPlanQuantity());
|
put("model", productWorkOrderDto.getModel());
|
put("completeQuantity", productWorkOrderDto.getCompleteQuantity());
|
put("scrapQty", productWorkOrderDto.getScrapQty());
|
put("planStartTime", productWorkOrderDto.getPlanStartTime());
|
put("planEndTime", productWorkOrderDto.getPlanEndTime());
|
put("actualStartTime", productWorkOrderDto.getActualStartTime());
|
put("actualEndTime", productWorkOrderDto.getActualEndTime());
|
put("twoCode", Pictures.ofLocal(codePath).create());
|
put("images", images.isEmpty()?null:images);
|
}});
|
|
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("导出失败");
|
}
|
}
|
|
}
|
