@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <div class="row justify-content-center">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header bg-primary text-white d-flex justify-content-between align-items-center">
                    <h4 class="mb-0">{{ __('Table Usage Report') }}</h4>
                    <div>
                        <a href="{{ route('reports.tables', ['report_type' => request('report_type'), 'start_date' => request('start_date'), 'end_date' => request('end_date'), 'export' => 'pdf']) }}" class="btn btn-light">
                            <i class="fas fa-file-pdf"></i> {{ __('Export PDF') }}
                        </a>
                        <button type="button" class="btn btn-light ms-2" onclick="window.print()">
                            <i class="fas fa-print"></i> {{ __('Print') }}
                        </button>
                    </div>
                </div>

                <div class="card-body">
                    <form method="GET" action="{{ route('reports.tables') }}" class="mb-4">
                        <div class="row">
                            <div class="col-md-3 mb-3">
                                <label for="report_type" class="form-label">{{ __('Report Type') }}</label>
                                <select class="form-select" id="report_type" name="report_type" onchange="this.form.submit()">
                                    <option value="daily" {{ request('report_type') == 'daily' ? 'selected' : '' }}>{{ __('Daily') }}</option>
                                    <option value="weekly" {{ request('report_type') == 'weekly' ? 'selected' : '' }}>{{ __('Weekly') }}</option>
                                    <option value="monthly" {{ request('report_type') == 'monthly' ? 'selected' : '' }}>{{ __('Monthly') }}</option>
                                    <option value="custom" {{ request('report_type') == 'custom' ? 'selected' : '' }}>{{ __('Custom Range') }}</option>
                                </select>
                            </div>
                            
                            @if(request('report_type') == 'custom')
                            <div class="col-md-3 mb-3">
                                <label for="start_date" class="form-label">{{ __('Start Date') }}</label>
                                <input type="date" class="form-control" id="start_date" name="start_date" value="{{ request('start_date', $startDate) }}">
                            </div>
                            <div class="col-md-3 mb-3">
                                <label for="end_date" class="form-label">{{ __('End Date') }}</label>
                                <input type="date" class="form-control" id="end_date" name="end_date" value="{{ request('end_date', $endDate) }}">
                            </div>
                            <div class="col-md-3 mb-3 d-flex align-items-end">
                                <button type="submit" class="btn btn-primary">{{ __('Apply Filters') }}</button>
                            </div>
                            @endif
                        </div>
                    </form>

                    <div class="report-header mb-4">
                        <h5>{{ __('Report Period') }}: {{ $startDate }} {{ __('to') }} {{ $endDate }}</h5>
                    </div>

                    <div class="table-responsive">
                        <table class="table table-striped table-hover">
                            <thead>
                                <tr>
                                    <th>{{ __('Table Number') }}</th>
                                    <th>{{ __('Capacity') }}</th>
                                    <th class="text-end">{{ __('Orders') }}</th>
                                    <th class="text-end">{{ __('Total Revenue') }}</th>
                                    <th class="text-end">{{ __('Average Order Value') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($tableUsage as $table)
                                <tr>
                                    <td>{{ $table->number }}</td>
                                    <td>{{ $table->capacity }}</td>
                                    <td class="text-end">{{ $table->orders_count }}</td>
                                    <td class="text-end">{{ number_format($table->orders_sum_final_amount, 2) }}</td>
                                    <td class="text-end">
                                        @if($table->orders_count > 0)
                                            {{ number_format($table->orders_sum_final_amount / $table->orders_count, 2) }}
                                        @else
                                            0.00
                                        @endif
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="5" class="text-center">{{ __('No table usage data available for the selected period') }}</td>
                                </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <tr class="fw-bold">
                                    <td colspan="2">{{ __('Total') }}</td>
                                    <td class="text-end">{{ $tableUsage->sum('orders_count') }}</td>
                                    <td class="text-end">{{ number_format($tableUsage->sum('orders_sum_final_amount'), 2) }}</td>
                                    <td class="text-end">
                                        @if($tableUsage->sum('orders_count') > 0)
                                            {{ number_format($tableUsage->sum('orders_sum_final_amount') / $tableUsage->sum('orders_count'), 2) }}
                                        @else
                                            0.00
                                        @endif
                                    </td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>

                    <div class="mt-4">
                        <h5>{{ __('Table Revenue Comparison') }}</h5>
                        <div class="chart-container" style="position: relative; height:300px;">
                            <canvas id="tableChart"></canvas>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
    document.addEventListener('DOMContentLoaded', function() {
        const tableData = @json($tableUsage);
        
        if (tableData.length > 0) {
            const ctx = document.getElementById('tableChart').getContext('2d');
            
            new Chart(ctx, {
                type: 'bar',
                data: {
                    labels: tableData.map(t => '{{ __("Table") }} ' + t.number),
                    datasets: [{
                        label: '{{ __("Revenue") }}',
                        data: tableData.map(t => t.orders_sum_final_amount),
                        backgroundColor: 'rgba(153, 102, 255, 0.5)',
                        borderColor: 'rgba(153, 102, 255, 1)',
                        borderWidth: 1
                    }]
                },
                options: {
                    responsive: true,
                    maintainAspectRatio: false,
                    scales: {
                        y: {
                            beginAtZero: true
                        }
                    }
                }
            });
        }
        
        // Handle report type change
        document.getElementById('report_type').addEventListener('change', function() {
            if (this.value === 'custom') {
                // Don't submit form automatically for custom, let user select dates
                return false;
            }
            this.form.submit();
        });
    });
</script>
@endsection