<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

require_once __DIR__ . '/self_hosted_activation_helpers.php';
require_once __DIR__ . '/scheduled_export_helpers.php';

if (!selfHostedModeEnabled()) {
    echo "This scheduled export sender is intended for self-hosted installs.\n";
    exit(1);
}

if (!selfHostedDbConfigured()) {
    echo "Self-hosted database settings are not configured.\n";
    exit(1);
}

try {
    $conn = selfHostedConnectDb();
    $settings = scheduledExportSettings($conn, '');
    $due = scheduledExportDueMarker($settings);

    if (!$due) {
        echo "No scheduled export is due right now.\n";
        $conn->close();
        exit(0);
    }

    $month = date('Y-m');
    $csv = exportCsvStringForMonth(
        $conn,
        $month,
        !empty($settings['include_archived']),
        !empty($settings['map_qbo_names'])
    );

    $storeName = SELF_HOSTED_STORE_NAME !== '' ? SELF_HOSTED_STORE_NAME : SELF_HOSTED_DB_NAME;
    $safeStore = preg_replace('/[^A-Za-z0-9_-]+/', '_', $storeName);
    $filename = $safeStore . '_transactions_' . $month . (!empty($settings['map_qbo_names']) ? '_qbo_mapped' : '') . '.csv';

    if (!sendScheduledExportEmail((string) $settings['email'], $storeName, $month, $csv, $filename)) {
        throw new RuntimeException('mail() returned false.');
    }

    scheduledExportMarkSent($conn, date('Y-m-d H:i:s'), (string) ($due['marker'] ?? ''));
    $conn->close();
    echo "Scheduled export sent successfully.\n";
    exit(0);
} catch (Throwable $e) {
    echo 'Scheduled export failed: ' . $e->getMessage() . "\n";
    exit(1);
}