From b686699a24f80abc6745f5f66fee96218f817c7f Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期六, 10 一月 2026 16:41:51 +0800
Subject: [PATCH] feat(quality): 完善质检流程并修复产品ID映射错误

---
 src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java |  124 ++++++++++++++++++++++++++++++++++++-----
 1 files changed, 108 insertions(+), 16 deletions(-)

diff --git a/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java b/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java
index 9f9123f..583c7d9 100644
--- a/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java
+++ b/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java
@@ -36,6 +36,12 @@
 import com.ruoyi.purchase.pojo.PurchaseLedger;
 import com.ruoyi.purchase.pojo.TicketRegistration;
 import com.ruoyi.purchase.service.IPurchaseLedgerService;
+import com.ruoyi.quality.mapper.QualityInspectMapper;
+import com.ruoyi.quality.mapper.QualityInspectParamMapper;
+import com.ruoyi.quality.mapper.QualityTestStandardMapper;
+import com.ruoyi.quality.pojo.QualityInspect;
+import com.ruoyi.quality.pojo.QualityInspectParam;
+import com.ruoyi.quality.pojo.QualityTestStandard;
 import com.ruoyi.sales.mapper.*;
 import com.ruoyi.sales.pojo.CommonFile;
 import com.ruoyi.sales.pojo.InvoiceRegistrationProduct;
@@ -101,6 +107,9 @@
     private final InvoiceRegistrationProductMapper invoiceRegistrationProductMapper;
 
     private final StringRedisTemplate redisTemplate;
+    private final QualityInspectMapper qualityInspectMapper;
+    private final QualityTestStandardMapper qualityTestStandardMapper;
+    private final QualityInspectParamMapper qualityInspectParamMapper;
 
     @Value("${file.upload-dir}")
     private String uploadDir;
@@ -113,7 +122,49 @@
         }
         return purchaseLedgerMapper.selectList(queryWrapper);
     }
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public int addPurchaseTemplate(PurchaseLedgerDto purchaseLedgerDto)throws IOException {
+        //褰曞叆浜�
+        SysUser sysUser = userMapper.selectUserById(purchaseLedgerDto.getRecorderId());
 
+        SupplierManage supplierManage = supplierManageMapper.selectById(purchaseLedgerDto.getSupplierId());
+        PurchaseLedger purchaseLedger = new PurchaseLedger();
+//        BeanUtils.copyProperties(purchaseLedger,purchaseLedgerDto);
+        LoginUser loginUser = SecurityUtils.getLoginUser();
+        if(ObjectUtils.isNotEmpty(loginUser) && null != loginUser.getTenantId()) {
+            purchaseLedger.setTenantId(loginUser.getTenantId());
+        }
+        purchaseLedger.setPaymentMethod(purchaseLedgerDto.getPaymentMethod());
+        purchaseLedger.setRecorderId(purchaseLedgerDto.getRecorderId());
+        purchaseLedger.setSupplierId(purchaseLedgerDto.getSupplierId());
+        purchaseLedger.setTemplateName(purchaseLedgerDto.getTemplateName());
+//        purchaseLedger.setSalesLedgerPId(purchaseLedgerDto.getSalesLedgerId());
+        purchaseLedger.setApprovalStatus(3);
+        purchaseLedger.setSupplierName(supplierManage.getSupplierName());
+        purchaseLedger.setRecorderName(sysUser.getNickName());
+        purchaseLedger.setPhoneNumber(sysUser.getPhonenumber());
+        purchaseLedger.setPurchaseContractNumber(UUID.randomUUID().toString().replaceAll("-", ""));
+        purchaseLedger.setEntryDate(Date.from(LocalDate.now().atStartOfDay(ZoneId.systemDefault()).toInstant()));
+        int insert = purchaseLedgerMapper.insert(purchaseLedger);
+
+        LambdaQueryWrapper<PurchaseLedger> queryWrapper = new LambdaQueryWrapper<>();
+        queryWrapper.eq(PurchaseLedger::getSupplierName, purchaseLedger.getSupplierName())
+                .eq(PurchaseLedger::getPurchaseContractNumber, purchaseLedger.getPurchaseContractNumber())
+                .eq(PurchaseLedger::getApprovalStatus,3);
+        PurchaseLedger purchaseLedger1 = purchaseLedgerMapper.selectOne(queryWrapper);
+
+        if(ObjectUtils.isNotEmpty(purchaseLedgerDto.getProductData())) {
+            // 4. 澶勭悊瀛愯〃鏁版嵁
+            List<SalesLedgerProduct> salesLedgerProductList = purchaseLedgerDto.getProductData();
+            salesLedgerProductList.forEach(salesLedgerProduct -> {
+                salesLedgerProduct.setSalesLedgerId(purchaseLedger1.getId());
+                salesLedgerProduct.setType(2);
+            });
+            salesLedgerProductList.forEach(salesLedgerProductMapper::insert);
+        }
+        return insert;
+    }
     @Override
     @Transactional(rollbackFor = Exception.class)
     public int addOrEditPurchase(PurchaseLedgerDto purchaseLedgerDto) throws IOException {
@@ -128,7 +179,7 @@
         PurchaseLedger purchaseLedger = new PurchaseLedger();
         BeanUtils.copyProperties(purchaseLedgerDto, purchaseLedger);
         LoginUser loginUser = SecurityUtils.getLoginUser();
-        if(ObjectUtils.isNotEmpty(loginUser) && null != loginUser.getTenantId()) {
+        if (ObjectUtils.isNotEmpty(loginUser) && null != loginUser.getTenantId()) {
             purchaseLedger.setTenantId(loginUser.getTenantId());
         }
         purchaseLedger.setSalesContractNo(ObjectUtils.isNotEmpty(salesLedger) ? salesLedger.getSalesContractNo() : "");
@@ -160,16 +211,16 @@
             PurchaseLedger purchaseLedgerDB = purchaseLedgerMapper.selectById(purchaseLedger.getId());
             List<AccountExpense> accountExpenseDBs = accountExpenseService.getByInvoiceNumberList(purchaseLedger.getPurchaseContractNumber());
             if (!CollectionUtils.isEmpty(accountExpenseDBs)) {
-                accountExpenseDBs.forEach(accountExpenseDB -> {
-                   accountExpenseDB.setExpenseDate(purchaseLedgerDB.getEntryDate());
-                   accountExpenseDB.setExpenseType("0");
-                   accountExpenseDB.setSupplierName(purchaseLedgerDB.getSupplierName());
-                   accountExpenseDB.setExpenseMoney(purchaseLedgerDB.getContractAmount());
-                   accountExpenseDB.setExpenseDescribed("閲囪喘鍚堝悓锛�" + purchaseLedgerDB.getPurchaseContractNumber());
-                   accountExpenseDB.setExpenseMethod("0");
-                   accountExpenseDB.setInvoiceNumber(purchaseLedgerDB.getPurchaseContractNumber());
-                   accountExpenseService.updateById(accountExpenseDB);
-               });
+                accountExpenseDBs.forEach(accountExpenseDB ->{
+                    accountExpenseDB.setExpenseDate(purchaseLedgerDB.getEntryDate());
+                    accountExpenseDB.setExpenseType("0");
+                    accountExpenseDB.setSupplierName(purchaseLedgerDB.getSupplierName());
+                    accountExpenseDB.setExpenseMoney(purchaseLedgerDB.getContractAmount());
+                    accountExpenseDB.setExpenseDescribed("閲囪喘鍚堝悓锛�" + purchaseLedgerDB.getPurchaseContractNumber());
+                    accountExpenseDB.setExpenseMethod("0");
+                    accountExpenseDB.setInvoiceNumber(purchaseLedgerDB.getPurchaseContractNumber());
+                    accountExpenseService.updateById(accountExpenseDB);
+                });
             }
 
         }
@@ -178,6 +229,31 @@
         List<SalesLedgerProduct> productList = purchaseLedgerDto.getProductData();
         if (productList != null && !productList.isEmpty()) {
             handleSalesLedgerProducts(purchaseLedger.getId(), productList, purchaseLedgerDto.getType());
+        }
+        //鏂板鍘熸潗鏂欐楠�
+        for (SalesLedgerProduct saleProduct : productList) {
+            QualityInspect qualityInspect = new QualityInspect();
+            qualityInspect.setInspectType(0);
+            qualityInspect.setSupplier(purchaseLedger.getSupplierName());
+            qualityInspect.setPurchaseLedgerId(purchaseLedger.getId());
+            qualityInspect.setProductId(saleProduct.getId());
+            qualityInspect.setProductName(saleProduct.getProductCategory());
+            qualityInspect.setModel(saleProduct.getSpecificationModel());
+            qualityInspect.setUnit(saleProduct.getUnit());
+            qualityInspect.setQuantity(saleProduct.getQuantity());
+            qualityInspectMapper.insert(qualityInspect);
+            QualityTestStandard qualityTestStandard = new QualityTestStandard();
+            qualityTestStandard.setProductId(saleProduct.getProductId());
+            List<QualityTestStandard> qualityTestStandards = qualityTestStandardMapper.qualityTestStandardList(qualityTestStandard);
+            for (QualityTestStandard qualityTestStandardDB : qualityTestStandards) {
+                QualityInspectParam qualityInspectParam = new QualityInspectParam();
+                qualityInspectParam.setInspectId(qualityInspect.getId());
+                qualityInspectParam.setParameterItem(qualityTestStandardDB.getParameterItem());
+                qualityInspectParam.setUnit(qualityTestStandardDB.getUnit());
+                qualityInspectParam.setStandardValue(qualityTestStandardDB.getStandardValue());
+                qualityInspectParam.setControlValue(qualityTestStandardDB.getControlValue());
+                qualityInspectParamMapper.insert(qualityInspectParam);
+            }
         }
 
         // 5. 杩佺Щ涓存椂鏂囦欢鍒版寮忕洰褰�
@@ -358,7 +434,7 @@
         salesLedgerProductMapper.delete(queryWrapper);
         // 鎵归噺鍒犻櫎鍏宠仈鐨勯噰璐彴璐︾殑鏉ョエ鐧昏
         LambdaQueryWrapper<TicketRegistration> ticketRegistrationLambdaQueryWrapper = new LambdaQueryWrapper<>();
-        ticketRegistrationLambdaQueryWrapper.in(TicketRegistration::getPurchaseLedgerId,ids);
+        ticketRegistrationLambdaQueryWrapper.in(TicketRegistration::getSalesLedgerId,ids);
         ticketRegistrationMapper.delete(ticketRegistrationLambdaQueryWrapper);
         // 鎵归噺鍒犻櫎鍏宠仈鐨勯噰璐彴璐︾殑鏉ョエ鐧昏璁板綍
         LambdaQueryWrapper<ProductRecord> productRecordLambdaQueryWrapper = new LambdaQueryWrapper<>();
@@ -366,8 +442,24 @@
         productRecordMapper.delete(productRecordLambdaQueryWrapper);
         // 鎵归噺鍒犻櫎浠樻鐧昏
         LambdaQueryWrapper<PaymentRegistration> paymentRegistrationLambdaQueryWrapper = new LambdaQueryWrapper<>();
-        paymentRegistrationLambdaQueryWrapper.in(PaymentRegistration::getPurchaseLedgerId,ids);
+        paymentRegistrationLambdaQueryWrapper.in(PaymentRegistration::getPurchaseLedgerId, ids);
         paymentRegistrationMapper.delete(paymentRegistrationLambdaQueryWrapper);
+        //鎵归噺鍒犻櫎妫�楠屾爣鍑�
+        LambdaQueryWrapper<QualityInspect> materialInspectLambdaQueryWrapper = new LambdaQueryWrapper<>();
+        materialInspectLambdaQueryWrapper.in(QualityInspect::getPurchaseLedgerId, ids);
+        List<QualityInspect> qualityInspects = qualityInspectMapper.selectList(materialInspectLambdaQueryWrapper);
+        List<Long> inspectIds = qualityInspects.stream()
+                .map(QualityInspect::getId)
+                .collect(Collectors.toList());
+
+        if (inspectIds.size() > 0) {
+            LambdaQueryWrapper<QualityInspectParam> qualityStandardLambdaQueryWrapper = new LambdaQueryWrapper<>();
+            qualityStandardLambdaQueryWrapper.in(QualityInspectParam::getInspectId, inspectIds);
+            qualityInspectParamMapper.delete(qualityStandardLambdaQueryWrapper);
+        }
+
+        //鎵归噺鍒犻櫎鍘熸潗鏂欐楠屾暟鎹�
+        qualityInspectMapper.delete(materialInspectLambdaQueryWrapper);
         // 鎵归噺鍒犻櫎閲囪喘鍙拌处
         return purchaseLedgerMapper.deleteBatchIds(Arrays.asList(ids));
     }
@@ -389,7 +481,7 @@
         // 3.鏌ヨ涓婁紶鏂囦欢
         LambdaQueryWrapper<CommonFile> salesLedgerFileWrapper = new LambdaQueryWrapper<>();
         salesLedgerFileWrapper.eq(CommonFile::getCommonId, purchaseLedger.getId())
-                .eq(CommonFile::getType, FileNameType.PURCHASE.getValue());
+                .eq(CommonFile::getType,FileNameType.PURCHASE.getValue());
         List<CommonFile> salesLedgerFiles = commonFileMapper.selectList(salesLedgerFileWrapper);
 
         // 4. 杞崲 DTO
@@ -494,8 +586,8 @@
     @Override
     public List<InvoiceRegistrationProduct> getProductBySalesNo(Long id) {
         List<InvoiceRegistrationProduct> invoiceRegistrationProducts = invoiceRegistrationProductMapper.selectList(new LambdaQueryWrapper<InvoiceRegistrationProduct>()
-                        .select(InvoiceRegistrationProduct::getId, InvoiceRegistrationProduct::getProductCategory, InvoiceRegistrationProduct::getSpecificationModel,
-                                InvoiceRegistrationProduct::getUnit, InvoiceRegistrationProduct::getQuantity)
+                .select(InvoiceRegistrationProduct::getId, InvoiceRegistrationProduct::getProductCategory, InvoiceRegistrationProduct::getSpecificationModel,
+                        InvoiceRegistrationProduct::getUnit, InvoiceRegistrationProduct::getQuantity)
                 .eq(InvoiceRegistrationProduct::getSalesLedgerId, id));
         if (invoiceRegistrationProducts.isEmpty()) {
             return new ArrayList<>();

--
Gitblit v1.9.3