MultilanguageMigration::createMultiLanguageTable() - Code Metrics - itstructure/yii2-admin-module - Measure and Improve Code Quality continuously with Scrutinizer

MultilanguageMigration::createMultiLanguageTable() A
last analyzed 2025-10-20 07:39 UTC

↳ Parent: MultilanguageMigration

Complexity

Conditions	1
Paths	1

Size

Total Lines	47
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	30
c	1
b	0
f	0
nc	1
nop	4
dl	0
loc	47
rs	9.44

<?php

namespace Itstructure\AdminModule\components;

use yii\helpers\ArrayHelper;

/**
 * Class MultilanguageMigration
 * Class to extend migration with multilanguage.
 *
 * @package Itstructure\AdminModule\components
 *
 * @author Andrey Girnik <[email protected]>
 */
class MultilanguageMigration extends \yii\db\Migration
{
    /**
     * Postfix for translate table name.
     */
    const TRANSLATE_TABLE_POSTFIX = 'language';

    /**
     * Table name to contain the project languages.
     */
    const LANGUAGE_TABLE_NAME = 'language';

    /**
     * Creates table with timestamp fields: created_at and updated_at.
     *
     * @param string $table - table name.
     * @param array $columns - array with names and types of columns.
     * @param string|null $options - additional SQL code.
     *
     * @return void
     */
    public function createTableWithTimestamps(string $table, array $columns, string $options = null): void
    {
        $columns = ArrayHelper::merge($columns, [
            'created_at' => $this->dateTime(),
            'created_at' => $this->/** @scrutinizer ignore-call */ dateTime(),
            'updated_at' => $this->dateTime(),
        ]);
        $this->createTable($table, $columns, $options);
    }

    /**
     * Creates two tables: main table and translate table.
     * For example:
     * catalog:
     *  - id
     *  - created_at
     *  - updated_at
     *
     * catalog_language:
     *  - catalog_id
     *  - language_id
     *  - title
     *  - text
     *
     * @param string $table - table name which needs to be translated.
     * @param array  $multiLanguageColumns - list of multilanguage fields.
     * @param array  $columns - list of simple fields.
     * @param string|null $options - additional SQL code.
     *
     * @return void
     */
    public function createMultiLanguageTable(
        string $table,
        array $multiLanguageColumns,
        array$columns = [],
        string $options = null
    ): void {

        $this->createTableWithTimestamps($table, ArrayHelper::merge([
                'id' => $this->primaryKey()
                'id' => $this->/** @scrutinizer ignore-call */ primaryKey()
            ], $columns)
        );

        $keyToPrimaryTable = $this->getKeyToPrimaryTable($table);
        $keyToLanguageTable = self::getKeyToLanguageTable();

        $languageTableKeys = [
            $keyToPrimaryTable => $this->integer(),
            $keyToPrimaryTable => $this->/** @scrutinizer ignore-call */ integer(),
            $keyToLanguageTable => $this->integer(),
            "PRIMARY KEY($keyToPrimaryTable, $keyToLanguageTable)",
        ];

        $translateTableName = $this->getTranslateTableName($table);

        $this->createTableWithTimestamps(
            $translateTableName,
            ArrayHelper::merge($languageTableKeys, $multiLanguageColumns),
            $options
        );

        $this->addForeignKey(
            $this->createFkName($translateTableName, $keyToPrimaryTable),
            $translateTableName,
            $keyToPrimaryTable,
            $table,
            'id',
            'CASCADE',
            'CASCADE'
        );

        $this->addForeignKey(
            $this->createFkName($translateTableName, $keyToLanguageTable),
            $translateTableName,
            $keyToLanguageTable,
            self::LANGUAGE_TABLE_NAME,
            'id',
            'CASCADE',
            'CASCADE'
        );
    }

    /**
     * Drop main table with translate table.
     *
     * @param string $table - main table name.
     *
     * @return void
     */
    public function dropMultiLanguageTable(string $table): void
    {
        $translateTableName = $this->getTranslateTableName($table);

        $foreignKeyToPrimary = $this->createFkName($translateTableName, $this->getKeyToPrimaryTable($table));
        $foreignKeyToLanguage = $this->createFkName($translateTableName, self::getKeyToLanguageTable());

        $this->dropForeignKey($foreignKeyToPrimary, $translateTableName);
        $this->dropForeignKey($foreignKeyToLanguage, $translateTableName);

        $this->dropTable($translateTableName);
        $this->dropTable($table);
    }

    /**
     * Returns key name for link translate table with languages table.
     *
     * @return string
     */
    public static function getKeyToLanguageTable(): string
    {
        return self::LANGUAGE_TABLE_NAME . '_id';
    }

    /**
     * Returns foreign key to other table.
     *
     * @param string $table
     * @param string $column
     *
     * @return string
     */
    private function createFkName(string $table, string $column): string
    {
        return 'fk-' . $table . '-' . $column;
    }

    /**
     * Returns table name for translates.
     *
     * @param string $table - main table name.
     *
     * @return string
     */
    private function getTranslateTableName(string $table): string
    {
        return $table . '_' . self::TRANSLATE_TABLE_POSTFIX;
    }

    /**
     * Returns key name for link translate table with main table.
     *
     * @param string $table - main table name.
     *
     * @return string
     */
    private function getKeyToPrimaryTable(string $table): string
    {
        return $table . '_id';
    }
}


itstructure / yii2-admin-module

MultilanguageMigration::createMultiLanguageTable() A last analyzed 2025-10-20 07:39 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

MultilanguageMigration::createMultiLanguageTable() A
last analyzed 2025-10-20 07:39 UTC