一手商城需求管理

位置：用户分析\推送效果分析\广播营销推送 和 用户分析\推送效果分析\精准营销推送\定向推送跳转APP内专场效果

需求：需要补充跳转直播间的数据

原始节点需要新增数据，yishou_apex.bi_broadcast_push_detail_d(在广播推送明细流程)

select 
push_id
,to_char(from_unixtime(push_time),'yyyymmdd')   as push_date
,to_char(from_unixtime(push_time),'HH:ss')   as push_hour_minute
,push_time
,title -- 任务名
,content
,case 
    when push_module is null or push_module = '0' then '不跳转'
    when push_module = 'myOrder' then '我的订单'
    when push_module in ('special', '1') then 'APP内专场'
    when push_module in ('goods', '3') then 'APP内商品'
    when push_module in ('coupon', '5') then '优惠券页面'
    when push_module in ('h5', '8') then 'H5'
    when push_module = 'wallet_list' then '退款详情'
    when push_module in ('live', '18') then '直播列表'
    when push_module in ('alone_goods', '40') then '一手币'
    when push_module = 'orderDetail' then '订单详情'
    when push_module = 'myCollect' then '我的收藏'
    when push_module = 'shoppingCar' then '购物车列表' 

-- 新增三个条件
    when push_module in ('28')  then '今日新款'
    when push_module in ('26')  then '直播间'
    when push_module in ('46')  then '46'
    else push_module
    end as redirect_type
 -- 跳转类型
,case when push_module in ('special', '1') then push_value end as special_id -- 推送专场id
,to_char(from_unixtime(push_time),'yyyymmdd') as dt
from 
yishou_data.all_fmys_broadcast_push
where length(push_uid) = 0 
and status = 1 -- 过滤无效推送任务
;