@extends('layouts.app')

@section('title', 'Total Tickets')

@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-ticket-alt fa-2x text-primary"></i>
                                </div>
                                <div>
                                    <h3 class="font-weight-bold mb-0 text-dark">Total Tickets</h3>
                                    <p class="mb-0 text-muted small">View all tickets</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-2 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 Tickets</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.total-tickets') }}">
                        @if(request('per_page'))
                            <input type="hidden" name="per_page" value="{{ request('per_page') }}">
                        @endif
                        <div class="row">
                            <div class="col-md-2">
                                <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-1">
                                <div class="form-group">
                                    <label>Status</label>
                                    <select name="status" class="form-control">
                                        <option value="">All</option>
                                        <option value="open" {{ request('status') == 'open' ? 'selected' : '' }}>Open</option>
                                        <option value="in_progress" {{ request('status') == 'in_progress' ? 'selected' : '' }}>In Progress</option>
                                        <option value="resolved" {{ request('status') == 'resolved' ? 'selected' : '' }}>Resolved</option>
                                        <option value="closed" {{ request('status') == 'closed' ? 'selected' : '' }}>Closed</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="form-group">
                                    <label>Priority</label>
                                    <select name="priority" class="form-control">
                                        <option value="">All</option>
                                        <option value="low" {{ request('priority') == 'low' ? 'selected' : '' }}>Low</option>
                                        <option value="medium" {{ request('priority') == 'medium' ? 'selected' : '' }}>Medium</option>
                                        <option value="high" {{ request('priority') == 'high' ? 'selected' : '' }}>High</option>
                                        <option value="urgent" {{ request('priority') == 'urgent' ? 'selected' : '' }}>Urgent</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="form-group">
                                    <label>Category</label>
                                    <select name="category_id" class="form-control">
                                        <option value="">All</option>
                                        @foreach($categories as $category)
                                            <option value="{{ $category->id }}" {{ request('category_id') == $category->id ? 'selected' : '' }}>
                                                {{ $category->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="form-group">
                                    <label>Date From</label>
                                    <input type="date" name="date_from" class="form-control" value="{{ request('date_from') }}">
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="form-group">
                                    <label>Date To</label>
                                    <input type="date" name="date_to" class="form-control" value="{{ request('date_to') }}">
                                </div>
                            </div>
                            <div class="col-md-1">
                                <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.total-tickets') }}" 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">
                    <div class="d-flex justify-content-between align-items-center">
                        <h5 class="mb-0">Total Tickets ({{ $stats['total'] }})</h5>
                        <div class="d-flex align-items-center" style="gap: 8px;">
                            <span style="color: #6c757d; font-weight: 500;">SHOW</span>
                            <form method="GET" action="{{ route('reseller-tickets.total-tickets') }}" id="perPageForm" style="margin: 0;">
                                @if(request('search'))
                                    <input type="hidden" name="search" value="{{ request('search') }}">
                                @endif
                                @if(request('status'))
                                    <input type="hidden" name="status" value="{{ request('status') }}">
                                @endif
                                @if(request('priority'))
                                    <input type="hidden" name="priority" value="{{ request('priority') }}">
                                @endif
                                @if(request('category_id'))
                                    <input type="hidden" name="category_id" value="{{ request('category_id') }}">
                                @endif
                                @if(request('date_from'))
                                    <input type="hidden" name="date_from" value="{{ request('date_from') }}">
                                @endif
                                @if(request('date_to'))
                                    <input type="hidden" name="date_to" value="{{ request('date_to') }}">
                                @endif
                                <select name="per_page" id="perPageSelect" class="form-control form-control-sm" style="width: auto; min-width: 80px; padding: 4px 30px 4px 8px; border: 1px solid #ced4da; border-radius: 4px; font-size: 14px;" onchange="document.getElementById('perPageForm').submit();">
                                    @php
                                        $currentPerPage = request('per_page', 15);
                                    @endphp
                                    <option value="10" {{ $currentPerPage == 10 ? 'selected' : '' }}>10</option>
                                    <option value="15" {{ $currentPerPage == 15 ? 'selected' : '' }}>15</option>
                                    <option value="25" {{ $currentPerPage == 25 ? 'selected' : '' }}>25</option>
                                    <option value="50" {{ $currentPerPage == 50 ? 'selected' : '' }}>50</option>
                                    <option value="100" {{ $currentPerPage == 100 ? 'selected' : '' }}>100</option>
                                    <option value="200" {{ $currentPerPage == 200 ? 'selected' : '' }}>200</option>
                                </select>
                            </form>
                            <span style="color: #6c757d; font-weight: 500;">ENTRIES</span>
                        </div>
                    </div>
                </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>Category</th>
                                    <th>Sub Category</th>
                                    <th>Priority</th>
                                    <th>Status</th>
                                    <th>Solving Status</th>
                                    <th>Solved by</th>
                                    <th>Created by</th>
                                    <th>Created At</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($tickets as $ticket)
                                    <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>{{ $ticket->category->name ?? 'N/A' }}</td>
                                        <td>{{ $ticket->subcategory->name ?? 'N/A' }}</td>
                                        <td>
                                            @php
                                                $priorityColors = [
                                                    'low' => '#6c757d',
                                                    'medium' => '#17a2b8',
                                                    'high' => '#ffc107',
                                                    'urgent' => '#dc3545'
                                                ];
                                                $priorityColor = $priorityColors[$ticket->priority] ?? '#6c757d';
                                            @endphp
                                            <span style="display: inline-block; padding: 4px 12px; background-color: {{ $priorityColor }}; color: white; border-radius: 12px; font-size: 0.85em;">
                                                {{ ucfirst($ticket->priority) }}
                                            </span>
                                        </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>
                                            @php
                                                $isSolved = $ticket->resolved_at || $ticket->status === 'resolved' || $ticket->status === 'closed';
                                                $isSolving = $ticket->status === 'in_progress' || ($ticket->assignedEmployees && $ticket->assignedEmployees->where('pivot.is_active', true)->count() > 0);
                                            @endphp
                                            @if($isSolved)
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #28a745; color: white; border-radius: 12px; font-size: 0.85em;">
                                                    Solved
                                                </span>
                                            @else
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #6c757d; color: white; border-radius: 12px; font-size: 0.85em;">
                                                    Not Solve
                                                </span>
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                // Find who solved the ticket
                                                $solvedByEmployee = null;
                                                if ($isSolved) {
                                                    $resolvedAt = $ticket->resolved_at ?? ($ticket->closed_at ?? now());
                                                    
                                                    // Find assignment that was active before resolution and deactivated around resolution time
                                                    $solvedAssignment = DB::table('reseller_ticket_employee_assignments')
                                                        ->where('reseller_ticket_id', $ticket->id)
                                                        ->where('is_active', false)
                                                        ->whereNotNull('assigned_at')
                                                        ->orderBy('updated_at', 'desc')
                                                        ->first();
                                                    
                                                    if ($solvedAssignment) {
                                                        $solvedEmployee = DB::table('employees')
                                                            ->where('id', $solvedAssignment->employee_id)
                                                            ->first();
                                                        $solvedByEmployee = $solvedEmployee ? $solvedEmployee->name : null;
                                                    }
                                                    
                                                    // If not found, try to find any employee who had assignment for this ticket
                                                    if (!$solvedByEmployee) {
                                                        $anyAssignment = DB::table('reseller_ticket_employee_assignments')
                                                            ->where('reseller_ticket_id', $ticket->id)
                                                            ->orderBy('updated_at', 'desc')
                                                            ->first();
                                                        
                                                        if ($anyAssignment) {
                                                            $anyEmployee = DB::table('employees')
                                                                ->where('id', $anyAssignment->employee_id)
                                                                ->first();
                                                            $solvedByEmployee = $anyEmployee ? $anyEmployee->name : null;
                                                        }
                                                    }
                                                }
                                            @endphp
                                            @if($isSolved && $solvedByEmployee)
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #28a745; color: white; border-radius: 4px; font-size: 0.85em;">
                                                    {{ $solvedByEmployee }}
                                                </span>
                                            @elseif($isSolved)
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #6c757d; color: white; border-radius: 4px; font-size: 0.85em;">
                                                    N/A
                                                </span>
                                            @else
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #e9ecef; color: #6c757d; border-radius: 4px; font-size: 0.85em;">
                                                    -
                                                </span>
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $createdByUser = $ticket->createdBy;
                                            @endphp
                                            @if($createdByUser)
                                                @if($createdByUser->employeeRecord)
                                                    <span style="display: inline-block; padding: 4px 12px; background-color: #17a2b8; color: white; border-radius: 4px; font-size: 0.85em;">
                                                        {{ $createdByUser->employeeRecord->name ?? $createdByUser->name ?? 'N/A' }}
                                                    </span>
                                                @else
                                                    <span style="display: inline-block; padding: 4px 12px; background-color: #6c757d; color: white; border-radius: 4px; font-size: 0.85em;">
                                                        {{ $createdByUser->name ?? 'N/A' }}
                                                    </span>
                                                @endif
                                            @else
                                                <span style="display: inline-block; padding: 4px 12px; background-color: #e9ecef; color: #6c757d; border-radius: 4px; font-size: 0.85em;">
                                                    N/A
                                                </span>
                                            @endif
                                        </td>
                                        <td>
                                            {{ $ticket->created_at->format('Y-m-d H:i') }}
                                            <br><small class="text-muted">{{ $ticket->created_at->diffForHumans() }}</small>
                                        </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>
                                            <a href="{{ route('reseller-tickets.edit', $ticket) }}" class="btn btn-sm btn-warning" title="Edit">
                                                <i class="fas fa-edit"></i> Edit
                                            </a>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="11" class="text-center">No tickets found</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                    <div class="mt-3">
                        {{ $tickets->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection