From 0e85601e2f80b6cb580c0fad9be9518f58c5882c Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期二, 14 四月 2026 22:19:27 +0800
Subject: [PATCH] 云仓模拟视图数据sql
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java
index bfc59f1..4c8a435 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java
@@ -9,8 +9,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
+import java.util.Collection;
+import java.util.List;
import java.util.Map;
@Mapper
@@ -18,4 +21,16 @@
public interface MatnrMapper extends BaseMapper<Matnr> {
IPage<Map<String, Object>> selectMatnrs(PageParam<Matnr, BaseParam> pages, @Param(Constants.WRAPPER) QueryWrapper<Matnr> matnrQueryWrapper);
+
+ @Select({
+ "<script>",
+ "SELECT item_no, item_spec, unit_no",
+ "FROM cus_item_sync_view",
+ "WHERE item_no IN",
+ "<foreach collection='itemNos' item='itemNo' open='(' separator=',' close=')'>",
+ "#{itemNo}",
+ "</foreach>",
+ "</script>"
+ })
+ List<Map<String, Object>> selectByCusItemSyncView(@Param("itemNos") Collection<String> itemNos);
}
--
Gitblit v1.9.1