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 | 84 ++++++++++++++++++++++++++++++++++++++--- 1 files changed, 77 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 0d6cf08..2d1bdf7 100644 --- a/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java +++ b/src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java @@ -11,9 +11,7 @@ import com.ruoyi.sales.dto.InvoiceRegistrationProductDto; import com.ruoyi.sales.excel.InvoiceLedgerExcelDto; import com.ruoyi.sales.mapper.*; -import com.ruoyi.sales.pojo.InvoiceLedger; -import com.ruoyi.sales.pojo.InvoiceLedgerFile; -import com.ruoyi.sales.pojo.ReceiptPayment; +import com.ruoyi.sales.pojo.*; import com.ruoyi.sales.service.InvoiceLedgerService; import org.apache.commons.collections4.CollectionUtils; import org.springframework.beans.BeanUtils; @@ -29,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,6 +51,9 @@ @Autowired private ReceiptPaymentMapper receiptPaymentMapper; + @Autowired + private SalesLedgerProductMapper salesLedgerProductMapper; + /** * 寮�绁ㄥ彴璐︽柊澧� * @param productDto @@ -74,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()); @@ -318,10 +341,57 @@ 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