product-inventory-management-after.git

			@@ -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:

			@@ -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

	src/main/resources/application-nydl.yml	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/main/resources/mapper/sales/InvoiceLedgerMapper.xml	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史