Chamilo\CoreBundle\Migrations\Schema\V200\Version20240928003000

Complexity

Total Complexity

17

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getDescription()	0	3	1
B	down()	0	34	8
B	up()	0	41	8

<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

final class Version20240928003000 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Add new fields to session and c_lp tables for handling reinscription and session repetition logic, and insert new settings if not exist.';
    }

    public function up(Schema $schema): void
    {
        $schemaManager = $this->connection->createSchemaManager();

        // Add fields to the 'session' table
        if ($schemaManager->tablesExist('session')) {
            $sessionTable = $schemaManager->listTableColumns('session');

            if (!isset($sessionTable['parent_id'])) {
                $this->addSql("ALTER TABLE session ADD parent_id INT DEFAULT NULL");
            }
            if (!isset($sessionTable['days_to_reinscription'])) {
                $this->addSql("ALTER TABLE session ADD days_to_reinscription INT DEFAULT NULL");
            }
            if (!isset($sessionTable['last_repetition'])) {
                $this->addSql("ALTER TABLE session ADD last_repetition TINYINT(1) DEFAULT 0 NOT NULL");
            }
            if (!isset($sessionTable['days_to_new_repetition'])) {
                $this->addSql("ALTER TABLE session ADD days_to_new_repetition INT DEFAULT NULL");
            }
        }

        // Add fields to the 'c_lp' (Learnpath) table
        if ($schemaManager->tablesExist('c_lp')) {
            $clpTable = $schemaManager->listTableColumns('c_lp');

            if (!isset($clpTable['validity_in_days'])) {
                $this->addSql("ALTER TABLE c_lp ADD validity_in_days INT DEFAULT NULL");
            }
        }

        // Insert new settings if not exist
        $this->addSql("
            INSERT INTO settings (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url, access_url_changeable, access_url_locked)
            SELECT 'enable_auto_reinscription', NULL, NULL, 'session', '0', 'Enable Auto Reinscription', 'Allow users to be automatically reinscribed in new sessions.', '', NULL, 1, 1, 1
            WHERE NOT EXISTS (
                SELECT 1 FROM settings WHERE variable = 'enable_auto_reinscription'
            )
        ");

        $this->addSql("
            INSERT INTO settings (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url, access_url_changeable, access_url_locked)
            SELECT 'enable_session_replication', NULL, NULL, 'session', '0', 'Enable Session Replication', 'Allow replication of session data across instances.', '', NULL, 1, 1, 1
            WHERE NOT EXISTS (
                SELECT 1 FROM settings WHERE variable = 'enable_session_replication'
            )
        ");
    }

    public function down(Schema $schema): void
    {
        $schemaManager = $this->connection->createSchemaManager();

        // Revert changes in the 'session' table
        if ($schemaManager->tablesExist('session')) {
            $sessionTable = $schemaManager->listTableColumns('session');

            if (isset($sessionTable['parent_id'])) {
                $this->addSql("ALTER TABLE session DROP COLUMN parent_id");
            }
            if (isset($sessionTable['days_to_reinscription'])) {
                $this->addSql("ALTER TABLE session DROP COLUMN days_to_reinscription");
            }
            if (isset($sessionTable['last_repetition'])) {
                $this->addSql("ALTER TABLE session DROP COLUMN last_repetition");
            }
            if (isset($sessionTable['days_to_new_repetition'])) {
                $this->addSql("ALTER TABLE session DROP COLUMN days_to_new_repetition");
            }
        }

        // Revert changes in the 'c_lp' table
        if ($schemaManager->tablesExist('c_lp')) {
            $clpTable = $schemaManager->listTableColumns('c_lp');

            if (isset($clpTable['validity_in_days'])) {
                $this->addSql("ALTER TABLE c_lp DROP COLUMN validity_in_days");
            }
        }

        // Remove settings
        $this->addSql("DELETE FROM settings WHERE variable = 'enable_auto_reinscription'");
        $this->addSql("DELETE FROM settings WHERE variable = 'enable_session_replication'");
    }
}