云仓模拟视图数据

cl

1 天以前 08ba24466d017583c63540228c8e1f622c579eed

 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);
}