@extends('layouts.master')

@section('page_title', 'Expenditure Report')

@section('content')
<div class="container-fluid">
    <!-- Filter Section -->
    <div class="card mb-4 no-print">
        <div class="card-header">
            <h5 class="mb-0">Expenditure Report Filters</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('reports.expenditure') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="start_date" class="form-label">Start Date</label>
                    <input type="date" class="form-control" id="start_date" name="start_date" 
                           value="{{ $startDate }}" required>
                </div>
                <div class="col-md-3">
                    <label for="end_date" class="form-label">End Date</label>
                    <input type="date" class="form-control" id="end_date" name="end_date" 
                           value="{{ $endDate }}" required>
                </div>
                <div class="col-md-3">
                    <label for="category_id" class="form-label">Category</label>
                    <select class="form-select" id="category_id" name="category_id">
                        <option value="">All Categories</option>
                        @foreach($categories as $category)
                            <option value="{{ $category->id }}" {{ $categoryId == $category->id ? 'selected' : '' }}>
                                {{ $category->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end gap-2">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search"></i> Generate Report
                    </button>
                    <button type="button" class="btn btn-success" onclick="window.print()">
                        <i class="fas fa-print"></i> Print
                    </button>
                    <button type="button" class="btn btn-info" onclick="exportToCSV()">
                        <i class="fas fa-download"></i> Export CSV
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2>Expenditure Report</h2>
            <p class="text-muted mb-0">Period: {{ Carbon\Carbon::parse($startDate)->format('M d, Y') }} - {{ Carbon\Carbon::parse($endDate)->format('M d, Y') }}</p>
        </div>
        <div class="text-end">
            <p class="mb-0"><strong>Generated:</strong> {{ Carbon\Carbon::now()->format('M d, Y g:i A') }}</p>
            <p class="mb-0"><strong>Total Transactions:</strong> {{ $expenditures->count() }}</p>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card bg-danger text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ \App\Helpers\Mk::formatCurrency($expenditures->sum('amount')) }}</h3>
                            <p class="mb-0">Total Expenditure</p>
                        </div>
                        <div>
                            <i class="fas fa-money-bill-wave fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-warning text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ \App\Helpers\Mk::formatCurrency($expenditures->avg('amount')) }}</h3>
                            <p class="mb-0">Average Transaction</p>
                        </div>
                        <div>
                            <i class="fas fa-chart-line fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-info text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ $expenditures->groupBy('category_name')->count() }}</h3>
                            <p class="mb-0">Categories Used</p>
                        </div>
                        <div>
                            <i class="fas fa-tags fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-secondary text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ \App\Helpers\Mk::formatCurrency($expenditures->max('amount')) }}</h3>
                            <p class="mb-0">Largest Transaction</p>
                        </div>
                        <div>
                            <i class="fas fa-arrow-up fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Category Summary -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Expenditure by Category</h5>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-8">
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>Category</th>
                                    <th class="text-center">Transactions</th>
                                    <th class="text-end">Total Amount</th>
                                    <th class="text-end">Average</th>
                                    <th class="text-end">Percentage</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $totalExpenditure = $expenditures->sum('amount'); @endphp
                                @foreach($categorySummary as $summary)
                                @php 
                                    $percentage = $totalExpenditure > 0 ? ($summary->total_amount / $totalExpenditure) * 100 : 0;
                                @endphp
                                <tr>
                                    <td><strong>{{ $summary->category_name }}</strong></td>
                                    <td class="text-center">{{ $summary->transaction_count }}</td>
                                    <td class="text-end">${{ number_format($summary->total_amount, 2) }}</td>
                                    <td class="text-end">${{ number_format($summary->avg_amount, 2) }}</td>
                                    <td class="text-end">{{ number_format($percentage, 1) }}%</td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="table-primary">
                                    <th>Total</th>
                                    <th class="text-center">{{ $expenditures->count() }}</th>
                                    <th class="text-end">${{ number_format($totalExpenditure, 2) }}</th>
                                    <th class="text-end">${{ number_format($expenditures->avg('amount'), 2) }}</th>
                                    <th class="text-end">100.0%</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
                <div class="col-md-4">
                    <canvas id="categoryChart" width="400" height="400"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Monthly Trend -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Monthly Expenditure Trend</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Month</th>
                            <th class="text-center">Transactions</th>
                            <th class="text-end">Total Amount</th>
                            <th class="text-end">Change from Previous</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $previousAmount = 0; @endphp
                        @foreach($monthlyTrend as $trend)
                        @php 
                            $change = $previousAmount > 0 ? (($trend->total_amount - $previousAmount) / $previousAmount) * 100 : 0;
                            $changeClass = $change > 0 ? 'text-danger' : ($change < 0 ? 'text-success' : 'text-muted');
                        @endphp
                        <tr>
                            <td><strong>{{ $trend->month_name }}</strong></td>
                            <td class="text-center">{{ $trend->transaction_count }}</td>
                            <td class="text-end">${{ number_format($trend->total_amount, 2) }}</td>
                            <td class="text-end {{ $changeClass }}">
                                @if($previousAmount > 0)
                                    {{ $change > 0 ? '+' : '' }}{{ number_format($change, 1) }}%
                                @else
                                    -
                                @endif
                            </td>
                        </tr>
                        @php $previousAmount = $trend->total_amount; @endphp
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Detailed Expenditures -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">Detailed Expenditure Transactions</h5>
        </div>
        <div class="card-body">
            @if($expenditures->count() > 0)
                <div class="table-responsive">
                    <table class="table table-striped table-hover" id="expendituresTable">
                        <thead>
                            <tr>
                                <th>Date</th>
                                <th>Voucher #</th>
                                <th>Description</th>
                                <th>Category</th>
                                <th>Vendor</th>
                                <th class="text-end">Amount</th>
                                <th>Payment Method</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($expenditures->sortByDesc('voucher_date') as $expenditure)
                            <tr>
                                <td>{{ Carbon\Carbon::parse($expenditure->voucher_date)->format('M d, Y') }}</td>
                                <td><code>{{ $expenditure->voucher_number }}</code></td>
                                <td>{{ str($expenditure->description)->limit(40) }}</td>
                                <td>
                                    <span class="badge bg-primary">{{ $expenditure->category_name ?? 'Uncategorized' }}</span>
                                </td>
                                <td>{{ $expenditure->vendor_name }}</td>
                                <td class="text-end">
                                    <strong class="text-danger">${{ number_format($expenditure->amount, 2) }}</strong>
                                </td>
                                <td>
                                    <span class="badge bg-secondary">{{ $expenditure->payment_method ?? 'N/A' }}</span>
                                </td>
                                <td>
                                    <span class="badge bg-{{ $expenditure->status == 'Paid' ? 'success' : ($expenditure->status == 'Pending' ? 'warning' : 'danger') }}">
                                        {{ $expenditure->status ?? 'Unknown' }}
                                    </span>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr class="table-primary">
                                <th colspan="5">Grand Total</th>
                                <th class="text-end">${{ number_format($expenditures->sum('amount'), 2) }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @else
                <div class="alert alert-info">
                    <i class="fas fa-info-circle"></i>
                    <strong>No Data Found</strong><br>
                    No expenditure transactions found for the selected criteria.
                </div>
            @endif
        </div>
    </div>
</div>

<!-- Chart.js -->
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

<script>
// Category Pie Chart
const categoryData = {!! json_encode($categorySummary->pluck('total_amount')) !!};
const categoryLabels = {!! json_encode($categorySummary->pluck('category_name')) !!};

const ctx = document.getElementById('categoryChart').getContext('2d');
new Chart(ctx, {
    type: 'pie',
    data: {
        labels: categoryLabels,
        datasets: [{
            data: categoryData,
            backgroundColor: [
                '#FF6384', '#36A2EB', '#FFCE56', '#4BC0C0', '#9966FF',
                '#FF9F40', '#FF6384', '#C9CBCF', '#4BC0C0', '#FF6384'
            ]
        }]
    },
    options: {
        responsive: true,
        plugins: {
            legend: {
                position: 'bottom'
            },
            tooltip: {
                callbacks: {
                    label: function(context) {
                        const total = categoryData.reduce((a, b) => a + b, 0);
                        const percentage = ((context.parsed / total) * 100).toFixed(1);
                        return context.label + ': $' + context.parsed.toLocaleString() + ' (' + percentage + '%)';
                    }
                }
            }
        }
    }
});

// Export to CSV function
function exportToCSV() {
    const table = document.getElementById('expendituresTable');
    let csv = [];
    
    // Get headers
    const headers = Array.from(table.querySelectorAll('thead th')).map(th => th.textContent.trim());
    csv.push(headers.join(','));
    
    // Get data rows
    const rows = table.querySelectorAll('tbody tr');
    rows.forEach(row => {
        const cols = Array.from(row.querySelectorAll('td')).map(td => {
            let text = td.textContent.trim();
            // Escape commas and quotes
            if (text.includes(',') || text.includes('"')) {
                text = '"' + text.replace(/"/g, '""') + '"';
            }
            return text;
        });
        csv.push(cols.join(','));
    });
    
    // Download
    const csvContent = csv.join('\n');
    const blob = new Blob([csvContent], { type: 'text/csv' });
    const url = window.URL.createObjectURL(blob);
    const a = document.createElement('a');
    a.href = url;
    a.download = 'expenditure-report-{{ date("Y-m-d") }}.csv';
    a.click();
    window.URL.revokeObjectURL(url);
}
</script>

<style>
@media print {
    .btn, .no-print {
        display: none !important;
    }
    
    .card {
        border: none !important;
        box-shadow: none !important;
    }
    
    .card-header {
        background: none !important;
        border: none !important;
    }
    
    body {
        -webkit-print-color-adjust: exact;
    }
    
    #categoryChart {
        max-width: 300px !important;
        max-height: 300px !important;
    }
}
</style>
@endsection