UpgradeVocabulary.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use App\Models\WordIndex;
  5. use App\Models\UserDict;
  6. class UpgradeVocabulary extends Command
  7. {
  8. /**
  9. * The name and signature of the console command.
  10. *
  11. * @var string
  12. */
  13. protected $signature = 'upgrade:vocabulary';
  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 int
  33. */
  34. public function handle()
  35. {
  36. if(\App\Tools\Tools::isStop()){
  37. return 0;
  38. }
  39. $words = UserDict::select('word')->groupBy('word')->cursor();
  40. $count=0;
  41. foreach ($words as $word) {
  42. $update = WordIndex::where('word',$word->word)->update(['final'=>1]);
  43. if($update==1){
  44. $this->info("{$count}. {$word->word}");
  45. $count++;
  46. }
  47. }
  48. return 0;
  49. }
  50. }