From 78c0d6c79dcd5a8e2e2f99199dbcf5504fe8687b Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期六, 24 五月 2025 15:45:56 +0800
Subject: [PATCH] 采购管理模块

---
 src/main/java/com/ruoyi/purchase/service/impl/TicketRegistrationServiceImpl.java |   83 +++++++++++++++++++++++++++++++++--------
 1 files changed, 66 insertions(+), 17 deletions(-)

diff --git a/src/main/java/com/ruoyi/purchase/service/impl/TicketRegistrationServiceImpl.java b/src/main/java/com/ruoyi/purchase/service/impl/TicketRegistrationServiceImpl.java
index dee106e..c9d189f 100644
--- a/src/main/java/com/ruoyi/purchase/service/impl/TicketRegistrationServiceImpl.java
+++ b/src/main/java/com/ruoyi/purchase/service/impl/TicketRegistrationServiceImpl.java
@@ -4,13 +4,16 @@
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ruoyi.common.exception.base.BaseException;
+import com.ruoyi.common.utils.DateUtils;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.bean.BeanUtils;
 import com.ruoyi.other.mapper.TempFileMapper;
 import com.ruoyi.other.pojo.TempFile;
 import com.ruoyi.purchase.dto.TicketRegistrationDto;
+import com.ruoyi.purchase.mapper.ProductRecordMapper;
 import com.ruoyi.purchase.mapper.PurchaseLedgerMapper;
 import com.ruoyi.purchase.mapper.TicketRegistrationMapper;
+import com.ruoyi.purchase.pojo.ProductRecord;
 import com.ruoyi.purchase.pojo.PurchaseLedger;
 import com.ruoyi.purchase.pojo.TicketRegistration;
 import com.ruoyi.purchase.service.ITicketRegistrationService;
@@ -23,6 +26,7 @@
 import org.apache.commons.io.FilenameUtils;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
 import java.io.IOException;
 import java.math.BigDecimal;
@@ -35,6 +39,7 @@
 import java.time.format.DateTimeFormatter;
 import java.util.Arrays;
 import java.util.List;
+import java.util.Map;
 import java.util.UUID;
 import java.util.stream.Collectors;
 
@@ -59,6 +64,8 @@
 
     private final TempFileMapper tempFileMapper;
 
+    private final ProductRecordMapper productRecordMapper;
+
     @Value("${file.upload-dir}")
     private String uploadDir;
 
@@ -67,12 +74,15 @@
     public List<TicketRegistration> selectTicketRegistrationList(TicketRegistration ticketRegistration) {
         LambdaQueryWrapper<TicketRegistration> queryWrapper = new LambdaQueryWrapper<>();
         if (StringUtils.isNotBlank(ticketRegistration.getPurchaseContractNumber())) {
-            queryWrapper.like(TicketRegistration::getPurchaseContractNumber, ticketRegistration.getPurchaseContractNumber());
+            queryWrapper.like(TicketRegistration::getPurchaseContractNumber, ticketRegistration.getPurchaseContractNumber())
+                    .like(TicketRegistration::getSupplierName, ticketRegistration.getSupplierName())
+                    .eq(TicketRegistration::getIssueDate, ticketRegistration.getIssueDate());
         }
         return ticketRegistrationMapper.selectList(queryWrapper);
     }
 
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public int addOrUpdateRegistration(TicketRegistrationDto ticketRegistrationDto) throws IOException {
         // 1. 鏌ヨ閲囪喘鍙拌处璁板綍
         PurchaseLedger purchaseLedger = purchaseLedgerMapper.selectById(ticketRegistrationDto.getPurchaseLedgerId());
@@ -81,21 +91,13 @@
             throw new IllegalArgumentException("閲囪喘鍙拌处璁板綍涓嶅瓨鍦紝ID: " + ticketRegistrationDto.getPurchaseLedgerId());
         }
 
-        // 2. 鏌ヨ鏄惁宸插瓨鍦ㄧエ鎹櫥璁拌褰�
-        TicketRegistration existingRecord = ticketRegistrationMapper.selectOne(
-                new LambdaQueryWrapper<TicketRegistration>()
-                        .eq(TicketRegistration::getPurchaseLedgerId, ticketRegistrationDto.getPurchaseLedgerId())
-        );
-
         // 3. 鍒涘缓鎴栨洿鏂扮エ鎹櫥璁板疄浣�
         TicketRegistration ticketRegistration = new TicketRegistration();
         BeanUtils.copyProperties(ticketRegistrationDto, ticketRegistration);
-        if (existingRecord != null){
-            ticketRegistration.setId(existingRecord.getId());
-        }
         ticketRegistration.setPurchaseContractNumber(purchaseLedger.getPurchaseContractNumber());
         ticketRegistration.setTenantId(purchaseLedger.getTenantId());
         ticketRegistration.setContractAmount(purchaseLedger.getContractAmount());
+        ticketRegistration.setSalesLedgerId(purchaseLedger.getSalesLedgerId());
 
         // 4. 澶勭悊瀛愯〃鏁版嵁
         List<SalesLedgerProduct> productData = ticketRegistrationDto.getProductData();
@@ -104,10 +106,22 @@
         }
 
         // 5. 鎵ц鎻掑叆鎴栨洿鏂版搷浣�
-        int rowsAffected = existingRecord != null
-                ? ticketRegistrationMapper.updateById(ticketRegistration)
-                : ticketRegistrationMapper.insert(ticketRegistration);
+        int rowsAffected = ticketRegistrationMapper.insert(ticketRegistration);
 
+        // 6. 澧炲姞閲囪喘鍙拌处浜у搧寮�绁ㄨ褰�
+        List<SalesLedgerProduct> salesLedgerProducts = ticketRegistrationDto.getProductData();
+        if (CollectionUtils.isNotEmpty(salesLedgerProducts)){
+            for (SalesLedgerProduct salesLedgerProduct : salesLedgerProducts) {
+                ProductRecord productRecord = new ProductRecord();
+                productRecord.setTicketRegistrationId(ticketRegistration.getId());
+                productRecord.setPurchaseLedgerId(ticketRegistrationDto.getPurchaseLedgerId());
+                productRecord.setCreatedAt(DateUtils.getNowDate());
+                BeanUtils.copyProperties(salesLedgerProduct,productRecord);
+                productRecord.setId(null);
+                productRecord.setType("2");
+                productRecordMapper.insert(productRecord);
+            }
+        }
         // 杩佺Щ涓存椂鏂囦欢鍒版寮忕洰褰�
         if (ticketRegistrationDto.getTempFileIds() != null && !ticketRegistrationDto.getTempFileIds().isEmpty()) {
             migrateTempFilesToFormal(ticketRegistration.getId(), ticketRegistrationDto.getTempFileIds());
@@ -209,8 +223,21 @@
                 .eq(SalesLedgerProduct::getType, 2);
         List<SalesLedgerProduct> productList = salesLedgerProductMapper.selectList(queryWrapper);
         resultDto.setProductData(productList);
-
         return resultDto;
+    }
+
+    @Override
+    public List getTicketNo(TicketRegistrationDto ticketRegistrationDto) {
+        LambdaQueryWrapper<TicketRegistration> queryWrapper = new LambdaQueryWrapper<>();
+        queryWrapper.select(TicketRegistration::getId,TicketRegistration::getInvoiceNumber,TicketRegistration::getInvoiceAmount)
+                .eq(TicketRegistration::getPurchaseLedgerId,ticketRegistrationDto.getId());
+        List<Map<String, Object>> result = ticketRegistrationMapper.selectMaps(queryWrapper);
+        // 灏嗕笅鍒掔嚎鍛藉悕杞崲涓洪┘宄板懡鍚�
+        return result.stream().map(map -> map.entrySet().stream()
+                .collect(Collectors.toMap(
+                        entry -> underlineToCamel(entry.getKey()),
+                        Map.Entry::getValue))
+        ).collect(Collectors.toList());
     }
 
     private void handleSalesLedgerProducts(Long salesLedgerId, List<SalesLedgerProduct> products, Integer type) {
@@ -237,8 +264,8 @@
                 if (product.getTicketsNum() == null) {
                     throw new BaseException("宸插紑绁ㄦ暟閲忎笉鑳戒负绌�");
                 }
-                if (product.getTaxExclusiveTotalPrice() == null) {
-                    throw new BaseException("涓嶅惈绋庢�讳环涓嶈兘涓虹┖");
+                if (product.getTaxInclusiveTotalPrice() == null) {
+                    throw new BaseException("鍚◣鎬讳环涓嶈兘涓虹┖");
                 }
                 if (product.getTicketsAmount() == null) {
                     throw new BaseException("鏈鏉ョエ閲戦(鍏�)涓嶈兘涓虹┖");
@@ -253,7 +280,7 @@
 
                 // 璁$畻 futureTicketsAmount
                 product.setFutureTicketsAmount(
-                        product.getTaxExclusiveTotalPrice()
+                        product.getTaxInclusiveTotalPrice()
                                 .subtract(product.getTicketsAmount())
                 );
                 product.setType(type);
@@ -261,4 +288,26 @@
             });
         }
     }
+
+    /**
+     * 涓嬪垝绾垮懡鍚嶈浆椹煎嘲鍛藉悕
+     */
+    private String underlineToCamel(String param) {
+        if (param == null || "".equals(param.trim())) {
+            return "";
+        }
+        int len = param.length();
+        StringBuilder sb = new StringBuilder(len);
+        for (int i = 0; i < len; i++) {
+            char c = param.charAt(i);
+            if (c == '_') {
+                if (++i < len) {
+                    sb.append(Character.toUpperCase(param.charAt(i)));
+                }
+            } else {
+                sb.append(Character.toLowerCase(c));
+            }
+        }
+        return sb.toString();
+    }
 }

--
Gitblit v1.9.3