neiyou_user_web/app/Console/Commands/AutoClearLog.php

<?php

namespace App\Console\Commands;

use App\Components\Helpers;
use App\Http\Models\SsNodeInfo;
use App\Http\Models\SsNodeIp;
use App\Http\Models\SsNodeOnlineLog;
use App\Http\Models\SsNodeTrafficDaily;
use App\Http\Models\SsNodeTrafficHourly;
use App\Http\Models\UserBanLog;
use App\Http\Models\UserLoginLog;
use App\Http\Models\UserSubscribeLog;
use App\Http\Models\UserTrafficDaily;
use App\Http\Models\UserTrafficHourly;
use App\Http\Models\UserTrafficLog;
use Illuminate\Console\Command;
use Log;

class AutoClearLog extends Command
{
	protected $signature = 'autoClearLog';
	protected $description = '自动清除日志';

	public function __construct()
	{
		parent::__construct();
	}

	public function handle()
	{
		$jobStartTime = microtime(TRUE);

		// 清除日志
		if(Helpers::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 5 days')))->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 month"))->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();
	}

}