<?php

namespace App\Repositories;

use App\Models\Location;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Collection;

class OfficeRepository
{

    const SYDNEY = 'Sydney';
    const LONDON = 'London';
    const GIBRALTAR = 'Gibraltar';
    const DUBAI = 'Dubai';
    const LARNACA = 'Larnaca';
    const LIMASSOL = 'Limassol';
    const CYPRUS = 'Cyprus';

    private static function getQuery(): Builder
    {
        return Location::query();
    }

    public static function getOffices(): Collection
    {
        return self::getQuery()->orderBy('position')->where('active', true)->get();
    }

}