<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Country extends Model
{
	public $primaryKey  = 'code';
	public $timestamps = false;
	/**
     * Scope a query to include all relations
     * see also https://laravel.com/docs/5.3/eloquent#query-scopes
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
	public function scopeWithAllRelations($query)
	{
		return $query->with(['packages','questions','questions.type','questions.options']);
	}

	/**
	 * retrieve all data including relations from a specific locale
	 * @param  [string] $locale
	 * @return [Country]
	 */
	static function getDataByLocale($locale = NULL) {
		return Country::where('locale','=',$locale)->withAllRelations()->first();
	}

	static function getEnabledCountries() {
		return Country::where('gp_enabled','=',1)->get();
	}

	/**
	 * Eloquent relation to packages
	 */
	public function packages() {
		return $this->hasMany('App\Models\Package','country_code','code')->where('active','=',true);
	}

	/**
	 * Eloquent relation to questions
	 */
	public function questions() {
		return $this->hasMany('App\Models\Question','country_code','code');
	}

}