first(); $user->totalTransfer = flowAutoShow($user->transfer_enable); $user->unusedTransfer = $user->transfer_enable - $user->u - $user->d > 0 ? $user->transfer_enable - $user->u - $user->d : 0; $user->unusedPercent = $user->transfer_enable > 0 ? round($user->unusedTransfer / $user->transfer_enable, 2) : 0; $user->unusedTransfer = flowAutoShow($user->unusedTransfer); $user->levelName = Level::query()->where('level', $user['level'])->first()['level_name']; $user->remainDays = date('Y-m-d') < $user->expire_time ? (strtotime($user->expire_time) - strtotime(date('Y-m-d'))) / 86400 : 0; $user->resetDays = date('d') > $user->traffic_reset_day ? (strtotime($user->traffic_reset_day) - strtotime(date('Y-m-d'))) / 86400 : strtotime($user->traffic_reset_day); $user_reset_day = $user->traffic_reset_day; $last_day = date('t'); $today = date('d'); if ($user_reset_day > $today) { $user->resetDays = $user_reset_day > $last_day ? $last_day - $today : $user_reset_day - $today; } else { $next_last_day = date('t', strtotime('next month')); $user->resetDays = $user_reset_day > $next_last_day ? $last_day - $today + $next_last_day : $last_day - $today + $user_reset_day; } $view['info'] = $user->toArray(); $view['noticeList'] = Article::type(2)->orderBy('id', 'desc')->Paginate(1); // 公告 $view['userLoginLog'] = UserLoginLog::query()->where('user_id', Auth::user()->id)->orderBy('id', 'desc')->first(); // 近期登录日志 //流量异常判断 $hourlyTraffic = UserTrafficHourly::query()->where('user_id', $user->id)->where('node_id', 0)->where('created_at', '>=', date('Y-m-d H:i:s', time() - 3900))->sum('total'); $view['isTrafficWarning'] = $hourlyTraffic < (self::$systemConfig['traffic_ban_value'] * 1073741824) ? 0 : 1; //付费用户判断 $view['is_paying_user'] = Order::uid()->where('status', 2)->where('is_expire', 0)->where('origin_amount', '>', 0)->get()->isEmpty(); $dailyData = []; $hourlyData = []; // 节点一个月内的流量 $userTrafficDaily = UserTrafficDaily::query()->where('user_id', Auth::user()->id)->where('node_id', 0)->where('created_at', '>=', date('Y-m', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray(); $dailyTotal = date('d') - 1; // 今天不算,减一 $dailyCount = count($userTrafficDaily); for ($x = 0; $x < $dailyTotal - $dailyCount; $x++) { $dailyData[$x] = 0; } for ($x = $dailyTotal - $dailyCount; $x < $dailyTotal; $x++) { $dailyData[$x] = round($userTrafficDaily[$x - ($dailyTotal - $dailyCount)] / (1024 * 1024 * 1024), 3); } // 节点一天内的流量 $userTrafficHourly = UserTrafficHourly::query()->where('user_id', Auth::user()->id)->where('node_id', 0)->where('created_at', '>=', date('Y-m-d', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray(); $hourlyTotal = date('H'); $hourlyCount = count($userTrafficHourly); for ($x = 0; $x < $hourlyTotal - $hourlyCount; $x++) { $hourlyData[$x] = 0; } for ($x = ($hourlyTotal - $hourlyCount); $x < $hourlyTotal; $x++) { $hourlyData[$x] = round($userTrafficHourly[$x - ($hourlyTotal - $hourlyCount)] / (1024 * 1024 * 1024), 3); } // 本月天数数据 $monthDays = []; for ($i = 1; $i <= date("d"); $i++) { $monthDays[] = $i; } // 本日小时数据 $dayHours = []; for ($i = 1; $i <= date("H"); $i++) { $dayHours[] = $i; } $view['trafficDaily'] = "'" . implode("','", $dailyData) . "'"; $view['trafficHourly'] = "'" . implode("','", $hourlyData) . "'"; $view['monthDays'] = "'" . implode("','", $monthDays) . "'"; $view['dayHours'] = "'" . implode("','", $dayHours) . "'"; return Response::view('user.index', $view); } // 签到 public function checkIn(Request $request) { // 系统开启登录加积分功能才可以签到 if (!self::$systemConfig['is_checkin']) { return Response::json(['status' => 'fail', 'message' => '系统未开启签到功能']); } // 已签到过,验证是否有效 if (Cache::has('userCheckIn_' . Auth::user()->id)) { return Response::json(['status' => 'fail', 'message' => '已经签到过了,明天再来吧']); } $traffic = mt_rand(self::$systemConfig['min_rand_traffic'], self::$systemConfig['max_rand_traffic']); $ret = User::uid()->increment('transfer_enable', $traffic * 1048576); if (!$ret) { return Response::json(['status' => 'fail', 'message' => '签到失败,系统异常']); } // 写入用户流量变动记录 Helpers::addUserTrafficModifyLog(Auth::user()->id, 0, Auth::user()->transfer_enable, Auth::user()->transfer_enable + $traffic * 1048576, '[签到]'); // 多久后可以再签到 $ttl = self::$systemConfig['traffic_limit_time'] ? self::$systemConfig['traffic_limit_time'] : 1440; Cache::put('userCheckIn_' . Auth::user()->id, '1', $ttl); return Response::json(['status' => 'success', 'message' => '签到成功,系统送您 ' . $traffic . 'M 流量']); } // 节点列表 public function nodeList(Request $request) { // 节点列表 $userLabelIds = UserLabel::uid()->pluck('label_id'); if (empty($userLabelIds)) { $view['nodeList'] = []; $view['allNodes'] = ''; return Response::view('user.nodeList', $view); } // 获取当前用户可用节点 $nodeList = DB::table('ss_node') ->selectRaw('ss_node.*') ->leftJoin('ss_node_label', 'ss_node.id', '=', 'ss_node_label.node_id') ->whereIn('ss_node_label.label_id', $userLabelIds) ->where('ss_node.status', 1) ->groupBy('ss_node.id') ->orderBy('ss_node.sort', 'desc') ->orderBy('ss_node.id', 'asc') ->get(); $allNodes = ''; // 全部节点SSR链接,用于一键复制所有节点 foreach ($nodeList as &$node) { // 获取分组名称 $group = SsGroup::query()->where('id', $node->group_id)->first(); if ($node->type == 1) { // 生成ssr scheme $obfs_param = Auth::user()->obfs_param ? Auth::user()->obfs_param : $node->obfs_param; $protocol_param = $node->single ? Auth::user()->port . ':' . Auth::user()->passwd : Auth::user()->protocol_param; $ssr_str = ($node->server ? $node->server : $node->ip) . ':' . ($node->single ? $node->single_port : Auth::user()->port); $ssr_str .= ':' . ($node->single ? $node->single_protocol : Auth::user()->protocol) . ':' . ($node->single ? $node->single_method : Auth::user()->method); $ssr_str .= ':' . ($node->single ? $node->single_obfs : Auth::user()->obfs) . ':' . ($node->single ? base64url_encode($node->single_passwd) : base64url_encode(Auth::user()->passwd)); $ssr_str .= '/?obfsparam=' . base64url_encode($obfs_param); $ssr_str .= '&protoparam=' . ($node->single ? base64url_encode(Auth::user()->port . ':' . Auth::user()->passwd) : base64url_encode($protocol_param)); $ssr_str .= '&remarks=' . base64url_encode($node->name); $ssr_str .= '&group=' . base64url_encode(empty($group) ? '' : $group->name); $ssr_str .= '&udpport=0'; $ssr_str .= '&uot=0'; $ssr_str = base64url_encode($ssr_str); $ssr_scheme = 'ssr://' . $ssr_str; // 生成ss scheme $ss_str = Auth::user()->method . ':' . Auth::user()->passwd . '@'; $ss_str .= ($node->server ? $node->server : $node->ip) . ':' . Auth::user()->port; $ss_str = base64url_encode($ss_str) . '#' . 'VPN'; $ss_scheme = 'ss://' . $ss_str; // 生成文本配置信息 $txt = "服务器:" . ($node->server ? $node->server : $node->ip) . PHP_EOL; if ($node->ipv6) { $txt .= "IPv6:" . $node->ipv6 . PHP_EOL; } $txt .= "远程端口:" . ($node->single ? $node->single_port : Auth::user()->port) . PHP_EOL; $txt .= "密码:" . ($node->single ? $node->single_passwd : Auth::user()->passwd) . PHP_EOL; $txt .= "加密方法:" . ($node->single ? $node->single_method : Auth::user()->method) . PHP_EOL; $txt .= "路由:绕过局域网及中国大陆地址" . PHP_EOL . PHP_EOL; $txt .= "协议:" . ($node->single ? $node->single_protocol : Auth::user()->protocol) . PHP_EOL; $txt .= "协议参数:" . ($node->single ? Auth::user()->port . ':' . Auth::user()->passwd : Auth::user()->protocol_param) . PHP_EOL; $txt .= "混淆方式:" . ($node->single ? $node->single_obfs : Auth::user()->obfs) . PHP_EOL; $txt .= "混淆参数:" . (Auth::user()->obfs_param ? Auth::user()->obfs_param : $node->obfs_param) . PHP_EOL; $txt .= "本地端口:1080" . PHP_EOL; $node->txt = $txt; $node->ssr_scheme = $ssr_scheme; $node->ss_scheme = $node->compatible ? $ss_scheme : ''; // 节点兼容原版才显示 $allNodes .= $ssr_scheme . '|'; } else { // 生成v2ray scheme $v2_json = [ "v" => "2", "ps" => $node->name, "add" => $node->server ? $node->server : $node->ip, "port" => $node->v2_port, "id" => Auth::user()->vmess_id, "aid" => $node->v2_alter_id, "net" => $node->v2_net, "type" => $node->v2_type, "host" => $node->v2_host, "path" => $node->v2_path, "tls" => $node->v2_tls == 1 ? "tls" : "" ]; $v2_scheme = 'vmess://' . base64url_encode(json_encode($v2_json, JSON_PRETTY_PRINT)); // 生成文本配置信息 $txt = "服务器:" . ($node->server ? $node->server : $node->ip) . PHP_EOL; if ($node->ipv6) { $txt .= "IPv6:" . $node->ipv6 . PHP_EOL; } $txt .= "端口:" . $node->v2_port . PHP_EOL; $txt .= "加密方式:" . $node->v2_method . PHP_EOL; $txt .= "用户ID:" . Auth::user()->vmess_id . PHP_EOL; $txt .= "额外ID:" . $node->v2_alter_id . PHP_EOL; $txt .= "传输协议:" . $node->v2_net . PHP_EOL; $txt .= "伪装类型:" . $node->v2_type . PHP_EOL; $txt .= $node->v2_host ? "伪装域名:" . $node->v2_host . PHP_EOL : ""; $txt .= $node->v2_path ? "路径:" . $node->v2_path . PHP_EOL : ""; $txt .= $node->v2_tls ? "TLS:tls" . PHP_EOL : ""; $node->txt = $txt; $node->v2_scheme = $v2_scheme; } // 节点在线状态 $nodeInfo = SsNodeInfo::query()->where('node_id', $node->id)->where('log_time', '>=', strtotime("-10 minutes"))->orderBy('id', 'desc')->first(); $node->online_status = empty($nodeInfo) || empty($nodeInfo->load) ? 0 : 1; // 节点标签 $node->labels = SsNodeLabel::query()->with('labelInfo')->where('node_id', $node->id)->first(); } $view['allNodes'] = rtrim($allNodes, "|"); $view['nodeList'] = $nodeList; return Response::view('user.nodeList', $view); } // 公告详情 public function article(Request $request) { $view['info'] = Article::query()->findOrFail($request->id); return Response::view('user.article', $view); } // 修改个人资料 public function profile(Request $request) { if ($request->isMethod('POST')) { $old_password = trim($request->input('old_password')); $new_password = trim($request->input('new_password')); $wechat = $request->input('wechat'); $qq = $request->input('qq'); $passwd = trim($request->input('passwd')); // 修改密码 if ($old_password && $new_password) { if (!Hash::check($old_password, Auth::user()->password)) { return Redirect::to('profile#tab_1')->withErrors('旧密码错误,请重新输入'); } elseif (Hash::check($new_password, Auth::user()->password)) { return Redirect::to('profile#tab_1')->withErrors('新密码不可与旧密码一样,请重新输入'); } // 演示环境禁止改管理员密码 if (env('APP_DEMO') && Auth::user()->id == 1) { return Redirect::to('profile#tab_1')->withErrors('演示环境禁止修改管理员密码'); } $ret = User::uid()->update(['password' => Hash::make($new_password)]); if (!$ret) { return Redirect::to('profile#tab_1')->withErrors('修改失败'); } else { return Redirect::to('profile#tab_1')->with('successMsg', '修改成功'); } } // 修改联系方式 if ($wechat || $qq) { if (empty(clean($wechat)) && empty(clean($qq))) { return Redirect::to('profile#tab_2')->withErrors('修改失败'); } $ret = User::uid()->update(['wechat' => $wechat, 'qq' => $qq]); if (!$ret) { return Redirect::to('profile#tab_2')->withErrors('修改失败'); } else { return Redirect::to('profile#tab_2')->with('successMsg', '修改成功'); } } // 修改代理密码 if ($passwd) { $ret = User::uid()->update(['passwd' => $passwd]); if (!$ret) { return Redirect::to('profile#tab_3')->withErrors('修改失败'); } else { return Redirect::to('profile#tab_3')->with('successMsg', '修改成功'); } } return Redirect::to('profile#tab_1')->withErrors('非法请求'); } else { return Response::view('user.profile'); } } // 商品列表 public function services(Request $request) { $user = User::uid()->first(); $view['user_balance'] = $user->balance; // 余额充值商品,只取10个 $view['chargeGoodsList'] = Goods::type(3)->where('status', 1)->orderBy('price', 'asc')->orderBy('price', 'asc')->limit(10)->get(); $view['goodsList'] = Goods::query()->where('status', 1)->where('type', '<=', '2')->orderBy('type', 'desc')->orderBy('sort', 'desc')->paginate(10)->appends($request->except('page')); return Response::view('user.services', $view); } // 工单 public function ticketList(Request $request) { $view['ticketList'] = Ticket::uid()->orderBy('id', 'desc')->paginate(10)->appends($request->except('page')); return Response::view('user.ticketList', $view); } // 订单 public function invoices(Request $request) { $view['orderList'] = Order::uid()->with(['user', 'goods', 'coupon', 'payment'])->orderBy('oid', 'desc')->paginate(10)->appends($request->except('page')); return Response::view('user.invoices', $view); } // 订单明细 public function invoiceDetail(Request $request, $sn) { $view['order'] = Order::uid()->with(['goods', 'coupon', 'payment'])->where('order_sn', $sn)->firstOrFail(); return Response::view('user.invoiceDetail', $view); } // 添加工单 public function addTicket(Request $request) { $title = $request->input('title'); $content = clean($request->input('content')); $content = str_replace("eval", "", str_replace("atob", "", $content)); if (empty($title) || empty($content)) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '请输入标题和内容']); } $obj = new Ticket(); $obj->user_id = Auth::user()->id; $obj->title = $title; $obj->content = $content; $obj->status = 0; $obj->save(); if ($obj->id) { $emailTitle = "新工单提醒"; $content = "标题:【" . $title . "】
内容:" . $content; // 发邮件通知管理员 if (self::$systemConfig['crash_warning_email']) { $logId = Helpers::addEmailLog(self::$systemConfig['crash_warning_email'], $emailTitle, $content); Mail::to(self::$systemConfig['crash_warning_email'])->send(new newTicket($logId, $emailTitle, $content)); } ServerChan::send($emailTitle, $content); return Response::json(['status' => 'success', 'data' => '', 'message' => '提交成功']); } else { return Response::json(['status' => 'fail', 'data' => '', 'message' => '提交失败']); } } // 回复工单 public function replyTicket(Request $request) { $id = intval($request->input('id')); $ticket = Ticket::uid()->with('user')->where('id', $id)->firstOrFail(); if ($request->isMethod('POST')) { $content = clean($request->input('content')); $content = str_replace("eval", "", str_replace("atob", "", $content)); $content = substr($content, 0, 300); if (empty($content)) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '回复内容不能为空']); } $obj = new TicketReply(); $obj->ticket_id = $id; $obj->user_id = Auth::user()->id; $obj->content = $content; $obj->save(); if ($obj->id) { // 重新打开工单 $ticket->status = 0; $ticket->save(); $title = "工单回复提醒"; $content = "标题:【" . $ticket->title . "】
用户回复:" . $content; // 发邮件通知管理员 if (self::$systemConfig['crash_warning_email']) { $logId = Helpers::addEmailLog(self::$systemConfig['crash_warning_email'], $title, $content); Mail::to(self::$systemConfig['crash_warning_email'])->send(new replyTicket($logId, $title, $content)); } ServerChan::send($title, $content); return Response::json(['status' => 'success', 'data' => '', 'message' => '回复成功']); } else { return Response::json(['status' => 'fail', 'data' => '', 'message' => '回复失败']); } } else { $view['ticket'] = $ticket; $view['replyList'] = TicketReply::query()->where('ticket_id', $id)->with('user')->orderBy('id', 'asc')->get(); return Response::view('user.replyTicket', $view); } } // 关闭工单 public function closeTicket(Request $request) { $id = $request->input('id'); $ret = Ticket::uid()->where('id', $id)->update(['status' => 2]); if ($ret) { ServerChan::send('工单关闭提醒', '工单:ID' . $id . '用户已手动关闭'); return Response::json(['status' => 'success', 'data' => '', 'message' => '关闭成功']); } else { return Response::json(['status' => 'fail', 'data' => '', 'message' => '关闭失败']); } } // 邀请码 public function invite(Request $request) { if (Order::uid()->where('status', 2)->where('is_expire', 0)->where('origin_amount', '>', 0)->get()->isEmpty()) { return Response::view('auth.error', ['message' => '本功能对非付费用户禁用!请 返回']); } $view['inviteList'] = Invite::uid()->with(['generator', 'user'])->paginate(10); // 邀请码列表 $view['referral_traffic'] = flowAutoShow(self::$systemConfig['referral_traffic'] * 1048576); $view['referral_percent'] = self::$systemConfig['referral_percent']; return Response::view('user.invite', $view); } // 生成邀请码 public function makeInvite(Request $request) { if (!Auth::user()->invite_num) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '生成失败:邀请码数量不足']); } DB::beginTransaction(); try { // 生成邀请码 $obj = new Invite(); $obj->uid = Auth::user()->id; $obj->fuid = 0; $obj->code = strtoupper(mb_substr(md5(microtime() . makeRandStr()), 8, 12)); $obj->status = 0; $obj->dateline = date('Y-m-d H:i:s', strtotime("+" . self::$systemConfig['user_invite_days'] . " days")); $obj->save(); // 扣减邀请码数 User::uid()->decrement('invite_num', 1); DB::commit(); return Response::json(['status' => 'success', 'data' => '', 'message' => '生成成功']); } catch (Exception $e) { Log::info("用户生成邀请码异常:" . $e); DB::rollBack(); return Response::json(['status' => 'fail', 'data' => '', 'message' => '生成失败:邀请码数量不足']); } } // 使用优惠券 public function redeemCoupon(Request $request) { $coupon_sn = $request->input('coupon_sn'); if (empty($coupon_sn)) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '优惠券不能为空']); } $coupon = Coupon::query()->where('sn', $coupon_sn)->whereIn('type', [1, 2])->first(); if (!$coupon) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券不存在']); } elseif ($coupon->status == 1) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已使用,请换一个试试']); } elseif ($coupon->status == 2) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已失效,请换一个试试']); } elseif ($coupon->available_end < time()) { $coupon->status = 2; $coupon->save(); return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已失效,请换一个试试']); } elseif ($coupon->available_start > time()) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券尚不可用,请换一个试试']); } $data = [ 'type' => $coupon->type, 'amount' => $coupon->amount, 'discount' => $coupon->discount ]; return Response::json(['status' => 'success', 'data' => $data, 'message' => '该优惠券有效']); } // 购买服务 public function buy(Request $request, $id) { $goods_id = intval($id); $coupon_sn = $request->input('coupon_sn'); // 余额支付 if ($request->isMethod('POST')) { $goods = Goods::query()->with(['label'])->where('status', 1)->where('id', $goods_id)->first(); if (!$goods) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:商品或服务已下架']); } // 限购控制:all-所有商品限购, free-价格为0的商品限购, none-不限购(默认) $strategy = self::$systemConfig['goods_purchase_limit_strategy']; if ($strategy == 'all' || ($strategy == 'package' && $goods->type == 2) || ($strategy == 'free' && $goods->price == 0) || ($strategy == 'package&free' && ($goods->type == 2 || $goods->price == 0))) { $noneExpireGoodExist = Order::uid()->where('status', '>=', 0)->where('is_expire', 0)->where('goods_id', $goods_id)->exists(); if ($noneExpireGoodExist) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:商品不可重复购买']); } } // 单个商品限购 if ($goods->is_limit == 1) { $noneExpireOrderExist = Order::uid()->where('status', '>=', 0)->where('goods_id', $goods_id)->exists(); if ($noneExpireOrderExist) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '创建支付单失败:此商品每人限购1次']); } } // 使用优惠券 if (!empty($coupon_sn)) { $coupon = Coupon::query()->where('status', 0)->whereIn('type', [1, 2])->where('sn', $coupon_sn)->first(); if (empty($coupon)) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '优惠券不存在']); } // 计算实际应支付总价 $amount = $coupon->type == 2 ? $goods->price * $coupon->discount / 10 : $goods->price - $coupon->amount; $amount = $amount > 0 ? $amount : 0; } else { $amount = $goods->price; } // 价格异常判断 if ($amount < 0) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:订单总价异常']); } // 验证账号余额是否充足 $user = User::uid()->first(); if ($user->balance < $amount) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:您的余额不足,请先充值']); } // 验证账号是否存在有效期更长的套餐 if ($goods->type == 2) { $existOrderList = Order::uid() ->with(['goods']) ->whereHas('goods', function ($q) { $q->where('type', 2); }) ->where('is_expire', 0) ->where('status', 2) ->get(); foreach ($existOrderList as $vo) { if ($vo->goods->days > $goods->days) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:您已存在有效期更长的套餐,只能购买流量包']); } } } DB::beginTransaction(); try { // 生成订单 $order = new Order(); $order->order_sn = date('ymdHis') . mt_rand(100000, 999999); $order->user_id = $user->id; $order->goods_id = $goods_id; $order->coupon_id = !empty($coupon) ? $coupon->id : 0; $order->origin_amount = $goods->price; $order->amount = $amount; $order->expire_at = date("Y-m-d H:i:s", strtotime("+" . $goods->days . " days")); $order->is_expire = 0; $order->pay_way = 1; $order->status = 2; $order->save(); // 扣余额 User::query()->where('id', $user->id)->decrement('balance', $amount * 100); // 记录余额操作日志 $this->addUserBalanceLog($user->id, $order->oid, $user->balance, $user->balance - $amount, -1 * $amount, '购买服务:' . $goods->name); // 优惠券置为已使用 if (!empty($coupon)) { if ($coupon->usage == 1) { $coupon->status = 1; $coupon->save(); } // 写入日志 Helpers::addCouponLog($coupon->id, $goods_id, $order->oid, '余额支付订单使用'); } // 如果买的是套餐,则先将之前购买的所有套餐置都无效,并扣掉之前所有套餐的流量,重置用户已用流量为0 if ($goods->type == 2) { $existOrderList = Order::query() ->with(['goods']) ->whereHas('goods', function ($q) { $q->where('type', 2); }) ->where('user_id', $order->user_id) ->where('oid', '<>', $order->oid) ->where('is_expire', 0) ->where('status', 2) ->get(); foreach ($existOrderList as $vo) { Order::query()->where('oid', $vo->oid)->update(['is_expire' => 1]); // 先判断,防止手动扣减过流量的用户流量被扣成负数 if ($order->user->transfer_enable - $vo->goods->traffic * 1048576 <= 0) { // 写入用户流量变动记录 Helpers::addUserTrafficModifyLog($user->id, $order->oid, 0, 0, '[余额支付]用户购买套餐,先扣减之前套餐的流量(扣完)'); User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => 0]); } else { // 写入用户流量变动记录 $user = User::query()->where('id', $user->id)->first(); // 重新取出user信息 Helpers::addUserTrafficModifyLog($user->id, $order->oid, $user->transfer_enable, ($user->transfer_enable - $vo->goods->traffic * 1048576), '[余额支付]用户购买套餐,先扣减之前套餐的流量(未扣完)'); User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0]); User::query()->where('id', $order->user_id)->decrement('transfer_enable', $vo->goods->traffic * 1048576); } } } // 写入用户流量变动记录 $user = User::query()->where('id', $user->id)->first(); // 重新取出user信息 Helpers::addUserTrafficModifyLog($user->id, $order->oid, $user->transfer_enable, ($user->transfer_enable + $goods->traffic * 1048576), '[余额支付]用户购买商品,加上流量'); // 把商品的流量加到账号上 User::query()->where('id', $user->id)->increment('transfer_enable', $goods->traffic * 1048576); // 计算账号过期时间 if ($user->expire_time < date('Y-m-d', strtotime("+" . $goods->days . " days"))) { $expireTime = date('Y-m-d', strtotime("+" . $goods->days . " days")); } else { $expireTime = $user->expire_time; } // 套餐就改流量重置日,流量包不改 if ($goods->type == 2) { $traffic_reset_day = date('d'); User::query()->where('id', $order->user_id)->update(['traffic_reset_day' => $traffic_reset_day, 'expire_time' => $expireTime, 'enable' => 1]); } else { User::query()->where('id', $order->user_id)->update(['expire_time' => $expireTime, 'enable' => 1]); } // 写入用户标签 if ($goods->label) { // 用户默认标签 $defaultLabels = []; if (self::$systemConfig['initial_labels_for_user']) { $defaultLabels = explode(',', self::$systemConfig['initial_labels_for_user']); } // 取出现有的标签 $userLabels = UserLabel::query()->where('user_id', $user->id)->pluck('label_id')->toArray(); $goodsLabels = GoodsLabel::query()->where('goods_id', $goods_id)->pluck('label_id')->toArray(); // 标签去重 $newUserLabels = array_values(array_unique(array_merge($userLabels, $goodsLabels, $defaultLabels))); // 删除用户所有标签 UserLabel::query()->where('user_id', $user->id)->delete(); // 生成标签 foreach ($newUserLabels as $vo) { $obj = new UserLabel(); $obj->user_id = $user->id; $obj->label_id = $vo; $obj->save(); } } // 写入返利日志 if ($user->referral_uid) { $this->addReferralLog($user->id, $user->referral_uid, $order->oid, $amount, $amount * self::$systemConfig['referral_percent']); } // 增加用户邀请码数量 if ($goods->invite_num) { User::uid()->increment('invite_num', $goods->invite_num); } // 取消重复返利 User::query()->where('id', $order->user_id)->update(['referral_uid' => 0]); DB::commit(); return Response::json(['status' => 'success', 'data' => '', 'message' => '支付成功']); } catch (\Exception $e) { DB::rollBack(); Log::error('支付订单失败:' . $e->getMessage()); return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:' . $e->getMessage()]); } } else { $goods = Goods::query()->where('id', $goods_id)->where('status', 1)->first(); if (empty($goods)) { return Redirect::to('services'); } $view['goods'] = $goods; return Response::view('user.buy', $view); } } // 推广返利 public function referral(Request $request) { if (Order::uid()->where('status', 2)->where('is_expire', 0)->where('origin_amount', '>', 0)->get()->isEmpty()) { return Response::view('auth.error', ['message' => '本功能对非付费用户禁用!请 返回']); } $view['referral_traffic'] = flowAutoShow(self::$systemConfig['referral_traffic'] * 1048576); $view['referral_percent'] = self::$systemConfig['referral_percent']; $view['referral_money'] = self::$systemConfig['referral_money']; $view['totalAmount'] = ReferralLog::uid()->sum('ref_amount') / 100; $view['canAmount'] = ReferralLog::uid()->where('status', 0)->sum('ref_amount') / 100; $view['link'] = self::$systemConfig['website_url'] . '/register?aff=' . Auth::user()->id; $view['referralLogList'] = ReferralLog::uid()->with('user')->orderBy('id', 'desc')->paginate(10); $view['referralApplyList'] = ReferralApply::uid()->with('user')->orderBy('id', 'desc')->paginate(10); $view['referralUserList'] = User::query()->select(['username', 'created_at'])->where('referral_uid', Auth::user()->id)->orderBy('id', 'desc')->paginate(10); return Response::view('user.referral', $view); } // 申请提现 public function extractMoney(Request $request) { // 判断账户是否过期 if (Auth::user()->expire_time < date('Y-m-d')) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:账号已过期,请先购买服务吧']); } // 判断是否已存在申请 $referralApply = ReferralApply::uid()->whereIn('status', [0, 1])->first(); if ($referralApply) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:已存在申请,请等待之前的申请处理完']); } // 校验可以提现金额是否超过系统设置的阀值 $ref_amount = ReferralLog::uid()->where('status', 0)->sum('ref_amount'); $ref_amount = $ref_amount / 100; if ($ref_amount < self::$systemConfig['referral_money']) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:满' . self::$systemConfig['referral_money'] . '元才可以提现,继续努力吧']); } // 取出本次申请关联返利日志ID $link_logs = ''; $referralLog = ReferralLog::uid()->where('status', 0)->get(); foreach ($referralLog as $log) { $link_logs .= $log->id . ','; } $link_logs = rtrim($link_logs, ','); $obj = new ReferralApply(); $obj->user_id = Auth::user()->id; $obj->before = $ref_amount; $obj->after = 0; $obj->amount = $ref_amount; $obj->link_logs = $link_logs; $obj->status = 0; $obj->save(); return Response::json(['status' => 'success', 'data' => '', 'message' => '申请成功,请等待管理员审核']); } // 帮助中心 public function help(Request $request) { $view['articleList'] = Article::type(1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->limit(10)->paginate(5); //付费用户判断 $view['is_paying_user'] = Order::uid()->where('status', 2)->where('is_expire', 0)->where('origin_amount', '>', 0)->get()->isEmpty(); //客户端安装 $view['Shadowrocket_install'] = 'itms-services://?action=download-manifest&url=' . self::$systemConfig['website_url'] . '/clients/ipa.plist'; $view['Quantumult_install'] = 'itms-services://?action=download-manifest&url=' . self::$systemConfig['website_url'] . '/ipa.plist'; // 订阅连接 $subscribe = UserSubscribe::query()->where('user_id', Auth::user()->id)->first(); $view['subscribe_status'] = $subscribe->status; $subscribe_link = (self::$systemConfig['subscribe_domain'] ? self::$systemConfig['subscribe_domain'] : self::$systemConfig['website_url']) . '/s/' . $subscribe->code; $view['link'] = $subscribe_link; $view['Shadowrocket_link'] = 'shadowrocket://add/sub://' . base64url_encode($subscribe_link) . '?remarks=' . self::$systemConfig['website_name'] . '-' . self::$systemConfig['website_url']; $view['Shadowrocket_linkQrcode'] = 'sub://' . base64url_encode($subscribe_link) . '#' . base64url_encode(self::$systemConfig['website_name']); $view['Quantumult_linkOut'] = 'quantumult://configuration?server=' . base64url_encode($subscribe_link) . '&filter=' . base64url_encode('https://raw.githubusercontent.com/ConnersHua/Profiles/master/Quantumult/Pro.conf') . '&rejection=' . base64url_encode('https://raw.githubusercontent.com/ConnersHua/Profiles/master/Quantumult/Rejection.conf'); $view['Quantumult_linkIn'] = 'quantumult://configuration?server=' . base64url_encode($subscribe_link) . '&filter=' . base64url_encode('https://raw.githubusercontent.com/ConnersHua/Profiles/master/Quantumult/BacktoCN.conf') . '&rejection=' . base64url_encode('https://raw.githubusercontent.com/ConnersHua/Profiles/master/Quantumult/Rejection.conf'); return Response::view('user.help', $view); } // 更换订阅地址 public function exchangeSubscribe(Request $request) { DB::beginTransaction(); try { // 更换订阅码 UserSubscribe::uid()->update(['code' => Helpers::makeSubscribeCode()]); // 更换连接密码 User::uid()->update(['passwd' => makeRandStr()]); DB::commit(); return Response::json(['status' => 'success', 'data' => '', 'message' => '更换成功']); } catch (\Exception $e) { DB::rollBack(); Log::info("更换订阅地址异常:" . $e->getMessage()); return Response::json(['status' => 'fail', 'data' => '', 'message' => '更换失败' . $e->getMessage()]); } } // 转换成管理员的身份 public function switchToAdmin(Request $request) { if (!Session::has('admin')) { return Response::json(['status' => 'fail', 'data' => '', 'message' => '非法请求']); } // 管理员信息重新写入user Auth::loginUsingId(Session::get('admin')); Session::forget('admin'); return Response::json(['status' => 'success', 'data' => '', 'message' => "身份切换成功"]); } // 卡券余额充值 public function charge(Request $request) { $validator = Validator::make($request->all(), [ 'coupon_sn' => [ 'required', Rule::exists('coupon', 'sn')->where(function ($query) { $query->where('type', 3)->where('status', 0); }), ] ], [ 'coupon_sn.required' => '券码不能为空', 'coupon_sn.exists' => '该券不可用' ]); if ($validator->fails()) { return Response::json(['status' => 'fail', 'data' => '', 'message' => $validator->getMessageBag()->first()]); } $coupon = Coupon::query()->where('sn', $request->input('coupon_sn'))->first(); DB::beginTransaction(); try { // 写入日志 $this->addUserBalanceLog(Auth::user()->id, 0, Auth::user()->balance, Auth::user()->balance + $coupon->amount, $coupon->amount, '用户手动充值 - [充值券:' . $request->input('coupon_sn') . ']'); // 余额充值 User::uid()->increment('balance', $coupon->amount * 100); // 更改卡券状态 $coupon->status = 1; $coupon->save(); // 写入卡券日志 Helpers::addCouponLog($coupon->id, 0, 0, '账户余额充值使用'); DB::commit(); return Response::json(['status' => 'success', 'data' => '', 'message' => '充值成功']); } catch (\Exception $e) { Log::error($e); DB::rollBack(); return Response::json(['status' => 'fail', 'data' => '', 'message' => '充值失败']); } } }