<?php include '../db.php'; ?>

<h2>Domain List</h2>
<a href="add.php">+ Add Domain</a> | 
<a href="index.php?filter=expired">Expired Domains</a> | 
<a href="index.php">All Domains</a>
<br><br>

<table border="1" cellpadding="5">
<tr>
    <th>Client</th><th>Domain</th><th>Provider</th><th>Purchase</th><th>Expiry</th><th>Status</th><th>Actions</th>
</tr>

<?php
$filter = $_GET['filter'] ?? '';
$where = "";

if ($filter == 'expired') {
    $today = date('Y-m-d');
    $where = "WHERE expiry_date < '$today'";
}

$stmt = $conn->query("
    SELECT d.*, c.name as client_name 
    FROM domains d 
    JOIN clients c ON d.client_id = c.id 
    $where 
    ORDER BY expiry_date ASC
");

foreach ($stmt->fetchAll() as $d) {
    echo "<tr>
        <td>{$d['client_name']}</td>
        <td>{$d['domain_name']}</td>
        <td>{$d['provider']}</td>
        <td>{$d['purchase_date']}</td>
        <td>{$d['expiry_date']}</td>
        <td>{$d['status']}</td>
        <td>
            <a href='edit.php?id={$d['id']}'>Edit</a> |
            <a href='delete.php?id={$d['id']}' onclick=\"return confirm('Delete this domain?')\">Delete</a> |
            <a href='print.php?id={$d['id']}'>Print</a>
        </td>
    </tr>";
}
?>
</table>
