1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / edfvgrwl / system / webentity / frontend / models /
Filename : Books.php
back
<?php

namespace app\models;

use Yii;

/**
 * This is the model class for table "books".
 *
 * @property integer $id
 * @property string $title_az
 * @property string $title_en
 * @property string $content_az
 * @property string $content_en
 *
 */
class Books extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'books';
    }
    
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['title_az', 'title_en'], 'required'],
            [['content_az', 'content_en'], 'string'],
            [['title_az', 'title_en'], 'string', 'max' => 255]
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'title_az' => 'Başlıq (az)',
            'title_en' => 'Başlıq (en)',
            'content_az' => 'Kontent (az)',
            'content_en' => 'Kontent (en)',
        ];
    }

    public function getActiveMenu()
    {
        return $this->find()
        ->where(['active' => self::MENU_ACTIVE])
        ->orderBy(['id' => SORT_DESC])
        ->one();
    }

    public static function dropDown()
    {
        $models = self::find()->all();
        $dropdown = [];
        foreach ($models as $model) {
            $dropdown[$model->id] = $model->title_az;
        }
        return $dropdown;
    }

    public static function getMenuById($id){
        $model = self::find()
        ->select(['title_az'])
        ->where(['id'=>$id])
        ->one();
        return is_object($model)?$model: $id;
    }

    public static function getTitleById($id){
        $model = self::find()
        ->select(['title_az'])
        ->where(['id'=>$id])
        ->one();
        return is_object($model)?$model->title_az: $id;
    }

    public function getItems()
    {
        $items = $this->find()
        ->where(['root' => 1])
        ->orderBy(['id' => SORT_DESC])
        ->all();
        return $items;
    }
}