mirror of
https://github.com/ProxyPanel/ProxyPanel.git
synced 2026-04-06 04:28:27 +00:00
ad3662cda0
- Optimize Blade JavaScript code. - Refactored multiple admin controllers for improved validation, error handling, and query efficiency. - Added ProxyConfig trait to centralize proxy configuration options. - Updated NodeStatusDetection to use model relationships for heartbeat checks. - Improved category, label, and country management logic and error logging. - Added new Blade components for admin UI and updated language files and assets for better localization and frontend support. - Bug fixed & introduced more bug :)
85 lines
3.2 KiB
PHP
85 lines
3.2 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers\Admin;
|
|
|
|
use App\Http\Controllers\Controller;
|
|
use App\Models\UserSubscribe;
|
|
use App\Utils\IP;
|
|
use Illuminate\Contracts\View\View;
|
|
use Illuminate\Http\JsonResponse;
|
|
use Illuminate\Http\Request;
|
|
|
|
class SubscribeController extends Controller
|
|
{
|
|
public function index(Request $request): View
|
|
{ // 订阅码列表
|
|
$query = UserSubscribe::with(['user:id,username']);
|
|
|
|
$request->whenFilled('username', function ($username) use ($query) {
|
|
$query->whereHas('user', function ($query) use ($username) {
|
|
$query->where('username', 'like', "%$username%");
|
|
});
|
|
});
|
|
|
|
foreach (['user_id', 'status', 'code'] as $field) {
|
|
$request->whenFilled($field, function ($value) use ($query, $field) {
|
|
$query->where($field, $value);
|
|
});
|
|
}
|
|
|
|
return view('admin.subscribe.index', ['subscribeList' => $query->sortable(['id' => 'desc'])->paginate(20)->appends($request->except('page'))]);
|
|
}
|
|
|
|
public function subscribeLog(Request $request, UserSubscribe $userSubscribe): View
|
|
{ // 订阅记录
|
|
$query = $userSubscribe->userSubscribeLogs();
|
|
|
|
$request->whenFilled('id', function ($value) use ($query) {
|
|
$query->where('id', $value);
|
|
});
|
|
|
|
$request->whenFilled('ip', function ($value) use ($query) {
|
|
$query->where('request_ip', 'like', "%$value%");
|
|
});
|
|
|
|
if ($request->filled('start')) {
|
|
$query->whereBetween('request_time', [$request->input('start').' 00:00:00', $request->input('end').' 23:59:59']);
|
|
}
|
|
|
|
$subscribeLogs = $query->latest()->paginate(20)->appends($request->except('page'));
|
|
|
|
// 批量获取 IP 信息以减少查询次数
|
|
$ipList = $subscribeLogs->pluck('request_ip')->filter()->unique()->toArray();
|
|
$ipInfoMap = [];
|
|
|
|
foreach ($ipList as $ip) {
|
|
if ($ip) {
|
|
$ipInfo = IP::getIPInfo($ip);
|
|
$ipInfoMap[$ip] = $ipInfo ? ($ipInfo['address'] ?? null) : null;
|
|
}
|
|
}
|
|
|
|
// 将 IP 信息附加到日志记录中
|
|
$subscribeLogs->getCollection()->transform(function ($log) use ($ipInfoMap) {
|
|
$log->ipInfo = $log->request_ip ? ($ipInfoMap[$log->request_ip] ?? null) : null;
|
|
|
|
return $log;
|
|
});
|
|
|
|
return view('admin.subscribe.log', ['subscribeLog' => $subscribeLogs, 'subscribe' => $userSubscribe]);
|
|
}
|
|
|
|
public function setSubscribeStatus(UserSubscribe $userSubscribe): JsonResponse
|
|
{
|
|
$data = $userSubscribe->status
|
|
? ['status' => 0, 'ban_time' => strtotime(sysConfig('ban_duration').' minutes'), 'ban_desc' => 'Your subscription has been disabled by the administrator, please contact the administrator to restore it']
|
|
: ['status' => 1, 'ban_time' => null, 'ban_desc' => null];
|
|
|
|
$ret = $userSubscribe->update($data)
|
|
? ['status' => 'success', 'message' => trans('common.success_item', ['attribute' => trans('common.update')])]
|
|
: ['status' => 'fail', 'message' => trans('common.failed_item', ['attribute' => trans('common.update')])];
|
|
|
|
return response()->json($ret);
|
|
}
|
|
}
|