Chamilo\CoreBundle\Migrations\Schema\V200\Version20250905112000::up()

Complexity

Conditions	10
Paths	21

Size

Total Lines	117
Code Lines	82

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	1

<?php
    public function up(Schema $schema): void
    {
        // Upsert settings (title/comment/category and default selected_value if missing)
        $settings = [
            [
                'name' => 'disable_gdpr',
                'title' => 'Disable GDPR features',
                'comment' => 'If you already manage your personal data protection declaration to users elsewhere, you can safely disable this feature.',
                'category' => 'profile',
                'default' => 'false',
            ],
            [
                'name' => 'show_conditions_to_user',
                'title' => 'Show specific registration conditions',
                'comment' => "Show multiple conditions to user during sign up process. Provide an array with each element containing 'variable' (internal extra field name), 'display_text' (simple text for a checkbox), 'text_area' (long text of conditions).",
                'category' => 'registration',
                'default' => '[]',
            ],
        ];

        foreach ($settings as $setting) {
            $variable = addslashes($setting['name']);
            $title    = addslashes($setting['title']);
            $comment  = addslashes($setting['comment']);
            $category = addslashes($setting['category']);
            $default  = addslashes($setting['default']);

            $sqlCheck = \sprintf(
                "SELECT COUNT(*) AS count
                 FROM settings
                 WHERE variable = '%s'
                   AND subkey IS NULL
                   AND access_url = 1",
                $variable
            );

            $stmt   = $this->connection->executeQuery($sqlCheck);
            $result = $stmt->fetchAssociative();

            if ($result && (int) $result['count'] > 0) {
                $this->addSql(\sprintf(
                    "UPDATE settings
                     SET title = '%s',
                         comment = '%s',
                         category = '%s'
                     WHERE variable = '%s'
                       AND subkey IS NULL
                       AND access_url = 1",
                    $title,
                    $comment,
                    $category,
                    $variable
                ));
                $this->write(\sprintf('Updated setting: %s', $setting['name']));
            } else {
                $this->addSql(\sprintf(
                    "INSERT INTO settings
                        (variable, subkey, type, category, selected_value, title, comment, access_url_changeable, access_url_locked, access_url)
                     VALUES
                        ('%s', NULL, NULL, '%s', '%s', '%s', '%s', 1, 0, 1)",
                    $variable,
                    $category,
                    $default,
                    $title,
                    $comment
                ));
                $this->write(\sprintf('Inserted setting: %s', $setting['name']));
            }
        }

        // Link show_conditions_to_user to its value template (from fixtures), only this variable
        $targetVariable = 'show_conditions_to_user';
        $templatesGrouped = SettingsValueTemplateFixtures::getTemplatesGrouped();

        foreach ($templatesGrouped as $category => $settingsList) {
            foreach ($settingsList as $tpl) {
                if (!isset($tpl['variable']) || $tpl['variable'] !== $targetVariable) {
                    continue;
                }

                $jsonExample = json_encode(
                    $tpl['json_example'],
                    JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE
                );

                // Check if template already exists
                $templateId = $this->connection->fetchOne(
                    'SELECT id FROM settings_value_template WHERE variable = ?',
                    [$targetVariable]
                );

                if ($templateId) {
                    $this->connection->executeStatement(
                        'UPDATE settings_value_template SET json_example = ?, updated_at = NOW() WHERE id = ?',
                        [$jsonExample, $templateId]
                    );
                } else {
                    $this->connection->executeStatement(
                        'INSERT INTO settings_value_template (variable, json_example, created_at, updated_at)
                         VALUES (?, ?, NOW(), NOW())',
                        [$targetVariable, $jsonExample]
                    );
                    $templateId = $this->connection->lastInsertId();
                }

                if ($templateId) {
                    $updatedRows = $this->connection->executeStatement(
                        'UPDATE settings
                         SET value_template_id = ?
                         WHERE variable = ? AND subkey IS NULL AND access_url = 1',
                        [$templateId, $targetVariable]
                    );
                    $this->write("Linked settings.value_template_id for '{$targetVariable}' (updated rows: {$updatedRows})");
                }

                // We found and processed the target; break both loops
                break 2;
            }