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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: expense-reports.php

<?php
// === server bootstrap & includes ===
include('includes/db.php');

// Normalize connection charset/collation
mysqli_query($conn, "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");
mysqli_query($conn, "SET collation_connection = 'utf8mb4_unicode_ci'");

// --- helpers ---
function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }

// --- UTC to IST conversion functions ---
function utcToIst($utcDateTime, $format = 'Y-m-d h:i A') {
    if (empty($utcDateTime)) return '';
    
    try {
        $utc = new DateTime($utcDateTime, new DateTimeZone('UTC'));
        $utc->setTimezone(new DateTimeZone('Asia/Kolkata')); // IST timezone
        return $utc->format($format);
    } catch (Exception $e) {
        return $utcDateTime; // fallback to original if conversion fails
    }
}

// Check user access
if (!isset($_SESSION['user_id']) && !isset($_SESSION['user_role'])) {
    header('Location: login.php');
    exit();
}

// Get user role
$user_role = isset($_SESSION['user_role']) ? $_SESSION['user_role'] : 'sale';

// === Filter handling ===
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : date('Y-m-01'); // Default: start of current month
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : date('Y-m-d'); // Default: today
$category = isset($_GET['category']) ? $_GET['category'] : '';
$min_amount = isset($_GET['min_amount']) ? (float)$_GET['min_amount'] : 0;
$max_amount = isset($_GET['max_amount']) ? (float)$_GET['max_amount'] : 0;

// Build WHERE conditions
$where_conditions = ["e.date BETWEEN '{$start_date}' AND '{$end_date}'"];
if (!empty($category)) {
    $category = mysqli_real_escape_string($conn, $category);
    $where_conditions[] = "e.category = '{$category}'";
}
if ($min_amount > 0) {
    $where_conditions[] = "e.amount >= {$min_amount}";
}
if ($max_amount > 0) {
    $where_conditions[] = "e.amount <= {$max_amount}";
}

$where_clause = !empty($where_conditions) ? 'WHERE ' . implode(' AND ', $where_conditions) : '';

// === Get summary statistics ===
$summary_query = "
    SELECT 
        COUNT(*) as total_expenses,
        COALESCE(SUM(e.amount), 0) as total_amount,
        COALESCE(MIN(e.amount), 0) as min_amount,
        COALESCE(MAX(e.amount), 0) as max_amount,
        COALESCE(AVG(e.amount), 0) as avg_amount
    FROM expenses e
    {$where_clause}
";

$summary_result = mysqli_query($conn, $summary_query);
$summary = mysqli_fetch_assoc($summary_result);

// === Get expense categories for filter ===
$categories_query = "SELECT DISTINCT category FROM expenses WHERE category IS NOT NULL AND category != '' ORDER BY category";
$categories_result = mysqli_query($conn, $categories_query);

// === Get expense details with pagination ===
$items_per_page = 50;
$current_page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$offset = ($current_page - 1) * $items_per_page;

// Count total records
$count_query = "SELECT COUNT(*) as total FROM expenses e {$where_clause}";
$count_result = mysqli_query($conn, $count_query);
$count_data = mysqli_fetch_assoc($count_result);
$total_records = $count_data['total'];
$total_pages = ceil($total_records / $items_per_page);

// Get expenses data
$expenses_query = "
    SELECT 
        e.*,
        DATE(e.created_at) as entry_date
    FROM expenses e
    {$where_clause}
    ORDER BY e.date DESC, e.id DESC
    LIMIT {$offset}, {$items_per_page}
";

$expenses_result = mysqli_query($conn, $expenses_query);

// === Get category-wise summary for chart ===
$category_summary_query = "
    SELECT 
        category,
        COUNT(*) as count,
        SUM(amount) as total_amount,
        AVG(amount) as avg_amount
    FROM expenses
    WHERE date BETWEEN '{$start_date}' AND '{$end_date}'
    GROUP BY category
    ORDER BY total_amount DESC
    LIMIT 10
";

$category_summary_result = mysqli_query($conn, $category_summary_query);
$category_summary_data = [];
$category_labels = [];
$category_totals = [];
$category_colors = [
    '#FF6384', '#36A2EB', '#FFCE56', '#4BC0C0', '#9966FF',
    '#FF9F40', '#FF6384', '#C9CBCF', '#4BC0C0', '#FFCD56'
];

$color_index = 0;
while($row = mysqli_fetch_assoc($category_summary_result)) {
    $category_summary_data[] = $row;
    $category_labels[] = $row['category'] ?: 'Uncategorized';
    $category_totals[] = (float)$row['total_amount'];
    $color_index = ($color_index + 1) % count($category_colors);
}

// === Get monthly expense trend ===
$monthly_trend_query = "
    SELECT 
        DATE_FORMAT(date, '%Y-%m') as month,
        SUM(amount) as total_amount,
        COUNT(*) as expense_count
    FROM expenses
    WHERE date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
    GROUP BY DATE_FORMAT(date, '%Y-%m')
    ORDER BY month
";

$monthly_trend_result = mysqli_query($conn, $monthly_trend_query);
$monthly_labels = [];
$monthly_totals = [];
$monthly_counts = [];

while($row = mysqli_fetch_assoc($monthly_trend_result)) {
    $monthly_labels[] = date('M Y', strtotime($row['month'] . '-01'));
    $monthly_totals[] = (float)$row['total_amount'];
    $monthly_counts[] = (int)$row['expense_count'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include('includes/head.php'); ?>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css">
    <style>
        .card-value { font-size: 1.5rem; font-weight: 600; margin-bottom: 0; }
        .card-label { font-size: 0.875rem; color: #fff; margin-bottom: 0.5rem; opacity: 0.9; }
        .kpi-card { transition: transform 0.2s; border-radius: 10px; border: none; color: white; }
        .kpi-card:hover { transform: translateY(-3px); box-shadow: 0 4px 15px rgba(0,0,0,0.2); }
        .stats-icon { font-size: 2rem; opacity: 0.8; }
        .filter-card { background: #f8f9fa; border-left: 4px solid #dc3545; }
        .expense-category-badge {
            padding: 4px 10px;
            border-radius: 20px;
            font-size: 0.75rem;
            font-weight: 600;
            background: #e3f2fd;
            color: #1976d2;
            display: inline-block;
        }
        .amount-positive { color: #28a745; }
        .amount-negative { color: #dc3545; }
        .chart-container { position: relative; height: 300px; }
        .category-list { max-height: 200px; overflow-y: auto; }
        .category-item {
            display: flex;
            justify-content: space-between;
            padding: 5px 0;
            border-bottom: 1px solid #eee;
        }
        .category-item:last-child { border-bottom: none; }
        .amount-cell { font-weight: 500; }
        .notes-cell { max-width: 200px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
        .notes-cell:hover { overflow: visible; white-space: normal; }
        .date-input-group { max-width: 200px; }
        .export-buttons .btn { margin-right: 5px; }
        .trend-up { color: #dc3545; }
        .trend-down { color: #28a745; }
    </style>
</head>
<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="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Expense Reports</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Expense Reports</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-danger text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['total_amount'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Total Expenses</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-money-bill-wave stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            <?php echo number_format($summary['total_expenses']); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Total Transactions</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-receipt stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['avg_amount'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Avg. Per Expense</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-calculator stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-secondary text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['min_amount'], 2); ?> - 
                                            ₹<?php echo number_format($summary['max_amount'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Amount Range</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-sliders-h stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-xl-6">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Expenses by Category</h5>
                                <div class="chart-container">
                                    <canvas id="categoryChart"></canvas>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-6">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Monthly Expense Trend</h5>
                                <div class="chart-container">
                                    <canvas id="monthlyTrendChart"></canvas>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Category-wise Summary</h5>
                                <div class="row">
                                    <div class="col-md-8">
                                        <div class="table-responsive">
                                            <table class="table table-sm table-hover">
                                                <thead class="table-light">
                                                    <tr>
                                                        <th>Category</th>
                                                        <th class="text-end">Count</th>
                                                        <th class="text-end">Total Amount</th>
                                                        <th class="text-end">Avg. Amount</th>
                                                        <th class="text-end">% of Total</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php if(!empty($category_summary_data)): ?>
                                                        <?php foreach($category_summary_data as $cat): ?>
                                                            <?php 
                                                            $percentage = $summary['total_amount'] > 0 
                                                                ? ($cat['total_amount'] / $summary['total_amount']) * 100 
                                                                : 0;
                                                            ?>
                                                            <tr>
                                                                <td>
                                                                    <span class="expense-category-badge">
                                                                        <?php echo h($cat['category'] ?: 'Uncategorized'); ?>
                                                                    </span>
                                                                </td>
                                                                <td class="text-end"><?php echo number_format($cat['count']); ?></td>
                                                                <td class="text-end fw-bold amount-negative">
                                                                    ₹<?php echo number_format($cat['total_amount'], 2); ?>
                                                                </td>
                                                                <td class="text-end">₹<?php echo number_format($cat['avg_amount'], 2); ?></td>
                                                                <td class="text-end">
                                                                    <span class="badge bg-light text-dark">
                                                                        <?php echo number_format($percentage, 1); ?>%
                                                                    </span>
                                                                </td>
                                                            </tr>
                                                        <?php endforeach; ?>
                                                    <?php else: ?>
                                                        <tr>
                                                            <td colspan="5" class="text-center text-muted">
                                                                No expense data for the selected period
                                                            </td>
                                                        </tr>
                                                    <?php endif; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="card bg-light">
                                            <div class="card-body">
                                                <h6 class="card-title">Quick Insights</h6>
                                                <div class="mt-3">
                                                    <?php if(!empty($category_summary_data)): ?>
                                                        <?php 
                                                        $top_category = $category_summary_data[0];
                                                        $top_percentage = $summary['total_amount'] > 0 
                                                            ? ($top_category['total_amount'] / $summary['total_amount']) * 100 
                                                            : 0;
                                                        ?>
                                                        <p class="mb-2">
                                                            <i class="fas fa-chart-pie text-primary me-2"></i>
                                                            <strong>Top Category:</strong> 
                                                            <?php echo h($top_category['category'] ?: 'Uncategorized'); ?>
                                                        </p>
                                                        <p class="mb-2">
                                                            <i class="fas fa-percentage text-success me-2"></i>
                                                            <strong>Share:</strong> 
                                                            <?php echo number_format($top_percentage, 1); ?>% of total
                                                        </p>
                                                        <p class="mb-2">
                                                            <i class="fas fa-money-bill text-danger me-2"></i>
                                                            <strong>Amount:</strong> 
                                                            ₹<?php echo number_format($top_category['total_amount'], 2); ?>
                                                        </p>
                                                        <hr>
                                                        <p class="mb-0">
                                                            <i class="fas fa-info-circle text-info me-2"></i>
                                                            <small>Based on period: 
                                                            <?php echo h($start_date); ?> to <?php echo h($end_date); ?></small>
                                                        </p>
                                                    <?php else: ?>
                                                        <p class="text-muted">No insights available</p>
                                                    <?php endif; ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card filter-card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Filter Expenses</h5>
                                <form method="GET" action="" class="row g-3">
                                    <div class="col-md-3">
                                        <label class="form-label">Start Date</label>
                                        <input type="date" class="form-control" name="start_date" 
                                               value="<?php echo h($start_date); ?>" max="<?php echo date('Y-m-d'); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">End Date</label>
                                        <input type="date" class="form-control" name="end_date" 
                                               value="<?php echo h($end_date); ?>" max="<?php echo date('Y-m-d'); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Category</label>
                                        <select class="form-select" name="category">
                                            <option value="">All Categories</option>
                                            <?php while($cat = mysqli_fetch_assoc($categories_result)): ?>
                                                <option value="<?php echo h($cat['category']); ?>" 
                                                    <?php echo $category == $cat['category'] ? 'selected' : ''; ?>>
                                                    <?php echo h($cat['category']); ?>
                                                </option>
                                            <?php endwhile; mysqli_data_seek($categories_result, 0); ?>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Amount Range</label>
                                        <div class="input-group">
                                            <input type="number" class="form-control" placeholder="Min" 
                                                   name="min_amount" value="<?php echo $min_amount > 0 ? h($min_amount) : ''; ?>" 
                                                   min="0" step="0.01">
                                            <span class="input-group-text">to</span>
                                            <input type="number" class="form-control" placeholder="Max" 
                                                   name="max_amount" value="<?php echo $max_amount > 0 ? h($max_amount) : ''; ?>" 
                                                   min="0" step="0.01">
                                        </div>
                                    </div>
                                    <div class="col-md-12 mt-3">
                                        <button type="submit" class="btn btn-danger me-2">
                                            <i class="fas fa-filter me-1"></i> Apply Filters
                                        </button>
                                        <a href="expense-reports.php" class="btn btn-outline-secondary">
                                            <i class="fas fa-times me-1"></i> Clear Filters
                                        </a>
                                        <div class="float-end export-buttons">
                                            <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                                <i class="fas fa-file-excel me-1"></i> Export Excel
                                            </button>
                                            <button type="button" class="btn btn-primary" onclick="printReport()">
                                                <i class="fas fa-print me-1"></i> Print
                                            </button>
                                            <?php if($user_role === 'admin'): ?>
                                                <a href="add-expense.php" class="btn btn-warning">
                                                    <i class="fas fa-plus me-1"></i> Add Expense
                                                </a>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-3">Expense Details</h4>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle mb-0" id="expenses-table">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Date</th>
                                                <th>Category</th>
                                                <th>Description</th>
                                                <th class="text-end">Amount (₹)</th>
                                                <th>Notes</th>
                                                <th>Entry Date</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if(mysqli_num_rows($expenses_result) > 0): ?>
                                                <?php while($expense = mysqli_fetch_assoc($expenses_result)): ?>
                                                    <tr>
                                                        <td>
                                                            <?php echo utcDateToIst($expense['date'], 'M d, Y'); ?>
                                                        </td>
                                                        <td>
                                                            <span class="expense-category-badge">
                                                                <?php echo h($expense['category'] ?: 'Uncategorized'); ?>
                                                            </span>
                                                        </td>
                                                        <td><?php echo h($expense['description']); ?></td>
                                                        <td class="text-end amount-cell amount-negative fw-bold">
                                                            ₹<?php echo number_format($expense['amount'], 2); ?>
                                                        </td>
                                                        <td class="notes-cell" title="<?php echo h($expense['notes']); ?>">
                                                            <?php echo h($expense['notes']); ?>
                                                        </td>
                                                        <td>
                                                            <?php echo utcDateToIst($expense['entry_date'], 'M d, Y'); ?>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm">
                                                                <?php if($user_role === 'admin'): ?>
                                                                    <a href="edit-expense.php?id=<?php echo $expense['id']; ?>" 
                                                                       class="btn btn-outline-warning" title="Edit">
                                                                        <i class="fas fa-edit"></i>
                                                                    </a>
                                                                    <button type="button" 
                                                                            class="btn btn-outline-danger" 
                                                                            title="Delete"
                                                                            onclick="confirmDelete(<?php echo $expense['id']; ?>, '<?php echo h($expense['description']); ?>')">
                                                                        <i class="fas fa-trash"></i>
                                                                    </button>
                                                                <?php endif; ?>
                                                                <button type="button" 
                                                                        class="btn btn-outline-info" 
                                                                        title="View Details"
                                                                        onclick="viewExpenseDetails(<?php echo $expense['id']; ?>)">
                                                                    <i class="fas fa-eye"></i>
                                                                </button>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="7" class="text-center py-4">
                                                        <div class="text-muted">
                                                            <i class="fas fa-receipt fa-2x mb-2"></i><br>
                                                            No expenses found for the selected filters
                                                        </div>
                                                        <?php if($user_role === 'admin'): ?>
                                                            <div class="mt-3">
                                                                <a href="add-expense.php" class="btn btn-primary">
                                                                    <i class="fas fa-plus me-1"></i> Add Your First Expense
                                                                </a>
                                                            </div>
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                        <?php if(mysqli_num_rows($expenses_result) > 0): ?>
                                        <tfoot class="table-light">
                                            <tr>
                                                <td colspan="3" class="text-end fw-bold">Page Totals:</td>
                                                <td class="text-end fw-bold amount-negative">
                                                    ₹<?php 
                                                        $page_total = 0;
                                                        mysqli_data_seek($expenses_result, 0);
                                                        while($expense = mysqli_fetch_assoc($expenses_result)) {
                                                            $page_total += $expense['amount'];
                                                        }
                                                        echo number_format($page_total, 2);
                                                    ?>
                                                </td>
                                                <td colspan="3"></td>
                                            </tr>
                                        </tfoot>
                                        <?php endif; ?>
                                    </table>
                                </div>

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

<?php 
                                                $start_page = max(1, $current_page - 2);
                                                $end_page = min($total_pages, $current_page + 2);
                                                
                                                if($start_page > 1): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => 1])); ?>">1</a>
                                                    </li>
                                                    <?php if($start_page > 2): ?>
                                                        <li class="page-item disabled"><span class="page-link">...</span></li>
                                                    <?php endif; ?>
                                                <?php endif; ?>

<?php for($i = $start_page; $i <= $end_page; $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; ?>

<?php if($end_page < $total_pages): ?>
                                                    <?php if($end_page < $total_pages - 1): ?>
                                                        <li class="page-item disabled"><span class="page-link">...</span></li>
                                                    <?php endif; ?>
                                                    <li class="page-item">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $total_pages])); ?>">
                                                            <?php echo $total_pages; ?>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>

<?php if($current_page < $total_pages): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page + 1])); ?>">
                                                            Next
                                                        </a>
                                                    </li>
                                                <?php endif; ?>
                                            </ul>
                                        </nav>
                                        <div class="text-center text-muted">
                                            Showing <?php echo $offset + 1; ?> to <?php echo min($offset + $items_per_page, $total_records); ?> 
                                            of <?php echo $total_records; ?> expenses
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

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

<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.5/dist/chart.umd.min.js"></script>

<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>

// Chart.js - Category Chart
const categoryCtx = document.getElementById('categoryChart').getContext('2d');
const categoryChart = new Chart(categoryCtx, {
    type: 'pie',
    data: {
        labels: <?php echo json_encode($category_labels); ?>,
        datasets: [{
            data: <?php echo json_encode($category_totals); ?>,
            backgroundColor: <?php echo json_encode(array_slice($category_colors, 0, count($category_labels))); ?>,
            borderWidth: 1,
            borderColor: '#fff'
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false,
        plugins: {
            legend: {
                position: 'right',
                labels: {
                    padding: 20,
                    usePointStyle: true,
                    pointStyle: 'circle'
                }
            },
            tooltip: {
                callbacks: {
                    label: function(context) {
                        let label = context.label || '';
                        if (label) {
                            label += ': ';
                        }
                        label += '₹' + context.raw.toLocaleString();
                        return label;
                    }
                }
            }
        }
    }
});

// Chart.js - Monthly Trend Chart
const monthlyCtx = document.getElementById('monthlyTrendChart').getContext('2d');
const monthlyTrendChart = new Chart(monthlyCtx, {
    type: 'line',
    data: {
        labels: <?php echo json_encode($monthly_labels); ?>,
        datasets: [{
            label: 'Total Expenses',
            data: <?php echo json_encode($monthly_totals); ?>,
            backgroundColor: 'rgba(220, 53, 69, 0.1)',
            borderColor: 'rgba(220, 53, 69, 1)',
            borderWidth: 2,
            tension: 0.4,
            fill: true
        }, {
            label: 'Number of Expenses',
            data: <?php echo json_encode($monthly_counts); ?>,
            backgroundColor: 'rgba(23, 162, 184, 0.1)',
            borderColor: 'rgba(23, 162, 184, 1)',
            borderWidth: 2,
            tension: 0.4,
            fill: true,
            yAxisID: 'y1'
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false,
        interaction: {
            mode: 'index',
            intersect: false,
        },
        scales: {
            y: {
                type: 'linear',
                display: true,
                position: 'left',
                title: {
                    display: true,
                    text: 'Amount (₹)'
                },
                ticks: {
                    callback: function(value) {
                        return '₹' + value.toLocaleString();
                    }
                }
            },
            y1: {
                type: 'linear',
                display: true,
                position: 'right',
                title: {
                    display: true,
                    text: 'Count'
                },
                grid: {
                    drawOnChartArea: false,
                },
            }
        },
        plugins: {
            tooltip: {
                callbacks: {
                    label: function(context) {
                        let label = context.dataset.label || '';
                        if (label.includes('Expenses')) {
                            label += ': ₹' + context.parsed.y.toLocaleString();
                        } else {
                            label += ': ' + context.parsed.y.toLocaleString();
                        }
                        return label;
                    }
                }
            }
        }
    }
});

// Export to Excel function
function exportToExcel() {
    // Create a new workbook
    const wb = XLSX.utils.book_new();
    
    // Get table data
    const table = document.getElementById('expenses-table');
    const ws = XLSX.utils.table_to_sheet(table);
    
    // Add summary data
    const summaryData = [
        ["EXPENSE REPORT SUMMARY"],
        ["Period:", "<?php echo h($start_date); ?> to <?php echo h($end_date); ?>"],
        ["Generated on:", new Date().toLocaleDateString()],
        [],
        ["Total Expenses:", "₹<?php echo number_format($summary['total_amount'], 2); ?>"],
        ["Number of Transactions:", "<?php echo number_format($summary['total_expenses']); ?>"],
        ["Average Amount:", "₹<?php echo number_format($summary['avg_amount'], 2); ?>"],
        ["Minimum Amount:", "₹<?php echo number_format($summary['min_amount'], 2); ?>"],
        ["Maximum Amount:", "₹<?php echo number_format($summary['max_amount'], 2); ?>"],
        []
    ];
    
    const summaryWs = XLSX.utils.aoa_to_sheet(summaryData);
    
    // Add worksheets to workbook
    XLSX.utils.book_append_sheet(wb, summaryWs, "Summary");
    XLSX.utils.book_append_sheet(wb, ws, "Expense Details");
    
    // Generate filename with current date
    const dateStr = new Date().toISOString().slice(0,10);
    const filename = `expense_report_${dateStr}.xlsx`;
    
    // Save the file
    XLSX.writeFile(wb, filename);
}

// Print report function
function printReport() {
    const originalContents = document.body.innerHTML;
    const printContents = `
        <div class="print-container">
            <div class="print-header">
                <h2>Expense Report</h2>
                <p>Period: <?php echo h($start_date); ?> to <?php echo h($end_date); ?></p>
                <p>Generated on: ${new Date().toLocaleDateString()}</p>
            </div>
            
            <div class="summary-box">
                <h4>Summary</h4>
                <table class="summary-table">
                    <tr>
                        <td><strong>Total Expenses:</strong></td>
                        <td>₹<?php echo number_format($summary['total_amount'], 2); ?></td>
                    </tr>
                    <tr>
                        <td><strong>Number of Transactions:</strong></td>
                        <td><?php echo number_format($summary['total_expenses']); ?></td>
                    </tr>
                    <tr>
                        <td><strong>Average Amount:</strong></td>
                        <td>₹<?php echo number_format($summary['avg_amount'], 2); ?></td>
                    </tr>
                    <tr>
                        <td><strong>Amount Range:</strong></td>
                        <td>₹<?php echo number_format($summary['min_amount'], 2); ?> - 
                            ₹<?php echo number_format($summary['max_amount'], 2); ?></td>
                    </tr>
                </table>
            </div>
            
            <div class="expense-details">
                ${document.getElementById('expenses-table').outerHTML}
            </div>
            
            <div class="no-print" style="margin-top: 20px; text-align: center;">
                <button onclick="window.print()" class="btn btn-primary">Print Report</button>
                <button onclick="window.close()" class="btn btn-secondary">Close</button>
            </div>
        </div>
    `;
    
    document.body.innerHTML = `
        <!DOCTYPE html>
        <html>
        <head>
            <title>Expense Report - <?php echo date('Y-m-d'); ?></title>
            <style>
                body { font-family: Arial, sans-serif; margin: 20px; }
                .print-header { text-align: center; margin-bottom: 30px; border-bottom: 2px solid #333; padding-bottom: 20px; }
                .print-header h2 { margin: 0; color: #333; }
                .print-header p { margin: 5px 0; color: #666; }
                .summary-box { 
                    background: #f8f9fa; 
                    border: 1px solid #dee2e6; 
                    padding: 15px; 
                    margin-bottom: 20px;
                    border-radius: 5px;
                }
                .summary-box h4 { margin-top: 0; color: #dc3545; }
                .summary-table { width: 100%; }
                .summary-table td { padding: 8px; border-bottom: 1px solid #eee; }
                .summary-table tr:last-child td { border-bottom: none; }
                table { width: 100%; border-collapse: collapse; margin: 20px 0; }
                th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                th { background-color: #f2f2f2; font-weight: bold; }
                .text-end { text-align: right; }
                .fw-bold { font-weight: bold; }
                .amount-negative { color: #dc3545; }
                @media print {
                    .no-print { display: none; }
                    body { margin: 0; }
                    .summary-box { break-inside: avoid; }
                    table { break-inside: auto; }
                }
                @page {
                    size: auto;
                    margin: 15mm;
                }
            </style>
        </head>
        <body>
            ${printContents}
        </body>
        </html>
    `;
    
    window.print();
    document.body.innerHTML = originalContents;
    window.location.reload();
}

// Confirm before deleting
function confirmDelete(expenseId, description) {
    if(confirm(`Are you sure you want to delete expense: "${description}"? This action cannot be undone.`)) {
        window.location.href = `delete-expense.php?id=${expenseId}`;
    }
}

// View expense details
function viewExpenseDetails(expenseId) {
    // You can implement a modal or redirect to view page
    window.open(`view-expense.php?id=${expenseId}`, '_blank');
}

// Auto-refresh summary stats when filters change
$(document).ready(function() {
    $('form').on('change', 'select, input', function() {
        $('button[type="submit"]').removeAttr('disabled');
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expense-reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation