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/ecommer.in/public_html/billing/printing

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: manage-expenses.php

<?php
// manage-expenses.php
session_start();
require_once 'includes/db.php';

$message = '';

// Handle expense deletion
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    
    // Check if expense exists
    $check_sql = "SELECT id FROM expenses WHERE id = $delete_id";
    $check_result = mysqli_query($conn, $check_sql);
    
    if (mysqli_num_rows($check_result) > 0) {
        $delete_sql = "DELETE FROM expenses WHERE id = $delete_id";
        if (mysqli_query($conn, $delete_sql)) {
            $message = '<div class="alert alert-success">Expense deleted successfully!</div>';
        } else {
            $message = '<div class="alert alert-danger">Error deleting expense: ' . mysqli_error($conn) . '</div>';
        }
    } else {
        $message = '<div class="alert alert-danger">Expense not found!</div>';
    }
}

// Handle bulk actions
if (isset($_POST['bulk_action']) && isset($_POST['selected_expenses'])) {
    $selected_ids = $_POST['selected_expenses'];
    $bulk_action = $_POST['bulk_action'];
    
    if (!empty($selected_ids)) {
        $ids_string = implode(',', array_map('intval', $selected_ids));
        
        if ($bulk_action === 'delete') {
            $delete_sql = "DELETE FROM expenses WHERE id IN ($ids_string)";
            if (mysqli_query($conn, $delete_sql)) {
                $message = '<div class="alert alert-success">' . count($selected_ids) . ' expense(s) deleted successfully!</div>';
            } else {
                $message = '<div class="alert alert-danger">Error deleting expenses: ' . mysqli_error($conn) . '</div>';
            }
        }
    } else {
        $message = '<div class="alert alert-warning">Please select expenses to perform bulk action.</div>';
    }
}

// Get filter parameters
$category_filter = $_GET['category'] ?? '';
$date_from = $_GET['date_from'] ?? '';
$date_to = $_GET['date_to'] ?? '';
$search = $_GET['search'] ?? '';

// Build query with filters
$where_conditions = [];
$query_params = [];

if (!empty($category_filter)) {
    $where_conditions[] = "category = '" . mysqli_real_escape_string($conn, $category_filter) . "'";
}

if (!empty($date_from)) {
    $where_conditions[] = "expense_date >= '" . mysqli_real_escape_string($conn, $date_from) . "'";
}

if (!empty($date_to)) {
    $where_conditions[] = "expense_date <= '" . mysqli_real_escape_string($conn, $date_to) . "'";
}

if (!empty($search)) {
    $search_term = mysqli_real_escape_string($conn, $search);
    $where_conditions[] = "(title LIKE '%$search_term%' OR notes LIKE '%$search_term%')";
}

$where_clause = '';
if (!empty($where_conditions)) {
    $where_clause = 'WHERE ' . implode(' AND ', $where_conditions);
}

// Get total count for pagination
$count_sql = "SELECT COUNT(*) as total FROM expenses $where_clause";
$count_result = mysqli_query($conn, $count_sql);
$total_expenses = mysqli_fetch_assoc($count_result)['total'];

// Pagination
$per_page = 10;
$total_pages = ceil($total_expenses / $per_page);
$current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$offset = ($current_page - 1) * $per_page;

// Get expenses with pagination
$sql = "SELECT * FROM expenses $where_clause ORDER BY expense_date DESC, created_at DESC LIMIT $offset, $per_page";
$result = mysqli_query($conn, $sql);

// Get total amount for current filter
$total_amount_sql = "SELECT SUM(amount) as total_amount FROM expenses $where_clause";
$total_amount_result = mysqli_query($conn, $total_amount_sql);
$total_amount_data = mysqli_fetch_assoc($total_amount_result);
$total_amount = $total_amount_data['total_amount'] ?? 0;

// Get category statistics
$category_stats_sql = "SELECT category, COUNT(*) as count, SUM(amount) as total 
                       FROM expenses 
                       GROUP BY category 
                       ORDER BY total DESC";
$category_stats_result = mysqli_query($conn, $category_stats_sql);
$category_stats = [];
while ($row = mysqli_fetch_assoc($category_stats_result)) {
    $category_stats[] = $row;
}
?>
<!doctype html>
<html lang="en">
<?php include('includes/head.php')?>
<body data-sidebar="dark">
<?php include('includes/pre-loader.php')?>
<div id="layout-wrapper">
    <?php include('includes/topbar.php')?>
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php')?>
        </div>
    </div>

<div class="row align-items-center mb-3">
                    <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
                        <h4 class="mb-0">Manage Expenses</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="add-expense.php" class="btn btn-primary btn-sm">
                                <i class="fas fa-plus me-1"></i> Add New Expense
                            </a>
                            <a href="dashboard.php" class="btn btn-secondary btn-sm">Dashboard</a>
                        </div>
                    </div>
                </div>

<?php echo $message; ?>

<div class="row mb-4">
                    <div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Total Expenses</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-receipt text-primary h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h3 class="mb-1">₹<?php echo number_format($total_amount, 2); ?></h3>
                                    <p class="text-muted mb-0"><?php echo $total_expenses; ?> expense(s)</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">This Month</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-calendar text-success h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <?php
                                    $current_month_sql = "SELECT SUM(amount) as total 
                                                         FROM expenses 
                                                         WHERE MONTH(expense_date) = MONTH(CURDATE()) 
                                                         AND YEAR(expense_date) = YEAR(CURDATE())";
                                    $current_month_result = mysqli_query($conn, $current_month_sql);
                                    $current_month_data = mysqli_fetch_assoc($current_month_result);
                                    $current_month_total = $current_month_data['total'] ?? 0;
                                    ?>
                                    <h3 class="mb-1">₹<?php echo number_format($current_month_total, 2); ?></h3>
                                    <p class="text-muted mb-0">Current month expenses</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Last Month</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-calendar-alt text-warning h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <?php
                                    $last_month_sql = "SELECT SUM(amount) as total 
                                                      FROM expenses 
                                                      WHERE MONTH(expense_date) = MONTH(CURDATE() - INTERVAL 1 MONTH) 
                                                      AND YEAR(expense_date) = YEAR(CURDATE() - INTERVAL 1 MONTH)";
                                    $last_month_result = mysqli_query($conn, $last_month_sql);
                                    $last_month_data = mysqli_fetch_assoc($last_month_result);
                                    $last_month_total = $last_month_data['total'] ?? 0;
                                    ?>
                                    <h3 class="mb-1">₹<?php echo number_format($last_month_total, 2); ?></h3>
                                    <p class="text-muted mb-0">Previous month expenses</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Average/Month</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-chart-line text-info h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <?php
                                    $avg_month_sql = "SELECT AVG(monthly_total) as avg_monthly 
                                                     FROM (SELECT SUM(amount) as monthly_total 
                                                           FROM expenses 
                                                           GROUP BY YEAR(expense_date), MONTH(expense_date)) as monthly_totals";
                                    $avg_month_result = mysqli_query($conn, $avg_month_sql);
                                    $avg_month_data = mysqli_fetch_assoc($avg_month_result);
                                    $avg_monthly = $avg_month_data['avg_monthly'] ?? 0;
                                    ?>
                                    <h3 class="mb-1">₹<?php echo number_format($avg_monthly, 2); ?></h3>
                                    <p class="text-muted mb-0">Average monthly expenses</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="card mb-4">
                    <div class="card-body">
                        <form method="GET" class="row g-3">
                            <div class="col-md-3">
                                <label class="form-label">Category</label>
                                <select name="category" class="form-select">
                                    <option value="">All Categories</option>
                                    <option value="software" <?php echo $category_filter === 'software' ? 'selected' : ''; ?>>Software</option>
                                    <option value="marketing" <?php echo $category_filter === 'marketing' ? 'selected' : ''; ?>>Marketing</option>
                                    <option value="salary" <?php echo $category_filter === 'salary' ? 'selected' : ''; ?>>Salary</option>
                                    <option value="office" <?php echo $category_filter === 'office' ? 'selected' : ''; ?>>Office</option>
                                    <option value="hosting" <?php echo $category_filter === 'hosting' ? 'selected' : ''; ?>>Hosting</option>
                                    <option value="misc" <?php echo $category_filter === 'misc' ? 'selected' : ''; ?>>Miscellaneous</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">Date From</label>
                                <input type="date" name="date_from" class="form-control" value="<?php echo htmlspecialchars($date_from); ?>">
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">Date To</label>
                                <input type="date" name="date_to" class="form-control" value="<?php echo htmlspecialchars($date_to); ?>">
                            </div>
                            <div class="col-md-3">
                                <label class="form-label">Search</label>
                                <input type="text" name="search" class="form-control" placeholder="Search title or notes..." value="<?php echo htmlspecialchars($search); ?>">
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <div class="d-flex gap-2 w-100">
                                    <button type="submit" class="btn btn-primary flex-grow-1">Filter</button>
                                    <a href="manage-expenses.php" class="btn btn-outline-secondary">Reset</a>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-8">
                        
                        <div class="card">
                            <div class="card-header bg-light d-flex justify-content-between align-items-center">
                                <h5 class="card-title mb-0">Expenses List</h5>
                                <div class="text-muted small">
                                    Showing <?php echo min($per_page, mysqli_num_rows($result)); ?> of <?php echo $total_expenses; ?> expenses
                                </div>
                            </div>
                            <div class="card-body">
                                <?php if (mysqli_num_rows($result) > 0): ?>
                                <form method="POST" id="expensesForm">
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th class="text-center" style="width: 40px;">
                                                        <input type="checkbox" id="selectAll" class="form-check-input">
                                                    </th>
                                                    <th>Title</th>
                                                    <th>Category</th>
                                                    <th class="text-end">Amount</th>
                                                    <th>Date</th>
                                                    <th class="text-center">Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($expense = mysqli_fetch_assoc($result)): ?>
                                                <tr>
                                                    <td class="text-center">
                                                        <input type="checkbox" name="selected_expenses[]" value="<?php echo $expense['id']; ?>" class="form-check-input expense-checkbox">
                                                    </td>
                                                    <td>
                                                        <div>
                                                            <h6 class="mb-1"><?php echo htmlspecialchars($expense['title']); ?></h6>
                                                            <?php if (!empty($expense['notes'])): ?>
                                                            <small class="text-muted"><?php echo htmlspecialchars(substr($expense['notes'], 0, 50)); ?><?php echo strlen($expense['notes']) > 50 ? '...' : ''; ?></small>
                                                            <?php endif; ?>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <span class="badge 
                                                            <?php 
                                                            $category_badges = [
                                                                'software' => 'bg-primary',
                                                                'marketing' => 'bg-success',
                                                                'salary' => 'bg-warning',
                                                                'office' => 'bg-info',
                                                                'hosting' => 'bg-secondary',
                                                                'misc' => 'bg-dark'
                                                            ];
                                                            echo $category_badges[$expense['category']] ?? 'bg-secondary';
                                                            ?>
                                                        ">
                                                            <?php 
                                                            $category_names = [
                                                                'software' => 'Software',
                                                                'marketing' => 'Marketing',
                                                                'salary' => 'Salary',
                                                                'office' => 'Office',
                                                                'hosting' => 'Hosting',
                                                                'misc' => 'Misc'
                                                            ];
                                                            echo $category_names[$expense['category']] ?? ucfirst($expense['category']);
                                                            ?>
                                                        </span>
                                                    </td>
                                                    <td class="text-end">
                                                        <strong class="text-danger">₹<?php echo number_format($expense['amount'], 2); ?></strong>
                                                    </td>
                                                    <td>
                                                        <?php echo date('M j, Y', strtotime($expense['expense_date'])); ?>
                                                    </td>
                                                    <td class="text-center">
                                                        <div class="btn-group btn-group-sm">
                                                            <a href="edit-expense.php?id=<?php echo $expense['id']; ?>" class="btn btn-outline-primary" title="Edit">
                                                                <i class="fas fa-edit"></i>
                                                            </a>
                                                            <a href="manage-expenses.php?delete_id=<?php echo $expense['id']; ?>" 
                                                               class="btn btn-outline-danger" 
                                                               title="Delete"
                                                               onclick="return confirm('Are you sure you want to delete this expense? This action cannot be undone.')">
                                                                <i class="fas fa-trash"></i>
                                                            </a>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>

<div class="row mt-3">
                                        <div class="col-md-6">
                                            <select name="bulk_action" class="form-select form-select-sm">
                                                <option value="">Bulk Actions</option>
                                                <option value="delete">Delete Selected</option>
                                            </select>
                                        </div>
                                        <div class="col-md-6 text-end">
                                            <button type="submit" class="btn btn-sm btn-outline-danger" onclick="return confirm('Are you sure you want to perform this action on selected expenses?')">
                                                Apply
                                            </button>
                                        </div>
                                    </div>
                                </form>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav>
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?php echo $current_page <= 1 ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page - 1])); ?>">Previous</a>
                                                </li>
                                                
                                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                    <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?php echo $current_page >= $total_pages ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page + 1])); ?>">Next</a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>

<?php else: ?>
                                <div class="text-center py-5">
                                    <i class="fas fa-receipt fa-3x text-muted mb-3"></i>
                                    <h5>No expenses found</h5>
                                    <p class="text-muted">No expenses match your current filters.</p>
                                    <a href="add-expense.php" class="btn btn-primary">Add Your First Expense</a>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Expenses by Category</h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($category_stats)): ?>
                                    <?php foreach ($category_stats as $stat): ?>
                                    <div class="d-flex align-items-center mb-3">
                                        <div class="flex-grow-1">
                                            <h6 class="mb-1">
                                                <?php 
                                                $category_names = [
                                                    'software' => 'Software',
                                                    'marketing' => 'Marketing',
                                                    'salary' => 'Salary',
                                                    'office' => 'Office',
                                                    'hosting' => 'Hosting',
                                                    'misc' => 'Miscellaneous'
                                                ];
                                                echo $category_names[$stat['category']] ?? ucfirst($stat['category']);
                                                ?>
                                            </h6>
                                            <p class="text-muted mb-0 small">
                                                <?php echo $stat['count']; ?> expense(s) • 
                                                ₹<?php echo number_format($stat['total'], 2); ?>
                                            </p>
                                        </div>
                                        <div class="flex-shrink-0">
                                            <span class="text-primary fw-bold">
                                                <?php echo $total_amount > 0 ? number_format(($stat['total'] / $total_amount) * 100, 1) : 0; ?>%
                                            </span>
                                        </div>
                                    </div>
                                    <div class="progress mb-3" style="height: 6px;">
                                        <div class="progress-bar" role="progressbar" 
                                             style="width: <?php echo $total_amount > 0 ? ($stat['total'] / $total_amount) * 100 : 0; ?>%" 
                                             aria-valuenow="<?php echo $total_amount > 0 ? ($stat['total'] / $total_amount) * 100 : 0; ?>" 
                                             aria-valuemin="0" aria-valuemax="100">
                                        </div>
                                    </div>
                                    <?php endforeach; ?>
                                <?php else: ?>
                                    <div class="text-center py-3">
                                        <p class="text-muted mb-0">No expense data available</p>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Quick Actions</h5>
                            </div>
                            <div class="card-body">
                                <div class="d-grid gap-2">
                                    <a href="add-expense.php" class="btn btn-primary">
                                        <i class="fas fa-plus me-2"></i>Add New Expense
                                    </a>
                                    <a href="export-expenses.php" class="btn btn-outline-success">
                                        <i class="fas fa-download me-2"></i>Export to Excel
                                    </a>
                                    <button type="button" class="btn btn-outline-info" data-bs-toggle="modal" data-bs-target="#importModal">
                                        <i class="fas fa-upload me-2"></i>Import Expenses
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>
        <?php include('includes/footer.php')?>
    </div>
</div>

<?php include('includes/rightbar.php')?>
<?php include('includes/scripts.php')?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-expenses.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation