| src/main/resources/mapper/sales/ReceiptPaymentMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/resources/mapper/sales/ReceiptPaymentMapper.xml
@@ -414,7 +414,7 @@ GROUP_CONCAT( name ORDER BY id ASC SEPARATOR ' | ') AS invoiceFileName FROM invoice_ledger_file GROUP BY invoice_ledger_id ) T4 ON T4.invoice_ledger_id = T1.id LEFT JOIN sales_ledger_product T5 ON T2.sales_ledger_product_id = T5.id and slp.type = 1 LEFT JOIN sales_ledger_product T5 ON T2.sales_ledger_product_id = T5.id and T5.type = 1 LEFT JOIN ( SELECT SUM(receipt_payment_amount) AS receipt_payment_amount_total,invoice_ledger_id FROM receipt_payment GROUP BY invoice_ledger_id