feat: 供应商往来增加筛选条件 采购单号

buhuazhen

2 天以前 bc1e6648584e5eeda7e78a9fafa5cb422f271dd0

feat: 供应商往来增加筛选条件 采购单号

 src/main/java/com/ruoyi/purchase/dto/PaymentLedgerDto.java

@@ -15,4 +15,7 @@

    // 结束日期
    private String endDate;

    // 采购单号
    private String purchaseContractNumber;
}

 src/main/resources/mapper/purchase/PaymentRegistrationMapper.xml

@@ -196,6 +196,9 @@
            <if test="req.supplierName != null and req.supplierName != '' ">
                T1.supplier_name LIKE CONCAT ('%',#{req.supplierName},'%')
            </if>
            <if test="req.purchaseContractNumber != null and req.purchaseContractNumber != '' ">
                AND T1.purchase_contract_number LIKE CONCAT ('%',#{req.purchaseContractNumber},'%')
            </if>
        </where>
        GROUP BY T1.supplier_id, T1.supplier_name
    </select>
@@ -216,6 +219,9 @@
            <if test="req.supplierName != null and req.supplierName != '' ">
                AND T1.supplier_name LIKE CONCAT ('%',#{req.supplierName},'%')
            </if>
            <if test="req.purchaseContractNumber != null and req.purchaseContractNumber != '' ">
                AND T1.purchase_contract_number LIKE CONCAT ('%',#{req.purchaseContractNumber},'%')
            </if>
        </where>
        GROUP BY T1.supplier_id, T1.supplier_name, T1.purchase_contract_number, T2.payment_date
    </select>