feat(production): 添加productId
| | |
| | | |
| | | @ApiModelProperty(value = "产品名称") |
| | | private String speculativeTradingName; |
| | | |
| | | private Long productId; |
| | | } |
| | |
| | | |
| | | @ApiModelProperty(value = "产品名称") |
| | | private String speculativeTradingName; |
| | | |
| | | private Long productId; |
| | | } |
| | |
| | | private String processName; |
| | | @ApiModelProperty(value = "产品名称") |
| | | private String speculativeTradingName; |
| | | @ApiModelProperty(value = "产品id") |
| | | private Long productId; |
| | | } |
| | |
| | | select pri.*, |
| | | pr.description , |
| | | pp.name as process_name, |
| | | pm.speculative_trading_name |
| | | pm.speculative_trading_name, |
| | | pm.product_id |
| | | 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 |
| | | select ps.*, pm.speculative_trading_name,pm.product_id |
| | | from process_route ps |
| | | left join product_model pm on ps.product_model_id = pm.id |
| | | <where> |
| | |
| | | <select id="listByproductModelId" resultType="com.ruoyi.production.dto.ProductStructureDto"> |
| | | select ps.*, |
| | | pm.speculative_trading_name , |
| | | pp.name as process_name |
| | | pp.name as process_name, |
| | | pm.product_id |
| | | from |
| | | product_structure ps |
| | | left join product_model pm on ps.product_model_id = pm.id |