@extends('layouts.app')

@section('title', 'Average Solved 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-check-circle fa-2x" style="color:#51cf66;"></i>
                                </div>
                                <div>
                                    <h3 class="font-weight-bold mb-0 text-dark">Average Solved Time</h3>
                                    <p class="mb-0 text-muted small">View solved 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 Solved</p>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-md-6 mb-3 stat-card">
            <div class="card" style="background:#51cf66; color:#fff;">
                <div class="card-body">
                    <h4>{{ $stats['average'] }}m</h4>
                    <p class="mb-0">Average Solved 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-solved-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-solved-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">Solved 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>Assigned At</th>
                                    <th>Resolved At</th>
                                    <th>Solved Time</th>
                                    <th>Rating</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($tickets as $ticket)
                                    @php
                                        $assignment = DB::table('reseller_ticket_employee_assignments')
                                            ->where('reseller_ticket_id', $ticket->id)
                                            ->where('employee_id', $currentEmployee->id)
                                            ->whereNotNull('assigned_at')
                                            ->orderBy('assigned_at', 'asc')
                                            ->first();
                                        $solvedTime = ($assignment && $ticket->resolved_at)
                                            ? \Carbon\Carbon::parse($assignment->assigned_at)->diffInMinutes(\Carbon\Carbon::parse($ticket->resolved_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($assignment && $assignment->assigned_at)
                                                @php
                                                    $assignedAt = \Carbon\Carbon::parse($assignment->assigned_at);
                                                    $resolvedAt = $ticket->resolved_at;
                                                    if ($resolvedAt) {
                                                        $duration = $assignedAt->diff($resolvedAt);
                                                        $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($resolvedAt)
                                                    <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
                                                <br><small class="text-muted mt-1 d-block">{{ $assignedAt->format('Y-m-d H:i') }}</small>
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>
                                            @if($ticket->resolved_at)
                                                @php
                                                    $resolvedAt = \Carbon\Carbon::parse($ticket->resolved_at);
                                                    $assignedAt = $assignment ? \Carbon\Carbon::parse($assignment->assigned_at) : null;
                                                    if ($assignedAt) {
                                                        $duration = $assignedAt->diff($resolvedAt);
                                                        $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($assignedAt)
                                                    <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">{{ $resolvedAt->format('Y-m-d H:i') }}</small>
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        <td>
                                            @if($solvedTime !== null)
                                                @php
                                                    $days = floor($solvedTime / (24 * 60));
                                                    $hours = floor(($solvedTime % (24 * 60)) / 60);
                                                    $mins = $solvedTime % 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>
                                            @if($ticket->rating)
                                                <span style="display: inline-flex; align-items: center; gap: 4px;">
                                                    @for($i = 1; $i <= 5; $i++)
                                                        <i class="fas fa-star" style="color: {{ $i <= $ticket->rating ? '#ffc107' : '#ddd' }};"></i>
                                                    @endfor
                                                    <span>({{ $ticket->rating }}/5)</span>
                                                </span>
                                            @else
                                                N/A
                                            @endif
                                        </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 solved tickets found</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                    <div class="mt-3">
                        {{ $tickets->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection