<?php
require_once __DIR__ . '/../../config/config.php';
require_once __DIR__ . '/../../includes/auth.php';

requireAdmin();
$db = getDBConnection();

if (isset($_GET['download']) && $_GET['download'] === 'csv') {
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=sales_report_' . date('Y-m-d') . '.csv');

    $output = fopen('php://output', 'w');
    // Output UTF-8 BOM for Excel compatibility with Thai characters
    fputs($output, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF)));

    fputcsv($output, ['Order No', 'Customer Name', 'Total Amount', 'Payment Method', 'Payment Status', 'Order Status', 'Date']);

    $stmt = $db->query("SELECT o.order_no, u.fullname, o.total_amount, o.payment_method, o.payment_status, o.order_status, o.created_at FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.id DESC");
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        fputcsv($output, $row);
    }
    fclose($output);
    exit;
}

require_once __DIR__ . '/../../includes/admin_header.php';
?>

<h3 class="fw-bold mb-4">📄 สรุปรายงาน & Export ข้อมูล</h3>

<div class="card card-custom p-4 text-center py-5">
  <div class="fs-1 mb-2">📊</div>
  <h4 class="fw-bold">ส่งออกข้อมูลคำสั่งซื้อเป็นไฟล์ CSV / Excel</h4>
  <p class="text-muted">รองรับการเปิดอ่านภาษาไทยใน Microsoft Excel ได้อย่างถูกต้องทันที</p>
  
  <div class="mt-3">
    <a href="export.php?download=csv" class="btn btn-success rounded-pill px-4 py-2 fs-5">
      📥 ดาวน์โหลดรายงาน (CSV Export)
    </a>
  </div>
</div>

<?php require_once __DIR__ . '/../../includes/admin_footer.php'; ?>
