<?php
include 'protect.php';
include 'db.php';
include 'store_settings.php';
require_once __DIR__ . '/qbo_name_map_helpers.php';
require_once __DIR__ . '/scheduled_export_helpers.php';

$month = trim((string) ($_REQUEST['month'] ?? ''));
$includeArchived = !empty($_REQUEST['include_archived']);
$mapQboNames = !empty($_REQUEST['map_qbo_names']);

if (!preg_match('/^\d{4}-\d{2}$/', $month)) {
    http_response_code(400);
    echo 'Please choose a valid export month.';
    exit;
}

$qboNameMap = [];

if ($mapQboNames) {
    try {
        $mappingFile = $_FILES['mapping_file'] ?? [];
        if (($mappingFile['error'] ?? UPLOAD_ERR_NO_FILE) === UPLOAD_ERR_NO_FILE) {
            $qboNameMap = qboNameMapLoadSaved($conn);
        } else {
            qboNameMapStoreUploadedFile($conn, $mappingFile);
            $qboNameMap = qboNameMapLoadSaved($conn);
        }
    } catch (Throwable $e) {
        http_response_code(400);
        echo htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8');
        exit;
    }
}

$safeStore = preg_replace('/[^A-Za-z0-9_-]+/', '_', (string) ($_SESSION['store_name'] ?? $_SESSION['store_db'] ?? 'store'));
$filename = $safeStore . '_transactions_' . $month . ($mapQboNames ? '_qbo_mapped' : '') . '.csv';
$csvContent = exportCsvStringForMonth($conn, $month, $includeArchived, $mapQboNames);

header('Content-Type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="' . $filename . '"');
echo $csvContent;
exit;