计算质检合格数量

huminmin

4 小时以前 228cf53fbba710e00e50486b845478ada35e4cb6

计算质检合格数量

 src/main/java/com/ruoyi/quality/pojo/QualityInspect.java

@@ -99,6 +99,10 @@
    @Excel(name = "数量")
    private BigDecimal quantity;

    @Excel(name = "合格数量")
    @TableField(exist = false)
    private BigDecimal qualifiedQuantity;

    /**
     * 不良数量
     */

 src/main/resources/mapper/quality/QualityInspectMapper.xml

@@ -4,6 +4,7 @@
    <select id="qualityInspectListPage" resultType="com.ruoyi.quality.pojo.QualityInspect">
        SELECT
        qi.*,
        (qi.quantity - qi.defective_quantity) as qualifiedQuantity,
        <choose>
            <when test="qualityInspect.inspectType == 0">
                pl.purchase_contract_number as purchase_contract_no
@@ -48,7 +49,8 @@

    <select id="qualityInspectExport" resultType="com.ruoyi.quality.pojo.QualityInspect">
        SELECT
        *
        *,
        (quantity - defective_quantity) as qualifiedQuantity
        FROM quality_inspect
        where
        inspect_type=#{qualityInspect.inspectType}