<?php


namespace App\Certificates;


use App\Base\Service;
use App\Certificates\Models\Certificate;

final class CertificateService extends Service
{

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

    /**
     * Get all certificates
     *
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public function getAllCertificates()
    {
        return $this->baseCertificateQuery()->get();
    }


}