feat(production): 添加productId
| | |
| | | @Data |
| | | public class ProcessRouteDto extends ProcessRoute { |
| | | |
| | | @ApiModelProperty(value = "产品名称") |
| | | @ApiModelProperty(value = "生产炒机") |
| | | private String speculativeTradingName; |
| | | |
| | | private Long productId; |
| | | |
| | | @ApiModelProperty("规格") |
| | | private String model; |
| | | } |
| | |
| | | private String speculativeTradingName; |
| | | |
| | | private Long productId; |
| | | |
| | | private String model; |
| | | } |
| | |
| | | |
| | | @ApiModelProperty(value = "工艺名称") |
| | | private String processName; |
| | | @ApiModelProperty(value = "产品名称") |
| | | @ApiModelProperty(value = "生产炒机") |
| | | private String speculativeTradingName; |
| | | @ApiModelProperty(value = "产品id") |
| | | private Long productId; |
| | | |
| | | private String model; |
| | | } |
| | |
| | | pr.description , |
| | | pp.name as process_name, |
| | | pm.speculative_trading_name, |
| | | pm.product_id |
| | | pm.product_id, |
| | | pm.model |
| | | from |
| | | process_route_item pri |
| | | left join product_model pm on pri.product_model_id = pm.id |
| | |
| | | </resultMap> |
| | | |
| | | <select id="pageProcessRouteDto" resultType="com.ruoyi.production.dto.ProcessRouteDto"> |
| | | select ps.*, pm.speculative_trading_name,pm.product_id |
| | | select ps.*, pm.speculative_trading_name,pm.product_id,pm.model |
| | | from process_route ps |
| | | left join product_model pm on ps.product_model_id = pm.id |
| | | <where> |
| | |
| | | <result property="tenantId" column="tenant_id"/> |
| | | </resultMap> |
| | | |
| | | |
| | | |
| | | <select id="listByproductModelId" resultType="com.ruoyi.production.dto.ProductStructureDto"> |
| | | select ps.*, |
| | | pm.speculative_trading_name , |
| | | pp.name as process_name, |
| | | pm.product_id |
| | | pm.product_id, |
| | | pm.model |
| | | from |
| | | product_structure ps |
| | | left join product_model pm on ps.product_model_id = pm.id |