<?php


namespace App\KommaApp\Vacancies;


use App\KommaApp\Vacancies\Models\Vacancy;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Pagination\LengthAwarePaginator;

class VacancyService
{

    /**
     * Base query for get vacancies from DB
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    private function baseVacancyQuery()
    {
        return \App::getSite()
            ->vacancies()
            ->with('translation')
            ->where('active', 1)
            ->where('lft', '!=', 1)
            ->orderBy('lft','asc');
    }

    /**
     * Get all posts
     *
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public function getVacancies()
    {
        return $this->baseVacancyQuery()->get();
    }
}