UserController.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\Helpers;
  4. use App\Components\PushNotification;
  5. use App\Mail\newTicket;
  6. use App\Mail\replyTicket;
  7. use App\Models\Article;
  8. use App\Models\Coupon;
  9. use App\Models\Goods;
  10. use App\Models\Invite;
  11. use App\Models\Node;
  12. use App\Models\NodeHeartBeat;
  13. use App\Models\NodePing;
  14. use App\Models\Order;
  15. use App\Models\Ticket;
  16. use App\Models\TicketReply;
  17. use App\Models\UserLoginLog;
  18. use App\Models\UserSubscribe;
  19. use Auth;
  20. use Cache;
  21. use DB;
  22. use Exception;
  23. use Hash;
  24. use Illuminate\Http\JsonResponse;
  25. use Illuminate\Http\Request;
  26. use Illuminate\Validation\Rule;
  27. use Log;
  28. use Mail;
  29. use Redirect;
  30. use Response;
  31. use Session;
  32. use Str;
  33. use Validator;
  34. /**
  35. * 用户控制器.
  36. *
  37. * Class UserController
  38. */
  39. class UserController extends Controller
  40. {
  41. public function index()
  42. {
  43. $user = Auth::getUser();
  44. $totalTransfer = $user->transfer_enable;
  45. $usedTransfer = $user->usedTraffic();
  46. $unusedTraffic = $totalTransfer - $usedTransfer > 0 ? $totalTransfer - $usedTransfer : 0;
  47. $expireTime = $user->expired_at;
  48. $view['remainDays'] = $expireTime < date('Y-m-d') ? -1 : Helpers::daysToNow($expireTime);
  49. $view['resetDays'] = $user->reset_time ? Helpers::daysToNow($user->reset_time) : 0;
  50. $view['unusedTraffic'] = flowAutoShow($unusedTraffic);
  51. $view['expireTime'] = $expireTime;
  52. $view['banedTime'] = $user->ban_time ?: 0;
  53. $view['unusedPercent'] = $totalTransfer > 0 ? round($unusedTraffic / $totalTransfer, 2) * 100 : 0;
  54. $view['announcements'] = Article::type(2)->take(5)->latest()->Paginate(1); // 公告
  55. //流量异常判断
  56. $view['isTrafficWarning'] = $user->isTrafficWarning();
  57. //付费用户判断
  58. $view['paying_user'] = $user->activePayingUser();
  59. $view['userLoginLog'] = UserLoginLog::whereUserId($user->id)->latest()->first(); // 近期登录日志
  60. $view = array_merge($view, $this->dataFlowChart($user->id));
  61. return view('user.index', $view);
  62. }
  63. // 签到
  64. public function checkIn(): JsonResponse
  65. {
  66. $user = Auth::getUser();
  67. // 系统开启登录加积分功能才可以签到
  68. if (! sysConfig('is_checkin')) {
  69. return Response::json(['status' => 'fail', 'message' => '系统未开启签到功能']);
  70. }
  71. // 已签到过,验证是否有效
  72. if (Cache::has('userCheckIn_'.$user->id)) {
  73. return Response::json(['status' => 'fail', 'message' => '已经签到过了,明天再来吧']);
  74. }
  75. $traffic = random_int((int) sysConfig('min_rand_traffic'), (int) sysConfig('max_rand_traffic')) * MB;
  76. if (! $user->incrementData($traffic)) {
  77. return Response::json(['status' => 'fail', 'message' => '签到失败,系统异常']);
  78. }
  79. // 写入用户流量变动记录
  80. Helpers::addUserTrafficModifyLog($user->id, 0, $user->transfer_enable, $user->transfer_enable + $traffic, '[签到]');
  81. // 多久后可以再签到
  82. $ttl = sysConfig('traffic_limit_time') ? sysConfig('traffic_limit_time') * Minute : Day;
  83. Cache::put('userCheckIn_'.$user->id, '1', $ttl);
  84. return Response::json(['status' => 'success', 'message' => '签到成功,系统送您 '.flowAutoShow($traffic).'流量']);
  85. }
  86. // 节点列表
  87. public function nodeList(Request $request)
  88. {
  89. $user = Auth::getUser();
  90. if ($request->isMethod('POST')) {
  91. $infoType = $request->input('type');
  92. $node = Node::find($request->input('id'));
  93. // 生成节点信息
  94. if ($node->type === 1) {
  95. $proxyType = $node->compatible ? 'SS' : 'SSR';
  96. } else {
  97. $proxyType = 'V2Ray';
  98. }
  99. $data = $this->getUserNodeInfo($user->id, $node->id, $infoType !== 'text' ? 0 : 1);
  100. return Response::json(['status' => 'success', 'data' => $data, 'title' => $proxyType]);
  101. }
  102. // 获取当前用户可用节点
  103. $nodeList = $user->userAccessNodes()->with(['labels', 'level_table'])->get();
  104. $view['nodesGeo'] = $nodeList->pluck('name', 'geo')->toArray();
  105. $onlineNode = NodeHeartBeat::recently()->distinct()->pluck('node_id')->toArray();
  106. $pingNodeLogs = NodePing::whereMonth('created_at', date('m'))->get(['node_id', 'ct', 'cu', 'cm', 'hk']);
  107. foreach ($nodeList as $node) {
  108. $data = $pingNodeLogs->where('node_id', $node->id);
  109. $node->ct = round($data->pluck('ct')->filter()->avg(), 2);
  110. $node->cu = round($data->pluck('cu')->filter()->avg(), 2);
  111. $node->cm = round($data->pluck('cm')->filter()->avg(), 2);
  112. $node->hk = round($data->pluck('hk')->filter()->avg(), 2);
  113. // 节点在线状态
  114. $node->offline = ! in_array($node->id, $onlineNode, true);
  115. }
  116. $view['nodeList'] = $nodeList ?? [];
  117. return view('user.nodeList', $view);
  118. }
  119. // 公告详情
  120. public function article(Request $request)
  121. {
  122. $view['info'] = Article::findOrFail($request->input('id'));
  123. return view('user.article', $view);
  124. }
  125. // 修改个人资料
  126. public function profile(Request $request)
  127. {
  128. $user = Auth::getUser();
  129. if ($request->isMethod('POST')) {
  130. $old_password = $request->input('old_password');
  131. $new_password = $request->input('new_password');
  132. $username = $request->input('username');
  133. $wechat = $request->input('wechat');
  134. $qq = $request->input('qq');
  135. $passwd = $request->input('passwd');
  136. // 修改密码
  137. if ($old_password && $new_password) {
  138. if (! Hash::check($old_password, $user->password)) {
  139. return Redirect::back()->withErrors('旧密码错误,请重新输入');
  140. }
  141. if (Hash::check($new_password, $user->password)) {
  142. return Redirect::back()->withErrors('新密码不可与旧密码一样,请重新输入');
  143. }
  144. // 演示环境禁止改管理员密码
  145. if ($user->id === 1 && config('app.demo')) {
  146. return Redirect::back()->withErrors('演示环境禁止修改管理员密码');
  147. }
  148. if (! $user->update(['password' => $new_password])) {
  149. return Redirect::back()->withErrors('修改失败');
  150. }
  151. return Redirect::back()->with('successMsg', '修改成功');
  152. // 修改代理密码
  153. }
  154. if ($passwd) {
  155. if (! $user->update(['passwd' => $passwd])) {
  156. return Redirect::back()->withErrors('修改失败');
  157. }
  158. return Redirect::back()->with('successMsg', '修改成功');
  159. }
  160. // 修改联系方式
  161. if (empty($username)) {
  162. return Redirect::back()->withErrors('修改失败,昵称不能为空值');
  163. }
  164. if (! $user->update(['username' => $username, 'wechat' => $wechat, 'qq' => $qq])) {
  165. return Redirect::back()->withErrors('修改失败');
  166. }
  167. return Redirect::back()->with('successMsg', '修改成功');
  168. }
  169. return view('user.profile');
  170. }
  171. // 商品列表
  172. public function services(Request $request)
  173. {
  174. $user = Auth::getUser();
  175. // 余额充值商品,只取10个
  176. $view['chargeGoodsList'] = Goods::type(3)->whereStatus(1)->orderBy('price')->limit(10)->get();
  177. $view['goodsList'] = Goods::whereStatus(1)
  178. ->where('type', '<=', '2')
  179. ->orderByDesc('type')
  180. ->orderByDesc('sort')
  181. ->paginate(10)
  182. ->appends($request->except('page'));
  183. $renewOrder = Order::userActivePlan($user->id)->first();
  184. $renewPrice = $renewOrder->goods ?? 0;
  185. $view['renewTraffic'] = $renewPrice->renew ?? 0;
  186. // 有重置日时按照重置日为标准,否者就以过期日为标准
  187. $dataPlusDays = $user->reset_time ?? $user->expired_at;
  188. $view['dataPlusDays'] = $dataPlusDays > date('Y-m-d') ? Helpers::daysToNow($dataPlusDays) : 0;
  189. return view('user.services', $view);
  190. }
  191. //重置流量
  192. public function resetUserTraffic(): ?JsonResponse
  193. {
  194. $user = Auth::getUser();
  195. $order = Order::userActivePlan()->first();
  196. $renewCost = $order->goods->renew;
  197. if ($user->credit < $renewCost) {
  198. return Response::json(['status' => 'fail', 'message' => '余额不足,请充值余额']);
  199. }
  200. $user->update(['u' => 0, 'd' => 0]);
  201. // 扣余额
  202. $user->updateCredit(-$renewCost);
  203. // 记录余额操作日志
  204. Helpers::addUserCreditLog($user->id, 0, $user->credit, $user->credit - $renewCost, -1 * $renewCost, '用户自行重置流量');
  205. return Response::json(['status' => 'success', 'message' => '重置成功']);
  206. }
  207. // 工单
  208. public function ticketList(Request $request)
  209. {
  210. return view('user.ticketList', [
  211. 'tickets' => Auth::user()->tickets()->latest()->paginate(10)->appends($request->except('page')),
  212. ]);
  213. }
  214. // 订单
  215. public function invoices(Request $request)
  216. {
  217. $view['orderList'] = Auth::user()->orders()
  218. ->with(['goods', 'payment'])
  219. ->orderByDesc('id')
  220. ->paginate(10)
  221. ->appends($request->except('page'));
  222. $view['prepaidPlan'] = Order::userPrepay()->exists();
  223. return view('user.invoices', $view);
  224. }
  225. public function closePlan(): JsonResponse
  226. {
  227. $activePlan = Order::userActivePlan()->first();
  228. $activePlan->is_expire = 1;
  229. if ($activePlan->save()) {
  230. // 关闭先前套餐后,新套餐自动运行
  231. if (Order::userActivePlan()->exists()) {
  232. return Response::json(['status' => 'success', 'message' => '激活成功']);
  233. }
  234. return Response::json(['status' => 'success', 'message' => '关闭']);
  235. }
  236. return Response::json(['status' => 'fail', 'message' => '关闭失败']);
  237. }
  238. // 订单明细
  239. public function invoiceDetail($sn)
  240. {
  241. $view['order'] = Order::uid()->whereOrderSn($sn)->with(['goods', 'coupon', 'payment'])->firstOrFail();
  242. return view('user.invoiceDetail', $view);
  243. }
  244. // 添加工单
  245. public function createTicket(Request $request): ?JsonResponse
  246. {
  247. $user = Auth::getUser();
  248. $title = $request->input('title');
  249. $content = clean($request->input('content'));
  250. $content = str_replace(['atob', 'eval'], '', $content);
  251. if (empty($title) || empty($content)) {
  252. return Response::json(['status' => 'fail', 'message' => '请输入标题和内容']);
  253. }
  254. $obj = new Ticket();
  255. $obj->user_id = $user->id;
  256. $obj->title = $title;
  257. $obj->content = $content;
  258. $obj->status = 0;
  259. if ($obj->save()) {
  260. $emailTitle = '新工单提醒';
  261. $content = '标题:【'.$title.'】<br>用户:'.$user->email.'<br>内容:'.$content;
  262. // 发邮件通知管理员
  263. if (sysConfig('webmaster_email')) {
  264. $logId = Helpers::addNotificationLog($emailTitle, $content, 1, sysConfig('webmaster_email'));
  265. Mail::to(sysConfig('webmaster_email'))->send(new newTicket($logId, $emailTitle, $content));
  266. }
  267. PushNotification::send($emailTitle, $content);
  268. return Response::json(['status' => 'success', 'message' => '提交成功']);
  269. }
  270. return Response::json(['status' => 'fail', 'message' => '提交失败']);
  271. }
  272. // 回复工单
  273. public function replyTicket(Request $request)
  274. {
  275. $id = $request->input('id');
  276. $ticket = Ticket::uid()->with('user')->whereId($id)->firstOrFail();
  277. if ($request->isMethod('POST')) {
  278. $content = clean($request->input('content'));
  279. $content = str_replace(['atob', 'eval'], '', $content);
  280. $content = substr($content, 0, 300);
  281. if (empty($content)) {
  282. return Response::json(['status' => 'fail', 'message' => '回复内容不能为空']);
  283. }
  284. if ($ticket->status === 2) {
  285. return Response::json(['status' => 'fail', 'message' => '错误:该工单已关闭']);
  286. }
  287. $obj = new TicketReply();
  288. $obj->ticket_id = $id;
  289. $obj->user_id = Auth::id();
  290. $obj->content = $content;
  291. if ($obj->save()) {
  292. // 重新打开工单
  293. $ticket->status = 0;
  294. $ticket->save();
  295. $title = '工单回复提醒';
  296. $content = '标题:【'.$ticket->title.'】<br>用户回复:'.$content;
  297. // 发邮件通知管理员
  298. if (sysConfig('webmaster_email')) {
  299. $logId = Helpers::addNotificationLog($title, $content, 1, sysConfig('webmaster_email'));
  300. Mail::to(sysConfig('webmaster_email'))->send(new replyTicket($logId, $title, $content));
  301. }
  302. PushNotification::send($title, $content);
  303. return Response::json(['status' => 'success', 'message' => '回复成功']);
  304. }
  305. return Response::json(['status' => 'fail', 'message' => '回复失败']);
  306. }
  307. $view['ticket'] = $ticket;
  308. $view['replyList'] = TicketReply::whereTicketId($id)->with('user')->oldest()->get();
  309. return view('user.replyTicket', $view);
  310. }
  311. // 关闭工单
  312. public function closeTicket(Request $request): ?JsonResponse
  313. {
  314. $id = $request->input('id');
  315. $ret = Ticket::uid()->whereId($id)->update(['status' => 2]);
  316. if ($ret) {
  317. PushNotification::send('工单关闭提醒', '工单:ID'.$id.'用户已手动关闭');
  318. return Response::json(['status' => 'success', 'message' => '关闭成功']);
  319. }
  320. return Response::json(['status' => 'fail', 'message' => '关闭失败']);
  321. }
  322. // 邀请码
  323. public function invite()
  324. {
  325. if (Order::uid()->active()->where('origin_amount', '>', 0)->doesntExist()) {
  326. return Response::view(
  327. 'auth.error',
  328. ['message' => '本功能对非付费用户禁用!请 <a class="btn btn-sm btn-danger" href="/">返 回</a>'],
  329. 402
  330. );
  331. }
  332. $view['num'] = Auth::getUser()->invite_num; // 还可以生成的邀请码数量
  333. $view['inviteList'] = Invite::uid()->with(['invitee', 'inviter'])->paginate(10); // 邀请码列表
  334. $view['referral_traffic'] = flowAutoShow(sysConfig('referral_traffic') * MB);
  335. $view['referral_percent'] = sysConfig('referral_percent');
  336. return view('user.invite', $view);
  337. }
  338. // 生成邀请码
  339. public function makeInvite(): JsonResponse
  340. {
  341. $user = Auth::getUser();
  342. if ($user->invite_num <= 0) {
  343. return Response::json(['status' => 'fail', 'message' => '生成失败:已无邀请码生成名额']);
  344. }
  345. $obj = new Invite();
  346. $obj->inviter_id = $user->id;
  347. $obj->invitee_id = 0;
  348. $obj->code = strtoupper(mb_substr(md5(microtime().Str::random()), 8, 12));
  349. $obj->status = 0;
  350. $obj->dateline = date('Y-m-d H:i:s', strtotime('+'.sysConfig('user_invite_days').' days'));
  351. $obj->save();
  352. if ($obj) {
  353. $user->update(['invite_num' => $user->invite_num - 1]);
  354. return Response::json(['status' => 'success', 'message' => '生成成功']);
  355. }
  356. return Response::json(['status' => 'fail', 'message' => '生成邀请码失败']);
  357. }
  358. // 使用优惠券
  359. public function redeemCoupon(Request $request): JsonResponse
  360. {
  361. $coupon_sn = $request->input('coupon_sn');
  362. $good_price = $request->input('price');
  363. if (empty($coupon_sn)) {
  364. return Response::json(['status' => 'fail', 'title' => '使用失败', 'message' => '请输入您的优惠劵!']);
  365. }
  366. $coupon = Coupon::whereSn($coupon_sn)->whereIn('type', [1, 2])->first();
  367. if (! $coupon) {
  368. return Response::json(['status' => 'fail', 'title' => '优惠券不存在', 'message' => '请确认优惠券是否输入正确!']);
  369. }
  370. if ($coupon->status === 1) {
  371. return Response::json(['status' => 'fail', 'title' => '抱歉', 'message' => '优惠券已被使用!']);
  372. }
  373. if ($coupon->status === 2) {
  374. return Response::json(['status' => 'fail', 'title' => '抱歉', 'message' => '优惠券已失效!']);
  375. }
  376. if ($coupon->end_time < time()) {
  377. $coupon->status = 2;
  378. $coupon->save();
  379. return Response::json(['status' => 'fail', 'title' => '抱歉', 'message' => '优惠券已失效!']);
  380. }
  381. if ($coupon->start_time > time()) {
  382. return Response::json(['status' => 'fail', 'title' => '优惠券尚未生效', 'message' => '请等待活动正式开启']);
  383. }
  384. if ($good_price < $coupon->rule) {
  385. return Response::json(['status' => 'fail', 'title' => '使用条件未满足', 'message' => '请购买价格更高的套餐']);
  386. }
  387. $data = [
  388. 'name' => $coupon->name,
  389. 'type' => $coupon->type,
  390. 'value' => $coupon->value,
  391. ];
  392. return Response::json(['status' => 'success', 'data' => $data, 'message' => '优惠券有效']);
  393. }
  394. // 购买服务
  395. public function buy($goods_id)
  396. {
  397. $user = Auth::getUser();
  398. $goods = Goods::whereId($goods_id)->whereStatus(1)->first();
  399. if (empty($goods)) {
  400. return Redirect::route('shop');
  401. }
  402. // 有重置日时按照重置日为标准,否者就以过期日为标准
  403. $dataPlusDays = $user->reset_time ?? $user->expired_at;
  404. $view['dataPlusDays'] = $dataPlusDays > date('Y-m-d') ? Helpers::daysToNow($dataPlusDays) : 0;
  405. $view['activePlan'] = Order::userActivePlan()->exists();
  406. $view['goods'] = $goods;
  407. return view('user.buy', $view);
  408. }
  409. // 帮助中心
  410. public function help()
  411. {
  412. //$view['articleList'] = Article::type(1)->orderByDesc('sort')->latest()->limit(10)->paginate(5);
  413. $data = [];
  414. if (Node::whereIn('type', [1, 4])->whereStatus(1)->exists()) {
  415. $data[] = 'ss';
  416. //array_push
  417. }
  418. if (Node::whereType(2)->whereStatus(1)->exists()) {
  419. $data[] = 'v2';
  420. }
  421. if (Node::whereType(3)->whereStatus(1)->exists()) {
  422. $data[] = 'trojan';
  423. }
  424. $view['sub'] = $data;
  425. //付费用户判断
  426. $view['paying_user'] = Auth::user()->activePayingUser();
  427. //客户端安装
  428. $view['Shadowrocket_install'] = 'itms-services://?action=download-manifest&url='.sysConfig('website_url').'/clients/Shadowrocket.plist';
  429. $view['Quantumult_install'] = 'itms-services://?action=download-manifest&url='.sysConfig('website_url').'/clients/Quantumult.plist';
  430. // 订阅连接
  431. $subscribe = UserSubscribe::whereUserId(Auth::id())->firstOrFail();
  432. $view['subscribe_status'] = $subscribe->status;
  433. $subscribe_link = route('sub', $subscribe->code);
  434. $view['link'] = $subscribe_link;
  435. $view['subscribe_link'] = 'sub://'.base64url_encode($subscribe_link);
  436. $view['Shadowrocket_link'] = 'shadowrocket://add/sub://'.base64url_encode($subscribe_link).'?remarks='.(sysConfig('website_name').'-'.sysConfig('website_url'));
  437. $view['Shadowrocket_linkQrcode'] = 'sub://'.base64url_encode($subscribe_link).'#'.base64url_encode(sysConfig('website_name'));
  438. $view['Quantumult_linkOut'] = 'quantumult://configuration?server='.base64url_encode($subscribe_link).'&filter='.base64url_encode('https://raw.githubusercontent.com/ZBrettonYe/VPN-Rules-Collection/master/Profiles/Quantumult/Pro.conf').'&rejection='.base64url_encode('https://raw.githubusercontent.com/ZBrettonYe/VPN-Rules-Collection/master/Profiles/Quantumult/Rejection.conf');
  439. $view['Quantumult_linkIn'] = 'quantumult://configuration?server='.base64url_encode($subscribe_link).'&filter='.base64url_encode('https://raw.githubusercontent.com/ZBrettonYe/VPN-Rules-Collection/master/Profiles/Quantumult/BacktoCN.conf').'&rejection='.base64url_encode('https://raw.githubusercontent.com/ZBrettonYe/VPN-Rules-Collection/master/Profiles/Quantumult/Rejection.conf');
  440. return view('user.help', $view);
  441. }
  442. // 更换订阅地址
  443. public function exchangeSubscribe(): ?JsonResponse
  444. {
  445. try {
  446. DB::beginTransaction();
  447. // 更换订阅码
  448. Auth::getUser()->subscribe->update(['code' => Helpers::makeSubscribeCode()]);
  449. // 更换连接信息
  450. Auth::getUser()->update(['passwd' => Str::random(), 'vmess_id' => Str::uuid()]);
  451. DB::commit();
  452. return Response::json(['status' => 'success', 'message' => '更换成功']);
  453. } catch (Exception $e) {
  454. DB::rollBack();
  455. Log::error('更换订阅地址异常:'.$e->getMessage());
  456. return Response::json(['status' => 'fail', 'message' => '更换失败'.$e->getMessage()]);
  457. }
  458. }
  459. // 转换成管理员的身份
  460. public function switchToAdmin(): JsonResponse
  461. {
  462. if (! Session::has('admin')) {
  463. return Response::json(['status' => 'fail', 'message' => '非法请求']);
  464. }
  465. // 管理员信息重新写入user
  466. $user = Auth::loginUsingId(Session::get('admin'));
  467. Session::forget('admin');
  468. if ($user) {
  469. return Response::json(['status' => 'success', 'message' => '身份切换成功']);
  470. }
  471. return Response::json(['status' => 'fail', 'message' => '身份切换失败']);
  472. }
  473. // Todo 卡券余额合并至CouponService
  474. public function charge(Request $request): ?JsonResponse
  475. {
  476. $validator = Validator::make($request->all(), [
  477. 'coupon_sn' => [
  478. 'required', Rule::exists('coupon', 'sn')->where(static function ($query) {
  479. $query->whereType(3)->whereStatus(0);
  480. }),
  481. ],
  482. ], ['coupon_sn.required' => '券码不能为空', 'coupon_sn.exists' => '该券不可用']);
  483. if ($validator->fails()) {
  484. return Response::json(['status' => 'fail', 'message' => $validator->getMessageBag()->first()]);
  485. }
  486. $coupon = Coupon::whereSn($request->input('coupon_sn'))->firstOrFail();
  487. try {
  488. DB::beginTransaction();
  489. // 写入日志
  490. $user = Auth::getUser();
  491. Helpers::addUserCreditLog($user->id, 0, $user->credit, $user->credit + $coupon->value, $coupon->value, '用户手动充值 - [充值券:'.$request->input('coupon_sn').']');
  492. // 余额充值
  493. $user->updateCredit($coupon->value);
  494. // 更改卡券状态
  495. Coupon::find($coupon->id)->update(['status' => 1]);
  496. // 写入卡券日志
  497. Helpers::addCouponLog('账户余额充值使用', $coupon->id);
  498. DB::commit();
  499. return Response::json(['status' => 'success', 'message' => '充值成功']);
  500. } catch (Exception $e) {
  501. Log::error('卡劵充值错误:'.$e->getMessage());
  502. DB::rollBack();
  503. return Response::json(['status' => 'fail', 'message' => '充值失败']);
  504. }
  505. }
  506. }