微商城/CRM - HOPESHOW应用系统在线帮助

最后修改人	朱成
最后修改时间	2025-11-06 20:43:55
创建人	朱成
创建时间	2023-05-18 15:16:28

该文档由朱成创建于 2023-05-18 15:16:28 ，朱成在 2025-11-06 20:43:55 修改了该文档。

[TOCM]

## 251106 HS督导群内询问
河北石家庄万象城，唐山区域，天津区域，现在生日会员券都没有，唐山上个月找过你说这个问题，现在还是没有券，我们可以弄一下嘛

![size:800,1000](/storage/2025/11-06/f48Dm2zHrzgYxQ1CH7MHDs8iN5JRPpLoBOZEVp2H.png)

![size:800,1000](/storage/2025/11-06/f7aF8JONUzwOI61UiIZ7Tkaqg8J8IC3dgiDsxran.png)

## 结论
1. 用户提到的三个代理商都是早期上线客户，均有配置过生日券
2. 经过核查，该代理商都在每月按时发券，发放的优惠券在加盟CRM系统与伯俊均可查
3. 石家庄这个店目前入会人数只有152个，所以发券就会只发这152个过生日的中的用户，我后台看11月份发了7张券
4. 天津代理商11月1日发券643张，0张核销；唐山发券534张，已核销4张；
5. 用户期望我们能他们补发券。
6. 深度沟通够，告诉了用户生日券发放规则，用户表示理解。

**HS生日券发放规则，总累销超过10元，则每月1日凌晨发放**

## 过程

1. 唐山券

SELECT  u.nickname,
        u.createdat              AS userRegTime,
        us.customerNa,
        ua.agencyName,
        auc.createdat            AS fqTime,
        auc.status,
        auc.usageStartTime,
        auc.usageEndTime,
        auc.id
FROM ac_user_coupon AS auc
JOIN user           AS u  ON u.id = auc.userId
JOIN ac_coupon      AS ac ON ac.id = auc.couponId
LEFT JOIN user_shops    AS us ON u.customerid = us.customerid
LEFT JOIN user_agencies AS ua ON u.agency = ua.id
WHERE auc.couponId = 1703554690001
  -- and us.customerid = 'D1056'
  and ua.id= 1688649150001
ORDER BY auc.createdat DESC;

2. 天津券

SELECT  u.nickname,
        u.createdat              AS userRegTime,
        us.customerNa,
        ua.agencyName,
        auc.createdat            AS fqTime,
        auc.status,
        auc.usageStartTime,
        auc.usageEndTime
FROM ac_user_coupon AS auc
JOIN user           AS u  ON u.id = auc.userId
JOIN ac_coupon      AS ac ON ac.id = auc.couponId
LEFT JOIN user_shops    AS us ON u.customerid = us.customerid
LEFT JOIN user_agencies AS ua ON u.agency = ua.id
WHERE auc.couponId = 1703554690001
  -- and us.customerid = 'D1056'
  and ua.id= 1688663550001
ORDER BY auc.createdat DESC;

3. 石家庄券

select a.nickname,a.createdat as userregtime, us.customerNa ,ua.agencyName,a.createdat2 as fqtime,a.status ,a.usagestarttime ,a.usageendtime from 
(select u.nickname,u.createdat, ac.name,u.customerid,u.agency,auc.createdat as createdat2,auc.status ,auc.usageStartTime,auc.usageEndTime
from ac_user_coupon auc 
left join user u on u.id=auc.userId
left join ac_coupon ac  on ac.id = auc.couponId
where auc.couponId =1703554690001) a
left join user_shops us on a.customerid = us.customerid
left join user_agencies ua on a.agency =ua.id
where ua.agencyName like '%石家庄%'