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

$month = isset($_REQUEST['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;
}

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

$storeName = 'HouseTabPro';
if (isset($_SESSION['store_name']) && $_SESSION['store_name'] !== '') {
    $storeName = $_SESSION['store_name'];
} elseif (isset($_SESSION['store_db']) && $_SESSION['store_db'] !== '') {
    $storeName = $_SESSION['store_db'];
}

$filename = exportFilenameForStore($storeName, $month, $mapQboNames);
$csvContent = exportCsvStringForMonth($conn, $month, $includeArchived, $mapQboNames);

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