<?php
require_once 'auth.php';
$auth->requireLogin();

$page_title = 'Expenses Management';
$success_message = '';
$error_message = '';

// Get edit data if editing
$edit_expense = null;
if (isset($_GET['edit_expense'])) {
    try {
        $edit_stmt = $pdo->prepare("
            SELECT e.*, ec.category_name, es.subcategory_name, u.full_name as paid_by_name
            FROM expenses e
            JOIN expense_categories ec ON e.category_id = ec.id
            LEFT JOIN expense_subcategories es ON e.subcategory_id = es.id
            JOIN users u ON e.paid_by = u.id
            WHERE e.id = ?
        ");
        $edit_stmt->execute([$_GET['edit_expense']]);
        $edit_expense = $edit_stmt->fetch(PDO::FETCH_ASSOC);
    } catch (PDOException $e) {
        $error_message = 'Error fetching expense for editing.';
    }
}

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['action'])) {
    
    if ($_POST['action'] == 'add_expense' || $_POST['action'] == 'edit_expense') {
        $expense_id = $_POST['expense_id'] ?? null;
        $category_id = $_POST['category_id'] ?? 0;
        $subcategory_id = $_POST['subcategory_id'] ?? null;
        $description = trim($_POST['description'] ?? '');
        $amount = $_POST['amount'] ?? 0;
        $expense_date = $_POST['expense_date'] ?? '';
        $paid_to = trim($_POST['paid_to'] ?? '');
        $paid_by = $_POST['paid_by'] ?? 0;
        $paid_through = $_POST['paid_through'] ?? '';
        $notes = trim($_POST['notes'] ?? '');
        
        // Validation
        if (empty($category_id) || empty($description) || empty($amount) || empty($expense_date) || empty($paid_to) || empty($paid_by) || empty($paid_through)) {
            $error_message = 'All fields except subcategory and notes are required.';
        } elseif (!is_numeric($amount) || $amount <= 0) {
            $error_message = 'Please enter a valid amount greater than zero.';
        } else {
            try {
                if ($_POST['action'] == 'edit_expense' && $expense_id) {
                    // Update existing expense
                    $stmt = $pdo->prepare("
                        UPDATE expenses SET category_id = ?, subcategory_id = ?, description = ?, 
                                          amount = ?, expense_date = ?, paid_to = ?, paid_by = ?, 
                                          paid_through = ?, notes = ?
                        WHERE id = ?
                    ");
                    
                    $stmt->execute([
                        $category_id, $subcategory_id ?: null, $description, $amount, 
                        $expense_date, $paid_to, $paid_by, $paid_through, $notes, $expense_id
                    ]);
                    
                    $_SESSION['success_message'] = 'Expense updated successfully!';
                } else {
                    // Create new expense
                    $expense_number = 'EXP' . date('YmdHis') . rand(100, 999);
                    
                    $stmt = $pdo->prepare("
                        INSERT INTO expenses (expense_number, category_id, subcategory_id, description, amount, 
                                            expense_date, paid_to, paid_by, paid_through, notes, created_by) 
                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                    ");
                    
                    $stmt->execute([
                        $expense_number, $category_id, $subcategory_id ?: null, $description, $amount,
                        $expense_date, $paid_to, $paid_by, $paid_through, $notes, $_SESSION['user_id']
                    ]);
                    
                    $_SESSION['success_message'] = 'Expense added successfully! Reference: ' . $expense_number;
                }
                
                header("Location: expenses.php");
                exit();
                
            } catch (Exception $e) {
                $error_message = 'Error processing expense: ' . $e->getMessage();
            }
        }
    }
    
    elseif ($_POST['action'] == 'delete_expense') {
        $expense_id = intval($_POST['expense_id'] ?? 0);
        
        if ($expense_id > 0) {
            try {
                $stmt = $pdo->prepare("DELETE FROM expenses WHERE id = ?");
                $result = $stmt->execute([$expense_id]);
                
                if ($result) {
                    $_SESSION['success_message'] = 'Expense deleted successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to delete expense.';
                }
                
            } catch (Exception $e) {
                $_SESSION['error_message'] = 'Error deleting expense: ' . $e->getMessage();
            }
        }
        
        header("Location: expenses.php");
        exit();
    }
    
    elseif ($_POST['action'] == 'export_expenses') {
        $export_filter_category = $_POST['export_filter_category'] ?? '';
        $export_filter_subcategory = $_POST['export_filter_subcategory'] ?? '';
        $export_filter_date_from = $_POST['export_filter_date_from'] ?? '';
        $export_filter_date_to = $_POST['export_filter_date_to'] ?? '';
        $export_filter_paid_by = $_POST['export_filter_paid_by'] ?? '';
        $export_filter_paid_through = $_POST['export_filter_paid_through'] ?? '';
        $export_filter_search = $_POST['export_filter_search'] ?? '';
        
        // Build export query with same filters
        $export_where_clause = "1=1";
        $export_params = [];
        
        if (!empty($export_filter_category)) {
            $export_where_clause .= " AND e.category_id = ?";
            $export_params[] = $export_filter_category;
        }
        
        if (!empty($export_filter_subcategory)) {
            $export_where_clause .= " AND e.subcategory_id = ?";
            $export_params[] = $export_filter_subcategory;
        }
        
        if (!empty($export_filter_date_from)) {
            $export_where_clause .= " AND e.expense_date >= ?";
            $export_params[] = $export_filter_date_from;
        }
        
        if (!empty($export_filter_date_to)) {
            $export_where_clause .= " AND e.expense_date <= ?";
            $export_params[] = $export_filter_date_to;
        }
        
        if (!empty($export_filter_paid_by)) {
            $export_where_clause .= " AND e.paid_by = ?";
            $export_params[] = $export_filter_paid_by;
        }
        
        if (!empty($export_filter_paid_through)) {
            $export_where_clause .= " AND e.paid_through = ?";
            $export_params[] = $export_filter_paid_through;
        }
        
        if (!empty($export_filter_search)) {
            $export_where_clause .= " AND (e.description LIKE ? OR e.paid_to LIKE ? OR e.notes LIKE ?)";
            $search_term = '%' . $export_filter_search . '%';
            $export_params[] = $search_term;
            $export_params[] = $search_term;
            $export_params[] = $search_term;
        }
        
        try {
            $export_stmt = $pdo->prepare("
                SELECT e.expense_number, e.expense_date, ec.category_name, 
                       COALESCE(es.subcategory_name, '-') as subcategory_name,
                       e.description, e.amount, e.paid_to, u.full_name as paid_by_name,
                       e.paid_through, e.notes
                FROM expenses e
                JOIN expense_categories ec ON e.category_id = ec.id
                LEFT JOIN expense_subcategories es ON e.subcategory_id = es.id
                JOIN users u ON e.paid_by = u.id
                WHERE $export_where_clause
                ORDER BY e.created_at DESC
            ");
            $export_stmt->execute($export_params);
            $export_data = $export_stmt->fetchAll(PDO::FETCH_ASSOC);
            
            $filename = 'expenses_export_' . date('Y-m-d_H-i-s') . '.csv';
            
            // Generate CSV
            header('Content-Type: text/csv');
            header('Content-Disposition: attachment; filename="' . $filename . '"');
            
            $output = fopen('php://output', 'w');
            
            // Add BOM for proper Excel UTF-8 support
            fwrite($output, "\xEF\xBB\xBF");
            
            // Headers
            fputcsv($output, [
                'Expense Number', 'Date', 'Category', 'Subcategory', 'Description', 
                'Amount', 'Paid To', 'Paid By', 'Payment Method', 'Notes'
            ]);
            
            foreach ($export_data as $row) {
                fputcsv($output, [
                    $row['expense_number'],
                    $row['expense_date'],
                    $row['category_name'],
                    $row['subcategory_name'],
                    $row['description'],
                    $row['amount'],
                    $row['paid_to'],
                    $row['paid_by_name'],
                    $row['paid_through'],
                    $row['notes']
                ]);
            }
            
            fclose($output);
            exit();
            
        } catch (PDOException $e) {
            $error_message = 'Error exporting data: ' . $e->getMessage();
        }
    }
}

// Fetch categories for dropdowns
try {
    $categories_stmt = $pdo->prepare("SELECT * FROM expense_categories WHERE status = 'active' ORDER BY category_name");
    $categories_stmt->execute();
    $categories = $categories_stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Fetch subcategories for dropdowns
    $subcategories_stmt = $pdo->prepare("
        SELECT es.*, ec.category_name 
        FROM expense_subcategories es 
        JOIN expense_categories ec ON es.category_id = ec.id 
        WHERE es.status = 'active' 
        ORDER BY ec.category_name, es.subcategory_name
    ");
    $subcategories_stmt->execute();
    $subcategories = $subcategories_stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Fetch users for dropdown
    $users_stmt = $pdo->prepare("SELECT id, full_name FROM users WHERE status = 'active' ORDER BY full_name");
    $users_stmt->execute();
    $users = $users_stmt->fetchAll(PDO::FETCH_ASSOC);
    
} catch (PDOException $e) {
    $categories = $subcategories = $users = [];
}

// Fetch expenses with filters
$filter_category = $_GET['filter_category'] ?? '';
$filter_subcategory = $_GET['filter_subcategory'] ?? '';
$filter_date_from = $_GET['filter_date_from'] ?? '';
$filter_date_to = $_GET['filter_date_to'] ?? '';
$filter_paid_by = $_GET['filter_paid_by'] ?? '';
$filter_paid_through = $_GET['filter_paid_through'] ?? '';
$filter_search = $_GET['filter_search'] ?? '';

$where_clause = "1=1";
$params = [];

if (!empty($filter_category)) {
    $where_clause .= " AND e.category_id = ?";
    $params[] = $filter_category;
}

if (!empty($filter_subcategory)) {
    $where_clause .= " AND e.subcategory_id = ?";
    $params[] = $filter_subcategory;
}

if (!empty($filter_date_from)) {
    $where_clause .= " AND e.expense_date >= ?";
    $params[] = $filter_date_from;
}

if (!empty($filter_date_to)) {
    $where_clause .= " AND e.expense_date <= ?";
    $params[] = $filter_date_to;
}

if (!empty($filter_paid_by)) {
    $where_clause .= " AND e.paid_by = ?";
    $params[] = $filter_paid_by;
}

if (!empty($filter_paid_through)) {
    $where_clause .= " AND e.paid_through = ?";
    $params[] = $filter_paid_through;
}

if (!empty($filter_search)) {
    $where_clause .= " AND (e.description LIKE ? OR e.paid_to LIKE ? OR e.notes LIKE ?)";
    $search_term = '%' . $filter_search . '%';
    $params[] = $search_term;
    $params[] = $search_term;
    $params[] = $search_term;
}

try {
    // Get expense stats
    $stats_stmt = $pdo->prepare("
        SELECT 
            COUNT(*) as total_expenses,
            COALESCE(SUM(amount), 0) as total_amount
        FROM expenses e WHERE $where_clause
    ");
    $stats_stmt->execute($params);
    $stats = $stats_stmt->fetch(PDO::FETCH_ASSOC);
    
    // Get expense records
    $expenses_stmt = $pdo->prepare("
        SELECT e.*, ec.category_name, 
               COALESCE(es.subcategory_name, '-') as subcategory_name,
               u.full_name as paid_by_name, uc.full_name as created_by_name
        FROM expenses e
        JOIN expense_categories ec ON e.category_id = ec.id
        LEFT JOIN expense_subcategories es ON e.subcategory_id = es.id
        JOIN users u ON e.paid_by = u.id
        JOIN users uc ON e.created_by = uc.id
        WHERE $where_clause
        ORDER BY e.created_at DESC
        LIMIT 100
    ");
    $expenses_stmt->execute($params);
    $expenses = $expenses_stmt->fetchAll(PDO::FETCH_ASSOC);
    
} catch (PDOException $e) {
    $stats = ['total_expenses' => 0, 'total_amount' => 0];
    $expenses = [];
    $error_message = 'Error fetching expense data.';
}

include 'includes/header.php';
?>

<div class="page-header">
    <h1 class="page-title">Expenses Management</h1>
    <p class="page-subtitle">Track and manage your business expenses</p>
</div>

<?php if ($error_message): ?>
    <div class="alert alert-error"><?php echo htmlspecialchars($error_message); ?></div>
<?php endif; ?>

<!-- Stats -->
<div class="dashboard-grid mb-3">
    <div class="stat-card" style="background: linear-gradient(135deg, #f44336 0%, #e57373 100%);">
        <div class="stat-number"><?php echo $stats['total_expenses']; ?></div>
        <div class="stat-label">Total Expenses</div>
    </div>
    <div class="stat-card" style="background: linear-gradient(135deg, #ff9800 0%, #ffb74d 100%);">
        <div class="stat-number">₹<?php echo number_format($stats['total_amount'], 2); ?></div>
        <div class="stat-label">Total Amount</div>
    </div>
</div>

<!-- Add/Edit Expense -->
<div class="card">
    <div class="card-header">
        <h2 class="card-title"><?php echo $edit_expense ? 'Edit Expense' : 'Add New Expense'; ?></h2>
    </div>
    
    <?php if (empty($categories)): ?>
        <div class="alert alert-warning">
            Please <a href="settings.php#categories-section">create expense categories</a> first.
        </div>
    <?php else: ?>
        <form method="POST" id="expenseForm">
            <input type="hidden" name="action" value="<?php echo $edit_expense ? 'edit_expense' : 'add_expense'; ?>">
            <?php if ($edit_expense): ?>
                <input type="hidden" name="expense_id" value="<?php echo $edit_expense['id']; ?>">
            <?php endif; ?>
            
            <!-- Expense Details -->
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 1rem; margin-bottom: 2rem;">
                <div class="form-group">
                    <label class="form-label">Category *</label>
                    <select name="category_id" id="category_id" class="form-select" onchange="updateSubcategories()" required>
                        <option value="">Select Category</option>
                        <?php foreach ($categories as $category): ?>
                            <option value="<?php echo $category['id']; ?>" <?php echo ($edit_expense['category_id'] ?? '') == $category['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($category['category_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Subcategory</label>
                    <select name="subcategory_id" id="subcategory_id" class="form-select">
                        <option value="">Select Subcategory (Optional)</option>
                        <?php foreach ($subcategories as $subcategory): ?>
                            <option value="<?php echo $subcategory['id']; ?>" 
                                    data-category="<?php echo $subcategory['category_id']; ?>"
                                    <?php echo ($edit_expense['subcategory_id'] ?? '') == $subcategory['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($subcategory['subcategory_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Expense Date *</label>
                    <input type="date" name="expense_date" class="form-input" 
                           value="<?php echo $edit_expense ? $edit_expense['expense_date'] : date('Y-m-d'); ?>" required>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Amount (₹) *</label>
                    <input type="number" name="amount" class="form-input" step="0.01" min="0.01" 
                           placeholder="0.00" value="<?php echo $edit_expense['amount'] ?? ''; ?>" required>
                </div>
            </div>
            
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 1rem; margin-bottom: 2rem;">
                <div class="form-group">
                    <label class="form-label">Description *</label>
                    <input type="text" name="description" class="form-input" 
                           placeholder="Brief description of expense" 
                           value="<?php echo htmlspecialchars($edit_expense['description'] ?? ''); ?>" required>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Paid To *</label>
                    <input type="text" name="paid_to" class="form-input" 
                           placeholder="Vendor/Supplier name" 
                           value="<?php echo htmlspecialchars($edit_expense['paid_to'] ?? ''); ?>" required>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Paid By *</label>
                    <select name="paid_by" class="form-select" required>
                        <option value="">Select User</option>
                        <?php foreach ($users as $user): ?>
                            <option value="<?php echo $user['id']; ?>" <?php echo ($edit_expense['paid_by'] ?? '') == $user['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($user['full_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Payment Method *</label>
                    <select name="paid_through" class="form-select" required>
                        <option value="">Select Method</option>
                        <option value="cash" <?php echo ($edit_expense['paid_through'] ?? '') == 'cash' ? 'selected' : ''; ?>>Cash</option>
                        <option value="upi" <?php echo ($edit_expense['paid_through'] ?? '') == 'upi' ? 'selected' : ''; ?>>UPI</option>
                        <option value="credit_card" <?php echo ($edit_expense['paid_through'] ?? '') == 'credit_card' ? 'selected' : ''; ?>>Credit Card</option>
                    </select>
                </div>
            </div>
            
            <div class="form-group">
                <label class="form-label">Notes</label>
                <textarea name="notes" class="form-textarea" rows="3" 
                          placeholder="Additional notes..."><?php echo htmlspecialchars($edit_expense['notes'] ?? ''); ?></textarea>
            </div>
            
            <div style="display: flex; gap: 1rem; flex-wrap: wrap;">
                <button type="submit" class="btn btn-primary"><?php echo $edit_expense ? 'Update Expense' : 'Add Expense'; ?></button>
                <?php if ($edit_expense): ?>
                    <a href="expenses.php" class="btn btn-secondary">Cancel</a>
                <?php endif; ?>
            </div>
        </form>
    <?php endif; ?>
</div>

<!-- Filters and Search -->
<div class="card">
    <div class="card-header">
        <h2 class="card-title">Filter & Export Expenses</h2>
    </div>
    
    <div style="display: grid; grid-template-columns: 1fr auto; gap: 2rem; align-items: start;">
        <!-- Filters Form -->
        <form method="GET">
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 1rem; margin-bottom: 1rem;">
                <div class="form-group">
                    <label class="form-label">Category</label>
                    <select name="filter_category" id="filter_category" class="form-select" onchange="updateFilterSubcategories()">
                        <option value="">All Categories</option>
                        <?php foreach ($categories as $category): ?>
                            <option value="<?php echo $category['id']; ?>" <?php echo $filter_category == $category['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($category['category_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Subcategory</label>
                    <select name="filter_subcategory" id="filter_subcategory" class="form-select">
                        <option value="">All Subcategories</option>
                        <?php foreach ($subcategories as $subcategory): ?>
                            <option value="<?php echo $subcategory['id']; ?>" 
                                    data-category="<?php echo $subcategory['category_id']; ?>"
                                    <?php echo $filter_subcategory == $subcategory['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($subcategory['subcategory_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">From Date</label>
                    <input type="date" name="filter_date_from" class="form-input" value="<?php echo htmlspecialchars($filter_date_from); ?>">
                </div>
                
                <div class="form-group">
                    <label class="form-label">To Date</label>
                    <input type="date" name="filter_date_to" class="form-input" value="<?php echo htmlspecialchars($filter_date_to); ?>">
                </div>
                
                <div class="form-group">
                    <label class="form-label">Paid By</label>
                    <select name="filter_paid_by" class="form-select">
                        <option value="">All Users</option>
                        <?php foreach ($users as $user): ?>
                            <option value="<?php echo $user['id']; ?>" <?php echo $filter_paid_by == $user['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($user['full_name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Payment Method</label>
                    <select name="filter_paid_through" class="form-select">
                        <option value="">All Methods</option>
                        <option value="cash" <?php echo $filter_paid_through == 'cash' ? 'selected' : ''; ?>>Cash</option>
                        <option value="upi" <?php echo $filter_paid_through == 'upi' ? 'selected' : ''; ?>>UPI</option>
                        <option value="credit_card" <?php echo $filter_paid_through == 'credit_card' ? 'selected' : ''; ?>>Credit Card</option>
                    </select>
                </div>
            </div>
            
            <div class="form-group">
                <label class="form-label">Search in Description/Paid To/Notes</label>
                <input type="text" name="filter_search" class="form-input" 
                       placeholder="Search..." value="<?php echo htmlspecialchars($filter_search); ?>">
            </div>
            
            <div style="display: flex; gap: 1rem; flex-wrap: wrap;">
                <button type="submit" class="btn btn-primary">Apply Filter</button>
                <a href="expenses.php" class="btn btn-secondary">Clear Filters</a>
            </div>
        </form>
        
        <!-- Export Form -->
        <div style="border-left: 2px solid #e0e0e0; padding-left: 1rem; min-width: 200px;">
            <div class="form-group">
                <label class="form-label">Export Options</label>
                
                <form method="POST">
                    <input type="hidden" name="action" value="export_expenses">
                    <input type="hidden" name="export_filter_category" value="<?php echo htmlspecialchars($filter_category); ?>">
                    <input type="hidden" name="export_filter_subcategory" value="<?php echo htmlspecialchars($filter_subcategory); ?>">
                    <input type="hidden" name="export_filter_date_from" value="<?php echo htmlspecialchars($filter_date_from); ?>">
                    <input type="hidden" name="export_filter_date_to" value="<?php echo htmlspecialchars($filter_date_to); ?>">
                    <input type="hidden" name="export_filter_paid_by" value="<?php echo htmlspecialchars($filter_paid_by); ?>">
                    <input type="hidden" name="export_filter_paid_through" value="<?php echo htmlspecialchars($filter_paid_through); ?>">
                    <input type="hidden" name="export_filter_search" value="<?php echo htmlspecialchars($filter_search); ?>">
                    
                    <button type="submit" class="btn btn-success" style="width: 100%;">
                        📊 Export to Excel
                    </button>
                </form>
            </div>
        </div>
    </div>
</div>

<!-- Expenses List -->
<div class="card">
    <div class="card-header">
        <h2 class="card-title">Expense Records</h2>
    </div>
    
    <?php if (empty($expenses)): ?>
        <div class="empty-state">
            <h3>No Expenses Found</h3>
            <p>Add your first expense using the form above.</p>
        </div>
    <?php else: ?>
        <div class="table-container">
            <table class="table">
                <thead>
                    <tr>
                        <th>Expense#</th>
                        <th>Date</th>
                        <th>Category</th>
                        <th>Description</th>
                        <th>Amount</th>
                        <th>Paid To</th>
                        <th>Paid By</th>
                        <th>Method</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($expenses as $expense): ?>
                        <tr>
                            <td><strong><?php echo htmlspecialchars($expense['expense_number']); ?></strong></td>
                            <td><?php echo date('M j, Y', strtotime($expense['expense_date'])); ?></td>
                            <td>
                                <?php echo htmlspecialchars($expense['category_name']); ?>
                                <?php if ($expense['subcategory_name'] != '-'): ?>
                                    <br><small style="color: #666;"><?php echo htmlspecialchars($expense['subcategory_name']); ?></small>
                                <?php endif; ?>
                            </td>
                            <td><?php echo htmlspecialchars($expense['description']); ?></td>
                            <td><strong>₹<?php echo number_format($expense['amount'], 2); ?></strong></td>
                            <td><?php echo htmlspecialchars($expense['paid_to']); ?></td>
                            <td><?php echo htmlspecialchars($expense['paid_by_name']); ?></td>
                            <td>
                                <?php 
                                $method_display = [
                                    'cash' => 'Cash',
                                    'upi' => 'UPI',
                                    'credit_card' => 'Credit Card'
                                ];
                                echo $method_display[$expense['paid_through']] ?? ucfirst($expense['paid_through']);
                                ?>
                            </td>
                            <td>
                                <div style="display: flex; gap: 0.5rem; flex-wrap: wrap; align-items: center;">
                                    <!-- Payment Slip Button -->
                                    <a href="payment_slip.php?expense_id=<?php echo $expense['id']; ?>" 
                                       class="btn btn-success" 
                                       style="padding: 0.3rem 0.6rem; font-size: 0.75rem; background: #4caf50;"
                                       target="_blank"
                                       title="Download Payment Slip">
                                        📄 Slip
                                    </a>
                                    
                                    <a href="expenses.php?edit_expense=<?php echo $expense['id']; ?>" 
                                       class="btn btn-secondary" 
                                       style="padding: 0.3rem 0.6rem; font-size: 0.75rem;">
                                        Edit
                                    </a>
                                    
                                    <form method="POST" style="display: inline;" onsubmit="return confirm('Delete this expense?');">
                                        <input type="hidden" name="action" value="delete_expense">
                                        <input type="hidden" name="expense_id" value="<?php echo $expense['id']; ?>">
                                        <button type="submit" 
                                                class="btn btn-danger" 
                                                style="padding: 0.3rem 0.6rem; font-size: 0.75rem;">
                                            Delete
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                        <?php if ($expense['notes']): ?>
                            <tr>
                                <td colspan="9" style="background: #f9f9f9; padding: 0.5rem 1rem; font-style: italic;">
                                    <strong>Notes:</strong> <?php echo htmlspecialchars($expense['notes']); ?>
                                </td>
                            </tr>
                        <?php endif; ?>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    <?php endif; ?>
</div>

<script>
// Store subcategories data from PHP
const subcategoriesData = <?php echo json_encode($subcategories); ?>;

// Subcategory filtering for form
function updateSubcategories() {
    const categorySelect = document.getElementById('category_id');
    const subcategorySelect = document.getElementById('subcategory_id');
    const selectedCategory = categorySelect.value;
    
    // Store current selection
    const currentSubcategory = subcategorySelect.value;
    
    // Reset subcategory dropdown
    subcategorySelect.innerHTML = '<option value="">Select Subcategory (Optional)</option>';
    
    if (selectedCategory) {
        // Filter and add subcategories for selected category
        subcategoriesData.forEach(subcategory => {
            if (subcategory.category_id == selectedCategory) {
                const option = document.createElement('option');
                option.value = subcategory.id;
                option.textContent = subcategory.subcategory_name;
                option.setAttribute('data-category', subcategory.category_id);
                
                // Restore selection if it was previously selected
                if (subcategory.id == currentSubcategory) {
                    option.selected = true;
                }
                
                subcategorySelect.appendChild(option);
            }
        });
    }
}

// Subcategory filtering for filters
function updateFilterSubcategories() {
    const categorySelect = document.getElementById('filter_category');
    const subcategorySelect = document.getElementById('filter_subcategory');
    const selectedCategory = categorySelect.value;
    
    // Store current selection
    const currentSubcategory = subcategorySelect.value;
    
    // Reset subcategory dropdown
    subcategorySelect.innerHTML = '<option value="">All Subcategories</option>';
    
    if (selectedCategory) {
        // Filter and add subcategories for selected category
        subcategoriesData.forEach(subcategory => {
            if (subcategory.category_id == selectedCategory) {
                const option = document.createElement('option');
                option.value = subcategory.id;
                option.textContent = subcategory.subcategory_name;
                option.setAttribute('data-category', subcategory.category_id);
                
                // Restore selection if it was previously selected
                if (subcategory.id == currentSubcategory) {
                    option.selected = true;
                }
                
                subcategorySelect.appendChild(option);
            }
        });
    }
}

// Initialize subcategory dropdowns on page load
document.addEventListener('DOMContentLoaded', function() {
    // Initial load for form subcategories
    updateSubcategories();
    
    // Initial load for filter subcategories  
    updateFilterSubcategories();
    
    // Add event listeners
    const categorySelect = document.getElementById('category_id');
    if (categorySelect) {
        categorySelect.addEventListener('change', updateSubcategories);
    }
    
    const filterCategorySelect = document.getElementById('filter_category');
    if (filterCategorySelect) {
        filterCategorySelect.addEventListener('change', updateFilterSubcategories);
    }
});
</script>

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