From 5936c125b47d34ed1bb85bd0ddba4cb4052c865f Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期五, 17 四月 2026 15:24:12 +0800
Subject: [PATCH] 视图兼容
---
rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java | 91 +++++++++++++++++++++++++++++++++++++++++----
1 files changed, 83 insertions(+), 8 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java
index 3c5c591..92b0464 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java
@@ -136,6 +136,8 @@
private OutStockService outStockService;
@Autowired
private BasContainerService basContainerService;
+ @Autowired
+ private CusItemSyncViewQueryService cusItemSyncViewQueryService;
/**
* @return
@@ -600,10 +602,11 @@
logger.info("=== 浠庣墿鏂欎俊鎭〃鏌ヨ鐗╂枡淇℃伅锛堜笉鏌ヨ鏀惰揣鍖猴級 ===");
logger.info("鏌ヨ鍙傛暟 - matnrCode: {}", matnrCode);
- Matnr matnr = matnrMapper.selectOne(new LambdaQueryWrapper<Matnr>()
- .eq(Matnr::getCode, matnrCode)
- .eq(Matnr::getDeleted, 0)
- .last("LIMIT 1"));
+ // Matnr matnr = matnrMapper.selectOne(new LambdaQueryWrapper<Matnr>()
+ // .eq(Matnr::getCode, matnrCode)
+ // .eq(Matnr::getDeleted, 0)
+ // .last("LIMIT 1"));
+ Matnr matnr = getMatnrByCodePreferView(matnrCode);
if (matnr == null) {
logger.warn("鐗╂枡淇℃伅琛ㄤ腑鏈壘鍒扮墿鏂欑紪鐮�: {}", matnrCode);
@@ -831,10 +834,11 @@
if (!matnrCodes.isEmpty()) {
Map<String, Matnr> matnrMap = new HashMap<>();
for (String matCode : matnrCodes) {
- Matnr matnr = matnrMapper.selectOne(new LambdaQueryWrapper<Matnr>()
- .eq(Matnr::getCode, matCode)
- .eq(Matnr::getDeleted, 0)
- .last("LIMIT 1"));
+ // Matnr matnr = matnrMapper.selectOne(new LambdaQueryWrapper<Matnr>()
+ // .eq(Matnr::getCode, matCode)
+ // .eq(Matnr::getDeleted, 0)
+ // .last("LIMIT 1"));
+ Matnr matnr = getMatnrByCodePreferView(matCode);
if (matnr != null) {
matnrMap.put(matCode, matnr);
}
@@ -873,6 +877,77 @@
return R.ok(list);
}
+ /** 缁勬墭鎵墿鏂欎紭鍏堟煡瑙嗗浘锛屽懡涓悗鍚屾鏈湴鐗╂枡 */
+ private Matnr getMatnrByCodePreferView(String matnrCode) {
+ String code = StringUtils.trimToNull(matnrCode);
+ if (code == null) {
+ return null;
+ }
+ List<Map<String, Object>> viewItems = null;
+ try {
+ viewItems = cusItemSyncViewQueryService.listByItemNos(Collections.singletonList(code));
+ } catch (Exception ignore) {
+ }
+ Map<String, Object> row = null;
+ if (viewItems != null) {
+ row = viewItems.stream()
+ .filter(v -> StringUtils.equals(code, StringUtils.trimToNull(Objects.toString(v.get("item_no"), null))))
+ .findFirst()
+ .orElse(null);
+ }
+ Matnr local = matnrMapper.selectOne(new LambdaQueryWrapper<Matnr>()
+ .eq(Matnr::getCode, code)
+ .eq(Matnr::getDeleted, 0)
+ .last("LIMIT 1"));
+ if (row == null) {
+ return local;
+ }
+ String viewSpec = StringUtils.trimToEmpty(Objects.toString(row.get("item_spec"), ""));
+ String viewUnit = StringUtils.trimToNull(Objects.toString(row.get("unit_no"), null));
+ if (local == null) {
+ Matnr matnr = new Matnr();
+ matnr.setCode(code)
+ .setBatch("")
+ .setName(code)
+ .setSpec(viewSpec)
+ .setUnit(viewUnit)
+ .setStockUnit(viewUnit)
+ .setStatus(1)
+ .setDeleted(0)
+ .setCreateBy(1L)
+ .setUpdateBy(1L)
+ .setCreateTime(new Date())
+ .setUpdateTime(new Date());
+ if (matnrMapper.insert(matnr) <= 0) {
+ throw new CoolException("鐗╂枡淇℃伅淇濆瓨澶辫触");
+ }
+ return matnr;
+ }
+ boolean specDiff = !StringUtils.equals(StringUtils.trimToEmpty(local.getSpec()), viewSpec);
+ boolean unitDiff = viewUnit != null
+ && (!StringUtils.equals(StringUtils.trimToEmpty(local.getUnit()), viewUnit)
+ || !StringUtils.equals(StringUtils.trimToEmpty(local.getStockUnit()), viewUnit));
+ if (specDiff || unitDiff) {
+ Matnr update = new Matnr();
+ update.setId(local.getId());
+ if (specDiff) {
+ update.setSpec(viewSpec);
+ local.setSpec(viewSpec);
+ }
+ if (unitDiff) {
+ update.setUnit(viewUnit);
+ update.setStockUnit(viewUnit);
+ local.setUnit(viewUnit);
+ local.setStockUnit(viewUnit);
+ }
+ update.setUpdateBy(1L).setUpdateTime(new Date());
+ if (matnrMapper.updateById(update) <= 0) {
+ throw new CoolException("鐗╂枡淇℃伅鏇存柊澶辫触");
+ }
+ }
+ return local;
+ }
+
/**
* @param
* @param userId
--
Gitblit v1.9.1