<?php

use App\Collections\BuildingCollection;
use App\Models\Building;
use Illuminate\Database\Migrations\Migration;

return new class extends Migration {

    public function up(): void
    {
        /** @var BuildingCollection $buildingsWithFloorsInfo */
        $buildingsWithFloorsInfo = Building::query()->whereNotNull('floors_info')->where('floors_info', '!=', '')->get();
        foreach ($buildingsWithFloorsInfo as $building) {
            $floorsInfo = explode('-', $building->floors_info);
            $floorsInfo = array_filter($floorsInfo, fn($floorsInfoItem) => ctype_digit($floorsInfoItem));
            if (empty($floorsInfo)) {
                continue;
            }
            $building->update(['floors' => max($floorsInfo)]);
        }
    }

    public function down(): void
    {
    }

};