90 lines
3.2 KiB
PHP
90 lines
3.2 KiB
PHP
<?php
|
|
// Mail configuration sourced from environment variables and database settings.
|
|
require_once __DIR__ . '/../db/config.php';
|
|
|
|
function env_val(string $key, $default = null) {
|
|
$v = getenv($key);
|
|
return ($v === false || $v === null || $v === '') ? $default : $v;
|
|
}
|
|
|
|
function load_dotenv_if_needed(array $keys): void {
|
|
$missing = array_filter($keys, fn($k) => getenv($k) === false || getenv($k) === '');
|
|
if (empty($missing)) return;
|
|
static $loaded = false;
|
|
if ($loaded) return;
|
|
$envPath = realpath(__DIR__ . '/../../.env'); // executor/.env
|
|
if ($envPath && is_readable($envPath)) {
|
|
$lines = @file($envPath, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES) ?: [];
|
|
foreach ($lines as $line) {
|
|
if ($line[0] === '#' || trim($line) === '') continue;
|
|
if (!str_contains($line, '=')) continue;
|
|
[$k, $v] = array_map('trim', explode('=', $line, 2));
|
|
$v = trim($v, "' ");
|
|
if ($k !== '' && (getenv($k) === false || getenv($k) === '')) {
|
|
putenv("{$k}={$v}");
|
|
}
|
|
}
|
|
$loaded = true;
|
|
}
|
|
}
|
|
|
|
load_dotenv_if_needed([
|
|
'MAIL_TRANSPORT','SMTP_HOST','SMTP_PORT','SMTP_SECURE','SMTP_USER','SMTP_PASS',
|
|
'MAIL_FROM','MAIL_FROM_NAME','MAIL_REPLY_TO','MAIL_TO'
|
|
]);
|
|
|
|
// Fetch from DB
|
|
$db_settings = [];
|
|
$org_name = 'Organization';
|
|
try {
|
|
$pdo = db();
|
|
$stmt = $pdo->query("SELECT setting_key, setting_value FROM settings WHERE setting_key LIKE 'mail_%' OR setting_key LIKE 'pop3_%'");
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
|
|
$db_settings[$row['setting_key']] = $row['setting_value'];
|
|
}
|
|
|
|
// Also fetch org name for default
|
|
$org = $pdo->query("SELECT name_en FROM org_profile LIMIT 1")->fetch();
|
|
if ($org && !empty($org['name_en'])) {
|
|
$org_name = $org['name_en'];
|
|
}
|
|
} catch (Exception $e) {
|
|
// Fallback if DB fails
|
|
}
|
|
|
|
$transport = env_val('MAIL_TRANSPORT', $db_settings['mail_transport'] ?? 'smtp');
|
|
$smtp_host = env_val('SMTP_HOST', $db_settings['mail_host'] ?? '');
|
|
$smtp_port = (int) env_val('SMTP_PORT', $db_settings['mail_port'] ?? 587);
|
|
$smtp_secure = env_val('SMTP_SECURE', $db_settings['mail_encryption'] ?? 'tls');
|
|
$smtp_user = env_val('SMTP_USER', $db_settings['mail_username'] ?? '');
|
|
$smtp_pass = env_val('SMTP_PASS', $db_settings['mail_password'] ?? '');
|
|
|
|
$from_email = env_val('MAIL_FROM', $db_settings['mail_from_address'] ?? 'no-reply@localhost');
|
|
|
|
// Ensure from_name falls back to org_name if DB setting is empty
|
|
$db_from_name = $db_settings['mail_from_name'] ?? '';
|
|
if (empty($db_from_name)) {
|
|
$db_from_name = $org_name;
|
|
}
|
|
$from_name = env_val('MAIL_FROM_NAME', $db_from_name);
|
|
|
|
$reply_to = env_val('MAIL_REPLY_TO');
|
|
|
|
return [
|
|
'transport' => $transport,
|
|
'smtp_host' => $smtp_host,
|
|
'smtp_port' => $smtp_port,
|
|
'smtp_secure' => $smtp_secure,
|
|
'smtp_user' => $smtp_user,
|
|
'smtp_pass' => $smtp_pass,
|
|
'from_email' => $from_email,
|
|
'from_name' => $from_name,
|
|
'reply_to' => $reply_to,
|
|
'org_name' => $org_name,
|
|
'pop3' => [
|
|
'host' => $db_settings['pop3_host'] ?? '',
|
|
'port' => $db_settings['pop3_port'] ?? '995',
|
|
'user' => $db_settings['pop3_username'] ?? '',
|
|
'pass' => $db_settings['pop3_password'] ?? '',
|
|
]
|
|
]; |