updateUserLevel.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435
  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. protected $signature = 'updateUserLevel';
  10. protected $description = '更新用户等级';
  11. public function handle(): void {
  12. Log::info('----------------------------【用户等级升级】开始----------------------------');
  13. // 预设level 0
  14. User::where('level', '<>', 0)->update(['level' => 0]);
  15. // 获取商品列表,取新等级
  16. $goodsLevel = Goods::type(2)->where('level', '<>', 0)->pluck('id')->toArray();
  17. // 取生效的套餐
  18. $orderList = Order::active()->with('goods')->whereIn('goods_id', $goodsLevel)->get();
  19. foreach($orderList as $order){
  20. $ret = $order->user->update(['level' => $order->goods->level]);
  21. if($ret){
  22. Log::info('用户: '.$order->user_id.', 按照订单'.$order->id.' 等级为'.$order->goods->level);
  23. }else{
  24. Log::error('用户: '.$order->user_id.' 等级更新失败!');
  25. }
  26. }
  27. Log::info('----------------------------【用户等级升级】结束----------------------------');
  28. }
  29. }