ChangePay.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use DB;
  5. class ChangePay extends Command
  6. {
  7. /**
  8. * The name and signature of the console command.
  9. *
  10. * @var string
  11. */
  12. protected $signature = 'pay:change {--from=} {--to=}';
  13. /**
  14. * The console command description.
  15. *
  16. * @var string
  17. */
  18. protected $description = 'Command description';
  19. /**
  20. * Create a new command instance.
  21. *
  22. * @return void
  23. */
  24. public function __construct()
  25. {
  26. parent::__construct();
  27. }
  28. /**
  29. * Execute the console command.
  30. *
  31. * @return mixed
  32. */
  33. public function handle()
  34. {
  35. //DB::table('distribution_channels')->whereIn('id',[5,123])->update(['pay_merchant_id'=>8]);
  36. $from = $this->option('from');
  37. $to = $this->option('to');
  38. $this->change($from,$to);
  39. }
  40. private function change($from,$to){
  41. DB::table('distribution_channels')->where('pay_merchant_id',$from)->update([
  42. 'pay_merchant_id'=>$to,
  43. 'updated_at'=>date('Y-m-d H:i:s')
  44. ]);
  45. }
  46. }