Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/deguzmandentalclinic.com/public_html/main

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: appointment.php

<?php
session_start();
include("../controller/config.php");

// Set the time zone to Philippine Time
date_default_timezone_set('Asia/Manila');

// Define all possible time slots (within clinic hours)
$allTimeSlots = [
    '8:00 AM', '9:00 AM', '10:00 AM', '11:00 AM', 
    '1:00 PM', '2:00 PM', '3:00 PM', '4:00 PM'
];

// Ensure a selected date is set
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['date'])) {
    $_SESSION['selectedDate'] = $_POST['date'];
}
$selectedDate = $_SESSION['selectedDate'] ?? '';

// Get the current date and time
$currentDate = date('Y-m-d');
$currentHour = date('G'); // 24-hour format without leading zeros
$currentMinute = date('i');

// Initialize available slots array
$availableSlots = [];

// If the selected date is today, apply time filtering logic
if ($selectedDate === $currentDate) {
    foreach ($allTimeSlots as $time) {
        // Convert the time to 24-hour format
        $time24 = date('H:i', strtotime($time));
        list($hour, $minute) = explode(':', $time24);
        $hour = (int) $hour;
        $minute = (int) $minute;

// Skip past times based on current time
        if ($hour < $currentHour || ($hour == $currentHour && $minute <= $currentMinute)) {
            continue;
        }

// Apply the new slot logic with buffer times (next available slot after a certain time)
        if (
            // 8:00 AM to 8:40 AM → Next: 9:00 AM
            ($currentHour == 8 && $currentMinute >= 0 && $currentMinute <= 40 && $hour < 9) ||
            // 8:41 AM to 9:40 AM → Next: 10:00 AM
            ($currentHour == 8 && $currentMinute >= 41) && $hour < 10 ||
            // 9:41 AM to 10:40 AM → Next: 11:00 AM
            ($currentHour == 9 && $currentMinute >= 41) && $hour < 11 ||
            // 10:41 AM to 11:40 AM → Next: 1:00 PM
            ($currentHour == 10 && $currentMinute >= 41) && $hour < 13 ||
            // 11:41 AM to 12:40 PM → Next: 1:00 PM
            ($currentHour == 11 && $currentMinute >= 41) && $hour < 13 ||
            // 12:50 PM to 1:00 PM → Next: 2:00 PM
            ($currentHour == 12 && $currentMinute >= 50) && $hour < 14 ||
            // 1:41 PM to 2:40 PM → Next: 3:00 PM
            ($currentHour == 13 && $currentMinute >= 41) && $hour < 15 ||
            // 2:41 PM to 3:50 PM → Next: 4:00 PM
            (($currentHour == 14 && $currentMinute >= 41) || ($currentHour == 15 && $currentMinute <= 50)) && $hour < 16
        ) {
            continue;
        }

// Add valid slots
        $availableSlots[] = $time;
    }
} else {
    // If it's a future date, allow all available slots
    $availableSlots = $allTimeSlots;
}

$sum1 = 0;
$_SESSION['sum'] = 0;

if (isset($_SESSION['customer_login'])) {
    $customer_id = $_SESSION['customer_login'];

$get_record = mysqli_query($conn, "select * from customer where customer_id ='$customer_id'");
    $row = mysqli_fetch_assoc($get_record);
    $customer_name = $row['name'];
    $customer_id = $row['customer_id'];
} else {
    header("location: login.php");
}

if (isset($_GET['id'])) {
    $cat_id = $_GET['id'];

$get_record2 = mysqli_query($conn, "select * from service_category where sc_id ='$cat_id'");
    $row = mysqli_fetch_assoc($get_record2);
    $db_category = $row['category'];
}

if (isset($_POST['submit1'])) {

$services = $_POST['services'];
    $time = $_POST['time'];

$sql = "INSERT INTO `appointment`(`customer_id`, `service_id`, `branch_id`, `date`, `time`, `status`) 
    VALUES ('$customer_id','$services','$branch]','$date','$time', '0')";
    $result = mysqli_query($conn, $sql);
}

$_SESSION['error_date'] = "";

if (isset($_POST['begin'])) {

$date = $_POST['date'];
    $branch = $_POST['branch'];

$tr_num = rand(1, 999999);

$currentDate = date('Y-m-d');

if ($date < $currentDate) {

$_SESSION['error_date'] = '** Invalid date! Please Enter PRESENT or FUTURE date. **';
    } else {
        $sql5 = "INSERT INTO `appoint_date`(`ap_date`, `branch_id`, `transaction_num`, `customer_id`, `status`) 
    VALUES ('$date','$branch','$tr_num','$customer_id','0')";
        $result55 = mysqli_query($conn, $sql5);
    }
}

$get_bar = mysqli_query($conn, "select * from appoint_date where customer_id ='$customer_id' and status='0' ");
$row15 = mysqli_num_rows($get_bar);

if ($row15 > 0) {
    $get_record8 = mysqli_query($conn, "select * from appoint_date where customer_id ='$customer_id' and status='0' ");
    $row8 = mysqli_fetch_assoc($get_record8);
    $ap_id = $row8['date_id'];
} else {
    $ap_id = 0;
}

$error = "";

if (isset($_POST['submit'])) {
    $services = $_POST['services'];
    $time = $_POST['time'];

$sql10 = "INSERT INTO `pre_appointment`(`service_id`, `time`, `date_id`) VALUES
    ('$services','$time','$ap_id')";
    $result10 = mysqli_query($conn, $sql10);
}

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
    <meta name="description" content="" />
    <meta name="author" content="" />
    <title>De Guzman Dental Clinic</title>
    
    <link rel="icon" type="image/x-icon" href="../img/logo.png" />
    
    <script src="https://use.fontawesome.com/releases/v6.3.0/js/all.js" crossorigin="anonymous"></script>
    
    <link href="https://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css" />
    <link href="https://fonts.googleapis.com/css?family=Roboto+Slab:400,100,300,700" rel="stylesheet" type="text/css" />
    
    <link href="css/styles.css" rel="stylesheet" />
    <link href="../chatbot/styles.css" rel="stylesheet" />

</head>

<body id="page-top">
    
    <nav class="navbar navbar-expand-lg navbar-dark bg-dark" id="mainNav">
        <div class="container">
        <a class="navbar-brand text-white" href="#page-top"><img src="../img/logo.png" alt="" style="height: 70px;" /> DE GUZMAN DENTAL CLINIC</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
                Menu
                <i class="fas fa-bars ms-1"></i>
            </button>
            <div class="collapse navbar-collapse" id="navbarResponsive">
                <ul class="navbar-nav text-uppercase ms-auto py-4 py-lg-0">

<li class="nav-item"><a class="nav-link " href="../index.php" style="font-size: larger;">Home</a></li>
                    <li class="nav-item"><a class="nav-link " href="services.php" style="font-size: larger;">Services</a></li>

<?php if (isset($_SESSION['customer_login'])) { ?>
                        <li class="nav-item"><a class="nav-link fw-bold active" href="appointment.php" style="font-size: larger;">Appointment</a></li>
                    <?php } else { ?>
                        <li class="nav-item"><a class="nav-link" href="login.php" style="font-size: larger;">Appointment</a></li>
                    <?php } ?>
                    <li class="nav-item"><a class="nav-link" href="about_us.php" style="font-size: larger;">About Us</a></li>
                </ul>
                <?php
                if (isset($_SESSION['customer_login'])) { ?>
                    <div class="dropdown" style="margin-left: 80px;">
                        <span class="d-flex align-items-center dropdown-toggle" href="#" role="button" id="avatarDropdown" data-bs-toggle="dropdown" aria-expanded="false">
                            <img src="../img/avatar.png" alt="Avatar" class="avatar">
                            <span class="ms-2 text-white text-capitalize" style="font-size: larger;"><?php echo $customer_name . " " ?><i class="fa-solid fa-caret-down ml-2"></i></span>
                        </span>

<ul class="dropdown-menu" aria-labelledby="avatarDropdown">
                            <li><a class="dropdown-item" href="profile.php">Profile</a></li>
                            <li><a class="dropdown-item" href="settings.php">Settings</a></li>
                            <li>
                                <hr class="dropdown-divider">
                            </li>
                            <li><a class="dropdown-item" href="../controller/customerLogout.php">Logout</a></li>
                        </ul>
                    </div>
                <?php } else { ?>

<a href="main/login.php"><button class="btn btn-success btn-sm mx-2 ml-2 px-3" type="button">Login</button></a>

<?php } ?>
            </div>

</div>

</nav>

<div class="container">
    <div class="row bg-light mt-3">
        <div class="col-12 d-flex flex-column flex-md-row justify-content-center justify-content-md-start gap-2 p-2">
            <a href="pending.php" class="btn btn-secondary flex-grow-1 flex-md-grow-0">Pending Appointment</a>
            <a href="approved.php" class="btn btn-secondary flex-grow-1 flex-md-grow-0">Approved Appointment</a>
            <a href="completed.php" class="btn btn-secondary flex-grow-1 flex-md-grow-0">Completed Appointment</a>
        </div>
    </div>
</div>

<section class="page-section" id="team" style="min-height: 90vh;">
    <div class="container mx-auto">
        <?php if (empty($row15)) { ?>
            
            <div class="alert alert-info mb-0" role="alert" style="font-size: 20px; padding: 10px 12px;">
                <strong>Please select a date and branch to start the transaction.</strong>
            </div>
        <?php ?>
    </div>

<div class="container">
                <form action="" method="post">
                    <div class="row">
                        
                        <div class="col-12 col-md-6 mb-3">
                            <label for="date" class="mt-2"><strong>Date:</strong></label>
                            <input type="date" name="date" class="form-control" required>
                            <?php if (isset($_SESSION['error_date'])) { ?>
                                <span class="text-danger px-5"><small class="fw-bold"><?php echo $_SESSION['error_date'] ?></small></span><br>
                            <?php }
                            unset($_SESSION['error_date']) ?>
                        </div>

<div class="col-12 col-md-6 mb-3">
                            <label for="branch" class="mt-2"><strong>Branch:</strong></label>
                            <select class="form-select" name="branch" required>
                                <option value=""> *** Select Branch ***</option>
                                <?php
                                $sql = "SELECT * FROM branch WHERE branch != 'owner'";
                                $res = $conn->query($sql);
                                while ($row = $res->fetch_assoc()) {
                                ?>
                                    <option value="<?php echo $row['branch_id']; ?>" data-price="<?php echo $row['branch_id']; ?>">
                                        <?php echo $row['branch']; ?>
                                    </option>
                                <?php } ?>
                            </select>
                        </div>

<div class="col-12 mb-3">
                            <small><strong style="color: red; font-size: 18px;">NOTICE: Closed on Sundays</strong></small><br>
                            <small>We are open <strong>Monday to Saturday</strong> from 8 AM to 5 PM.</small><br>
                            <small>Thank you for your understanding!</small><br>
                            <small>📍 De Guzman Dental Clinic</small><br>
                            <small>📞 09954874757</small>
                        </div>
                    </div>

<div class="row mt-4">
                        <div class="col-12">
                            <button type="submit" class="btn btn-dark form-control" name="begin">Submit</button>
                        </div>
                    </div>
                </form>
            </div>
    </div>
</section>

<?php } else { ?>
                <div class="row gl-3">

<div class="col-lg-4">
                        <div class="card">
                            <div class="card-header fw-bold bg-dark text-white text-center py-3"
                                style="font-family: Arial, Helvetica, sans-serif;">
                                ADD SERVICE
                            </div>
                            <div class="card-body">

<div class="col">
    <label for="" class="mt-2"><strong>Service Category:</strong></label>
    <select class="form-select" onchange="selectCategory()" name="category" id="select1" required>
        <option value="" selected>*** Select Category ***</option>
        <?php
        $sql = "SELECT * FROM service_category";
        $res = $conn->query($sql);
        while ($row = $res->fetch_assoc()) {
        ?>
            <option value="<?php echo $row['sc_id']; ?>"><?php echo $row['category']; ?></option>
        <?php }
        ?>
    </select>
    </div>

<div class="col" id="serviceContainer" style="display: none;"> 
                <label for="" class="mt-2"><strong>Services:</strong></label>
                <select class="form-select" name="services" id="select2" required>
                <option value="" selected>*** Select Services ***</option>
                
         </select>
</div>

// Remove the first option when a category is selected
        if (categoryDropdown.selectedIndex !== 0) {
            categoryDropdown.options[0].style.display = "none";
            serviceContainer.style.display = "block"; // Show services dropdown
        } else {
            serviceContainer.style.display = "none"; // Hide services if no category is selected
        }

// Fetch services dynamically
        var categoryId = categoryDropdown.value;
        if (categoryId) {
            fetch('fetch_services.php?category=' + categoryId)
                .then(response => response.text())
                .then(data => {
                    serviceDropdown.innerHTML = data;
                    serviceDropdown.options[0].style.display = "none"; // Hide first option
                });
        }
    }
</script>

<div class="row">
    <div class="col">
        <label for="" class="mt-2"><strong>Time:</strong></label>
        <select class="form-select" name="time" id="item" required>
    <option value="">*** Select Time ***</option>
    <?php
    foreach ($availableSlots as $time) {
        echo "<option value=\"$time\">$time</option>";
    }
    ?>
</select>

</div>
</div>

<div class="d-grid gap-2 mt-4 mb-3">
    <button type="submit" name="submit"
        class="btn btn-block btn-success py-2 text-white">Submit</button>
</div>

<div class="d-grid gap-2">
    <a href="cancel.php?id=<?php echo $ap_id; ?>" class="btn btn-block text-white" style="background-color: #f33c39;">
        Cancel
    </a>
</div>

</form>
                            </div>

</div>
                    </div>
                    <div class="col-lg-8">

<div class="card">
    <div class="card-header fw-bold bg-dark text-white text-center py-3" style="font-family: Arial, Helvetica, sans-serif;">
        APPOINTMENT DETAILS
    </div>
    <div class="container-fluid">
        <div class="row mt-2">
            <?php
            // Fetch only the latest appointment to avoid duplicate rows
            $fetch = "SELECT * FROM appoint_date WHERE customer_id = '$customer_id' AND status ='0' ORDER BY ap_date DESC LIMIT 1";
            $res8 = $conn->query($fetch);
            $row22 = $res8->fetch_assoc(); // Fetch only once
            
            if ($row22) {
                $branch1 = $row22['branch_id'];
                $get_record3 = mysqli_query($conn, "SELECT * FROM branch WHERE branch_id ='$branch1'");
                $row3 = mysqli_fetch_assoc($get_record3);
                $db_branch = $row3['branch'];
            ?>
                <div class="col">
                    <span>Appointment Date:</span> <br>
                    <strong class="text-success"><?php echo $row22['ap_date']; ?></strong>
                </div>
                <div class="col text-end">
                    <span>Branch:</span> <br>
                    <strong class="text-success"><?php echo $db_branch; ?></strong>
                </div>
            <?php } ?>
        </div>
    </div>

<div class="card-body">
        <div class="table-responsive"> 
            <table class="table table-striped table-hover table-bordered">
                <thead class="text-white bg-dark">
                    <tr>
                        <th class="text-nowrap text-center">Time</th>
                        <th class="text-nowrap text-center">Service Category</th>
                        <th class="text-nowrap text-center">Services</th>
                        <th class="text-nowrap text-center">Price</th>
                        <th class="text-nowrap text-center">Action</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    // Updated SQL Query with JOIN
                    $sql = "SELECT pre_appointment.*, services.service_name, services.price, service_category.category 
                            FROM pre_appointment
                            JOIN services ON pre_appointment.service_id = services.service_id
                            JOIN service_category ON services.sc_id = service_category.sc_id
                            WHERE pre_appointment.date_id = '$ap_id'";

$res = $conn->query($sql);
                    $sum1 = 0; // Reset total price
                    while ($row = $res->fetch_assoc()) {
                        $sum1 += $row['price'];
                        $_SESSION['sum'] = $sum1;
                    ?>
                        <tr>
                            <td class="text-nowrap text-center">
                                <?php 
                                $time = $row['time'];
                                $timenew = substr($time, 0, -3);
                                if ($row['time'] >= '08:00:00' and $row['time'] <= '11:00:00') {
                                    echo $timenew . " AM";
                                } else if ($row['time'] >= '01:00:00' and $row['time'] <= '04:00:00') {
                                    echo $timenew . " PM";
                                }
                                ?>
                            </td>
                            <td class="text-nowrap text-center"><?php echo $row['category']; ?></td>
                            <td class="text-nowrap text-center"><?php echo $row['service_name']; ?></td>
                            <td class="text-nowrap text-center">₱ <?php echo number_format($row['price'], 2); ?></td>
                            <td class="text-nowrap text-center">
                                <a href="deleteItem.php?id=<?php echo $row['pre_app_id']; ?>">
                                    <button class="btn btn-danger btn-sm">Delete</button>
                                </a>
                            </td>
                        </tr>
                    <?php } ?>
                </tbody>
            </table>
        </div>

<strong class="float-end">Total: ₱ <?php echo number_format($_SESSION['sum'], 2); ?> </strong>
    </div>

<div class="card-footer d-flex flex-column align-items-center justify-content-center">
    <p id="service-note" class="text-danger text-center">Please add a service first to confirm your appointment.</p>
    <div id="confirm-wrapper" style="pointer-events: none;">
        <a href="confirm.php?id=<?php echo $ap_id; ?>">
            <button id="confirm-btn" class="btn text-white" style="background-color: blue;" disabled>
                Confirm Appointment
            </button>
        </a>
    </div>
</div>

</div>
                    </div>
                </div>
            <?php } ?>
        </div>
    </section>

<div id="predefined-questions">
                    <button class="question-btn" data-question="How to book an appointment?">How to book an appointment?</button>
                    <button class="question-btn" data-question="Can I reschedule my appointment?">Can I reschedule my appointment?</button>
                    <button class="question-btn" data-question="Is there an appointment fee?">Is there an appointment fee?</button>
            </div>

<footer class="footer py-4 bg-dark">
    <div class="container text-white">
        <div class="row align-items-center">
            <div class="col-lg-4 text-lg-start">De Guzman Dental Clinic &copy; All rights Reserved 2023.</div>
            <div class="col-lg-4 my-3 my-lg-0">
                
            </div>

</div>
    </div>
</footer>

<script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
    
    <script src="js/scripts.js"></script>
    <script src="https://cdn.startbootstrap.com/sb-forms-latest.js"></script>
    <script src="../chatbot/script.js"></script>

if (v1 === "") {
            window.location.href = "appointment.php"; // Redirect if empty
        } else {
            window.location.href = "appointment.php?id=" + v1; // Redirect with ID
            $("#cat_id").val(v1); // Set value to hidden input (if needed)
        }
    }

document.addEventListener("DOMContentLoaded", function () {
        const serviceTable = document.querySelector("tbody");
        const confirmBtn = document.getElementById("confirm-btn");
        const serviceNote = document.getElementById("service-note");

function checkServices() {
            let rowCount = serviceTable.getElementsByTagName("tr").length; // Count services

if (rowCount > 0) {
                serviceNote.style.display = "none"; // Hide warning immediately
                confirmBtn.disabled = false; // Enable button
                confirmBtn.style.pointerEvents = "auto"; // Allow clicking
            } else {
                serviceNote.style.display = "block"; // Show warning
                confirmBtn.disabled = true; // Disable button
                confirmBtn.style.pointerEvents = "none"; // Prevent clicking
            }
        }

// Run check immediately on page load without delay
        requestAnimationFrame(checkServices);

// Observe table changes instantly
        const observer = new MutationObserver(checkServices);
        observer.observe(serviceTable, { childList: true });

// Ensure button updates when delete is clicked
        $(document).on("click", ".btn-danger", checkServices);

// Prevent multiple form submissions
        document.getElementById("appointmentForm")?.addEventListener("submit", function () {
            document.getElementById("submitButton").disabled = true;
        });
    });
</script>

</script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: appointment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation