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],
        );
    }
 
    // ...
}