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 | 2 +-
src/main/java/com/product/contract/service/ProjectCommissionService.java | 2 +-
2 files changed, 2 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 ed2a64b..0576fe4 100644
--- a/src/main/java/com/product/contract/service/ContractPaymentService.java
+++ b/src/main/java/com/product/contract/service/ContractPaymentService.java
@@ -123,7 +123,7 @@
"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");
+ "LEFT JOIN product_project_contract_payment_collection f on d.invoice_num=f.invoice_num",new String[]{});
}
}
diff --git a/src/main/java/com/product/contract/service/ProjectCommissionService.java b/src/main/java/com/product/contract/service/ProjectCommissionService.java
index ae4b490..d0674ec 100644
--- a/src/main/java/com/product/contract/service/ProjectCommissionService.java
+++ b/src/main/java/com/product/contract/service/ProjectCommissionService.java
@@ -31,7 +31,7 @@
String queryFilter = queryFilterService.getQueryFilter(fse);
StringBuilder sb = new StringBuilder();
sb.append("SELECT * FROM( \n");
- sb.append("SELECT A.*,B.project_number,B.project_name AS project_name_label,E.user_name AS apply_label \n");
+ sb.append("SELECT A.*,B.project_name AS project_name_label,E.user_name AS apply_label \n");
sb.append("FROM product_project_performance_commission A \n");
sb.append("LEFT JOIN product_project_business B ON B.uuid = A.project_uuid \n");
sb.append("LEFT JOIN product_sys_users E ON E.user_id = A.apply_user \n");
--
Gitblit v1.9.2