mint/api-v13/app/Console/Commands/ExportAiPaliWordToken.php

<?php

namespace App\Console\Commands;

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

class ExportAiPaliWordToken extends Command
{
    /**
     * The name and signature of the console command.
     * php artisan export:ai.pali.word.token
     *
     * @var string
     */
    protected $signature = 'export:ai.pali.word.token {--format=gz  : zip file format 7z,lzma,gz }';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'export ai pali word token';

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

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        Log::debug('export ai pali word token');

        if (Tools::isStop()) {
            return 0;
        }
        $exportDir = storage_path('app/tmp/export/offline');
        if (! is_dir($exportDir)) {
            $res = mkdir($exportDir, 0755, true);
            if (! $res) {
                Log::error('mkdir fail path='.$exportDir);

                return 1;
            } else {
                Log::info('make dir successful '.$exportDir);
            }
        }

        $dict_id = DictApi::getSysDict('system_preference');
        if (! $dict_id) {
            Log::error('没有找到 system_preference 字典');

            return 1;
        }

        $filename = 'ai-pali-word-token-'.date('Y-m-d').'.tsv';
        $exportFile = $exportDir.'/'.$filename;
        $fp = fopen($exportFile, 'w');
        if ($fp === false) {
            Log::error('无法创建文件');

            return 1;
        }

        $start = time();
        $total = UserDict::where('dict_id', $dict_id)->count();
        $words = UserDict::where('dict_id', $dict_id)
            ->select([
                'word',
                'factors',
            ])->cursor();
        foreach ($words as $key => $word) {
            $output = [$word->word, $word->factors];
            fwrite($fp, implode("\t", $output)."\n");
            if ($key % 100 === 0) {
                $present = (int) ($key * 100 / $total);
                $this->info("[{$present}%]-{$key}");
            }
        }
        fclose($fp);
        Log::info((time() - $start).' seconds');

        $this->call('export:zip', [
            'id' => 'ai-pali-word-token',
            'filename' => $exportFile,
            'title' => 'ai pali word token',
            'format' => $this->option('format'),
        ]);

        return 0;
    }
}