fix: 处理空值计算，确保待来票金额与未来票金额一致

gongchunyi

7 小时以前 79a570ae5f497e30337e7dd002450072e1b21cc2

fix: 处理空值计算，确保待来票金额与未来票金额一致

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

@@ -17,8 +17,8 @@
        pl.supplier_name,
        pl.project_name,
        pl.contract_amount,
        sum(pr.tickets_amount)as receipt_payment_amount,
        pl.contract_amount-sum(pr.tickets_amount) AS unReceipt_payment_amount,
        COALESCE(SUM(pr.tickets_amount), 0) AS receipt_payment_amount,
        pl.contract_amount - COALESCE(SUM(pr.tickets_amount), 0) AS unReceipt_payment_amount,
        pl.entry_date,
        pl.recorder_name,
        pl.payment_method