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/esgpos.shop/public_html/teanaw/main/pos

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: expenses.php

<?php

include('process.php');

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

$log_cashier = "";
$log_bar = "";
$log_kitchen = "";

if (isset($_SESSION['login_id'])) {

$log_id = $_SESSION['login_id'];

$get_record = mysqli_query($conn, "select * from user, branch where user.user_id ='$log_id' and user.branch_id = branch.branch_id");
    $row = mysqli_fetch_assoc($get_record);
    $log_name = $row['name'];
    $log_lastname = $row['lastname'];
    $usertype = $row['usertype'];
    $branch_id = $row['branch_id'];
    $branch_name = $row['branch_name'];
    $log_user = $row['username'];
    $log_password = $row['password'];
    $contact_num = $row['emp_contact_num'];

if ($usertype == "admin") {
        //redirect to admin
        header('Location: ../admin/index.php');
    } else if ($usertype == "cashier") {
        header('location: index.php');
    } else {
    }
} else {
    header("location: ../../index.php");
}

$currentDate = new DateTime();
$today = date_format($currentDate, "Y-m-d");

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

$ingredient_id = $_POST['ingredient_id'];
    $quantity = $_POST['quantity'];
    $unit = $_POST['unit'];
    $unit_price = $_POST['unit_price'];
    $item_total = $quantity * $unit_price;

$get_record = mysqli_query($conn, "select * from branch_inventory where ingredients_id ='$ingredient_id' and branch_id='$branch_id'");
    $row = mysqli_fetch_assoc($get_record);
    $db_quantity = $row['quantity'];

$sql = "INSERT INTO `expense`(`ingredient_id`, `quantity`, `unit`, `price`, `total`, `branch_id`, `user_id`) 
    VALUES ('$ingredient_id','$quantity','$unit','$unit_price','$item_total','$branch_id','$log_id')";
    $result = $conn->query($sql);

$update_quantity = $quantity + $db_quantity;

$sql2 = "UPDATE `branch_inventory` SET `quantity`='$update_quantity' where ingredients_id = '$ingredient_id' and branch_id ='$branch_id'";
    $result3 = $conn->query($sql2);

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

$total = 0;
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <meta password="viewport" content="width=device-width, initial-scale=1" />
    <title>ESGPOS | <?php echo $branch_name ?></title>
    <link href="../img/esg_logo.png" rel="icon" />
    <link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
    
    <link rel="stylesheet"
        href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback" />
    
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css">
    
    <link rel="stylesheet" href="../dist/css/adminlte.min.css" />
    <link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
    <script src="../includes/sweetalert.min.js"></script>

</head>

<body class="dark-mode hold-transition layout-top-nav">
    <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/tenaw_logo.png" alt="AdminLTE Logo"
                        class="brand-image img-circle elevation-3 border-light" style="opacity: 0.8" />
                    <span class="brand-text font-weight-bold">TEANAW</span>
                </a>

<div class="collapse navbar-collapse order-3" id="navbarCollapse">
                    
                    <ul class="navbar-nav">
                        <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"><i class="fa-solid fa-money-check-dollar"></i> My
                                Sales</a>
                        </li>

<li class="nav-item">
                            <a href="reports.php" class="nav-link"><i class="fa-solid fa-file-lines"></i>
                                Sales Report</a>
                        </li>

<li class="nav-item">
                            <a href="startingCash.php" class="nav-link  "><i class="fa-solid fa-wallet"></i> Starting
                                Cash</a>
                        </li>

<li class="nav-item">
                            <a href="expenses.php" class="nav-link bg-success active"><i
                                    class="fa-solid fa-cart-plus"></i> Expenses</a>
                        </li>

<li class="nav-item">
                            <a href="pendingServing.php" class="nav-link"><i class="fa-solid fa-cart-arrow-down"></i> Pending Servings</a>
                        </li>

</ul>
                    </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-1"></i> <?php echo $log_name ?>
                                <i class="fa-solid fa-angle-down ml-1"></i>
                            </a>
                            <div class="dropdown-menu dropdown-menu-xs dropdown-menu-right">
                                <a href="customer_view.php" class="dropdown-item" target="_blank">
                                    <i class="fa-solid fa-tv mr-1"></i> Customer View
                                </a>
                                <a href="openCashdrawer.php" class="nav-link"><i class="fa-solid fa-sack-dollar mr-1"></i>
                                    Open Drawer
                                </a>
                                <a href="lockscreen.php" class="nav-link"><i class="fa-solid fa-user-lock mr-1"></i> Lock User
                                </a>
                                <a href="settings.php" class="dropdown-item">
                                    <i class="fa-solid fa-gears mr-2"></i> Settings
                                </a>
                                <div class="dropdown-divider"></div>
                                <a href="../controller/cashierlogout.php" class="dropdown-item">
                                    <i class="fa-solid fa-right-to-bracket mr-2"></i> Logout
                                </a>
                            </div>
                        </li>
                        <li>
                            <a class="nav-link" data-widget="fullscreen" href="#" role="button">
                                <i class="fas fa-expand-arrows-alt"></i>
                            </a>
                        </li>

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

<div class="content-wrapper">

<div class="content">
                <div class="container pt-5">
                    <div class="row pt-4 justify-content-center">
                        <div class="col-lg-4 col-xs-12">
                            <div class="card">
                                <div class="card-header bg-success h6 text-center font-weight-bold">ADD ITEM</div>
                                <form action="" method="post">
                                    <div class="card-body">
                                        <div class="form-group">
                                            <label for="">Quantity:</label>
                                            <input type="number" name="quantity" id="" class="form-control" required
                                                placeholder="Enter Quantity">
                                        </div>
                                        <div class="form-group">
                                            <label for="">Unit:</label>
                                            <select name="unit" id="" class="form-control">
                                                <option value="">--- Select Unit ---</option>
                                                <option value="Liter/s">Liter/s</option>
                                                <option value="Kilogram/s">Kilogram/s/</option>
                                                <option value="Miligram/s">Miligram/s</option>
                                                <option value="Gram/s">Gram/s</option>
                                                <option value="Box">Box</option>
                                                <option value="Sack/s">Sack/s</option>
                                                <option value="Piece/s">Piece/s</option>
                                            </select>

</div>
                                        <div class="form-group">
                                            <label for="">Item:</label>
                                            <select name="ingredient_id" id="" class="form-control">
                                                <option value="">--- Select Item ---</option>
                                                <?php $sql2 = "SELECT * FROM branch_inventory, ingredient where branch_inventory.ingredients_id = ingredient.ingredient_id and branch_id = '$branch_id' ";
                                                $res2 = $conn->query($sql2);
                                                while ($row2 = $res2->fetch_assoc()) { ?>

</div>

<div class="form-group">
                                            <label for="">Unit Price:</label>
                                            <input type="text" name="unit_price" id="" class="form-control" required
                                                placeholder="Enter Unit Price">
                                        </div>

</div>
                                    <div class="card-footer">
                                        <button class="btn btn-success btn-block" type="submit" name="add"><i
                                                class="fa-solid fa-plus"></i> Add</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                        <div class="col-lg-8 col-xs-12">
                            <div class="card ">
                                <div class="card-header h5 bg-success font-weight-bold">
                                    ITEM
                                </div>

<div class="card-body table-responsive">
                                    <table id="example2" class="table table-hover  table-bordered table-striped">
                                        <thead class="text-white bg-secondary">
                                            <tr>
                                                <th class="">Quantity</th>
                                                <th class="">Unit</th>
                                                <th class="">Item Description</th>
                                                <th class="">Price</th>
                                                <th class="">Subtotal</th>
                                        </thead>

<tbody>
                                            <?php
                                            $sql = "select * from expense, ingredient where expense.branch_id = '$branch_id' and date(expense.date) = '$today' and expense.ingredient_id = ingredient.ingredient_id";
                                            $res = $conn->query($sql);
                                            while ($row = $res->fetch_assoc()) {
                                                $total += $row['total'];
                                            ?>
                                                <tr>
                                                    <td class="col-2"><?php echo $row['quantity'] ?></td>
                                                    <td class="col-2"><?php echo $row['unit'] ?></td>
                                                    <td class=""><?php echo $row['ing_name'] ?></td>
                                                    <td class="col-2"><?php echo $row['price'] ?></td>
                                                    <td class="col-2"><?php echo $row['total'] ?></td>
                                                </tr>

<?php
                                            }
                                            ?>
                                        </tbody>

</table>

</div>

<div class="card-footer">
                                    <h4 class="text-success float-right font-weight-bold"> Total:
                                        <?php echo number_format($total, 2) ?></h4>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<aside class="control-sidebar control-sidebar-dark">
            
        </aside>

<footer class="main-footer text-dark">
            
            <div class="float-right d-none d-sm-inline">
                <?php
                date_default_timezone_set('Asia/Manila');
                ?>
                <small class="font-weight-bold">Running: <?php echo date("F m, Y") . " " . date("l"); ?></small>
            </div>
            
            <strong>Copyright &copy;<img src="../img/esg_logo.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>

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

</html>
<script>

</script>
<script>
    $(function() {
        $("#example1").DataTable({
            "responsive": true,
            "lengthChange": false,
            "autoWidth": false,
            "buttons": ["csv", "excel", "pdf", "print"]
        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
        $('#example2').DataTable({
            "paging": true,
            "lengthChange": true,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });
    });
</script>

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

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expenses.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation