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