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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: dataEntry.php

<?php

include('user.php');

if (isset($_SESSION['lock_screen'])) {
    header('location: lockscreen.php');
}

$host = "localhost";
$username = "root";
$password = "";
$database = "motorshop";

// Create DB Connection
$conn = mysqli_connect($host, $username, $password, $database);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

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";
}
?>
<!DOCTYPE html>
<html lang="en">

<head>

<head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>ESG-GSMS | Cashier</title>
        <link href="../img/zamjy.png" rel="icon" />

.suggestion-item {
            padding: 12px;
            cursor: pointer;
        }

.suggestion-item:hover {
            background: #286ba9;
            color: white;
        }
    </style>

option {
            font-size: 20px;
        }

tr td {
            padding: 0.1 !important;
            margin: 0.1 !important;
        }
    </style>

</head>

<div class="wrapper">
        
        <nav class="main-header navbar navbar-expand-md navbar-light navbar-dark">
            <div class="container-fluid">
                <a href="index.php" class="navbar-brand">
                    <img src="../img/zamjy.png" alt="AdminLTE Logo"
                        class="brand-image img-circle elevation-3 border-light" style="opacity: 0.8" />
                    <span class="brand-text font-weight-bold">BOSS JON MOTORSHOP (POS)</span>
                </a>

<li class="nav-item">
                            <a href="index.php" class="nav-link "><i class="fa-solid fa-cash-register"></i> POS</a>
                        </li>
                        <li class="nav-item">
                            <a href="mySales.php" class="nav-link text-uppercase"><i
                                    class="fa-solid fa-money-check-dollar"></i> My
                                Sales</a>
                        </li>

<li class="nav-item">
                            <a href="return.php" class="nav-link text-uppercase"><i class="fa-solid fa-right-left"></i> Return Item</a>
                        </li>

<li class="nav-item">
                            <a href="dataEntry.php" class="nav-link text-uppercase active bg-purple text-white"><i class="fa-solid fa-truck-ramp-box"></i>
                                Data Entry
                            </a>
                        </li>

</ul>

<ul class="order-1 order-md-3 navbar-nav navbar-no-expand ml-auto">

<li class="nav-item dropdown">
                            <a class="nav-link" data-toggle="dropdown" href="#">
                                <i class="fa-solid fa-user mr-lg-1"></i> <?php echo $log_name ?>
                                <i class="fa-solid fa-angle-down ml-lg-1"></i>
                            </a>
                            <div class="dropdown-menu dropdown-menu-xs dropdown-menu-right">

<a href="lockscreen.php" class="dropdown-item">
                                    <i class="fa-solid fa-user-lock mr-1"></i> Lock User
                                </a>
                                <div class="dropdown-divider"></div>
                                <a href="settings.php" class="dropdown-item">
                                    <i class="fa-solid fa-gears mr-1"></i> Settings
                                </a>
                                <div class="dropdown-divider"></div>
                                <a href="../controller/logout.php" class="dropdown-item">
                                    <i class="fa-solid fa-right-to-bracket mr-1"></i> Logout
                                </a>
                            </div>

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

<div class="content-wrapper">
            
            <div class="content-header">
                <div class="container-fluid">

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

<footer class="main-footer text-dark footer">
            
            <div class="float-right d-none d-sm-inline">
                <strong class="font-weight-bold"><i class="fa-regular fa-clock"></i> Running: <?php $currentDateTime = new DateTime('now');
                                                                                                $currentDate = $currentDateTime->format('F d, Y');
                                                                                                echo $currentDate; ?> -
                    <span id="txt"></span></strong>
            </div>
            
            <strong>Copyright &copy;<img src="../img/zamjy.png" style="height: 30px; width: 30px;"> Powered By: <a
                    href="https://www.facebook.com/profile.php?id=61560951500923" target="_blank"> ESG
                    IT-Solutions</a>.</strong> All rights reserved 2023.
        </footer>
    </div>

<script src="../plugins/chart.js/Chart.min.js"></script>

</html>

$(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>

$("#cat_id").val(v1);
    }
</script>

<?php
if (isset($_SESSION['status'])) {
?>

<?php
    unset($_SESSION['status']);
    unset($_SESSION['code']);
}

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

document.getElementById("form-add-menu").menu_id.value = menu;
        $("#addMenuModal").modal("show");
    }
</script>

const today = new Date();
        let h = today.getHours();
        let m = today.getMinutes();
        let s = today.getSeconds();

var date_format = '12'; /* FORMAT CAN BE 12 hour (12) OR 24 hour (24)*/
        var result = h;
        var ext = '';

if (date_format == '12') {
            if (h > 12) {
                ext = 'PM';
                h = (h - 12);
                result = h;

if (h < 10) {
                    result = "0" + h;
                } else if (h == 12) {
                    h = "00";
                    ext = 'AM';
                }
            } else if (h < 12) {
                result = ((h < 10) ? "0" + h : h);
                ext = 'AM';
            } else if (h == 12) {
                ext = 'PM';
            }
        }

if (m < 10) {
            m = "0" + m;
        }

if (s < 10) {
            s = "0" + s;
        }
        result = result + ":" + m + ':' + s + ' ' + ext;
        m = checkTime(m);
        s = checkTime(s);
        document.getElementById('txt').innerHTML = result;
        setTimeout(startTime, 1000);
    }

function checkTime(i) {
        if (i < 10) {
            i = "0" + i
        }; // add zero in front of numbers < 10
        return i;
    }
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: dataEntry.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation