<?php
/**
 * Expenses Management Page for Kayal Aqua
 * Record and manage business expenses
 */

require_once '../config/config.php';
require_once '../includes/functions.php';

// Check permissions
if (!hasPermission('manage_expenses') && !hasPermission('add_expenses')) {
    redirect('../index.php');
}

$pageTitle = 'Expense Management';
$breadcrumb = [
    ['title' => 'Expense Management']
];

$success = '';
$error = '';
$currentUser = getCurrentUser();

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        $action = $_POST['action'] ?? '';
        
        switch ($action) {
            case 'add_expense':
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $categoryId = !empty($_POST['category_id']) ? (int)$_POST['category_id'] : null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $expenseDate = $_POST['expense_date'];
                $description = sanitizeInput($_POST['description'] ?? '');
                $paymentMethod = sanitizeInput($_POST['payment_method'] ?? '');
                $vendor = sanitizeInput($_POST['vendor'] ?? '');
                
                // Validation
                if (empty($title) || $amount <= 0 || empty($expenseDate)) {
                    throw new Exception('Title, amount, and expense date are required.');
                }
                
                // Handle receipt image upload
                $receiptImage = null;
                if (isset($_FILES['receipt_image']) && $_FILES['receipt_image']['error'] === UPLOAD_ERR_OK) {
                    try {
                        $receiptImage = handleFileUpload('receipt_image', '../uploads/receipts/');
                    } catch (Exception $e) {
                        // Log error but don't fail the transaction
                        error_log("Receipt upload failed: " . $e->getMessage());
                    }
                }
                
                $expenseData = [
                    'title' => $title,
                    'amount' => $amount,
                    'category_id' => $categoryId,
                    'segment_id' => $segmentId,
                    'expense_date' => $expenseDate,
                    'description' => $description,
                    'payment_method' => $paymentMethod,
                    'vendor' => $vendor,
                    'receipt_image' => $receiptImage,
                    'created_by' => $currentUser['id'],
                    'created_at' => date('Y-m-d H:i:s')
                ];
                
                $expenseId = insertData('expenses', $expenseData);
                
                if ($expenseId) {
                    logSystemActivity('Add Expense', "Added expense: {$title} - " . formatIndianCurrency($amount));
                    $success = 'Expense recorded successfully!';
                } else {
                    throw new Exception('Failed to record expense.');
                }
                break;
                
            case 'update_expense':
                $expenseId = (int)$_POST['expense_id'];
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $categoryId = !empty($_POST['category_id']) ? (int)$_POST['category_id'] : null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $expenseDate = $_POST['expense_date'];
                $description = sanitizeInput($_POST['description'] ?? '');
                $paymentMethod = sanitizeInput($_POST['payment_method'] ?? '');
                $vendor = sanitizeInput($_POST['vendor'] ?? '');
                
                // Validation
                if (empty($title) || $amount <= 0 || empty($expenseDate)) {
                    throw new Exception('Title, amount, and expense date are required.');
                }
                
                // Check if user can edit this expense
                $existingExpense = fetchRow("SELECT * FROM expenses WHERE id = ?", [$expenseId]);
                if (!$existingExpense) {
                    throw new Exception('Expense not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingExpense['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only edit your own expense records.');
                }
                
                $updateData = [
                    'title' => $title,
                    'amount' => $amount,
                    'category_id' => $categoryId,
                    'segment_id' => $segmentId,
                    'expense_date' => $expenseDate,
                    'description' => $description,
                    'payment_method' => $paymentMethod,
                    'vendor' => $vendor
                ];
                
                updateData('expenses', $updateData, 'id = ?', [$expenseId]);
                
                logSystemActivity('Update Expense', "Updated expense ID: {$expenseId}");
                $success = 'Expense updated successfully!';
                break;
                
            case 'delete_expense':
                $expenseId = (int)$_POST['expense_id'];
                
                // Check if user can delete this expense
                $existingExpense = fetchRow("SELECT * FROM expenses WHERE id = ?", [$expenseId]);
                if (!$existingExpense) {
                    throw new Exception('Expense not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingExpense['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only delete your own expense records.');
                }
                
                // Delete associated receipt image
                if ($existingExpense['receipt_image'] && file_exists('../' . $existingExpense['receipt_image'])) {
                    unlink('../' . $existingExpense['receipt_image']);
                }
                
                executeQuery("DELETE FROM expenses WHERE id = ?", [$expenseId]);
                
                logSystemActivity('Delete Expense', "Deleted expense: {$existingExpense['title']}");
                $success = 'Expense deleted successfully!';
                break;
        }
    } catch (Exception $e) {
        $error = $e->getMessage();
    }
}

// Get filter parameters
$dateFrom = $_GET['date_from'] ?? date('Y-m-01'); // First day of current month
$dateTo = $_GET['date_to'] ?? date('Y-m-d'); // Today
$segmentFilter = $_GET['segment'] ?? '';
$categoryFilter = $_GET['category'] ?? '';
$search = $_GET['search'] ?? '';

// Build query for expenses list
$whereConditions = [];
$params = [];

// Date range filter
if ($dateFrom) {
    $whereConditions[] = "e.expense_date >= ?";
    $params[] = $dateFrom;
}
if ($dateTo) {
    $whereConditions[] = "e.expense_date <= ?";
    $params[] = $dateTo;
}

// Segment filter
if ($segmentFilter) {
    $whereConditions[] = "e.segment_id = ?";
    $params[] = $segmentFilter;
}

// Category filter
if ($categoryFilter) {
    $whereConditions[] = "e.category_id = ?";
    $params[] = $categoryFilter;
}

// Search filter
if ($search) {
    $whereConditions[] = "(e.title LIKE ? OR e.vendor LIKE ? OR e.description LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

// User-specific filter for non-admin users
if ($currentUser['role'] !== 'admin' && !hasPermission('manage_expenses')) {
    $whereConditions[] = "e.created_by = ?";
    $params[] = $currentUser['id'];
}

$whereClause = !empty($whereConditions) ? 'WHERE ' . implode(' AND ', $whereConditions) : '';

// Get expenses with related data
$expensesQuery = "
    SELECT e.*, 
           bs.name as segment_name,
           c.name as category_name,
           u.full_name as created_by_name
    FROM expenses e
    LEFT JOIN business_segments bs ON e.segment_id = bs.id
    LEFT JOIN categories c ON e.category_id = c.id
    LEFT JOIN users u ON e.created_by = u.id
    {$whereClause}
    ORDER BY e.expense_date DESC, e.created_at DESC
    LIMIT 100
";

$expenses = fetchAll($expensesQuery, $params);

// Calculate totals for the filtered data
$totalQuery = "
    SELECT 
        COUNT(*) as total_count,
        SUM(amount) as total_amount,
        AVG(amount) as avg_amount
    FROM expenses e
    {$whereClause}
";
$totals = fetchRow($totalQuery, $params);

// Get expense breakdown by category
$categoryBreakdown = fetchAll("
    SELECT 
        c.name as category_name,
        SUM(e.amount) as total_amount,
        COUNT(e.id) as count
    FROM expenses e
    LEFT JOIN categories c ON e.category_id = c.id
    {$whereClause}
    GROUP BY e.category_id, c.name
    ORDER BY total_amount DESC
    LIMIT 10
", $params);

// Get data for dropdowns
$businessSegments = getBusinessSegments();
$expenseCategories = getCategories('expense');

include '../includes/header.php';
?>

<div class="expenses-container">
    <!-- Page Header -->
    <div class="page-header mb-4">
        <div class="d-flex justify-content-between align-items-center">
            <div>
                <h1 class="page-title">
                    <i class="fas fa-receipt"></i>
                    Expense Management
                </h1>
                <p class="page-description">
                    Track and manage your business expenses and costs.
                </p>
            </div>
            <div class="page-actions">
                <button class="btn btn-primary" onclick="showAddExpenseModal()">
                    <i class="fas fa-plus"></i>
                    <span class="desktop-only">Add Expense</span>
                </button>
            </div>
        </div>
    </div>

    <!-- Success/Error Messages -->
    <?php if ($success): ?>
        <div class="alert alert-success alert-dismissible">
            <i class="fas fa-check-circle"></i>
            <?php echo htmlspecialchars($success); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <?php if ($error): ?>
        <div class="alert alert-danger alert-dismissible">
            <i class="fas fa-exclamation-circle"></i>
            <?php echo htmlspecialchars($error); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <!-- Expense Statistics -->
    <div class="stats-section mb-4">
        <div class="row">
            <div class="col-lg-8">
                <div class="row">
                    <div class="col-md-4 mb-3">
                        <div class="stat-card">
                            <div class="stat-icon bg-danger">
                                <i class="fas fa-chart-line-down"></i>
                            </div>
                            <div class="stat-content">
                                <div class="stat-value"><?php echo formatIndianCurrency($totals['total_amount'] ?? 0); ?></div>
                                <div class="stat-label">Total Expenses</div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4 mb-3">
                        <div class="stat-card">
                            <div class="stat-icon bg-primary">
                                <i class="fas fa-receipt"></i>
                            </div>
                            <div class="stat-content">
                                <div class="stat-value"><?php echo number_format($totals['total_count'] ?? 0); ?></div>
                                <div class="stat-label">Transactions</div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4 mb-3">
                        <div class="stat-card">
                            <div class="stat-icon bg-info">
                                <i class="fas fa-calculator"></i>
                            </div>
                            <div class="stat-content">
                                <div class="stat-value"><?php echo formatIndianCurrency($totals['avg_amount'] ?? 0); ?></div>
                                <div class="stat-label">Average Expense</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-4 mb-3">
                <div class="card">
                    <div class="card-header">
                        <h6 class="card-title">
                            <i class="fas fa-chart-pie"></i>
                            Top Categories
                        </h6>
                    </div>
                    <div class="card-body">
                        <?php if (empty($categoryBreakdown)): ?>
                            <p class="text-muted text-center">No data available</p>
                        <?php else: ?>
                            <div class="category-breakdown">
                                <?php foreach (array_slice($categoryBreakdown, 0, 5) as $category): ?>
                                    <div class="category-item">
                                        <div class="category-info">
                                            <div class="category-name"><?php echo htmlspecialchars($category['category_name'] ?: 'Uncategorized'); ?></div>
                                            <div class="category-amount"><?php echo formatIndianCurrency($category['total_amount']); ?></div>
                                        </div>
                                        <div class="category-progress">
                                            <?php 
                                            $percentage = $totals['total_amount'] > 0 ? ($category['total_amount'] / $totals['total_amount']) * 100 : 0;
                                            ?>
                                            <div class="progress">
                                                <div class="progress-bar bg-danger" style="width: <?php echo min($percentage, 100); ?>%"></div>
                                            </div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="card filters-card mb-4">
        <div class="card-body">
            <form method="GET" class="filters-form">
                <div class="row">
                    <div class="col-md-3 mb-3">
                        <label for="date_from" class="form-label">From Date</label>
                        <input type="date" id="date_from" name="date_from" class="form-control" 
                               value="<?php echo htmlspecialchars($dateFrom); ?>">
                    </div>
                    <div class="col-md-3 mb-3">
                        <label for="date_to" class="form-label">To Date</label>
                        <input type="date" id="date_to" name="date_to" class="form-control" 
                               value="<?php echo htmlspecialchars($dateTo); ?>">
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="segment" class="form-label">Segment</label>
                        <select id="segment" name="segment" class="form-control">
                            <option value="">All Segments</option>
                            <?php foreach ($businessSegments as $segment): ?>
                                <option value="<?php echo $segment['id']; ?>" 
                                        <?php echo $segmentFilter == $segment['id'] ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($segment['name']); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="category" class="form-label">Category</label>
                        <select id="category" name="category" class="form-control">
                            <option value="">All Categories</option>
                            <?php foreach ($expenseCategories as $category): ?>
                                <option value="<?php echo $category['id']; ?>" 
                                        <?php echo $categoryFilter == $category['id'] ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($category['name']); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="search" class="form-label">Search</label>
                        <input type="text" id="search" name="search" class="form-control" 
                               placeholder="Title, vendor..." value="<?php echo htmlspecialchars($search); ?>">
                    </div>
                </div>
                <div class="filter-actions">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-filter"></i> Apply Filters
                    </button>
                    <a href="expenses.php" class="btn btn-outline">
                        <i class="fas fa-times"></i> Clear
                    </a>
                    <button type="button" class="btn btn-success" onclick="exportExpenses()">
                        <i class="fas fa-download"></i> Export
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Expenses List -->
    <div class="card">
        <div class="card-header">
            <h5 class="card-title">
                <i class="fas fa-list"></i>
                Expense Records
            </h5>
            <div class="card-subtitle">
                Showing <?php echo count($expenses); ?> of <?php echo $totals['total_count']; ?> expenses
            </div>
        </div>
        <div class="card-body">
            <?php if (empty($expenses)): ?>
                <div class="empty-state text-center py-5">
                    <i class="fas fa-receipt fa-4x text-muted mb-3"></i>
                    <h5>No Expenses Found</h5>
                    <p class="text-muted">
                        <?php if ($search || $segmentFilter || $categoryFilter): ?>
                            Try adjusting your filters or search criteria.
                        <?php else: ?>
                            Start by recording your first expense.
                        <?php endif; ?>
                    </p>
                    <button class="btn btn-primary" onclick="showAddExpenseModal()">
                        <i class="fas fa-plus"></i> Add First Expense
                    </button>
                </div>
            <?php else: ?>
                <div class="table-responsive">
                    <table class="table table-hover" id="expensesTable">
                        <thead>
                            <tr>
                                <th>Description</th>
                                <th>Vendor</th>
                                <th class="desktop-only">Category</th>
                                <th>Amount</th>
                                <th class="desktop-only">Payment</th>
                                <th>Date</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($expenses as $expense): ?>
                                <tr data-expense-id="<?php echo $expense['id']; ?>">
                                    <td>
                                        <div class="expense-info">
                                            <div class="expense-title"><?php echo htmlspecialchars($expense['title']); ?></div>
                                            <div class="expense-meta">
                                                <?php if ($expense['segment_name']): ?>
                                                    <span class="segment-badge">
                                                        <?php echo htmlspecialchars($expense['segment_name']); ?>
                                                    </span>
                                                <?php endif; ?>
                                                <?php if ($expense['receipt_image']): ?>
                                                    <span class="receipt-indicator">
                                                        <i class="fas fa-paperclip"></i>
                                                    </span>
                                                <?php endif; ?>
                                            </div>
                                            <div class="mobile-only expense-details-mobile">
                                                <small class="text-muted">
                                                    <?php if ($expense['category_name']): ?>
                                                        <?php echo htmlspecialchars($expense['category_name']); ?>
                                                    <?php endif; ?>
                                                    <?php if ($expense['payment_method']): ?>
                                                        • <?php echo ucfirst($expense['payment_method']); ?>
                                                    <?php endif; ?>
                                                </small>
                                            </div>
                                        </div>
                                    </td>
                                    <td>
                                        <div class="vendor-info">
                                            <?php if ($expense['vendor']): ?>
                                                <div class="vendor-name"><?php echo htmlspecialchars($expense['vendor']); ?></div>
                                            <?php else: ?>
                                                <div class="text-muted">Not specified</div>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                    <td class="desktop-only">
                                        <?php if ($expense['category_name']): ?>
                                            <span class="badge badge-warning">
                                                <?php echo htmlspecialchars($expense['category_name']); ?>
                                            </span>
                                        <?php else: ?>
                                            <span class="text-muted">-</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <div class="amount-info">
                                            <div class="expense-amount"><?php echo formatIndianCurrency($expense['amount']); ?></div>
                                        </div>
                                    </td>
                                    <td class="desktop-only">
                                        <?php if ($expense['payment_method']): ?>
                                            <span class="payment-method">
                                                <i class="fas fa-<?php echo $expense['payment_method'] === 'cash' ? 'money-bill' : 'credit-card'; ?>"></i>
                                                <?php echo ucfirst($expense['payment_method']); ?>
                                            </span>
                                        <?php else: ?>
                                            <span class="text-muted">-</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <div class="date-info">
                                            <div class="expense-date"><?php echo formatDate($expense['expense_date'], 'd M'); ?></div>
                                            <small class="created-time"><?php echo date('g:i A', strtotime($expense['created_at'])); ?></small>
                                        </div>
                                    </td>
                                    <td>
                                        <div class="action-buttons">
                                            <button class="btn btn-sm btn-outline" 
                                                    onclick="viewExpense(<?php echo htmlspecialchars(json_encode($expense)); ?>)"
                                                    title="View Details">
                                                <i class="fas fa-eye"></i>
                                            </button>
                                            <?php if ($currentUser['role'] === 'admin' || $expense['created_by'] == $currentUser['id']): ?>
                                                <button class="btn btn-sm btn-outline" 
                                                        onclick="editExpense(<?php echo htmlspecialchars(json_encode($expense)); ?>)"
                                                        title="Edit Expense">
                                                    <i class="fas fa-edit"></i>
                                                </button>
                                                <button class="btn btn-sm btn-outline text-danger" 
                                                        onclick="deleteExpense(<?php echo $expense['id']; ?>, '<?php echo htmlspecialchars($expense['title']); ?>')"
                                                        title="Delete Expense">
                                                    <i class="fas fa-trash"></i>
                                                </button>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<!-- Add Expense Modal -->
<div class="modal" id="addExpenseModal">
    <div class="modal-content modal-lg">
        <div class="modal-header">
            <h3 class="modal-title">Add New Expense</h3>
            <button class="modal-close" onclick="closeModal('addExpenseModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="addExpenseForm" method="POST" enctype="multipart/form-data" data-validate>
                <input type="hidden" name="action" value="add_expense">
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="form-group">
                            <label for="add_title" class="form-label">Expense Description <span class="text-danger">*</span></label>
                            <input type="text" id="add_title" name="title" class="form-control" required 
                                   placeholder="e.g., Fish purchase from vendor">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="add_expense_date" class="form-label">Expense Date <span class="text-danger">*</span></label>
                            <input type="date" id="add_expense_date" name="expense_date" class="form-control" 
                                   value="<?php echo date('Y-m-d'); ?>" required>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_amount" class="form-label">Amount <span class="text-danger">*</span></label>
                            <input type="number" id="add_amount" name="amount" class="form-control" 
                                   step="0.01" min="0" required>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_payment_method" class="form-label">Payment Method</label>
                            <select id="add_payment_method" name="payment_method" class="form-control">
                                <option value="">Select Method</option>
                                <option value="cash">Cash</option>
                                <option value="card">Card</option>
                                <option value="bank_transfer">Bank Transfer</option>
                                <option value="upi">UPI</option>
                                <option value="cheque">Cheque</option>
                                <option value="other">Other</option>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_segment_id" class="form-label">Business Segment</label>
                            <select id="add_segment_id" name="segment_id" class="form-control">
                                <option value="">Select Segment</option>
                                <?php foreach ($businessSegments as $segment): ?>
                                    <option value="<?php echo $segment['id']; ?>">
                                        <?php echo htmlspecialchars($segment['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_category_id" class="form-label">Category</label>
                            <select id="add_category_id" name="category_id" class="form-control">
                                <option value="">Select Category</option>
                                <?php foreach ($expenseCategories as $category): ?>
                                    <option value="<?php echo $category['id']; ?>">
                                        <?php echo htmlspecialchars($category['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="form-group">
                    <label for="add_vendor" class="form-label">Vendor/Supplier</label>
                    <input type="text" id="add_vendor" name="vendor" class="form-control" 
                           placeholder="e.g., ABC Fish Suppliers">
                </div>

                <div class="form-group">
                    <label for="add_description" class="form-label">Additional Notes</label>
                    <textarea id="add_description" name="description" class="form-control" rows="3"></textarea>
                </div>

                <div class="form-group">
                    <label for="add_receipt_image" class="form-label">Receipt/Bill Image (Optional)</label>
                    <input type="file" id="add_receipt_image" name="receipt_image" class="form-control" 
                           accept="image/*,.pdf">
                    <small class="text-muted">Max 5MB. Supported formats: JPG, PNG, PDF</small>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('addExpenseModal')">Cancel</button>
            <button type="submit" form="addExpenseForm" class="btn btn-primary">
                <i class="fas fa-save"></i> Record Expense
            </button>
        </div>
    </div>
</div>

<!-- Edit Expense Modal -->
<div class="modal" id="editExpenseModal">
    <div class="modal-content modal-lg">
        <div class="modal-header">
            <h3 class="modal-title">Edit Expense</h3>
            <button class="modal-close" onclick="closeModal('editExpenseModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="editExpenseForm" method="POST" data-validate>
                <input type="hidden" name="action" value="update_expense">
                <input type="hidden" name="expense_id" id="edit_expense_id">
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="form-group">
                            <label for="edit_title" class="form-label">Expense Description <span class="text-danger">*</span></label>
                            <input type="text" id="edit_title" name="title" class="form-control" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="edit_expense_date" class="form-label">Expense Date <span class="text-danger">*</span></label>
                            <input type="date" id="edit_expense_date" name="expense_date" class="form-control" required>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_amount" class="form-label">Amount <span class="text-danger">*</span></label>
                            <input type="number" id="edit_amount" name="amount" class="form-control" 
                                   step="0.01" min="0" required>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_payment_method" class="form-label">Payment Method</label>
                            <select id="edit_payment_method" name="payment_method" class="form-control">
                                <option value="">Select Method</option>
                                <option value="cash">Cash</option>
                                <option value="card">Card</option>
                                <option value="bank_transfer">Bank Transfer</option>
                                <option value="upi">UPI</option>
                                <option value="cheque">Cheque</option>
                                <option value="other">Other</option>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_segment_id" class="form-label">Business Segment</label>
                            <select id="edit_segment_id" name="segment_id" class="form-control">
                                <option value="">Select Segment</option>
                                <?php foreach ($businessSegments as $segment): ?>
                                    <option value="<?php echo $segment['id']; ?>">
                                        <?php echo htmlspecialchars($segment['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_category_id" class="form-label">Category</label>
                            <select id="edit_category_id" name="category_id" class="form-control">
                                <option value="">Select Category</option>
                                <?php foreach ($expenseCategories as $category): ?>
                                    <option value="<?php echo $category['id']; ?>">
                                        <?php echo htmlspecialchars($category['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="form-group">
                    <label for="edit_vendor" class="form-label">Vendor/Supplier</label>
                    <input type="text" id="edit_vendor" name="vendor" class="form-control">
                </div>

                <div class="form-group">
                    <label for="edit_description" class="form-label">Additional Notes</label>
                    <textarea id="edit_description" name="description" class="form-control" rows="3"></textarea>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('editExpenseModal')">Cancel</button>
            <button type="submit" form="editExpenseForm" class="btn btn-primary">
                <i class="fas fa-save"></i> Update Expense
            </button>
        </div>
    </div>
</div>

<!-- View Expense Modal -->
<div class="modal" id="viewExpenseModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3 class="modal-title">Expense Details</h3>
            <button class="modal-close" onclick="closeModal('viewExpenseModal')">&times;</button>
        </div>
        <div class="modal-body">
            <div id="expenseDetailsContent">
                <!-- Content will be populated by JavaScript -->
            </div>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('viewExpenseModal')">Close</button>
        </div>
    </div>
</div>

<script>
// Expense management functions
function showAddExpenseModal() {
    document.getElementById('addExpenseForm').reset();
    document.getElementById('add_expense_date').value = new Date().toISOString().split('T')[0];
    openModal('addExpenseModal');
}

function editExpense(expense) {
    document.getElementById('edit_expense_id').value = expense.id;
    document.getElementById('edit_title').value = expense.title;
    document.getElementById('edit_amount').value = expense.amount;
    document.getElementById('edit_expense_date').value = expense.expense_date;
    document.getElementById('edit_segment_id').value = expense.segment_id || '';
    document.getElementById('edit_category_id').value = expense.category_id || '';
    document.getElementById('edit_vendor').value = expense.vendor || '';
    document.getElementById('edit_payment_method').value = expense.payment_method || '';
    document.getElementById('edit_description').value = expense.description || '';
    
    openModal('editExpenseModal');
}

function viewExpense(expense) {
    const content = `
        <div class="expense-details">
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Expense Date:</strong><br>
                    ${formatDate(expense.expense_date)}
                </div>
                <div class="col-6">
                    <strong>Amount:</strong><br>
                    <span class="amount-large text-danger">${formatCurrency(expense.amount)}</span>
                </div>
            </div>
            
            <div class="row mb-3">
                <div class="col-12">
                    <strong>Description:</strong><br>
                    <span class="expense-title-large">${expense.title}</span>
                </div>
            </div>
            
            ${expense.vendor ? `
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Vendor:</strong><br>
                    ${expense.vendor}
                </div>
                <div class="col-6">
                    <strong>Payment Method:</strong><br>
                    ${expense.payment_method ? expense.payment_method.charAt(0).toUpperCase() + expense.payment_method.slice(1) : 'Not specified'}
                </div>
            </div>
            ` : ''}
            
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Segment:</strong><br>
                    ${expense.segment_name || 'Not specified'}
                </div>
                <div class="col-6">
                    <strong>Category:</strong><br>
                    ${expense.category_name || 'Not specified'}
                </div>
            </div>
            
            ${expense.description ? `
            <div class="row mb-3">
                <div class="col-12">
                    <strong>Additional Notes:</strong><br>
                    ${expense.description}
                </div>
            </div>
            ` : ''}
            
            ${expense.receipt_image ? `
            <div class="row mb-3">
                <div class="col-12">
                    <strong>Receipt/Bill:</strong><br>
                    <a href="../${expense.receipt_image}" target="_blank" class="btn btn-sm btn-outline">
                        <i class="fas fa-paperclip"></i> View Receipt
                    </a>
                </div>
            </div>
            ` : ''}
            
            <div class="row">
                <div class="col-12">
                    <strong>Created:</strong><br>
                    ${formatDateTime(expense.created_at)} by ${expense.created_by_name}
                </div>
            </div>
        </div>
    `;
    
    document.getElementById('expenseDetailsContent').innerHTML = content;
    openModal('viewExpenseModal');
}

function deleteExpense(expenseId, title) {
    if (confirm(`Are you sure you want to delete the expense "${title}"?\n\nThis action cannot be undone.`)) {
        const form = document.createElement('form');
        form.method = 'POST';
        form.style.display = 'none';
        
        const actionInput = document.createElement('input');
        actionInput.type = 'hidden';
        actionInput.name = 'action';
        actionInput.value = 'delete_expense';
        
        const expenseIdInput = document.createElement('input');
        expenseIdInput.type = 'hidden';
        expenseIdInput.name = 'expense_id';
        expenseIdInput.value = expenseId;
        
        form.appendChild(actionInput);
        form.appendChild(expenseIdInput);
        document.body.appendChild(form);
        form.submit();
    }
}

function exportExpenses() {
    const params = new URLSearchParams(window.location.search);
    params.set('export', 'csv');
    
    window.location.href = 'export_expenses.php?' + params.toString();
}

function openModal(modalId) {
    document.getElementById(modalId).classList.add('active');
    document.body.style.overflow = 'hidden';
}

function closeModal(modalId) {
    document.getElementById(modalId).classList.remove('active');
    document.body.style.overflow = '';
}

// Utility functions
function formatDate(dateString) {
    return new Date(dateString).toLocaleDateString('en-IN', {
        year: 'numeric',
        month: 'short',
        day: 'numeric'
    });
}

function formatDateTime(dateString) {
    return new Date(dateString).toLocaleDateString('en-IN', {
        year: 'numeric',
        month: 'short',
        day: 'numeric',
        hour: 'numeric',
        minute: '2-digit'
    });
}

function formatCurrency(amount) {
    return new Intl.NumberFormat('en-IN', {
        style: 'currency',
        currency: 'INR',
        minimumFractionDigits: 2
    }).format(amount);
}
</script>

<style>
/* Expenses page specific styles */
.expenses-container {
    animation: fadeIn 0.6s ease;
}

.expense-info {
    min-width: 0;
}

.expense-title {
    font-weight: 600;
    color: var(--primary-navy);
    margin-bottom: var(--space-xs);
}

.expense-meta {
    display: flex;
    gap: var(--space-sm);
    align-items: center;
    flex-wrap: wrap;
    margin-bottom: var(--space-xs);
}

.segment-badge {
    font-size: var(--font-size-xs);
    background: var(--primary-yellow);
    color: var(--primary-navy);
    padding: 2px 6px;
    border-radius: 3px;
    font-weight: 500;
}

.receipt-indicator {
    color: var(--success);
    font-size: var(--font-size-xs);
}

.vendor-info {
    min-width: 0;
}

.vendor-name {
    font-weight: 500;
    color: var(--primary-navy);
}

.expense-amount {
    font-weight: 600;
    color: var(--danger);
    font-size: var(--font-size-lg);
}

.payment-method {
    font-size: var(--font-size-sm);
    color: var(--gray);
    display: flex;
    align-items: center;
    gap: var(--space-xs);
}

.category-breakdown {
    max-height: 200px;
    overflow-y: auto;
}

.category-item {
    padding: var(--space-sm) 0;
    border-bottom: 1px solid var(--light-gray);
}

.category-item:last-child {
    border-bottom: none;
}

.category-info {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: var(--space-xs);
}

.category-name {
    font-size: var(--font-size-sm);
    color: var(--primary-navy);
    font-weight: 500;
}

.category-amount {
    font-size: var(--font-size-sm);
    color: var(--danger);
    font-weight: 600;
}

.category-progress .progress {
    height: 4px;
    background: var(--light-gray);
}

.filters-form {
    margin: 0;
}

.filter-actions {
    display: flex;
    gap: var(--space-sm);
    flex-wrap: wrap;
    align-items: center;
}

.expense-details {
    background: var(--light-gray);
    padding: var(--space-lg);
    border-radius: var(--border-radius);
}

.expense-title-large {
    font-size: var(--font-size-lg);
    font-weight: 600;
    color: var(--primary-navy);
}

@media (max-width: 768px) {
    .filter-actions {
        margin-top: var(--space-md);
    }
    
    .filter-actions .btn {
        flex: 1;
        min-width: 120px;
    }
    
    .expense-details {
        padding: var(--space-md);
    }
}
</style>

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