| | |
| | | @Excel(name = "物料编码") |
| | | private String materialCode; |
| | | |
| | | @ApiModelProperty(value = "产品ID") |
| | | private Long productId; |
| | | |
| | | @ApiModelProperty(value = "工艺路线编号") |
| | | @Excel(name = "工艺路线编号") |
| | | private String processRouteCode; |
| | |
| | | pb.bom_no AS bomNo, |
| | | ROUND(po.complete_quantity / po.quantity * 100, 2) AS completionStatus, |
| | | pms.model, |
| | | pms.material_code AS materialCode |
| | | pms.material_code AS materialCode, |
| | | pms.id AS productId |
| | | FROM product_order po |
| | | LEFT JOIN process_route pr ON po.route_id = pr.id |
| | | LEFT JOIN product_bom pb ON pr.bom_id = pb.id |