UpgradeFts.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use App\Models\BookTitle;
  5. use App\Models\FtsText;
  6. class UpgradeFts extends Command
  7. {
  8. /**
  9. * The name and signature of the console command.
  10. *
  11. * @var string
  12. */
  13. protected $signature = 'upgrade:fts {--book}';
  14. /**
  15. * The console command description.
  16. *
  17. * @var string
  18. */
  19. protected $description = 'Command 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 int
  33. */
  34. public function handle()
  35. {
  36. if($this->option('book')){
  37. $bookTitles = BookTitle::orderBy('id')->get();
  38. $bar = $this->output->createProgressBar(count($bookTitles));
  39. foreach ($bookTitles as $key => $value) {
  40. # code...
  41. FtsText::where('book',$value->book)
  42. ->where('paragraph','>=',$value->paragraph)
  43. ->update(['pcd_book_id'=>$value->id]);
  44. $bar->advance();
  45. }
  46. $bar->finish();
  47. return 0;
  48. }
  49. return 0;
  50. }
  51. }