davide-casiraghi/laravel-events-calendar

<?php

namespace DavideCasiraghi\LaravelEventsCalendar\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Cache;

class Country extends Model
{
    /***************************************************************************/
    /**
     * The table associated with the model.
     *
     * @var string
     */
    protected $table = 'countries';

    /***************************************************************************/

    protected $fillable = [
        'name', 'code', 'continent_id',
    ];

    /***************************************************************************/

    /**
     * Return all the countries ordered by name.
     *
     * @return iterable
     */
    public static function getCountries(): iterable
    {
        $seconds = 86400; // One day
        $ret = Cache::remember('countries_list', $seconds, function () {
            return self::orderBy('name')->pluck('name', 'id');
        });

        return $ret;
    }

    /***************************************************************************/

    /**
     * Return the all countries with active events.
     *
     * @return iterable
     */
    public static function getActiveCountries(): ?iterable
    {
        $seconds = 900; // 15 minutes

        // All the countries
        $ret = Cache::remember('active_countries', $seconds, function () {
            date_default_timezone_set('Europe/Rome');
            $searchStartDate = date('Y-m-d', time());
            $lastestEventsRepetitionsQuery = EventRepetition::getLastestEventsRepetitionsQuery($searchStartDate, null);

            return self::
            select('countries.*')
                ->join('event_venues', 'countries.id', '=', 'event_venues.country_id')
                ->join('events', 'event_venues.id', '=', 'events.venue_id')
                ->joinSub($lastestEventsRepetitionsQuery, 'event_repetitions', function ($join) {
                    $join->on('events.id', '=', 'event_repetitions.event_id');
                })
                ->orderBy('countries.name')
                ->get();
        });

        return $ret;
    }

    /***************************************************************************/

    /**
     * Return the all active countries by continent.
     * @param int $continent_id
     * @return iterable
     */
    public static function getActiveCountriesByContinent($continent_id): ?iterable
    {
        $activeCountries = self::getActiveCountries()->unique('name')->sortBy('name');
        $ret = $activeCountries->where('continent_id', $continent_id);

        return $ret;
    }

    /***************************************************************************/

    /**
     * Return the all countries with teachers.
     *
     * @return \Illuminate\Support\Collection
     */
    public static function getCountriesWithTeachers(): ?iterable
    {
        $ret = self::join('teachers', 'countries.id', '=', 'teachers.country_id')
                      ->orderBy('countries.name')->pluck('countries.name', 'countries.id');

        return $ret;
    }

    /***************************************************************************/

    /*
     * Return active Continent and Countries JSON Tree (for hp select filters, vue component).
     *
     * @return string
     */
    /*public static function getActiveCountriesByContinent()
    {
        $minutes = 15;
        $ret = Cache::remember('active_continent_countries_json_tree', $minutes, function () {
            return Country::orderBy('name')->pluck('name', 'id');
        });

        return $ret;
    }*/

    /***************************************************************************/

    /**
     * Return the country name.
     * @param int $countryId
     * @return string
     */
    public static function getCountryName($countryId): string
    {
        $country = self::select('name')->where('id', $countryId)->get();
        $ret = $country[0]['name'];

        return $ret;
    }
}