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/esgpos.shop/public_html/teanaw/main/admin

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: serving.php

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

$remarks = "";
$date = "";

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

$remarks = $_POST['remarks'];
    $date = $_POST['date'];
}

<nav class="mt-4">
        <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="manageEmployee.php" class="nav-link ">
                    <i class="fa-solid fa-users nav-icon"></i>
                    <p>
                        Manage Employee
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="manageIngredient.php" class="nav-link ">
                    <i class="fa-solid fa-basket-shopping nav-icon"></i>
                    <p>
                        Manage Ingredient
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="manageMenuCategory.php" class="nav-link ">
                    <i class="fa-solid fa-spoon nav-icon"></i>
                    <p>
                        Manage Menu Category
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="manageMenu.php" class="nav-link ">
                    <i class="fa-solid fa-utensils nav-icon"></i>
                    <p>
                        Manage Menu
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="manageDiscount.php" class="nav-link">
                    <i class="fa-solid fa-tags nav-icon"></i>
                    <p>
                        Manage Discount
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="MangeInventory.php" class="nav-link ">
                    <i class="fa-solid fa-warehouse nav-icon"></i>
                    <p>
                        Inventory
                        
                    </p>
                </a>
            </li>

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

<li class="nav-item">
                <a href="serving.php" class="nav-link active">
                    <i class="nav-icon fa-solid fa-bell-concierge"></i>
                    <p>
                        Serving Report
                        
                    </p>
                </a>
            </li>

</ul>
    </nav>
    
</div>

</aside>

<div class="content-wrapper">

<div class="content pt-3">
        <div class="container-fluid">
            <form action="" method="post">
                <div class="row">

<label for="">Select Date: </label>
                            <?php if (isset($_POST['date'])) { ?>
                                <input type="date" name="date" class="form-control" required value="<?php echo $date ?>">
                            <?php } else { ?>
                                <input type="date" name="date" class="form-control " required>
                            <?php } ?>
                        </div>
                    </div>

<div class="col-lg-4">
                        <div class="form-group">
                            <label for="">Select Serving: </label>
                            <select name="remarks" id="" class="form-control" required>
                                <?php if (isset($_POST['remarks'])) { ?>
                                    <option value="<?php echo $remarks ?>"><?php echo $remarks ?></option>
                                <?php } else { ?>
                                    <option value="">**** Select **** </option>
                                <?php } ?>
                                <option value="Late Served">Late Served</option>
                                <option value="Served On Time">Served On Time</option>
                            </select>
                        </div>
                    </div>

<div class="col-lg-2">
                        <div class="form-group">
                            <button type="submit" name="search" class="btn btn-success px-4" style="margin-top: 30px;"><i class="fa-solid fa-magnifying-glass"></i> Search</button>
                        </div>
                    </div>
                </div>
            </form>
            <div class="card mt-4 mb-5">
                <div class="card-header h3 font-weight-bold">
                    <span>TOTAL: </span>
                    <?php if (isset($remarks)) {
                        $counter_query = $conn->query("SELECT COUNT(*) FROM serving where date(serve_time) = '$date' and remarks ='$remarks'");
                        $counter = $counter_query->fetch_array(MYSQLI_NUM);
                        echo $counter[0];
                    } ?>
                </div>

<div class="card-body table-responsive">
                    <table id="example5" class="table table-hover  table-bordered table-striped">
                        <thead class="text-dark bg-secondary">
                            <tr>
                                <th>Order Number</th>
                                <th>Order Date/Time</th>
                                <th>Menu</th>
                                <th>Serving Duration</th>
                                <th class="text-center">Remarks</th>
                                <th>Served Time</th>
                            </tr>
                        </thead>

<?php
                        if (isset($_POST['search'])) {

$sql = "SELECT * from byb_walkin_orders INNER JOIN serving ON byb_walkin_orders.order_id = serving.order_id
                             INNER JOIN menu ON byb_walkin_orders.menu_id = menu.menu_id WHERE date(byb_walkin_orders.order_date) = '$date' and serving.remarks = '$remarks'";
                        } else {
                            $sql = "SELECT * from byb_walkin_orders INNER JOIN serving ON byb_walkin_orders.order_id = serving.order_id
                             WHERE date(byb_walkin_orders.order_date) = '$date' and serving.remarks = 'xxxxx'";
                        }
                        $res = $conn->query($sql);
                        while ($row = $res->fetch_assoc()) {

?>
                            <tr>

<td class=""><?php echo $row['order_number'] ?></td>
                                <td class="">
                                    <?php
                                    $db_date = $row['order_date'];
                                    $phpdate = strtotime($db_date);
                                    $mysqldate = date('F d, Y | h:i A', $phpdate);
                                    echo $mysqldate;
                                    ?>
                                </td>
                                <td class=""><?php echo $row['menu_name'] ?></td>
                                <td class=""><?php echo $row['s_duration'] ?> Minutes</td>

<?php
                                if ($row['remarks'] == 'Late Served') { ?>
                                    <td class="text-center"><span class="badge badge-pill badge-danger"><?php echo $row['remarks'] ?></span></td>
                                <?php } else { ?>
                                    <td class="text-center"><span class="badge badge-pill badge-success"><?php echo $row['remarks'] ?></span></td>
                                <?php } ?>

</table>

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

<?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: serving.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation