123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127 |
- <?php
- namespace App\Http\Controllers;
- use App\Models\Country;
- use App\Models\Invite;
- use App\Models\Label;
- use App\Models\Level;
- use App\Models\Node;
- use App\Models\NodeDailyDataFlow;
- use App\Models\Order;
- use App\Models\ReferralApply;
- use App\Models\ReferralLog;
- use App\Models\SsConfig;
- use App\Models\User;
- use App\Models\UserHourlyDataFlow;
- use Illuminate\Http\JsonResponse;
- use Log;
- use PhpOffice\PhpSpreadsheet\Exception;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- use Response;
- use Str;
- class AdminController extends Controller
- {
- public function index()
- {
- $past = strtotime('-'.sysConfig('expire_days').' days');
- return view('admin.index', [
- 'expireDays' => sysConfig('expire_days'),
- 'totalUserCount' => 0,
- 'todayRegister' => User::whereDate('created_at', date('Y-m-d'))->count(),
- 'enableUserCount' => User::whereEnable(1)->count(),
- 'activeUserCount' => 1,
- 'payingUserCount' => 1,
- 'unActiveUserCount' => 1,
- 'onlineUserCount' => User::where('t', '>=', strtotime('-10 minutes'))->count(),
- 'expireWarningUserCount' => 1,
- 'largeTrafficUserCount' => 1,
- 'flowAbnormalUserCount' => 1,
- 'nodeCount' => 1,
- 'unnormalNodeCount' => 1,
- 'flowCount' => 1,
- 'todayFlowCount' => 1,
- 'totalFlowCount' => 1,
- 'totalCredit' => 1,
- 'totalWaitRefAmount' => 1,
- 'todayWaitRefAmount' => 1,
- 'totalRefAmount' => 1,
- 'totalOrder' => 1,
- 'todayOrder' => 1,
- 'totalOnlinePayOrder' => 1,
- 'todayOnlinePayOrder' => 1,
- 'totalSuccessOrder' => Order::whereStatus(2)->count(),
- 'todaySuccessOrder' => Order::whereStatus(2)->whereDate('created_at', date('Y-m-d'))->count(),
- ]);
- }
-
- public function inviteList()
- {
- return view('admin.inviteList', [
- 'inviteList' => Invite::with(['invitee:id,email', 'inviter:id,email'])->orderBy('status')->orderByDesc('id')->paginate(15)->appends(request('page')),
- ]);
- }
-
- public function makeInvite(): JsonResponse
- {
- for ($i = 0; $i < 10; $i++) {
- $obj = new Invite();
- $obj->code = strtoupper(substr(md5(microtime().Str::random(6)), 8, 12));
- $obj->dateline = date('Y-m-d H:i:s', strtotime('+'.sysConfig('admin_invite_days').' days'));
- $obj->save();
- }
- return Response::json(['status' => 'success', 'message' => trans('common.generate_item', ['attribute' => trans('common.success')])]);
- }
-
- public function exportInvite()
- {
- $inviteList = Invite::whereStatus(0)->orderBy('id')->get();
- $filename = '邀请码'.date('Ymd').'.xlsx';
- $spreadsheet = new Spreadsheet();
- $spreadsheet->getProperties()
- ->setCreator('ProxyPanel')
- ->setLastModifiedBy('ProxyPanel')
- ->setTitle('邀请码')
- ->setSubject('邀请码');
- try {
- $spreadsheet->setActiveSheetIndex(0);
- $sheet = $spreadsheet->getActiveSheet();
- $sheet->setTitle('邀请码');
- $sheet->fromArray(['邀请码', '有效期'], null);
- foreach ($inviteList as $k => $vo) {
- $sheet->fromArray([$vo->code, $vo->dateline], null, 'A'.($k + 2));
- }
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
-
- header('Content-Disposition: attachment;filename="'.$filename.'"');
- header('Cache-Control: max-age=0');
- $writer = new Xlsx($spreadsheet);
- $writer->save('php://output');
- } catch (Exception $e) {
- Log::error('导出邀请码时报错:'.$e->getMessage());
- }
- }
- public function config()
- {
- return view('admin.config.config', [
- 'methods' => SsConfig::type(1)->get(),
- 'protocols' => SsConfig::type(2)->get(),
- 'obfsList' => SsConfig::type(3)->get(),
- 'countries' => Country::all(),
- 'levels' => Level::all(),
- 'labels' => Label::with('nodes')->get(),
- ]);
- }
- }
|