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: mySales.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());
}

date_default_timezone_set('Asia/Manila');
$currentDate = new DateTime();
$today = date_format($currentDate, "Y-m-d");

?>
<!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" />

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 active bg-purple text-white 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"><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 pb-3 ">
                    <div class="row">
                        <div class="col">
                            <form action="cashierSales.php" method="post">
                                <div class="row mb-2 justify-content-right">

<div class="col">
                                        <input type="date" name="today_sales" class="form-control pb-xs-3" required
                                            style="height: 60px;">
                                    </div>
                                    <div class="col-lg-3 float-right">
                                        <button class="btn btn-info py-3 btn-block " name="mySales"><i
                                                class="fa-solid fa-print"></i>
                                            Cashier Out Report</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                        <div class="col">
                            <div class="container-fluid pb-3 ">
                                <form action="printSales.php" method="post">
                                    <div class="row mb-2">

<div class="col">
                                            <input type="date" name="report_date" class="form-control pb-xs-3" required
                                                style="height: 60px;">
                                        </div>
                                        <div class="col-lg-3 float-right">
                                            <button class="btn btn-success py-3 btn-block " name="generate"><i
                                                    class="fa-solid fa-print"></i>
                                                Print Sales Report</button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>

</div>
                <div class=" container-fluid">

<div class="row">
                        <div class="col-lg-12">
                            <div class="row">
                                
                                <div class="col-lg-6 col-12">
                                    
                                    <div class="small-box" style="background-color: #7d21c0">
                                        <div class="inner">
                                            <h3 class="font-weight-bold">₱
                                                <?php

$result4 = mysqli_query($conn, "SELECT SUM(total) AS cash FROM sales where payment_type = 'CASH' and DATE(sales_date) = '$today'");
                                                $row4 = mysqli_fetch_assoc($result4);
                                                $cash = number_format($row4['cash'], 2);
                                                echo $cash;
                                                ?></h3>

<h4 class="font-weight-bold">CASH SALES</h4>
                                        </div>
                                        <div class="icon">
                                            <i class="fa-solid fa-sack-dollar"></i>
                                        </div>
                                        <a href="#" class="small-box-footer">SALES TODAY
                                            <i class="fas fa-arrow-circle-right"></i></a>
                                    </div>
                                </div>

<div class="col-lg-6 col-12">
                                    
                                    <div class="small-box" style="background-color: #215be9">
                                        <div class="inner">
                                            <h3 class="font-weight-bold">₱
                                                <?php

$result2 = mysqli_query($conn, "SELECT SUM(total) AS cash1 FROM sales where payment_type = 'G-CASH' and DATE(sales_date) = '$today'");
                                                $row2 = mysqli_fetch_assoc($result2);
                                                $cash1 = number_format($row2['cash1'], 2);
                                                echo $cash1;
                                                ?></h3>

<h4 class="font-weight-bold">G-CASH SALES</h4>
                                        </div>
                                        <div class="icon">
                                            <i class="fa-solid fa-mobile-screen-button"></i>
                                        </div>
                                        <a href="#" class="small-box-footer">SALES TODAY <i
                                                class="fas fa-arrow-circle-right"></i></a>
                                    </div>
                                </div>

</div>
                            <div class="card">
                                <div class="card-header font-weight-bold">
                                    TRANSACTION RECORDS
                                </div>
                                <div class="card-body">
                                    <table id="example2" class="table table-bordered table-striped table-hover">
                                        <thead class="text-white bg-secondary">
                                            <tr>
                                                <th>TRANS. #:</th>
                                                <th>Customer Money</th>
                                                <th>Total</th>
                                                <th>Change</th>
                                                <th>Payment Type</th>
                                            </tr>
                                        </thead>

<tbody>
                                            <?php

$sql = "SELECT * from sales where date(sales_date) = '$today'"; // SHOWING DATA ON THE TABLES
                                            $res = $conn->query($sql);
                                            while ($row = $res->fetch_assoc()) {

?>
                                                <tr>
                                                    <td><?php echo $row['order_num'] ?></td>
                                                    <td><?php echo number_format($row['c_money'], 2) ?></td>
                                                    <td><?php echo number_format($row['total'], 2) ?></td>
                                                    <td><?php echo number_format($row['c_change'], 2) ?></td>
                                                    <td><?php echo $row['payment_type'] ?></td>
                                                </tr>
                                            <?php } ?>
                                        </tbody>

</table>
                                </div>
                                <div class="card-footer">

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

var change = c_money - sales;
        var sold_liter = sales / pricePer;
        $('#change').val(change);
        $('#liters').val(sold_liter);
        $('#price').val(pricePer);
        $('#gas_name').val(gasname);

}
    $('#gas_name').change(updateTotal);
    $('#price').change(updateTotal);
    $('#gas').change(updateTotal);
    $('#sales').change(updateTotal);
    $('#liters').change(updateTotal);
    $('#c_money').change(updateTotal);
    $('#change').change(updateTotal);
</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: mySales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation