common/models/Menu.php

<?php
namespace common\models;
use Yii;
  
/**
 * This is the model class for table "menu".
 *
 * @property integer $menu_id
 * @property integer $menu_pid
 * @property integer $menu_lft
 * @property integer $menu_rgt
 * @property integer $termin_id
 * @property integer $show
 * @property integer $sortorder
 */
class Menu extends \yii\db\ActiveRecord
{ 
    public function getMenuList ($location_name)
    {  
        return yii::$app->db->createCommand('
            SELECT 
                menu.menu_id, menu.menu_pid, menu.level,
                termin_lang.termin_title, termin_lang.termin_alias 
            FROM menu
                INNER JOIN menu_location ON menu_location.menu_location_id = menu.menu_location_id
                    AND menu_location.menu_location_name = \''.$location_name.'\'  
                INNER JOIN termin ON termin.termin_id = menu.termin_id
                INNER JOIN termin_lang ON termin_lang.termin_id = menu.termin_id
                    AND termin_lang.lang_id = '.Yii::$app->params['lang_id'].' 
            ORDER BY menu.level ASC, menu.sortorder ASC
        ')->queryAll();
/*
        return $this->find()
            ->selectOption('termin_lang.termin_title')
            ->from('menu')
            ->join(
                'INNER JOIN', 
                'termin_lang.termin_id = menu.termin_id', 
                ['lang_id' => yii::$app->params['lang_id']])
            ->all();
*/
    }
 
    // ==== YII ====
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'menu';
    }
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['menu_pid', 'menu_lft', 'menu_rgt', 'termin_id', 'show', 'sortorder'], 'safe'],
            [['menu_pid', 'menu_lft', 'menu_rgt', 'termin_id', 'show', 'sortorder'], 'integer']
        ];
    }
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'menu_id' => Yii::t('app', 'Menu ID'),
            'menu_pid' => Yii::t('app', 'Menu Pid'),
            'menu_lft' => Yii::t('app', 'Menu Lft'),
            'menu_rgt' => Yii::t('app', 'Menu Rgt'),
            'termin_id' => Yii::t('app', 'Termin ID'),
            'show' => Yii::t('app', 'Show'),
            'sortorder' => Yii::t('app', 'Sortorder'),
        ];
    }
 
}