UserController.php 55 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\Helpers;
  4. use App\Components\ServerChan;
  5. use App\Http\Models\Article;
  6. use App\Http\Models\Coupon;
  7. use App\Http\Models\Goods;
  8. use App\Http\Models\GoodsLabel;
  9. use App\Http\Models\Invite;
  10. use App\Http\Models\Level;
  11. use App\Http\Models\Order;
  12. use App\Http\Models\ReferralApply;
  13. use App\Http\Models\ReferralLog;
  14. use App\Http\Models\SsConfig;
  15. use App\Http\Models\SsGroup;
  16. use App\Http\Models\SsNodeInfo;
  17. use App\Http\Models\SsNodeLabel;
  18. use App\Http\Models\Ticket;
  19. use App\Http\Models\TicketReply;
  20. use App\Http\Models\User;
  21. use App\Http\Models\UserLabel;
  22. use App\Http\Models\UserLoginLog;
  23. use App\Http\Models\UserSubscribe;
  24. use App\Http\Models\UserTrafficDaily;
  25. use App\Http\Models\UserTrafficHourly;
  26. use App\Http\Models\Verify;
  27. use App\Mail\activeUser;
  28. use App\Mail\newTicket;
  29. use App\Mail\replyTicket;
  30. use App\Mail\resetPassword;
  31. use Illuminate\Http\Request;
  32. use Redirect;
  33. use Response;
  34. use Session;
  35. use Cache;
  36. use Mail;
  37. use Log;
  38. use DB;
  39. class UserController extends Controller
  40. {
  41. protected static $systemConfig;
  42. function __construct()
  43. {
  44. self::$systemConfig = Helpers::systemConfig();
  45. }
  46. public function index(Request $request)
  47. {
  48. $user = Session::get('user');
  49. $user = User::query()->where('id', $user['id'])->first();
  50. $user->totalTransfer = flowAutoShow($user->transfer_enable);
  51. $user->usedTransfer = flowAutoShow($user->u + $user->d);
  52. $user->usedPercent = $user->transfer_enable > 0 ? round(($user->u + $user->d) / $user->transfer_enable, 2) : 1;
  53. $user->levelName = Level::query()->where('level', $user['level'])->first()['level_name'];
  54. $view['info'] = $user->toArray();
  55. $view['notice'] = Article::query()->where('type', 2)->where('is_del', 0)->orderBy('id', 'desc')->first();
  56. $view['wechat_qrcode'] = self::$systemConfig['wechat_qrcode'];
  57. $view['alipay_qrcode'] = self::$systemConfig['alipay_qrcode'];
  58. $view['login_add_score'] = self::$systemConfig['login_add_score'];
  59. $view['website_logo'] = self::$systemConfig['website_logo'];
  60. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  61. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  62. $view['is_push_bear'] = self::$systemConfig['is_push_bear'];
  63. $view['push_bear_qrcode'] = self::$systemConfig['push_bear_qrcode'];
  64. $view['ipa_list'] = 'itms-services://?action=download-manifest&url=' . self::$systemConfig['website_url'] . '/clients/ipa.plist';
  65. $view['goodsList'] = Goods::query()->where('type', 3)->where('status', 1)->where('is_del', 0)->orderBy('sort', 'desc')->orderBy('price', 'asc')->limit(10)->get(); // 余额充值商品,只取10个
  66. // 推广返利是否可见
  67. if (!Session::has('referral_status')) {
  68. Session::put('referral_status', self::$systemConfig['referral_status']);
  69. }
  70. // 如果没有唯一码则生成一个
  71. $subscribe = UserSubscribe::query()->where('user_id', $user['id'])->first();
  72. if (!$subscribe) {
  73. $code = $this->makeSubscribeCode();
  74. $obj = new UserSubscribe();
  75. $obj->user_id = $user['id'];
  76. $obj->code = $code;
  77. $obj->times = 0;
  78. $obj->save();
  79. } else {
  80. $code = $subscribe->code;
  81. }
  82. $view['subscribe_status'] = !$subscribe ? 1 : $subscribe->status;
  83. $view['link'] = self::$systemConfig['subscribe_domain'] ? self::$systemConfig['subscribe_domain'] . '/s/' . $code : self::$systemConfig['website_url'] . '/s/' . $code;
  84. // 近期登录日志
  85. $view['userLoginLog'] = UserLoginLog::query()->where('user_id', $user['id'])->orderBy('id', 'desc')->limit(10)->get();
  86. // 节点列表
  87. $userLabelIds = UserLabel::query()->where('user_id', $user['id'])->pluck('label_id');
  88. if (empty($userLabelIds)) {
  89. $view['nodeList'] = [];
  90. return Response::view('user.index', $view);
  91. }
  92. $nodeList = DB::table('ss_node')
  93. ->leftJoin('ss_node_label', 'ss_node.id', '=', 'ss_node_label.node_id')
  94. ->whereIn('ss_node_label.label_id', $userLabelIds)
  95. ->where('ss_node.status', 1)
  96. ->groupBy('ss_node.id')
  97. ->orderBy('sort', 'desc')
  98. ->get();
  99. foreach ($nodeList as &$node) {
  100. // 获取分组名称
  101. $group = SsGroup::query()->where('id', $node->group_id)->first();
  102. // 生成ssr scheme
  103. $obfs_param = $user->obfs_param ? $user->obfs_param : $node->obfs_param;
  104. $protocol_param = $node->single ? $user->port . ':' . $user->passwd : $user->protocol_param;
  105. $ssr_str = ($node->server ? $node->server : $node->ip) . ':' . ($node->single ? $node->single_port : $user->port);
  106. $ssr_str .= ':' . ($node->single ? $node->single_protocol : $user->protocol) . ':' . ($node->single ? $node->single_method : $user->method);
  107. $ssr_str .= ':' . ($node->single ? $node->single_obfs : $user->obfs) . ':' . ($node->single ? base64url_encode($node->single_passwd) : base64url_encode($user->passwd));
  108. $ssr_str .= '/?obfsparam=' . base64url_encode($obfs_param);
  109. $ssr_str .= '&protoparam=' . ($node->single ? base64url_encode($user->port . ':' . $user->passwd) : base64url_encode($protocol_param));
  110. $ssr_str .= '&remarks=' . base64url_encode($node->name);
  111. $ssr_str .= '&group=' . base64url_encode(empty($group) ? '' : $group->name);
  112. $ssr_str .= '&udpport=0';
  113. $ssr_str .= '&uot=0';
  114. $ssr_str = base64url_encode($ssr_str);
  115. $ssr_scheme = 'ssr://' . $ssr_str;
  116. // 生成ss scheme
  117. $ss_str = $user->method . ':' . $user->passwd . '@';
  118. $ss_str .= ($node->server ? $node->server : $node->ip) . ':' . $user->port;
  119. $ss_str = base64url_encode($ss_str) . '#' . 'VPN';
  120. $ss_scheme = 'ss://' . $ss_str;
  121. // 生成文本配置信息
  122. $txt = "服务器:" . ($node->server ? $node->server : $node->ip) . "\r\n";
  123. if ($node->ipv6) {
  124. $txt .= "IPv6:" . $node->ipv6 . "\r\n";
  125. }
  126. $txt .= "远程端口:" . ($node->single ? $node->single_port : $user->port) . "\r\n";
  127. $txt .= "密码:" . ($node->single ? $node->single_passwd : $user->passwd) . "\r\n";
  128. $txt .= "加密方法:" . ($node->single ? $node->single_method : $user->method) . "\r\n";
  129. $txt .= "路由:绕过局域网及中国大陆地址" . "\r\n\r\n";
  130. $txt .= "协议:" . ($node->single ? $node->single_protocol : $user->protocol) . "\r\n";
  131. $txt .= "协议参数:" . ($node->single ? $user->port . ':' . $user->passwd : $user->protocol_param) . "\r\n";
  132. $txt .= "混淆方式:" . ($node->single ? $node->single_obfs : $user->obfs) . "\r\n";
  133. $txt .= "混淆参数:" . ($user->obfs_param ? $user->obfs_param : $node->obfs_param) . "\r\n";
  134. $txt .= "本地端口:1080" . "\r\n";
  135. $node->txt = $txt;
  136. $node->ssr_scheme = $ssr_scheme;
  137. $node->ss_scheme = $node->compatible ? $ss_scheme : ''; // 节点兼容原版才显示
  138. // 节点在线状态
  139. $nodeInfo = SsNodeInfo::query()->where('node_id', $node->node_id)->where('log_time', '>=', strtotime("-10 minutes"))->orderBy('id', 'desc')->first();
  140. $node->online_status = empty($nodeInfo) || empty($nodeInfo->load) ? 0 : 1;
  141. // 节点标签
  142. $node->labels = SsNodeLabel::query()->with('labelInfo')->where('node_id', $node->id)->get();
  143. }
  144. $view['nodeList'] = $nodeList;
  145. return Response::view('user.index', $view);
  146. }
  147. // 公告详情
  148. public function article(Request $request)
  149. {
  150. $id = $request->get('id');
  151. $view['info'] = Article::query()->where('is_del', 0)->where('id', $id)->first();
  152. if (empty($view['info'])) {
  153. return Redirect::to('/');
  154. }
  155. $view['website_logo'] = self::$systemConfig['website_logo'];
  156. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  157. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  158. return Response::view('user.article', $view);
  159. }
  160. // 修改个人资料
  161. public function profile(Request $request)
  162. {
  163. $user = Session::get('user');
  164. if ($request->method() == 'POST') {
  165. $old_password = $request->get('old_password');
  166. $new_password = $request->get('new_password');
  167. $wechat = $request->get('wechat');
  168. $qq = $request->get('qq');
  169. $passwd = trim($request->get('passwd'));
  170. $method = $request->get('method');
  171. $protocol = $request->get('protocol');
  172. $obfs = $request->get('obfs');
  173. // 修改密码
  174. if ($old_password && $new_password) {
  175. $old_password = md5(trim($old_password));
  176. $new_password = md5(trim($new_password));
  177. $user = User::query()->where('id', $user['id'])->first();
  178. if ($user->password != $old_password) {
  179. Session::flash('errorMsg', '旧密码错误,请重新输入');
  180. return Redirect::to('profile#tab_1');
  181. } elseif ($user->password == $new_password) {
  182. Session::flash('errorMsg', '新密码不可与旧密码一样,请重新输入');
  183. return Redirect::to('profile#tab_1');
  184. }
  185. // 演示环境禁止改管理员密码
  186. if (env('APP_DEMO') && $user['id'] == 1) {
  187. Session::flash('errorMsg', '演示环境禁止修改管理员密码');
  188. return Redirect::to('profile#tab_1');
  189. }
  190. $ret = User::query()->where('id', $user['id'])->update(['password' => $new_password]);
  191. if (!$ret) {
  192. Session::flash('errorMsg', '修改失败');
  193. return Redirect::to('profile#tab_1');
  194. } else {
  195. Session::flash('successMsg', '修改成功');
  196. return Redirect::to('profile#tab_1');
  197. }
  198. }
  199. // 修改联系方式
  200. if ($wechat || $qq) {
  201. if (empty(clean($wechat)) && empty(clean($qq))) {
  202. Session::flash('errorMsg', '修改失败');
  203. return Redirect::to('profile#tab_2');
  204. }
  205. $ret = User::query()->where('id', $user['id'])->update(['wechat' => $wechat, 'qq' => $qq]);
  206. if (!$ret) {
  207. Session::flash('errorMsg', '修改失败');
  208. return Redirect::to('profile#tab_2');
  209. } else {
  210. Session::flash('successMsg', '修改成功');
  211. return Redirect::to('profile#tab_2');
  212. }
  213. }
  214. // 修改SSR(R)设置
  215. if ($method || $protocol || $obfs) {
  216. if (empty($passwd)) {
  217. Session::flash('errorMsg', '密码不能为空');
  218. return Redirect::to('profile#tab_3');
  219. }
  220. // 加密方式、协议、混淆必须存在
  221. $existMethod = SsConfig::query()->where('type', 1)->where('name', $method)->first();
  222. $existProtocol = SsConfig::query()->where('type', 2)->where('name', $protocol)->first();
  223. $existObfs = SsConfig::query()->where('type', 3)->where('name', $obfs)->first();
  224. if (!$existMethod || !$existProtocol || !$existObfs) {
  225. Session::flash('errorMsg', '非法请求');
  226. return Redirect::to('profile#tab_3');
  227. }
  228. $data = [
  229. 'passwd' => $passwd,
  230. 'method' => $method,
  231. 'protocol' => $protocol,
  232. 'obfs' => $obfs
  233. ];
  234. $ret = User::query()->where('id', $user['id'])->update($data);
  235. if (!$ret) {
  236. Session::flash('errorMsg', '修改失败');
  237. return Redirect::to('profile#tab_3');
  238. } else {
  239. // 更新session
  240. $user = User::query()->where('id', $user['id'])->first()->toArray();
  241. Session::remove('user');
  242. Session::put('user', $user);
  243. Session::flash('successMsg', '修改成功');
  244. return Redirect::to('profile#tab_3');
  245. }
  246. }
  247. } else {
  248. // 加密方式、协议、混淆
  249. $view['method_list'] = Helpers::methodList();
  250. $view['protocol_list'] = Helpers::protocolList();
  251. $view['obfs_list'] = Helpers::obfsList();
  252. $view['info'] = User::query()->where('id', $user['id'])->first();
  253. $view['website_logo'] = self::$systemConfig['website_logo'];
  254. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  255. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  256. return Response::view('user.profile', $view);
  257. }
  258. }
  259. // 流量日志
  260. public function trafficLog(Request $request)
  261. {
  262. $user = Session::get('user');
  263. $dailyData = [];
  264. $hourlyData = [];
  265. // 节点一个月内的流量
  266. $userTrafficDaily = UserTrafficDaily::query()->where('user_id', $user['id'])->where('node_id', 0)->where('created_at', '>=', date('Y-m', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  267. $dailyTotal = date('d', time()) - 1; // 今天不算,减一
  268. $dailyCount = count($userTrafficDaily);
  269. for ($x = 0; $x < ($dailyTotal - $dailyCount); $x++) {
  270. $dailyData[$x] = 0;
  271. }
  272. for ($x = ($dailyTotal - $dailyCount); $x < $dailyTotal; $x++) {
  273. $dailyData[$x] = round($userTrafficDaily[$x - ($dailyTotal - $dailyCount)] / (1024 * 1024 * 1024), 3);
  274. }
  275. // 节点一天内的流量
  276. $userTrafficHourly = UserTrafficHourly::query()->where('user_id', $user['id'])->where('node_id', 0)->where('created_at', '>=', date('Y-m-d', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  277. $hourlyTotal = date('H', time());
  278. $hourlyCount = count($userTrafficHourly);
  279. for ($x = 0; $x < ($hourlyTotal - $hourlyCount); $x++) {
  280. $hourlyData[$x] = 0;
  281. }
  282. for ($x = ($hourlyTotal - $hourlyCount); $x < $hourlyTotal; $x++) {
  283. $hourlyData[$x] = round($userTrafficHourly[$x - ($hourlyTotal - $hourlyCount)] / (1024 * 1024 * 1024), 3);
  284. }
  285. // 本月天数数据
  286. $monthDays = [];
  287. $monthHasDays = date("t");
  288. for ($i = 1; $i <= $monthHasDays; $i++) {
  289. $monthDays[] = $i;
  290. }
  291. $view['trafficDaily'] = "'" . implode("','", $dailyData) . "'";
  292. $view['trafficHourly'] = "'" . implode("','", $hourlyData) . "'";
  293. $view['monthDays'] = "'" . implode("','", $monthDays) . "'";
  294. $view['website_logo'] = self::$systemConfig['website_logo'];
  295. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  296. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  297. return Response::view('user.trafficLog', $view);
  298. }
  299. // 商品列表
  300. public function goodsList(Request $request)
  301. {
  302. $view['goodsList'] = Goods::query()->where('status', 1)->where('is_del', 0)->where('type', '<=', '2')->orderBy('type', 'desc')->orderBy('sort', 'desc')->paginate(10)->appends($request->except('page'));
  303. $view['website_logo'] = self::$systemConfig['website_logo'];
  304. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  305. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  306. return Response::view('user.goodsList', $view);
  307. }
  308. // 工单
  309. public function ticketList(Request $request)
  310. {
  311. $user = Session::get('user');
  312. $view['website_logo'] = self::$systemConfig['website_logo'];
  313. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  314. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  315. $view['ticketList'] = Ticket::query()->where('user_id', $user['id'])->orderBy('id', 'desc')->paginate(10)->appends($request->except('page'));
  316. return Response::view('user.ticketList', $view);
  317. }
  318. // 订单
  319. public function orderList(Request $request)
  320. {
  321. $user = Session::get('user');
  322. $view['orderList'] = Order::query()->with(['user', 'goods', 'coupon', 'payment'])->where('user_id', $user['id'])->orderBy('oid', 'desc')->paginate(10)->appends($request->except('page'));
  323. $view['website_logo'] = self::$systemConfig['website_logo'];
  324. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  325. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  326. return Response::view('user.orderList', $view);
  327. }
  328. // 订单明细
  329. public function orderDetail(Request $request, $sn)
  330. {
  331. $view['website_logo'] = self::$systemConfig['website_logo'];
  332. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  333. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  334. $view['order'] = Order::query()->with(['goods', 'coupon', 'payment'])->where('order_sn', $sn)->firstOrFail();
  335. return Response::view('user.orderDetail', $view);
  336. }
  337. // 添加工单
  338. public function addTicket(Request $request)
  339. {
  340. $title = $request->get('title');
  341. $content = clean($request->get('content'));
  342. $content = str_replace("eval", "", str_replace("atob", "", $content));
  343. $user = Session::get('user');
  344. if (empty($title) || empty($content)) {
  345. return Response::json(['status' => 'fail', 'data' => '', 'message' => '请输入标题和内容']);
  346. }
  347. $obj = new Ticket();
  348. $obj->user_id = $user['id'];
  349. $obj->title = $title;
  350. $obj->content = $content;
  351. $obj->status = 0;
  352. $obj->created_at = date('Y-m-d H:i:s');
  353. $obj->save();
  354. if ($obj->id) {
  355. $emailTitle = "新工单提醒";
  356. $content = "标题:【" . $title . "】<br>内容:" . $content;
  357. // 发邮件通知管理员
  358. if (self::$systemConfig['crash_warning_email']) {
  359. try {
  360. Mail::to(self::$systemConfig['crash_warning_email'])->send(new newTicket(self::$systemConfig['website_name'], $emailTitle, $content));
  361. Helpers::addEmailLog(1, $emailTitle, $content);
  362. } catch (\Exception $e) {
  363. Helpers::addEmailLog(1, $emailTitle, $content, 0, $e->getMessage());
  364. }
  365. }
  366. // 通过ServerChan发微信消息提醒管理员
  367. if (self::$systemConfig['is_server_chan'] && self::$systemConfig['server_chan_key']) {
  368. $serverChan = new ServerChan();
  369. $serverChan->send($emailTitle, $content);
  370. }
  371. return Response::json(['status' => 'success', 'data' => '', 'message' => '提交成功']);
  372. } else {
  373. return Response::json(['status' => 'fail', 'data' => '', 'message' => '提交失败']);
  374. }
  375. }
  376. // 回复工单
  377. public function replyTicket(Request $request)
  378. {
  379. $id = intval($request->get('id'));
  380. $user = Session::get('user');
  381. if ($request->method() == 'POST') {
  382. $content = clean($request->get('content'));
  383. $content = str_replace("eval", "", str_replace("atob", "", $content));
  384. $content = substr($content, 0, 300);
  385. if (empty($content)) {
  386. return Response::json(['status' => 'fail', 'data' => '', 'message' => '回复内容不能为空']);
  387. }
  388. $obj = new TicketReply();
  389. $obj->ticket_id = $id;
  390. $obj->user_id = $user['id'];
  391. $obj->content = $content;
  392. $obj->created_at = date('Y-m-d H:i:s');
  393. $obj->save();
  394. if ($obj->id) {
  395. $ticket = Ticket::query()->where('id', $id)->first();
  396. $title = "工单回复提醒";
  397. $content = "标题:【" . $ticket->title . "】<br>用户回复:" . $content;
  398. // 发邮件通知管理员
  399. if (self::$systemConfig['crash_warning_email']) {
  400. try {
  401. Mail::to(self::$systemConfig['crash_warning_email'])->send(new replyTicket(self::$systemConfig['website_name'], $title, $content));
  402. Helpers::addEmailLog(1, $title, $content);
  403. } catch (\Exception $e) {
  404. Helpers::addEmailLog(1, $title, $content, 0, $e->getMessage());
  405. }
  406. }
  407. // 通过ServerChan发微信消息提醒管理员
  408. if (self::$systemConfig['is_server_chan'] && self::$systemConfig['server_chan_key']) {
  409. $serverChan = new ServerChan();
  410. $serverChan->send($title, $content);
  411. }
  412. return Response::json(['status' => 'success', 'data' => '', 'message' => '回复成功']);
  413. } else {
  414. return Response::json(['status' => 'fail', 'data' => '', 'message' => '回复失败']);
  415. }
  416. } else {
  417. $ticket = Ticket::query()->where('id', $id)->with('user')->first();
  418. if (empty($ticket) || $ticket->user_id != $user['id']) {
  419. return Redirect::to('tickets');
  420. }
  421. $view['ticket'] = $ticket;
  422. $view['replyList'] = TicketReply::query()->where('ticket_id', $id)->with('user')->orderBy('id', 'asc')->get();
  423. $view['website_logo'] = self::$systemConfig['website_logo'];
  424. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  425. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  426. return Response::view('user.replyTicket', $view);
  427. }
  428. }
  429. // 关闭工单
  430. public function closeTicket(Request $request)
  431. {
  432. $id = $request->get('id');
  433. $user = Session::get('user');
  434. $ret = Ticket::query()->where('id', $id)->where('user_id', $user['id'])->update(['status' => 2]);
  435. if ($ret) {
  436. return Response::json(['status' => 'success', 'data' => '', 'message' => '关闭成功']);
  437. } else {
  438. return Response::json(['status' => 'fail', 'data' => '', 'message' => '关闭失败']);
  439. }
  440. }
  441. // 邀请码
  442. public function invite(Request $request)
  443. {
  444. $user = Session::get('user');
  445. // 已生成的邀请码数量
  446. $num = Invite::query()->where('uid', $user['id'])->count();
  447. $view['website_logo'] = self::$systemConfig['website_logo'];
  448. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  449. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  450. $view['num'] = self::$systemConfig['invite_num'] - $num <= 0 ? 0 : self::$systemConfig['invite_num'] - $num; // 还可以生成的邀请码数量
  451. $view['inviteList'] = Invite::query()->where('uid', $user['id'])->with(['generator', 'user'])->paginate(10); // 邀请码列表
  452. $view['referral_traffic'] = flowAutoShow(self::$systemConfig['referral_traffic'] * 1048576);
  453. $view['referral_percent'] = self::$systemConfig['referral_percent'];
  454. return Response::view('user.invite', $view);
  455. }
  456. // 公开的邀请码列表
  457. public function free(Request $request)
  458. {
  459. $view['website_logo'] = self::$systemConfig['website_logo'];
  460. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  461. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  462. $view['is_invite_register'] = self::$systemConfig['is_invite_register'];
  463. $view['is_free_code'] = self::$systemConfig['is_free_code'];
  464. $view['inviteList'] = Invite::query()->where('uid', 0)->where('status', 0)->paginate();
  465. return Response::view('user.free', $view);
  466. }
  467. // 生成邀请码
  468. public function makeInvite(Request $request)
  469. {
  470. $user = Session::get('user');
  471. // 已生成的邀请码数量
  472. $num = Invite::query()->where('uid', $user['id'])->count();
  473. if ($num >= self::$systemConfig['invite_num']) {
  474. return Response::json(['status' => 'fail', 'data' => '', 'message' => '生成失败:最多只能生成' . self::$systemConfig['invite_num'] . '个邀请码']);
  475. }
  476. $obj = new Invite();
  477. $obj->uid = $user['id'];
  478. $obj->fuid = 0;
  479. $obj->code = strtoupper(mb_substr(md5(microtime() . makeRandStr()), 8, 12));
  480. $obj->status = 0;
  481. $obj->dateline = date('Y-m-d H:i:s', strtotime("+7 days"));
  482. $obj->save();
  483. return Response::json(['status' => 'success', 'data' => '', 'message' => '生成成功']);
  484. }
  485. // 激活账号页
  486. public function activeUser(Request $request)
  487. {
  488. if ($request->method() == 'POST') {
  489. $username = trim($request->get('username'));
  490. // 是否开启账号激活
  491. if (!self::$systemConfig['is_active_register']) {
  492. Session::flash('errorMsg', '系统未开启账号激活功能,请联系管理员');
  493. return Redirect::back()->withInput();
  494. }
  495. // 查找账号
  496. $user = User::query()->where('username', $username)->first();
  497. if (!$user) {
  498. Session::flash('errorMsg', '账号不存在,请重试');
  499. return Redirect::back();
  500. } elseif ($user->status < 0) {
  501. Session::flash('errorMsg', '账号已禁止登陆,无需激活');
  502. return Redirect::back();
  503. } elseif ($user->status > 0) {
  504. Session::flash('errorMsg', '账号无需激活');
  505. return Redirect::back();
  506. }
  507. // 24小时内激活次数限制
  508. $activeTimes = 0;
  509. if (Cache::has('activeUser_' . md5($username))) {
  510. $activeTimes = Cache::get('activeUser_' . md5($username));
  511. if ($activeTimes >= self::$systemConfig['active_times']) {
  512. Session::flash('errorMsg', '同一个账号24小时内只能请求激活' . self::$systemConfig['active_times'] . '次,请勿频繁操作');
  513. return Redirect::back();
  514. }
  515. }
  516. // 生成激活账号的地址
  517. $token = md5(self::$systemConfig['website_name'] . $username . microtime());
  518. $verify = new Verify();
  519. $verify->user_id = $user->id;
  520. $verify->username = $username;
  521. $verify->token = $token;
  522. $verify->status = 0;
  523. $verify->save();
  524. // 发送邮件
  525. $activeUserUrl = self::$systemConfig['website_url'] . '/active/' . $token;
  526. $title = '重新激活账号';
  527. $content = '请求地址:' . $activeUserUrl;
  528. try {
  529. Mail::to($user->username)->send(new activeUser(self::$systemConfig['website_name'], $activeUserUrl));
  530. Helpers::addEmailLog($user->id, $title, $content);
  531. } catch (\Exception $e) {
  532. Helpers::addEmailLog($user->id, $title, $content, 0, $e->getMessage());
  533. }
  534. Cache::put('activeUser_' . md5($username), $activeTimes + 1, 1440);
  535. Session::flash('successMsg', '激活邮件已发送,如未收到,请查看垃圾邮箱');
  536. return Redirect::back();
  537. } else {
  538. $view['is_active_register'] = self::$systemConfig['is_active_register'];
  539. return Response::view('user.activeUser', $view);
  540. }
  541. }
  542. // 激活账号
  543. public function active(Request $request, $token)
  544. {
  545. if (empty($token)) {
  546. return Redirect::to('login');
  547. }
  548. $verify = Verify::query()->where('token', $token)->with('user')->first();
  549. if (empty($verify)) {
  550. return Redirect::to('login');
  551. } elseif (empty($verify->user)) {
  552. Session::flash('errorMsg', '该链接已失效');
  553. return Response::view('user.active');
  554. } elseif ($verify->status == 1) {
  555. Session::flash('errorMsg', '该链接已失效');
  556. return Response::view('user.active');
  557. } elseif ($verify->user->status != 0) {
  558. Session::flash('errorMsg', '该账号无需激活.');
  559. return Response::view('user.active');
  560. } elseif (time() - strtotime($verify->created_at) >= 1800) {
  561. Session::flash('errorMsg', '该链接已过期');
  562. // 置为已失效
  563. $verify->status = 2;
  564. $verify->save();
  565. return Response::view('user.active');
  566. }
  567. // 更新账号状态
  568. $ret = User::query()->where('id', $verify->user_id)->update(['status' => 1]);
  569. if (!$ret) {
  570. Session::flash('errorMsg', '账号激活失败');
  571. return Redirect::back();
  572. }
  573. // 置为已使用
  574. $verify->status = 1;
  575. $verify->save();
  576. // 账号激活后给邀请人送流量
  577. if ($verify->user->referral_uid) {
  578. $transfer_enable = self::$systemConfig['referral_traffic'] * 1048576;
  579. User::query()->where('id', $verify->user->referral_uid)->increment('transfer_enable', $transfer_enable);
  580. User::query()->where('id', $verify->user->referral_uid)->update(['enable' => 1]);
  581. }
  582. Session::flash('successMsg', '账号激活成功');
  583. return Response::view('user.active');
  584. }
  585. // 重设密码页
  586. public function resetPassword(Request $request)
  587. {
  588. if ($request->method() == 'POST') {
  589. $username = trim($request->get('username'));
  590. // 是否开启重设密码
  591. if (!self::$systemConfig['is_reset_password']) {
  592. Session::flash('errorMsg', '系统未开启重置密码功能,请联系管理员');
  593. return Redirect::back()->withInput();
  594. }
  595. // 查找账号
  596. $user = User::query()->where('username', $username)->first();
  597. if (!$user) {
  598. Session::flash('errorMsg', '账号不存在,请重试');
  599. return Redirect::back();
  600. }
  601. // 24小时内重设密码次数限制
  602. $resetTimes = 0;
  603. if (Cache::has('resetPassword_' . md5($username))) {
  604. $resetTimes = Cache::get('resetPassword_' . md5($username));
  605. if ($resetTimes >= self::$systemConfig['reset_password_times']) {
  606. Session::flash('errorMsg', '同一个账号24小时内只能重设密码' . self::$systemConfig['reset_password_times'] . '次,请勿频繁操作');
  607. return Redirect::back();
  608. }
  609. }
  610. // 生成取回密码的地址
  611. $token = md5(self::$systemConfig['website_name'] . $username . microtime());
  612. $verify = new Verify();
  613. $verify->user_id = $user->id;
  614. $verify->username = $username;
  615. $verify->token = $token;
  616. $verify->status = 0;
  617. $verify->save();
  618. // 发送邮件
  619. $resetPasswordUrl = self::$systemConfig['website_url'] . '/reset/' . $token;
  620. $title = '重置密码';
  621. $content = '请求地址:' . $resetPasswordUrl;
  622. try {
  623. Mail::to($user->username)->send(new resetPassword(self::$systemConfig['website_name'], $resetPasswordUrl));
  624. Helpers::addEmailLog($user->id, $title, $content);
  625. } catch (\Exception $e) {
  626. Helpers::addEmailLog($user->id, $title, $content, 0, $e->getMessage());
  627. }
  628. Cache::put('resetPassword_' . md5($username), $resetTimes + 1, 1440);
  629. Session::flash('successMsg', '重置成功,请查看邮箱');
  630. return Redirect::back();
  631. } else {
  632. $view['website_home_logo'] = self::$systemConfig['website_home_logo'];
  633. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  634. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  635. $view['is_reset_password'] = self::$systemConfig['is_reset_password'];
  636. return Response::view('user.resetPassword', $view);
  637. }
  638. }
  639. // 重设密码
  640. public function reset(Request $request, $token)
  641. {
  642. if ($request->method() == 'POST') {
  643. $password = trim($request->get('password'));
  644. $repassword = trim($request->get('repassword'));
  645. if (empty($token)) {
  646. return Redirect::to('login');
  647. } elseif (empty($password) || empty($repassword)) {
  648. Session::flash('errorMsg', '密码不能为空');
  649. return Redirect::back();
  650. } elseif (md5($password) != md5($repassword)) {
  651. Session::flash('errorMsg', '两次输入密码不一致,请重新输入');
  652. return Redirect::back();
  653. }
  654. // 校验账号
  655. $verify = Verify::query()->where('token', $token)->with('User')->first();
  656. if (empty($verify)) {
  657. return Redirect::to('login');
  658. } elseif ($verify->status == 1) {
  659. Session::flash('errorMsg', '该链接已失效');
  660. return Redirect::back();
  661. } elseif ($verify->user->status < 0) {
  662. Session::flash('errorMsg', '账号已被禁用');
  663. return Redirect::back();
  664. } elseif (md5($password) == $verify->user->password) {
  665. Session::flash('errorMsg', '新旧密码一样,请重新输入');
  666. return Redirect::back();
  667. }
  668. // 更新密码
  669. $ret = User::query()->where('id', $verify->user_id)->update(['password' => md5($password)]);
  670. if (!$ret) {
  671. Session::flash('errorMsg', '重设密码失败');
  672. return Redirect::back();
  673. }
  674. // 置为已使用
  675. $verify->status = 1;
  676. $verify->save();
  677. Session::flash('successMsg', '新密码设置成功,请自行登录');
  678. return Redirect::back();
  679. } else {
  680. if (empty($token)) {
  681. return Redirect::to('login');
  682. }
  683. $verify = Verify::query()->where('token', $token)->with('user')->first();
  684. if (empty($verify)) {
  685. return Redirect::to('login');
  686. } elseif (time() - strtotime($verify->created_at) >= 1800) {
  687. Session::flash('errorMsg', '该链接已过期');
  688. // 置为已失效
  689. $verify->status = 2;
  690. $verify->save();
  691. // 重新获取一遍verify
  692. $view['verify'] = Verify::query()->where('token', $token)->with('user')->first();
  693. return Response::view('user.reset', $view);
  694. }
  695. $view['website_home_logo'] = self::$systemConfig['website_home_logo'];
  696. $view['verify'] = $verify;
  697. return Response::view('user.reset', $view);
  698. }
  699. }
  700. // 使用优惠券
  701. public function redeemCoupon(Request $request)
  702. {
  703. $coupon_sn = $request->get('coupon_sn');
  704. if (empty($coupon_sn)) {
  705. return Response::json(['status' => 'fail', 'data' => '', 'message' => '优惠券不能为空']);
  706. }
  707. $coupon = Coupon::query()->where('sn', $coupon_sn)->whereIn('type', [1, 2])->where('is_del', 0)->first();
  708. if (!$coupon) {
  709. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券不存在']);
  710. } elseif ($coupon->status == 1) {
  711. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已使用,请换一个试试']);
  712. } elseif ($coupon->status == 2) {
  713. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已失效,请换一个试试']);
  714. } elseif ($coupon->available_start > time() || $coupon->available_end < time()) {
  715. $coupon->status = 2;
  716. $coupon->save();
  717. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该优惠券已失效,请换一个试试']);
  718. }
  719. $data = [
  720. 'type' => $coupon->type,
  721. 'amount' => $coupon->amount,
  722. 'discount' => $coupon->discount
  723. ];
  724. return Response::json(['status' => 'success', 'data' => $data, 'message' => '该优惠券有效']);
  725. }
  726. // 购买服务
  727. public function buy(Request $request, $id)
  728. {
  729. $goods_id = intval($id);
  730. $coupon_sn = $request->get('coupon_sn');
  731. $user = Session::get('user');
  732. if ($request->method() == 'POST') {
  733. $goods = Goods::query()->with(['label'])->where('is_del', 0)->where('status', 1)->where('id', $goods_id)->first();
  734. if (!$goods) {
  735. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:商品或服务已下架']);
  736. }
  737. // 限购控制:all-所有商品限购, free-价格为0的商品限购, none-不限购(默认)
  738. $strategy = self::$systemConfig['goods_purchase_limit_strategy'];
  739. if ($strategy == 'all' || ($strategy == 'package' && $goods->type == 2) || ($strategy == 'free' && $goods->price == 0) || ($strategy == 'package&free' && ($goods->type == 2 || $goods->price == 0))) {
  740. $noneExpireGoodExist = Order::query()->where('status', '>=', 0)->where('is_expire', 0)->where('user_id', $user['id'])->where('goods_id', $goods_id)->exists();
  741. if ($noneExpireGoodExist) {
  742. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:商品不可重复购买']);
  743. }
  744. }
  745. // 使用优惠券
  746. if (!empty($coupon_sn)) {
  747. $coupon = Coupon::query()->where('status', 0)->where('is_del', 0)->whereIn('type', [1, 2])->where('sn', $coupon_sn)->first();
  748. if (empty($coupon)) {
  749. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:优惠券不存在']);
  750. }
  751. // 计算实际应支付总价
  752. $amount = $coupon->type == 2 ? $goods->price * $coupon->discount / 10 : $goods->price - $coupon->amount;
  753. $amount = $amount > 0 ? $amount : 0;
  754. } else {
  755. $amount = $goods->price;
  756. }
  757. // 价格异常判断
  758. if ($amount < 0) {
  759. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:订单总价异常']);
  760. }
  761. // 验证账号余额是否充足
  762. $user = User::query()->where('id', $user['id'])->first();
  763. if ($user->balance < $amount) {
  764. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:您的余额不足,请先充值']);
  765. }
  766. // 验证账号是否存在有效期更长的套餐
  767. if ($goods->type == 2) {
  768. $existOrderList = Order::query()
  769. ->with(['goods'])
  770. ->whereHas('goods', function ($q) {
  771. $q->where('type', 2);
  772. })
  773. ->where('user_id', $user['id'])
  774. ->where('is_expire', 0)
  775. ->where('status', 2)
  776. ->get();
  777. foreach ($existOrderList as $vo) {
  778. if ($vo->goods->days > $goods->days) {
  779. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:您已存在有效期更长的套餐,只能购买流量包']);
  780. }
  781. }
  782. }
  783. DB::beginTransaction();
  784. try {
  785. // 生成订单
  786. $order = new Order();
  787. $order->order_sn = date('ymdHis') . mt_rand(100000, 999999);
  788. $order->user_id = $user->id;
  789. $order->goods_id = $goods_id;
  790. $order->coupon_id = !empty($coupon) ? $coupon->id : 0;
  791. $order->origin_amount = $goods->price;
  792. $order->amount = $amount;
  793. $order->expire_at = date("Y-m-d H:i:s", strtotime("+" . $goods->days . " days"));
  794. $order->is_expire = 0;
  795. $order->pay_way = 1;
  796. $order->status = 2;
  797. $order->save();
  798. // 扣余额
  799. User::query()->where('id', $user->id)->decrement('balance', $amount * 100);
  800. // 记录余额操作日志
  801. $this->addUserBalanceLog($user->id, $order->oid, $user->balance, $user->balance - $amount, -1 * $amount, '购买服务:' . $goods->name);
  802. // 优惠券置为已使用
  803. if (!empty($coupon)) {
  804. if ($coupon->usage == 1) {
  805. $coupon->status = 1;
  806. $coupon->save();
  807. }
  808. // 写入日志
  809. Helpers::addCouponLog($coupon->id, $goods_id, $order->oid, '余额支付订单使用');
  810. }
  811. // 如果买的是套餐,则先将之前购买的所有套餐置都无效,并扣掉之前所有套餐的流量,重置用户已用流量为0
  812. if ($goods->type == 2) {
  813. $existOrderList = Order::query()
  814. ->with(['goods'])
  815. ->whereHas('goods', function ($q) {
  816. $q->where('type', 2);
  817. })
  818. ->where('user_id', $order->user_id)
  819. ->where('oid', '<>', $order->oid)
  820. ->where('is_expire', 0)
  821. ->where('status', 2)
  822. ->get();
  823. foreach ($existOrderList as $vo) {
  824. Order::query()->where('oid', $vo->oid)->update(['is_expire' => 1]);
  825. // 先判断,防止手动扣减过流量的用户流量被扣成负数
  826. if ($order->user->transfer_enable - $vo->goods->traffic * 1048576 <= 0) {
  827. User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => 0]);
  828. } else {
  829. User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0]);
  830. User::query()->where('id', $order->user_id)->decrement('transfer_enable', $vo->goods->traffic * 1048576);
  831. }
  832. }
  833. }
  834. // 把商品的流量加到账号上
  835. User::query()->where('id', $user->id)->increment('transfer_enable', $goods->traffic * 1048576);
  836. // 计算账号过期时间
  837. if ($user->expire_time < date('Y-m-d', strtotime("+" . $goods->days . " days"))) {
  838. $expireTime = date('Y-m-d', strtotime("+" . $goods->days . " days"));
  839. } else {
  840. $expireTime = $user->expire_time;
  841. }
  842. // 套餐就改流量重置日,流量包不改
  843. if ($goods->type == 2) {
  844. if (date('m') == 2 && date('d') == 29) {
  845. $traffic_reset_day = 28;
  846. } else {
  847. $traffic_reset_day = date('d') == 31 ? 30 : abs(date('d'));
  848. }
  849. User::query()->where('id', $order->user_id)->update(['traffic_reset_day' => $traffic_reset_day, 'expire_time' => $expireTime, 'enable' => 1]);
  850. } else {
  851. User::query()->where('id', $order->user_id)->update(['expire_time' => $expireTime, 'enable' => 1]);
  852. }
  853. // 写入用户标签
  854. if ($goods->label) {
  855. // 用户默认标签
  856. $defaultLabels = [];
  857. if (self::$systemConfig['initial_labels_for_user']) {
  858. $defaultLabels = explode(',', self::$systemConfig['initial_labels_for_user']);
  859. }
  860. // 取出现有的标签
  861. $userLabels = UserLabel::query()->where('user_id', $user->id)->pluck('label_id')->toArray();
  862. $goodsLabels = GoodsLabel::query()->where('goods_id', $goods_id)->pluck('label_id')->toArray();
  863. // 标签去重
  864. $newUserLabels = array_values(array_unique(array_merge($userLabels, $goodsLabels, $defaultLabels)));
  865. // 删除用户所有标签
  866. UserLabel::query()->where('user_id', $user->id)->delete();
  867. // 生成标签
  868. foreach ($newUserLabels as $vo) {
  869. $obj = new UserLabel();
  870. $obj->user_id = $user->id;
  871. $obj->label_id = $vo;
  872. $obj->save();
  873. }
  874. }
  875. // 写入返利日志
  876. if ($user->referral_uid) {
  877. $this->addReferralLog($user->id, $user->referral_uid, $order->oid, $amount, $amount * self::$systemConfig['referral_percent']);
  878. }
  879. // 取消重复返利
  880. User::query()->where('id', $order->user_id)->update(['referral_uid' => 0]);
  881. DB::commit();
  882. return Response::json(['status' => 'success', 'data' => '', 'message' => '支付成功']);
  883. } catch (\Exception $e) {
  884. DB::rollBack();
  885. Log::error('支付订单失败:' . $e->getMessage());
  886. return Response::json(['status' => 'fail', 'data' => '', 'message' => '支付失败:' . $e->getMessage()]);
  887. }
  888. } else {
  889. $goods = Goods::query()->where('id', $goods_id)->where('is_del', 0)->where('status', 1)->first();
  890. if (empty($goods)) {
  891. return Redirect::to('services');
  892. }
  893. $view['goods'] = $goods;
  894. $view['is_youzan'] = self::$systemConfig['is_youzan'];
  895. $view['website_logo'] = self::$systemConfig['website_logo'];
  896. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  897. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  898. return Response::view('user.buy', $view);
  899. }
  900. }
  901. // 积分兑换流量
  902. public function exchange(Request $request)
  903. {
  904. $user = Session::get('user');
  905. // 积分满100才可以兑换
  906. if ($user['score'] < 100) {
  907. return Response::json(['status' => 'fail', 'data' => '', 'message' => '兑换失败:满100才可以兑换,请继续累计吧']);
  908. }
  909. // 账号过期不允许兑换
  910. if ($user['expire_time'] < date('Y-m-d')) {
  911. return Response::json(['status' => 'fail', 'data' => '', 'message' => '兑换失败:账号已过期,请先购买服务吧']);
  912. }
  913. DB::beginTransaction();
  914. try {
  915. // 写入积分操作日志
  916. $ret = $this->addUserScoreLog($user['id'], $user['score'], 0, -1 * $user['score'], '积分兑换流量');
  917. // 扣积分加流量
  918. if ($ret) {
  919. User::query()->where('id', $user['id'])->update(['score' => 0]);
  920. User::query()->where('id', $user['id'])->increment('transfer_enable', $user['score'] * 1048576);
  921. }
  922. DB::commit();
  923. // 更新session
  924. $user = User::query()->where('id', $user['id'])->first()->toArray();
  925. Session::remove('user');
  926. Session::put('user', $user);
  927. return Response::json(['status' => 'success', 'data' => '', 'message' => '兑换成功']);
  928. } catch (\Exception $e) {
  929. DB::rollBack();
  930. return Response::json(['status' => 'fail', 'data' => '', 'message' => '兑换失败:' . $e->getMessage()]);
  931. }
  932. }
  933. // 推广返利
  934. public function referral(Request $request)
  935. {
  936. // 生成个人推广链接
  937. $user = Session::get('user');
  938. $view['website_logo'] = self::$systemConfig['website_logo'];
  939. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  940. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  941. $view['referral_traffic'] = flowAutoShow(self::$systemConfig['referral_traffic'] * 1048576);
  942. $view['referral_percent'] = self::$systemConfig['referral_percent'];
  943. $view['referral_money'] = self::$systemConfig['referral_money'];
  944. $view['totalAmount'] = ReferralLog::query()->where('ref_user_id', $user['id'])->sum('ref_amount') / 100;
  945. $view['canAmount'] = ReferralLog::query()->where('ref_user_id', $user['id'])->where('status', 0)->sum('ref_amount') / 100;
  946. $view['link'] = self::$systemConfig['website_url'] . '/register?aff=' . $user['id'];
  947. $view['referralLogList'] = ReferralLog::query()->where('ref_user_id', $user['id'])->with('user')->orderBy('id', 'desc')->paginate(10);
  948. $view['referralApplyList'] = ReferralApply::query()->where('user_id', $user['id'])->with('user')->orderBy('id', 'desc')->paginate(10);
  949. $view['referralUserList'] = User::query()->select(['username', 'created_at'])->where('referral_uid', $user['id'])->orderBy('id', 'desc')->paginate(10);
  950. return Response::view('user.referral', $view);
  951. }
  952. // 申请提现
  953. public function extractMoney(Request $request)
  954. {
  955. $user = Session::get('user');
  956. // 判断账户是否过期
  957. if ($user['expire_time'] < date('Y-m-d')) {
  958. return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:账号已过期,请先购买服务吧']);
  959. }
  960. // 判断是否已存在申请
  961. $referralApply = ReferralApply::query()->where('user_id', $user['id'])->whereIn('status', [0, 1])->first();
  962. if ($referralApply) {
  963. return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:已存在申请,请等待之前的申请处理完']);
  964. }
  965. // 校验可以提现金额是否超过系统设置的阀值
  966. $ref_amount = ReferralLog::query()->where('ref_user_id', $user['id'])->where('status', 0)->sum('ref_amount');
  967. $ref_amount = $ref_amount / 100;
  968. if ($ref_amount < self::$systemConfig['referral_money']) {
  969. return Response::json(['status' => 'fail', 'data' => '', 'message' => '申请失败:满' . self::$systemConfig['referral_money'] . '元才可以提现,继续努力吧']);
  970. }
  971. // 取出本次申请关联返利日志ID
  972. $link_logs = '';
  973. $referralLog = ReferralLog::query()->where('ref_user_id', $user['id'])->where('status', 0)->get();
  974. foreach ($referralLog as $log) {
  975. $link_logs .= $log->id . ',';
  976. }
  977. $link_logs = rtrim($link_logs, ',');
  978. $obj = new ReferralApply();
  979. $obj->user_id = $user['id'];
  980. $obj->before = $ref_amount;
  981. $obj->after = 0;
  982. $obj->amount = $ref_amount;
  983. $obj->link_logs = $link_logs;
  984. $obj->status = 0;
  985. $obj->save();
  986. return Response::json(['status' => 'success', 'data' => '', 'message' => '申请成功,请等待管理员审核']);
  987. }
  988. // 帮助中心
  989. public function help(Request $request)
  990. {
  991. $view['website_logo'] = self::$systemConfig['website_logo'];
  992. $view['website_analytics'] = self::$systemConfig['website_analytics'];
  993. $view['website_customer_service'] = self::$systemConfig['website_customer_service'];
  994. $view['articleList'] = Article::query()->where('type', 1)->where('is_del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->limit(10)->paginate(15);
  995. return Response::view('user.help', $view);
  996. }
  997. // 更换订阅地址
  998. public function exchangeSubscribe(Request $request)
  999. {
  1000. $user = Session::get('user');
  1001. DB::beginTransaction();
  1002. try {
  1003. // 更换订阅地址
  1004. $code = $this->makeSubscribeCode();
  1005. UserSubscribe::query()->where('user_id', $user['id'])->update(['code' => $code]);
  1006. // 更换连接密码
  1007. User::query()->where('id', $user['id'])->update(['passwd' => makeRandStr()]);
  1008. DB::commit();
  1009. return Response::json(['status' => 'success', 'data' => '', 'message' => '更换成功']);
  1010. } catch (\Exception $e) {
  1011. DB::rollBack();
  1012. Log::info("更换订阅地址异常:" . $e->getMessage());
  1013. return Response::json(['status' => 'fail', 'data' => '', 'message' => '更换失败' . $e->getMessage()]);
  1014. }
  1015. }
  1016. // 转换成管理员的身份
  1017. public function switchToAdmin(Request $request)
  1018. {
  1019. if (!Session::has('admin') || !Session::has('user')) {
  1020. return Response::json(['status' => 'fail', 'data' => '', 'message' => '非法请求']);
  1021. }
  1022. $admin = Session::get('admin');
  1023. $user = User::query()->where('id', $admin['id'])->first();
  1024. if (!$user) {
  1025. return Response::json(['status' => 'fail', 'data' => '', 'message' => "非法请求"]);
  1026. }
  1027. // 管理员信息重新写入user
  1028. Session::put('user', Session::get('admin'));
  1029. Session::forget('admin');
  1030. return Response::json(['status' => 'success', 'data' => '', 'message' => "身份切换成功"]);
  1031. }
  1032. // 卡券余额充值
  1033. public function charge(Request $request)
  1034. {
  1035. $user = Session::get('user');
  1036. $coupon_sn = trim($request->get('coupon_sn'));
  1037. if (empty($coupon_sn)) {
  1038. return Response::json(['status' => 'fail', 'data' => '', 'message' => '券码不能为空']);
  1039. }
  1040. $coupon = Coupon::query()->where('sn', $coupon_sn)->where('type', 3)->where('is_del', 0)->where('status', 0)->first();
  1041. if (!$coupon) {
  1042. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该券不可用']);
  1043. }
  1044. DB::beginTransaction();
  1045. try {
  1046. $user = User::query()->where('id', $user['id'])->first();
  1047. // 写入日志
  1048. $this->addUserBalanceLog($user->id, 0, $user->balance, $user->balance + $coupon->amount, $coupon->amount, '用户手动充值 - [充值券:' . $coupon_sn . ']');
  1049. // 余额充值
  1050. $user->balance = $user->balance + $coupon->amount;
  1051. $user->save();
  1052. // 更改卡券状态
  1053. $coupon->status = 1;
  1054. $coupon->save();
  1055. // 写入卡券日志
  1056. Helpers::addCouponLog($coupon->id, 0, 0, '账户余额充值使用');
  1057. DB::commit();
  1058. return Response::json(['status' => 'success', 'data' => '', 'message' => '充值成功']);
  1059. } catch (\Exception $e) {
  1060. Log::error($e->getMessage());
  1061. DB::rollBack();
  1062. return Response::json(['status' => 'fail', 'data' => '', 'message' => '充值失败']);
  1063. }
  1064. }
  1065. // 切换语言
  1066. public function switchLang(Request $request, $locale)
  1067. {
  1068. Session::put("locale", $locale);
  1069. return Redirect::back();
  1070. }
  1071. }