@extends('layouts.app')

@section('title', 'Average Forwarded Time')

@section('content')
<div class="container-fluid">
    <!-- Header Section -->
    <div class="row mb-3">
        <div class="col-12">
            <div class="card border-0 shadow-sm">
                <div class="card-body py-3">
                    <div class="row align-items-center">
                        <div class="col-lg-8">
                            <div class="d-flex align-items-center">
                                <div class="mr-3">
                                    <i class="fas fa-share-alt fa-2x" style="color:#ff6b6b;"></i>
                                </div>
                                <div>
                                    <h3 class="font-weight-bold mb-0 text-dark">Average Forwarded Time</h3>
                                    <p class="mb-0 text-muted small">View forwarded time statistics</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-4 text-lg-right mt-2 mt-lg-0">
                            <button type="button" onclick="history.back()" class="btn btn-secondary">
                                <i class="fas fa-arrow-left"></i> Back to Tickets
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Statistics Cards -->
    <div class="row mb-4">
        <div class="col-lg-3 col-md-6 mb-3 stat-card">
            <div class="card bg-primary text-white w-100">
                <div class="card-body">
                    <h4>{{ $stats['total'] }}</h4>
                    <p class="mb-0">Total Forwarded</p>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-md-6 mb-3 stat-card">
            <div class="card" style="background:#ff6b6b; color:#fff;">
                <div class="card-body">
                    <h4>{{ $stats['average'] }}m</h4>
                    <p class="mb-0">Average Forwarded Time</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <form method="GET" action="{{ route('reseller-tickets.average-forwarded-time') }}">
                        <div class="row">
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label>Search</label>
                                    <input type="text" name="search" class="form-control" value="{{ request('search') }}" placeholder="Ticket number, subject, reseller...">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group">
                                    <label>&nbsp;</label>
                                    <button type="submit" class="btn btn-primary btn-block">Filter</button>
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="form-group">
                                    <label>&nbsp;</label>
                                    <a href="{{ route('reseller-tickets.average-forwarded-time') }}" class="btn btn-secondary btn-block">Reset</a>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Tickets Table -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h5 class="mb-0">Forwarded Tickets ({{ $stats['total'] }})</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-hover">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Ticket #</th>
                                    <th>Reseller</th>
                                    <th>Subject</th>
                                    <th>Category</th>
                                    <th>Forwarded At</th>
                                    <th>Next Assigned At</th>
                                    <th>Forwarded Time</th>
                                    <th>Status</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($tickets as $ticket)
                                    @php
                                        $forwardedAssignment = DB::table('reseller_ticket_employee_assignments')
                                            ->where('reseller_ticket_id', $ticket->id)
                                            ->where('assigned_by', auth()->id())
                                            ->where('is_active', false)
                                            ->orderBy('assigned_at', 'asc')
                                            ->first();
                                        $nextAssignment = DB::table('reseller_ticket_employee_assignments')
                                            ->where('reseller_ticket_id', $ticket->id)
                                            ->where('assigned_at', '>', $forwardedAssignment ? $forwardedAssignment->assigned_at : now())
                                            ->orderBy('assigned_at', 'asc')
                                            ->first();
                                        $forwardedTime = ($forwardedAssignment && $nextAssignment)
                                            ? \Carbon\Carbon::parse($forwardedAssignment->assigned_at)->diffInMinutes(\Carbon\Carbon::parse($nextAssignment->assigned_at))
                                            : null;
                                    @endphp
                                    <tr>
                                        <td>
                                            <a href="{{ route('reseller-tickets.show', $ticket) }}" class="btn btn-link text-primary font-weight-bold">
                                                {{ $ticket->ticket_number }}
                                            </a>
                                        </td>
                                        <td>
                                            @if($ticket->user)
                                                @if($ticket->user->reseller && $ticket->user->reseller->name)
                                                    {{ $ticket->user->reseller->name }}
                                                @elseif($ticket->user->company_name)
                                                    {{ $ticket->user->company_name }}
                                                @else
                                                    {{ $ticket->user->name ?? 'N/A' }}
                                                @endif
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>{{ Str::limit($ticket->subject ?? $ticket->description, 50) }}</td>
                                        <td>{{ $ticket->category->name ?? 'N/A' }}</td>
                                        <td>
                                            @if($forwardedAssignment && $forwardedAssignment->assigned_at)
                                                @php
                                                    $forwardedAt = \Carbon\Carbon::parse($forwardedAssignment->assigned_at);
                                                    $nextAssignedAt = $nextAssignment ? \Carbon\Carbon::parse($nextAssignment->assigned_at) : null;
                                                    if ($nextAssignedAt) {
                                                        $duration = $forwardedAt->diff($nextAssignedAt);
                                                        $days = $duration->days;
                                                        $hours = $duration->h;
                                                        $minutes = $duration->i;
                                                        $seconds = $duration->s;
                                                        $durationText = sprintf('%dd:%02dh:%02dm:%02ds', $days, $hours, $minutes, $seconds);
                                                    } else {
                                                        $durationText = 'N/A';
                                                    }
                                                @endphp
                                                @if($nextAssignedAt)
                                                    <span style="display: inline-block; padding: 6px 12px; background-color: #ffc107; color: #000; border-radius: 20px; font-weight: 500; font-size: 0.9em;">
                                                        {{ $durationText }}
                                                    </span>
                                                @endif
                                                <br><small class="text-muted mt-1 d-block">{{ $forwardedAt->format('Y-m-d H:i') }}</small>
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>
                                            @if($nextAssignment && $nextAssignment->assigned_at)
                                                @php
                                                    $nextAssignedAt = \Carbon\Carbon::parse($nextAssignment->assigned_at);
                                                    $forwardedAt = $forwardedAssignment ? \Carbon\Carbon::parse($forwardedAssignment->assigned_at) : null;
                                                    if ($forwardedAt) {
                                                        $duration = $forwardedAt->diff($nextAssignedAt);
                                                        $days = $duration->days;
                                                        $hours = $duration->h;
                                                        $minutes = $duration->i;
                                                        $seconds = $duration->s;
                                                        $durationText = sprintf('%dd:%02dh:%02dm:%02ds', $days, $hours, $minutes, $seconds);
                                                    } else {
                                                        $durationText = 'N/A';
                                                    }
                                                @endphp
                                                @if($forwardedAt)
                                                    <span style="display: inline-block; padding: 6px 12px; background-color: #ffc107; color: #000; border-radius: 20px; font-weight: 500; font-size: 0.9em;">
                                                        {{ $durationText }}
                                                    </span>
                                                @endif
                                                <br><small class="text-muted mt-1 d-block">{{ $nextAssignedAt->format('Y-m-d H:i') }}</small>
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>
                                            @if($forwardedTime !== null)
                                                @php
                                                    $days = floor($forwardedTime / (24 * 60));
                                                    $hours = floor(($forwardedTime % (24 * 60)) / 60);
                                                    $mins = $forwardedTime % 60;
                                                    $durationText = sprintf('%dd:%02dh:%02dm:00s', $days, $hours, $mins);
                                                @endphp
                                                <span style="display: inline-block; padding: 6px 12px; background-color: #ffc107; color: #000; border-radius: 20px; font-weight: 500; font-size: 0.9em;">
                                                    {{ $durationText }}
                                                </span>
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $statusLabel = ucfirst(str_replace('_', ' ', $ticket->status));
                                            @endphp
                                            <span style="display: inline-block; padding: 4px 12px; background-color: {{ $ticket->status == 'open' ? '#28a745' : ($ticket->status == 'in_progress' ? '#ffc107' : '#6c757d') }}; color: white; border-radius: 12px; font-size: 0.85em;">
                                                {{ $statusLabel }}
                                            </span>
                                        </td>
                                        <td>
                                            <a href="{{ route('reseller-tickets.show', $ticket) }}" class="btn btn-sm btn-info" title="View">
                                                <i class="fas fa-eye"></i> View
                                            </a>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="9" class="text-center">No forwarded tickets found</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                    <div class="mt-3">
                        {{ $tickets->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection