UpdateUserDepositStatusCommand.php 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\User;
  4. use Carbon\Carbon;
  5. use Illuminate\Console\Command;
  6. class UpdateUserDepositStatusCommand extends Command
  7. {
  8. /**
  9. * The name and signature of the console command.
  10. *
  11. * @var string
  12. */
  13. protected $signature = 'update:user_deposit_status';
  14. /**
  15. * The console command description.
  16. *
  17. * @var string
  18. */
  19. protected $description = '更新押金类型为免押金卡得用户押金状态';
  20. /**
  21. * Create a new command instance.
  22. *
  23. * @return void
  24. */
  25. public function __construct()
  26. {
  27. parent::__construct();
  28. }
  29. /**
  30. * Execute the console command.
  31. *
  32. * @return mixed
  33. */
  34. public function handle()
  35. {
  36. //
  37. User::query()
  38. ->where('deposit_type', User::DEPOSIT_CARD)
  39. ->where('deposit_expire_time', '<', Carbon::now())
  40. ->update(['is_deposit' => User::DEPOSIT_NO, 'deposit_type' => User::DEPOSIT_TYPE_NO, 'deposit_money' => 0]);
  41. }
  42. }