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/silverconchawavepoolresortandhotel.com/public_html/admin/main

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: manageEntry.php

<?php
include("header.php"); //HEADER CALL
include("topnav.php"); // TOP NAVIGATION CALL

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

$item_id = $_POST['item_id'];
}

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

$barcode = $_POST['barcode'];
}

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

$db_quantity = $_POST['db_quantity'];
    $quantity = $_POST['quantity'];
    $db_id = $_POST['db_id'];

$added_stock = $db_quantity + $quantity;

$sql = "UPDATE `item` SET `quantity`='$added_stock' WHERE item_id = '$db_id'";
    $res = $conn->query($sql);

$insert = "INSERT INTO `logs`(`item_id`, `stock`, `added_stock`, `new_stock`) VALUES
     ('$db_id','$db_quantity','$quantity','$added_stock')";
    $result = $conn->query($insert);

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

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

$b_db_quantity = $_POST['b_db_quantity'];
    $b_quantity = $_POST['b_quantity'];
    $b_db_id = $_POST['b_db_id'];

$added_stock = $b_db_quantity + $b_quantity;

$sql = "UPDATE `item` SET `quantity`='$added_stock' WHERE item_id = '$b_db_id'";
    $res = $conn->query($sql);

$insert = "INSERT INTO `logs`(`item_id`, `stock`, `added_stock`, `new_stock`) VALUES
     ('$b_db_id','$b_db_quantity','$b_quantity','$added_stock')";
    $result = $conn->query($insert);

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

<nav class="mt-3">
    <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-user nav-icon"></i>
                <p>
                    Employee
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageEntry.php" class="nav-link active">
                <i class="fa-solid fa-dolly nav-icon"></i>
                <p>
                    Data Entry
                    
                </p>
            </a>
        </li>

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

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

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

<li class="nav-item">
            <a href="manageReports.php" class="nav-link">
                <i class="fa-solid fa-calendar nav-icon"></i>
                <p>
                    Sales Reports
                    
                </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="row" style="height: 400px;">
                <div class="col-lg-5">
                    <div class="card">
                        <div class="card-header bg-lightblue">
                            <h3 class="card-title font-weight-bold mt-1">DATA ENTRY</h3>
                        </div>

<div class="card-body">
                            <form action="" method="post">
                                <label for="">Search By Item Name:</label>
                                <div class="row mb-3">
                                    <div class="col">
                                        <input type="text" id="search" name="search" class="form-control"
                                            placeholder="Search Item Here" required>
                                        <div id="suggestions"></div>
                                        <input type="hidden" name="item_id" id="item_id" placeholder="Email" readonly>
                                    </div>
                                    <div class="col-2">
                                        <button type="submit" class="btn btn-info" name="search_btn"><i class="fa-solid fa-magnifying-glass"></i> Search</button>
                                    </div>
                                </div>
                            </form>
                            <form action="" method="post">
                                <label for="">Search by Barcode:</label>
                                <div class="row">

<div class="col">
                                        <div class="form-group">
                                            <input type="text" name="barcode" class="form-control"
                                                placeholder="Click here. Scan or Manual Enter barcode.." autofocus>
                                        </div>
                                    </div>
                                    <div class="col-2">
                                        <button type="submit" class="btn btn-primary"
                                            name="search_barcode"> <i class="fa-solid fa-magnifying-glass"></i> Search</button>
                                    </div>
                                </div>
                            </form>

</div>
                        
                    </div>
                </div>
                
                <div class="col-lg-7">
                    <?php if (isset($_POST['search_btn'])) {

$sql2 = "SELECT * FROM item WHERE item_id = '$item_id'";
                        $res2 = $conn->query($sql2);
                        while ($row = $res2->fetch_assoc()) { ?>
                            <?php if ($row > 0) { ?>
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title font-weight-bold mt-1">ITEM INFORMATION</h3>
                                    </div>
                                    <form action="" method="post">
                                        <div class="card-body">

<div class="row">
                                                <div class="col">
                                                    <div class="form-group">
                                                        <label for="">Item Name:</label>
                                                        <input type="text" name="item_name_info" class="form-control"
                                                            value="<?php echo $row['item_name'] ?>" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <div class="col">
                                                    <div class="form-group">
                                                        <label for="">Barcode:</label>
                                                        <input type="text" name="barcode_info" class="form-control"
                                                            value="<?php echo $row['barcode'] ?>" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                            </div>

<div class="row">
                                                <div class="col-lg-2">
                                                    <div class=" form-group">
                                                        <label for="">Current Stock:</label>
                                                        <input type="text" name="db_quantity"
                                                            value="<?php echo $row['quantity'] ?> " class="form-control" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <div class="col-lg-2">
                                                    <div class=" form-group">
                                                        <label for="">Quantity:</label>
                                                        <input type="number" name="quantity" class="form-control" required>
                                                        <span><small>* Enter Quantity *</small></span>
                                                    </div>
                                                </div>
                                                <div class="col">
                                                    <div class=" form-group">
                                                        <label for="">Description:</label>
                                                        <input type="text" name="description_info" class="form-control" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <input type="hidden" name="db_id" value="<?php echo $row['item_id'] ?>">
                                            </div>

</div>
                                        <div class="card-footer">
                                            <button class="btn btn-success float-right" name="add_stock"><i class="fa-solid fa-plus"></i> Add Stock</button>
                                        </div>
                                    </form>
                                </div>
                            <?php } else { ?>
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title font-weight-bold mt-1">ITEM INFORMATION</h3>
                                    </div>
                                    <form action="" method="post">
                                        <div class="card-body">

<h6>No Records Found</h6>

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

<?php } ?>
                            <?php }
                    } elseif (isset($_POST['search_barcode'])) {

$getbarcode = mysqli_query($conn, "SELECT barcode FROM `item` where barcode='$barcode'");
                        $getbar = mysqli_num_rows($getbarcode);

if ($getbar > 0) {

$sql2 = "SELECT * FROM item WHERE barcode = '$barcode'";
                            $res2 = $conn->query($sql2);
                            while ($row = $res2->fetch_assoc()) { ?>
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title font-weight-bold mt-1">ITEM INFORMATION</h3>
                                    </div>
                                    <form action="" method="post">
                                        <div class="card-body">

<div class="row">
                                                <div class="col">
                                                    <div class="form-group">
                                                        <label for="">Item Name:</label>
                                                        <input type="text" name="b_item_name_info" class="form-control"
                                                            value="<?php echo $row['item_name'] ?>" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <div class="col">
                                                    <div class="form-group">
                                                        <label for="">Barcode:</label>
                                                        <input type="text" name="b_barcode_info" class="form-control"
                                                            value="<?php echo $row['barcode'] ?>" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                            </div>

<div class="row">
                                                <div class="col-lg-2">
                                                    <div class=" form-group">
                                                        <label for="">Current Stock:</label>
                                                        <input type="text" name="b_db_quantity"
                                                            value="<?php echo $row['quantity'] ?> " class="form-control" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <div class="col-lg-2">
                                                    <div class=" form-group">
                                                        <label for="">Quantity:</label>
                                                        <input type="number" name="b_quantity" class="form-control" required>
                                                        <span><small>* Enter Quantity *</small></span>
                                                    </div>
                                                </div>
                                                <div class="col">
                                                    <div class=" form-group">
                                                        <label for="">Description:</label>
                                                        <input type="text" name="b_description_info" class="form-control" readonly style="background-color:darkslategrey">
                                                    </div>
                                                </div>
                                                <input type="hidden" name="b_db_id" value="<?php echo $row['item_id'] ?>">
                                            </div>

</div>
                                        <div class="card-footer">
                                            <button class="btn btn-success float-right" name="b_add_stock"> <i class="fa-solid fa-plus"></i> Add Stock</button>
                                        </div>
                                    </form>
                                </div>
                            <?php } ?>

<?php } else { ?>

<div class="card">
                                <div class="card-header">
                                    <h3 class="card-title font-weight-bold mt-1">SEARCHED BY BARCODE</h3>
                                </div>
                                <form action="" method="post">
                                    <div class="card-body">

<h6 class="font-weight-bold text-warning">NO AVAILABLE RECORD!</h6>

</div>
                                </form>
                            </div>
                        <?php } ?>
                    <?php } else { ?>

<div class="card">
                            <div class="card-header">
                                <h3 class="card-title font-weight-bold mt-1">ITEM INFORMATION</h3>
                            </div>
                            <div class="card-body">

<div class="row">
                                    <div class="col">
                                        <div class="form-group">
                                            <label for="">Item Name:</label>
                                            <input type="text" name="item_name_info" class="form-control"
                                                readonly style="background-color:darkslategrey">
                                        </div>
                                    </div>
                                    <div class="col">
                                        <div class="form-group">
                                            <label for="">Barcode:</label>
                                            <input type="text" name="barcode_info" class="form-control"
                                                readonly style="background-color:darkslategrey">
                                        </div>
                                    </div>
                                </div>

<div class="row">
                                    <div class="col-2">
                                        <div class=" form-group">
                                            <label for="">Current Stock:</label>
                                            <input type="text" name="db_quantity"
                                                class="form-control" readonly style="background-color:darkslategrey">
                                        </div>
                                    </div>

<div class="col">
                                        <div class=" form-group">
                                            <label for="">Description:</label>
                                            <input type="text" name="description_info" class="form-control" readonly style="background-color:darkslategrey">
                                        </div>
                                    </div>
                                </div>

</div>
                        </div>

<?php  } ?>

</div>

<div class="card">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">ENTRY LOGS</h3>
                </div>
                <div class="card-body">
                    <table id="example2" class="table table-bordered table-striped table-hover">
                        <thead class="text-white bg-secondary">
                            <tr>
                                <th>Item Name</th>
                                <th>Current Stock</th>
                                <th>Added Stock</th>
                                <th>New Stock</th>
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $currentDate = new DateTime();
                            $today = date_format($currentDate, "Y-m-d");
                            $sql = "SELECT * from logs, item where logs.item_id = item.item_id and date(logs.date_logs) ='$today'"; // SHOWING DATA ON THE TABLES
                            $res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                            ?>
                                <tr>
                                    <td><?php echo $row['item_name'] ?></td>
                                    <td><?php echo $row['stock'] ?></td>
                                    <td><?php echo $row['added_stock'] ?></td>
                                    <td><?php echo $row['new_stock'] ?></td>
                                </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="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");
?>
<script>
    $(document).ready(function() {
        $('#search').on('keyup', function() {
            var query = $(this).val();
            if (query.length > 0) {
                $.ajax({
                    url: 'suggestions.php',
                    method: 'GET',
                    data: {
                        q: query
                    },
                    success: function(data) {
                        $('#suggestions').html(data).show();
                    }
                });
            } else {
                $('#suggestions').hide();
            }
        });

$(document).on('click', '.suggestion-item', function() {
            var selectedName = $(this).text();
            var selectedId = $(this).data('id'); // Get the ID

$('#search').val(selectedName);
            $('#item_id').val(selectedId);
            $('#suggestions').hide();

// You can use the ID as needed
            console.log("Selected ID: " + selectedId);
            console.log("Selected Email: " + selectedEmail);
            console.log("Selected Phone: " + selectedPhone);
        });
    });
</script>
<script>
    function confirmDelete(self) {
        var id = self.getAttribute("data-id");

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manageEntry.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation