Lakshan-Madushanka/movieshark

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Illuminate\Support\Arr;

trait HasSorts
{
    private Builder $sortQuery;

    public function scopeSort(Builder $query): Builder
    {
        $this->sortQuery = $query;
        return $this->applyRequestSorts(request());
    }

    public function checkSortColumnValidity($column): bool
    {
        if ( ! property_exists($this, 'allowedSortColumns') || ! is_array(self::$allowedSortColumns)) {
            return false;
        }

        $validity = array_key_exists($column, self::$allowedSortColumns) && empty(self::$allowedSortColumns[$column]);

        if ( ! empty(self::$allowedSortColumns[$column]) && array_key_exists('columnName', self::$allowedSortColumns[$column])) {
            $validity = true;
        }

        return  $validity;
    }

    private function applyRequestSorts(Request $request): Builder
    {
        if ( ! $request->filled('sort')) {
            return $this->applyDefaultSort();
        }

        $sorts = $request->query('sort');

        if (str($sorts)->contains(',')) {
            $sorts = collect(explode(',', $sorts));
        }

        $sorts = collect(Arr::wrap($sorts));

        $sorts->each(function ($value): void {
            if ( ! $this->checkSortColumnValidity($value)) {
                return;
            }

            $columnName = self::$allowedSortColumns[$value]['columnName'] ?? $value;

            if (str($value)->startsWith('-')) {
                $columnName = str($columnName)->replaceFirst('-', '')->toString();
                $this->applyDescendingSort($columnName);
                return;
            }

            $this->applyAscendingSort($columnName);
        });

        return $this->sortQuery;
    }

    private function applyDescendingSort($value): void
    {
        $this->sortQuery->orderByRaw("{$value} is null")->orderByDesc($value);
    }

    private function applyAscendingSort($value): void
    {
        $this->sortQuery->orderByRaw("{$value} is null")->orderBy($value);
    }

    private function applyDefaultSort(): Builder
    {
        return $this->sortQuery->latest();
    }
}

use App\Models\Concerns\HasSorts;

class Movie extends Model
{
    use HasFactory;
    use HasUlids;
    use HasFilters;
    use HasSorts;

    // ...

    public static $allowedSortColumns = [
        'created_at' => [],
        'downloaded_status' => [],
        'my_rating' => [],
    ];

    // ...
}

use App\Http\Controllers\Controller;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Inertia\Inertia;
use Inertia\Response;

class WatchListController extends Controller
{
    // ..

    public function index(Request $request): Response
    {
        $watchList = Auth::user()
            ->movies()
            ->filter()
            ->Sort()
            ->paginate(10);

        return Inertia::render(
            component: 'Dashboard',
            props: ['watchList' => $watchList],
        );
    }

    // ...
}