根据母料型号查询子件信息及有关联的散装件信息

lxw

2022-08-03 f7bd9703449afd6115074d1a64fcdfabc7a2c2f8

根据母料型号查询子件信息及有关联的散装件信息

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

@@ -62,6 +62,12 @@
        return service.getAllBom();
    }

    @ApiOperation(tags = "产品管理",value = "根据母料型号查询子件信息及有关联的散装件信息")
    @GetMapping("getSubByComponentProduct")
    public Response getSubByComponentProduct(@RequestParam String parentModel){
        return service.getSubByComponentProduct(parentModel);
    }

    @ApiOperation(tags = "产品管理",value = "产品打包下载")
    @GetMapping("downloadBom")
    public void downloadBom(HttpServletRequest req, HttpServletResponse resp,@RequestParam String parentModel){

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

@@ -13,4 +13,7 @@

    //查询所有产品中没有与指定散装件关联的子件
    List<ProductBom> getAllSubWithOutComponent(int componentId);

    //根据母料型号查询子件信息及有关联的散装件信息
    List<ProductBom> getSubByComponentProduct(String parentModel);
}

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

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

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

/**
 * 产品bom表
@@ -65,6 +66,9 @@

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

    @TableField(exist = false)
    private List<Component> components;

    public Integer getId() {
        return id;
@@ -265,4 +269,12 @@
    public void setUpUser(String upUser) {
        this.upUser = upUser;
    }

    public List<Component> getComponents() {
        return components;
    }

    public void setComponents(List<Component> components) {
        this.components = components;
    }
}

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

@@ -359,4 +359,9 @@
        List<ProductBom> list=mapper.getAllSubWithOutComponent(componentId);
        return new Response().setII(1,list.size()>0?true:false,list,"返回数据");
    }
    //根据母料型号查询子件信息及有关联的散装件信息
    public Response getSubByComponentProduct(String parentModel) {
        List<ProductBom> list=mapper.getSubByComponentProduct(parentModel);
        return new Response().setII(1,list.size()>0?true:false,list,"返回数据");
    }
}

 src/main/resources/mapper/ProductBomMapper.xml

@@ -57,4 +57,46 @@
        select * from  db_doc.tb_product_bom  b where (select count(1) as num from  db_doc.tb_component_product  c
         where b.parent_model= c.parent_model  and b.sub_name= c.sub_name and c.component_id=#{componentId} ) = 0
    </select>

    <resultMap id="componentList" type="productBom">
        <id property="id" column="id"></id>
        <result property="parentCode" column="parent_code"></result>
        <result property="parentName" column="parent_name"></result>
        <result property="parentModel" column="parent_model"></result>
        <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="version" column="version"></result>
        <result property="dwgUrl" column="dwg_url"></result>
        <result property="parentVersion" column="parent_version"></result>
        <collection property="components" javaType="java.util.ArrayList" ofType="com.whyc.pojo.Component" column="{subName=sub_name,parentModel=parent_model}" select="selectComponent">
        </collection>
    </resultMap>

    <select id="getSubByComponentProduct" resultMap="componentList" parameterType="java.lang.String">
        select distinct * from  db_doc.tb_product_bom
        <where>
            parent_model = #{parentModel}
        </where>
        order by id asc
    </select>

    <select id="selectComponent"  resultType="com.whyc.pojo.Component">
        select DISTINCT tb_component.*  FROM db_doc.tb_component,db_doc.tb_component_product where tb_component.id=tb_component_product.component_id
        and tb_component_product.sub_name=#{subName} and tb_component_product.parent_model=#{parentModel}
    </select>
</mapper>