AutoClearLog.php 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\NodeDailyDataFlow;
  4. use App\Models\NodeHeartBeat;
  5. use App\Models\NodeHourlyDataFlow;
  6. use App\Models\NodeOnlineLog;
  7. use App\Models\NodeOnlineUserIp;
  8. use App\Models\UserBanedLog;
  9. use App\Models\UserDailyDataFlow;
  10. use App\Models\UserDataFlowLog;
  11. use App\Models\UserHourlyDataFlow;
  12. use App\Models\UserLoginLog;
  13. use App\Models\UserSubscribeLog;
  14. use Exception;
  15. use Illuminate\Console\Command;
  16. use Log;
  17. class AutoClearLog extends Command
  18. {
  19. protected $signature = 'autoClearLog';
  20. protected $description = '自动清除日志';
  21. public function handle(): void
  22. {
  23. $jobStartTime = microtime(true);
  24. // 清除日志
  25. if (sysConfig('is_clear_log')) {
  26. $this->clearLog();
  27. }
  28. $jobEndTime = microtime(true);
  29. $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
  30. Log::info('---【'.$this->description.'】完成---,耗时'.$jobUsedTime.'秒');
  31. }
  32. // 清除日志
  33. private function clearLog(): void
  34. {
  35. try {
  36. // 清除节点负载信息日志
  37. NodeHeartBeat::where('log_time', '<=', strtotime('-30 minutes'))->delete();
  38. // 清除节点在线用户数日志
  39. NodeOnlineLog::where('log_time', '<=', strtotime('-1 hour'))->delete();
  40. // 清除用户流量日志
  41. UserDataFlowLog::where('log_time', '<=', strtotime('-3 days'))->delete();
  42. // 清除用户每时各流量数据日志
  43. UserHourlyDataFlow::where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 days')))->delete();
  44. // 清除用户各节点 / 节点总计的每天流量数据日志
  45. UserDailyDataFlow::where('node_id', '<>', 0)
  46. ->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-1 month')))
  47. ->orWhere('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 month')))
  48. ->delete();
  49. // 清除节点每小时流量数据日志
  50. NodeHourlyDataFlow::where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 days')))->delete();
  51. // 清除节点每天流量数据日志
  52. NodeDailyDataFlow::where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-2 month')))->delete();
  53. // 清除用户封禁日志
  54. UserBanedLog::where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 month')))->delete();
  55. // 清除用户连接IP
  56. NodeOnlineUserIp::where('created_at', '<=', strtotime('-1 month'))->delete();
  57. // 清除用户登陆日志
  58. UserLoginLog::where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-3 month')))->delete();
  59. // 清除用户订阅记录
  60. UserSubscribeLog::where('request_time', '<=', date('Y-m-d H:i:s', strtotime('-1 month')))->delete();
  61. } catch (Exception $e) {
  62. Log::error('【清理日志】错误: '.$e->getMessage());
  63. }
  64. }
  65. }