OrderByArrayScope.php

<?php

namespace App\Models\Traits;

use Illuminate\Contracts\Database\Eloquent\Builder;

trait OrderByArrayScope
{
    public function scopeOrderByArray(Builder $query, string $key, array $values, string $direction = 'ASC', bool $prefix = true)
    {
        $index = count($values);
        $cases = collect($values)
            ->map(function ($value, $index) use ($key, $prefix) {
                if ($prefix && !str($key)->contains('.')) {
                    $key = $this->getTable() . '.' . $key;
                }

                $value = $value?->value ?? $value;
                return "WHEN {$key} = '{$value}' THEN {$index}";
            })
            ->implode("\n        ");

        $query->orderByRaw(<<<SQL

            CASE
                {$cases}
                ELSE {$index}
            END
            {$direction}
        SQL);
    }
}