AdminController.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Models\Country;
  4. use App\Models\Invite;
  5. use App\Models\Label;
  6. use App\Models\Level;
  7. use App\Models\Node;
  8. use App\Models\NodeDailyDataFlow;
  9. use App\Models\Order;
  10. use App\Models\ReferralApply;
  11. use App\Models\ReferralLog;
  12. use App\Models\SsConfig;
  13. use App\Models\User;
  14. use App\Models\UserHourlyDataFlow;
  15. use Illuminate\Http\JsonResponse;
  16. use Log;
  17. use PhpOffice\PhpSpreadsheet\Exception;
  18. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  19. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  20. use Response;
  21. use Str;
  22. class AdminController extends Controller
  23. {
  24. public function index()
  25. {
  26. $past = strtotime('-'.sysConfig('expire_days').' days');
  27. return view('admin.index', [
  28. 'expireDays' => sysConfig('expire_days'),
  29. 'totalUserCount' => 0, //User::count(), // 总用户数
  30. 'todayRegister' => User::whereDate('created_at', date('Y-m-d'))->count(), // 今日注册用户
  31. 'enableUserCount' => User::whereEnable(1)->count(), // 有效用户数
  32. 'activeUserCount' => 1, //User::where('t', '>=', $past)->count(), // 活跃用户数,
  33. 'payingUserCount' => 1, //Order::whereStatus(2)->where('goods_id', '<>', 0)->whereIsExpire(0)->where('amount', '>', 0)->pluck('user_id')->unique()->count(), // 付费用户数
  34. 'unActiveUserCount' => 1, //User::whereEnable(1)->whereBetween('t', [1, $past])->count(), // 不活跃用户数
  35. 'onlineUserCount' => User::where('t', '>=', strtotime('-10 minutes'))->count(), // 10分钟内在线用户数
  36. 'expireWarningUserCount' => 1, //User::whereBetween('expired_at', [date('Y-m-d'), date('Y-m-d', strtotime('+'.sysConfig('expire_days').' days'))])->count(), // 临近过期用户数
  37. 'largeTrafficUserCount' => 1, //User::whereRaw('(u + d)/transfer_enable >= 0.9')->where('status', '<>', -1)->count(), // 流量使用超过90%的用户
  38. 'flowAbnormalUserCount' => 1, //count((new UserHourlyDataFlow)->trafficAbnormal()), // 1小时内流量异常用户
  39. 'nodeCount' => 1, //Node::count(),
  40. 'unnormalNodeCount' => 1, //Node::whereStatus(0)->count(),
  41. 'flowCount' => 1, //flowAutoShow(NodeDailyDataFlow::where('created_at', '>=', date('Y-m-d', strtotime('-30 days')))->sum('total')),
  42. 'todayFlowCount' => 1, //flowAutoShow(NodeDailyDataFlow::where('created_at', '>=', date('Y-m-d'))->sum('total')),
  43. 'totalFlowCount' => 1, //flowAutoShow(NodeDailyDataFlow::sum('total')),
  44. 'totalCredit' => 1, //User::where('credit', '<>', 0)->sum('credit') / 100,
  45. 'totalWaitRefAmount' => 1, //ReferralLog::whereIn('status', [0, 1])->sum('commission') / 100,
  46. 'todayWaitRefAmount' => 1, //ReferralLog::whereIn('status', [0, 1])->whereDate('created_at', date('Y-m-d'))->sum('commission') / 100,
  47. 'totalRefAmount' => 1, //ReferralApply::whereStatus(2)->sum('amount') / 100,
  48. 'totalOrder' => 1, //Order::count(),
  49. 'todayOrder' => 1, //Order::whereDate('created_at', date('Y-m-d'))->count(),
  50. 'totalOnlinePayOrder' => 1, //Order::where('pay_type', '<>', 0)->count(),
  51. 'todayOnlinePayOrder' => 1, //Order::where('pay_type', '<>', 0)->whereDate('created_at', date('Y-m-d'))->count(),
  52. 'totalSuccessOrder' => Order::whereStatus(2)->count(),
  53. 'todaySuccessOrder' => Order::whereStatus(2)->whereDate('created_at', date('Y-m-d'))->count(),
  54. ]);
  55. }
  56. // 邀请码列表
  57. public function inviteList()
  58. {
  59. return view('admin.inviteList', [
  60. 'inviteList' => Invite::with(['invitee:id,email', 'inviter:id,email'])->orderBy('status')->orderByDesc('id')->paginate(15)->appends(request('page')),
  61. ]);
  62. }
  63. // 生成邀请码
  64. public function makeInvite(): JsonResponse
  65. {
  66. for ($i = 0; $i < 10; $i++) {
  67. $obj = new Invite();
  68. $obj->code = strtoupper(substr(md5(microtime().Str::random(6)), 8, 12));
  69. $obj->dateline = date('Y-m-d H:i:s', strtotime('+'.sysConfig('admin_invite_days').' days'));
  70. $obj->save();
  71. }
  72. return Response::json(['status' => 'success', 'message' => trans('common.generate_item', ['attribute' => trans('common.success')])]);
  73. }
  74. // 导出邀请码
  75. public function exportInvite()
  76. {
  77. $inviteList = Invite::whereStatus(0)->orderBy('id')->get();
  78. $filename = '邀请码'.date('Ymd').'.xlsx';
  79. $spreadsheet = new Spreadsheet();
  80. $spreadsheet->getProperties()
  81. ->setCreator('ProxyPanel')
  82. ->setLastModifiedBy('ProxyPanel')
  83. ->setTitle('邀请码')
  84. ->setSubject('邀请码');
  85. try {
  86. $spreadsheet->setActiveSheetIndex(0);
  87. $sheet = $spreadsheet->getActiveSheet();
  88. $sheet->setTitle('邀请码');
  89. $sheet->fromArray(['邀请码', '有效期'], null);
  90. foreach ($inviteList as $k => $vo) {
  91. $sheet->fromArray([$vo->code, $vo->dateline], null, 'A'.($k + 2));
  92. }
  93. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // 输出07Excel文件
  94. //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
  95. header('Content-Disposition: attachment;filename="'.$filename.'"');
  96. header('Cache-Control: max-age=0');
  97. $writer = new Xlsx($spreadsheet);
  98. $writer->save('php://output');
  99. } catch (Exception $e) {
  100. Log::error('导出邀请码时报错:'.$e->getMessage());
  101. }
  102. }
  103. public function config()
  104. {
  105. return view('admin.config.config', [
  106. 'methods' => SsConfig::type(1)->get(),
  107. 'protocols' => SsConfig::type(2)->get(),
  108. 'obfsList' => SsConfig::type(3)->get(),
  109. 'countries' => Country::all(),
  110. 'levels' => Level::all(),
  111. 'labels' => Label::with('nodes')->get(),
  112. ]);
  113. }
  114. }