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 | 24 ++++++++++++++++++++++++
1 files changed, 24 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 72b237c..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
@@ -1,12 +1,36 @@
package com.vincent.rsf.server.manager.mapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.vincent.rsf.server.common.domain.BaseParam;
+import com.vincent.rsf.server.common.domain.PageParam;
import com.vincent.rsf.server.manager.entity.Matnr;
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
@Repository
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