查询所有的散装件信息分页模糊查询带上类别

lxw

2022-08-13 0afaddafcf5c6709754fd6366f423c0b12ad0b36

查询所有的散装件信息分页模糊查询带上类别

 src/main/java/com/whyc/controller/ComponentController.java

@@ -19,8 +19,8 @@

    @ApiOperation(value = "查询所有的散装件信息分页（带上关联的子件信息，status状态不做处理)）")
    @GetMapping("getAllComponent")
    public Response getAllComponent(@RequestParam(required = false) String subCode,@RequestParam(required = false) String subName, @RequestParam(required = false) String subModel,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllComponent(subCode,subName,subModel,pageCurr,pageSize);
    public Response getAllComponent(@RequestParam(required = false) String category,@RequestParam(required = false) String subCode,@RequestParam(required = false) String subName, @RequestParam(required = false) String subModel,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllComponent(category,subCode,subName,subModel,pageCurr,pageSize);
    }
    @ApiOperation(tags = "产品管理",value = "查询所有的散装件信息不分页(不包含被最新版本关联的散装件，status=1可用)")
    @GetMapping("getComponentWithoutSub")

 src/main/java/com/whyc/mapper/ComponentMapper.java

@@ -10,7 +10,7 @@
    //查询所有的散装件信息不分页
    List<Component> getComponentWithoutSub(String parentModel, String subName,int version);
    //查询所有的散装件信息加设置了替换关系的子件信息
    List<Component> getAllComponent(String subCode,String subName,String subModel);
    List<Component> getAllComponent(String category,String subCode,String subName,String subModel);
    //查询出存在替换关系得散装件
    List<ProductBom> getReplaceComponent(String parentModel);
    //历史版本下载查询出存在替换关系得散装件

 src/main/java/com/whyc/service/ComponentService.java

@@ -18,12 +18,12 @@
    @Autowired(required = false)
    private ComponentMapper mapper;
    //查询所有的散装件信息加设置了替换关系的子件信息
    public Response getAllComponent(String subCode,String subName,String subModel,int pageCurr,int pageSize) {
    public Response getAllComponent(String category,String subCode,String subName,String subModel,int pageCurr,int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        /*QueryWrapper wrapper=new QueryWrapper();
        wrapper.orderByAsc("id");
        List<Component> list=mapper.selectList(wrapper);*/
        List<Component> list=mapper.getAllComponent(subCode,subName,subModel);
        List<Component> list=mapper.getAllComponent(category,subCode,subName,subModel);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回所有的散装件");
    }

 src/main/resources/mapper/ComponentMapper.xml

@@ -40,6 +40,9 @@
        select distinct * from  db_doc.tb_component
        <where>
        1=1
            <if test="category!=null&amp;&amp;category!=''">
                and category like '%${category}%'
            </if>
            <if test="subCode!=null&amp;&amp;subCode!=''">
                and sub_code like '%${subCode}%'
            </if>