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-appointments.php (10379B)

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

$doctor_id = $_SESSION['doctor_id'];

$filter_date = isset($_GET['filter_date']) ? trim($_GET['filter_date']) : '';
$filter_time = isset($_GET['filter_time']) ? trim($_GET['filter_time']) : '';

$where = "WHERE doctor_id=$doctor_id";

// ✅ Date filter
if ($filter_date != '') {
    $where .= " AND appointment_date = '$filter_date'";
}

// ✅ Time filter (IMPORTANT FIX)
if ($filter_time != '') {
    $where .= " AND date_time LIKE '$filter_time%'";
}

$sqlbooking = mysqli_query($conn, "
SELECT * FROM tbl_booking 
WHERE doctor_id = '$doctor_id'
ORDER BY appointment_date ASC, date_time ASC
");
// echo mysqli_num_rows($sqlbooking);
// exit;
// echo "SELECT * FROM tbl_booking $where";
// exit;
?>
<!DOCTYPE html>
<html xml:lang="en-US" lang="en-US">

<div class="page-title">
                My Appointments
            </div>

<button type="submit" class="btn btn-primary">Filter</button>

<a href="doctor-appointments.php" class="btn btn-secondary">Reset</a>

</form>

</div>

<?php
                $currentDate = '';

while ($rowbook = mysqli_fetch_assoc($sqlbooking)) {

// 👉 NEW DATE GROUP START
                    if ($currentDate != $rowbook['appointment_date']) {

// 👉 Close previous table
                        if ($currentDate != '') {
                            echo "</tbody></table>";
                        }

$currentDate = $rowbook['appointment_date'];
                ?>

<thead>
                                <tr>
                                    <th>Slip No</th>
                                    <th>Patient</th>
                                    <th>Phone</th>
                                    <th>Appointment Time</th>
                                    <th>Created At</th>
                                    <th>Start Meeting </th>
                                    <th>Send Link</th>
                                    <th>End Meeting</th>
                                    <th>Status</th>
                                </tr>
                            </thead>

<tbody>

<?php } ?>

<?php
                            // 🔥 STATUS LOGIC
                            $now = time();
                            $start = strtotime($rowbook['date_time']);
                            $end = $start + (15 * 60);

if (!empty($rowbook['meeting_status']) && $rowbook['meeting_status'] == 'Completed') {

$meeting_status = "Completed";
                                $badge = "dark";
                            } else {

// fallback (auto logic)
                                $now = time();
                                $start = strtotime($rowbook['date_time']);
                                $end = $start + (15 * 60);

if ($now < $start) {
                                    $meeting_status = "Upcoming";
                                    $badge = "secondary";
                                } elseif ($now >= $start && $now <= $end) {
                                    $meeting_status = "Running";
                                    $badge = "success";
                                } else {
                                    $meeting_status = "Completed";
                                    $badge = "dark";
                                }
                            }
                            ?>

<tr>

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

<td>
                                    <?php if ($rowbook['meeting_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 $rowbook['id']; ?>"
                                            class="btn btn-success btn-sm">
                                            Send Zoom Link
                                        </a>
                                    <?php } ?>
                                </td>

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

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

</tr>

<?php } ?>

</tbody>
                        </table>

</div>
        </div>

.table-box {
                background: #fff;
                padding: 20px;
                border-radius: 10px;
                box-shadow: 0 10px 30px rgba(0, 0, 0, .08);
            }

h5.text-primary {
                border-left: 4px solid #0d6efd;
                padding-left: 10px;
                font-weight: 600;
            }
        </style>

<?php include 'include/footer.php'; ?>
    </div>
    <?php include 'include/footer-tab.php'; ?>
    <?php include 'include/model.php'; ?>
    <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 type="text/javascript" src="function/custum.js"></script>
    <?php include 'include/footer-file.php' ?>
</body>

</html>

<?= $meta_title ?>

My Appointments

"; } $currentDate = $rowbook['appointment_date']; ?>

= $start && $now <= $end) { $meeting_status = "Running"; $badge = "success"; } else { $meeting_status = "Completed"; $badge = "dark"; } } ?>

Slip No	Patient	Phone	Appointment Time	Created At	Start Meeting	Send Link	End Meeting	Status
					Start	Send Zoom Link	End