feat(product): 添加产品结构父子关系功能
| | |
| | | disk_quantity numeric(16, 4) not null comment '盘数量', |
| | | tenant_id bigint not null comment '租户id' |
| | | ); |
| | | alter table product_structure |
| | | add parent_id bigint null comment '父id'; |
| | |
| | | public R addOrUpdate(@RequestBody ProductStructureDto productStructureDto){ |
| | | return R.ok(productStructureService.addProductStructureDto(productStructureDto)); |
| | | } |
| | | @ApiOperation("删除产品结构") |
| | | @DeleteMapping("/{ids}") |
| | | public R delete(@PathVariable("ids") Long[] ids){ |
| | | return R.ok(productStructureService.removeBatchByIds(Arrays.asList(ids))); |
| | | } |
| | | } |
| | |
| | | |
| | | @ApiModelProperty(value = "工艺名称") |
| | | private String processName; |
| | | @ApiModelProperty(value = "生产炒机") |
| | | private String speculativeTradingName; |
| | | @ApiModelProperty(value = "产品名称") |
| | | private String productName; |
| | | @ApiModelProperty(value = "产品id") |
| | | private Long productId; |
| | | |
| | |
| | | private String unit; |
| | | |
| | | /** |
| | | * 父级id |
| | | */ |
| | | private Long parentId; |
| | | |
| | | /** |
| | | * 盘数量 |
| | | */ |
| | | private BigDecimal diskQuantity; |
| | |
| | | |
| | | @Override |
| | | public Boolean addProductStructureDto(ProductStructureDto productStructureDto) { |
| | | this.remove(new QueryWrapper<ProductStructure>().lambda().eq(ProductStructure::getProductModelId, productStructureDto.getProductModelId())); |
| | | this.remove(new QueryWrapper<ProductStructure>().lambda().eq(ProductStructure::getParentId, productStructureDto.getParentId())); |
| | | productStructureDto.getProductStructureList().forEach(productStructure -> { |
| | | productStructure.setParentId(productStructureDto.getParentId()); |
| | | }); |
| | | return this.saveBatch(productStructureDto.getProductStructureList()); |
| | | } |
| | | } |
| | |
| | | |
| | | <select id="listByproductModelId" resultType="com.ruoyi.production.dto.ProductStructureDto"> |
| | | select ps.*, |
| | | pm.speculative_trading_name , |
| | | pp.name as process_name, |
| | | pm.product_id, |
| | | pm.model |
| | | p.product_name, |
| | | pp.name as process_name, |
| | | pm.product_id, |
| | | pm.model |
| | | from |
| | | product_structure ps |
| | | left join product_model pm on ps.product_model_id = pm.id |
| | | left join product_process pp on ps.process_id = pp.id |
| | | where pm.id = #{productId} |
| | | product_structure ps |
| | | left join product_model pm on ps.product_model_id = pm.id |
| | | left join product p on pm.product_id = p.id |
| | | left join product_process pp on ps.process_id = pp.id |
| | | where ps.parent_id = #{productModelId} |
| | | order by ps.id |
| | | </select> |
| | | </mapper> |