autocde2.0/app/Console/Commands/SyncBimConvertStatus.php

<?php

namespace App\Console\Commands;

use App\Libraries\BIM\BIMFactory;
use App\Models\BimFile;
use App\Models\Enums\BimFileConvertStatus;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Support\Facades\Log;

class SyncBimConvertStatus extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'lpc:sync-bim-convert-status';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'sync bim convert status';

    /**
     * Execute the console command.
     */
    public function handle()
    {
        Log::info('start to sync bim convert status');

        BimFile::query()
            ->where("created_at", ">=", Carbon::now()->subDay())
            ->whereIn("convert_status", BimFileConvertStatus::unfinishedStatus())
            ->chunkById(2000, function (Collection $bimFiles) {
                $this->queryStatus($bimFiles);
            });
    }

    protected function queryStatus(Collection $bimFiles)
    {
        foreach ($bimFiles as $bimFile) {
            try {
                $statusArr = BIMFactory::make($bimFile->bim_driver)->findConvertStatus($bimFile->bim_data_set_id);

                $bimFile->fill($statusArr);
                $bimFile->save();

            } catch (\Exception $exception) {
            }
        }
    }
}