<?php
session_start();

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

require_once 'db_connection.php';

try {
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename="payments_' . date('Y-m-d') . '.csv"');
    
    $output = fopen('php://output', 'w');
    fprintf($output, chr(0xEF).chr(0xBB).chr(0xBF));
    
    fputcsv($output, array('Date', 'Buyer', 'Amount Paid'));
    
    $query = "SELECT p.*, b.name as buyer_name FROM payments p JOIN buyers b ON p.buyer_id = b.id ORDER BY p.date DESC";
    $result = $conn->query($query);
    
    while ($row = $result->fetch_assoc()) {
        fputcsv($output, array(
            $row['date'],
            $row['buyer_name'],
            number_format($row['amount_paid'], 2)
        ));
    }

    fclose($output);
    $conn->close();
} catch (Exception $e) {
    header('Content-Type: text/plain');
    echo "Export error";
    error_log("Payments export error: " . $e->getMessage());
}

exit();
?>