123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- <?php
- namespace App\Console\Commands;
- use App\Components\Helpers;
- use App\Http\Models\SsNodeIp;
- use App\Http\Models\SsNodeInfo;
- use App\Http\Models\SsNodeOnlineLog;
- use App\Http\Models\SsNodeTrafficHourly;
- use App\Http\Models\SsNodeTrafficDaily;
- use App\Http\Models\UserBanLog;
- use App\Http\Models\UserLoginLog;
- use App\Http\Models\UserSubscribeLog;
- use App\Http\Models\UserTrafficDaily;
- use App\Http\Models\UserTrafficLog;
- use App\Http\Models\UserTrafficHourly;
- use Illuminate\Console\Command;
- use Log;
- class AutoClearLog extends Command
- {
- protected $signature = 'autoClearLog';
- protected $description = '自动清除日志';
- protected static $systemConfig;
- public function __construct()
- {
- parent::__construct();
- self::$systemConfig = Helpers::systemConfig();
- }
- public function handle()
- {
- $jobStartTime = microtime(true);
- // 清除日志
- if (self::$systemConfig['is_clear_log']) {
- $this->clearLog();
- }
- $jobEndTime = microtime(true);
- $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
- Log::info('执行定时任务【' . $this->description . '】,耗时' . $jobUsedTime . '秒');
- }
- // 清除日志
- private function clearLog()
- {
- // 自动清除30分钟以前的节点负载信息日志
- SsNodeInfo::query()->where('log_time', '<=', strtotime("-30 minutes"))->delete();
- // 自动清除1小时以前的节点在线用户数日志
- SsNodeOnlineLog::query()->where('log_time', '<=', strtotime("-1 hour"))->delete();
- // 自动清除3天以前的用户流量日志
- UserTrafficLog::query()->where('log_time', '<=', strtotime("-3 days"))->delete();
- // 自动清除3天以前的用户每小时流量数据日志
- UserTrafficHourly::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 days')))->delete();
- // 自动清除1个月以前的用户每天流量数据日志
- UserTrafficDaily::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-1 month')))->delete();
- // 自动清除2个月以前的节点每小时流量数据日志
- SsNodeTrafficHourly::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-2 month')))->delete();
- // 自动清除3个月以前的节点每天流量数据日志
- SsNodeTrafficDaily::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 month')))->delete();
- // 自动清除30天以前用户封禁日志
- UserBanLog::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime("-1 month")))->delete();
- // 自动清除1天前用户连接IP
- SsNodeIp::query()->where('created_at', '<=', strtotime("-1 day"))->delete();
- // 自动清除3个月以前用户登陆日志
- UserLoginLog::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime("-3 month")))->delete();
- // 自动清除1个月前的用户订阅记录
- UserSubscribeLog::query()->where('request_time', '<=', date('Y-m-d H:i:s', strtotime("-1 month")))->delete();
- }
- }
|