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

Complexity

Conditions	8
Paths	28

Size

Total Lines	75
Code Lines	48

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up(Schema $schema): void
    {
        $targetVariable = 'search_prefilter_prefix';

        $templates = SettingsValueTemplateFixtures::getTemplatesGrouped();

        $foundTemplate = null;

        foreach ($templates as $category => $settings) {
            foreach ($settings as $setting) {
                if (($setting['variable'] ?? null) === $targetVariable) {
                    $foundTemplate = $setting;
                    break 2;
                }
            }
        }

        if (!$foundTemplate) {
            $this->write("No template found in SettingsValueTemplateFixtures for variable '{$targetVariable}'. Skipping.");
            return;
        }

        $jsonExample = json_encode(
            $foundTemplate['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]
            );
            $this->write("Updated existing template (ID {$templateId}) for variable '{$targetVariable}'.");
        } 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();
            $this->write("Inserted new template (ID {$templateId}) for variable '{$targetVariable}'.");
        }

        if ($templateId) {
            // Link template to existing settings rows
            $updatedRows = $this->connection->executeStatement(
                'UPDATE settings
                 SET value_template_id = ?
                 WHERE variable = ?',
                [$templateId, $targetVariable]
            );
            $this->write("Updated {$updatedRows} rows in settings for variable '{$targetVariable}'.");

            // Optional: clean legacy boolean values (Yes/No) to avoid invalid JSON
            $cleanedRows = $this->connection->executeStatement(
                "UPDATE settings
                 SET selected_value = ''
                 WHERE variable = ?
                   AND (selected_value = 'true' OR selected_value = 'false')",
                [$targetVariable]
            );
            if ($cleanedRows > 0) {
                $this->write("Cleaned legacy boolean values in {$cleanedRows} rows for variable '{$targetVariable}'.");
            }
        } else {
            $this->write("ERROR: Template ID is null for variable '{$targetVariable}'.");
        }