AutoResetUserTraffic.php 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Components\Helpers;
  4. use App\Http\Models\Order;
  5. use App\Http\Models\User;
  6. use Illuminate\Console\Command;
  7. use Log;
  8. class AutoResetUserTraffic extends Command
  9. {
  10. protected $signature = 'autoResetUserTraffic';
  11. protected $description = '自动重置用户可用流量';
  12. protected static $systemConfig;
  13. public function __construct()
  14. {
  15. parent::__construct();
  16. self::$systemConfig = Helpers::systemConfig();
  17. }
  18. public function handle()
  19. {
  20. $jobStartTime = microtime(TRUE);
  21. // 重置用户流量
  22. if(self::$systemConfig['reset_traffic']){
  23. $this->resetUserTraffic();
  24. }
  25. $jobEndTime = microtime(TRUE);
  26. $jobUsedTime = round(($jobEndTime-$jobStartTime), 4);
  27. Log::info('执行定时任务【'.$this->description.'】,耗时'.$jobUsedTime.'秒');
  28. }
  29. // 重置用户流量
  30. private function resetUserTraffic()
  31. {
  32. $userList = User::query()->where('status', '>=', 0)->where('expire_time', '>=', date('Y-m-d'))->get();
  33. if(!$userList->isEmpty()){
  34. foreach($userList as $user){
  35. if(!$user->traffic_reset_day){
  36. continue;
  37. }
  38. // 取出用户购买的有效套餐
  39. $order = Order::query()
  40. ->with(['user', 'goods'])
  41. ->whereHas('goods', function($q){
  42. $q->where('type', 2);
  43. })
  44. ->where('user_id', $user->id)
  45. ->where('is_expire', 0)
  46. ->orderBy('oid', 'desc')
  47. ->first();
  48. if(!$order){
  49. continue;
  50. }
  51. $month = date('m');
  52. $today = date('d');
  53. $last_day = date('t');
  54. $resetDay = $order->user->traffic_reset_day;
  55. if($resetDay == $today || ($today == $last_day && $resetDay > $last_day)){
  56. // 跳过本月,防止异常重置
  57. if($month == date('m', strtotime($order->expire_at))){
  58. continue;
  59. }elseif($month == date('m', strtotime($order->created_at))){
  60. continue;
  61. }
  62. // 重置流量
  63. User::query()->where('id', $user->id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => $order->goods->traffic*1048576]);
  64. }
  65. }
  66. }
  67. }
  68. }