src/main/java/com/ruoyi/production/dto/ProductionProductMainDto.java
@@ -33,6 +33,10 @@ @Excel(name = "报废数量") private BigDecimal scrapQty = BigDecimal.ZERO; @ApiModelProperty(value = "合格数量") @Excel(name = "合格数量") private BigDecimal qualifiedQty = BigDecimal.ZERO; //产品名称 @Excel(name = "产品名称") private String productName; src/main/resources/mapper/production/ProductionProductMainMapper.xml
@@ -64,8 +64,8 @@ ppo.quantity, ppo.scrap_qty, ppo.other_data, pm.unit, sl.sales_contract_no salesContractNo (ppo.quantity - ppo.scrap_qty) as qualifiedQty, pm.unit from production_product_main ppm left join product_work_order pwo on pwo.id = ppm.work_order_id
