ALTER VIEW [dbo].[N_BILL_PRINT_Card_AddMoney]
AS
SELECT A.ID AS 流水单号, A.Card_ID AS 卡号, A.Shp_Id AS 店铺编号, U.shp_name AS 店铺名称
, U.shp_name1 AS 店铺简称, U.shp_add AS 店铺地址, U.shp_tele AS 店铺电话,
A.sysDate AS 充值时间, A.OpterMan AS 收银员, A.salesman AS 销售员, B.vip_id AS Vip卡号, Vip.vip_name AS Vip名称,
--CASE a.AddType WHEN '00' THEN '现金充值' WHEN '0' THEN '现金充值' WHEN '01' THEN '银行卡充值' WHEN '02' THEN '积分兑换' END AS 充值类型,
ltrim(case when isnull(pay1.pay_money,0)=0 then '' else '现金:'+cast(pay1.pay_money as varchar) end
+case when isnull(pay2.pay_money,0)=0 then '' else ' 银行卡:'+cast(pay2.pay_money as varchar) end
+case when isnull(pay4.pay_money,0)=0 then '' else ' 积分:'+cast(pay4.pay_money as varchar) end
+case when isnull(pay5.pay_money,0)=0 then '' else ' 支付宝:'+cast(pay5.pay_money as varchar) end
+case when isnull(pay6.pay_money,0)=0 then '' else ' 微信:'+cast(pay6.pay_money as varchar) end
+case when isnull(pay3.pay_money,0)=0 then '' else ' 其他:'+cast(pay3.pay_money as varchar) end )
AS 充值类型
,A.AddMoney AS 充值金额, A.GrantMoney AS 充值赠送金额, A.GrantIntegral AS 充值赠送积分, A.sys_memo AS 备注, co.com_name AS 公司名称,
co.com_name1 AS 公司简称
FROM dbo.Card_AddMoney AS A INNER JOIN
dbo.Bas_Card AS B ON A.Card_ID = B.Card_ID LEFT OUTER JOIN
dbo.BAS_VIP AS Vip ON Vip.vip_id = B.vip_id INNER JOIN
dbo.BAS_SHP AS U ON A.Shp_Id = U.shp_id LEFT OUTER JOIN
(SELECT TOP 1 com_name, com_name1
FROM dbo.BAS_COMPANY) AS co ON 1 = 1
left join CARD_ADD_MONEY_PAY pay1 on pay1.id=a.ID and pay1.pay_type='RMB' --现金
left join CARD_ADD_MONEY_PAY pay2 on pay2.id=a.ID and pay2.pay_type='CREDIT' --银行卡
left join CARD_ADD_MONEY_PAY pay3 on pay3.id=a.ID and pay3.pay_type='OTHER' --其他
left join CARD_ADD_MONEY_PAY pay4 on pay4.id=a.ID and pay4.pay_type='INTEGRAL' --积分
left join CARD_ADD_MONEY_PAY pay5 on pay5.id=a.ID and pay5.pay_type='ALIPAY' --支付宝
left join CARD_ADD_MONEY_PAY pay6 on pay6.id=a.ID and pay6.pay_type='MICROPAY' --微信
GO
**************************************************