package com.ruoyi.production.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.production.dto.ProductOrderDto;
|
import com.ruoyi.production.mapper.*;
|
import com.ruoyi.production.pojo.*;
|
import com.ruoyi.production.service.ProcessRouteService;
|
import com.ruoyi.production.service.ProductOrderService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.util.List;
|
|
@Service
|
public class ProductOrderServiceImpl extends ServiceImpl<ProductOrderMapper, ProductOrder> implements ProductOrderService {
|
|
@Autowired
|
private ProductOrderMapper productOrderMapper;
|
|
@Autowired
|
private ProcessRouteMapper processRouteMapper;
|
|
@Autowired
|
private ProductProcessRouteMapper productProcessRouteMapper;
|
|
@Autowired
|
private ProcessRouteItemMapper processRouteItemMapper;
|
|
@Autowired
|
private ProductProcessRouteItemMapper productProcessRouteItemMapper;
|
|
@Autowired
|
private ProductWorkOrderMapper productWorkOrderMapper;
|
|
|
@Override
|
public IPage<ProductOrderDto> pageProductOrder(Page page, ProductOrderDto productOrder) {
|
return productOrderMapper.pageProductOrder(page, productOrder);
|
}
|
|
@Override
|
public int bindingRoute(ProductOrder productOrder) {
|
//新增生产订单下的工艺路线主表
|
ProcessRoute processRoute = processRouteMapper.selectById(productOrder.getRouteId());
|
ProductProcessRoute productProcessRoute = new ProductProcessRoute();
|
productProcessRoute.setProductModelId(processRoute.getProductModelId());
|
productProcessRoute.setProcessRouteCode(processRoute.getProcessRouteCode());
|
productProcessRoute.setProductOrderId(productOrder.getId());
|
productProcessRoute.setBomId(processRoute.getBomId());
|
productProcessRouteMapper.insert(productProcessRoute);
|
//新增生产订单下的工艺路线子表
|
List<ProcessRouteItem> processRouteItems = processRouteItemMapper.selectList(new QueryWrapper<ProcessRouteItem>().lambda().eq(ProcessRouteItem::getRouteId, processRoute.getId()));
|
// 生成当前日期的前缀：年月日
|
String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
|
for (ProcessRouteItem processRouteItem : processRouteItems) {
|
ProductProcessRouteItem productProcessRouteItem = new ProductProcessRouteItem();
|
productProcessRouteItem.setProductModelId(processRouteItem.getProductModelId());
|
productProcessRouteItem.setProcessId(processRouteItem.getProcessId());
|
productProcessRouteItem.setProductOrderId(productOrder.getId());
|
productProcessRouteItem.setProductRouteId(productProcessRoute.getId());
|
int insert = productProcessRouteItemMapper.insert(productProcessRouteItem);
|
if (insert > 0) {
|
// 查询今日已存在的最大工单号
|
QueryWrapper<ProductWorkOrder> queryWrapper = new QueryWrapper<>();
|
queryWrapper.likeRight("work_order_no", datePrefix)
|
.orderByDesc("work_order_no")
|
.last("LIMIT 1");
|
ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectOne(queryWrapper);
|
int sequenceNumber = 1; // 默认序号
|
if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) {
|
String lastNo = lastWorkOrder.getWorkOrderNo().toString();
|
if (lastNo.startsWith(datePrefix)) {
|
String seqStr = lastNo.substring(datePrefix.length());
|
try {
|
sequenceNumber = Integer.parseInt(seqStr) + 1;
|
} catch (NumberFormatException e) {
|
sequenceNumber = 1;
|
}
|
}
|
}
|
// 生成完整的工单号
|
String workOrderNoStr = String.format("%s%03d", datePrefix, sequenceNumber);
|
ProductWorkOrder productWorkOrder = new ProductWorkOrder();
|
productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId());
|
productWorkOrder.setProductOrderId(productOrder.getId());
|
productWorkOrder.setPlanQuantity(productOrder.getQuantity());
|
productWorkOrder.setWorkOrderNo(workOrderNoStr);
|
productWorkOrder.setStatus(1);
|
productWorkOrderMapper.insert(productWorkOrder);
|
}
|
}
|
return productOrderMapper.updateById(productOrder);
|
}
|
|
@Override
|
public List<ProcessRoute> listProcessRoute(Long productModelId) {
|
return productOrderMapper.listProcessRoute(productModelId);
|
}
|
}
|
