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: manageSales.php

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

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

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

$get_bar = mysqli_query($online, "SELECT * FROM `branch_inventory` where ingredients_id ='$ingredient_id' and branch_id = '$db_branch_id'");
    $row = mysqli_num_rows($get_bar);

if ($row) {
        $_SESSION['status'] = "Item Already Exists!";
        $_SESSION['code'] = "error";
    } else {
        $sql = "INSERT INTO `branch_inventory`(`ingredients_id`, `quantity`, `unit`, `category`, `location`, `branch_id`) 
    VALUES ('$ingredient_id','$quantity','$unit','$category','$location','$db_branch_id')";
        $res = $conn->query($sql);
        $res1 = $online->query($sql);

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

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

$sql = "DELETE FROM user where user_id = $user_id ";
    $res = $conn->query($sql);

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

//END FUNCTION
?>

<nav class="pt-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">
                    <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">
                            <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 active">
                    <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 active">
                            <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">
        <div class="container-fluid pt-3">
            <div class="row">
                <div class="col">
                    <h5 for="" class="font-weight-bold">Select a Date:</h5>
                </div>
            </div>
            <?php
            if (isset($_POST['search'])) {
                $date = $_POST['date'];

$result = mysqli_query($online, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$db_branch_id' and DATE(date) = '$date'");
                $row2 = mysqli_fetch_assoc($result);
                $sum = number_format($row2['value_sum'], 2);
            } else {
                $result = mysqli_query($online, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$db_branch_id'");
                $row2 = mysqli_fetch_assoc($result);
                $sum = number_format($row2['value_sum'], 2);
            }

?>
            <form action="" method="post">
                <div class="row">

<div class="col-lg-6">
                        <div class="form-group">
                            <input type="date" name="date" class="form-control" required placeholder="--- Select Date --">
                        </div>
                    </div>
                    <div class="col-lg-2">
                        <div class="form-group">
                            <button class="btn btn-info" name="search"><i class="fa-solid fa-magnifying-glass"></i> Search</button>
                        </div>
                    </div>
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend ">
                                <span class="input-group-text font-weight-bold bg-success">TOTAL SALES: </span>
                            </div>
                            <?php if (!isset($_POST['search'])) { ?>
                                <input type="text" class="form-control font-weight-bold" style="font-size: 25px;" value="₱  0.00">
                            <?php } else { ?>
                                <input type="text" class="form-control font-weight-bold" style="font-size: 25px;" value="₱ <?php echo $sum ?>">
                            <?php  } ?>

</div>
                    </div>

</div>
            </form>

<div class="card">
                <div class="card-header bg-lightblue font-weight-bold text-white">
                    BRANCH SALES

</div>

<div class="card-body table-responsive">
                    <table id="example5" class="table table-hover  table-bordered table-striped">
                        <thead class="text-dark bg-secondary">
                            <tr>
                                <th>Order Number</th>
                                <th>Order Type</th>
                                <th>Total Order</th>

<th>Gcash</th>
                                <th>Cash</th>

<th>Cashier</th>
                                <th class="col-2">Date</th>
                            </tr>
                        </thead>

<tbody>
                            <?php

if (!isset($_POST['date'])) {
                                $sql = "select * from sales, branch, user where branch.branch_id = '$db_branch_id' and sales.branch_id = '$db_branch_id' and user.user_id = sales.user_id ORDER BY sales.order_number DESC";
                            } else {
                                $sql = "select * from sales, user where sales.branch_id = '$db_branch_id' and date(sales.date) = '$date' and user.user_id = sales.user_id ORDER BY sales.order_number DESC";
                            }

$res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                            ?>
                                <tr>
                                    <td class=""><?php echo $row['order_number'] ?></td>
                                    <td class=""><?php echo $row['order_type'] ?></td>
                                    <td class=""><?php echo number_format($row['total'], 2) ?></td>
                                    <td class=""><?php echo number_format($row['gcash'], 2) ?></td>
                                    <td class=""><?php echo number_format($row['cash'], 2) ?></td>
                                    <td class=""><?php echo $row['name'] . " " . $row['lastname']; ?></td>
                                    <td class="">

<?php
                                        $db_date = $row['date'];

$phpdate = strtotime($db_date);
                                        $mysqldate = date('F d, Y |  h:i:s A',  $phpdate);
                                        echo $mysqldate;
                                        ?>
                                    </td>

</tr>
                            <?php } ?>
                        </tbody>

</table>

</div>

</div>

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

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation