[Laravel] Sorting Media Collection of Spacie Media Library by a custom property.

MediaPropertyService.php

<?php

namespace App\Services;

use Illuminate\Support\Collection;
use Spatie\MediaLibrary\HasMedia;
use Spatie\MediaLibrary\MediaCollections\Models\Media;

class MediaPropertyService
{
    public function __construct(
        private readonly HasMedia $subject,
        private readonly string $collectionName = 'default',
    )
    {
        //
    }

    public function getSortedBy(string $customProperty): Collection
    {
        return Media::query()
            ->where('model_type', '=', $this->subject::class)
            ->where('model_id', '=', $this->subject->id)
            ->where('collection_name', '=', $this->collectionName)
            ->orderByRaw("JSON_EXTRACT(custom_properties, \"$.{$customProperty}\") ASC")
            ->get();
    }

    public function getSortedUrlsBy(string $customProperty): Collection
    {
        return $this->getSortedBy($customProperty)
            ->map(fn($item) => $item->getUrl());
    }

    public function getSortedPathsBy(string $customProperty): Collection
    {
        return $this->getSortedBy($customProperty)
            ->map(fn($item) => $item->getPath());
    }
}