<?php
namespace App\KommaApp\Pages\Models;

use App\KommaApp\Kms\Core\AbstractTranslationModel;
use App\KommaApp\Kms\Core\HasRoutesInterface;
use App\KommaApp\Routes\Models\RedirectRoute;
use App\KommaApp\Routes\Models\Route;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\MorphOne;
use Illuminate\Database\Eloquent\Relations\MorphMany;
use Illuminate\Database\Query\Builder;

/**
 * Class PageTranslation
 * @package App\KommaApp\Pages\Models
 *
 * @property int page_id
 * @property int language_id
 * @property string slug
 * @property string name
 * @property string description
 * @property string meta_title
 * @property string meta_description
 */
class PageTranslation extends AbstractTranslationModel implements HasRoutesInterface
{
    protected $table = 'page_translations';

    protected $fillable = ['slug', 'name', 'description', 'meta_title', 'meta_description', 'language_id', 'page_id'];

    public function translatable():BelongsTo
    {
        return $this->belongsTo(Page::class);
    }

    /**
     * @return MorphOne returns a MorphOne relation to Route instances
     * @see Route
     */
    public function route(): MorphOne
    {
        return $this->morphOne(Route::class,'routeable');
    }

    /**
     * @return MorphMany returns relation that resolves to RedirectRouteModelInterface
     * @see RedirectRouteModelInterface
     */
    public function redirectRoutes(): MorphMany
    {
        return $this->morphMany(RedirectRoute::class,'routeable');
    }

    /**
     * Returns the query builder to return all routes
     */
    public function routes(): Builder {
        return $this->morphOne(Route::class,'routeable')->getQuery()->union($this->morphMany(RedirectRoute::class,'routeable')->getQuery())->getQuery();
    }
}