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/admin

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: view4.php

<?php
include("header.php");
include("topnav.php");

$date_id = $_GET['id'];
$_SESSION['date_id'] = $date_id;

?>

<nav class="mt-2">
    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
        
        <li class="nav-item">
            <a href="index.php" class="nav-link ">
                <i class="nav-icon fas fa-tachometer-alt"></i>
                <p>
                    Dashboard
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="managePatient.php" class="nav-link">
                <i class="fa-solid fa-people-line nav-icon"></i>
                <p>
                    Manage Patients
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageServices.php" class="nav-link ">
                <i class="fa-solid fa-bag-shopping nav-icon"></i>
                <p>
                    Manage Services
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageScategory.php" class="nav-link ">
                <i class="fa-solid fa-gears nav-icon"></i>
                <p>
                    Manage Service Category
                    
                </p>
            </a>
        </li>

<li class="nav-item menu-open">
            <a href="#" class="nav-link">
                <i class="fa-solid fa-calendar-check nav-icon"></i>
                <p>
                    Manage Appointments
                    <i class="right fas fa-angle-left"></i>
                </p>
            </a>
            <ul class="nav nav-treeview">
                <li class="nav-item">
                    <a href="manageAppointment.php" class="nav-link ">
                        <i class="far fa-circle nav-icon"></i>
                        <p> Pending</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="approvedAppointment.php" class="nav-link ">
                        <i class="far fa-circle nav-icon"></i>
                        <p> Approved</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="renderedAppointment.php" class="nav-link ">
                        <i class="far fa-circle nav-icon"></i>
                        <p> Rendered</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="declinedAppointment.php" class="nav-link ">
                        <i class="far fa-circle nav-icon"></i>
                        <p> Declined</p>
                    </a>
                </li>
            </ul>
        </li>

<li class="nav-item">
            <a href="manageSales.php" class="nav-link">
                <i class="fa-solid fa-sack-dollar nav-icon"></i>
                <p>
                    Manage Sales
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="patientHistory.php" class="nav-link active">
                <i class="fa-solid fa-users-between-lines nav-icon"></i>
                <p>
                    Patients History
                    
                </p>
            </a>
        </li>

</ul>
</nav>

</div>

</aside>

<div class="content-wrapper">
    
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">

</ol>
                </div>
            </div>
        </div>
    </div>

<div class="content">
        <div class="container">

<div class="card">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">APPOINTMENT DETAILS</h3>

</div>

<div class="card-body">
                    <?php
                    $sql = "select * from appoint_date, customer, branch where
                    appoint_date.customer_id = customer.customer_id and appoint_date.branch_id = branch.branch_id and appoint_date.date_id='$date_id'";
                    $res = $conn->query($sql);
                    while ($row = $res->fetch_assoc()) { ?>
                        <div>
                            <div class="row">
                                <div class="col">
                                    Appointment Date: <strong style="text-decoration: underline;"><?php echo $row['ap_date'] ?></strong>
                                </div>
                                <div class="col">
                                    Patient's Name: <strong style="text-decoration: underline;"><?php echo $row['lname'] . ", " . $row['name'] . " " . $row['mname'] ?></strong>
                                </div>
                                <div class="col">
                                    Transaction Number: <strong style="text-decoration: underline;"><?php echo $row['transaction_num'] ?></strong>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col">
                                    Payment Type: <strong style="text-decoration: underline;"><?php echo $row['payment'] ?></strong>
                                </div>
                                <div class=" col">
                                    Total: ₱ <strong style="text-decoration: underline;"><?php echo number_format ($row['total'], 2) ?></strong>
                                </div>
                                <div class=" col">
                                    Status: <strong style="text-decoration: underline;"><?php echo $row['status'] ?></strong>
                                </div>
                            </div>
                        </div>
                    <?php } ?>
                    <hr>
                    <table id=" example2" class="table table-bordered table-striped">
                        <thead class="text-white bg-dark">
                            <tr>

<th>Time</th>
                                <th>Service Category</th>
                                <th>Service Name</th>
                                <th>Price</th>
                                
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $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 = '$date_id'";
                            $res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                                $time = $row['time'];
                                $timenew = substr($time, 0, -3);
                            ?>
                                <tr>
                                    <td>
                                        <?php
                                        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><?php echo $row['category'] ?></td>
                                    <td><?php echo $row['service_name'] ?></td>
                                    <td>₱ <?php echo number_format ($row['price'], 2)  ?></td>

</tr>
                            <?php } ?>
                        </tbody>

</table>

</div>
                
                <div class="card-footer">
                    <a class="btn btn-sm btn-danger float-right" href="patientHistory.php"><i class="fa-solid fa-arrow-left"></i> Back</a>
                </div>
            </div>

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

<aside class="control-sidebar control-sidebar-dark">
    
    <div class="p-3">
        <h5>Title</h5>
        <p>Sidebar content</p>
    </div>
</aside>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header bg-dark text-white">
                <h5 class="modal-title" id="exampleModalLabel">Add Employee</h5>

<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form action="" method="post">
                    <label Class="text-secondary">First Name:</label>
                    <input type="text" class="form-control mb-2" name="fname" placeholder="First Name" required>
                    <label Class="text-secondary">Middle Name:</label>
                    <input type="text" class="form-control mb-2" name="mname" placeholder="Middle Name" required>
                    <label Class="text-secondary">Last Name:</label>
                    <input type="text" class="form-control mb-2" name="lname" placeholder="Last Name" required>
                    <label Class="text-secondary">Position:</label>
                    <input type="text" class="form-control mb-2" name="position" placeholder="Position" required>
                    <label Class="text-secondary">Contact Number:</label>
                    <input type="number" class="form-control mb-2" name="contact_num" placeholder="Contact Number" required>

</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                <button type="submit" name="add_employee" class="btn btn-primary">Add</button>
            </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title text-dark font-weight-bold" id="exampleModalLabel">DELETE CONFIRMATION</h5>
                <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div class="modal-body">
                <form method="POST" id="form-delete">

<h6>Are sure you want to Delete this Data?</h6>

</div>
            <div class="modal-footer">
                <button class="btn btn-danger" type="button" data-dismiss="modal">Cancel</button>
                <button type="submit" form="form-delete" class="btn btn-primary">Yes. Delete It!</button>
            </div>
            </form>
        </div>
    </div>
</div>

<?php
include("footer.php");
include("alert.php");
?>

document.getElementById("form-delete").id.value = id;
        $("#deleteModal").modal("show");
    }
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view4.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation