<?php


namespace App\Komma\Employees;


use App\Komma\Base\Service;
use App\Komma\Employees\Models\Employee;
use Carbon\Carbon;

final class EmployeeService extends Service
{
    /**
     * Base query for get employee from DB
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    private function baseEmployeeQuery()
    {
        return Employee::where('active', 1)
            ->with('translation', 'images')
//            ->orderBy('department','asc')
            ->orderBy('name', 'desc');
    }

    /**
     * Get all employees
     *
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public function getEmployees()
    {
        return $this->baseEmployeeQuery()->get();
    }
}