From 390b4243dff25a50f1d3302228e7dd16e9c2f18a Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期三, 14 五月 2025 17:56:24 +0800 Subject: [PATCH] 1.合同金额优化 2.来票台账 --- src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java | 95 ++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 89 insertions(+), 6 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 c8ef0fc..f49faf8 100644 --- a/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java +++ b/src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java @@ -2,6 +2,7 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.common.utils.StringUtils; @@ -27,6 +28,7 @@ import org.springframework.stereotype.Service; import java.io.IOException; +import java.math.BigDecimal; import java.nio.file.Files; import java.nio.file.Path; import java.nio.file.Paths; @@ -34,10 +36,7 @@ import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; -import java.util.Arrays; -import java.util.List; -import java.util.Map; -import java.util.UUID; +import java.util.*; import java.util.stream.Collectors; /** @@ -67,7 +66,11 @@ @Override public List<PurchaseLedger> selectPurchaseLedgerList(PurchaseLedger purchaseLedger) { - return purchaseLedgerMapper.selectList(new LambdaQueryWrapper<>()); + LambdaQueryWrapper<PurchaseLedger> queryWrapper = new LambdaQueryWrapper<>(); + if (StringUtils.isNotBlank(purchaseLedger.getPurchaseContractNumber())) { + queryWrapper.like(PurchaseLedger::getPurchaseContractNumber,purchaseLedger.getPurchaseContractNumber()); + } + return purchaseLedgerMapper.selectList(queryWrapper); } @Override @@ -75,9 +78,13 @@ SalesLedger salesLedger = salesLedgerMapper.selectById(purchaseLedgerDto.getSalesLedgerId()); + //涓氬姟鍛� + SysUser businessPerson = userMapper.selectUserById(purchaseLedgerDto.getBusinessPersonId()); + if (salesLedger == null) { throw new BaseException("閿�鍞彴璐︿笉瀛樺湪"); } + //褰曞叆浜� SysUser sysUser = userMapper.selectUserById(purchaseLedgerDto.getRecorderId()); // DTO杞珽ntity @@ -87,6 +94,9 @@ purchaseLedger.setSalesContractNo(salesLedger.getSalesContractNo()); purchaseLedger.setRecorderId(purchaseLedgerDto.getRecorderId()); purchaseLedger.setRecorderName(sysUser.getNickName()); + purchaseLedger.setBusinessPersonId(purchaseLedgerDto.getBusinessPersonId()); + purchaseLedger.setBusinessPerson(businessPerson.getNickName()); + purchaseLedger.setPhoneNumber(sysUser.getPhonenumber()); // 3. 鏂板鎴栨洿鏂颁富琛� if (purchaseLedger.getId() == null) { @@ -99,7 +109,6 @@ List<SalesLedgerProduct> productList = purchaseLedgerDto.getProductData(); if (productList != null && !productList.isEmpty()) { handleSalesLedgerProducts(purchaseLedger.getId(), productList, purchaseLedgerDto.getType()); - } // 5. 杩佺Щ涓存椂鏂囦欢鍒版寮忕洰褰� @@ -132,6 +141,18 @@ salesLedgerProduct.setType(type); salesLedgerProductMapper.insert(salesLedgerProduct); } + } + + // 璁$畻鎬诲惈绋庨噾棰� + BigDecimal totalTaxInclusiveAmount = products.stream() + .map(SalesLedgerProduct::getTaxInclusiveTotalPrice) + .filter(Objects::nonNull) + .reduce(BigDecimal.ZERO, BigDecimal::add); + + // 鏇存柊涓昏〃鐨勬�婚噾棰濆瓧娈� + if (salesLedgerId != null) { + // 鐩存帴鏇存柊鎸囧畾ID鐨勮褰曠殑contractAmount瀛楁涓簍otalTaxInclusiveAmount + purchaseLedgerMapper.updateContractAmountById(salesLedgerId, totalTaxInclusiveAmount); } } @@ -239,4 +260,66 @@ } return resultDto; } + + @Override + public List getProduct(PurchaseLedgerDto purchaseLedgerDto) { + LambdaQueryWrapper<PurchaseLedger> queryWrapper = Wrappers.lambdaQuery(); + queryWrapper.select(PurchaseLedger::getId, PurchaseLedger::getPurchaseContractNumber); + + // 鑾峰彇鍘熷鏌ヨ缁撴灉 + List<Map<String, Object>> result = purchaseLedgerMapper.selectMaps(queryWrapper); + + // 灏嗕笅鍒掔嚎鍛藉悕杞崲涓洪┘宄板懡鍚� + return result.stream().map(map -> map.entrySet().stream() + .collect(Collectors.toMap( + entry -> underlineToCamel(entry.getKey()), + Map.Entry::getValue)) + ).collect(Collectors.toList()); + } + + @Override + public PurchaseLedgerDto getInfo(PurchaseLedgerDto purchaseLedgerDto) { + PurchaseLedger purchaseLedger = purchaseLedgerMapper.selectById(purchaseLedgerDto.getId()); + if (purchaseLedger == null) { + throw new BaseException("閲囪喘鍙拌处涓嶅瓨鍦�"); + } + // 鍒涘缓骞跺~鍏匘TO + PurchaseLedgerDto resultDto = new PurchaseLedgerDto(); + resultDto.setSalesContractNoId(purchaseLedger.getSalesLedgerId()); + resultDto.setSalesContractNo(purchaseLedger.getSalesContractNo()); + resultDto.setSupplierName(purchaseLedger.getSupplierName()); + resultDto.setProjectName(purchaseLedger.getProjectName()); + resultDto.setBusinessPersonId(purchaseLedger.getBusinessPersonId()); + + // 鏌ヨ骞惰缃叧鑱斾骇鍝� + LambdaQueryWrapper<SalesLedgerProduct> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.eq(SalesLedgerProduct::getSalesLedgerId, purchaseLedger.getId()) + .eq(SalesLedgerProduct::getType, 2); + List<SalesLedgerProduct> productList = salesLedgerProductMapper.selectList(queryWrapper); + resultDto.setProductData(productList); + + return resultDto; + } + + /** + * 涓嬪垝绾垮懡鍚嶈浆椹煎嘲鍛藉悕 + */ + 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