updateUserLevel.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\Goods;
  4. use App\Models\Order;
  5. use App\Models\User;
  6. use Illuminate\Console\Command;
  7. use Log;
  8. class updateUserLevel extends Command
  9. {
  10. protected $signature = 'updateUserLevel';
  11. protected $description = '更新用户等级';
  12. public function handle(): void
  13. {
  14. Log::info('----------------------------【用户等级升级】开始----------------------------');
  15. // 预设level 0
  16. User::where('level', '<>', 0)->update(['level' => 0]);
  17. // 获取商品列表,取新等级
  18. $goodsLevel = Goods::type(2)->where('level', '<>', 0)->pluck('id')->toArray();
  19. // 取生效的套餐
  20. $orderList = Order::active()->with('goods')->whereIn('goods_id', $goodsLevel)->get();
  21. foreach ($orderList as $order) {
  22. $ret = $order->user->update(['level' => $order->goods->level]);
  23. if ($ret) {
  24. Log::info('用户: '.$order->user_id.', 按照订单'.$order->id.' 等级为'.$order->goods->level);
  25. } else {
  26. Log::error('用户: '.$order->user_id.' 等级更新失败!');
  27. }
  28. }
  29. Log::info('----------------------------【用户等级升级】结束----------------------------');
  30. }
  31. }