| | |
|---|
| | | package com.ruoyi.production.service.impl; |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
|---|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
|---|
| | | import com.ruoyi.framework.web.domain.R; |
|---|
| | | import com.ruoyi.production.dto.ProductProcessRouteItemDto; |
|---|
| | | import com.ruoyi.production.dto.ProductionProductMainDto; |
|---|
| | | import com.ruoyi.production.mapper.*; |
|---|
| | | import com.ruoyi.production.pojo.*; |
|---|
| | | import com.ruoyi.production.service.ProductProcessRouteItemService; |
|---|
| | | import com.ruoyi.production.service.ProductionProductMainService; |
|---|
| | | import com.ruoyi.quality.mapper.QualityInspectMapper; |
|---|
| | | import com.ruoyi.quality.pojo.QualityInspect; |
|---|
| | | import com.ruoyi.sales.mapper.SalesLedgerProductMapper; |
|---|
| | | import com.ruoyi.sales.pojo.SalesLedgerProduct; |
|---|
| | | import lombok.AllArgsConstructor; |
|---|
| | | import org.apache.poi.ss.formula.functions.T; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | import org.springframework.transaction.annotation.Transactional; |
|---|
| | | import org.springframework.util.CollectionUtils; |
|---|
| | | |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.time.format.DateTimeFormatter; |
|---|
| | | import java.util.ArrayList; |
|---|
| | | import java.util.Collections; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | import java.util.stream.Collectors; |
|---|
| | | |
|---|
| | | @Service |
|---|
| | | @Transactional(rollbackFor = Exception.class) |
|---|
| | |
|---|
| | | String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd")); |
|---|
| | | 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); |
|---|
| | | ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectMax(datePrefix); |
|---|
| | | int sequenceNumber = 1; // 默认序号 |
|---|
| | | if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) { |
|---|
| | | String lastNo = lastWorkOrder.getWorkOrderNo().toString(); |
|---|
| | |
|---|
| | | ProductWorkOrder productWorkOrder = new ProductWorkOrder(); |
|---|
| | | productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId()); |
|---|
| | | productWorkOrder.setProductOrderId(productProcessRouteItem.getProductOrderId()); |
|---|
| | | productWorkOrder.setLotNo(productOrder.getLotNo()); |
|---|
| | | productWorkOrder.setPriority(productOrder.getPriority()); |
|---|
| | | productWorkOrder.setPlanQuantity(productOrder.getQuantity()); |
|---|
| | | productWorkOrder.setWorkOrderNo(workOrderNoStr); |
|---|
| | | productWorkOrder.setStatus(1); |
|---|
