java/xizang.git

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

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