<?php
require 'config.php';

$result = $conn->query("SELECT * FROM crm_entries ORDER BY submitted_at DESC");

if ($result->num_rows > 0) {
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=leads.csv');

    $output = fopen('php://output', 'w');

    fputcsv($output, [
        'Name', 'Email', 'Phone', 'Location', 'Purpose', 'Status',
        'Follow-Up Needed', 'Follow-Up Date', 'Assigned Staff',
        'Origin of Lead', 'Caller Response', 'Additional Info', 'Date Submitted'
    ]);

    while ($row = $result->fetch_assoc()) {
        fputcsv($output, [
            $row['caller_name'],
            $row['caller_email'],
            $row['caller_phone'],
            $row['caller_location'],
            $row['call_purpose'],
            $row['lead_status'],
            $row['follow_up_needed'],
            $row['follow_up_date'],
            $row['assigned_staff'],
            $row['source'],
            $row['caller_response'],
            $row['additional_info'],
            $row['submitted_at']
        ]);
    }

    fclose($output);
    exit();
} else {
    echo "No leads found.";
}