UserController.php 49 KB

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