Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/sp/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: expense-history.php

<?php
// Database connection
include 'includes/db.php';

// Initialize filter variables
$filter = isset($_GET['filter']) ? $_GET['filter'] : 'all';
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
$total_expenses = 0;

// Build SQL query based on filter
$sql = "SELECT id, remark, amount, expense_date, category FROM expenses";
$where = "";
$params = [];

if ($filter == 'this_month') {
    $where = " WHERE MONTH(expense_date) = MONTH(CURDATE()) AND YEAR(expense_date) = YEAR(CURDATE())";
} elseif ($filter == 'this_week') {
    $where = " WHERE expense_date BETWEEN DATE_SUB(CURDATE(), INTERVAL WEEKDAY(CURDATE()) DAY) AND CURDATE()";
} elseif ($filter == 'this_year') {
    $where = " WHERE YEAR(expense_date) = YEAR(CURDATE())";
} elseif ($filter == 'custom' && !empty($start_date) && !empty($end_date)) {
    $start_date = mysqli_real_escape_string($conn, $start_date);
    $end_date = mysqli_real_escape_string($conn, $end_date);
    $where = " WHERE expense_date BETWEEN '$start_date' AND '$end_date'";
}

$sql .= $where . " ORDER BY created_at DESC";
$result = mysqli_query($conn, $sql);

// Check for query errors
if (!$result) {
    echo "<pre>Error fetching expenses: " . mysqli_error($conn) . "</pre>";
    die();
}

// Calculate total expenses
$total_sql = "SELECT SUM(amount) as total FROM expenses" . $where;
$total_result = mysqli_query($conn, $total_sql);
if ($total_result) {
    $total_row = mysqli_fetch_assoc($total_result);
    $total_expenses = $total_row['total'] ? number_format($total_row['total'], 2) : '0.00';
}

// Debug query results
$rows = mysqli_num_rows($result);
echo "";

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

<div class="startbar d-print-none">
        <div class="brand">
            <a href="index.php" class="logo">
                <span>
                    <img src="assets/images/logo-sm.png" alt="logo-small" class="logo-sm">
                </span>
                <span class="">
                    <img src="assets/images/logo-light.png" alt="logo-large" class="logo-lg logo-light">
                    <img src="assets/images/logo-dark.png" alt="logo-large" class="logo-lg logo-dark">
                </span>
            </a>
        </div>
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>

<div class="page-wrapper">
            
            <div class="page-content">
                <div class="container-fluid">
                    
                    <?php
                    $page_title = "Expense History";
                    $breadcrumb_active = "Expense History";
                    ?>
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                                <h4 class="page-title"><?php echo $page_title; ?></h4>
                                <div class="">
                                    <ol class="breadcrumb mb-0">
                                        <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                        <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                                    </ol>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row align-items-center mb-3">
                        <div class="col">
                            <h3 class="mb-0">Expense History</h3>
                            <small class="text-muted">View all recorded expenses.</small>
                        </div>
                        <div class="col-auto">
                            <a href="expenses.php" class="btn btn-sm btn-primary">Add New Expense</a>
                        </div>
                    </div>

<div class="row mb-3">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <form id="filterForm" action="expense-history.php" method="get" novalidate>
                                        <div class="row g-3 align-items-end">
                                            <div class="col-md-3">
                                                <label for="filter" class="form-label">Filter By</label>
                                                <select class="form-control" id="filter" name="filter" onchange="toggleDateFields()">
                                                    <option value="all" <?php echo $filter == 'all' ? 'selected' : ''; ?>>All</option>
                                                    <option value="this_month" <?php echo $filter == 'this_month' ? 'selected' : ''; ?>>This Month</option>
                                                    <option value="this_week" <?php echo $filter == 'this_week' ? 'selected' : ''; ?>>This Week</option>
                                                    <option value="this_year" <?php echo $filter == 'this_year' ? 'selected' : ''; ?>>This Year</option>
                                                    <option value="custom" <?php echo $filter == 'custom' ? 'selected' : ''; ?>>Between Dates</option>
                                                </select>
                                            </div>
                                            <div class="col-md-3" id="start_date_field" style="display: <?php echo $filter == 'custom' ? 'block' : 'none'; ?>;">
                                                <label for="start_date" class="form-label">Start Date</label>
                                                <input type="date" class="form-control" id="start_date" name="start_date" value="<?php echo htmlspecialchars($start_date); ?>">
                                            </div>
                                            <div class="col-md-3" id="end_date_field" style="display: <?php echo $filter == 'custom' ? 'block' : 'none'; ?>;">
                                                <label for="end_date" class="form-label">End Date</label>
                                                <input type="date" class="form-control" id="end_date" name="end_date" value="<?php echo htmlspecialchars($end_date); ?>">
                                            </div>
                                            <div class="col-md-3">
                                                <button type="submit" class="btn btn-primary">Apply Filter</button>
                                                <a href="expense-history.php" class="btn btn-light">Reset</a>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row mb-3">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-0">Total Expenses: ₹<?php echo $total_expenses; ?></h5>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title mb-0">Expense List</h4>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table id="tblExpenseHistory" class="table table-striped table-bordered align-middle w-100">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#Expense ID</th>
                                                    <th>Remark</th>
                                                    <th>Amount (₹)</th>
                                                    <th>Date</th>
                                                    <th>Category</th>
                                                    <th class="text-end">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php if (mysqli_num_rows($result) > 0) { ?>
                                                    <?php while ($row = mysqli_fetch_assoc($result)) { ?>
                                                        <tr>
                                                            <td>
                                                                <a href="#" class="expense-id" data-expense-id="<?php echo $row['id']; ?>" data-bs-toggle="modal" data-bs-target="#expenseDetailsModal">
                                                                    <?php echo "EXP-" . $row['id']; ?>
                                                                </a>
                                                            </td>
                                                            <td><?php echo $row['remark'] ? htmlspecialchars($row['remark']) : '-'; ?></td>
                                                            <td><?php echo number_format($row['amount'], 2); ?></td>
                                                            <td><?php echo $row['expense_date']; ?></td>
                                                            <td><?php echo htmlspecialchars($row['category']); ?></td>
                                                            <td class="text-end">
                                                                <a href="edit-expense.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-primary">
                                                                    <i class="las la-edit"></i>
                                                                </a>
                                                                <a href="delete-expense.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-danger" onclick="return confirm('Are you sure you want to delete this expense?')">
                                                                    <i class="las la-trash"></i>
                                                                </a>
                                                            </td>
                                                        </tr>
                                                    <?php } ?>
                                                <?php } else { ?>
                                                    <tr>
                                                        <td colspan="6" class="text-center">No expenses found.</td>
                                                    </tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div>

<div class="modal fade" id="expenseDetailsModal" tabindex="-1" aria-labelledby="expenseDetailsModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="expenseDetailsModalLabel">Expense Details</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                            </div>
                            <div class="modal-body">
                                <div id="expenseDetailsContent">
                                    <p>Loading expense details...</p>
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                            </div>
                        </div>
                    </div>
                </div>

<?php include 'includes/rightbar.php'; ?>
                
                <?php include 'includes/footer.php'; ?>
            </div>
            
        </div>

<?php include 'includes/scripts.php'; ?>

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.8/css/dataTables.bootstrap5.min.css">
        <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
        <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>
        <script src="https://cdn.datatables.net/1.13.8/js/dataTables.bootstrap5.min.js"></script>

// Handle click on expense ID to fetch details via AJAX
                $('.expense-id').on('click', function(e) {
                    e.preventDefault();
                    var expenseId = $(this).data('expense-id');
                    
                    $.ajax({
                        url: 'get-expense-details.php',
                        type: 'GET',
                        data: { expense_id: expenseId },
                        dataType: 'html',
                        beforeSend: function() {
                            $('#expenseDetailsContent').html('<p>Loading expense details...</p>');
                            console.log('Sending AJAX request for expense ID: ' + expenseId);
                        },
                        success: function(response) {
                            $('#expenseDetailsContent').html(response);
                            $('#expenseDetailsTable').DataTable({
                                pageLength: 10,
                                searching: false,
                                paging: false,
                                info: false
                            });
                            console.log('AJAX request successful for expense ID: ' + expenseId);
                        },
                        error: function(xhr, status, error) {
                            $('#expenseDetailsContent').html('<p class="text-danger">Error loading expense details: ' + error + '</p>');
                            console.log('AJAX Error Details:');
                            console.log('Status: ' + status);
                            console.log('Error: ' + error);
                            console.log('Response Text: ' + xhr.responseText);
                            console.log('Status Code: ' + xhr.status);
                            console.log('Status Text: ' + xhr.statusText);
                            console.log('URL: ' + this.url);
                        }
                    });
                });
            });

// Toggle date fields visibility
            function toggleDateFields() {
                var filter = document.getElementById('filter').value;
                var startDateField = document.getElementById('start_date_field');
                var endDateField = document.getElementById('end_date_field');
                if (filter === 'custom') {
                    startDateField.style.display = 'block';
                    endDateField.style.display = 'block';
                } else {
                    startDateField.style.display = 'none';
                    endDateField.style.display = 'none';
                }
            }
        </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expense-history.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation