| | |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | @Data |
| | |
| | | @ApiModelProperty(value = "单位") |
| | | private String unit; |
| | | |
| | | @ApiModelProperty(value = "数量") |
| | | private BigDecimal qualitity; |
| | | |
| | | @ApiModelProperty(value = "子节点列表") |
| | | private List<FinishedProductTreeDto> children; |
| | | } |
| | |
| | | leafNode.setVoltage(data.getVoltage()); |
| | | leafNode.setMaterialCode(data.getMaterialCode()); |
| | | leafNode.setUnit(data.getUnit()); |
| | | leafNode.setQualitity(data.getQualitity()); |
| | | productMap.get(productId).getChildren().add(leafNode); |
| | | } |
| | | |
| | |
| | | si.process_category as processCategory, |
| | | si.voltage, |
| | | pm.material_code as materialCode, |
| | | pm.unit |
| | | pm.unit, |
| | | si.qualitity as qualitity |
| | | from stock_inventory si |
| | | inner join product_model pm on si.product_model_id = pm.id |
| | | inner join product p on pm.product_id = p.id |
| | |
| | | <if test="ew.voltage != null and ew.voltage != ''"> |
| | | and si.voltage = #{ew.voltage} |
| | | </if> |
| | | and si.qualitity > 0 |
| | | </where> |
| | | order by p.id asc, pm.id asc, si.id asc |
| | | </select> |