From 0865fa0747b8fdcd6049ad001e207e012dfde25d Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期三, 12 三月 2025 10:19:45 +0800
Subject: [PATCH] 整体BUG修改
---
src/main/java/com/product/contract/service/ContractPaymentService.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/product/contract/service/ContractPaymentService.java b/src/main/java/com/product/contract/service/ContractPaymentService.java
index 8129f18..5c7e0aa 100644
--- a/src/main/java/com/product/contract/service/ContractPaymentService.java
+++ b/src/main/java/com/product/contract/service/ContractPaymentService.java
@@ -140,13 +140,14 @@
* @throws BaseException
*/
public DataTableEntity paymentCollectionData()throws BaseException{
- return baseDao.listTable("SELECT b.project_name,b.customer_name,a.contract_name,c.clause_content,d.invoice_num,e.apply_time,d.invoice_amount,f.collection_amount,f.collection_time FROM \n" +
+ return baseDao.listTable("SELECT b.project_name,g.customer_name,a.contract_name,c.clause_content,d.invoice_num,e.apply_time,d.invoice_amount,f.collection_amount,f.collection_time FROM \n" +
"product_project_contract_info a \n" +
"LEFT JOIN product_project_business b on a.project_uuid=b.uuid\n" +
"LEFT JOIN product_project_contract_info_sub c on a.uuid =c.contract_info_uuid\n" +
"LEFT JOIN product_project_contract_invoice_info d on c.uuid=d.contract_terms\n" +
"LEFT JOIN product_project_contract_invoice e on e.uuid=d.contract_invoice_uuid\n" +
- "LEFT JOIN product_project_contract_payment_collection f on d.invoice_num=f.invoice_num",new String[]{});
+ "LEFT JOIN product_project_contract_payment_collection f on d.invoice_num=f.invoice_num\n" +
+ "LEFT JOIN product_project_customer g on b.customer_name=g.uuid",new String[]{});
}
}
--
Gitblit v1.9.2