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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: export-expenses.php

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

// Check if export is requested
if (isset($_GET['export'])) {
    $export_type = $_GET['export'];
    $format = $_GET['format'] ?? 'csv';
    
    // 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 = [];
    
    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);
    }
    
    // Determine what to export
    switch ($export_type) {
        case 'all':
            $sql = "SELECT * FROM expenses $where_clause ORDER BY expense_date DESC, created_at DESC";
            $filename_suffix = 'all_expenses';
            break;
            
        case 'current_month':
            $sql = "SELECT * FROM expenses 
                    WHERE MONTH(expense_date) = MONTH(CURDATE()) 
                    AND YEAR(expense_date) = YEAR(CURDATE()) 
                    ORDER BY expense_date DESC";
            $filename_suffix = 'current_month_expenses';
            break;
            
        case 'last_month':
            $sql = "SELECT * FROM expenses 
                    WHERE MONTH(expense_date) = MONTH(CURDATE() - INTERVAL 1 MONTH) 
                    AND YEAR(expense_date) = YEAR(CURDATE() - INTERVAL 1 MONTH) 
                    ORDER BY expense_date DESC";
            $filename_suffix = 'last_month_expenses';
            break;
            
        case 'custom':
            if (!empty($date_from) && !empty($date_to)) {
                $sql = "SELECT * FROM expenses 
                        WHERE expense_date BETWEEN '$date_from' AND '$date_to' 
                        ORDER BY expense_date DESC";
                $filename_suffix = 'expenses_' . $date_from . '_to_' . $date_to;
            } else {
                die("Custom date range requires both start and end dates.");
            }
            break;
            
        default:
            die("Invalid export type.");
    }
    
    $result = mysqli_query($conn, $sql);
    
    if (!$result) {
        die("Database error: " . mysqli_error($conn));
    }
    
    // Generate filename with timestamp
    $timestamp = date('Y-m-d_H-i-s');
    $filename = "venes_expenses_{$filename_suffix}_{$timestamp}";
    
    // Export based on format
    if ($format === 'excel') {
        exportToExcel($result, $filename);
    } else {
        exportToCSV($result, $filename);
    }
    
    exit;
}

// Function to export as CSV
function exportToCSV($result, $filename) {
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename="' . $filename . '.csv"');
    
    $output = fopen('php://output', 'w');
    
    // Add BOM for UTF-8
    fputs($output, "\xEF\xBB\xBF");
    
    // Column headers
    $headers = array('ID', 'Title', 'Category', 'Amount (₹)', 'Expense Date', 'Notes', 'Created Date');
    fputcsv($output, $headers);
    
    // Data rows
    while ($row = mysqli_fetch_assoc($result)) {
        $category_names = [
            'software' => 'Software',
            'marketing' => 'Marketing',
            'salary' => 'Salary',
            'office' => 'Office',
            'hosting' => 'Hosting',
            'misc' => 'Miscellaneous'
        ];
        
        $data = array(
            $row['id'],
            $row['title'],
            $category_names[$row['category']] ?? ucfirst($row['category']),
            $row['amount'],
            $row['expense_date'],
            $row['notes'],
            $row['created_at']
        );
        
        fputcsv($output, $data);
    }
    
    fclose($output);
}

// Function to export as Excel (HTML table with Excel MIME type)
function exportToExcel($result, $filename) {
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment; filename="' . $filename . '.xls"');
    
    echo '<!DOCTYPE html>
    <html>
    <head>
        <meta charset="UTF-8">
        <style>
            table { border-collapse: collapse; width: 100%; }
            th { background-color: #f8f9fa; font-weight: bold; text-align: left; }
            th, td { border: 1px solid #ddd; padding: 8px; }
            .text-right { text-align: right; }
            .text-center { text-align: center; }
        </style>
    </head>
    <body>
        <table>
            <tr>
                <th>ID</th>
                <th>Title</th>
                <th>Category</th>
                <th>Amount (₹)</th>
                <th>Expense Date</th>
                <th>Notes</th>
                <th>Created Date</th>
            </tr>';
    
    $total_amount = 0;
    $category_totals = [];
    
    while ($row = mysqli_fetch_assoc($result)) {
        $category_names = [
            'software' => 'Software',
            'marketing' => 'Marketing',
            'salary' => 'Salary',
            'office' => 'Office',
            'hosting' => 'Hosting',
            'misc' => 'Miscellaneous'
        ];
        
        $category = $category_names[$row['category']] ?? ucfirst($row['category']);
        $amount = $row['amount'];
        $total_amount += $amount;
        
        // Track category totals
        if (!isset($category_totals[$category])) {
            $category_totals[$category] = 0;
        }
        $category_totals[$category] += $amount;
        
        echo '<tr>
                <td>' . htmlspecialchars($row['id']) . '</td>
                <td>' . htmlspecialchars($row['title']) . '</td>
                <td>' . htmlspecialchars($category) . '</td>
                <td class="text-right">' . number_format($amount, 2) . '</td>
                <td>' . htmlspecialchars($row['expense_date']) . '</td>
                <td>' . htmlspecialchars($row['notes']) . '</td>
                <td>' . htmlspecialchars($row['created_at']) . '</td>
              </tr>';
    }
    
    // Add summary rows
    echo '<tr><td colspan="7" style="border: none;"></td></tr>';
    echo '<tr><td colspan="7" style="border: none; background-color: #f8f9fa; font-weight: bold;">SUMMARY</td></tr>';
    
    foreach ($category_totals as $category => $category_total) {
        echo '<tr>
                <td colspan="2"></td>
                <td><strong>' . htmlspecialchars($category) . '</strong></td>
                <td class="text-right"><strong>₹' . number_format($category_total, 2) . '</strong></td>
                <td colspan="3"></td>
              </tr>';
    }
    
    echo '<tr>
            <td colspan="2"></td>
            <td><strong>TOTAL</strong></td>
            <td class="text-right"><strong>₹' . number_format($total_amount, 2) . '</strong></td>
            <td colspan="3"></td>
          </tr>';
    
    echo '</table>
    </body>
    </html>';
}

// If not exporting, show the export options page
?>

<!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">Export Expenses</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="manage-expenses.php" class="btn btn-secondary btn-sm">
                                <i class="fas fa-arrow-left me-1"></i> Back to Expenses
                            </a>
                            <a href="dashboard.php" class="btn btn-primary btn-sm">Dashboard</a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Export Options</h5>
                            </div>
                            <div class="card-body">
                                
                                <div class="row mb-4">
                                    <div class="col-md-6 mb-3">
                                        <div class="card h-100 border">
                                            <div class="card-body text-center">
                                                <i class="fas fa-download fa-2x text-primary mb-3"></i>
                                                <h5>All Expenses</h5>
                                                <p class="text-muted small">Export complete expense history</p>
                                                <div class="d-grid gap-2">
                                                    <a href="?export=all&format=csv" class="btn btn-outline-primary btn-sm">CSV Format</a>
                                                    <a href="?export=all&format=excel" class="btn btn-outline-success btn-sm">Excel Format</a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6 mb-3">
                                        <div class="card h-100 border">
                                            <div class="card-body text-center">
                                                <i class="fas fa-calendar fa-2x text-success mb-3"></i>
                                                <h5>Current Month</h5>
                                                <p class="text-muted small">Export <?php echo date('F Y'); ?> expenses</p>
                                                <div class="d-grid gap-2">
                                                    <a href="?export=current_month&format=csv" class="btn btn-outline-primary btn-sm">CSV Format</a>
                                                    <a href="?export=current_month&format=excel" class="btn btn-outline-success btn-sm">Excel Format</a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6 mb-3">
                                        <div class="card h-100 border">
                                            <div class="card-body text-center">
                                                <i class="fas fa-calendar-alt fa-2x text-warning mb-3"></i>
                                                <h5>Last Month</h5>
                                                <p class="text-muted small">Export <?php echo date('F Y', strtotime('last month')); ?> expenses</p>
                                                <div class="d-grid gap-2">
                                                    <a href="?export=last_month&format=csv" class="btn btn-outline-primary btn-sm">CSV Format</a>
                                                    <a href="?export=last_month&format=excel" class="btn btn-outline-success btn-sm">Excel Format</a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="card border">
                                    <div class="card-header bg-light">
                                        <h6 class="card-title mb-0">Custom Export with Filters</h6>
                                    </div>
                                    <div class="card-body">
                                        <form method="GET" class="row g-3">
                                            <input type="hidden" name="export" value="custom">
                                            
                                            <div class="col-md-4">
                                                <label class="form-label">Category</label>
                                                <select name="category" class="form-select">
                                                    <option value="">All Categories</option>
                                                    <option value="software">Software</option>
                                                    <option value="marketing">Marketing</option>
                                                    <option value="salary">Salary</option>
                                                    <option value="office">Office</option>
                                                    <option value="hosting">Hosting</option>
                                                    <option value="misc">Miscellaneous</option>
                                                </select>
                                            </div>
                                            
                                            <div class="col-md-4">
                                                <label class="form-label">Date From</label>
                                                <input type="date" name="date_from" class="form-control" required>
                                            </div>
                                            
                                            <div class="col-md-4">
                                                <label class="form-label">Date To</label>
                                                <input type="date" name="date_to" class="form-control" required>
                                            </div>
                                            
                                            <div class="col-md-8">
                                                <label class="form-label">Search</label>
                                                <input type="text" name="search" class="form-control" placeholder="Search in title or notes...">
                                            </div>
                                            
                                            <div class="col-md-4">
                                                <label class="form-label">Format</label>
                                                <select name="format" class="form-select">
                                                    <option value="csv">CSV Format</option>
                                                    <option value="excel">Excel Format</option>
                                                </select>
                                            </div>
                                            
                                            <div class="col-12">
                                                <div class="d-flex justify-content-end gap-2">
                                                    <button type="reset" class="btn btn-outline-secondary">Reset</button>
                                                    <button type="submit" class="btn btn-primary">Export Custom Data</button>
                                                </div>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Export Information</h5>
                            </div>
                            <div class="card-body">
                                <div class="alert alert-info">
                                    <h6 class="alert-heading">About Export Formats:</h6>
                                    <ul class="mb-0 small">
                                        <li><strong>CSV Format:</strong> Best for data analysis and import into other systems</li>
                                        <li><strong>Excel Format:</strong> Best for viewing and printing with formatted tables</li>
                                    </ul>
                                </div>
                                
                                <div class="alert alert-warning">
                                    <h6 class="alert-heading">Export Includes:</h6>
                                    <ul class="mb-0 small">
                                        <li>Expense ID and Title</li>
                                        <li>Category and Amount</li>
                                        <li>Expense Date and Notes</li>
                                        <li>Creation Date</li>
                                        <li>Summary totals by category</li>
                                    </ul>
                                </div>
                                
                                <div class="alert alert-success">
                                    <h6 class="alert-heading">Tips:</h6>
                                    <ul class="mb-0 small">
                                        <li>Use custom export for specific date ranges</li>
                                        <li>Excel format includes summary calculations</li>
                                        <li>CSV files can be opened in any spreadsheet software</li>
                                        <li>Files are automatically named with timestamps</li>
                                    </ul>
                                </div>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Quick Stats</h5>
                            </div>
                            <div class="card-body">
                                <?php
                                // Get some quick stats
                                $total_expenses_sql = "SELECT COUNT(*) as total_count, SUM(amount) as total_amount FROM expenses";
                                $total_expenses_result = mysqli_query($conn, $total_expenses_sql);
                                $total_data = mysqli_fetch_assoc($total_expenses_result);
                                
                                $current_month_sql = "SELECT COUNT(*) as count, SUM(amount) as amount 
                                                     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);
                                ?>
                                
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <span>Total Expenses:</span>
                                    <strong><?php echo $total_data['total_count']; ?> records</strong>
                                </div>
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <span>Total Amount:</span>
                                    <strong class="text-danger">₹<?php echo number_format($total_data['total_amount'] ?? 0, 2); ?></strong>
                                </div>
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <span>This Month:</span>
                                    <strong><?php echo $current_month_data['count']; ?> records</strong>
                                </div>
                                <div class="d-flex justify-content-between align-items-center">
                                    <span>This Month Amount:</span>
                                    <strong class="text-success">₹<?php echo number_format($current_month_data['amount'] ?? 0, 2); ?></strong>
                                </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: export-expenses.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation