ods_ticketitemproductdiscountdetail_di

SELECT

ticketitemid,

userid,

productuid,

discounttype,

case when discounttype is null or discounttype=0 then '无折扣'

when discounttype=1 then '搭赠'

when discounttype=2 then '换购'

when discounttype=3 then '打折与特价'

when discounttype=4 then '第二件打折'

when discounttype=5 then '会员折扣'

when discounttype=6 then '商品手动改价（单品折扣）'

when discounttype=7 then '套餐'

when discounttype=8 then '满额返现'

when discounttype=9 then '次卡消费'

when discounttype=10 then '会员积分兑换现金'

when discounttype=11 then '会员积分兑换商品'

when discounttype=12 then '整单折扣/整单改价、优惠券'

when discounttype=13 then '梯度优惠'

else '其他优惠' end as discounttype_name,

discountrate,

discountamount,

discounttotalamount,

discountruleuid,

pt

FROM pspldata.ods_ticketitemproductdiscountdetail_di

WHERE pt > '${start_date}' AND pt<='${end_date}'