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/cheatday.store/public_html/main/admin

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: MangeInventory.php

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

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

$raw_name = $_POST['raw_name'];
    $raw_cat_id = $_POST['raw_cat_id'];

$sql = "INSERT INTO `raw`(`raw_name`, `raw_cat_id`) VALUES 
    ('$raw_name','$raw_cat_id')";
    $res = $conn->query($sql);

$_SESSION['status'] = "Data Successfully Added!";
    $_SESSION['code'] = "success";
}

if (isset($_POST['id'])) {
    $raw_id = $_POST['id'];

$sql = "DELETE FROM raw where raw_id = $raw_id ";
    $res = $conn->query($sql);

if ($res == TRUE) {
        $_SESSION['status'] = "Data Successfully Deleted!";
        $_SESSION['code'] = "success";
    }
}

//END FUNCTION
?>

<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="manageBranch.php" class="nav-link">
                    <i class="fa-solid fa-shop nav-icon"></i>
                    <p>
                        Manage Branch
                        
                    </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="manageOrder.php" class="nav-link">
                    <i class="fa-solid fa-truck-fast nav-icon"></i>
                    <p>
                        Manage Order
                        
                    </p>
                </a>
            </li>

<li class="nav-item">
                <a href="MangeInventory.php" class="nav-link active">
                    <i class="fa-solid fa-warehouse nav-icon"></i>
                    <p>
                        Branch 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>
        </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-fluid">

<div class="alert alert-info alert-dismissible fade show mb-4">
                <button type="button" class="close" data-dismiss="alert">&times;</button>
                <strong>Info!</strong> Please Select Branch and Click Search to View the Inventory of a Branch.
            </div>

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

$branch_id = $_POST['branch_id'];

$get_record = mysqli_query($conn, "select * from branch where branch_id ='$branch_id'");
                $row = mysqli_fetch_assoc($get_record);
                $db_branch_name = $row['branch_name'];
            }
            ?>

<form action="" method="post">
                <div class="row mb-2">
                    <div class="col-lg-4">
                        <select name="branch_id" id="" class="form-control " required>
                            <?php if (isset($_POST['branch_id'])) { ?>
                                <option value="<?php echo $branch_id ?>"><?php echo $db_branch_name ?></option>
                            <?php } else { ?>
                                <option value="">--- Select a Branch --- </option>
                            <?php } ?>

<?php $sql2 = "select * from branch where branch_name != 1";
                            $res2 = $conn->query($sql2); ?>

<?php while ($row2 = $res2->fetch_assoc()) { ?>

<option value="<?php echo $row2['branch_id'] ?>"><?php echo $row2['branch_name'] ?></option>
                            <?php } ?>
                        </select>
                    </div>
                    <div class="col-lg-4">
                        <button class="btn btn-primary pl-4 pr-4" name="submit"><i
                                class="fa-solid fa-magnifying-glass"></i> Search</button>
                    </div>
                </div>
            </form>

<hr>
            <div class="card card-outline card-success">
                <!-- <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">BRANCH INVENTORY</h3>

</div> -->

<div class="card-body">
                    <table id="example1" class="table table-hover table-bordered table-striped">
                        <thead class="text-white bg-secondary">
                            <tr>
                                <th>Item Name</th>
                                <th>Quantity In Stock</th>
                                <th>Unit</th>
                                <th>Category</th>
                                <th>Location</th>
                                <th class="text-center">Stock Level</th>
                                <th class="text-center">Branch</th>

</tr>
                        </thead>

<tbody>
                            <?php
                            if (!isset($_POST['submit'])) {
                                $sql = "select * from branch_inventory, branch,  ingredient where branch_inventory.ingredients_id = ingredient.ingredient_id and
                             branch.branch_id = branch_inventory.branch_id ";
                                $res = $conn->query($sql);
                                while ($row = $res->fetch_assoc()) {
                                    ?>
                                    <tr>

<?php if ($row['quantity'] <= 10) { ?>
                                            <td class="text-center"><span class="badge badge-danger">Low</span></td>
                                        <?php } else if ($row['quantity'] >= 11 and $row['quantity'] <= 20) { ?>
                                                <td class="text-center"><span class="badge badge-warning">Average</span></td>
                                        <?php } else { ?>
                                                <td class="text-center"><span class="badge badge-success">Normal</span></td>
                                        <?php } ?>
                                        <td class=""><?php echo $row['branch_name'] ?></td>

</tr>
                                <?php } ?>
                            <?php } else { ?>

<?php $sql = "select * from branch, branch_inventory, ingredient where branch_inventory.ingredients_id = ingredient.ingredient_id and
                                branch.branch_id = '$branch_id' and branch_inventory.branch_id = '$branch_id'";
                                $res = $conn->query($sql);
                                while ($row = $res->fetch_assoc()) {
                                    ?>
                                    <tr>

</tr>

<?php }
                            } ?>

</tbody>

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

<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-teal">
                <h5 class="modal-title" id="exampleModalLabel">Add Raw</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">Raw Category</label>
                    <select name="raw_cat_id" id="" class="form-control mb-3">
                        <option value="">--- Select Category ---</option>
                        <?php $sql = "select * from raw_category";
                        $res1 = $conn->query($sql);
                        while ($row1 = $res1->fetch_assoc()) { ?>
                            <option value="<?php echo $row1['raw_cat_id'] ?>"><?php echo $row1['r_cat_name']; ?></option>
                        <?php } ?>
                    </select>

</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                <button type="submit" name="add" class="btn btn-success pl-4 pr-4">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-success">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: MangeInventory.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation