产品供销存-后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
buhuazhen
2026-05-12 15999f1d20063dec73abeeea435d6e0d5a55c491 
 src/main/java/com/ruoyi/production/service/impl/ProductProcessRouteItemServiceImpl.java


@@ -6,9 +6,13 @@


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.ProductProcessService;


import com.ruoyi.production.service.ProductWorkOrderService;


import com.ruoyi.production.service.ProductionProductMainService;


import com.ruoyi.quality.mapper.QualityInspectMapper;


import com.ruoyi.quality.pojo.QualityInspect;


import com.ruoyi.sales.mapper.SalesLedgerProductMapper;


@@ -16,10 +20,12 @@


import lombok.AllArgsConstructor;


import org.apache.poi.ss.formula.functions.T;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.context.annotation.Lazy;


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;


@@ -33,16 +39,13 @@


@AllArgsConstructor


public class ProductProcessRouteItemServiceImpl extends ServiceImpl<ProductProcessRouteItemMapper, ProductProcessRouteItem> implements ProductProcessRouteItemService {




    @Autowired


    @Lazy


    private ProductionProductMainService productionProductMainService;




    private ProductProcessRouteItemMapper productProcessRouteItemMapper;




    private ProductionProductMainMapper productionProductMainMapper;




    private ProductionProductInputMapper productionProductInputMapper;




    private ProductionProductOutputMapper productionProductOutputMapper;




    private QualityInspectMapper qualityInspectMapper;




    private SalesLedgerProductionAccountingMapper salesLedgerProductionAccountingMapper;




@@ -50,9 +53,9 @@




    private ProductOrderMapper productOrderMapper;




    private ProductProcessRouteMapper productProcessRouteMapper;


    private final ProductWorkOrderService productWorkOrderService;




    private SalesLedgerProductMapper salesLedgerProductMapper;


    private final ProductProcessService productProcessService;






    @Override


@@ -73,6 +76,9 @@


            if (productWorkOrder == null) {


                throw new RuntimeException("删除失败：未找到关联的生产工单");


            }


            if (BigDecimal.ZERO.compareTo(productWorkOrder.getCompleteQuantity()) < 0) {


                throw new RuntimeException("删除失败：该工单已开始生产，请先删除生产报工");


            }


            Long workOrderId = productWorkOrder.getId();


            Long productOrderId = productWorkOrder.getProductOrderId();


            // 查询生产主表


@@ -83,27 +89,23 @@


            if (!productionProductMains.isEmpty()) {


                // 批量删除子表


                for (ProductionProductMain main : productionProductMains) {


                    Long mainId = main.getId();


                    // 删除投入


                    productionProductInputMapper.delete(new LambdaQueryWrapper<ProductionProductInput>()


                            .eq(ProductionProductInput::getProductMainId, mainId));


                    // 删除产出


                    productionProductOutputMapper.delete(new LambdaQueryWrapper<ProductionProductOutput>()


                            .eq(ProductionProductOutput::getProductMainId, mainId));


                    // 删除质检


                    qualityInspectMapper.delete(new LambdaQueryWrapper<QualityInspect>()


                            .eq(QualityInspect::getProductMainId, mainId));


                    productionProductMainService.removeProductMain(main.getId());


//                    Long mainId = main.getId();


//                    // 删除投入


//                    productionProductInputMapper.delete(new LambdaQueryWrapper<ProductionProductInput>()


//                            .eq(ProductionProductInput::getProductMainId, mainId));


//                    // 删除产出


//                    productionProductOutputMapper.delete(new LambdaQueryWrapper<ProductionProductOutput>()


//                            .eq(ProductionProductOutput::getProductMainId, mainId));


//                    // 删除质检


//                    qualityInspectMapper.delete(new LambdaQueryWrapper<QualityInspect>()


//                            .eq(QualityInspect::getProductMainId, mainId));


                    salesLedgerProductionAccountingMapper.delete(new LambdaQueryWrapper<SalesLedgerProductionAccounting>()


                            .eq(SalesLedgerProductionAccounting::getProductMainId, main.getId()));


                }


            }


            //  删除报工（生产主表）


            productionProductMainMapper.delete(new LambdaQueryWrapper<ProductionProductMain>()


                    .eq(ProductionProductMain::getWorkOrderId, workOrderId));


            // 查询订单 + 删除核算


            ProductOrder productOrder = productOrderMapper.selectById(productOrderId);


            if (productOrder != null && productOrder.getSalesLedgerId() != null) {


                salesLedgerProductionAccountingMapper.delete(new LambdaQueryWrapper<SalesLedgerProductionAccounting>()


                        .eq(SalesLedgerProductionAccounting::getSalesLedgerId, productOrder.getSalesLedgerId()));


            }




            // 删除关联工单


            productWorkOrderMapper.delete(new LambdaQueryWrapper<ProductWorkOrder>()


                    .eq(ProductWorkOrder::getProductProcessRouteItemId, routeItemId));


@@ -134,35 +136,16 @@


    @Override


    public R addRouteItem(ProductProcessRouteItem productProcessRouteItem) {


        ProductOrder productOrder = productOrderMapper.selectById(productProcessRouteItem.getProductOrderId());


        ProductProcess productProcess = productProcessService.getById(productProcessRouteItem.getProcessId());


        int insert = productProcessRouteItemMapper.insert(productProcessRouteItem);


        // 生成当前日期的前缀：年月日


        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);


            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 = "GD" +String.format("%s%03d", datePrefix, sequenceNumber);




            ProductWorkOrder productWorkOrder = new ProductWorkOrder();


            productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId());


            productWorkOrder.setProductOrderId(productProcessRouteItem.getProductOrderId());


            productWorkOrder.setPlanQuantity(productOrder.getQuantity());


            productWorkOrder.setWorkOrderNo(workOrderNoStr);


            productWorkOrder.setWorkOrderNo(productWorkOrderService.generateProductWorkOrder(productProcess.getName(),productOrder.getNpsNo()));


            productWorkOrder.setStatus(1);


            productWorkOrderMapper.insert(productWorkOrder);


        }