From e8b879be4968a0eb9e25a224e560f20f2a71cafc Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 17 十月 2025 10:13:18 +0800
Subject: [PATCH] yys 修改-客户往来-应收金额字段bug
---
src/main/resources/application-nydl.yml | 8 ++++----
src/main/resources/mapper/sales/InvoiceLedgerMapper.xml | 2 +-
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/main/resources/application-nydl.yml b/src/main/resources/application-nydl.yml
index 56c2573..7d9428e 100644
--- a/src/main/resources/application-nydl.yml
+++ b/src/main/resources/application-nydl.yml
@@ -62,9 +62,9 @@
druid:
# 涓诲簱鏁版嵁婧�
master:
- url: jdbc:mysql://192.168.1.185:3306/product-inventory-management-nydl?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+ url: jdbc:mysql://192.168.0.182:3306/product-inventory-management-nydl?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
- password: xd@123456..
+ password: HpencZdyK7WrtQvBUKnr
# 浠庡簱鏁版嵁婧�
slave:
# 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
@@ -135,11 +135,11 @@
redis:
# 鍦板潃
# host: 127.0.0.1
- host: 192.168.1.185
+ host: 192.168.0.182
# 绔彛锛岄粯璁や负6379
port: 6379
# 鏁版嵁搴撶储寮�
- database: 14
+ database: 0
# 瀵嗙爜
# password: root2022!
password:
diff --git a/src/main/resources/mapper/sales/InvoiceLedgerMapper.xml b/src/main/resources/mapper/sales/InvoiceLedgerMapper.xml
index b8f9aa2..0c93e4d 100644
--- a/src/main/resources/mapper/sales/InvoiceLedgerMapper.xml
+++ b/src/main/resources/mapper/sales/InvoiceLedgerMapper.xml
@@ -114,7 +114,7 @@
T4.id,T4.customer_name ,
SUM(invoice_total) AS invoice_total,
IFNULL( SUM(T5.receipt_payment_amount) , 0 ) AS receipt_payment_amount,
- IFNULL((SUM(invoice_total) - SUM(T5.receipt_payment_amount)),0) AS unReceipt_payment_amount
+ IFNULL((IFNULL(SUM(invoice_total),0) - IFNULL(SUM(T5.receipt_payment_amount),0)),0) AS unReceipt_payment_amount
FROM
invoice_ledger T1
LEFT JOIN invoice_registration_product T2 ON T1.invoice_registration_product_id = T2.id
--
Gitblit v1.9.3