<?php


namespace App\References;


use App\Base\Service;
use App\References\Models\Reference;

final class ReferenceService extends Service
{

    /**
     * Base query for get reference from DB
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    private function baseReferenceQuery()
    {
        return Reference::where('active', 1)
            ->whereHas('translation')
            ->with('translation')
            ->orderBy('lft','asc');
    }

    /**
     * Get all references
     *
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public function getAllReferences()
    {
        return $this->baseReferenceQuery()->get();
    }


}