setCurrentTable(date('Ym', strtotime($month))); return $UserSignModel->where('uid', $uid)->select('price', 'sign_time')->orderBy('sign_time', 'desc')->paginate($page_size); } public static function sign($uid, $day) { //查看签到日期 $sign_day = ReadRecordService::getSignDay($uid); if ($sign_day == -1) { return false; } $count = ReadRecordService::getSignCountSimple($uid); if ($sign_day != $day) { //记录签到日期 if ($sign_day && $sign_day == date('Y-m-d', time() - 86400)) { //昨天有签过到 ReadRecordService::sign((int) $uid, true); $count += 1; } else { //昨天没有签过到 ReadRecordService::sign((int) $uid, false); $count = 1; } } $fee = 0; $day_list = []; if ($count % 7 == 1 && $count <= 7) { $fee = 30; } elseif ($count % 7 == 3) { $fee = 120; } elseif ($count % 7 == 0) { $fee = 150; } else { $fee = 50; } if ($count > 7) { $day_list = [50, 50, 120, 50, 50, 50, 150]; } else { $day_list = [30, 50, 120, 50, 50, 50, 150]; } if ($sign_day != $day) { UserService::addBalance($uid, $fee, 0, $fee); // 先扔到redis里面,异步更新user_sign表 $use_redis_user_sign = true; if ($use_redis_user_sign) { $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')]; Redis::sadd('user_sign:uid', $uid); Redis::hset('user_sign:uid:info', $uid, json_encode($sign_data)); ReadRecordService::setSignInfo($uid, json_encode($sign_data)); } else { $user_sign_model = new UserSign(); $user_sign_model->setCurrentTable(date('Ym')); $data = ['uid' => $uid, 'price' => $fee, 'day' => $day, 'sign_time' => time()]; $user_sign_model->create($data); } } return ['fee' => $fee, 'days' => $count, 'day_list' => $day_list]; } public static function setUserSignVersion($uid, $version) { ReadRecordService::setByField($uid, 'sign_version', $version); } /** * 新签到回复 * @param $openid * @param bool $check_sign * @param int $price * @return string */ public static function userSignReturnContent3($openid, $distribution_channel_id = '') { $content = ''; $day = date('Y-m-d'); $user = ForceSubscribeUsers::getOneForceSubscribeUsersByOpenid($openid); if ($user) { $user_wechat = User::where('id', $user->uid)->first(); $new_user_activity_content = ''; if (!Order::where('uid', $user->uid)->where('status', 'PAID')->select('id')->first()) { $new_user_activity_content = self::newUserActivity($user); } $encode_distribution_channel_id = encodeDistributionChannelId($user->distribution_channel_id); $attach_content = self::signCallBackPushActivityInfo($user->uid, $user->distribution_channel_id); $continueReadUrl = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('WECHAT_CUSTOM_HOST') . '.com/continue'; $sign_url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('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']; } $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 = '女频'; } } $hot_book_num = 3; $recomm_books = BookConfigService::getSignRecommendBooks($read_bid_arr, $sign_recomm_bid_key, $hot_book_num); $content .= "\n\n" . '热门书籍推荐'; if ($recomm_books) { foreach ($recomm_books as $book) { $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('WECHAT_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 .= $new_user_activity_content; } } // 空用户推默认的文案 else { $encode_distribution_channel_id = encodeDistributionChannelId($distribution_channel_id); $url = env('PROTOCOL') . '://site' . $encode_distribution_channel_id . '.' . env('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; } }