UpgradePcdBookId.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use App\Models\FtsText;
  5. use App\Models\WbwTemplate;
  6. use App\Models\BookTitle;
  7. class UpgradePcdBookId extends Command
  8. {
  9. /**
  10. * The name and signature of the console command.
  11. *
  12. * @var string
  13. */
  14. protected $signature = 'upgrade:pcd.book.id {--table=all}';
  15. /**
  16. * The console command description.
  17. *
  18. * @var string
  19. */
  20. protected $description = 'Command description';
  21. /**
  22. * Create a new command instance.
  23. *
  24. * @return void
  25. */
  26. public function __construct()
  27. {
  28. parent::__construct();
  29. }
  30. /**
  31. * Execute the console command.
  32. *
  33. * @return int
  34. */
  35. public function handle()
  36. {
  37. $table = $this->option('table');
  38. $bookTitles = BookTitle::orderBy('id')->get();
  39. $bar = $this->output->createProgressBar(count($bookTitles));
  40. foreach ($bookTitles as $key => $value) {
  41. # code...
  42. if($table === 'all' || $table ==='fts'){
  43. FtsText::where('book',$value->book)
  44. ->where('paragraph','>=',$value->paragraph)
  45. ->update(['pcd_book_id'=>$value->id]);
  46. }
  47. if($table === 'all' || $table ==='wbw'){
  48. WbwTemplate::where('book',$value->book)
  49. ->where('paragraph','>=',$value->paragraph)
  50. ->update(['pcd_book_id'=>$value->id]);
  51. }
  52. $bar->advance();
  53. }
  54. $bar->finish();
  55. return 0;
  56. }
  57. }