@extends('dashboard.layouts.app')

@section('title', __('dashboard.Purchases Statistics'))
@section('page_heading', __('dashboard.Purchases 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.Purchases') }}</li>
@endsection

@section('content')
    <div class="card card-flush">
        <div class="card-header">
            <h3 class="card-title">{{ __('dashboard.Purchases Statistics') }}</h3>
            <div class="card-toolbar">
                <a href="{{ route('dashboard.statistics.purchases.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.purchases') }}" 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.purchases') }}" class="btn btn-secondary">{{ __('dashboard.Reset') }}</a>
                    </div>
                </div>
            </form>

            <div class="row">
                <div class="col-md-6">
                    <div id="purchasesChart" style="height: 400px; width: 100%;"></div>
                </div>
                <div class="col-md-6">
                    <div id="amountsChart" style="height: 400px; width: 100%;"></div>
                </div>
            </div>

            <div class="table-responsive mt-5">
                <table id="purchasesTable" 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.Purchases Count') }}</th>
                            <th>{{ __('dashboard.Returns Count') }}</th>
                            <th>{{ __('dashboard.Purchases Total Value') }}</th>
                            <th>{{ __('dashboard.Returns Value') }}</th>
                            <th>{{ __('dashboard.Net Purchases') }}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($chartData['labels'] as $index => $date)
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>{{ $date }}</td>
                                <td>{{ $chartData['purchases'][$index] }}</td>
                                <td>{{ $chartData['returns'][$index] }}</td>
                                <td>{{ number_format($chartData['amount'][$index], 2) }}</td>
                                <td>{{ number_format($chartData['returns_amount'][$index], 2) }}</td>
                                <td>{{ number_format($chartData['net_purchases'][$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(drawCharts);

        var purchasesChartData = @json($chartData);
        var i;
        function drawChart(data, options, chartId) {
            var chart = new google.visualization.LineChart(document.getElementById(chartId));
            chart.draw(data, options);
        }

        function drawCharts() {
            // بيانات المخطط الأول - عدد المشتريات
            var dataPurchases = new google.visualization.DataTable();
            dataPurchases.addColumn('string', '{{ __('dashboard.Date') }}');
            dataPurchases.addColumn('number', '{{ __('dashboard.Purchases Count') }}');
            dataPurchases.addColumn('number', '{{ __('dashboard.Returns Count') }}');

            for ( i = 0; i < purchasesChartData.labels.length; i++) {
                dataPurchases.addRow([
                    purchasesChartData.labels[i],
                    parseFloat(purchasesChartData.purchases[i]),
                    parseFloat(purchasesChartData.returns[i])
                ]);
            }

            var optionsPurchases = {
                title: '{{ __('dashboard.Purchases and Returns Count') }}',
                legend: { position: 'bottom' },
                curveType: 'function',
                vAxis: {
                    title: '{{ __('dashboard.Count') }}',
                    minValue: 0,
                    format: '0'
                },
                hAxis: {
                    title: '{{ __('dashboard.Date') }}'
                },
                colors: ['#009ef7', '#f1416c'],
                isStacked: false
            };

            drawChart(dataPurchases, optionsPurchases, 'purchasesChart');

            // بيانات المخطط الثاني -  قيم المشتريات
            var dataAmounts = new google.visualization.DataTable();
            dataAmounts.addColumn('string', '{{ __('dashboard.Date') }}');
            dataAmounts.addColumn('number', '{{ __('dashboard.Purchases Total Value') }}');
            dataAmounts.addColumn('number', '{{ __('dashboard.Returns Value') }}');
            dataAmounts.addColumn('number', '{{ __('dashboard.Net Purchases') }}');

            for ( i = 0; i < purchasesChartData.labels.length; i++) {
                dataAmounts.addRow([
                    purchasesChartData.labels[i],
                    parseFloat(purchasesChartData.amount[$i]),
                    parseFloat(purchasesChartData.returns_amount[$i]),
                    parseFloat(purchasesChartData.net_purchases[$i])
                ]);
            }

            var optionsAmounts = {
                title: '{{ __('dashboard.Purchases and Returns Values') }}',
                legend: { position: 'bottom' },
                curveType: 'function',
                vAxis: {
                    title: '{{ __('dashboard.Value') }}',
                    minValue: 0,
                    format: 'decimal'
                },
                hAxis: {
                    title: '{{ __('dashboard.Date') }}'
                },
                colors: ['#009ef7', '#f1416c', '#66CDAA'] // ألوان مختلفة
            };

            drawChart(dataAmounts, optionsAmounts, 'amountsChart');
        }

        $(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