FM / public

/home/u775757334/domains/civicwelllife.com/public_html/

/home/u775757334/domains/civicwelllife.com/public_html

Name	Size	Mode	Actions
admin/	-	0755	rm
civiclife/	-	0755	rm
css/	-	0755	rm
fonts/	-	0755	rm
function/	-	0755	rm
images/	-	0755	rm
include/	-	0755	rm
js/	-	0755	rm
management/	-	0755	rm
media/	-	0755	rm
razorpay/	-	0755	rm
seller/	-	0755	rm
vendor/	-	0755	rm
09.php	142	0644	edit dl rm
about-us.php	3025	0644	edit dl rm
account.php	7408	0644	edit dl rm
add-shipping.php	6073	0644	edit dl rm
affiliate-registration.php	4543	0644	edit dl rm
arrow.jpg	1546	0644	edit dl rm
blog-details.php	10838	0644	edit dl rm
blog-list.php	9268	0644	edit dl rm
blog.php	10062	0644	edit dl rm
booking-process.php	2149	0644	edit dl rm
booking-success.php	5541	0644	edit dl rm
category-details.php	7903	0644	edit dl rm
checkout.php	15505	0644	edit dl rm
civiclife (2).zip	151986360	0644	edit dl rm
config.php	9419	0644	edit dl rm
consultation-payment.php	12113	0644	edit dl rm
consultation.php	17921	0644	edit dl rm
contact-us.php	9742	0644	edit dl rm
cpage.css	14115	0644	edit dl rm
create-order.php	443	0644	edit dl rm
create_zoom_link.php	2832	0644	edit dl rm
default.php	16369	0644	edit dl rm
delivery-return.php	2923	0644	edit dl rm
dlogout.php	125	0644	edit dl rm
doctor-account.php	36857	0644	edit dl rm
doctor-appointments.php	10379	0644	edit dl rm
doctor-blog.php	8588	0644	edit dl rm
doctor-consultation.php	5467	0644	edit dl rm
doctor-profile.php	32002	0644	edit dl rm
doctor-registration.php	13189	0644	edit dl rm
doctors.php	10383	0644	edit dl rm
end_meeting.php	230	0644	edit dl rm
faq-list.php	7900	0644	edit dl rm
faq.php	6367	0644	edit dl rm
get_subcategory.php	437	0644	edit dl rm
health-test.php	31910	0644	edit dl rm
index.html	4133	0644	edit dl rm
index.php	3656	0644	edit dl rm
login.php	3842	0644	edit dl rm
media.zip	37481598	0644	edit dl rm
my-account.php	7397	0644	edit dl rm
order-details.php	6172	0644	edit dl rm
patient-login.php	7935	0644	edit dl rm
privacy-policy.php	2430	0644	edit dl rm
product-detail.php	32756	0644	edit dl rm
product-list.php	10761	0644	edit dl rm
return-and-refund.php	2398	0644	edit dl rm
review.php	12362	0644	edit dl rm
seller-registration.php	11374	0644	edit dl rm
send_review.php	765	0644	edit dl rm
start_meeting.php	194	0644	edit dl rm
sub-category.php	7839	0644	edit dl rm
terms-and-conditions.php	2681	0644	edit dl rm
testimonial-list.php	8787	0644	edit dl rm
testimonial.php	8060	0644	edit dl rm
timing-list.php	6068	0644	edit dl rm
timming.php	7571	0644	edit dl rm
vedio-list.php	7877	0644	edit dl rm
vedio.php	8579	0644	edit dl rm
vedios.php	8787	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/doctor-account.php (36857B)

<?php include 'config.php';
if (!isset($_SESSION['doctor_id'])) {
    header('Location: index.php');
}
?>
<!DOCTYPE html>
<html xml:lang="en-US" lang="en-US">

.booking-hero-card {
            background: linear-gradient(135deg, #0d6efd 0%, #1f4fd8 100%);
            border-radius: 22px;
            padding: 28px;
            color: #fff;
            box-shadow: 0 14px 35px rgba(13, 110, 253, 0.18);
        }

.booking-mini-badge {
            display: inline-block;
            padding: 7px 14px;
            border-radius: 40px;
            background: rgba(255, 255, 255, 0.16);
            font-size: 13px;
            font-weight: 700;
            margin-bottom: 12px;
        }

.booking-hero-card h3 {
            font-size: 30px;
            font-weight: 800;
            margin-bottom: 8px;
            color: #fff;
        }

.booking-hero-card p {
            margin: 0;
            font-size: 14px;
            line-height: 1.8;
            color: rgba(255, 255, 255, 0.88);
        }

.booking-stats-grid {
            display: grid;
            grid-template-columns: repeat(3, 1fr);
            gap: 18px;
        }

.booking-stat-card {
            background: #fff;
            border: 1px solid #e8edf5;
            border-radius: 18px;
            padding: 22px;
            box-shadow: 0 8px 24px rgba(15, 23, 42, 0.05);
        }

.booking-stat-card .stat-label {
            font-size: 14px;
            color: #64748b;
            margin-bottom: 10px;
        }

.booking-stat-card .stat-value {
            font-size: 32px;
            font-weight: 800;
            line-height: 1;
            color: #0f172a;
        }

.booking-section-card {
            background: #fff;
            border: 1px solid #e8edf5;
            border-radius: 22px;
            padding: 24px;
            box-shadow: 0 8px 24px rgba(15, 23, 42, 0.05);
        }

.booking-section-head {
            margin-bottom: 18px;
        }

.booking-section-head h4 {
            font-size: 26px;
            font-weight: 800;
            margin-bottom: 6px;
            color: #0f172a;
        }

.booking-section-head p {
            margin: 0;
            color: #64748b;
            font-size: 14px;
        }

.booking-filter-box {
            background: #f8fbff;
            border: 1px solid #e8eef8;
            border-radius: 18px;
            padding: 18px;
            margin-bottom: 20px;
        }

.booking-label {
            display: block;
            font-size: 13px;
            font-weight: 700;
            color: #334155;
            margin-bottom: 7px;
        }

.booking-control {
            min-height: 46px;
            border-radius: 12px;
            border: 1px solid #dbe3ef;
            box-shadow: none !important;
        }

.booking-control:focus {
            border-color: #0d6efd;
        }

.booking-filter-actions {
            display: flex;
            gap: 10px;
        }

.booking-filter-btn,
        .booking-reset-btn {
            height: 46px;
            padding: 0 18px;
            border-radius: 12px;
            border: 0;
            display: inline-flex;
            align-items: center;
            justify-content: center;
            font-weight: 700;
            text-decoration: none;
        }

.booking-filter-btn {
            background: linear-gradient(135deg, #0d6efd 0%, #1f4fd8 100%);
            color: #fff;
        }

.booking-reset-btn {
            background: #eef3fb;
            color: #334155;
        }

.booking-table-wrap {
            overflow-x: auto;
        }

.booking-table-new {
            width: 100%;
            min-width: 980px;
            border-collapse: separate;
            border-spacing: 0 12px;
        }

.booking-table-new thead th {
            padding: 0 12px 10px;
            font-size: 13px;
            color: #64748b;
            font-weight: 700;
            border: 0;
            background: transparent;
            white-space: nowrap;
        }

.booking-table-new tbody tr {
            background: #fff;
        }

.booking-table-new tbody td {
            padding: 16px 12px;
            vertical-align: middle;
            border-top: 1px solid #eef2f7;
            border-bottom: 1px solid #eef2f7;
            background: #fff;
        }

.booking-table-new tbody td:first-child {
            border-left: 1px solid #eef2f7;
            border-top-left-radius: 16px;
            border-bottom-left-radius: 16px;
        }

.booking-table-new tbody td:last-child {
            border-right: 1px solid #eef2f7;
            border-top-right-radius: 16px;
            border-bottom-right-radius: 16px;
        }

.booking-order-id,
        .booking-date,
        .patient-name {
            font-weight: 700;
            color: #0f172a;
            margin-bottom: 3px;
        }

.booking-table-new small,
        .patient-sub {
            display: block;
            color: #64748b;
            font-size: 12px;
            line-height: 1.6;
        }

.mode-badge {
            display: inline-block;
            padding: 6px 12px;
            border-radius: 40px;
            background: #eff6ff;
            color: #2563eb;
            font-size: 12px;
            font-weight: 700;
        }

.status-badge {
            display: inline-block;
            padding: 6px 12px;
            border-radius: 40px;
            font-size: 12px;
            font-weight: 700;
        }

.paid-badge {
            background: #ecfdf3;
            color: #15803d;
        }

.unpaid-badge {
            background: #fff1f2;
            color: #dc2626;
        }

.booking-view-btn {
            display: inline-flex;
            align-items: center;
            gap: 7px;
            padding: 10px 14px;
            border-radius: 12px;
            background: linear-gradient(135deg, #0d6efd 0%, #1f4fd8 100%);
            color: #fff;
            font-size: 13px;
            font-weight: 700;
            text-decoration: none;
        }

.booking-view-btn:hover {
            color: #fff;
            opacity: 0.95;
        }

.empty-booking-state {
            text-align: center;
            padding: 30px 10px;
            color: #64748b;
            font-size: 15px;
            font-weight: 600;
        }

@media (max-width: 991px) {
            .booking-stats-grid {
                grid-template-columns: 1fr;
            }
        }

@media (max-width: 767px) {
            .booking-hero-card {
                padding: 22px 18px;
                border-radius: 18px;
            }

.booking-hero-card h3 {
                font-size: 24px;
            }

.booking-section-card {
                padding: 18px;
                border-radius: 18px;
            }

.booking-section-head h4 {
                font-size: 22px;
            }

.booking-filter-actions {
                flex-direction: column;
            }

.booking-filter-btn,
            .booking-reset-btn {
                width: 100%;
            }
        }

.booking-modal-content {
            border: 0;
            border-radius: 24px;
            overflow: hidden;
            box-shadow: 0 20px 60px rgba(15, 23, 42, 0.16);
        }

.booking-modal-header {
            padding: 24px 24px 12px;
            background: linear-gradient(180deg, #f8fbff 0%, #ffffff 100%);
        }

.booking-modal-badge {
            display: inline-block;
            padding: 6px 12px;
            border-radius: 40px;
            background: #eaf2ff;
            color: #2563eb;
            font-size: 12px;
            font-weight: 700;
            margin-bottom: 10px;
        }

.booking-modal-title {
            font-size: 28px;
            font-weight: 800;
            color: #0f172a;
        }

.booking-modal-sub {
            font-size: 14px;
            color: #64748b;
        }

.booking-modal-body {
            padding: 18px 24px 10px;
        }

.booking-detail-card {
            height: 100%;
            background: #fbfdff;
            border: 1px solid #e8eef8;
            border-radius: 16px;
            padding: 14px 16px;
        }

.detail-label {
            font-size: 12px;
            font-weight: 700;
            color: #64748b;
            text-transform: uppercase;
            letter-spacing: .3px;
            margin-bottom: 6px;
        }

.detail-value {
            font-size: 15px;
            font-weight: 600;
            color: #0f172a;
            line-height: 1.6;
            word-break: break-word;
        }

#modal_payment_status_badge.paid-badge {
            background: #ecfdf3;
            color: #15803d;
        }

#modal_payment_status_badge.unpaid-badge {
            background: #fff1f2;
            color: #dc2626;
        }

@media (max-width: 767px) {
            .booking-modal-header {
                padding: 18px 18px 10px;
            }

.booking-modal-body {
                padding: 14px 18px 6px;
            }

.booking-modal-title {
                font-size: 22px;
            }
        }
    </style>
</head>

<body class="preload-wrapper color-primary-8 color-main-text-2">
    <div id="wrapper">
        
        <?php include 'include/header.php'; ?>
        <div class="tf-page-title">
            <div class="container-full">
                <div class="heading text-center">My Account</div>
            </div>
        </div>
        <section class="flat-spacing-11">
            <div class="container">
                <div class="row">
                    <div class="col-lg-3">
                        <?php include 'include/doctor-menu.php'; ?>
                    </div>
                    <div class="col-lg-9">
                        <div class="booking-dashboard-wrap">

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

$doctor_id = $_SESSION['doctor_id'];

$docQuery = mysqli_query($conn, "SELECT name FROM tbl_doctor_registration WHERE id='$doctor_id'");
                            $docData = mysqli_fetch_assoc($docQuery);
                            $doctor_name = $docData['name'] ?? 'Doctor';

$paymentStatus = [
                                1 => "Paid",
                                0 => "UnPaid"
                            ];

$from_date = isset($_GET['from_date']) ? trim($_GET['from_date']) : '';
                            $to_date   = isset($_GET['to_date']) ? trim($_GET['to_date']) : '';

$where = " WHERE doctor_id='$doctor_id' ";

if ($from_date != '') {
                                $where .= " AND appointment_date >= '$from_date' ";
                            }

if ($to_date != '') {
                                $where .= " AND appointment_date <= '$to_date' ";
                            }

$sql = mysqli_query($conn, "SELECT * FROM tbl_booking $where ORDER BY appointment_date DESC, id DESC");

$totalBooking = 0;
                            $paidBooking = 0;
                            $unpaidBooking = 0;

$bookingRows = [];
                            if ($sql && mysqli_num_rows($sql) > 0) {
                                while ($row = mysqli_fetch_assoc($sql)) {
                                    $bookingRows[] = $row;
                                    $totalBooking++;
                                    if ((int)$row['payment_status'] == 1) {
                                        $paidBooking++;
                                    } else {
                                        $unpaidBooking++;
                                    }
                                }
                            }
                            ?>

<div class="booking-hero-card">
                                <div class="booking-hero-left">
                                    <span class="booking-mini-badge">Doctor Panel</span>
                                    <h3>Hello Dr. <?= htmlspecialchars($doctor_name) ?></h3>
                                    <p>Yahan se aap apni all appointments aur booking records manage kar sakte hain.</p>
                                </div>
                            </div>

<div class="booking-stats-grid">
                                <div class="booking-stat-card">
                                    <div class="stat-label">Total Bookings</div>
                                    <div class="stat-value"><?= $totalBooking ?></div>
                                </div>

<div class="booking-stat-card">
                                    <div class="stat-label">Paid Bookings</div>
                                    <div class="stat-value text-success"><?= $paidBooking ?></div>
                                </div>

<div class="booking-stat-card">
                                    <div class="stat-label">Unpaid Bookings</div>
                                    <div class="stat-value text-danger"><?= $unpaidBooking ?></div>
                                </div>
                            </div>

<div class="booking-section-card">
                                <div class="booking-section-head">
                                    <div>
                                        <h4>Appointment Bookings</h4>
                                        <p>Filter appointments date wise and view full patient booking details.</p>
                                    </div>
                                </div>

<div class="col-md-4">
                                            <div class="booking-filter-actions">
                                                <button type="submit" class="booking-filter-btn">
                                                    <i class="fa fa-search"></i> Filter
                                                </button>

<a href="doctor-dashboard.php" class="booking-reset-btn">
                                                    Reset
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                </form>

<div class="booking-table-wrap">
                                    <table class="booking-table-new">
                                        <thead>
                                            <tr>
                                                <th>Order#</th>
                                                <th>Appointment</th>
                                                <th>Patient Details</th>
                                                <th>City</th>
                                                <th>Payment Mode</th>
                                                <th>Payment Status</th>
                                                <th>Start Meeting </th>
                                                <th>Send Link</th>
                                                 <th>End Meeting</th>
                                                   <th>Status</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

<tr>

<td>
                                                            <?php if ((int)$row['payment_status'] == 1) { ?>
                                                                <span class="status-badge paid-badge">Paid</span>
                                                            <?php } else { ?>
                                                                <span class="status-badge unpaid-badge">UnPaid</span>
                                                            <?php } ?>
                                                        </td>

<?php
                                                        // 🔥 STATUS FROM DB
                                                        $status = $row['meeting_status'];

if ($status == 'Upcoming') $badge = "secondary";
                                                        elseif ($status == 'Running') $badge = "success";
                                                        elseif ($status == 'Completed') $badge = "dark";
                                                        else $badge = "secondary";
                                                        ?>

<td>
                                                            <?php if ($status == 'Completed') { ?>
                                                                <button class="btn btn-outline-secondary btn-sm" disabled>Start</button>
                                                            <?php } elseif (empty($row['start_link'])) { ?>
                                                                <button class="btn btn-secondary btn-sm" disabled>No Link</button>
                                                            <?php } else { ?>
                                                                <a href="start_meeting.php?id=<?php echo $row['id']; ?>&link=<?php echo urlencode($row['start_link']); ?>"
                                                                    target="_blank" class="btn btn-primary btn-sm">
                                                                    Start
                                                                </a>
                                                            <?php } ?>
                                                        </td>

<td>
                                                            <?php if ($status == 'Completed') { ?>
                                                                <button class="btn btn-outline-secondary btn-sm" disabled>Send Link</button>
                                                            <?php } else { ?>
                                                                <a href="create_zoom_link.php?id=<?php echo $row['id']; ?>"
                                                                    class="btn btn-success btn-sm">
                                                                    Send Zoom Link
                                                                </a>
                                                            <?php } ?>
                                                        </td>

<td>
                                                            <?php if ($status == 'Completed') { ?>
                                                                <button class="btn btn-outline-secondary btn-sm" disabled>Ended</button>
                                                            <?php } else { ?>
                                                                <a href="end_meeting.php?id=<?php echo $row['id']; ?>"
                                                                    class="btn btn-danger btn-sm">
                                                                    End
                                                                </a>
                                                            <?php } ?>
                                                        </td>

<td>
                                                            <span class="badge bg-<?php echo $badge; ?>">
                                                                <?php echo $status; ?>
                                                            </span>
                                                        </td>

<td>
                                                            <button type="button"
                                                                class="booking-view-btn viewBookingBtn"
                                                                data-bs-toggle="modal"
                                                                data-bs-target="#bookingDetailsModal"

data-id="<?= (int)$row['id'] ?>"
                                                                data-order_id="<?= htmlspecialchars($row['order_id']) ?>"
                                                                data-batch_number="<?= htmlspecialchars($row['batch_number']) ?>"
                                                                data-slip_no="<?= htmlspecialchars($row['slip_no']) ?>"
                                                                data-doctor_id="<?= htmlspecialchars($row['doctor_id']) ?>"
                                                                data-patient_name="<?= htmlspecialchars($row['patient_name']) ?>"
                                                                data-patient_phone="<?= htmlspecialchars($row['patient_phone']) ?>"
                                                                data-patient_email="<?= htmlspecialchars($row['patient_email']) ?>"
                                                                data-city="<?= htmlspecialchars($row['city']) ?>"
                                                                data-appointment_date="<?= htmlspecialchars($row['appointment_date']) ?>"
                                                                data-date_time="<?= htmlspecialchars($row['date_time']) ?>"
                                                                data-payment_status="<?= ((int)$row['payment_status'] == 1) ? 'Paid' : 'UnPaid' ?>"
                                                                data-payment_mode="<?= htmlspecialchars($row['payment_mode']) ?>"
                                                                data-created_at="<?= htmlspecialchars($row['date']) ?>">

</tr>

<?php } ?>
                                            <?php } else { ?>

<tr>
                                                    <td colspan="10">
                                                        <div class="empty-booking-state">
                                                            No Bookings Found
                                                        </div>
                                                    </td>
                                                </tr>

<?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>

</div>
                    </div>
                </div>
            </div>
        </section>

<?php include 'include/footer.php'; ?>

</div>
    
    <?php include 'include/footer-tab.php'; ?>
    <?php include 'include/model.php'; ?>

<div class="modal fade" id="bookingDetailsModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered modal-lg">
            <div class="modal-content booking-modal-content">
                <div class="modal-header booking-modal-header border-0">
                    <div>
                        <span class="booking-modal-badge">Booking Details</span>
                        <h4 class="booking-modal-title mb-1" id="modal_patient_name">Patient Name</h4>
                        <p class="booking-modal-sub mb-0">Full appointment and payment information</p>
                    </div>
                    <button type="button" class="btn-close shadow-none" data-bs-dismiss="modal"></button>
                </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Order ID</div>
                                <div class="detail-value" id="modal_order_id">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Patient Name</div>
                                <div class="detail-value" id="modal_patient_name_2">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Patient Phone</div>
                                <div class="detail-value" id="modal_patient_phone">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Patient Email</div>
                                <div class="detail-value" id="modal_patient_email">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Appointment Date</div>
                                <div class="detail-value" id="modal_appointment_date">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Appointment Time</div>
                                <div class="detail-value" id="modal_date_time">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Payment Mode</div>
                                <div class="detail-value" id="modal_payment_mode">-</div>
                            </div>
                        </div>

<div class="col-md-6">
                            <div class="booking-detail-card">
                                <div class="detail-label">Payment Status</div>
                                <div class="detail-value">
                                    <span id="modal_payment_status_badge" class="status-badge">-</span>
                                </div>
                            </div>
                        </div>

<div class="col-md-12">
                            <div class="booking-detail-card">
                                <div class="detail-label">Created At</div>
                                <div class="detail-value" id="modal_created_at">-</div>
                            </div>
                        </div>

</div>
                </div>

<div class="modal-footer border-0 pt-0">
                    <button type="button" class="btn btn-secondary px-4" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>
    <script type="text/javascript" src="js/bootstrap.min.js"></script>
    <script type="text/javascript" src="js/jquery.min.js"></script>
    <script type="text/javascript" src="js/swiper-bundle.min.js"></script>
    <script type="text/javascript" src="js/carousel.js"></script>
    <script type="text/javascript" src="js/bootstrap-select.min.js"></script>
    <script type="text/javascript" src="js/lazysize.min.js"></script>
    <script type="text/javascript" src="js/bootstrap-select.min.js"></script>
    <script type="text/javascript" src="js/count-down.js"></script>
    <script type="text/javascript" src="js/wow.min.js"></script>
    <script type="text/javascript" src="js/multiple-modal.js"></script>
    <script type="text/javascript" src="js/main.js"></script>
    <script>
        $(document).on("click", ".viewBookingBtn", function() {
            let btn = $(this);

$("#modal_id").text(btn.data("id") || "-");
            $("#modal_order_id").text(btn.data("order_id") || "-");
            $("#modal_batch_number").text(btn.data("batch_number") || "-");
            $("#modal_slip_no").text(btn.data("slip_no") || "-");
            $("#modal_patient_name").text(btn.data("patient_name") || "-");
            $("#modal_patient_name_2").text(btn.data("patient_name") || "-");
            $("#modal_patient_phone").text(btn.data("patient_phone") || "-");
            $("#modal_patient_email").text(btn.data("patient_email") || "-");
            $("#modal_city").text(btn.data("city") || "-");
            $("#modal_appointment_date").text(btn.data("appointment_date") || "-");
            $("#modal_date_time").text(btn.data("date_time") || "-");
            $("#modal_payment_mode").text(btn.data("payment_mode") || "-");
            $("#modal_payment_razor_order_id").text(btn.data("payment_razor_order_id") || "-");
            $("#modal_payment_razor_id").text(btn.data("payment_razor_id") || "-");
            $("#modal_created_at").text(btn.data("created_at") || "-");

let paymentStatus = btn.data("payment_status") || "-";
            let badge = $("#modal_payment_status_badge");

badge.text(paymentStatus);
            badge.removeClass("paid-badge unpaid-badge");

if (paymentStatus.toLowerCase() === "paid") {
                badge.addClass("paid-badge");
            } else {
                badge.addClass("unpaid-badge");
            }
        });
    </script>
</body>

</html>

<?= $meta_title ?>

My Account

"Paid", 0 => "UnPaid" ]; $from_date = isset($_GET['from_date']) ? trim($_GET['from_date']) : ''; $to_date = isset($_GET['to_date']) ? trim($_GET['to_date']) : ''; $where = " WHERE doctor_id='$doctor_id' "; if ($from_date != '') { $where .= " AND appointment_date >= '$from_date' "; } if ($to_date != '') { $where .= " AND appointment_date <= '$to_date' "; } $sql = mysqli_query($conn, "SELECT * FROM tbl_booking $where ORDER BY appointment_date DESC, id DESC"); $totalBooking = 0; $paidBooking = 0; $unpaidBooking = 0; $bookingRows = []; if ($sql && mysqli_num_rows($sql) > 0) { while ($row = mysqli_fetch_assoc($sql)) { $bookingRows[] = $row; $totalBooking++; if ((int)$row['payment_status'] == 1) { $paidBooking++; } else { $unpaidBooking++; } } } ?>

Doctor Panel

Hello Dr.

Yahan se aap apni all appointments aur booking records manage kar sakte hain.

Total Bookings

Paid Bookings

Unpaid Bookings

Appointment Bookings

Filter appointments date wise and view full patient booking details.

Order#	Appointment	Patient Details	City	Payment Mode	Payment Status	Start Meeting	Send Link	End Meeting	Status	Action
#					Paid UnPaid	Start	Send Zoom Link	End
No Bookings Found