<?php
include 'db.php';
session_start();

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit;
}

/* ============================================================
   HELPER
============================================================ */
function e($value)
{
    return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8');
}

/* ============================================================
   PAGINATION
============================================================ */
$limit = 10;

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) {
    $page = 1;
}

$start = ($page - 1) * $limit;

/* ============================================================
   SAVE PAYMENT
============================================================ */
if (isset($_POST['save'])) {

    $domain_id    = (int)($_POST['domain_id'] ?? 0);
    $client_name  = trim($_POST['client_name'] ?? '');
    $description  = trim($_POST['description'] ?? '');
    $amount       = (float)($_POST['amount'] ?? 0);
    $payment_mode = trim($_POST['payment_mode'] ?? '');
    $payment_date = $_POST['payment_date'] ?? '';

    if (
        $domain_id > 0 &&
        $client_name !== '' &&
        $amount > 0 &&
        $payment_mode !== '' &&
        $payment_date !== ''
    ) {

        $stmt = mysqli_prepare(
            $conn,
            "INSERT INTO payments
            (domain_id, client_name, description, amount, payment_mode, payment_date)
            VALUES (?, ?, ?, ?, ?, ?)"
        );

        if ($stmt) {

            mysqli_stmt_bind_param(
                $stmt,
                "issdss",
                $domain_id,
                $client_name,
                $description,
                $amount,
                $payment_mode,
                $payment_date
            );

            mysqli_stmt_execute($stmt);
            mysqli_stmt_close($stmt);
        }
    }

    header("Location: add-payment.php?saved=1");
    exit;
}

/* ============================================================
   DOMAIN LIST
============================================================ */
$domains = mysqli_query(
    $conn,
    "SELECT id, domain_name, client_name
     FROM domains
     ORDER BY domain_name ASC"
);

/* ============================================================
   TOTAL RECORDS
============================================================ */
$totalQuery = mysqli_query(
    $conn,
    "SELECT COUNT(*) AS c FROM payments"
);

$totalRow = mysqli_fetch_assoc($totalQuery);
$total = (int)($totalRow['c'] ?? 0);

$totalPages = max(1, ceil($total / $limit));

if ($page > $totalPages) {
    $page = $totalPages;
    $start = ($page - 1) * $limit;
}

/* ============================================================
   TOTAL PAYMENT
============================================================ */
$totalAmtQuery = mysqli_query(
    $conn,
    "SELECT COALESCE(SUM(amount),0) AS s FROM payments"
);

$totalAmtRow = mysqli_fetch_assoc($totalAmtQuery);
$totalAmt = (float)($totalAmtRow['s'] ?? 0);

/* ============================================================
   TODAY PAYMENT
============================================================ */
$todayQuery = mysqli_query(
    $conn,
    "SELECT COALESCE(SUM(amount),0) AS s
     FROM payments
     WHERE payment_date = CURDATE()"
);

$todayRow = mysqli_fetch_assoc($todayQuery);
$todayAmt = (float)($todayRow['s'] ?? 0);

/* ============================================================
   THIS MONTH PAYMENT
============================================================ */
$monthQuery = mysqli_query(
    $conn,
    "SELECT COALESCE(SUM(amount),0) AS s
     FROM payments
     WHERE YEAR(payment_date)=YEAR(CURDATE())
     AND MONTH(payment_date)=MONTH(CURDATE())"
);

$monthRow = mysqli_fetch_assoc($monthQuery);
$monthAmt = (float)($monthRow['s'] ?? 0);

/* ============================================================
   PAYMENT DATA
============================================================ */
$payments = mysqli_query(
    $conn,
    "
    SELECT
        p.*,
        d.domain_name
    FROM payments p
    LEFT JOIN domains d
        ON d.id = p.domain_id
    ORDER BY p.payment_date DESC, p.id DESC
    LIMIT $start,$limit
    "
);
?>

<!DOCTYPE html>
<html lang="en">

<head>

<meta charset="UTF-8">

<meta name="viewport"
      content="width=device-width, initial-scale=1.0">

<title>Receive Payments | CAPAPP Dashboard</title>

<link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css"
rel="stylesheet">

<link
href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.1/font/bootstrap-icons.css"
rel="stylesheet">

<style>

/* ============================================================
   ROOT
============================================================ */

:root{
    --primary:#2563eb;
    --primary-dark:#1d4ed8;
    --navy:#0f172a;
    --navy2:#1e293b;
    --text:#172033;
    --muted:#64748b;
    --bg:#f1f5f9;
    --white:#ffffff;
    --border:#e2e8f0;
    --green:#16a34a;
    --orange:#f59e0b;
    --red:#dc2626;
    --purple:#7c3aed;
}

/* ============================================================
   RESET
============================================================ */

*{
    margin:0;
    padding:0;
    box-sizing:border-box;
}

body{
    background:
        radial-gradient(
            circle at top right,
            rgba(37,99,235,.08),
            transparent 30%
        ),
        #f1f5f9;

    font-family:
        "Segoe UI",
        Arial,
        sans-serif;

    color:var(--text);
}

/* ============================================================
   SIDEBAR
============================================================ */

.sidebar{
    width:260px;
    height:100vh;

    position:fixed;
    left:0;
    top:0;

    background:
        linear-gradient(
            180deg,
            #0f172a 0%,
            #172554 100%
        );

    padding:22px 15px;

    z-index:1000;

    overflow-y:auto;

    box-shadow:
        10px 0 35px rgba(15,23,42,.15);

    transition:.3s;
}

/* LOGO */

.logo-box{
    padding:10px 12px 25px;
    text-align:center;
}

.logo-icon{
    width:58px;
    height:58px;

    margin:auto;
    margin-bottom:12px;

    border-radius:17px;

    display:flex;
    align-items:center;
    justify-content:center;

    color:#fff;

    font-size:28px;

    background:
        linear-gradient(
            135deg,
            #2563eb,
            #7c3aed
        );

    box-shadow:
        0 10px 25px rgba(37,99,235,.35);
}

.logo-box h2{
    color:#fff;
    font-size:25px;
    font-weight:800;
    letter-spacing:.5px;
}

.logo-box p{
    color:#94a3b8;
    font-size:12px;
    margin-top:4px;
}

/* MENU */

.menu-title{
    color:#64748b;
    font-size:10px;
    text-transform:uppercase;
    letter-spacing:1.5px;

    padding:8px 14px;

    margin-top:5px;
}

.menu a{
    display:flex;
    align-items:center;

    gap:13px;

    color:#cbd5e1;

    text-decoration:none;

    padding:13px 14px;

    border-radius:12px;

    margin-bottom:5px;

    font-size:14px;
    font-weight:600;

    transition:.25s;
}

.menu a i{
    width:23px;

    text-align:center;

    font-size:18px;
}

.menu a:hover{
    background:rgba(37,99,235,.25);
    color:#fff;

    transform:translateX(3px);
}

.menu a.active{
    background:
        linear-gradient(
            135deg,
            #2563eb,
            #1d4ed8
        );

    color:#fff;

    box-shadow:
        0 8px 20px rgba(37,99,235,.25);
}

/* ============================================================
   MAIN
============================================================ */

.main{
    margin-left:260px;

    min-height:100vh;

    padding:25px;
}

/* ============================================================
   TOPBAR
============================================================ */

.topbar{
    background:rgba(255,255,255,.92);

    border:1px solid rgba(226,232,240,.8);

    backdrop-filter:blur(12px);

    padding:16px 20px;

    border-radius:18px;

    display:flex;
    align-items:center;
    justify-content:space-between;

    margin-bottom:22px;

    box-shadow:
        0 8px 30px rgba(15,23,42,.06);
}

.top-left{
    display:flex;
    align-items:center;
    gap:13px;
}

.page-icon{
    width:44px;
    height:44px;

    border-radius:13px;

    background:#eff6ff;
    color:var(--primary);

    display:flex;
    align-items:center;
    justify-content:center;

    font-size:21px;
}

.topbar h4{
    margin:0;

    font-size:20px;
    font-weight:800;
}

.topbar small{
    color:var(--muted);
}

.admin-box{
    display:flex;
    align-items:center;
    gap:10px;

    padding:6px 12px 6px 7px;

    border:1px solid var(--border);

    border-radius:50px;

    background:#fff;
}

.admin-icon{
    width:36px;
    height:36px;

    border-radius:50%;

    display:flex;
    align-items:center;
    justify-content:center;

    background:
        linear-gradient(
            135deg,
            #2563eb,
            #7c3aed
        );

    color:#fff;
}

/* MOBILE BUTTON */

.mobile-toggle{
    display:none;

    width:42px;
    height:42px;

    border:0;

    border-radius:12px;

    background:#eff6ff;

    color:var(--primary);

    font-size:22px;
}

/* ============================================================
   STATS
============================================================ */

.stat-card{
    position:relative;

    min-height:135px;

    padding:22px;

    border-radius:20px;

    color:#fff;

    overflow:hidden;

    box-shadow:
        0 12px 30px rgba(15,23,42,.10);

    transition:.3s;
}

.stat-card:hover{
    transform:translateY(-5px);
}

.stat-card::after{
    content:"";

    position:absolute;

    width:110px;
    height:110px;

    right:-30px;
    bottom:-40px;

    border-radius:50%;

    background:rgba(255,255,255,.10);
}

.stat-card .icon{
    width:46px;
    height:46px;

    border-radius:14px;

    display:flex;
    align-items:center;
    justify-content:center;

    background:rgba(255,255,255,.16);

    font-size:22px;

    margin-bottom:12px;
}

.stat-card small{
    opacity:.85;

    font-size:12px;

    font-weight:600;

    text-transform:uppercase;

    letter-spacing:.5px;
}

.stat-card h3{
    font-size:25px;

    font-weight:800;

    margin:4px 0 0;
}

.stat-blue{
    background:
        linear-gradient(
            135deg,
            #2563eb,
            #1d4ed8
        );
}

.stat-green{
    background:
        linear-gradient(
            135deg,
            #16a34a,
            #15803d
        );
}

.stat-orange{
    background:
        linear-gradient(
            135deg,
            #f59e0b,
            #d97706
        );
}

.stat-purple{
    background:
        linear-gradient(
            135deg,
            #7c3aed,
            #6d28d9
        );
}

/* ============================================================
   MAIN CARD
============================================================ */

.card-box{
    background:#fff;

    border:1px solid var(--border);

    border-radius:20px;

    padding:22px;

    margin-top:22px;

    box-shadow:
        0 8px 30px rgba(15,23,42,.05);
}

/* CARD HEADER */

.card-header-custom{
    display:flex;
    align-items:center;
    justify-content:space-between;

    gap:15px;

    margin-bottom:20px;
}

.card-title{
    display:flex;
    align-items:center;

    gap:10px;
}

.card-title-icon{
    width:40px;
    height:40px;

    border-radius:12px;

    background:#eff6ff;

    color:var(--primary);

    display:flex;
    align-items:center;
    justify-content:center;

    font-size:19px;
}

.card-title h5{
    margin:0;

    font-size:17px;

    font-weight:800;
}

.card-title p{
    margin:2px 0 0;

    font-size:12px;

    color:var(--muted);
}

/* ============================================================
   FORM
============================================================ */

.form-label{
    font-size:12px;

    font-weight:700;

    color:#475569;

    margin-bottom:7px;
}

.form-control,
.form-select{
    min-height:46px;

    border-radius:11px;

    border:1px solid #dbe3ef;

    font-size:14px;

    box-shadow:none !important;

    transition:.2s;
}

.form-control:focus,
.form-select:focus{
    border-color:#60a5fa;

    box-shadow:
        0 0 0 4px rgba(37,99,235,.08) !important;
}

.btn-save{
    min-height:46px;

    border:0;

    border-radius:11px;

    padding:0 22px;

    background:
        linear-gradient(
            135deg,
            #16a34a,
            #15803d
        );

    color:#fff;

    font-weight:700;

    transition:.25s;

    box-shadow:
        0 8px 20px rgba(22,163,74,.20);
}

.btn-save:hover{
    transform:translateY(-2px);

    box-shadow:
        0 12px 25px rgba(22,163,74,.30);

    color:#fff;
}

/* ============================================================
   TABLE
============================================================ */

.table-wrapper{
    overflow-x:auto;

    border:1px solid var(--border);

    border-radius:15px;
}

.payment-table{
    margin:0;

    min-width:850px;
}

.payment-table thead th{
    background:#f8fafc;

    color:#64748b;

    font-size:11px;

    text-transform:uppercase;

    letter-spacing:.7px;

    font-weight:800;

    padding:15px 14px;

    border-bottom:1px solid var(--border);

    white-space:nowrap;
}

.payment-table tbody td{
    padding:15px 14px;

    border-bottom:1px solid #eef2f7;

    font-size:13px;

    vertical-align:middle;
}

.payment-table tbody tr{
    transition:.2s;
}

.payment-table tbody tr:hover{
    background:#f8fbff;
}

.payment-table tbody tr:last-child td{
    border-bottom:0;
}

/* DOMAIN */

.domain-name{
    font-weight:750;

    color:#1e293b;
}

.domain-name i{
    color:var(--primary);

    margin-right:5px;
}

/* CLIENT */

.client-name{
    font-weight:650;
}

.description{
    color:#64748b;

    font-size:12px;
}

/* AMOUNT */

.amount{
    color:#15803d;

    font-size:15px;

    font-weight:800;
}

/* PAYMENT MODE */

.mode-badge{
    display:inline-flex;

    align-items:center;

    gap:5px;

    padding:6px 10px;

    border-radius:50px;

    font-size:11px;

    font-weight:700;

    background:#eff6ff;

    color:#2563eb;
}

/* DATE */

.date-box{
    color:#475569;

    font-weight:600;

    white-space:nowrap;
}

/* EMPTY */

.empty-state{
    text-align:center;

    padding:50px 20px !important;

    color:#94a3b8;
}

.empty-icon{
    width:65px;
    height:65px;

    margin:0 auto 12px;

    border-radius:18px;

    background:#f1f5f9;

    display:flex;
    align-items:center;
    justify-content:center;

    font-size:28px;
}

/* ============================================================
   PAGINATION
============================================================ */

.pagination-wrap{
    display:flex;

    justify-content:space-between;

    align-items:center;

    gap:15px;

    margin-top:20px;

    flex-wrap:wrap;
}

.pagination-info{
    color:#64748b;

    font-size:13px;
}

.pagination{
    margin:0;

    gap:5px;
}

.pagination .page-link{
    border:0;

    width:38px;
    height:38px;

    border-radius:10px !important;

    display:flex;
    align-items:center;
    justify-content:center;

    color:#475569;

    font-size:13px;

    font-weight:700;

    background:#f8fafc;
}

.pagination .page-link:hover{
    background:#eff6ff;

    color:var(--primary);
}

.pagination .active .page-link{
    background:
        linear-gradient(
            135deg,
            #2563eb,
            #1d4ed8
        );

    color:#fff;

    box-shadow:
        0 5px 14px rgba(37,99,235,.25);
}

/* ============================================================
   SUCCESS ALERT
============================================================ */

.success-alert{
    border:0;

    border-radius:14px;

    background:#ecfdf5;

    color:#166534;

    padding:13px 16px;

    margin-bottom:20px;

    box-shadow:
        0 6px 20px rgba(22,163,74,.08);
}

/* ============================================================
   OVERLAY
============================================================ */

.sidebar-overlay{
    display:none;

    position:fixed;

    inset:0;

    background:rgba(15,23,42,.45);

    z-index:999;
}

/* ============================================================
   RESPONSIVE
============================================================ */

@media(max-width:1100px){

    .sidebar{
        width:240px;
    }

    .main{
        margin-left:240px;
    }

}

@media(max-width:991px){

    .sidebar{
        left:-270px;

        width:260px;
    }

    .sidebar.active{
        left:0;
    }

    .sidebar.active + .sidebar-overlay{
        display:block;
    }

    .main{
        margin-left:0;

        padding:15px;
    }

    .mobile-toggle{
        display:flex;

        align-items:center;
        justify-content:center;
    }

    .topbar{
        padding:13px 15px;
    }

    .admin-box span{
        display:none;
    }

    .card-box{
        padding:16px;
    }

}

@media(max-width:575px){

    .topbar h4{
        font-size:16px;
    }

    .topbar small{
        display:none;
    }

    .page-icon{
        width:38px;
        height:38px;
    }

    .admin-box{
        padding:4px;
        border:0;
        background:transparent;
    }

    .admin-icon{
        width:38px;
        height:38px;
    }

    .stat-card{
        min-height:120px;

        padding:17px;
    }

    .stat-card h3{
        font-size:21px;
    }

    .stat-card .icon{
        width:40px;
        height:40px;
    }

    .card-header-custom{
        align-items:flex-start;
    }

    .pagination-wrap{
        justify-content:center;
    }

    .pagination-info{
        width:100%;
        text-align:center;
    }

}

</style>

</head>

<body>

<!-- ============================================================
     SIDEBAR
============================================================ -->

<aside class="sidebar" id="sidebar">

    <div class="logo-box">

        <div class="logo-icon">
            <i class="bi bi-globe2"></i>
        </div>

        <h2>CAPAPP</h2>

        <p>Domain Management Panel</p>

    </div>

    <div class="menu">

        <div class="menu-title">
            Main Menu
        </div>

        <a href="dashboard.php">
            <i class="bi bi-speedometer2"></i>
            <span>Dashboard</span>
        </a>

        <a href="index.php">
            <i class="bi bi-globe2"></i>
            <span>All Domains</span>
        </a>

        <a href="add-domain.php">
            <i class="bi bi-plus-circle"></i>
            <span>Add Domain</span>
        </a>

        <div class="menu-title">
            Finance
        </div>

        <a href="domain-charges.php">
            <i class="bi bi-cash-stack"></i>
            <span>Domain Charges</span>
        </a>

        <a href="add-payment.php" class="active">
            <i class="bi bi-wallet2"></i>
            <span>Receive Payment</span>
        </a>

        <a href="domain-ledger.php">
            <i class="bi bi-journal-text"></i>
            <span>Balance Sheet</span>
        </a>

        <div class="menu-title">
            Documents
        </div>

        <a href="bill.php">
            <i class="bi bi-receipt"></i>
            <span>Generate Invoice</span>
        </a>

        <a href="expired-domains.php">
            <i class="bi bi-exclamation-circle"></i>
            <span>Expired Domains</span>
        </a>

        <div class="menu-title">
            Account
        </div>

        <a href="logout.php">
            <i class="bi bi-box-arrow-right"></i>
            <span>Logout</span>
        </a>

    </div>

</aside>

<div class="sidebar-overlay"
     id="sidebarOverlay"
     onclick="toggleMenu()">
</div>


<!-- ============================================================
     MAIN
============================================================ -->

<main class="main">

    <!-- TOPBAR -->

    <div class="topbar">

        <div class="top-left">

            <button
                class="mobile-toggle"
                onclick="toggleMenu()"
                type="button">

                <i class="bi bi-list"></i>

            </button>

            <div class="page-icon">

                <i class="bi bi-wallet2"></i>

            </div>

            <div>

                <h4>Receive Payments</h4>

                <small>
                    Manage and track domain payments
                </small>

            </div>

        </div>

        <div class="admin-box">

            <div class="admin-icon">

                <i class="bi bi-person"></i>

            </div>

            <span class="fw-semibold">
                Admin
            </span>

        </div>

    </div>


    <!-- SUCCESS -->

    <?php if(isset($_GET['saved'])): ?>

        <div class="success-alert">

            <i class="bi bi-check-circle-fill me-2"></i>

            Payment successfully added.

        </div>

    <?php endif; ?>


    <!-- ========================================================
         STAT CARDS
    ========================================================= -->

    <div class="row g-3">

        <div class="col-12 col-sm-6 col-xl-3">

            <div class="stat-card stat-blue">

                <div class="icon">
                    <i class="bi bi-wallet2"></i>
                </div>

                <small>Total Payments</small>

                <h3>
                    ₹<?= number_format($totalAmt,2) ?>
                </h3>

            </div>

        </div>


        <div class="col-12 col-sm-6 col-xl-3">

            <div class="stat-card stat-green">

                <div class="icon">
                    <i class="bi bi-calendar-check"></i>
                </div>

                <small>Today's Collection</small>

                <h3>
                    ₹<?= number_format($todayAmt,2) ?>
                </h3>

            </div>

        </div>


        <div class="col-12 col-sm-6 col-xl-3">

            <div class="stat-card stat-orange">

                <div class="icon">
                    <i class="bi bi-calendar3"></i>
                </div>

                <small>This Month</small>

                <h3>
                    ₹<?= number_format($monthAmt,2) ?>
                </h3>

            </div>

        </div>


        <div class="col-12 col-sm-6 col-xl-3">

            <div class="stat-card stat-purple">

                <div class="icon">
                    <i class="bi bi-receipt"></i>
                </div>

                <small>Total Records</small>

                <h3>
                    <?= number_format($total) ?>
                </h3>

            </div>

        </div>

    </div>


    <!-- ========================================================
         PAYMENT FORM
    ========================================================= -->

    <div class="card-box">

        <div class="card-header-custom">

            <div class="card-title">

                <div class="card-title-icon">
                    <i class="bi bi-plus-lg"></i>
                </div>

                <div>

                    <h5>Add New Payment</h5>

                    <p>
                        Enter client payment details below
                    </p>

                </div>

            </div>

        </div>


        <form method="post">

            <div class="row g-3">

                <!-- DOMAIN -->

                <div class="col-12 col-md-6 col-xl-4">

                    <label class="form-label">
                        Domain
                    </label>

                    <select
                        name="domain_id"
                        class="form-select"
                        required>

                        <option value="">
                            Select Domain
                        </option>

                        <?php while($d = mysqli_fetch_assoc($domains)): ?>

                            <option value="<?= (int)$d['id'] ?>">

                                <?= e($d['domain_name']) ?>

                                <?php if(!empty($d['client_name'])): ?>

                                    — <?= e($d['client_name']) ?>

                                <?php endif; ?>

                            </option>

                        <?php endwhile; ?>

                    </select>

                </div>


                <!-- CLIENT -->

                <div class="col-12 col-md-6 col-xl-4">

                    <label class="form-label">
                        Client Name
                    </label>

                    <input
                        type="text"
                        name="client_name"
                        class="form-control"
                        placeholder="Enter client name"
                        required>

                </div>


                <!-- AMOUNT -->

                <div class="col-12 col-md-6 col-xl-4">

                    <label class="form-label">
                        Amount
                    </label>

                    <div class="input-group">

                        <span class="input-group-text bg-white">
                            ₹
                        </span>

                        <input
                            type="number"
                            name="amount"
                            class="form-control"
                            placeholder="0.00"
                            min="1"
                            step="0.01"
                            required>

                    </div>

                </div>


                <!-- DESCRIPTION -->

                <div class="col-12 col-md-6 col-xl-6">

                    <label class="form-label">
                        Description
                    </label>

                    <input
                        type="text"
                        name="description"
                        class="form-control"
                        placeholder="Payment description">

                </div>


                <!-- PAYMENT MODE -->

                <div class="col-12 col-md-6 col-xl-3">

                    <label class="form-label">
                        Payment Mode
                    </label>

                    <select
                        name="payment_mode"
                        class="form-select"
                        required>

                        <option value="Cash">
                            Cash
                        </option>

                        <option value="UPI">
                            UPI
                        </option>

                        <option value="Bank">
                            Bank Transfer
                        </option>

                        <option value="Online">
                            Online
                        </option>

                    </select>

                </div>


                <!-- DATE -->

                <div class="col-12 col-md-6 col-xl-3">

                    <label class="form-label">
                        Payment Date
                    </label>

                    <input
                        type="date"
                        name="payment_date"
                        class="form-control"
                        value="<?= date('Y-m-d') ?>"
                        required>

                </div>


                <!-- BUTTON -->

                <div class="col-12">

                    <button
                        type="submit"
                        name="save"
                        class="btn-save">

                        <i class="bi bi-check2-circle me-1"></i>

                        Add Payment

                    </button>

                </div>

            </div>

        </form>

    </div>


    <!-- ========================================================
         PAYMENT HISTORY
    ========================================================= -->

    <div class="card-box">

        <div class="card-header-custom">

            <div class="card-title">

                <div class="card-title-icon">

                    <i class="bi bi-clock-history"></i>

                </div>

                <div>

                    <h5>Payment History</h5>

                    <p>
                        Latest received payments
                    </p>

                </div>

            </div>

            <div>

                <span class="badge text-bg-light px-3 py-2">

                    <?= number_format($total) ?> Records

                </span>

            </div>

        </div>


        <div class="table-wrapper">

            <table class="table payment-table">

                <thead>

                    <tr>

                        <th>
                            #
                        </th>

                        <th>
                            Date
                        </th>

                        <th>
                            Domain
                        </th>

                        <th>
                            Client
                        </th>

                        <th>
                            Description
                        </th>

                        <th>
                            Amount
                        </th>

                        <th>
                            Payment Mode
                        </th>

                    </tr>

                </thead>


                <tbody>

                <?php

                $counter = $start + 1;

                if($payments && mysqli_num_rows($payments) > 0):

                    while($p = mysqli_fetch_assoc($payments)):

                ?>

                    <tr>

                        <td class="text-muted">
                            <?= $counter++ ?>
                        </td>


                        <td>

                            <div class="date-box">

                                <i class="bi bi-calendar3 me-1"></i>

                                <?= date(
                                    'd M Y',
                                    strtotime($p['payment_date'])
                                ) ?>

                            </div>

                        </td>


                        <td>

                            <div class="domain-name">

                                <i class="bi bi-globe2"></i>

                                <?= e(
                                    $p['domain_name']
                                    ?: 'Domain Removed'
                                ) ?>

                            </div>

                        </td>


                        <td>

                            <div class="client-name">

                                <?= e($p['client_name']) ?>

                            </div>

                        </td>


                        <td>

                            <div class="description">

                                <?=
                                !empty($p['description'])
                                    ? e($p['description'])
                                    : '—'
                                ?>

                            </div>

                        </td>


                        <td>

                            <div class="amount">

                                ₹<?= number_format(
                                    (float)$p['amount'],
                                    2
                                ) ?>

                            </div>

                        </td>


                        <td>

                            <span class="mode-badge">

                                <?php

                                $modeIcon = 'bi-credit-card';

                                if($p['payment_mode'] === 'Cash'){
                                    $modeIcon = 'bi-cash-stack';
                                }

                                if($p['payment_mode'] === 'UPI'){
                                    $modeIcon = 'bi-phone';
                                }

                                if($p['payment_mode'] === 'Bank'){
                                    $modeIcon = 'bi-bank';
                                }

                                ?>

                                <i class="bi <?= $modeIcon ?>"></i>

                                <?= e($p['payment_mode']) ?>

                            </span>

                        </td>

                    </tr>

                <?php

                    endwhile;

                else:

                ?>

                    <tr>

                        <td
                            colspan="7"
                            class="empty-state">

                            <div class="empty-icon">

                                <i class="bi bi-wallet2"></i>

                            </div>

                            <strong>
                                No Payments Found
                            </strong>

                            <div class="small mt-1">
                                Add your first payment using the form above.
                            </div>

                        </td>

                    </tr>

                <?php endif; ?>

                </tbody>

            </table>

        </div>


        <!-- ====================================================
             PAGINATION
        ===================================================== -->

        <?php if($totalPages > 1): ?>

        <div class="pagination-wrap">

            <div class="pagination-info">

                Showing

                <strong>
                    <?= $total > 0 ? $start + 1 : 0 ?>
                </strong>

                to

                <strong>
                    <?= min($start + $limit, $total) ?>
                </strong>

                of

                <strong>
                    <?= $total ?>
                </strong>

                payments

            </div>


            <nav>

                <ul class="pagination">

                    <!-- PREVIOUS -->

                    <?php if($page > 1): ?>

                        <li class="page-item">

                            <a
                                class="page-link"
                                href="?page=<?= $page - 1 ?>">

                                <i class="bi bi-chevron-left"></i>

                            </a>

                        </li>

                    <?php endif; ?>


                    <?php

                    $startPage = max(1, $page - 2);
                    $endPage   = min($totalPages, $page + 2);

                    if($startPage > 1):

                    ?>

                        <li class="page-item">

                            <a
                                class="page-link"
                                href="?page=1">

                                1

                            </a>

                        </li>

                        <?php if($startPage > 2): ?>

                            <li class="page-item disabled">

                                <span class="page-link">
                                    ...
                                </span>

                            </li>

                        <?php endif; ?>

                    <?php endif; ?>


                    <?php for(
                        $i = $startPage;
                        $i <= $endPage;
                        $i++
                    ): ?>

                        <li
                            class="page-item <?= $i == $page ? 'active' : '' ?>">

                            <a
                                class="page-link"
                                href="?page=<?= $i ?>">

                                <?= $i ?>

                            </a>

                        </li>

                    <?php endfor; ?>


                    <?php if($endPage < $totalPages): ?>

                        <?php if($endPage < $totalPages - 1): ?>

                            <li class="page-item disabled">

                                <span class="page-link">
                                    ...
                                </span>

                            </li>

                        <?php endif; ?>

                        <li class="page-item">

                            <a
                                class="page-link"
                                href="?page=<?= $totalPages ?>">

                                <?= $totalPages ?>

                            </a>

                        </li>

                    <?php endif; ?>


                    <!-- NEXT -->

                    <?php if($page < $totalPages): ?>

                        <li class="page-item">

                            <a
                                class="page-link"
                                href="?page=<?= $page + 1 ?>">

                                <i class="bi bi-chevron-right"></i>

                            </a>

                        </li>

                    <?php endif; ?>

                </ul>

            </nav>

        </div>

        <?php endif; ?>

    </div>

</main>


<script>

function toggleMenu(){

    const sidebar =
        document.getElementById("sidebar");

    sidebar.classList.toggle("active");

}


/* Close sidebar after clicking menu on mobile */

document.querySelectorAll(".sidebar a").forEach(function(link){

    link.addEventListener("click", function(){

        if(window.innerWidth <= 991){

            document
                .getElementById("sidebar")
                .classList.remove("active");

        }

    });

});


/* Auto close on resize */

window.addEventListener("resize", function(){

    if(window.innerWidth > 991){

        document
            .getElementById("sidebar")
            .classList.remove("active");

    }

});

</script>

</body>
</html>