<?php
namespace KommaApp\Sites;

use KommaApp\Domains\Domain;

class SiteRepository
{

    /**
     * @param $siteId
     * @return mixed
     */
    public function getSite($siteId)
    {
        return \DB::table('sites')
            ->where('id', '=', $siteId)
            ->select('*')
            ->first();
    }

    /*
     * @returns Object
     */
    public function getSiteWithDomainByDomain(Domain $domain)
    {
        return \DB::table('sites')
            ->join('domains', 'sites.id', '=', 'domains.site_id')
            ->where('domains.domain', '=', $domain->get())
            ->first();
    }

    /*
     * @returns Array
     */
    public function getSitesWithLanguageById($siteId = null)
    {
        $siteLanguages = \DB::table('sites')
            ->join('site_language', 'sites.id', '=', 'site_language.site_id')
            ->join('languages', 'languages.id', '=', 'site_language.language_id')
            ->select('sites.id', 'sites.default_language_id', 'languages.id as language_id', 'languages.iso_2 as language_slug');
        if ($siteId) {
            $siteLanguages = $siteLanguages->where('site_language.site_id', '=', $siteId);
        }
        return $siteLanguages->get();
    }

    public function getSiteCountry($siteId)
    {
        return \DB::table('sites')
            ->join('countries', 'sites.country_id', '=', 'countries.id')
            ->select('countries.name', 'countries.iso_2')
            ->where('sites.id', '=', $siteId)
            ->get();
    }
}