ServiceTimer.php 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Components\Helpers;
  4. use App\Models\Order;
  5. use Illuminate\Console\Command;
  6. use Log;
  7. class ServiceTimer extends Command
  8. {
  9. protected $signature = 'serviceTimer';
  10. protected $description = '服务计时器';
  11. public function handle(): void
  12. {
  13. $jobStartTime = microtime(true);
  14. // 扣减用户到期商品的流量
  15. //$this->decGoodsTraffic();
  16. $jobEndTime = microtime(true);
  17. $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
  18. Log::info('---【'.$this->description.'】完成---,耗时'.$jobUsedTime.'秒');
  19. }
  20. // 扣减用户到期商品的流量
  21. private function decGoodsTraffic(): void
  22. {
  23. //获取失效的套餐
  24. foreach (Order::activePlan()->where('expired_at', '<=', date('Y-m-d H:i:s'))->with('user')->whereHas('user')->get() as $order) {
  25. // 无用户订单,跳过
  26. // 清理全部流量,重置重置日期和等级
  27. $user = $order->user;
  28. $user->update([
  29. 'u' => 0,
  30. 'd' => 0,
  31. 'transfer_enable' => 0,
  32. 'reset_time' => null,
  33. 'level' => 0,
  34. ]);
  35. Helpers::addUserTrafficModifyLog($user->id, $order->id, $user->transfer_enable, 0, '[定时任务]用户所购商品到期,扣减商品对应的流量');
  36. // 过期本订单
  37. $order->update(['is_expire' => 1]);
  38. }
  39. }
  40. }