From efd19d385d177bfcc8d9747148ae2357e9f6aedc Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期一, 14 七月 2025 16:19:27 +0800
Subject: [PATCH] 修改销售管理-回款登记,金额不许超过发票金额

---
 src/main/java/com/ruoyi/sales/service/impl/ReceiptPaymentServiceImpl.java |  124 +++++++++++++++++++++++++++++++++++++++++
 1 files changed, 123 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/ruoyi/sales/service/impl/ReceiptPaymentServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/ReceiptPaymentServiceImpl.java
index 1e84cec..5349dab 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/ReceiptPaymentServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/ReceiptPaymentServiceImpl.java
@@ -4,10 +4,16 @@
 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.common.utils.SecurityUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.sales.dto.CustomerInteractionDto;
 import com.ruoyi.sales.dto.InvoiceLedgerDto;
 import com.ruoyi.sales.dto.ReceiptPaymentDto;
+import com.ruoyi.sales.dto.ReceiptPaymentExeclDto;
+import com.ruoyi.sales.mapper.InvoiceLedgerMapper;
 import com.ruoyi.sales.mapper.ReceiptPaymentMapper;
 import com.ruoyi.sales.mapper.SalesLedgerMapper;
+import com.ruoyi.sales.pojo.InvoiceLedger;
 import com.ruoyi.sales.pojo.ReceiptPayment;
 import com.ruoyi.sales.pojo.SalesLedger;
 import com.ruoyi.sales.service.ReceiptPaymentService;
@@ -16,10 +22,12 @@
 import org.springframework.util.CollectionUtils;
 import org.springframework.util.ObjectUtils;
 
+import javax.servlet.http.HttpServletResponse;
 import java.math.BigDecimal;
 import java.time.LocalDate;
 import java.time.YearMonth;
 import java.util.*;
+import java.util.stream.Collectors;
 
 @Service
 public class ReceiptPaymentServiceImpl extends ServiceImpl<ReceiptPaymentMapper,ReceiptPayment> implements ReceiptPaymentService {
@@ -29,6 +37,8 @@
 
     @Autowired
     private SalesLedgerMapper salesLedgerMapper;
+    @Autowired
+    private InvoiceLedgerMapper invoiceLedgerMapper;
 
     /**
      * 鍥炴鐧昏鏂板
@@ -37,9 +47,27 @@
      */
     @Override
     public int receiptPaymentSaveOrUpdate(ReceiptPayment receiptPayment) {
+        ReceiptPayment byId = receiptPayment;
+        if (!ObjectUtils.isEmpty(receiptPayment.getId())){
+             byId = this.getById(receiptPayment.getId());
+        }
+        InvoiceLedger invoiceLedger = invoiceLedgerMapper.selectById(byId.getInvoiceLedgerId());
+        Page<ReceiptPaymentDto> objectPage = new Page<>();
+        ReceiptPaymentDto receiptPaymentDto = new ReceiptPaymentDto();
+        receiptPaymentDto.setInvoiceLedgerId(invoiceLedger.getId());
+        IPage<ReceiptPaymentDto> receiptPaymentDtoIPage = receiptPaymentMapper.bindInvoiceNoRegPage(objectPage, receiptPaymentDto);
+        ReceiptPaymentDto receiptPaymentDto1 = receiptPaymentDtoIPage.getRecords().get(0);
+        if (!ObjectUtils.isEmpty(byId.getId())){
+            receiptPaymentDto1.setNoReceiptAmount(receiptPaymentDto1.getNoReceiptAmount().add(byId.getReceiptPaymentAmount()));
+        }
+        if (receiptPaymentDto1.getNoReceiptAmount().compareTo(receiptPayment.getReceiptPaymentAmount())<0){
+            throw new RuntimeException("鏈鍥炴閲戦涓嶈兘澶т簬寰呭洖娆鹃噾棰�");
+        }
         if(null==receiptPayment.getId()){
+
             return receiptPaymentMapper.insert(receiptPayment);
         }else {
+
             return receiptPaymentMapper.updateById(receiptPayment);
         }
     }
@@ -132,7 +160,11 @@
      */
     @Override
     public IPage<ReceiptPaymentDto> bindInvoiceNoRegPage(Page page, ReceiptPaymentDto receiptPaymentDto) {
-        return receiptPaymentMapper.bindInvoiceNoRegPage(page, receiptPaymentDto);
+        IPage<ReceiptPaymentDto> receiptPaymentDtoIPage = receiptPaymentMapper.bindInvoiceNoRegPage(page, receiptPaymentDto);
+        if (receiptPaymentDto.getStatus()) {
+            receiptPaymentDtoIPage.getRecords().removeIf(receiptPaymentDto1 -> new BigDecimal("0.00").equals(receiptPaymentDto1.getNoReceiptAmount()));
+        }
+        return receiptPaymentDtoIPage;
     }
 
     /**
@@ -190,4 +222,94 @@
     public IPage<ReceiptPaymentDto> receiptPaymentHistoryListPage(Page page, ReceiptPaymentDto receiptPaymentDto) {
         return receiptPaymentMapper.receiptPaymentHistoryListPage(page, receiptPaymentDto);
     }
+
+    /**
+     * 瀹㈡埛寰�鏉ヨ褰曟煡璇�
+     * @param receiptPaymentDto
+     * @return
+     */
+    @Override
+    public List<CustomerInteractionDto> customerInteractions(ReceiptPaymentDto receiptPaymentDto) {
+        ArrayList<CustomerInteractionDto> result = new ArrayList<>();
+        List<CustomerInteractionDto> customerInteractionDtos = receiptPaymentMapper.customerInteractions(receiptPaymentDto);
+        if(CollectionUtils.isEmpty(customerInteractionDtos)){
+            return result;
+        }
+        // 搴旀敹鎬婚噾棰濋噾棰濊绠�
+        BigDecimal amountTotal = BigDecimal.ZERO;
+        Map<LocalDate, List<CustomerInteractionDto>> dateListMap = customerInteractionDtos.stream().collect(
+                Collectors.groupingBy(
+                        CustomerInteractionDto::getHappenTime,
+                        LinkedHashMap::new,
+                        Collectors.toList()
+                )
+        );
+        for (LocalDate localDate : dateListMap.keySet()) {
+            BigDecimal currentReceiptAmount = BigDecimal.ZERO;
+            BigDecimal invoiceAmount = BigDecimal.ZERO;
+            BigDecimal currentDateTotal = BigDecimal.ZERO;
+            List<CustomerInteractionDto> customerInteractionDtoList = dateListMap.get(localDate);
+            // 璁$畻褰撳ぉ鏀舵鏁�
+            currentReceiptAmount = customerInteractionDtoList.stream()
+                    .filter(item ->item.getType() == 0)
+                    .map(CustomerInteractionDto::getReceiptAmount)
+                    .reduce(BigDecimal.ZERO,BigDecimal::add);
+            // 璁$畻褰撳ぉ寮�绁ㄦ暟
+            invoiceAmount = customerInteractionDtoList.stream()
+                    .filter(item ->item.getType() == 1)
+                    .map(CustomerInteractionDto::getInvoiceAmount)
+                    .reduce(BigDecimal.ZERO,BigDecimal::add);
+            // 璁$畻褰撴棩姹囨��
+            currentDateTotal = currentDateTotal.add(invoiceAmount).subtract(currentReceiptAmount);
+            CustomerInteractionDto customerInteractionDto = new CustomerInteractionDto();
+            customerInteractionDto.setHappenTime(localDate);
+            customerInteractionDto.setInvoiceAmount(invoiceAmount);
+            customerInteractionDto.setReceiptAmount(currentReceiptAmount);
+            amountTotal = customerInteractionDto.getInvoiceAmount().subtract(customerInteractionDto.getReceiptAmount());
+            customerInteractionDto.setUnReceiptAmount(amountTotal);
+            result.add(customerInteractionDto);
+        }
+        ArrayList<CustomerInteractionDto> newResult = new ArrayList<>();
+        for (int i = 0; i < result.size(); i++) {
+            CustomerInteractionDto customerInteractionDto = result.get(i);
+            if (i == 0) {
+                customerInteractionDto.setUnReceiptAmount(customerInteractionDto.getInvoiceAmount().subtract(customerInteractionDto.getReceiptAmount()));
+            }else {
+                CustomerInteractionDto customerInteractionDto1 = result.get(i-1);
+                customerInteractionDto.setUnReceiptAmount(customerInteractionDto1.getUnReceiptAmount()
+                        .add(customerInteractionDto.getInvoiceAmount()).subtract(customerInteractionDto.getReceiptAmount()));
+            }
+            newResult.add(customerInteractionDto);
+        }
+        return newResult;
+    }
+
+    /**
+     * 鏌ヨ鍥炴璁板綍鍒嗛〉
+     */
+    @Override
+    public List<ReceiptPaymentDto> receiptPaymentHistoryListNoPage(ReceiptPaymentDto receiptPaymentDto) {
+        return receiptPaymentMapper.receiptPaymentHistoryListNoPage( receiptPaymentDto);
+    }
+
+    @Override
+    public void exportPaymentList(HttpServletResponse response) {
+       List<ReceiptPaymentDto> receiptPaymentDtoList =  receiptPaymentMapper.bindInvoiceNoRegListAll();
+        ExcelUtil<ReceiptPaymentDto> util = new ExcelUtil<ReceiptPaymentDto>(ReceiptPaymentDto.class);
+        util.exportExcel(response, receiptPaymentDtoList, "鍥炴鐧昏");
+    }
+
+    @Override
+    public void exportPaymentList(HttpServletResponse response, List<Long> ids) {
+        if (ids == null) {
+            List<ReceiptPaymentExeclDto> receiptPaymentDtoList =  receiptPaymentMapper.bindInvoiceNoRegListByIds(new ArrayList<>(), SecurityUtils.getLoginUser().getTenantId());
+            ExcelUtil<ReceiptPaymentExeclDto> util = new ExcelUtil<ReceiptPaymentExeclDto>(ReceiptPaymentExeclDto.class);
+            util.exportExcel(response, receiptPaymentDtoList, "鍥炴鐧昏");
+        }else {
+            List<ReceiptPaymentExeclDto> receiptPaymentDtoList =  receiptPaymentMapper.bindInvoiceNoRegListByIds(ids,SecurityUtils.getLoginUser().getTenantId());
+            ExcelUtil<ReceiptPaymentExeclDto> util = new ExcelUtil<ReceiptPaymentExeclDto>(ReceiptPaymentExeclDto.class);
+            util.exportExcel(response, receiptPaymentDtoList, "鍥炴鐧昏");
+        }
+
+    }
 }

--
Gitblit v1.9.3