mint/app/Console/Commands/UpgradeFts.php

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\BookTitle;
use App\Models\FtsText;
use App\Models\WbwTemplate;

class UpgradeFts extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'upgrade:fts {--content : upgrade col content}
        {para?}
        {--test : output log}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'upgrade full text search table';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {

        if($this->option('content')){
            if(!empty($this->argument('para'))){
                $para = explode('-',$this->argument('para'));
                $content = $this->getContent($para[0],$para[1]);
                if($this->option('test')){
                    $this->info($content);
                }else{
                    FtsText::where('book',$para[0])->where('paragraph',$para[1])->update(['content'=>$content]);
                }
            }else{
                for ($iBook=1; $iBook <= 217; $iBook++) {
                    # code...
                    $this->info('book:'.$iBook);
                    $maxParagraph = WbwTemplate::where('book',$iBook)->max('paragraph');
                    $bar = $this->output->createProgressBar($maxParagraph-1);
                    for($iPara=1; $iPara <= $maxParagraph; $iPara++){
                        $content = $this->getContent($iBook,$iPara);
                        FtsText::where('book',$iBook)->where('paragraph',$iPara)->update(['content'=>$content]);
                        $bar->advance();
                    }
                    $bar->finish();
                    $this->info('done');
                }
            }


        }
        return 0;
    }

    private function getContent($book,$para){
        $words = WbwTemplate::where('book',$book)
                            ->where('paragraph',$para)
                            ->where('type',"<>",".ctl.")
                            ->orderBy('wid')->get();
        $content = '';
        foreach ($words as  $word) {
            if($word->style === 'bld'){
                if(strpos($word->word,"{")===FALSE){
                    $content .= "**{$word->word}** ";
                }else{
                    $content .= str_replace(['{','}'],['**','** '],$word->word);
                }
            }else if($word->style === 'note'){
                $content .= " _{$word->word}_ ";
            }else{
                $content .= $word->word . " ";
            }
        }
        return $content;
    }
}