@extends('layouts.user_type.auth')

@section('content')
<style>
    table td.wrapped-text {
        white-space: normal !important;
        word-break: break-word !important;
        max-width: 250px;
    }
</style>

<div class="container-fluid">
    <form method="GET" action="{{ route('attendance.employee-location') }}" class="d-flex flex-wrap justify-content-between align-items-end mb-4 gap-3">
        <div>
            <h4>Employee Attendance - {{ \Carbon\Carbon::parse($startDate)->format('d M Y') }} to {{ \Carbon\Carbon::parse($endDate)->format('d M Y') }}</h4>
        </div>
        <div class="d-flex gap-3 align-items-end flex-wrap">
            <div style="margin-bottom: 1rem;">
                <label for="start_date" class="form-label">Start Date</label>
                <input type="date" name="start_date" id="start_date"
                value="{{ request('start_date', \Carbon\Carbon::parse($startDate)->format('Y-m-d')) }}"
                class="form-control" required>
            </div>
            <div style="margin-bottom: 1rem;">
                <label for="end_date" class="form-label">End Date</label>
                <input type="date" name="end_date" id="end_date"
                value="{{ request('end_date', \Carbon\Carbon::parse($endDate)->format('Y-m-d')) }}"
                class="form-control" required>
            </div>
            <div style="margin-bottom: 1rem;">
                <label for="employee_id" class="form-label">Employee</label>
                <select name="employee_id" id="employee_id" class="form-control">
                    <option value="">All Employees</option>
                    @foreach($allEmployees as $emp)
                        <option value="{{ $emp->id }}" {{ request('employee_id') == $emp->id ? 'selected' : '' }}>
                            {{ $emp->name ?? $emp->first_name . ' ' . $emp->middle_name . ' ' . $emp->last_name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div>
                <button type="submit" class="btn btn-primary mt-2">View</button>
            </div>
        </div>
    </form>
    <a 
        href="{{ route('attendance.exportEmployeeAttendance', [
            'start_date' => request('start_date'),
            'end_date' => request('end_date'),
            'employee_id' => request('employee_id'),
        ]) }}"
        class="btn btn-success"
        target="_blank"
    >
        📥 Export Attendance
    </a>
    <div class="table-responsive">
        <table class="table table-bordered text-center">
            <thead class="thead-dark">
                <tr>
                    <th>Employee</th>
                    <th>Date</th>
                    <th>Check-in Time</th>
                    <th>Check-out Time</th>
                    <th>Check-in Status</th>
                    <th>Check-out Status</th>
                    <th>Check-in Address</th>
                    <th>Check-out Address</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $hasData = false;
                    $officeLocations = [
                        ['lat' => 19.88872063745518, 'lng' => 75.36867925450616, 'name' => 'Aurangabad Office'],
                        ['lat' => 19.065966468569965, 'lng' => 72.99926801031167, 'name' => 'Mumbai Office'],
                        ['lat' => 18.59007007542511, 'lng' => 73.74808194495957, 'name' => 'Pune Office'],
                    ];

                    function getDistanceAndStatus($latLng, $offices, $radius = 300) {
                        if (!$latLng || !str_contains($latLng, ',')) return ['status' => 'N/A', 'distance' => null];

                        [$lat1, $lon1] = explode(',', $latLng);
                        $lat1 = floatval($lat1);
                        $lon1 = floatval($lon1);
                        $earthRadius = 6371000;

                        $closestDistance = null;
                        foreach ($offices as $office) {
                            $lat2 = $office['lat'];
                            $lon2 = $office['lng'];
                            $dLat = deg2rad($lat2 - $lat1);
                            $dLon = deg2rad($lon2 - $lon1);
                            $a = sin($dLat/2) ** 2 +
                                 cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * sin($dLon/2) ** 2;
                            $c = 2 * atan2(sqrt($a), sqrt(1 - $a));
                            $distance = $earthRadius * $c;

                            if (is_null($closestDistance) || $distance < $closestDistance) {
                                $closestDistance = $distance;
                            }
                        }

                        $status = ($closestDistance <= $radius) ? 'Inside Office' : 'Outside Office';
                        return ['status' => $status, 'distance' => round($closestDistance)];
                    }
                @endphp

                @foreach ($employees as $employee)
                    @foreach ($employee->attendances as $attendance)
                        @php $hasData = true; @endphp
                        <tr>
                            <td>
                                {{ $employee->name ?? ($employee->first_name . ($employee->middle_name ? ' ' . $employee->middle_name : '') . ' ' . $employee->last_name) }}
                            </td>
                            <td>{{ \Carbon\Carbon::parse($attendance->check_in)->format('d M Y') }}</td>
                            <td>{{ \Carbon\Carbon::parse($attendance->check_in)->setTimezone('Asia/Kolkata')->format('h:i A') }}</td>
                            <td>{{ $attendance->check_out ? \Carbon\Carbon::parse($attendance->check_out)->setTimezone('Asia/Kolkata')->format('h:i A') : '-' }}</td>

                            @php $checkin = getDistanceAndStatus($attendance->check_in_location, $officeLocations); @endphp
                            <td>
                                <span class="badge {{ $checkin['status'] === 'Inside Office' ? 'bg-success' : 'bg-danger' }}">
                                    {{ $checkin['status'] }}
                                </span>
                                @if ($checkin['distance'])
                                    <div class="text-muted small">({{ $checkin['distance'] }} m)</div>
                                @endif
                            </td>

                            @php $checkout = getDistanceAndStatus($attendance->check_out_location, $officeLocations); @endphp
                            <td>
                                <span class="badge {{ $checkout['status'] === 'Inside Office' ? 'bg-success' : 'bg-danger' }}">
                                    {{ $checkout['status'] }}
                                </span>
                                @if ($checkout['distance'])
                                    <div class="text-muted small">({{ $checkout['distance'] }} m)</div>
                                @endif
                            </td>
                            <td class="wrapped-text">{{ $attendance->check_in_address ?? '-' }}</td>
                            <td class="wrapped-text">{{ $attendance->check_out_address ?? '-' }}</td>
                        </tr>
                    @endforeach
                @endforeach

                @if (!$hasData)
                    <tr>
                        <td colspan="8" class="text-muted py-4">No attendance data found for the selected date range.</td>
                    </tr>
                @endif
            </tbody>
        </table>
        <div class="card-footer py-4">
            <div class="d-flex justify-content-between">
                <div>
                    Showing {{ $employees->firstItem() }} to {{ $employees->lastItem() }} of {{ $employees->total() }} results
                </div>
                <div>
                    {{ $employees->appends(request()->query())->links('vendor.pagination.bootstrap-4') }}
                </div>
            </div>
        </div>
    </div>
</div>
@endsection