@extends('layouts.admin')

@section('title', 'Custom Report Results')

@section('content')
<div class="container-fluid">
    <!-- Page Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h1 class="h3 mb-0 text-gray-800">Custom Report Results</h1>
            <p class="text-muted">{{ ucfirst($validated['report_type']) }} report generated for {{ $validated['date_from'] }} to {{ $validated['date_to'] }}</p>
        </div>
        <div>
            <a href="{{ route('admin.reports.custom') }}" class="btn btn-primary">
                <i class="fas fa-plus me-2"></i>New Report
            </a>
            <a href="{{ route('admin.reports.index') }}" class="btn btn-outline-secondary">
                <i class="fas fa-arrow-left me-2"></i>Back to Reports
            </a>
        </div>
    </div>

    <!-- Report Parameters -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Report Parameters</h6>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-3">
                    <strong>Report Type:</strong><br>
                    <span class="badge bg-primary">{{ ucfirst($validated['report_type']) }}</span>
                </div>
                <div class="col-md-3">
                    <strong>Chart Type:</strong><br>
                    <span class="badge bg-info">{{ ucfirst($validated['chart_type']) }}</span>
                </div>
                <div class="col-md-3">
                    <strong>Date Range:</strong><br>
                    {{ \Carbon\Carbon::parse($validated['date_from'])->format('M d, Y') }} - 
                    {{ \Carbon\Carbon::parse($validated['date_to'])->format('M d, Y') }}
                </div>
                <div class="col-md-3">
                    <strong>Metrics:</strong><br>
                    @foreach($validated['metrics'] as $metric)
                        <span class="badge bg-success me-1">{{ ucfirst(str_replace('_', ' ', $metric)) }}</span>
                    @endforeach
                </div>
            </div>
            @if(!empty($validated['group_by']))
            <div class="row mt-2">
                <div class="col-md-12">
                    <strong>Grouped By:</strong> 
                    <span class="badge bg-warning">{{ ucfirst($validated['group_by']) }}</span>
                </div>
            </div>
            @endif
        </div>
    </div>

    <!-- Report Results -->
    <div class="card shadow">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-success">Report Data</h6>
        </div>
        <div class="card-body">
            @if($validated['chart_type'] === 'table')
                <!-- Table View -->
                <div class="table-responsive">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Item</th>
                                @foreach($validated['metrics'] as $metric)
                                    <th>{{ ucfirst(str_replace('_', ' ', $metric)) }}</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>
                            @if(isset($reportData['data']) && count($reportData['data']) > 0)
                                @foreach($reportData['data'] as $metric => $value)
                                <tr>
                                    <td>{{ ucfirst(str_replace('_', ' ', $metric)) }}</td>
                                    <td>{{ is_numeric($value) ? number_format($value, 2) : $value }}</td>
                                </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td colspan="{{ count($validated['metrics']) + 1 }}" class="text-center text-muted">
                                        No data available for the selected criteria
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>
            @else
                <!-- Chart Placeholder -->
                <div class="text-center py-5">
                    <i class="fas fa-chart-{{ $validated['chart_type'] === 'pie' ? 'pie' : ($validated['chart_type'] === 'line' ? 'line' : 'bar') }} fa-3x text-muted mb-3"></i>
                    <h5 class="text-muted">{{ ucfirst($validated['chart_type']) }} Chart</h5>
                    <p class="text-muted">Chart visualization would be displayed here</p>
                    
                    @if(isset($reportData['data']) && count($reportData['data']) > 0)
                        <div class="mt-4">
                            <h6>Data Summary:</h6>
                            @foreach($reportData['data'] as $metric => $value)
                                <div class="d-inline-block mx-3">
                                    <div class="h4 mb-0 text-primary">{{ is_numeric($value) ? number_format($value, 2) : $value }}</div>
                                    <div class="text-xs text-muted">{{ ucfirst(str_replace('_', ' ', $metric)) }}</div>
                                </div>
                            @endforeach
                        </div>
                    @endif
                </div>
            @endif
        </div>
    </div>

    <!-- Raw Data (if available) -->
    @if(isset($reportData['raw_data']) && $reportData['raw_data']->count() > 0)
    <div class="card shadow mt-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-info">Raw Data Sample (First 10 Records)</h6>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead>
                        <tr>
                            <th>ID</th>
                            @if($validated['report_type'] === 'applications')
                                <th>User</th>
                                <th>Position</th>
                                <th>Status</th>
                            @elseif($validated['report_type'] === 'positions')
                                <th>Title</th>
                                <th>Department</th>
                                <th>Status</th>
                            @elseif($validated['report_type'] === 'users')
                                <th>Name</th>
                                <th>Email</th>
                                <th>Role</th>
                            @elseif($validated['report_type'] === 'departments')
                                <th>Name</th>
                                <th>Status</th>
                            @endif
                            <th>Created Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($reportData['raw_data']->take(10) as $item)
                        <tr>
                            <td>{{ $item->id }}</td>
                            @if($validated['report_type'] === 'applications')
                                <td>{{ $item->user->name ?? 'N/A' }}</td>
                                <td>{{ $item->advertisement->title ?? 'N/A' }}</td>
                                <td>
                                    <span class="badge bg-{{ $item->status_color ?? 'secondary' }}">
                                        {{ ucfirst($item->status) }}
                                    </span>
                                </td>
                            @elseif($validated['report_type'] === 'positions')
                                <td>{{ $item->title }}</td>
                                <td>{{ $item->department->name ?? 'N/A' }}</td>
                                <td>
                                    <span class="badge bg-{{ $item->status === 'published' ? 'success' : 'secondary' }}">
                                        {{ ucfirst($item->status) }}
                                    </span>
                                </td>
                            @elseif($validated['report_type'] === 'users')
                                <td>{{ $item->name }}</td>
                                <td>{{ $item->email }}</td>
                                <td>
                                    <span class="badge bg-{{ $item->role === 'admin' ? 'danger' : 'primary' }}">
                                        {{ ucfirst($item->role) }}
                                    </span>
                                </td>
                            @elseif($validated['report_type'] === 'departments')
                                <td>{{ $item->name }}</td>
                                <td>
                                    <span class="badge bg-success">{{ ucfirst($item->status ?? 'active') }}</span>
                                </td>
                            @endif
                            <td>{{ $item->created_at->format('M d, Y H:i') }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            @if($reportData['raw_data']->count() > 10)
                <p class="text-muted small mt-2">
                    Showing 10 of {{ $reportData['raw_data']->count() }} total records
                </p>
            @endif
        </div>
    </div>
    @endif

    <!-- Export Options -->
    <div class="card shadow mt-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-warning">Export Options</h6>
        </div>
        <div class="card-body">
            <p class="text-muted">Export this report in various formats:</p>
            <div class="btn-group" role="group">
                <button type="button" class="btn btn-outline-success" onclick="exportReport('excel')">
                    <i class="fas fa-file-excel me-1"></i>Excel
                </button>
                <button type="button" class="btn btn-outline-danger" onclick="exportReport('pdf')">
                    <i class="fas fa-file-pdf me-1"></i>PDF
                </button>
                <button type="button" class="btn btn-outline-info" onclick="exportReport('csv')">
                    <i class="fas fa-file-csv me-1"></i>CSV
                </button>
            </div>
        </div>
    </div>
</div>

<script>
function exportReport(format) {
    // This would typically make an AJAX call to export the report
    alert('Export functionality would be implemented here for ' + format.toUpperCase() + ' format');
}
</script>
@endsection