AutoClearLog.php 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Components\Helpers;
  4. use App\Http\Models\SsNodeIp;
  5. use App\Http\Models\SsNodeInfo;
  6. use App\Http\Models\SsNodeOnlineLog;
  7. use App\Http\Models\SsNodeTrafficHourly;
  8. use App\Http\Models\SsNodeTrafficDaily;
  9. use App\Http\Models\UserBanLog;
  10. use App\Http\Models\UserLoginLog;
  11. use App\Http\Models\UserSubscribeLog;
  12. use App\Http\Models\UserTrafficDaily;
  13. use App\Http\Models\UserTrafficLog;
  14. use App\Http\Models\UserTrafficHourly;
  15. use Illuminate\Console\Command;
  16. use Log;
  17. class AutoClearLog extends Command
  18. {
  19. protected $signature = 'autoClearLog';
  20. protected $description = '自动清除日志';
  21. protected static $systemConfig;
  22. public function __construct()
  23. {
  24. parent::__construct();
  25. self::$systemConfig = Helpers::systemConfig();
  26. }
  27. public function handle()
  28. {
  29. $jobStartTime = microtime(true);
  30. // 清除日志
  31. if (self::$systemConfig['is_clear_log']) {
  32. $this->clearLog();
  33. }
  34. $jobEndTime = microtime(true);
  35. $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
  36. Log::info('执行定时任务【' . $this->description . '】,耗时' . $jobUsedTime . '秒');
  37. }
  38. // 清除日志
  39. private function clearLog()
  40. {
  41. // 自动清除30分钟以前的节点负载信息日志
  42. SsNodeInfo::query()->where('log_time', '<=', strtotime("-30 minutes"))->delete();
  43. // 自动清除1小时以前的节点在线用户数日志
  44. SsNodeOnlineLog::query()->where('log_time', '<=', strtotime("-1 hour"))->delete();
  45. // 自动清除3天以前的用户流量日志
  46. UserTrafficLog::query()->where('log_time', '<=', strtotime("-3 days"))->delete();
  47. // 自动清除3天以前的用户每小时流量数据日志
  48. UserTrafficHourly::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 days')))->delete();
  49. // 自动清除1个月以前的用户每天流量数据日志
  50. UserTrafficDaily::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-1 month')))->delete();
  51. // 自动清除2个月以前的节点每小时流量数据日志
  52. SsNodeTrafficHourly::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-2 month')))->delete();
  53. // 自动清除3个月以前的节点每天流量数据日志
  54. SsNodeTrafficDaily::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 month')))->delete();
  55. // 自动清除30天以前用户封禁日志
  56. UserBanLog::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime("-1 month")))->delete();
  57. // 自动清除1天前用户连接IP
  58. SsNodeIp::query()->where('created_at', '<=', strtotime("-1 day"))->delete();
  59. // 自动清除3个月以前用户登陆日志
  60. UserLoginLog::query()->where('created_at', '<=', date('Y-m-d H:i:s', strtotime("-3 month")))->delete();
  61. // 自动清除1个月前的用户订阅记录
  62. UserSubscribeLog::query()->where('request_time', '<=', date('Y-m-d H:i:s', strtotime("-1 month")))->delete();
  63. }
  64. }