From 19be4121c6c958109a2cb63267bf2e6b0af4476f Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期四, 25 七月 2024 17:00:32 +0800
Subject: [PATCH] 回款报表
---
src/main/java/com/product/contract/service/ContractPaymentService.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/product/contract/service/ContractPaymentService.java b/src/main/java/com/product/contract/service/ContractPaymentService.java
index 470e358..ed2a64b 100644
--- a/src/main/java/com/product/contract/service/ContractPaymentService.java
+++ b/src/main/java/com/product/contract/service/ContractPaymentService.java
@@ -110,5 +110,20 @@
return baseDao.getFieldSetEntity(CmnConst.LX_PROJECT_CONTRACT_PAYMENT,fs.getUUID(),true);
}
+ /**
+ * 鍥炴鎶ヨ〃
+ * @param fs
+ * @return
+ * @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" +
+ "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");
+ }
}
--
Gitblit v1.9.2