Sid Gifari File Manager

Sid Gifari File Manager

🏠 Root / home / genremedia08 / musicjukebox.overlookedtracks.com / app / Services / Tracks / Queries /

Editing: BaseTrackQuery.php

<?php

namespace App\Services\Tracks\Queries;

use App\Track;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Support\Arr;

abstract class BaseTrackQuery
{
    const ORDER_DIR = 'desc';

public function __construct(protected array $params)
    {
    }

abstract public function get(int $modelId): Builder;

protected function baseQuery(): Builder
    {
        $order = $this->getOrder();

return app(Track::class)
            ->with([
                'artists',
                'album' => function (BelongsTo $q) {
                    return $q->select('id', 'name', 'image');
                },
            ])
            ->orderBy($order['col'], $order['dir'])
            ->orderBy('tracks.id', 'desc');
    }

public function getOrder(): array
    {
        return [
            'col' => Arr::get($this->params, 'orderBy') ?: static::ORDER_COL,
            'dir' => Arr::get($this->params, 'orderDir') ?: static::ORDER_DIR,
        ];
    }
}