From 76640d343082d1473a482e7ba48461db9b26c035 Mon Sep 17 00:00:00 2001
From: chenhj <1263187585@qq.com>
Date: 星期四, 30 四月 2026 17:36:57 +0800
Subject: [PATCH] Merge branch 'dev_New_pro' of http://114.132.189.42:9002/r/product-inventory-management-after into dev_New_pro

---
 src/main/java/com/ruoyi/ai/tools/PurchaseAgentTools.java |  334 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 331 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/ruoyi/ai/tools/PurchaseAgentTools.java b/src/main/java/com/ruoyi/ai/tools/PurchaseAgentTools.java
index 92b739f..17b6868 100644
--- a/src/main/java/com/ruoyi/ai/tools/PurchaseAgentTools.java
+++ b/src/main/java/com/ruoyi/ai/tools/PurchaseAgentTools.java
@@ -13,6 +13,12 @@
 import com.ruoyi.purchase.pojo.PaymentRegistration;
 import com.ruoyi.purchase.pojo.PurchaseLedger;
 import com.ruoyi.purchase.pojo.PurchaseReturnOrders;
+import com.ruoyi.procurementrecord.mapper.InboundManagementMapper;
+import com.ruoyi.procurementrecord.mapper.ProcurementRecordMapper;
+import com.ruoyi.procurementrecord.pojo.InboundManagement;
+import com.ruoyi.procurementrecord.pojo.ProcurementRecordStorage;
+import com.ruoyi.sales.mapper.SalesLedgerProductMapper;
+import com.ruoyi.sales.pojo.SalesLedgerProduct;
 import dev.langchain4j.agent.tool.P;
 import dev.langchain4j.agent.tool.Tool;
 import dev.langchain4j.agent.tool.ToolMemoryId;
@@ -29,6 +35,7 @@
 import java.util.List;
 import java.util.Map;
 import java.util.Objects;
+import java.util.Comparator;
 import java.util.stream.Collectors;
 
 @Component
@@ -42,17 +49,26 @@
     private final PaymentRegistrationMapper paymentRegistrationMapper;
     private final InvoicePurchaseMapper invoicePurchaseMapper;
     private final PurchaseReturnOrdersMapper purchaseReturnOrdersMapper;
+    private final SalesLedgerProductMapper salesLedgerProductMapper;
+    private final ProcurementRecordMapper procurementRecordMapper;
+    private final InboundManagementMapper inboundManagementMapper;
     private final AiSessionUserContext aiSessionUserContext;
 
     public PurchaseAgentTools(PurchaseLedgerMapper purchaseLedgerMapper,
                               PaymentRegistrationMapper paymentRegistrationMapper,
                               InvoicePurchaseMapper invoicePurchaseMapper,
                               PurchaseReturnOrdersMapper purchaseReturnOrdersMapper,
+                              SalesLedgerProductMapper salesLedgerProductMapper,
+                              ProcurementRecordMapper procurementRecordMapper,
+                              InboundManagementMapper inboundManagementMapper,
                               AiSessionUserContext aiSessionUserContext) {
         this.purchaseLedgerMapper = purchaseLedgerMapper;
         this.paymentRegistrationMapper = paymentRegistrationMapper;
         this.invoicePurchaseMapper = invoicePurchaseMapper;
         this.purchaseReturnOrdersMapper = purchaseReturnOrdersMapper;
+        this.salesLedgerProductMapper = salesLedgerProductMapper;
+        this.procurementRecordMapper = procurementRecordMapper;
+        this.inboundManagementMapper = inboundManagementMapper;
         this.aiSessionUserContext = aiSessionUserContext;
     }
 
@@ -78,7 +94,7 @@
             wrapper.ge(PurchaseLedger::getEntryDate, toDate(start));
         }
         if (end != null) {
-            wrapper.le(PurchaseLedger::getEntryDate, toDate(end));
+            wrapper.lt(PurchaseLedger::getEntryDate, toExclusiveEndDate(end));
         }
         wrapper.orderByDesc(PurchaseLedger::getEntryDate, PurchaseLedger::getId).last("limit " + finalLimit);
 
@@ -151,19 +167,290 @@
         return jsonResponse(true, "purchase_stats", "宸茶繑鍥為噰璐粺璁℃暟鎹�", summary, Map.of(), Map.of());
     }
 
+    @Tool(name = "閲囪喘鐗╂枡閲戦鎺掕", value = "鎸夋椂闂磋寖鍥寸粺璁¢噰璐墿鏂欓噾棰濇帓琛岋紝鍙洖绛旀湰鏈堥噰璐噾棰濇帓鍚嶉潬鍓嶇殑鐗╂枡銆�")
+    public String rankPurchaseMaterials(@ToolMemoryId String memoryId,
+                                        @P(value = "寮�濮嬫棩鏈� yyyy-MM-dd", required = false) String startDate,
+                                        @P(value = "缁撴潫鏃ユ湡 yyyy-MM-dd", required = false) String endDate,
+                                        @P(value = "鏃堕棿鑼冨洿鎻忚堪锛屼緥濡傛湰鏈堛�佽繎7澶┿�佽繎30澶�", required = false) String timeRange,
+                                        @P(value = "杩斿洖鏉℃暟锛岄粯璁�10锛屾渶澶�30", required = false) Integer limit) {
+        LoginUser loginUser = currentLoginUser(memoryId);
+        DateRange range = resolveDateRange(startDate, endDate, timeRange);
+        List<Long> ledgerIds = queryLedgers(loginUser, range).stream()
+                .map(PurchaseLedger::getId)
+                .filter(Objects::nonNull)
+                .collect(Collectors.toList());
+        if (ledgerIds.isEmpty()) {
+            return jsonResponse(true, "purchase_material_rank", "褰撳墠鏃堕棿鑼冨洿鍐呮病鏈夐噰璐墿鏂欐暟鎹��",
+                    rangeSummary(range, 0), Map.of("items", List.of()), Map.of());
+        }
+
+        List<SalesLedgerProduct> products = defaultList(salesLedgerProductMapper.selectList(new LambdaQueryWrapper<SalesLedgerProduct>()
+                .eq(SalesLedgerProduct::getType, 2)
+                .in(SalesLedgerProduct::getSalesLedgerId, ledgerIds)));
+
+        Map<String, MaterialRankItem> grouped = new LinkedHashMap<>();
+        for (SalesLedgerProduct product : products) {
+            String name = safe(product.getProductCategory());
+            String model = safe(product.getSpecificationModel());
+            String key = name + "|" + model;
+            MaterialRankItem item = grouped.computeIfAbsent(key, ignored -> new MaterialRankItem(name, model, safe(product.getUnit())));
+            item.quantity = item.quantity.add(defaultDecimal(product.getQuantity()));
+            item.amount = item.amount.add(defaultDecimal(product.getTaxInclusiveTotalPrice()));
+        }
+
+        List<Map<String, Object>> items = grouped.values().stream()
+                .sorted(Comparator.comparing((MaterialRankItem item) -> item.amount).reversed())
+                .limit(normalizeLimit(limit))
+                .map(MaterialRankItem::toMap)
+                .collect(Collectors.toList());
+
+        return jsonResponse(true, "purchase_material_rank", "宸茶繑鍥為噰璐墿鏂欓噾棰濇帓琛屻��",
+                rangeSummary(range, items.size()), Map.of("items", items), Map.of());
+    }
+
+    @Tool(name = "鏌ヨ鏈叆搴撻噰璐鍗�", value = "鏌ヨ閲囪喘璁㈠崟涓嬩粛鏈夊緟鍏ュ簱鏁伴噺鐨勭墿鏂欐槑缁嗐��")
+    public String listUnstockedPurchaseOrders(@ToolMemoryId String memoryId,
+                                              @P(value = "寮�濮嬫棩鏈� yyyy-MM-dd", required = false) String startDate,
+                                              @P(value = "缁撴潫鏃ユ湡 yyyy-MM-dd", required = false) String endDate,
+                                              @P(value = "鍏抽敭瀛楋紝鍙尮閰嶉噰璐悎鍚屽彿/渚涘簲鍟�/鐗╂枡", required = false) String keyword,
+                                              @P(value = "杩斿洖鏉℃暟锛岄粯璁�10锛屾渶澶�30", required = false) Integer limit) {
+        LoginUser loginUser = currentLoginUser(memoryId);
+        DateRange range = resolveDateRange(startDate, endDate, null);
+        List<PurchaseLedger> ledgers = queryLedgers(loginUser, range).stream()
+                .filter(ledger -> matchLedgerKeyword(ledger, keyword))
+                .collect(Collectors.toList());
+        Map<Long, PurchaseLedger> ledgerMap = ledgers.stream()
+                .filter(ledger -> ledger.getId() != null)
+                .collect(Collectors.toMap(PurchaseLedger::getId, ledger -> ledger, (a, b) -> a, LinkedHashMap::new));
+        if (ledgerMap.isEmpty()) {
+            return jsonResponse(true, "purchase_unstocked_list", "鏈煡璇㈠埌绗﹀悎鏉′欢鐨勯噰璐鍗曘��",
+                    rangeSummary(range, 0), Map.of("items", List.of()), Map.of());
+        }
+
+        List<SalesLedgerProduct> products = defaultList(salesLedgerProductMapper.selectList(new LambdaQueryWrapper<SalesLedgerProduct>()
+                .eq(SalesLedgerProduct::getType, 2)
+                .in(SalesLedgerProduct::getSalesLedgerId, ledgerMap.keySet())));
+
+        List<Map<String, Object>> items = products.stream()
+                .filter(product -> matchProductKeyword(product, keyword))
+                .map(product -> toUnstockedItem(product, ledgerMap.get(product.getSalesLedgerId())))
+                .filter(Objects::nonNull)
+                .limit(normalizeLimit(limit))
+                .collect(Collectors.toList());
+
+        return jsonResponse(true, "purchase_unstocked_list", "宸茶繑鍥炴湭鍏ュ簱閲囪喘璁㈠崟銆�",
+                rangeSummary(range, items.size()), Map.of("items", items), Map.of());
+    }
+
+    @Tool(name = "鏌ヨ閲囪喘鍒拌揣寮傚父", value = "鏌ヨ鍒拌揣鐘舵�佸紓甯告垨澶囨敞鍖呭惈寮傚父淇℃伅鐨勫埌璐ц褰曘��")
+    public String listArrivalExceptions(@ToolMemoryId String memoryId,
+                                        @P(value = "寮�濮嬫棩鏈� yyyy-MM-dd", required = false) String startDate,
+                                        @P(value = "缁撴潫鏃ユ湡 yyyy-MM-dd", required = false) String endDate,
+                                        @P(value = "鏃堕棿鑼冨洿鎻忚堪锛屼緥濡傝繎7澶┿�佹湰鏈�", required = false) String timeRange,
+                                        @P(value = "杩斿洖鏉℃暟锛岄粯璁�10锛屾渶澶�30", required = false) Integer limit) {
+        LoginUser loginUser = currentLoginUser(memoryId);
+        DateRange range = resolveDateRange(startDate, endDate, timeRange);
+        LambdaQueryWrapper<InboundManagement> wrapper = new LambdaQueryWrapper<>();
+        applyTenantFilter(wrapper, loginUser.getTenantId(), InboundManagement::getTenantId);
+        wrapper.ge(InboundManagement::getArrivalTime, toDate(range.start()))
+                .lt(InboundManagement::getArrivalTime, toExclusiveEndDate(range.end()))
+                .and(w -> w.notLike(InboundManagement::getStatus, "姝e父")
+                        .notLike(InboundManagement::getStatus, "瀹屾垚")
+                        .notLike(InboundManagement::getStatus, "宸插埌璐�")
+                        .or().like(InboundManagement::getStatus, "寮傚父")
+                        .or().like(InboundManagement::getRemark, "寮傚父")
+                        .or().like(InboundManagement::getRemark, "闂")
+                        .or().like(InboundManagement::getRemark, "寤惰繜")
+                        .or().like(InboundManagement::getRemark, "鐭己"));
+        wrapper.orderByDesc(InboundManagement::getArrivalTime).last("limit " + normalizeLimit(limit));
+
+        List<Map<String, Object>> items = defaultList(inboundManagementMapper.selectList(wrapper)).stream()
+                .map(this::toArrivalItem)
+                .collect(Collectors.toList());
+        return jsonResponse(true, "purchase_arrival_exception_list", "宸茶繑鍥為噰璐埌璐у紓甯歌褰曘��",
+                rangeSummary(range, items.size()), Map.of("items", items), Map.of());
+    }
+
+    @Tool(name = "鏌ヨ寰呬粯娆鹃噰璐崟", value = "鏌ヨ鍚堝悓閲戦澶т簬宸蹭粯娆鹃噾棰濈殑閲囪喘鍗曘��")
+    public String listPendingPaymentOrders(@ToolMemoryId String memoryId,
+                                           @P(value = "寮�濮嬫棩鏈� yyyy-MM-dd", required = false) String startDate,
+                                           @P(value = "缁撴潫鏃ユ湡 yyyy-MM-dd", required = false) String endDate,
+                                           @P(value = "鍏抽敭瀛楋紝鍙尮閰嶉噰璐悎鍚屽彿/渚涘簲鍟�/椤圭洰鍚�", required = false) String keyword,
+                                           @P(value = "杩斿洖鏉℃暟锛岄粯璁�10锛屾渶澶�30", required = false) Integer limit) {
+        LoginUser loginUser = currentLoginUser(memoryId);
+        DateRange range = resolveDateRange(startDate, endDate, null);
+        List<Map<String, Object>> items = queryLedgers(loginUser, range).stream()
+                .filter(ledger -> matchLedgerKeyword(ledger, keyword))
+                .map(ledger -> toPendingPaymentItem(loginUser, ledger))
+                .filter(Objects::nonNull)
+                .sorted(Comparator.comparing(item -> (BigDecimal) item.get("pendingAmount"), Comparator.reverseOrder()))
+                .limit(normalizeLimit(limit))
+                .collect(Collectors.toList());
+        return jsonResponse(true, "purchase_pending_payment_list", "宸茶繑鍥炲緟浠樻閲囪喘鍗曘��",
+                rangeSummary(range, items.size()), Map.of("items", items), Map.of());
+    }
+
+    @Tool(name = "鏌ヨ閲囪喘閫�璐ф儏鍐�", value = "鎸夋椂闂磋寖鍥存煡璇㈤噰璐��璐у崟鍒楄〃鍜岄��璐ч噾棰濄��")
+    public String listPurchaseReturns(@ToolMemoryId String memoryId,
+                                      @P(value = "寮�濮嬫棩鏈� yyyy-MM-dd", required = false) String startDate,
+                                      @P(value = "缁撴潫鏃ユ湡 yyyy-MM-dd", required = false) String endDate,
+                                      @P(value = "鍏抽敭瀛楋紝鍙尮閰嶉��璐у崟鍙�/澶囨敞", required = false) String keyword,
+                                      @P(value = "杩斿洖鏉℃暟锛岄粯璁�10锛屾渶澶�30", required = false) Integer limit) {
+        LoginUser loginUser = currentLoginUser(memoryId);
+        DateRange range = resolveDateRange(startDate, endDate, null);
+        LambdaQueryWrapper<PurchaseReturnOrders> wrapper = new LambdaQueryWrapper<>();
+        applyDeptFilter(wrapper, loginUser.getCurrentDeptId(), PurchaseReturnOrders::getDeptId);
+        wrapper.ge(PurchaseReturnOrders::getPreparedAt, range.start())
+                .le(PurchaseReturnOrders::getPreparedAt, range.end());
+        if (StringUtils.hasText(keyword)) {
+            wrapper.and(w -> w.like(PurchaseReturnOrders::getNo, keyword)
+                    .or().like(PurchaseReturnOrders::getRemark, keyword)
+                    .or().like(PurchaseReturnOrders::getReturnUserName, keyword));
+        }
+        wrapper.orderByDesc(PurchaseReturnOrders::getPreparedAt).last("limit " + normalizeLimit(limit));
+
+        List<PurchaseReturnOrders> returns = defaultList(purchaseReturnOrdersMapper.selectList(wrapper));
+        BigDecimal totalAmount = returns.stream()
+                .map(PurchaseReturnOrders::getTotalAmount)
+                .filter(Objects::nonNull)
+                .reduce(BigDecimal.ZERO, BigDecimal::add);
+        Map<String, Object> summary = rangeSummary(range, returns.size());
+        summary.put("returnAmount", totalAmount);
+
+        return jsonResponse(true, "purchase_return_list", "宸茶繑鍥為噰璐��璐ф儏鍐点��",
+                summary,
+                Map.of("items", returns.stream().map(this::toReturnItem).collect(Collectors.toList())),
+                Map.of());
+    }
+
     private List<PurchaseLedger> queryLedgers(LoginUser loginUser, DateRange range) {
         LambdaQueryWrapper<PurchaseLedger> wrapper = new LambdaQueryWrapper<>();
         applyTenantFilter(wrapper, loginUser.getTenantId(), PurchaseLedger::getTenantId);
         wrapper.ge(PurchaseLedger::getEntryDate, toDate(range.start()))
-                .le(PurchaseLedger::getEntryDate, toDate(range.end()));
+                .lt(PurchaseLedger::getEntryDate, toExclusiveEndDate(range.end()));
         return defaultList(purchaseLedgerMapper.selectList(wrapper));
+    }
+
+    private Map<String, Object> rangeSummary(DateRange range, int count) {
+        Map<String, Object> summary = new LinkedHashMap<>();
+        summary.put("timeRange", range.label());
+        summary.put("startDate", range.start().toString());
+        summary.put("endDate", range.end().toString());
+        summary.put("count", count);
+        return summary;
+    }
+
+    private boolean matchLedgerKeyword(PurchaseLedger ledger, String keyword) {
+        if (!StringUtils.hasText(keyword)) {
+            return true;
+        }
+        String text = keyword.trim();
+        return safe(ledger.getPurchaseContractNumber()).contains(text)
+                || safe(ledger.getSupplierName()).contains(text)
+                || safe(ledger.getProjectName()).contains(text);
+    }
+
+    private boolean matchProductKeyword(SalesLedgerProduct product, String keyword) {
+        if (!StringUtils.hasText(keyword)) {
+            return true;
+        }
+        String text = keyword.trim();
+        return safe(product.getProductCategory()).contains(text)
+                || safe(product.getSpecificationModel()).contains(text);
+    }
+
+    private Map<String, Object> toUnstockedItem(SalesLedgerProduct product, PurchaseLedger ledger) {
+        if (product == null || ledger == null || product.getId() == null) {
+            return null;
+        }
+        BigDecimal orderedQuantity = defaultDecimal(product.getQuantity());
+        BigDecimal inboundQuantity = sumInboundQuantity(product.getId());
+        BigDecimal pendingQuantity = orderedQuantity.subtract(inboundQuantity);
+        if (pendingQuantity.compareTo(BigDecimal.ZERO) <= 0) {
+            return null;
+        }
+        Map<String, Object> item = new LinkedHashMap<>();
+        item.put("purchaseLedgerId", ledger.getId());
+        item.put("purchaseContractNumber", safe(ledger.getPurchaseContractNumber()));
+        item.put("supplierName", safe(ledger.getSupplierName()));
+        item.put("productCategory", safe(product.getProductCategory()));
+        item.put("specificationModel", safe(product.getSpecificationModel()));
+        item.put("unit", safe(product.getUnit()));
+        item.put("orderedQuantity", orderedQuantity);
+        item.put("inboundQuantity", inboundQuantity);
+        item.put("pendingInboundQuantity", pendingQuantity);
+        item.put("entryDate", formatDate(ledger.getEntryDate()));
+        return item;
+    }
+
+    private BigDecimal sumInboundQuantity(Long salesLedgerProductId) {
+        List<ProcurementRecordStorage> records = defaultList(procurementRecordMapper.selectList(new LambdaQueryWrapper<ProcurementRecordStorage>()
+                .eq(ProcurementRecordStorage::getType, 1)
+                .eq(ProcurementRecordStorage::getSalesLedgerProductId, salesLedgerProductId)));
+        return records.stream()
+                .map(ProcurementRecordStorage::getInboundNum)
+                .filter(Objects::nonNull)
+                .reduce(BigDecimal.ZERO, BigDecimal::add);
+    }
+
+    private Map<String, Object> toArrivalItem(InboundManagement item) {
+        Map<String, Object> map = new LinkedHashMap<>();
+        map.put("id", item.getId());
+        map.put("orderNo", safe(item.getOrderNo()));
+        map.put("arrivalNo", safe(item.getArrivalNo()));
+        map.put("supplierName", safe(item.getSupplierName()));
+        map.put("status", safe(item.getStatus()));
+        map.put("arrivalTime", formatDate(item.getArrivalTime()));
+        map.put("arrivalQuantity", safe(item.getArrivalQuantity()));
+        map.put("remark", safe(item.getRemark()));
+        return map;
+    }
+
+    private Map<String, Object> toPendingPaymentItem(LoginUser loginUser, PurchaseLedger ledger) {
+        BigDecimal contractAmount = defaultDecimal(ledger.getContractAmount());
+        BigDecimal paidAmount = sumPaymentAmount(loginUser, ledger.getId());
+        BigDecimal pendingAmount = contractAmount.subtract(paidAmount);
+        if (pendingAmount.compareTo(BigDecimal.ZERO) <= 0) {
+            return null;
+        }
+        Map<String, Object> item = toLedgerItem(ledger);
+        item.put("paidAmount", paidAmount);
+        item.put("pendingAmount", pendingAmount);
+        return item;
+    }
+
+    private BigDecimal sumPaymentAmount(LoginUser loginUser, Long purchaseLedgerId) {
+        LambdaQueryWrapper<PaymentRegistration> wrapper = new LambdaQueryWrapper<>();
+        applyTenantFilter(wrapper, loginUser.getTenantId(), PaymentRegistration::getTenantId);
+        wrapper.eq(PaymentRegistration::getPurchaseLedgerId, purchaseLedgerId);
+        return defaultList(paymentRegistrationMapper.selectList(wrapper)).stream()
+                .map(PaymentRegistration::getCurrentPaymentAmount)
+                .filter(Objects::nonNull)
+                .reduce(BigDecimal.ZERO, BigDecimal::add);
+    }
+
+    private Map<String, Object> toReturnItem(PurchaseReturnOrders item) {
+        Map<String, Object> map = new LinkedHashMap<>();
+        map.put("id", item.getId());
+        map.put("no", safe(item.getNo()));
+        map.put("returnType", item.getReturnType());
+        map.put("purchaseLedgerId", item.getPurchaseLedgerId());
+        map.put("preparedAt", item.getPreparedAt() == null ? "" : item.getPreparedAt().toString());
+        map.put("returnUserName", safe(item.getReturnUserName()));
+        map.put("totalAmount", item.getTotalAmount());
+        map.put("remark", safe(item.getRemark()));
+        return map;
+    }
+
+    private BigDecimal defaultDecimal(BigDecimal value) {
+        return value == null ? BigDecimal.ZERO : value;
     }
 
     private List<PaymentRegistration> queryPayments(LoginUser loginUser, DateRange range) {
         LambdaQueryWrapper<PaymentRegistration> wrapper = new LambdaQueryWrapper<>();
         applyTenantFilter(wrapper, loginUser.getTenantId(), PaymentRegistration::getTenantId);
         wrapper.ge(PaymentRegistration::getPaymentDate, toDate(range.start()))
-                .le(PaymentRegistration::getPaymentDate, toDate(range.end()));
+                .lt(PaymentRegistration::getPaymentDate, toExclusiveEndDate(range.end()));
         return defaultList(paymentRegistrationMapper.selectList(wrapper));
     }
 
@@ -231,6 +518,19 @@
         if (text.contains("杩戝崐涓湀") || text.contains("鏈�杩戝崐涓湀") || text.contains("鍗婁釜鏈�")) {
             return new DateRange(today.minusDays(14), today, "杩戝崐涓湀");
         }
+        java.util.regex.Matcher relativeMatcher = java.util.regex.Pattern.compile("(杩憒鏈�杩�)(\\d+)(澶﹟鍛▅涓湀|鏈坾骞�)").matcher(text);
+        if (relativeMatcher.find()) {
+            int amount = Integer.parseInt(relativeMatcher.group(2));
+            String unit = relativeMatcher.group(3);
+            LocalDate relativeStart = switch (unit) {
+                case "澶�" -> today.minusDays(Math.max(amount - 1L, 0));
+                case "鍛�" -> today.minusWeeks(Math.max(amount, 1)).plusDays(1);
+                case "涓湀", "鏈�" -> today.minusMonths(Math.max(amount, 1)).plusDays(1);
+                case "骞�" -> today.minusYears(Math.max(amount, 1)).plusDays(1);
+                default -> today.minusDays(29);
+            };
+            return new DateRange(relativeStart, today, "杩�" + amount + unit);
+        }
         return new DateRange(today.minusDays(29), today, "杩�30澶�");
     }
 
@@ -243,6 +543,10 @@
 
     private Date toDate(LocalDate localDate) {
         return Date.from(localDate.atStartOfDay(ZoneId.systemDefault()).toInstant());
+    }
+
+    private Date toExclusiveEndDate(LocalDate localDate) {
+        return Date.from(localDate.plusDays(1).atStartOfDay(ZoneId.systemDefault()).toInstant());
     }
 
     private String formatDate(Date date) {
@@ -312,4 +616,28 @@
 
     private record DateRange(LocalDate start, LocalDate end, String label) {
     }
+
+    private static class MaterialRankItem {
+        private final String productCategory;
+        private final String specificationModel;
+        private final String unit;
+        private BigDecimal quantity = BigDecimal.ZERO;
+        private BigDecimal amount = BigDecimal.ZERO;
+
+        private MaterialRankItem(String productCategory, String specificationModel, String unit) {
+            this.productCategory = productCategory;
+            this.specificationModel = specificationModel;
+            this.unit = unit;
+        }
+
+        private Map<String, Object> toMap() {
+            Map<String, Object> map = new LinkedHashMap<>();
+            map.put("productCategory", productCategory);
+            map.put("specificationModel", specificationModel);
+            map.put("unit", unit);
+            map.put("quantity", quantity);
+            map.put("amount", amount);
+            return map;
+        }
+    }
 }

--
Gitblit v1.9.3