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, //User::count(), // 总用户数
- 'todayRegister' => User::whereDate('created_at', date('Y-m-d'))->count(), // 今日注册用户
- 'enableUserCount' => User::whereEnable(1)->count(), // 有效用户数
- 'activeUserCount' => 1, //User::where('t', '>=', $past)->count(), // 活跃用户数,
- 'payingUserCount' => 1, //Order::whereStatus(2)->where('goods_id', '<>', 0)->whereIsExpire(0)->where('amount', '>', 0)->pluck('user_id')->unique()->count(), // 付费用户数
- 'unActiveUserCount' => 1, //User::whereEnable(1)->whereBetween('t', [1, $past])->count(), // 不活跃用户数
- 'onlineUserCount' => User::where('t', '>=', strtotime('-10 minutes'))->count(), // 10分钟内在线用户数
- 'expireWarningUserCount' => 1, //User::whereBetween('expired_at', [date('Y-m-d'), date('Y-m-d', strtotime('+'.sysConfig('expire_days').' days'))])->count(), // 临近过期用户数
- 'largeTrafficUserCount' => 1, //User::whereRaw('(u + d)/transfer_enable >= 0.9')->where('status', '<>', -1)->count(), // 流量使用超过90%的用户
- 'flowAbnormalUserCount' => 1, //count((new UserHourlyDataFlow)->trafficAbnormal()), // 1小时内流量异常用户
- 'nodeCount' => 1, //Node::count(),
- 'unnormalNodeCount' => 1, //Node::whereStatus(0)->count(),
- 'flowCount' => 1, //flowAutoShow(NodeDailyDataFlow::where('created_at', '>=', date('Y-m-d', strtotime('-30 days')))->sum('total')),
- 'todayFlowCount' => 1, //flowAutoShow(NodeDailyDataFlow::where('created_at', '>=', date('Y-m-d'))->sum('total')),
- 'totalFlowCount' => 1, //flowAutoShow(NodeDailyDataFlow::sum('total')),
- 'totalCredit' => 1, //User::where('credit', '<>', 0)->sum('credit') / 100,
- 'totalWaitRefAmount' => 1, //ReferralLog::whereIn('status', [0, 1])->sum('commission') / 100,
- 'todayWaitRefAmount' => 1, //ReferralLog::whereIn('status', [0, 1])->whereDate('created_at', date('Y-m-d'))->sum('commission') / 100,
- 'totalRefAmount' => 1, //ReferralApply::whereStatus(2)->sum('amount') / 100,
- 'totalOrder' => 1, //Order::count(),
- 'todayOrder' => 1, //Order::whereDate('created_at', date('Y-m-d'))->count(),
- 'totalOnlinePayOrder' => 1, //Order::where('pay_type', '<>', 0)->count(),
- 'todayOnlinePayOrder' => 1, //Order::where('pay_type', '<>', 0)->whereDate('created_at', date('Y-m-d'))->count(),
- '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'); // 输出07Excel文件
- //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
- 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(),
- ]);
- }
- }
|