src/main/java/com/ruoyi/production/dto/ProductionProductMainDto.java
@@ -73,4 +73,7 @@ @ApiModelProperty(value = "产出方量") @Excel(name = "产出方量") private BigDecimal totalQuantity; @ApiModelProperty("强度") private String strength; } src/main/java/com/ruoyi/production/dto/ProductionProductRouteItemDto.java
@@ -20,6 +20,15 @@ @EqualsAndHashCode(callSuper = false) public class ProductionProductRouteItemDto extends ProductionProductRouteItem { @ApiModelProperty("工序名称") private String processName; @ApiModelProperty("工序编号") private String processNo; @ApiModelProperty("强度") private String strength; @ApiModelProperty("工序绑定的参数信息") private List<ProductionProductRouteItemParamDto> productionProductRouteItemParamDtoList; src/main/java/com/ruoyi/production/dto/ProductionProductRouteItemParamDto.java
@@ -21,4 +21,13 @@ @ApiModelProperty("产品名称") private String productName; @ApiModelProperty("规格型号") private String model; @ApiModelProperty("物料编码") private String materialCode; @ApiModelProperty("强度") private String strength; } src/main/java/com/ruoyi/production/dto/ProductionRecordDto.java
@@ -66,6 +66,9 @@ @ApiModelProperty("产出数量") private BigDecimal quantity; @ApiModelProperty("强度") private String strength; @ApiModelProperty("工艺路线绑定的工序") private List<ProductionProductRouteItemDto> productionProductRouteItemDtoList; src/main/java/com/ruoyi/production/mapper/ProductBomMapper.java
@@ -23,4 +23,6 @@ IPage<ProductBomDto> listPage(Page<ProductBom> page, @Param("c") ProductBomDto productBomDto); ProductBomDto getById(@Param("bomId") Long bomId); String selectStrengthById(@Param("bomId") Long bomId); } src/main/java/com/ruoyi/production/pojo/ProductionProductRouteItemParam.java
@@ -71,7 +71,7 @@ private BigDecimal productValue; @ApiModelProperty(value = "BOM ID") private BigDecimal bomId; private Long bomId; @ApiModelProperty(value = "单位") private String unit; src/main/java/com/ruoyi/production/service/ProductBomService.java
@@ -27,4 +27,7 @@ AjaxResult uploadBom(MultipartFile file, Long dictCode); void exportBom(HttpServletResponse response, Integer bomId); String strengthById(Long bomId); } src/main/java/com/ruoyi/production/service/impl/ProductBomServiceImpl.java
@@ -253,6 +253,14 @@ util.exportExcel(response, exportList, "BOM结构导出"); } @Override public String strengthById(Long bomId) { if (bomId == null) { return null; } return baseMapper.selectStrengthById(bomId); } private void populateMap(List<ProductStructureDto> nodes, Map<Long, ProductStructureDto> map) { if (nodes == null || nodes.isEmpty()) { return; src/main/java/com/ruoyi/production/service/impl/ProductionRecordServiceImpl.java
@@ -93,6 +93,9 @@ private ProductMaterialService productMaterialService; @Autowired private ProductBomService productBomService; @Autowired private TempFileMapper tempFileMapper; @Override @@ -470,6 +473,7 @@ throw new ServiceException("查询失败,未查询到生产订单信息"); } dto.setNpsNo(productOrder.getNpsNo()); dto.setStrength(productOrder.getStrength()); /// 产品信息 ProductMaterialSkuDto productMaterialSkuDto = productMaterialService.selectProductByProductMainId(productOrder.getId()); @@ -507,6 +511,11 @@ ProductionProductRouteItemDto routeItemDto = new ProductionProductRouteItemDto(); BeanUtils.copyProperties(routeItem, routeItemDto); // 工序名称/编号 ProductProcess productProcess = productProcessService.getById(routeItem.getProcessId()); routeItemDto.setProcessName(productProcess.getName()); routeItemDto.setProcessNo(productProcess.getNo()); // 查询工序参数 List<ProductionProductRouteItemParam> paramList = productionProductRouteItemParamService.list( new LambdaQueryWrapper<ProductionProductRouteItemParam>() @@ -519,6 +528,10 @@ ProductMaterialSkuDto materialSkuDto = productMaterialService.selectProductByModelId(paramDto.getProductId()); productMaterialService.selectProductByModelId(paramDto.getProductId()); paramDto.setParamName(materialSkuDto.getProductName()); paramDto.setModel(materialSkuDto.getModel()); paramDto.setMaterialCode(materialSkuDto.getMaterialCode()); String strength = productBomService.strengthById(paramDto.getBomId()); paramDto.setStrength(strength); } return paramDto; }).collect(Collectors.toList()); src/main/resources/mapper/production/ProductBomMapper.xml
@@ -44,4 +44,20 @@ where pb.id = #{id} </select> <select id="selectStrengthById" resultType="java.lang.String" parameterType="java.lang.Long"> select sdd.dict_label from product_bom pb left join sys_dict_data sdd on pb.dict_code = sdd.dict_code <where> <choose> <when test="bomId != null"> pb.id = #{bomId} </when> <otherwise> 1 = 0 </otherwise> </choose> </where> </select> </mapper> src/main/resources/mapper/production/ProductionProductMainMapper.xml
@@ -19,6 +19,7 @@ select ppm.*, ppm.post_name as postName, po.nps_no as npsNo, po.strength as strength, pms.material_code as materialCode, pm.product_name as productName, pms.model as productModelName,