Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

30.0 KB
Raw Blame
<?php
require_once 'includes/header.php';
require_once 'includes/oidc_settings.php';
require_once 'includes/ssrf_helper.php';
require_once 'includes/instance_config.php';

if ($isAdmin != 1) {
    header('Location: index.php');
    exit;
}

// get admin settings from admin table, with anything the deployment owns
// applied over them
$adminConfiguration = wallos_get_effective_admin_configuration($db);
$settings = $adminConfiguration['settings'];
$instanceManagedFields = $adminConfiguration['managed_fields'];
$instanceNotes = $adminConfiguration['notes'];

$oidcConfiguration = wallos_get_effective_oidc_configuration($db);
$oidcSettings = $oidcConfiguration['settings'];
$oidcManagedFields = $oidcConfiguration['managed_fields'];
$oidcNotes = $oidcConfiguration['notes'];

$ssrfConfiguration = wallos_get_effective_ssrf_allowlist($db);
$ssrfManagedFields = $ssrfConfiguration['is_managed'] ? ['allowlist' => 'SSRF_ALLOWLIST'] : [];

function oidc_input_attrs($field, $managedFields)
{
    return isset($managedFields[$field]) ? 'disabled data-managed-by="' . htmlspecialchars($managedFields[$field]) . '"' : '';
}

// get user accounts
$stmt = $db->prepare('SELECT id, username, email FROM user ORDER BY id ASC');
$result = $stmt->execute();

$users = [];
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
    $users[] = $row;
}
$userCount = is_array($users) ? count($users) : 0;

$loginDisabledAllowed = $userCount == 1 && $settings['registrations_open'] == 0;
?>

<section class="contain settings">

    <section class="account-section">
        <header>
            <h2><?= translate('registrations', $i18n) ?></h2>
        </header>
        <div class="admin-form">
            <div class="form-group-inline">
                <input type="checkbox" id="registrations" <?= $settings['registrations_open'] ? 'checked' : '' ?> />
                <label for="registrations"><?= translate('enable_user_registrations', $i18n) ?></label>
            </div>
            <div class="form-group">
                <label for="maxUsers"><?= translate('maximum_number_users', $i18n) ?></label>
                <input type="number" id="maxUsers" autocomplete="off" value="<?= $settings['max_users'] ?>" />
            </div>
            <div class="settings-notes">
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('max_users_info', $i18n) ?>
                </p>
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('registrations_disable_login_info', $i18n) ?>
                </p>
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="requireEmail" <?= $settings['require_email_verification'] ? 'checked' : '' ?>
                    <?= empty($settings['smtp_address']) ? 'disabled' : '' ?> />
                <label for="requireEmail">
                    <?= translate('require_email_verification', $i18n) ?>
                </label>
            </div>
            <?php
            if (empty($settings['smtp_address'])) {
                ?>
                <div class="settings-notes">
                    <p>
                        <i class="fa-solid fa-circle-info"></i>
                        <?= translate('configure_smtp_settings_to_enable', $i18n) ?>
                    </p>
                </div>
                <?php
            }
            ?>
            <div class="form-group">
                <label for="serverUrl"><?= translate('server_url', $i18n) ?></label>
                <input type="text" id="serverUrl" autocomplete="off" value="<?= htmlspecialchars($settings['server_url']) ?>" />
            </div>
            <div class="settings-notes">
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('server_url_info', $i18n) ?>
                </p>
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('server_url_password_reset', $i18n) ?>
                </p>
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="disableLogin" <?= $settings['login_disabled'] ? 'checked' : '' ?>
                    <?= $loginDisabledAllowed ? '' : 'disabled' ?> />
                <label for="disableLogin"><?= translate('disable_login', $i18n) ?></label>
            </div>
            <div class="settings-notes">
                <p>
                    <i class="fa-solid fa-triangle-exclamation" aria-hidden="true"></i>
                    <?= translate('disable_login_info', $i18n) ?>
                </p>
                <p>
                    <i class="fa-solid fa-triangle-exclamation" aria-hidden="true"></i>
                    <?= translate('disable_login_info2', $i18n) ?>
                </p>
            </div>
            <div class="buttons">
                <input type="submit" class="thin mobile-grow" value="<?= translate('save', $i18n) ?>"
                    id="saveAccountRegistrations" onClick="saveAccountRegistrationsButton()" />
            </div>
        </div>
    </section>

    <?php
    if ($userCount >= 0) {
        ?>

        <section class="account-section">
            <header>
                <h2><?= translate('user_management', $i18n) ?></h2>
            </header>
            <div class="user-list">
                <?php
                foreach ($users as $user) {
                    $userIcon = $user['id'] == 1 ? 'fa-user-shield' : 'fa-user';
                    ?>
                    <div class="form-group-inline" data-userid="<?= $user['id'] ?>">
                        <div class="user-list-row">
                            <div title="<?= translate('username', $i18n) ?>">
                                <div class="user-list-icon">
                                    <i class="fa-solid <?= $userIcon ?>"></i>
                                </div>
                                <?= htmlspecialchars($user['username']) ?>
                            </div>
                            <div title="<?= translate('email', $i18n) ?>">
                                <div class="user-list-icon">
                                    <i class="fa-solid fa-at"></i>
                                </div>
                                <a href="mailto:<?= htmlspecialchars($user['email']) ?>"><?= htmlspecialchars($user['email']) ?></a>
                            </div>
                        </div>
                        <div>
                            <?php
                            if ($user['id'] != 1) {
                                ?>
                                <button class="image-button medium" onClick="removeUser(<?= $user['id'] ?>)"
                                    title="<?= translate('delete_user', $i18n) ?>">
                                    <i class="fa-solid fa-trash-can"></i>
                                </button>
                                <?php
                            } else {
                                ?>
                                <button class="image-button medium disabled" disabled
                                    title="<?= translate('delete_user', $i18n) ?>">
                                    <i class="fa-solid fa-trash-can"></i>
                                </button>
                                <?php
                            }
                            ?>

                        </div>
                    </div>
                    <?php
                }
                ?>
            </div>
            <div class="settings-notes">
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('delete_user_info', $i18n) ?>
                </p>
            </div>
            <h2><?= translate('create_user', $i18n) ?></h2>
            <div class="form-group">
                <input type="text" id="newUsername" autocomplete="off"
                    placeholder="<?= translate('username', $i18n) ?>" />
            </div>
            <div class="form-group">
                <input type="email" id="newEmail" autocomplete="off"
                    placeholder="<?= translate('email', $i18n) ?>" />
            </div>
            <div class="form-group-inline">
                <input type="password" id="newPassword" autocomplete="off"
                    placeholder="<?= translate('password', $i18n) ?>" />
                <input type="submit" class="thin" value="<?= translate('add', $i18n) ?>" id="addUserButton"
                    onClick="addUserButton()" />
            </div>
        </section>

        <?php
    }
    ?>

    <section class="account-section">
        <header>
            <h2><?= translate('oidc_settings', $i18n) ?></h2>
        </header>
        <div class="admin-form">
            <div class="form-group-inline">
                <input type="checkbox" id="oidcEnabled" <?= $oidcConfiguration['enabled'] ? 'checked' : '' ?>
                    <?= oidc_input_attrs('enabled', $oidcManagedFields) ?>
                    onchange="toggleOidcEnabled()" />
                <label for="oidcEnabled"><?= translate('oidc_oauth_enabled', $i18n) ?></label>
            </div>
            <div class="form-group">
                <input type="text" id="oidcName" placeholder="Provider Name" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['name']) ?>" <?= oidc_input_attrs('name', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcClientId" placeholder="Client ID" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['client_id']) ?>" <?= oidc_input_attrs('client_id', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcClientSecret" placeholder="Client Secret" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['client_secret']) ?>" <?= oidc_input_attrs('client_secret', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcAuthUrl" placeholder="Auth URL" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['authorization_url']) ?>" <?= oidc_input_attrs('authorization_url', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcTokenUrl" placeholder="Token URL" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['token_url']) ?>" <?= oidc_input_attrs('token_url', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcUserInfoUrl" placeholder="User Info URL" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['user_info_url']) ?>" <?= oidc_input_attrs('user_info_url', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcRedirectUrl" placeholder="Redirect URL" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['redirect_url']) ?>" <?= oidc_input_attrs('redirect_url', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcLogoutUrl" placeholder="Logout URL" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['logout_url']) ?>" <?= oidc_input_attrs('logout_url', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcUserIdentifierField" placeholder="User Identifier Field" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['user_identifier_field']) ?>" <?= oidc_input_attrs('user_identifier_field', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="text" id="oidcScopes" placeholder="Scopes" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['scopes']) ?>" <?= oidc_input_attrs('scopes', $oidcManagedFields) ?> />
            </div>
            <div class="form-group">
                <input type="hidden" id="oidcAuthStyle" placeholder="Auth Style" autocomplete="off"
                    value="<?= htmlspecialchars($oidcSettings['auth_style']) ?>" />
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="oidcAutoCreateUser" <?= $oidcSettings['auto_create_user'] ? 'checked' : '' ?>
                    <?= oidc_input_attrs('auto_create_user', $oidcManagedFields) ?> />
                <label for="oidcAutoCreateUser"><?= translate('create_user_automatically', $i18n) ?></label>
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="oidcPasswordLoginDisabled"
                    <?= $oidcSettings['password_login_disabled'] ? 'checked' : '' ?>
                    <?= oidc_input_attrs('password_login_disabled', $oidcManagedFields) ?> />
                <label for="oidcPasswordLoginDisabled"><?= translate('disable_password_login', $i18n) ?></label>
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="oidcRequireEmailVerified"
                    <?= $oidcSettings['require_email_verified'] ? 'checked' : '' ?>
                    <?= oidc_input_attrs('require_email_verified', $oidcManagedFields) ?> />
                <label for="oidcRequireEmailVerified"><?= translate('require_email_verified_linking', $i18n) ?></label>
            </div>
            <?php if (!empty($oidcManagedFields) || !empty($oidcNotes)): ?>
                <div class="settings-notes">
                    <?php if (!empty($oidcManagedFields)): ?>
                        <p>
                            <i class="fa-solid fa-circle-info"></i>
                            OIDC fields managed by environment variables are shown here but cannot be edited in the UI.
                        </p>
                    <?php endif; ?>
                    <?php foreach ($oidcNotes as $oidcNote): ?>
                        <p>
                            <i class="fa-solid fa-circle-info"></i>
                            <?= htmlspecialchars($oidcNote) ?>
                        </p>
                    <?php endforeach; ?>
                </div>
            <?php endif; ?>
            <div class="buttons">
                <input type="submit" class="thin mobile-grow" value="<?= translate('save', $i18n) ?>"
                    id="saveOidcSettingsButton" onClick="saveOidcSettingsButton()" />
            </div>
        </div>

    </section>

    <section class="account-section">
        <header>
            <h2><?= translate('smtp_settings', $i18n) ?></h2>
        </header>
        <div class="admin-form">
            <div class="form-group-inline">
                <input type="text" name="smtpaddress" id="smtpaddress" autocomplete="off"
                    placeholder="<?= translate('smtp_address', $i18n) ?>" value="<?= htmlspecialchars($settings['smtp_address']) ?>"
                    <?= oidc_input_attrs('smtp_address', $instanceManagedFields) ?> />
                <input type="text" name="smtpport" id="smtpport" autocomplete="off"
                    placeholder="<?= translate('port', $i18n) ?>" class="one-third" value="<?= htmlspecialchars($settings['smtp_port']) ?>"
                    <?= oidc_input_attrs('smtp_port', $instanceManagedFields) ?> />
            </div>
            <div class="form-group-inline">
                <div>
                    <input type="radio" name="encryption" id="encryptionnone" value="none"
                        <?= empty($settings['encryption']) || $settings['encryption'] == "none" ? "checked" : "" ?>
                        <?= oidc_input_attrs('encryption', $instanceManagedFields) ?> />
                    <label for="encryptionnone"><?= translate('none', $i18n) ?></label>
                </div>
                <div>
                    <input type="radio" name="encryption" id="encryptiontls" value="tls"
                        <?= $settings['encryption'] == "tls" ? "checked" : "" ?>
                        <?= oidc_input_attrs('encryption', $instanceManagedFields) ?> />
                    <label for="encryptiontls"><?= translate('tls', $i18n) ?></label>
                </div>
                <div>
                    <input type="radio" name="encryption" id="encryptionssl" value="ssl"
                        <?= $settings['encryption'] == "ssl" ? "checked" : "" ?>
                        <?= oidc_input_attrs('encryption', $instanceManagedFields) ?> />
                    <label for="encryptionssl"><?= translate('ssl', $i18n) ?></label>
                </div>
            </div>
            <div class="form-group-inline">
                <input type="text" name="smtpusername" id="smtpusername" autocomplete="off"
                    placeholder="<?= translate('smtp_username', $i18n) ?>" value="<?= htmlspecialchars($settings['smtp_username']) ?>"
                    <?= oidc_input_attrs('smtp_username', $instanceManagedFields) ?> />
            </div>
            <div class="form-group-inline">
                <?php if (isset($instanceManagedFields['smtp_password'])): ?>
                    <?php /* The value is never rendered when the deployment owns it: a mounted
                             secret that reaches the page source has left the place it was
                             mounted into. The field says it is set, and nothing more. */ ?>
                    <input type="password" name="smtppassword" id="smtppassword" autocomplete="off"
                        placeholder="<?= translate('smtp_password', $i18n) ?>" value=""
                        <?= oidc_input_attrs('smtp_password', $instanceManagedFields) ?> />
                <?php else: ?>
                    <input type="password" name="smtppassword" id="smtppassword" autocomplete="off"
                        placeholder="<?= translate('smtp_password', $i18n) ?>" value="<?= htmlspecialchars($settings['smtp_password']) ?>" />
                <?php endif; ?>
            </div>
            <div class="form-group-inline">
                <input type="text" name="fromemail" id="fromemail" autocomplete="off"
                    placeholder="<?= translate('from_email', $i18n) ?>" value="<?= htmlspecialchars($settings['from_email']) ?>"
                    <?= oidc_input_attrs('from_email', $instanceManagedFields) ?> />
            </div>
            <div class="buttons">
                <input type="button" class="secondary-button thin mobile-grow" value="<?= translate('test', $i18n) ?>"
                    id="testSmtpSettingsButton" onClick="testSmtpSettingsButton()" />
                <input type="submit" class="thin mobile-grow" value="<?= translate('save', $i18n) ?>"
                    id="saveSmtpSettingsButton" onClick="saveSmtpSettingsButton()" />
            </div>
            <div class="settings-notes">
                <p>
                    <i class="fa-solid fa-circle-info"></i> <?= translate('smtp_info', $i18n) ?>
                </p>
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('smtp_usage_info', $i18n) ?>
                </p>
                <?php if (!empty($instanceManagedFields)): ?>
                    <p>
                        <i class="fa-solid fa-circle-info"></i>
                        Fields managed by environment variables are shown here but cannot be
                        edited in the UI: <?= htmlspecialchars(implode(', ', $instanceManagedFields)) ?>.
                    </p>
                <?php endif; ?>
                <?php foreach ($instanceNotes as $instanceNote): ?>
                    <p>
                        <i class="fa-solid fa-circle-info"></i>
                        <?= htmlspecialchars($instanceNote) ?>
                    </p>
                <?php endforeach; ?>
            </div>
        </div>
    </section>

    <section class="account-section">
    <header>
        <h2><?= translate('security_settings', $i18n) ?></h2> </header>
    <div class="admin-form">
        <div class="form-group-inline">
            <input type="text" name="local_webhook_notifications_allowlist" id="local_webhook_notifications_allowlist" autocomplete="off"
                placeholder="e.g., 192.168.1.5:8123, homeassistant.local" value="<?= htmlspecialchars($ssrfConfiguration['raw'], ENT_QUOTES, 'UTF-8') ?>" <?= oidc_input_attrs('allowlist', $ssrfManagedFields) ?> />
        </div>

        <div class="settings-notes">
            <p>
                <i class="fa-solid fa-circle-info"></i>
                <?= translate('ssrf_protection_info', $i18n) ?>
            </p>
            <p>
                <i class="fa-solid fa-circle-info"></i>
                <?= translate('local_webhook_info', $i18n) ?>
            </p>
            <?php if ($ssrfConfiguration['is_managed']): ?>
                <p>
                    <i class="fa-solid fa-circle-info"></i>
                    <?= translate('ssrf_allowlist_env_managed', $i18n) ?>
                </p>
            <?php endif; ?>
        </div>

        <div class="form-group-inline">
            <input type="checkbox" id="allow_standard_users_local_webhooks" name="allow_standard_users_local_webhooks"
                <?= $ssrfConfiguration['allow_standard_users'] ? 'checked' : '' ?> />
            <label for="allow_standard_users_local_webhooks"><?= translate('allow_standard_users_local_webhooks', $i18n) ?></label>
        </div>

        <div class="settings-notes">
            <p>
                <i class="fa-solid fa-triangle-exclamation" aria-hidden="true"></i>
                <?= translate('allow_standard_users_local_webhooks_info', $i18n) ?>
            </p>
        </div>

        <div class="buttons">
            <input type="submit" class="thin mobile-grow" value="<?= translate('save', $i18n) ?>"
                id="saveSecuritySettingsButton" onClick="saveSecuritySettingsButton()" />
        </div>
    </div>
</section>

    <?php
    // Get latest version from admin table
    if (!is_null($settings['latest_version'])) {
        $latestVersion = $settings['latest_version'];
        $hasUpdate = version_compare($version, $latestVersion) == -1;
    } else {
        $hasUpdate = false;
    }

    // find unused upload logos

    // Get all logos in the subscriptions table
    $query = 'SELECT logo, logo_variant FROM subscriptions';
    $stmt = $db->prepare($query);
    $result = $stmt->execute();

    $logosOnDisk = [];
    $logosOnDB = [];
    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        $logosOnDB[] = $row['logo'];
        $logosOnDB[] = $row['logo_variant'];
    }

    // Get all logos in the payment_methods table
    $query = 'SELECT icon FROM payment_methods';
    $stmt = $db->prepare($query);
    $result = $stmt->execute();

    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        if (!strstr($row['icon'], "images/uploads/icons/")) {
            $logosOnDB[] = $row['icon'];
        }
    }

    $logosOnDB = array_unique($logosOnDB);

    // Get all logos in the uploads folder
    $uploadDir = 'images/uploads/logos/';
    $uploadFiles = scandir($uploadDir);

    foreach ($uploadFiles as $file) {
        if ($file != '.' && $file != '..' && $file != 'avatars') {
            $logosOnDisk[] = ['logo' => $file];
        }
    }

    // Find unused logos
    $unusedLogos = [];
    foreach ($logosOnDisk as $disk) {
        $found = false;
        foreach ($logosOnDB as $dbLogo) {
            if ($disk['logo'] == $dbLogo) {
                $found = true;
                break;
            }
        }
        if (!$found) {
            $unusedLogos[] = $disk;
        }
    }

    $logosToDelete = count($unusedLogos);

    ?>

    <section class="account-section">
        <header>
            <h2>
                <?= translate('maintenance_tasks', $i18n) ?>
            </h2>
        </header>
        <div class="maintenance-tasks">
            <h3><?= translate('update', $i18n) ?></h3>
            <div class="form-group">
                <?php
                if ($hasUpdate) {
                    ?>
                    <div class="updates-list">
                        <p class="updates-list-title">
                            <i class="fa-solid fa-arrow-up"></i>
                            <?= translate('new_version_available', $i18n) ?>.
                        </p>
                        <p>
                            <?= translate('current_version', $i18n) ?>:
                            <span>
                                <?= htmlspecialchars($version) ?>
                                <a href="https://github.com/ellite/Wallos/releases/tag/<?= htmlspecialchars($version) ?>"
                                    target="_blank" title="<?= translate('external_url', $i18n) ?>" rel="noreferrer">
                                    <i class="fa-solid fa-arrow-up-right-from-square"></i>
                                </a>
                            </span>
                        </p>
                        <p>
                            <?= translate('latest_version', $i18n) ?>:
                            <span class="updates-list-latest">
                                <?= htmlspecialchars($latestVersion) ?>
                                <a href="https://github.com/ellite/Wallos/releases/tag/<?= htmlspecialchars($latestVersion) ?>"
                                    target="_blank" title="<?= translate('external_url', $i18n) ?>" rel="noreferrer">
                                    <i class="fa-solid fa-arrow-up-right-from-square"></i>
                                </a>
                            </span>
                        </p>
                    </div>
                    <?php
                } else {
                    ?>
                    <?= translate('on_current_version', $i18n) ?>
                    <?php
                }
                ?>
            </div>
            <div class="form-group-inline">
                <input type="checkbox" id="updateNotification" <?= $settings['update_notification'] ? 'checked' : '' ?>
                    onchange="toggleUpdateNotification()" />
                <label for="updateNotification"><?= translate('show_update_notification', $i18n) ?></label>
            </div>
            <h3><?= translate('orphaned_logos', $i18n) ?></h3>
            <div class="form-group-inline">
                <input type="button" class="button thin mobile-grow" value="<?= translate('delete', $i18n) ?>"
                    id="deleteUnusedLogos" onClick="deleteUnusedLogos()" <?= $logosToDelete == 0 ? 'disabled' : '' ?> />
                <span class="number-of-logos bold"><?= $logosToDelete ?></span>
                <?= translate('orphaned_logos', $i18n) ?>
            </div>
            <h3><?= translate('cronjobs', $i18n) ?></h3>
            <div>
                <div class="inline-row">
                    <input type="button" value="Check for Updates" class="button tiny mobile-grow"
                        onclick="executeCronJob('checkforupdates')">
                    <input type="button" value="Send Notifications" class="button tiny mobile-grow"
                        onclick="executeCronJob('sendnotifications')">
                    <input type="button" value="Send Cancellation Notifications" class="button tiny mobile-grow"
                        onclick="executeCronJob('sendcancellationnotifications')">
                    <input type="button" value="Send Password Reset Emails" class="button tiny mobile-grow"
                        onclick="executeCronJob('sendresetpasswordemails')">
                    <input type="button" value="Send Verification Emails" class="button tiny mobile-grow"
                        onclick="executeCronJob('sendverificationemails')">
                    <input type="button" value="Update Exchange Rates" class="button tiny mobile-grow"
                        onclick="executeCronJob('updateexchange')">
                    <input type="button" value="Update Next Payments" class="button tiny mobile-grow"
                        onclick="executeCronJob('updatenextpayment')">
                    <input type="button" value="Store Total Yearly Cost" class="button tiny mobile-grow"
                        onclick="executeCronJob('storetotalyearlycost')">
                    <input type="button" value="Generate AI Recommendations" class="button tiny mobile-grow"
                        onclick="executeCronJob('generaterecommendations')">    
                </div>
                <div class="inline-row">
                    <textarea id="cronjobResult" class="thin" readonly></textarea>
                </div>
            </div>
        </div>
    </section>

    <section class="account-section">
        <header>
            <h2><?= translate('backup_and_restore', $i18n) ?></h2>
        </header>
        <div class="form-group-inline">
            <input type="button" class="button thin mobile-grow" value="<?= translate('backup', $i18n) ?>" id="backupDB"
                onClick="backupDB()" />
            <input type="button" class="secondary-button thin mobile-grow" value="<?= translate('restore', $i18n) ?>"
                id="restoreDB" onClick="openRestoreDBFileSelect()" />
            <input type="file" name="restoreDBFile" id="restoreDBFile" style="display: none;" onChange="restoreDB()"
                accept=".zip">
        </div>
        <div class="settings-notes">
            <p>
                <i class="fa-solid fa-circle-info"></i>
                <?= translate('restore_info', $i18n) ?>
            </p>
        </div>
    </section>

</section>
<script src="scripts/admin.js?<?= $version ?>"></script>

<?php
require_once 'includes/footer.php';
?>