where('day','>=',$day_2)->select('day')->orderBy('id','desc')->limit(3)->get(); if(!$sign_stat->isEmpty()){ $day_1 = date('Y-m-d',strtotime($day)-86400); $sign_day = []; foreach ($sign_stat as $v){ $sign_day[] = $v->day; } if(in_array($day,$sign_day)){ return 0; } if( in_array($day_1,$sign_day) && in_array($day_2,$sign_day)){ return 50; } return 30; } return 30; } /** * 用户签到记录 */ public static function getUserSignRecord($uid){ return UserSign::getUserSignRecord($uid); } /** * 签到 * @param $uid * @param $day * @return mixed */ public static function sign($uid, $day) { //查看签到日期 $sign_day = ReadRecordService::getSignDay($uid); if($sign_day == -1){ return false; } //已经签过到 if($sign_day == $day){ return false; } $count = ReadRecordService::getSignCountSimple($uid); //记录签到日期 if($sign_day && $sign_day == date('Y-m-d',time()-86400)){ $continue = true; //昨天有签过到 ReadRecordService::sign((int)$uid,true); $count += 1; }else{ $continue = false; //昨天没有签过到 ReadRecordService::sign((int)$uid,false); $count = 1; } $return_fee = $fee = 30; //连续签到两天 50书币 if($continue && $count>=3){ $return_fee = $fee = 50; } if($count%15 == 7){ $fee += 100; } if($count%15 == 0){ $fee += 150; } UserService::addBalance($uid, $fee, 0, $fee); UserSign::sign($uid, $day,$fee); return $return_fee; } public static function signToday($uid){ return self::sign($uid,date('Y-m-d')); } /** * 新签到回复 * @param $openid * @param bool $check_sign * @param int $price * @return string */ public static function userSignReturnContent3($openid,$distribution_channel_id='',$WECHAT_CUSTOM_HOST='zhuishuyun') { $content = ''; $day = date('Y-m-d'); $user = ForceSubscribeUsers::getOneForceSubscribeUsersByOpenid($openid); if ($user) { $user_wechat = User::where('id',$user->uid)->first(); $new_user_activity_content = ''; $close_sign_activity = env('CLOSE_SIGN_ACTIVITY_SITE','-1'); if(!in_array($user->distribution_channel_id,explode(',',$close_sign_activity))){ if(!Order::where('uid',$user->uid)->where('status','PAID')->select('id')->first()){ $new_user_activity_content = self::newUserActivity($user); } } $distribution_channel_id = $user->distribution_channel_id; $encode_distribution_channel_id = encodeDistributionChannelId($user->distribution_channel_id); $attach_content = self::signCallBackPushActivityInfoV2($user->uid,$user->distribution_channel_id); $continueReadUrl = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/continue'; $sign_url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/sign'; $sign_stat = self::isSign($user->uid); if ($sign_stat) { $content = '今日已经签到过了,明日继续签到得书币哦~' ; //$content .= ' ☞ 点我继续上次阅读'; }else{ $content = '尊敬的会员:'.($user_wechat?$user_wechat->nickname:'')."\n\n"."💰点击此处签到领书币" ; //$content .= '继续阅读\n\n ☞ 点我继续上次阅读'; } $res = ReadRecordService::getReadRecord($user->uid); // foreach ($res as $key => $record) { // if ($key == 1) break; // $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('CUSTOM_HOST') . '.com/reader?bid=' . Hashids::encode($record['bid']) . '&cid=' . $record['cid']; // $content .= "\n\n" . ' ☞ 《' . $record['book_name'] . '》'; // } $read_bid_arr = []; $read_bid_arr[] = -1; foreach ($res as $vbook) { $read_bid_arr[] = $vbook['bid']; } // 男频强制推广男频书 $channel_sex = ChannelService::getChannelCompanySex($distribution_channel_id); if($channel_sex == 1){ $sign_recomm_bid_key = '男频'; }else{ $sex = ForceSubscribeService::getSimpleSexByUid($user->uid); $sign_recomm_bid_key = $sex==1?'男频':'女频'; } $hot_book_num = 3; $recomm_books = BookConfigService::getSignRecommendBooks($read_bid_arr, $sign_recomm_bid_key,$hot_book_num); $content .= "\n\n" . '热门书籍推荐'; if ($recomm_books) { // 判断是否不展示书名 $self_config = ChannelService::check_channel_account_priv($distribution_channel_id,'hide_book_name'); $hide_type = isset($self_config->type)?$self_config->type:'not_hide'; $recommend_titles = []; if($hide_type == 'hide_book_name'){ \Log::info('sign_hide_book_name:'.$distribution_channel_id); $sex = ForceSubscribeService::getSimpleSexByUid($user->uid); $recommend_titles = PromotionService::getRandomHeadline($sex,count($recomm_books)); } foreach ($recomm_books as $key=>$book) { $book_name = $book->book_name; if($hide_type == 'hide_book_name'){ $book_name = isset($recommend_titles[$key]->title)?$recommend_titles[$key]->title:$book->book_name; } $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/reader?bid=' . Hashids::encode($book->bid) . '&cid=' . $book->first_cid; $content .= "\n\n" . ' ☞ 《' . $book_name . '》'; } } //$content .= "\n\n" . '为方便下次阅读,请置顶公众号'; $content .= "\n\n" . '为方便下次阅读,请置顶公众号'; if($attach_content){ $content .= "\n\n" .$attach_content; } if($new_user_activity_content){ $content .= $new_user_activity_content; } } // 空用户推默认的文案 else{ $encode_distribution_channel_id = encodeDistributionChannelId($distribution_channel_id); $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . $WECHAT_CUSTOM_HOST . '.com/sign'; $content = "尊敬的会员:\n\n" . ' 💰点击此处签到领书币'; } return $content; } private static function newUserActivity($user){ $content = ''; $status = self::newUserActivityStatus($user->uid); $record = []; //新关未付费用户42小时后充推送活动 68元的活动 文案:全年免费看书 if(strtotime($user->created_at)+42*3600 < time() && $user->distribution_channel_id == 123 && !in_array(1,$status) ){ $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/seYearActivity?fromtype=signcallback_forever&send_time='.time() ; $content .= "\n\n" .' 💰全年免费看书'; $record[] = ['uid'=>$user->uid,'type'=>1,'created_at'=>date('Y-m-d H:i:s'),'updated_at'=>date('Y-m-d H:i:s')]; } //20小时的 文字链的文案:书币充值特惠 if(strtotime($user->created_at)+20*3600 < time() && !in_array(2,$status)){ $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/newUserSale?fromtype=signcallback_newUserSale&send_time='.time() ; $content .= "\n\n" .' 💰书币充值特惠'; $record[] = ['uid'=>$user->uid,'type'=>2,'created_at'=>date('Y-m-d H:i:s'),'updated_at'=>date('Y-m-d H:i:s')]; } //36小时的。文案:充9.9送2000书币 if(strtotime($user->created_at)+36*3600 < time() && !in_array(3,$status)){ $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($user->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/sale/newUserActivity?fromtype=signcallback_newUserActivity&send_time='.time() ; $content .= "\n\n" .' 💰充9.9得2000书币'; $record[] = ['uid'=>$user->uid,'type'=>3,'created_at'=>date('Y-m-d H:i:s'),'updated_at'=>date('Y-m-d H:i:s')]; } self::recordnewUserActivityPush($record); return $content; } private static function newUserActivityStatus($uid){ $data = [-1]; if(!$uid){ return $data; } $result = DB::table('user_sign_push_activity')->where('uid',$uid)->select('type')->get(); if($result){ foreach ($result as $v){ array_push($data,$v->type); } } return $data; } private static function recordnewUserActivityPush($data){ if($data){ try{ DB::table('user_sign_push_activity')->insert($data); }catch (\Exception $e){ } } } /** * * @param $openid * @return string */ public static function userSignReturnContent($openid) { $content = ''; $day = date('Y-m-d'); $user = ForceSubscribeUsers::getOneForceSubscribeUsersByOpenid($openid); if ($user) { $encode_distribution_channel_id = encodeDistributionChannelId($user->distribution_channel_id); $attach_content = self::signCallBackPushActivityInfo($user->uid); $continueReadUrl = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('CUSTOM_HOST') . '.com/continue'; $is_sign = self::isSign($user->uid); if ($is_sign) { $content = '今日已经签到过了,明日继续签到得书币哦~' . "\n\n" . ' >>点我继续上次阅读'; /*if($attach_content){ $content .= "\n\n" .$attach_content; }*/ //return $content; }else{ $sign_stat = self::sign($user->uid, $day); $content = '今日签到成功,赠送'.$sign_stat.'书币,明日继续签到得书币哦~' . "\n\n" . ' >>点我继续上次阅读' . "\n\n" . '阅读记录:'; if($sign_stat == 30){ $content = '今日签到成功,赠送30书币,连续签到2日后,赠送书币增加至50哦~' . "\n\n" . ' >>点我继续上次阅读' . "\n\n" . '阅读记录:'; } } $new_user_activity_content = ''; if(!Order::where('uid',$user->uid)->where('status','PAID')->select('id')->first()){ $new_user_activity_content = self::newUserActivity($user); } $res = ReadRecordService::getReadRecord($user->uid); foreach ($res as $key => $record) { if ($key == 3) break; $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('CUSTOM_HOST') . '.com/reader?bid=' . Hashids::encode($record['bid']) . '&cid=' . $record['cid']; $content .= "\n\n" . ' >>《' . $record['book_name'] . '》'; } $read_bid_arr = []; $read_bid_arr[] = -1; foreach ($res as $vbook) { $read_bid_arr[] = $vbook['bid']; } $user_detail = UserService::getById($user->uid); $sign_recomm_bid_key = '男频'; if ($user_detail && isset($user_detail->sex)) { if ($user_detail->sex == 2) { $sign_recomm_bid_key = '女频'; } } $recomm_books = BookConfigService::getSignRecommendBooks($read_bid_arr, $sign_recomm_bid_key); $content .= "\n\n" . '热门书籍推荐'; if ($recomm_books) { foreach ($recomm_books as $book) { $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('CUSTOM_HOST') . '.com/reader?bid=' . Hashids::encode($book->bid) . '&cid=' . $book->first_cid; $content .= "\n\n" . ' >>《' . $book->book_name . '》'; } } //$content .= "\n\n" . '为方便下次阅读,请置顶公众号'; $content .= "\n\n" . '为方便下次阅读,请置顶公众号'; if($attach_content){ $content .= "\n\n" .$attach_content; } if($new_user_activity_content){ $content .= "\n\n" .$new_user_activity_content; } } return $content; } public static function signCallBackPushActivityInfo($uid,$distribution_channel_id){ $activity_setting = ActivityService::getActivitySetting(); if(!$activity_setting) return false; $acyivity_id = isset($activity_setting['activity_id'])?$activity_setting['activity_id']:0; $other = env('OTHER_ACTIVITY_ID',0); if($acyivity_id == $other && !in_array($distribution_channel_id,explode(',', env('OTHER_ACTIVITY_CHANNEL', '1')))){ return false; } if(!$acyivity_id) return false; $activity_title = isset($activity_setting['sign_call_back_text'])?$activity_setting['sign_call_back_text']:'';; if(empty($activity_title)) return false; $activity_info = ActivityService::getById($acyivity_id); if(empty($activity_info)) return false; if(time()< strtotime($activity_info->start_time) || time()> strtotime($activity_info->end_time)){ return false; } $user = UserService::getById($uid); if(empty($user)) return false; if(!ActivitySwitchService::isShowInPage($acyivity_id,$distribution_channel_id,'sign')){ return false; } /* $no_participate_activity = env('no_participate_activity',''); if($no_participate_activity && in_array($user->distribution_channel_id, explode(',',$no_participate_activity))){ return false; }*/ if($user && isset($user->created_at) && (time() - strtotime($user->created_at)) >= 86400*2) { $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com'.$activity_info->activity_page . '&fromtype=signcallback' ; return ' ' . $activity_title . ''; } return false; } public static function signCallBackPushActivityInfoV2($uid,$distribution_channel_id){ $activity_info = ActivityService::selectNowActiveActivityV3($distribution_channel_id); if(empty($activity_info)) return false; $acyivity_id = $activity_info->id; $activity_setting = $activity_info->setting; if(!$activity_setting ) return false; $activity_setting = json_decode($activity_setting,1); if(!isset($activity_setting['sign_text']) || empty($activity_setting['sign_text'])) return false; if($activity_info->create_type == 5){ //渠道自定义活动 if(!isset($activity_setting['sign_enter_point_switch']) || empty($activity_setting['sign_enter_point_switch'])){ return false; } }else{ if(!ActivitySwitchService::isShowInPage($acyivity_id,$distribution_channel_id,'sign')){ return false; } } $user = UserService::getById($uid); if(empty($user)) return false; if($user && isset($user->created_at) && (time() - strtotime($user->created_at)) >= 86400*2) { $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com'.$activity_info->activity_page . '&fromtype=signcallback' ; return ' ' . $activity_setting['sign_text'] . ''; } return false; } /** * 签到统计 */ public static function getSignTotalByChnnelId(array $data = []) { $search_obj = UserSign::join('users', 'user_sign.uid', '=', 'users.id'); if (isset($params['distribution_channel_id'])) $search_obj->where('users.distribution_channel_id', $params['distribution_channel_id']); if (isset($params['begin_time']) && $params['begin_time']) $search_obj->where('user_sign.created_at', '>=', $params['begin_time']); if (isset($params['end_time']) && $params['end_time']) $search_obj->where('user_sign.created_at', '<=', $params['end_time']); return $search_obj->groupBy('user_sign.day', 'users.distribution_channel_id')->select(DB::raw('count(*) as sign_num'), DB::raw('user_sign.day as day'), 'users.distribution_channel_id')->get(); } }