<?php include '../db.php'; ?>

<h2>Email Records</h2>
<a href="add.php">+ Add Email</a><br><br>

<table border="1" cellpadding="5">
<tr>
    <th>Client</th><th>Email Address</th><th>Provider</th><th>Renewal Date</th><th>Status</th><th>Actions</th>
</tr>

<?php
$stmt = $conn->query("
    SELECT e.*, c.name as client_name
    FROM emails e
    JOIN clients c ON e.client_id = c.id
    ORDER BY e.renewal_date ASC
");

foreach ($stmt->fetchAll() as $e) {
    echo "<tr>
        <td>{$e['client_name']}</td>
        <td>{$e['email_address']}</td>
        <td>{$e['provider']}</td>
        <td>{$e['renewal_date']}</td>
        <td>{$e['status']}</td>
        <td>
            <a href='edit.php?id={$e['id']}'>Edit</a> |
            <a href='delete.php?id={$e['id']}' onclick=\"return confirm('Delete this email record?')\">Delete</a>
        </td>
    </tr>";
}
?>
</table>
