From af9498656d10e69a84a0783aa70ca04c5705e538 Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期五, 26 七月 2024 10:34:46 +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..0576fe4 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",new String[]{});
+ }
}
--
Gitblit v1.9.2