@extends('layouts.app')

@section('title', 'Monthly Summary Report')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h3 mb-0 text-gray-800">
            <i class="bi bi-calendar3 me-2"></i>Monthly Summary Report
        </h1>
        <a href="{{ route('reports.index') }}" class="btn btn-secondary">
            <i class="bi bi-arrow-left me-1"></i>Back to Reports
        </a>
    </div>

    <!-- Filter Form -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.monthly-summary') }}" class="row g-3">
                <div class="col-md-6">
                    <label for="year" class="form-label">Year</label>
                    <select class="form-select" id="year" name="year">
                        @for($y = now()->year; $y >= now()->year - 5; $y--)
                            <option value="{{ $y }}" {{ request('year', now()->year) == $y ? 'selected' : '' }}>
                                {{ $y }}
                            </option>
                        @endfor
                    </select>
                </div>
                <div class="col-md-4">
                    <label class="form-label">&nbsp;</label>
                    <div class="d-flex flex-column flex-md-row gap-2">
                        <button type="submit" class="btn btn-primary">
                            <i class="bi bi-funnel me-1"></i>Filter
                        </button>
                        <a href="{{ route('reports.export-csv', ['report' => 'monthly-summary'] + request()->all()) }}" 
                           class="btn btn-success">
                            <i class="fas fa-download me-1"></i>CSV
                        </a>
                        <a href="{{ route('reports.monthly-summary.pdf', request()->all()) }}" 
                           class="btn btn-danger">
                            <i class="fas fa-file-pdf me-1"></i>PDF
                        </a>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <!-- Year Summary Cards -->
    <div class="row mb-4">
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-success shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                Total Income ({{ $year }})</div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                LKR {{ number_format($yearlyTotals['income'], 2) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="bi bi-arrow-up-circle text-success fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-danger shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                                Total Expenses ({{ $year }})</div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                LKR {{ number_format($yearlyTotals['expense'], 2) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="bi bi-arrow-down-circle text-danger fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-{{ $yearlyTotals['net'] >= 0 ? 'success' : 'danger' }} shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-{{ $yearlyTotals['net'] >= 0 ? 'success' : 'danger' }} text-uppercase mb-1">
                                Net {{ $yearlyTotals['net'] >= 0 ? 'Profit' : 'Loss' }}</div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                LKR {{ number_format(abs($yearlyTotals['net']), 2) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="bi bi-{{ $yearlyTotals['net'] >= 0 ? 'trophy' : 'exclamation-triangle' }} text-{{ $yearlyTotals['net'] >= 0 ? 'success' : 'danger' }} fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-info shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                Avg Monthly Profit</div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                LKR {{ number_format($yearlyTotals['net'] / 12, 2) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="bi bi-graph-up text-info fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Monthly Chart -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Monthly Income vs Expense ({{ $year }})</h6>
        </div>
        <div class="card-body">
            <canvas id="monthlyChart"></canvas>
        </div>
    </div>

    <!-- Monthly Summary Table -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Monthly Breakdown</h6>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>Month</th>
                            <th>Income</th>
                            <th>Expenses</th>
                            <th>Net Profit/Loss</th>
                            <th>Transaction Count</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($monthlyData as $data)
                        <tr>
                            <td>{{ $data->month_name }}</td>
                            <td class="text-success">LKR {{ number_format($data->income, 2) }}</td>
                            <td class="text-danger">LKR {{ number_format($data->expense, 2) }}</td>
                            <td class="text-{{ ($data->income - $data->expense) >= 0 ? 'success' : 'danger' }}">
                                LKR {{ number_format($data->income - $data->expense, 2) }}
                            </td>
                            <td>{{ $data->transaction_count }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
// Monthly Chart
const monthlyCtx = document.getElementById('monthlyChart').getContext('2d');
const monthlyChart = new Chart(monthlyCtx, {
    type: 'bar',
    data: {
        labels: {!! json_encode($monthlyData->pluck('month_name')) !!},
        datasets: [{
            label: 'Income',
            data: {!! json_encode($monthlyData->pluck('income')) !!},
            backgroundColor: 'rgba(28, 200, 138, 0.8)',
            borderColor: 'rgb(28, 200, 138)',
            borderWidth: 1
        }, {
            label: 'Expense',
            data: {!! json_encode($monthlyData->pluck('expense')) !!},
            backgroundColor: 'rgba(231, 74, 59, 0.8)',
            borderColor: 'rgb(231, 74, 59)',
            borderWidth: 1
        }]
    },
    options: {
        responsive: true,
        scales: {
            y: {
                beginAtZero: true,
                ticks: {
                    callback: function(value) {
                        return 'LKR ' + value.toLocaleString();
                    }
                }
            }
        },
        plugins: {
            legend: {
                position: 'top'
            }
        }
    }
});
</script>
@endsection