java/xizang.git

			@@ -37,9 +37,9 @@
			<!-- 统计总额和微信支付金额 -->
			<select id="getPaymentStats" resultMap="PaymentStatsResultMap">
			SELECT
			SUM(flow_money) AS totalFlowMoney,
			SUM(deduction_money) AS totalDeductionMoney,
			SUM(remaining_money) AS totalRemainingMoney
			ifnull(SUM(flow_money),0) AS totalFlowMoney,
			ifnull(SUM(deduction_money),0) AS totalDeductionMoney,
			ifnull(SUM(remaining_money),0) AS totalRemainingMoney
			FROM
			t_bank_flow
			<where>

			@@ -39,10 +39,10 @@

			<!-- 统计总额和微信支付金额 -->
			<select id="getPaymentStats" resultMap="PaymentStatsResultMap">
			SELECT SUM(flow_money) AS total_amount,
			SUM(CASE WHEN pay_type = 1 THEN flow_money ELSE 0 END ) AS wechat_amount,
			SUM(CASE WHEN pay_type = 2 THEN flow_money ELSE 0 END ) AS alipay_amount,
			SUM(CASE WHEN pay_type = 3 THEN flow_money ELSE 0 END ) AS offline_amount
			SELECT ifnull(SUM(flow_money),0) AS total_amount,
			ifnull(SUM(CASE WHEN pay_type = 1 THEN flow_money ELSE 0 END ) ,0)AS wechat_amount,
			ifnull(SUM(CASE WHEN pay_type = 2 THEN flow_money ELSE 0 END ),0) AS alipay_amount,
			ifnull(SUM(CASE WHEN pay_type = 3 THEN flow_money ELSE 0 END ),0) AS offline_amount
			FROM
			t_flow_management
			<where>

	ruoyi-system/src/main/resources/mapper/system/TBankFlowMapper.xml	6 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	ruoyi-system/src/main/resources/mapper/system/TFlowManagementMapper.xml	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史