cl
2 天以前 91831843f3b9fa4c9f29e518e10dae5d3f9aead8
rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/MatnrMapper.java
@@ -9,10 +9,8 @@
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;
@@ -22,16 +20,4 @@
    IPage<Map<String, Object>> selectMatnrs(PageParam<Matnr, BaseParam> pages, @Param(Constants.WRAPPER) QueryWrapper<Matnr> matnrQueryWrapper);
    // 未配置 cus-item-sync.datasource.url 时由 CusItemSyncViewQueryService 调用(副库则用 JdbcTemplate)
    @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);
}