查询所有的散装件信息分页（带上关联的子件信息）

lxw

2022-08-04 0a047f1a368fe24abe254495e96e93665d3b018d

查询所有的散装件信息分页（带上关联的子件信息）

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

@@ -17,7 +17,7 @@
    @Autowired
    private ComponentService service;

    @ApiOperation(value = "查询所有的散装件信息")
    @ApiOperation(value = "查询所有的散装件信息分页（带上关联的子件信息）")
    @GetMapping("getAllComponent")
    public Response getAllComponent(@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllComponent(pageCurr,pageSize);

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

@@ -7,4 +7,6 @@
public interface ComponentMapper extends CustomMapper<Component>{
    //查询所有的散装件信息不分页
    List<Component> getComponentWithoutSub(String parentModel, String subName);
    //查询所有的散装件信息加设置了替换关系的子件信息
    List<Component> getAllComponent();
}

 src/main/java/com/whyc/pojo/Component.java

@@ -7,6 +7,7 @@

import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * 散装件
@@ -51,6 +52,9 @@

    @ApiModelProperty("工程图纸url")
    private String dwgUrl;

    @TableField(exist = false)
    private List<ProductBom> pBoms;

    public Integer getId() {
        return id;
@@ -211,4 +215,12 @@
    public void setStatus(int status) {
        this.status = status;
    }

    public List<ProductBom> getpBoms() {
        return pBoms;
    }

    public void setpBoms(List<ProductBom> pBoms) {
        this.pBoms = pBoms;
    }
}

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

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

 src/main/resources/mapper/ComponentMapper.xml

@@ -4,7 +4,43 @@


    <select id="getComponentWithoutSub" resultType="com.whyc.pojo.Component">
        select * from  db_doc.tb_component  b where (select count(1) as num from  db_doc.tb_component_product  c
                                                     where b.id= c.component_id   and c.sub_name=#{subName} and parent_model=#{parentModel} ) = 0
        select * from  db_doc.tb_component  b
        where (select count(1) as num from  db_doc.tb_component_product  c where b.id= c.component_id   and c.sub_name=#{subName} and parent_model=#{parentModel} ) = 0
        and b.status=1;
    </select>

    <resultMap id="productBomList" type="component">
        <id property="id" column="id"></id>
        <result property="type" column="type"></result>
        <result property="category" column="category"></result>
        <result property="subCode" column="sub_code"></result>
        <result property="subName" column="sub_name"></result>
        <result property="subModel" column="sub_model"></result>
        <result property="unit" column="unit"></result>
        <result property="quantity" column="quantity"></result>
        <result property="producer" column="producer"></result>
        <result property="material" column="material"></result>
        <result property="thickness" column="thickness"></result>
        <result property="surfaceDetail" column="surface_detail"></result>
        <result property="notes" column="notes"></result>
        <result property="pictureUrl" column="picture_url"></result>
        <result property="fileUrl" column="file_url"></result>
        <result property="upUserId" column="up_user_id"></result>
        <result property="createDate" column="create_date"></result>
        <result property="updateDate" column="update_date"></result>
        <result property="dwgUrl" column="dwg_url"></result>
        <collection property="pBoms" javaType="java.util.ArrayList" ofType="com.whyc.pojo.ProductBom" column="{id=id}" select="selectProductBom">
        </collection>
    </resultMap>

    <select id="getAllComponent" resultMap="productBomList">
        select distinct * from  db_doc.tb_component
        where status=1
        order by id asc
    </select>
    <select id="selectProductBom"  resultType="com.whyc.pojo.ProductBom">
        select DISTINCT tb_product_bom.*  FROM db_doc.tb_product_bom,db_doc.tb_component_product
        where tb_product_bom.sub_name=tb_component_product.sub_name
        and tb_product_bom.parent_model=tb_component_product.parent_model and tb_component_product.component_id=#{id}
    </select>
</mapper>