<?php
/* * ********************************************************************************************
 * 								Open Real Estate
 * 								----------------
 * 	version				:	V1.36.0
 * 	copyright			:	(c) 2016 Monoray
 * 							http://monoray.net
 * 							http://monoray.ru
 *
 * 	website				:	http://open-real-estate.info/en
 *
 * 	contact us			:	http://open-real-estate.info/en/contact-us
 *
 * 	license:			:	http://open-real-estate.info/en/license
 * 							http://open-real-estate.info/ru/license
 *
 * This file is part of Open Real Estate
 *
 * ********************************************************************************************* */

class Article extends ParentModel
{

    public $title;
    private static $_lastArticles;

    public static function model($className = __CLASS__)
    {
        return parent::model($className);
    }

    public function tableName()
    {
        return '{{articles}}';
    }

    public function rules()
    {
        return array(
            array('page_title, page_body', 'i18nRequired'),
            array('page_title', 'i18nLength', 'min' => 2, 'max' => 255),
            array('page_body', 'i18nLength', 'min' => 2),
            array('date_updated', 'safe', 'on' => 'search'),
            array($this->getI18nFieldSafe(), 'safe')
        );
    }

    public function i18nFields()
    {
        return array(
            'page_title' => 'varchar(255) not null default ""',
            'page_body' => 'text null',
        );
    }

    public function seoFields()
    {
        return array(
            'fieldTitle' => 'page_title',
            'fieldDescription' => 'page_body'
        );
    }

    public function getPage_title()
    {
        return $this->getStrByLang('page_title');
    }

    public function getPage_body()
    {
        return $this->getStrByLang('page_body');
    }

    public function attributeLabels()
    {
        return array(
            'page_title' => tt('Title / Question'),
            'page_body' => tt('Body / Answer'),
            'date_updated' => tc('Date updated'),
            'active' => tt('Status'),
        );
    }

    public function search()
    {

        $criteria = new CDbCriteria;
        $tmp = 'page_title_' . Yii::app()->language;
        $criteria->compare($tmp, $this->$tmp, true);

        $tmp = 'page_body_' . Yii::app()->language;
        $criteria->compare($tmp, $this->$tmp, true);

        return new CustomActiveDataProvider($this, array(
            'criteria' => $criteria,
            'sort' => array(
                'defaultOrder' => $this->getTableAlias() . '.sorter ASC',
            ),
            'pagination' => array(
                'pageSize' => param('adminPaginationPageSize', 20),
            ),
        ));
    }

    public function behaviors()
    {
        $arr = array();
        $arr['AutoTimestampBehavior'] = array(
            'class' => 'zii.behaviors.CTimestampBehavior',
            'createAttribute' => null,
            'updateAttribute' => 'date_updated',
        );
        if (issetModule('historyChanges')) {
            $arr['ArLogBehavior'] = array(
                'class' => 'application.modules.historyChanges.components.ArLogBehavior',
            );
        }

        return $arr;
    }

    public function afterFind()
    {
        $this->title = $this->page_title;
    }

    public function beforeSave()
    {
        if ($this->isNewRecord) {
            $this->active = 1;

            $maxSorter = Yii::app()->db->createCommand()
                ->select('MAX(sorter) as maxSorter')
                //->where('active=1')
                ->from('{{articles}}')
                ->queryScalar();
            $this->sorter = $maxSorter + 1;
        }
        return parent::beforeSave();
    }

    public function beforeDelete()
    {
        if (issetModule('seo')) {
            $sql = 'DELETE FROM {{seo_friendly_url}} WHERE model_id="' . $this->id . '" AND model_name = "Article"';
            Yii::app()->db->createCommand($sql)->execute();

            $sql = 'DELETE FROM {{seo_friendly_url_history}} WHERE model_id="' . $this->id . '" AND model_name = "Article"';
            Yii::app()->db->createCommand($sql)->execute();
        }

        $sql = 'DELETE FROM {{comments}} WHERE model_id=:id AND model_name="Article"';
        Yii::app()->db->createCommand($sql)->execute(array(':id' => $this->id));

        return parent::beforeDelete();
    }

    public function afterSave()
    {
        if (issetModule('seo')) {
            SeoFriendlyUrl::getAndCreateForModel($this);
        }
        return parent::afterSave();
    }

    public function getUrl()
    {
        if (issetModule('seo')) {
            $seo = SeoFriendlyUrl::getForUrl($this->id, 'Article');

            if ($seo) {
                $field = 'url_' . Yii::app()->language;
                if ($seo->$field) {
                    return Yii::app()->createAbsoluteUrl('/articles/main/view', array(
                        'url' => $seo->$field . (param('urlExtension') ? '.html' : ''),
                    ));
                }
            }
        }

        return Yii::app()->createAbsoluteUrl('/articles/main/view', array(
            'id' => $this->id,
        ));
    }

    public static function getCacheDependency()
    {
        return new CDbCacheDependency('SELECT MAX(date_updated) FROM {{articles}}');
    }

    public static function getRel($id, $lang)
    {
        $model = self::model()->resetScope()->findByPk($id);

        $title = 'page_title_' . $lang;
        $model->title = $model->$title;

        return $model;
    }

    public static function getLastArticles()
    {
        if (self::$_lastArticles === null) {
            $criteriaArticles = new CDbCriteria();
            $criteriaArticles->limit = 4;
            $criteriaArticles->order = 'id DESC';

            self::$_lastArticles = Article::model()->findAll($criteriaArticles);
        }
        return self::$_lastArticles;
    }
}
