From 83383b2b94d34c1986769d20c8cdd6149e46739c Mon Sep 17 00:00:00 2001
From: chenrui <1187576398@qq.com>
Date: 星期二, 10 六月 2025 11:39:34 +0800
Subject: [PATCH] 开票登记编辑功能开发
---
src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java | 101 +++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 94 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java
index 9ce10fb..2d1bdf7 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java
@@ -10,12 +10,8 @@
import com.ruoyi.sales.dto.InvoiceLedgerDto;
import com.ruoyi.sales.dto.InvoiceRegistrationProductDto;
import com.ruoyi.sales.excel.InvoiceLedgerExcelDto;
-import com.ruoyi.sales.mapper.InvoiceLedgerFileMapper;
-import com.ruoyi.sales.mapper.InvoiceLedgerMapper;
-import com.ruoyi.sales.mapper.InvoiceRegistrationMapper;
-import com.ruoyi.sales.mapper.InvoiceRegistrationProductMapper;
-import com.ruoyi.sales.pojo.InvoiceLedger;
-import com.ruoyi.sales.pojo.InvoiceLedgerFile;
+import com.ruoyi.sales.mapper.*;
+import com.ruoyi.sales.pojo.*;
import com.ruoyi.sales.service.InvoiceLedgerService;
import org.apache.commons.collections4.CollectionUtils;
import org.springframework.beans.BeanUtils;
@@ -31,6 +27,7 @@
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.YearMonth;
+import java.util.Comparator;
import java.util.List;
import java.util.Objects;
import java.util.UUID;
@@ -52,7 +49,10 @@
private InvoiceRegistrationProductMapper invoiceRegistrationProductMapper;
@Autowired
- private InvoiceRegistrationMapper invoiceRegistrationMapper;
+ private ReceiptPaymentMapper receiptPaymentMapper;
+
+ @Autowired
+ private SalesLedgerProductMapper salesLedgerProductMapper;
/**
* 寮�绁ㄥ彴璐︽柊澧�
@@ -76,6 +76,27 @@
invoiceLedger.setInvoicePerson(productDto.getInvoicePerson());
result = invoiceLedgerMapper.insert(invoiceLedger);
}else {
+ // 淇敼sale_leger_product
+ InvoiceRegistrationProduct invoiceRegistrationProduct = invoiceRegistrationProductMapper.selectById(productDto.getId());
+ SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(invoiceRegistrationProduct.getSalesLedgerProductId());
+
+ BigDecimal invoiceNum = productDto.getInvoiceTotal().divide(invoiceRegistrationProduct.getTaxInclusiveTotalPrice(), 2, BigDecimal.ROUND_HALF_UP);
+ //璁＄畻 鏈紑绁ㄦ暟/鏈紑绁ㄩ噾棰�
+ BigDecimal noInvoiceAmount = salesLedgerProduct.getNoInvoiceAmount().add(invoiceRegistrationProduct.getInvoiceAmount()).subtract(productDto.getInvoiceTotal());
+ BigDecimal noInvoiceNum = salesLedgerProduct.getNoInvoiceNum().add(invoiceRegistrationProduct.getInvoiceNum()).subtract(invoiceNum);
+ salesLedgerProduct.setNoInvoiceAmount(noInvoiceAmount);
+ salesLedgerProduct.setNoInvoiceNum(noInvoiceNum);
+ salesLedgerProductMapper.updateById(salesLedgerProduct);
+
+ // 淇敼褰撳墠浜у搧寮�绁ㄧ櫥璁拌褰曟暟鎹�
+ BigDecimal currentNoInvoiceNum = invoiceRegistrationProduct.getNoInvoiceNum().add(invoiceRegistrationProduct.getInvoiceNum()).subtract(invoiceNum);
+ BigDecimal currentNoInvoiceAmount = invoiceRegistrationProduct.getNoInvoiceAmount().add(invoiceRegistrationProduct.getInvoiceAmount()).subtract(productDto.getInvoiceTotal());
+ invoiceRegistrationProduct.setInvoiceNum(invoiceNum);
+ invoiceRegistrationProduct.setInvoiceAmount(productDto.getInvoiceAmount());
+ invoiceRegistrationProduct.setNoInvoiceNum(currentNoInvoiceNum);
+ invoiceRegistrationProduct.setNoInvoiceAmount(currentNoInvoiceAmount);
+ invoiceRegistrationProductMapper.updateById(invoiceRegistrationProduct);
+
invoiceLedger.setInvoiceNo(productDto.getInvoiceNo());
invoiceLedger.setInvoiceTotal(productDto.getInvoiceTotal());
invoiceLedger.setInvoiceDate(productDto.getInvoiceDate());
@@ -307,4 +328,70 @@
return invoiceRegistrationProductDto;
}
+ /**
+ * 寮�绁ㄥ彴璐﹀垹闄�
+ * @param invoiceRegistrationProductId
+ * @return
+ */
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void delInvoiceLedger(Integer invoiceRegistrationProductId) {
+ // 鍒ゆ柇鏄惁鏈夊洖娆捐褰�
+ List<ReceiptPayment> receiptPaymentList = receiptPaymentMapper.receiptPaymentListByProdRegId(invoiceRegistrationProductId);
+ if(!CollectionUtils.isEmpty(receiptPaymentList)){
+ throw new RuntimeException("璇峰厛鍒犻櫎鍥炴璁板綍");
+ }
+ // 鍒ゆ柇鏄惁鏈夊紑绁ㄥ彴璐�
+ InvoiceRegistrationProduct invoiceRegistrationProduct = invoiceRegistrationProductMapper.selectById(invoiceRegistrationProductId);
+ if(ObjectUtils.isEmpty(invoiceRegistrationProduct)){
+ throw new RuntimeException("寮�绁ㄥ彴璐︽煡鎵惧け璐�");
+ }
+ // 鍒ゆ柇璇ュ紑绁ㄥ彴璐︽槸鍚︽湭褰撴湀锛屽鏋滀负褰撴湀鐩存帴鍒犻櫎鍚﹀垯鏂板涓�鏉＄浉鍙嶈礋鏁版暟鎹�
+
+ // 鍒犻櫎寮�绁ㄥ彴璐�
+ QueryWrapper<InvoiceLedger> delMapper = new QueryWrapper<>();
+ delMapper.eq("invoice_registration_product_id", invoiceRegistrationProductId);
+ invoiceLedgerMapper.delete(delMapper);
+ // 鍒犻櫎寮�绁ㄧ櫥璁板苟鍥炴粴
+ QueryWrapper<InvoiceRegistrationProduct> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("sales_ledger_id", invoiceRegistrationProduct.getSalesLedgerId());
+ queryWrapper.eq("sales_ledger_product_id", invoiceRegistrationProduct.getSalesLedgerProductId());
+ queryWrapper.orderByAsc("create_time");
+ List<InvoiceRegistrationProduct> invoiceRegistrationProductList = invoiceRegistrationProductMapper.selectList(queryWrapper);
+ int index = -1;
+ for (int i = 0; i < invoiceRegistrationProductList.size(); i++) {
+ InvoiceRegistrationProduct currentInvoiceRegProduct = invoiceRegistrationProductList.get(i);
+ if(invoiceRegistrationProduct.getId() == currentInvoiceRegProduct.getId()){
+ index = i;
+ }
+ }
+ if(index == -1){
+ return;
+ }
+ for (int i = index + 1; i < invoiceRegistrationProductList.size(); i++) {
+ InvoiceRegistrationProduct currentInvoiceRegProduct = invoiceRegistrationProductList.get(i);
+ // 鍥炴粴鏈紑绁ㄦ暟/鏈紑绁ㄩ噾棰�
+ BigDecimal noInvoiceAmount = currentInvoiceRegProduct.getNoInvoiceAmount().add(invoiceRegistrationProduct.getInvoiceAmount());
+ BigDecimal noInvoiceNum = currentInvoiceRegProduct.getNoInvoiceNum().add(invoiceRegistrationProduct.getInvoiceNum());
+ currentInvoiceRegProduct.setNoInvoiceAmount(noInvoiceAmount);
+ currentInvoiceRegProduct.setNoInvoiceNum(noInvoiceNum);
+ invoiceRegistrationProductMapper.updateById(currentInvoiceRegProduct);
+ }
+ invoiceRegistrationProductMapper.deleteById(invoiceRegistrationProductId);
+ // 淇敼sale_product鏁版嵁
+ SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(invoiceRegistrationProduct.getSalesLedgerProductId());
+ QueryWrapper<InvoiceRegistrationProduct> newQueryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("sales_ledger_id", invoiceRegistrationProduct.getSalesLedgerId());
+ queryWrapper.eq("sales_ledger_product_id", invoiceRegistrationProduct.getSalesLedgerProductId());
+ queryWrapper.orderByAsc("create_time");
+ List<InvoiceRegistrationProduct> newInvoiceRegistrationProductList = invoiceRegistrationProductMapper.selectList(newQueryWrapper);
+ if(CollectionUtils.isEmpty(newInvoiceRegistrationProductList)){
+ salesLedgerProduct.setNoInvoiceNum(salesLedgerProduct.getQuantity());
+ salesLedgerProduct.setNoInvoiceAmount(salesLedgerProduct.getTaxInclusiveTotalPrice());
+ }else {
+ salesLedgerProduct.setNoInvoiceNum(newInvoiceRegistrationProductList.get(newInvoiceRegistrationProductList.size()-1).getNoInvoiceNum());
+ salesLedgerProduct.setNoInvoiceAmount(newInvoiceRegistrationProductList.get(newInvoiceRegistrationProductList.size()-1).getNoInvoiceAmount());
+ }
+ salesLedgerProductMapper.updateById(salesLedgerProduct);
+ }
}
--
Gitblit v1.9.3