<?php

namespace bff\modules\site\models;

use Site;
use bff\db\illuminate\Model;
use bff\db\illuminate\Langs;

/**
 * Site Page model
 * @copyright Tamaranga
 */
class Page extends Model
{
    use Langs;

    protected $table = Site::TABLE_PAGES;

    /**
     * Modifier user relation
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function modifier()
    {
        return $this->hasOne($this->modelClass('User', 'Users'), 'user_id', 'modified_uid');
    }

    /**
     * Translatable columns
     * @return array
     */
    public function langColumns()
    {
        return ['title', 'content', 'mtitle', 'mkeywords', 'mdescription', 'content_publicator_search'];
    }

    /**
     * Check if filename is unique
     * @param string $filename
     * @param int $except page id
     * @return bool
     */
    public function filenameExists($filename, $except = 0)
    {
        $query = $this->where('filename', $filename);
        if ($except) {
            $query->where('id', '!=', $except);
        }
        return (int)$query->count() > 0;
    }
}