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

Complexity

Conditions	10
Paths	64

Size

Total Lines	86
Code Lines	62

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up(Schema $schema): void
    {
        $projectDir = $this->container->getParameter('kernel.project_dir');

The method getParameter() does not exist on null.

        $updateRootPath = $this->getUpdateRootPath();
        $oldMailConfPath = $updateRootPath.'/app/config/mail.conf.php';

        $legacyMailConfig = file_exists($oldMailConfPath);

        if ($legacyMailConfig) {
            include $oldMailConfPath;

            global $platform_email;
        }

        $envFile = $projectDir.'/.env';

        $dotenv = new Dotenv();
        $dotenv->loadEnv($envFile);

        $mailerScheme = 'null';
        $smtpSecure = $_ENV['SMTP_SECURE'] ?? '';
        $query = '';

        if (!empty($smtpSecure)) {
            $mailerScheme = 'smtp';

            if ($smtpSecure === 'ssl') {
                $mailerScheme = 'smtps';
            } elseif ($smtpSecure === 'tls') {
                $query = '?encryption=tls';
            }
        }

        $dsn = sprintf(
            '%s://%s%s@%s:%s%s',
            $mailerScheme,
            !empty($_ENV['SMTP_AUTH']) ? ($_ENV['SMTP_USER'] ?? '') : '',
            !empty($_ENV['SMTP_AUTH']) ? ':'.($_ENV['SMTP_PASS'] ?? '') : '',
            $_ENV['SMTP_HOST'] ?? '',
            $_ENV['SMTP_PORT'] ?? '',
            $query
        );

        $settings = [
            'mailer_from_email' => $_ENV['SMTP_FROM_EMAIL'] ?? '',
            'mailer_from_name' => $_ENV['SMTP_FROM_NAME'] ?? '',
            'mailer_dsn' => $dsn,
            'mailer_mails_charset' => $_ENV['SMTP_CHARSET'] ?? 'UTF-8',
            'mailer_debug_enable' => !empty($_ENV['SMTP_DEBUG']) ? 'true' : 'false',
            'mailer_exclude_json' => $platform_email['EXCLUDE_JSON'] ?? false,
            'mailer_dkim' => '',
            'mailer_xoauth2' => '',
        ];

        if ($legacyMailConfig) {
            $dkim = [
                'enable' => $platform_email['DKIM'] ?? false,
                'selector' => $platform_email['DKIM_SELECTOR'] ?? '',
                'domain' => $platform_email['DKIM_DOMAIN'] ?? '',
                'private_key_string' => $platform_email['DKIM_PRIVATE_KEY_STRING'] ?? '',
                'private_key' => $platform_email['DKIM_PRIVATE_KEY'] ?? '',
                'passphrase' => $platform_email['DKIM_PASSPHRASE'] ?? '',
            ];

            $xoauth2 = [
                'method' => $platform_email['XOAUTH2_METHOD'] ?? false,
                'url_authorize' => $platform_email['XOAUTH2_URL_AUTHORIZE'] ?? '',
                'url_access_token' => $platform_email['XOAUTH2_URL_ACCES_TOKEN'] ?? '',
                'url_resource_owner_details' => $platform_email['XOAUTH2_URL_RESOURCE_OWNER_DETAILS'] ?? '',
                'scopes' => $platform_email['XOAUTH2_SCOPES'] ?? '',
                'client_id' => $platform_email['XOAUTH2_CLIENT_ID'] ?? '',
                'client_secret' => $platform_email['XOAUTH2_CLIENT_SECRET'] ?? '',
                'refresh_token' => $platform_email['XOAUTH2_REFRESH_TOKEN'] ?? '',
            ];

            $settings['mailer_dkim'] = json_encode($dkim);
            $settings['mailer_xoauth2'] = json_encode($xoauth2);

        }
        foreach ($settings as $variable => $value) {
            $this->addSql(
                sprintf(
                    "INSERT IGNORE INTO settings (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url, access_url_changeable, access_url_locked) VALUES ('%s', null, null, 'mail', %s, '%s', null, '', null, 1, 1, 1)",
                    $variable,
                    $value,
                    $variable
                ),
}