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

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: stock_in.php

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

$invent_id = $_GET['id'];

$get_record = mysqli_query($conn, "select * from branch_inventory, ingredient where branch_inventory.invent_id ='$invent_id' and branch_inventory.ingredients_id = ingredient.ingredient_id");
$row = mysqli_fetch_assoc($get_record);
$db_invent_id = $row['invent_id'];
$db_ing_name = $row['ing_name'];
$db_quantity = $row['quantity'];

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

$quantity = $_POST['quantity'];

$total = $quantity + $db_quantity;

$batch_prefix = "CH";
    $date = date("mdY");
    $batch_number = $batch_prefix . "-" . $date;

$sql = "UPDATE `branch_inventory` SET `quantity`='$total' where invent_id = $invent_id";
    $res = $conn->query($sql);
    
    if($res){
         $logs = "INSERT INTO `stock_logs`(`invent_id`, `current`, `added`, `total`, `batch_number`) 
    VALUES ('$invent_id','$db_quantity','$quantity','$total','$batch_number')";
    $res1 = $conn->query($logs);

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

}

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

$sql = "DELETE FROM branch where branch_id = $branch_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 menu-open">
                <a href="#" class="nav-link ">
                    <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="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 menu-open">
                <a href="#" class="nav-link active">
                    <i class="fa-solid fa-warehouse nav-icon"></i>
                    <p>
                        Manage Inventory
                        <i class="right fas fa-angle-left"></i>
                    </p>
                </a>
                <ul class="nav nav-treeview">
                    <li class="nav-item">
                        <a href="addStock.php" class="nav-link  active">
                            <i class="far fa-circle nav-icon"></i>
                            <p> Add Stock</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="viewStock.php" class="nav-link">
                            <i class="far fa-circle nav-icon"></i>
                            <p> View Stock</p>
                        </a>
                    </li>
                </ul>
            </li>

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

</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="form-group">
                                <label for="" class="float-left">Current Stock:</label>
                                <input type="number" class="form-control" value="<?php echo $db_quantity ?>" readonly>
                            </div>

<div class="form-group">
                                <label for="" class="float-left">Quantity to be Add:</label>
                                <input type="number" name="quantity" class="form-control" required placeholder="Enter Quantity">
                            </div>

</div>
                        
                        <div class="card-footer">
                            <button name="submit" class="btn btn-sm p-2 btn-success btn-block">Submit</button>
                        </div>
                    </form>
                </div>
            </center>

</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="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");
?>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock_in.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation