<?php

/**
 * 生成系统规则变形词典
 * 算法： 扫描字典里的所有单词。根据语尾表变形。
 * 并在词库中查找是否在三藏中出现。出现的保存。
 */

namespace App\Console\Commands;

use App\Http\Api\DictApi;
use App\Models\UserDict;
use App\Tools\CaseMan;
use App\Tools\Tools;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;

class UpgradeDictSysRegular extends Command
{
    /**
     * The name and signature of the console command.
     * php artisan upgrade:regular jāta
     *
     * @var string
     */
    protected $signature = 'upgrade:regular {word?} {--debug}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'upgrade regular';

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

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        if (Tools::isStop()) {
            return 0;
        }
        $dict_id = DictApi::getSysDict('system_regular');
        if (! $dict_id) {
            $this->error('没有找到 system_regular 字典');

            return 1;
        } else {
            $this->info("system_regular :{$dict_id}");
        }

        if (empty($this->argument('word'))) {
            $words = UserDict::where('type', '.n:base.')
                ->orWhere('type', '.v:base.')
                ->orWhere('type', '.adj:base.')
                ->orWhere('type', '.ti:base.');
            $init = UserDict::where('dict_id', $dict_id)
                ->update(['flag' => 0]);
        } else {
            $words = UserDict::where('word', $this->argument('word'))
                ->where(function ($query) {
                    $query->where('type', '.n:base.')
                        ->orWhere('type', '.v:base.')
                        ->orWhere('type', '.adj:base.')
                        ->orWhere('type', '.ti:base.');
                });
            $init = UserDict::where('dict_id', $dict_id)
                ->where('word', $this->argument('word'))
                ->update(['flag' => 0]);
        }
        $words = $words->select(['word', 'type', 'grammar'])
            ->groupBy(['word', 'type', 'grammar'])
            ->orderBy('word');
        $query = "
		select count(*) from (select count(*) from user_dicts ud where
			\"type\" = '.v:base.' or
			\"type\" = '.n:base.' or
			\"type\" = '.ti:base.' or
			\"type\" = '.adj:base.'
			group by word,type,grammar) as t;
		";
        $count = DB::select($query);
        $bar = $this->output->createProgressBar($count[0]->count);
        $caseMan = new CaseMan;
        foreach ($words->cursor() as $word) {
            if ($this->option('debug')) {
                $this->info("{$word->word}:{$word->type}");
            }
            $newWords = $caseMan->Declension($word->word, $word->type, $word->grammar, 0.5);
            if ($this->option('debug')) {
                $this->info("{$word->word}:".count($newWords));
            }
            foreach ($newWords as $newWord) {
                if (isset($newWord['type'])) {
                    $type = $newWord['type'];
                } else {
                    $type = \str_replace(':base', '', $word->type);
                }

                $new = UserDict::firstOrNew(
                    [
                        'word' => $newWord['word'],
                        'type' => $type,
                        'grammar' => $newWord['grammar'],
                        'parent' => $word->word,
                        'factors' => $newWord['factors'],
                        'dict_id' => $dict_id,
                    ],
                    [
                        'id' => app('snowflake')->id(),
                        'source' => '_ROBOT_',
                        'create_time' => (int) (microtime(true) * 1000),
                    ]
                );
                $new->confidence = 80;
                $new->language = 'cm';
                $new->creator_id = 1;
                $new->flag = 1;
                $new->save();
            }

            $bar->advance();
        }
        $bar->finish();
        if (! empty($this->argument('word'))) {
            $declensions = UserDict::where('dict_id', $dict_id)
                ->where('parent', $this->argument('word'))
                ->select('word')
                ->groupBy('word')
                ->get();
            foreach ($declensions as $key => $word) {
                Log::debug($word->word);
            }
        }
        // 删除旧数据
        $table = UserDict::where('dict_id', $dict_id);
        if (! empty($this->argument('word'))) {
            $table = $table->where('parent', $this->argument('word'));
        }
        $table->where('flag', 0)->delete();

        // DB::enableQueryLog();
        $newRecord = UserDict::where('dict_id', $dict_id);
        if (! empty($this->argument('word'))) {
            $newRecord = $newRecord->where('parent', $this->argument('word'));
        }
        $newRecord->where('flag', 1)->update(['flag' => 0]);

        // print_r(DB::getQueryLog());
        return 0;
    }
}