UserSignService.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399
  1. <?php
  2. namespace App\Modules\User\Services;
  3. use App\Modules\Activity\Services\ActivitySwitchService;
  4. use App\Modules\Subscribe\Models\Order;
  5. use App\Modules\User\Models\User;
  6. use App\Modules\User\Models\UserSign;
  7. use App\Modules\OfficialAccount\Models\ForceSubscribeUsers;
  8. use App\Modules\Channel\Services\ChannelService;
  9. use App\Modules\OfficialAccount\Services\ForceSubscribeService;
  10. use Hashids;
  11. use App\Modules\Book\Services\BookConfigService;
  12. use DB;
  13. use Redis;
  14. use App\Modules\User\Services\UserService;
  15. use App\Modules\Activity\Services\ActivityService;
  16. class UserSignService
  17. {
  18. protected $table = 'user_sign';
  19. protected $fillable = ['uid', 'price', 'day', 'sign_time'];
  20. /**
  21. * 用户是否已签到
  22. * @param $uid
  23. * @param $day
  24. * @return mixed
  25. */
  26. public static function isSign($uid)
  27. {
  28. //return UserSign::isSign($uid, $day);
  29. $sign_day = ReadRecordService::getSignDay($uid);
  30. //异常
  31. if ($sign_day == -1) {
  32. return true;
  33. }
  34. if ($sign_day && $sign_day == date('Y-m-d')) {
  35. return true;
  36. }
  37. return false;
  38. }
  39. public static function signV2($uid, $day)
  40. {
  41. \Log::info('signv2:uid:' . $uid . ' day:' . $day);
  42. //查看签到日期
  43. $sign_day = ReadRecordService::getSignDay($uid);
  44. if ($sign_day == -1) {
  45. return false;
  46. }
  47. //已经签过到
  48. if ($sign_day == $day) {
  49. return false;
  50. }
  51. $count = ReadRecordService::getSignCountSimple($uid);
  52. //记录签到日期
  53. if ($sign_day && $sign_day == date('Y-m-d', time() - 86400)) {
  54. $continue = true;
  55. //昨天有签过到
  56. ReadRecordService::sign((int)$uid, true);
  57. $count += 1;
  58. } else {
  59. $continue = false;
  60. //昨天没有签过到
  61. ReadRecordService::sign((int)$uid, false);
  62. $count = 1;
  63. }
  64. $fee = 30;
  65. if ($count % 7 == 1 && $count<=7) {
  66. $fee = 30;
  67. } elseif ($count % 7 == 3) {
  68. $fee = 120;
  69. } elseif ($count % 7 == 0) {
  70. $fee = 150;
  71. } else {
  72. $fee = 50;
  73. }
  74. UserService::addBalance($uid, $fee, 0, $fee);
  75. // 先扔到redis里面,异步更新user_sign表
  76. $use_redis_user_sign = true;
  77. if ($use_redis_user_sign) {
  78. $sign_data = ['uid' => $uid, 'price' => $fee, 'day' => $day, 'sign_time' => time(), 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')];
  79. Redis::sadd('user_sign:uid', $uid);
  80. Redis::hset('user_sign:uid:info', $uid, json_encode($sign_data));
  81. ReadRecordService::setSignInfo($uid, json_encode($sign_data));
  82. } else {
  83. $user_sign_model = new UserSign();
  84. $user_sign_model->setCurrentTable(date('Ym'));
  85. $data = ['uid'=>$uid,'price'=>$fee,'day'=>$day,'sign_time'=>time()];
  86. $user_sign_model->create($data);
  87. }
  88. return compact('count','fee');
  89. }
  90. /**
  91. * 新签到回复
  92. * @param $openid
  93. * @param bool $check_sign
  94. * @param int $price
  95. * @return string
  96. */
  97. public static function userSignReturnContent3($openid,$distribution_channel_id='',$WECHAT_CUSTOM_HOST='zhuishuyun')
  98. {
  99. return self::userSignReturnContent($openid,$distribution_channel_id,$WECHAT_CUSTOM_HOST);
  100. }
  101. public static function userSignReturnContent($openid,$distribution_channel_id='',$WECHAT_CUSTOM_HOST='zhuishuyun'){
  102. //强关信息
  103. $user = ForceSubscribeUsers::getOneForceSubscribeUsersByOpenid($openid);
  104. if (!$user) {
  105. return self::defaultSignContent($distribution_channel_id,$WECHAT_CUSTOM_HOST);
  106. }
  107. //用户信息
  108. $user_info = User::where('id',$user->uid)->first();
  109. if (!$user_info){
  110. return self::defaultSignContent($distribution_channel_id,$WECHAT_CUSTOM_HOST);
  111. }
  112. $encode_distribution_channel_id = encodeDistributionChannelId($distribution_channel_id);
  113. $continueReadUrl = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/continue';
  114. $sign_url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/sign';
  115. //是否签到
  116. $sign_status = self::isSign($user->uid);
  117. if($sign_status){
  118. $content = self::hadSignContent($continueReadUrl);
  119. }else{
  120. //直接签到
  121. $direct_sites = explode(',',env('DIRECT_SIGN_SITES'));
  122. $is_direct_sign = in_array($distribution_channel_id,$direct_sites) ? true : false;
  123. if ($is_direct_sign) {
  124. $content = self::directSignContent($user->uid,$user_info->nickname,$continueReadUrl,$sign_url);
  125. } else {
  126. $content = '尊敬的会员:'.$user_info->nickname."\n\n"."<a href='".$sign_url."'>💰点击此处签到领书币</a>" ;
  127. }
  128. }
  129. $content .= self::bookContent($user->uid,$distribution_channel_id,$encode_distribution_channel_id,$WECHAT_CUSTOM_HOST);
  130. $activity_attach_content = '';
  131. try{
  132. $activity_attach_content = self::signCallBackPushActivityInfoV2($user->uid,$distribution_channel_id);
  133. }catch (\Exception $e){
  134. }
  135. if($activity_attach_content){
  136. $content .= "\n\n" .$activity_attach_content;
  137. }
  138. return $content;
  139. }
  140. private static function bookContent($uid,$distribution_channel_id,$encode_distribution_channel_id,$host){
  141. //展示用户最近阅读的三本书,倒叙排列
  142. //如果没有阅读记录则
  143. $read_record_list = ReadRecordService::getReadRecord($uid);
  144. if($read_record_list){
  145. $temp = 0;
  146. $content = "\n\n" . '历史阅读记录';
  147. foreach ($read_record_list as $item){
  148. if($temp >=3) break;
  149. $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $host . '.com/reader?bid=' . Hashids::encode($item['bid']) . '&cid=' . $item['cid'];
  150. $content .= "\n\n" . '<a href="' . $url . '"> ☞ 《' . $item['book_name'] . '》</a>';
  151. $temp++;
  152. }
  153. return $content;
  154. }
  155. //正常推荐3本书
  156. //男女频
  157. $channel_sex = ChannelService::getChannelCompanySex($distribution_channel_id);
  158. if($channel_sex == 1){
  159. $sign_recomm_bid_key = '男频';
  160. }else{
  161. $sex = ForceSubscribeService::getUserRealSexByUid($uid);
  162. $sign_recomm_bid_key = $sex==1?'男频':'女频';
  163. }
  164. $recomm_books = BookConfigService::getSignRecommendBooksFromCache([], $sign_recomm_bid_key,3);
  165. if ($recomm_books) {
  166. // 判断是否不展示书名
  167. $content = "\n\n" . '热门书籍推荐';
  168. foreach ($recomm_books as $key=>$book) {
  169. $book_name = $book->book_name;
  170. $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $host . '.com/reader?bid=' . Hashids::encode($book->bid) . '&cid=' . $book->first_cid;
  171. $content .= "\n\n" . '<a href="' . $url . '"> ☞ 《' . $book_name . '》</a>';
  172. }
  173. return $content;
  174. }
  175. return '';
  176. }
  177. //直接签到
  178. private static function directSignContent($uid,$user_name,$continueReadUrl,$sign_url){
  179. $result = self::signV2($uid,date('Y-m-d'));
  180. if($result){
  181. $content = "本日签到成功,您已连续签到{$result['count']}天,赠送{$result['fee']}书币,连续签到,最高赠送150书币~";
  182. $content .= "\n\n<a href=" . '"' . $continueReadUrl . '"' . '> ☞ 点我继续上次阅读</a>';
  183. return $content;
  184. }else{
  185. //签到失败
  186. $content = '尊敬的会员:'.$user_name."\n\n"."<a href='".$sign_url."'>💰点击此处签到领书币</a>" ;
  187. return $content;
  188. }
  189. }
  190. //已经签过到
  191. private static function hadSignContent($continueReadUrl){
  192. $content = '今日已经签到过了,明日继续签到得书币哦~' ;
  193. $content .= "\n\n<a href=" . '"' . $continueReadUrl . '"' . '> ☞ 点我继续上次阅读</a>';
  194. return $content;
  195. }
  196. //默认签到文案
  197. private static function defaultSignContent($distribution_channel_id,$host){
  198. $encode_distribution_channel_id = encodeDistributionChannelId($distribution_channel_id);
  199. $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $host . '.com/sign';
  200. $content = "尊敬的会员:\n\n" . '<a href="' . $url . '"> 💰点击此处签到领书币</a>';
  201. return $content;
  202. }
  203. //没有开关控制的签到推送,先去掉
  204. private static function newUserActivity($user)
  205. {
  206. $content = '';
  207. $status = self::newUserActivityStatus($user->uid);
  208. $record = [];
  209. //新关未付费用户42小时后充推送活动 68元的活动 文案:全年免费看书
  210. if (strtotime($user->created_at) + 42 * 3600 < time() &&
  211. $user->distribution_channel_id == 123 &&
  212. !in_array(1, $status)
  213. ) {
  214. $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/seYearActivity?fromtype=signcallback_forever&send_time=' . time();
  215. $content .= "\n\n" . '<a href="' . $url . '"> 💰全年免费看书</a>';
  216. $record[] = ['uid' => $user->uid, 'type' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')];
  217. }
  218. //20小时的 文字链的文案:书币充值特惠
  219. if (strtotime($user->created_at) + 20 * 3600 < time() && !in_array(2, $status)) {
  220. $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/newUserSale?fromtype=signcallback_newUserSale&send_time=' . time();
  221. $content .= "\n\n" . '<a href="' . $url . '"> 💰书币充值特惠</a>';
  222. $record[] = ['uid' => $user->uid, 'type' => 2, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')];
  223. }
  224. //36小时的。文案:充9.9送2000书币
  225. if (strtotime($user->created_at) + 36 * 3600 < time() && !in_array(3, $status)) {
  226. $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/newUserActivity?fromtype=signcallback_newUserActivity&send_time=' . time();
  227. $content .= "\n\n" . '<a href="' . $url . '"> 💰充9.9得2000书币</a>';
  228. $record[] = ['uid' => $user->uid, 'type' => 3, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')];
  229. }
  230. self::recordnewUserActivityPush($record);
  231. return $content;
  232. }
  233. private static function newUserActivityStatus($uid)
  234. {
  235. $data = [-1];
  236. if (!$uid) {
  237. return $data;
  238. }
  239. $result = DB::connection('api_mysql')->table('user_sign_push_activity')->where('uid', $uid)->select('type')->get();
  240. if ($result) {
  241. foreach ($result as $v) {
  242. array_push($data, $v->type);
  243. }
  244. }
  245. return $data;
  246. }
  247. private static function recordnewUserActivityPush($data)
  248. {
  249. if ($data) {
  250. try {
  251. DB::connection('api_mysql')->table('user_sign_push_activity')->insert($data);
  252. } catch (\Exception $e) {
  253. }
  254. }
  255. }
  256. public static function signCallBackPushActivityInfoV2($uid,$distribution_channel_id){
  257. $activity_info = ActivityService::selectNowActiveActivity($distribution_channel_id);
  258. if(empty($activity_info))
  259. return false;
  260. $acyivity_id = $activity_info->id;
  261. $activity_setting = $activity_info->setting;
  262. if(!$activity_setting ) return false;
  263. $activity_setting = json_decode($activity_setting,1);
  264. if(!isset($activity_setting['sign_text']) || empty($activity_setting['sign_text'])) return false;
  265. if($activity_info->create_type == 5){
  266. //渠道自定义活动
  267. if(!isset($activity_setting['sign_enter_point_switch']) || empty($activity_setting['sign_enter_point_switch'])){
  268. return false;
  269. }
  270. }else{
  271. if(!ActivitySwitchService::isShowInPage($acyivity_id,$distribution_channel_id,'sign')){
  272. return false;
  273. }
  274. }
  275. $user = UserService::getById($uid);
  276. if(empty($user))
  277. return false;
  278. if($user && isset($user->created_at) && (time() - strtotime($user->created_at)) >= 86400*2) {
  279. $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com'.$activity_info->activity_page . '&fromtype=signcallback' ;
  280. return '<a href="' . $url . '"> ' . $activity_setting['sign_text'] . '</a>';
  281. }
  282. return false;
  283. }
  284. private static function rfmActivity($uid,$distribution_channel_id,$created_at,&$status){
  285. $rfm_user = DB::connection('api_mysql')->table('rfm_ab_test_user')->where('uid',$uid)->select('uid','type')->first();
  286. if(!$rfm_user){
  287. $status = 0;
  288. return '';
  289. }
  290. $time = time() - strtotime($created_at);
  291. if($time > 3600*4 && $time < 23*3600){
  292. if($rfm_user->type == 'A'){
  293. $status = 1;
  294. return '';
  295. }
  296. $level = UserService::rfmLevel($uid,strtotime($created_at));
  297. if($level){
  298. $level_str = implode('',$level);
  299. }
  300. $status = 1;
  301. return '';
  302. }
  303. if($time > 23*3600){
  304. $level = UserService::rfmLevel($uid,strtotime($created_at));
  305. if($level){
  306. $level_str = implode('',$level);
  307. }
  308. $status = 1;
  309. return '';
  310. }
  311. $status = 1;
  312. return '';
  313. }
  314. public static function guideFans($uid,$distribution_channel_id,$openid,$created_at){
  315. list($inner_sites,$qrcode,$second_qrcode) = Redis::hmget('env','GUIDE_PERSONAL_ACCOUNT_SITES','ACTIVE_GUIDE_PERSONAL_ACCOUNT_OURS_QRCODE','SECOND_ACTIVE_GUIDE_PERSONAL_ACCOUNT_OURS_QRCODE');
  316. if ($inner_sites && in_array($distribution_channel_id, explode(',', $inner_sites))){
  317. if (!self::isAccess($openid, $type)) return false;
  318. //注册时按
  319. if ($type == 'INNER_ACTIVE') {
  320. if (!$qrcode) return false;
  321. }
  322. if ($type == 'SECOND_INNER_ACTIVE') {
  323. if (!$second_qrcode) return false;
  324. }
  325. if (strtotime($created_at) <= strtotime('-1 day')) {
  326. $sql = sprintf("select id from orders where uid in (select id from users where openid = '%s' ) and status = 'PAID' and price >=10 limit 1",$openid);
  327. $result = DB::connection('api_mysql')->select( $sql );
  328. if($result){
  329. return true;
  330. }else{
  331. //openid充值金额小于10:不曝光
  332. return false;
  333. }
  334. }
  335. $sql = sprintf("select id from orders where uid = %s and status = 'PAID' and price >=10 limit 1",$uid);
  336. $result = DB::connection('api_mysql')->select( $sql );
  337. //uid下注册时间小于24小时
  338. if ($result) {
  339. return true;
  340. } else {
  341. //uid下充值金额小于10:不曝光
  342. return false;
  343. }
  344. }
  345. return false;
  346. }
  347. //crm 访问权限
  348. private static function isAccess($openid, &$type)
  349. {
  350. //二次到分
  351. $second_result = DB::connection('api_mysql')->table('crm_second_guide')->where('openid',$openid)->select('status')->first();
  352. if($second_result && $second_result->status == 0){
  353. $type = 'SECOND_INNER_ACTIVE';
  354. return true;
  355. }
  356. $first_result = DB::connection('api_mysql')->table('user_bind_hk_welfare')->where('openid',$openid)->select('id')->first();
  357. if ($first_result) {
  358. //领过书币不曝光
  359. return false;
  360. }
  361. $type = 'INNER_ACTIVE';
  362. return true;
  363. }
  364. }