AutoClearLog.php 2.6 KB

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