| | |
| | | @ApiModelProperty(value = "工艺路线名称") |
| | | private String routeName; |
| | | |
| | | @ApiModelProperty(value = "产品名称") |
| | | @ApiModelProperty(value = "生产炒机") |
| | | private String speculativeTradingName; |
| | | |
| | | @ApiModelProperty(value = "产品名称") |
| | | private String productName; |
| | | |
| | | @ApiModelProperty(value = "单位") |
| | | private String unit; |
| | | |
| | | private Long productId; |
| | | |
| | | |
| | |
| | | pm.speculative_trading_name, |
| | | pm.product_id, |
| | | pm.model, |
| | | pm.product_name, |
| | | p.product_name, |
| | | pm.unit |
| | | from |
| | | process_route_item pri |
| | | left join product_model pm on pri.product_model_id = pm.id |
| | | left join product_process pp on pp.id = pri.process_id |
| | | left join product p on p.id = pm.product_id |
| | | left join process_route pr on pr.id = pri.route_id |
| | | where |
| | | pri.route_id = #{c.routeId} |