@extends('dashboard.layouts.app')

@section('title', __('dashboard.Expenses Statistics'))
@section('page_heading', __('dashboard.Expenses Statistics'))

@section('breadcrumb')
    <li class="breadcrumb-item text-muted">
        <a href="{{ route('dashboard.home') }}" class="text-muted text-hover-primary">{{ __('dashboard.Home') }}</a>
    </li>
    <li class="breadcrumb-item text-muted">
        <a href="{{ route('dashboard.statistics.index') }}" class="text-muted text-hover-primary">{{ __('dashboard.Statistics') }}</a>
    </li>
    <li class="breadcrumb-item text-muted">{{ __('dashboard.Expenses') }}</li>
@endsection

@section('content')
    <div class="card card-flush">
        <div class="card-header">
            <h3 class="card-title">{{ __('dashboard.Expenses Statistics') }}</h3>
            <div class="card-toolbar">
                <a href="{{ route('dashboard.statistics.expenses.export', ['start_date' => $startDate->toDateString(), 'end_date' => $endDate->toDateString(), 'range' => $range]) }}" class="btn btn-light-primary">
                    {{ __('dashboard.Export CSV') }}
                </a>
            </div>
        </div>
        <div class="card-body">
            <form action="{{ route('dashboard.statistics.expenses') }}" method="GET">
                <div class="row mb-5">
                    <div class="col-md-3">
                        <label class="form-label">{{ __('dashboard.Select Range') }}</label>
                        <select name="range" id="range" class="form-select" onchange="this.form.submit()">
                            <option value="today" {{ $range == 'today' ? 'selected' : '' }}>{{ __('dashboard.Today') }}</option>
                            <option value="last_week" {{ $range == 'last_week' ? 'selected' : '' }}>{{ __('dashboard.Last Week') }}</option>
                            <option value="last_month" {{ $range == 'last_month' ? 'selected' : '' }}>{{ __('dashboard.Last Month') }}</option>
                            <option value="last_3_months" {{ $range == 'last_3_months' ? 'selected' : '' }}>{{ __('dashboard.Last 3 Months') }}</option>
                            <option value="last_6_months" {{ $range == 'last_6_months' ? 'selected' : '' }}>{{ __('dashboard.Last 6 Months') }}</option>
                            <option value="last_9_months" {{ $range == 'last_9_months' ? 'selected' : '' }}>{{ __('dashboard.Last 9 Months') }}</option>
                            <option value="last_year" {{ $range == 'last_year' ? 'selected' : '' }}>{{ __('dashboard.Last Year') }}</option>
                            <option value="custom" {{ $range == 'custom' ? 'selected' : '' }}>{{ __('dashboard.Custom Range') }}</option>
                        </select>
                    </div>
                    <div class="col-md-3" id="start_date_container" style="display: {{ $range == 'custom' ? 'block' : 'none' }};">
                        <label for="custom_start" class="form-label">{{ __('dashboard.From Date') }}</label>
                        <input type="date" name="custom_start" id="custom_start" class="form-control" value="{{ request('custom_start') }}">
                    </div>
                    <div class="col-md-3" id="end_date_container" style="display: {{ $range == 'custom' ? 'block' : 'none' }};">
                        <label for="custom_end" class="form-label">{{ __('dashboard.To Date') }}</label>
                        <input type="date" name="custom_end" id="custom_end" class="form-control" value="{{ request('custom_end') }}">
                    </div>
                    <div class="col-md-3 d-flex align-items-end">
                        <button type="submit" class="btn btn-primary me-3">{{ __('dashboard.Filter') }}</button>
                        <a href="{{ route('dashboard.statistics.expenses') }}" class="btn btn-secondary">{{ __('dashboard.Reset') }}</a>
                    </div>
                </div>
            </form>

            <div id="expensesChart" style="height: 400px; width: 100%;"></div>

            <div class="table-responsive mt-5">
                <table id="expensesTable" class="table table-striped table-row-bordered gy-5 gs-7">
                    <thead>
                        <tr class="fw-bold fs-6 text-gray-800">
                            <th>#</th>
                            <th>{{ __('dashboard.Date') }}</th>
                            <th>{{ __('dashboard.Total Expenses') }}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($chartData['labels'] as $index => $date)
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>{{ $date }}</td>
                                <td>{{ number_format($chartData['amounts'][$index], 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
        google.charts.load('current', {'packages':['corechart']});
        google.charts.setOnLoadCallback(drawChart);

        var expensesChartData = @json($chartData);

        function drawChart() {
            var data = new google.visualization.DataTable();
            data.addColumn('string', '{{ __('dashboard.Date') }}');
            data.addColumn('number', '{{ __('dashboard.Total Expenses') }}');

            for (var i = 0; i < expensesChartData.labels.length; i++) {
                data.addRow([
                    expensesChartData.labels[i],
                    parseFloat(expensesChartData.amounts[i])
                ]);
            }

            var options = {
                title: '{{ __('dashboard.Expenses Statistics') }}',
                curveType: 'function',
                legend: { position: 'bottom' },
                vAxis: {
                    minValue: 0,
                    format: 'decimal'
                },
                hAxis: {
                    title: '{{ __('dashboard.Date') }}'
                },
                colors: ['#009ef7']
            };

            var chart = new google.visualization.LineChart(document.getElementById('expensesChart'));
            chart.draw(data, options);
        }

        $(document).ready(function() {
            $('select[name="range"]').change(function() {
                if($(this).val() === 'custom') {
                    $('#start_date_container').show();
                    $('#end_date_container').show();
                } else {
                    $('#start_date_container').hide();
                    $('#end_date_container').hide();
                    this.form.submit();
                }
            });

            $('input[name="custom_start"], input[name="custom_end"]').change(function() {
                if ($('select[name="range"]').val() === 'custom') {
                    // No automatic submission, wait for the Filter button
                }
            });
        });
    </script>
@endsection