[Из песочницы] Мультиязычные деревья в Yii2 на примере создания модуля меню16.10.2018 19:04

db = 'db';
        parent::init();
    }

    public function safeUp()
    {
        $tableOptions = 'ENGINE=InnoDB';
        $this->createTable('{{%menu}}', [
            'id'=> $this->primaryKey(11),
            'parent_id'=> $this->integer(11)->null()->defaultValue(null),
            'link'=> $this->string(255)->notNull()->defaultValue('#'),
            'link_attributes'=> $this->text()->notNull(),
            'icon_class'=> $this->string(255)->notNull(),
            'sort'=> $this->integer(11)->notNull()->defaultValue(0),
            'status'=> $this->tinyInteger(1)->notNull()->defaultValue(1),
        ], $tableOptions);
        $this->createIndex('parent_sort', '{{%menu}}', ['parent_id','sort'], false);
        $this->createTable('{{%menu_lang}}', [
            'owner_id'=> $this->integer(11)->notNull(),
            'language'=> $this->string(2)->notNull(),
            'name'=> $this->string(255)->notNull(),
            'title'=> $this->text()->notNull(),
        ], $tableOptions);
        $this->addPrimaryKey('pk_on_menu_lang', '{{%menu_lang}}', ['owner_id','language']);
        $this->addForeignKey(
            'fk_menu_lang_owner_id',
            '{{%menu_lang}}',
            'owner_id',
            '{{%menu}}',
            'id',
            'CASCADE',
            'CASCADE'
        );
        // Insert sample data
        $this->batchInsert(
            '{{%menu}}',
            ['id', 'parent_id', 'link', 'link_attributes', 'icon_class', 'sort', 'status'],
            [
                [
                    'id' => '1',
                    'parent_id' => null,
                    'link' => '#',
                    'link_attributes' => '',
                    'icon_class' => '',
                    'sort' => '0',
                    'status' => '0',
                ],
                [
                    'id' => '2',
                    'parent_id' => '1',
                    'link' => '/',
                    'link_attributes' => '',
                    'icon_class' => 'fa fa-home',
                    'sort' => '0',
                    'status' => '1',
                ],
            ]
        );
        $this->batchInsert(
            '{{%menu_lang}}',
            ['owner_id', 'language', 'name', 'title'],
            [
                [
                    'owner_id' => '1',
                    'language' => 'ru',
                    'name' => 'Главное меню',
                    'title' => '',
                ],
                [
                    'owner_id' => '1',
                    'language' => 'en',
                    'name' => 'Main menu',
                    'title' => '',
                ],
                [
                    'owner_id' => '2',
                    'language' => 'ru',
                    'name' => 'Главная',
                    'title' => 'Главная страница сайта',
                ],
                [
                    'owner_id' => '2',
                    'language' => 'en',
                    'name' => 'Home',
                    'title' => 'Site homepage',
                ],
            ]
        );
    }

    public function safeDown()
    {
        $this->truncateTable('{{%menu}} CASCADE');
        $this->dropForeignKey('fk_menu_lang_owner_id', '{{%menu_lang}}');
        $this->dropTable('{{%menu}}');
        $this->dropPrimaryKey('pk_on_menu_lang', '{{%menu_lang}}');
        $this->dropTable('{{%menu_lang}}');
    }
}

 [
                'class' => TranslateableBehavior::class,
                'translationAttributes' => $translationAttributes,
                'translationRelation' => 'translations',
                'translationLanguageAttribute' => 'language',
            ],
        ];
    }

    public function transactions()
    {
        return [
            self::SCENARIO_DEFAULT => self::OP_INSERT | self::OP_UPDATE,
        ];
    }

    public function getLang()
    {
        return $this->hasOne(self::langClass(), ['owner_id' => 'id'])->where([self::langTableName() . '.language' => Yii::$app->language]);
    }

    public function getTranslations()
    {
        return $this->hasMany(self::langClass(), ['owner_id' => 'id']);
    }

}

 [
                'class' => AdjacencyListBehavior::class,
                'parentAttribute' => 'parent_id',
                'sortable' => [
                    'step' => 10,
                ],
                'checkLoop' => false,
                'parentsJoinLevels' => 5,
                'childrenJoinLevels' => 5,
            ],
        ];
    }

    public static function find()
    {
        $queryClass = self::getQueryClass();
        return new $queryClass(get_called_class());
    }

    public static function listTree($node = null, $level = 1, $nameAttribute = 'name', $prefix = '-->')
    {
        $result = [];
        if (!$node) {
            $node = self::find()->roots()->one()->populateTree();
        }
        if ($node->isRoot()) {
            $result[$node['id']] = mb_strtoupper($node[$nameAttribute ?: 'slug']);
        }
        if ($node['children']) {
            foreach ($node['children'] as $child) {
                $result[$child['id']] = str_repeat($prefix, $level) . $child[$nameAttribute];
                $result = $result + self::listTree($child, $level + 1, $nameAttribute);
            }
        }
        return $result;
    }

    public static function treeViewData($node = null)
    {
        if ($node === null) {
            $node = self::find()->roots()->one()->populateTree();
        }
        $result = null;
        $items = null;
        $children = null;
        if ($node['children']) {
            foreach ($node['children'] as $child) {
                $items[] = self::treeViewData($child);
            }
            $children = call_user_func_array('array_merge', $items);
        }
        $result[] = [
            'text' => Html::a($node['lang']['name'] ?: $node['id'], ['update', 'id' => $node['id']], ['title' => Yii::t('app', 'Редактировать элемент')]),
            'tags' => [
                Html::a(
                    '',
                    ['move-down', 'id' => $node['id']],
                    ['title' => Yii::t('app', 'Передвинуть вниз')]
                ),
                Html::a(
                    '',
                    ['move-up', 'id' => $node['id']],
                    ['title' => Yii::t('app', 'Передвинуть вверх')]
                )
            ],
            'backColor' => $node['status'] == 0 ? '#ccc' : '#fff',
            'selectable' => false,
            'nodes' => $children,
        ];
        return $result;
    }
}

treeBehaviors(),
            $this->langBehaviors(['name', 'title'])
        );
    }

    public static function tableName()
    {
        return 'menu';
    }

    public function rules()
    {
        return [
            [['parent_id', 'sort', 'status'], 'integer'],
            [['link', 'icon_class'], 'string', 'max' => 255],
            [['link_attributes'], 'string'],
            [['link'], 'default', 'value' => '#'],
            [['link_attributes', 'icon_class'], 'default', 'value' => ''],
            [['parent_id'], 'exist', 'skipOnError' => true, 'targetClass' => self::class, 'targetAttribute' => ['parent_id' => 'id']],
        ];
    }

    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'parent_id' => Yii::t('app', 'Родитель'),
            'link' => Yii::t('app', 'Ссылка'),
            'link_attributes' => Yii::t('app', 'Атрибуты ссылки (JSON массив)'),
            'icon_class' => Yii::t('app', 'Класс иконки'),
            'sort' => Yii::t('app', 'Сортировка'),
            'status' => Yii::t('app', 'Опубликован'),
        ];
    }

    public static function menuItems($node = null)
    {
        if ($node === null) {
            $node = self::find()->roots()->one()->populateTree();
        }
        $result = null;
        $items = null;
        $children = null;
        if ($node['children']) {
            foreach ($node['children'] as $child) {
                $items[] = self::menuItems($child);
            }
            $children = call_user_func_array('array_merge', $items);
        }
        $result[] = [
            'label' => ($node['icon_class'] ? ' ' . ($node['lang']['name'] ?: $node['id']) : ($node['lang']['name'] ?: $node['id'] )),
            'encode' => ($node['icon_class'] ? false : true),
            'url' => [$node['link'], 'language' => Yii::$app->language],
            'active' => $node['link'] == Yii::$app->request->url ? true : false,
            'linkOptions' => ($node['link_attributes'] ? array_merge(json_decode($node['link_attributes'], true), ['title' => ($node['lang']['title'] ?: $node['lang']['name'])]) : ['title' => ($node['lang']['title'] ?: $node['lang']['name'])]),
            'items' => $children,
        ];
        return $result;
    }
}

 255],
        ];
    }

    public function attributeLabels()
    {
        return [
            'owner_id' => Yii::t('app', 'Владелец'),
            'language' => Yii::t('app', 'Язык'),
            'name' => Yii::t('app', 'Название'),
            'title' => Yii::t('app', 'Всплывающая подсказка'),
        ];
    }

    public function getOwner()
    {
        return $this->hasOne(Menu::class, ['id' => 'owner_id']);
    }
}