From 9fcff4b02fcbb777fc68b1b721d20db96ef10205 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期五, 22 五月 2026 15:19:09 +0800
Subject: [PATCH] fix(stock): 修复库存查询中多余的字符导致SQL语法错误

---
 src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java |    7 ++-----
 1 files changed, 2 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
index e651217..7de2682 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
@@ -42,10 +42,7 @@
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Map;
-import java.util.Objects;
+import java.util.*;
 import java.util.stream.Collectors;
 
 import static cn.hutool.core.date.LocalDateTimeUtil.between;
@@ -393,7 +390,7 @@
                         SalesLedgerProductionAccounting salesLedgerProductionAccounting = SalesLedgerProductionAccounting.builder()
                                 .productMainId(productionProductMain.getId())
                                 .schedulingUserId(Long.parseLong(s))
-                                .schedulingUserName(userMapper.selectUserById(Long.parseLong(s)).getNickName())
+                                .schedulingUserName(Optional.of(userMapper.selectUserById(Long.parseLong(s))).orElse(new SysUser()).getNickName())
                                 .finishedNum(productQty)
                                 .workHours(workHours)
                                 .process(productProcess.getName())

--
Gitblit v1.9.3