@extends('layout.mainlayout')

@section('content')
    <div class="page-wrapper">
        <div class="content">

            <div class="page-header d-flex justify-content-between align-items-center">
                <h3 class="page-title">Overseas Attendance Requests</h3>
                <a href="{{ route('attendance.overseas.requests.export', request()->except('page')) }}"
                    class="btn btn-success">
                    <i class="ti ti-download me-1"></i> Export
                </a>
            </div>

            {{-- FILTERS --}}
            <form method="GET" class="row g-2 mb-3">

                <div class="col-md-2">
                    <label class="form-label">From Date</label>
                    <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
                </div>

                <div class="col-md-2">
                    <label class="form-label">To Date</label>
                    <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
                </div>

                <div class="col-md-2">
                    <label class="form-label">Team</label>
                    <select name="team_id" class="form-control select2">
                        <option value="">All Teams</option>
                        @foreach ($teams as $team)
                            <option value="{{ $team->id }}" @selected(request('team_id') == $team->id)>
                                {{ $team->name }}
                            </option>
                        @endforeach
                    </select>
                </div>


                <div class="col-md-2">
                    <label class="form-label">Overseas Employee</label>
                    <select name="resource_id" class="form-control select2">
                        <option value="">All Overseas Employees</option>
                        @foreach ($overseasUsers as $u)
                            <option value="{{ $u['id'] }}" @selected(request('resource_id') == $u['id'])>
                                {{ $u['name'] }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2 d-flex align-items-end gap-2">
                    <button class="btn btn-primary w-100">Filter</button>
                </div>

            </form>

            {{-- TABLE --}}
            <div class="card">
                <div class="card-body table-responsive">

                    <table class="table table-bordered table-striped align-middle" id="OverseasAttendanceRequestsTable">
                        <thead class="table-light">
                            <tr>
                                <th>Name</th>
                                <th>Applied On</th>

                                <th>Date Range</th>
                                <th>Days</th>
                                <th>Type</th>
                                <th>Testing Time</th>
                                <th>Testing Hours</th>
                                <th>Mobility Hours</th>
                                <th>Mobility</th>\
                                <th>Personal Car Usage</th>
                                <th>City</th>
                                <th>Country</th>
                                <th>Half Day</th>
                                <th>Product</th>
                                <th>Remark</th>
                                <th>Team</th>
                                <th>Lead</th>
                                <th>Manager</th>
                                <th>Lead Status</th>
                                <th>Manager Status</th>
                                <th>Final</th>
                            </tr>
                        </thead>

                        <tbody>
                            @forelse($requests as $r)
                                @php
                                    $testingStart = $r->getForm('testing_start_time') ?? '-';
                                    $testingEnd = $r->getForm('testing_end_time') ?? '-';

                                     $start = \Carbon\Carbon::parse($r->start_date);
                                    $end   = \Carbon\Carbon::parse($r->end_date);

                                    $calculatedDays = $start->diffInDays($end) + 1;

                                    if (strtolower($r->getForm('half_day') ?? 'no') === 'yes') {
                                        $calculatedDays = 0.5;
                                    }

                                    $testingTime =
                                        $testingStart !== '-' && $testingEnd !== '-'
                                            ? "{$testingStart} - {$testingEnd}"
                                            : '-';

                                    $testingHours = $r->getForm('testing_hours') ?? '-';
                                    $mobilityHours = $r->getForm('mobility_hours') ?? '-';

                                    $mobility = strtolower($r->getForm('mobility') ?? 'no') === 'yes' ? 'Yes' : 'No';
                                    $personalCar = strtolower($r->getForm('personal_car') ?? 'no') === 'yes' ? 'Yes' : 'No';

                                    $city = $r->getForm('location_city') ?? '-';
                                    $country = $r->getForm('location_country') ?? '-';

                                    $halfDay = strtolower($r->getForm('half_day') ?? 'no') === 'yes' ? 'Yes' : 'No';

                                    $productName = $r->getForm('product_name') ?? '-';

                                    $remark = $r->getForm('remark') ?? '-';
                                @endphp


                                <tr>
                                    <td>
                                        <strong>
                                            {{ $r->overseasResource?->first_name }} {{ $r->overseasResource?->last_name }}
                                        </strong>
                                        <br>
                                        <small class="text-muted">
                                            {{ $r->overseasResource?->professional_email ?? '-' }}
                                        </small>
                                    </td>

                                    <td>{{ $r->created_at?->format('d M Y H:i') }}</td>

                                    <td>
                                        {{ \Carbon\Carbon::parse($r->start_date)->format('d M Y') }}
                                        →
                                        {{ \Carbon\Carbon::parse($r->end_date)->format('d M Y') }}
                                    </td>
                                    
                                    <td>
                                    <span class="badge bg-primary">
                                        {{ $calculatedDays }}
                                    </span>
                                </td>



                                    <td>
                                        <span class="badge bg-info text-white">
                                            {{ ucfirst($r->attendance_type) }}
                                        </span>
                                    </td>

                                    <td>{{ $testingTime }}</td>
                                    <td>{{ $testingHours }}</td>
                                    <td>{{ $mobilityHours }}</td>
                                    <td>{{ $personalCar }}</td>

                                    <td>
                                        @if ($mobility === 'Yes')
                                            <span class="badge bg-success">Yes</span>
                                        @else
                                            <span class="badge bg-secondary">No</span>
                                        @endif
                                    </td>

                                    <td>{{ $city }}</td>
                                    <td>{{ $country }}</td>

                                    <td>
                                        @if ($halfDay === 'Yes')
                                            <span class="badge bg-warning text-dark">Yes</span>
                                        @else
                                            <span class="badge bg-secondary">No</span>
                                        @endif
                                    </td>

                                    <td>
                                        <span class="badge bg-dark">{{ $productName }}</span>
                                    </td>

                                    
                                    <td>
                                        {{ $remark }}
                                    </td>
                                    <td>
                                        {{ $r->overseasResource?->teamDetails?->name ?? '-' }}
                                    </td>


                                    <td>
                                        {{ $r->projectLead?->name ?? '-' }}
                                    </td>

                                    <td>
                                        {{ $r->manager?->name ?? '-' }}
                                    </td>


                                    <td>
                                        @if ($r->status_lead === 'approved')
                                            <span class="badge bg-success">Approved</span>
                                        @elseif($r->status_lead === 'rejected')
                                            <span class="badge bg-danger">Rejected</span>
                                        @else
                                            <span class="badge bg-warning text-dark">Pending</span>
                                        @endif
                                    </td>

                                    <td>
                                        @if ($r->status_manager === 'approved')
                                            <span class="badge bg-success">Approved</span>
                                        @elseif($r->status_manager === 'rejected')
                                            <span class="badge bg-danger">Rejected</span>
                                        @else
                                            <span class="badge bg-warning text-dark">Pending</span>
                                        @endif
                                    </td>

                                    <td>
                                        @if ($r->final_status === 'approved')
                                            <span class="badge bg-success">Approved</span>
                                        @elseif($r->final_status === 'rejected')
                                            <span class="badge bg-danger">Rejected</span>
                                        @else
                                            <span class="badge bg-warning text-dark">Pending</span>
                                        @endif
                                    </td>
                                </tr>

                            @empty
                                <tr>
                                    <td colspan="13" class="text-center text-muted">
                                        No overseas attendance requests found
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>

                    {{ $requests->links('vendor.pagination.no-arrows') }}

                </div>
            </div>

        </div>
    </div>
@endsection

@push('scripts')
    <script>
        $(document).ready(function() {

            $('.select2').select2({
                width: '100%'
            });

            initDataTableWithFilters('OverseasAttendanceRequestsTable');

        });
    </script>
@endpush