@extends(request()->routeIs('admin.*') ? 'layouts.admin' : 'layouts.user')

@section('title', 'Route Margin Report')

@section('content')
    @php
        $routePrefix = request()->routeIs('admin.*') ? 'admin.reports.patroller' : 'reports.patroller';
    @endphp

    <div class="space-y-6">
        <!-- Navigation Tabs -->
        <div class="flex space-x-2 border-b border-gray-200 pb-2 overflow-x-auto">
            <a href="{{ route($routePrefix . '.index') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.index') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                In/Out Report
            </a>
            <a href="{{ route($routePrefix . '.tickets') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.tickets') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                Ticket Reports
            </a>
            <a href="{{ route($routePrefix . '.monthly_tickets') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.monthly_tickets') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                Monthly Ticket Chart
            </a>
            <a href="{{ route($routePrefix . '.payout') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.payout') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                Patroller Payout
            </a>
            <a href="{{ route($routePrefix . '.route_payout') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.route_payout') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                Route Payout
            </a>
            <a href="{{ route($routePrefix . '.route_margin') }}"
                class="px-4 py-2 text-sm font-bold rounded-lg transition-colors {{ request()->routeIs($routePrefix . '.route_margin') ? 'bg-slate-900 text-white' : 'text-slate-600 hover:bg-gray-50' }}">
                Route Margin
            </a>
        </div>

        <!-- Filters -->
        <div class="bg-white p-6 rounded-lg shadow-sm border border-gray-200">
            <h2 class="text-2xl font-bold text-gray-800 mb-6">Route Margin Report</h2>
            
            <form method="GET" action="{{ route($routePrefix . '.route_margin') }}" class="flex items-end gap-4">
                <!-- Start Date -->
                <div class="w-40">
                    <label class="block text-xs font-bold text-gray-600 mb-2 uppercase tracking-wide">Start Date</label>
                    <input type="date" name="start_date" value="{{ request('start_date', now()->startOfMonth()->format('Y-m-d')) }}" 
                        class="w-full text-sm rounded-lg border-gray-300 focus:border-purple-500 focus:ring-purple-500 px-3 py-2 shadow-sm">
                </div>

                <!-- End Date -->
                <div class="w-40">
                    <label class="block text-xs font-bold text-gray-600 mb-2 uppercase tracking-wide">End Date</label>
                    <input type="date" name="end_date" value="{{ request('end_date', now()->format('Y-m-d')) }}" 
                        class="w-full text-sm rounded-lg border-gray-300 focus:border-purple-500 focus:ring-purple-500 px-3 py-2 shadow-sm">
                </div>

                {{-- Report Type Radio Buttons --}}
                <div class="flex-none">
                    <label class="block text-xs font-bold text-gray-600 mb-2 uppercase tracking-wide">Report Type</label>
                    <div class="flex items-center gap-4 h-[38px]">
                        <label class="flex items-center gap-2 cursor-pointer">
                            <input type="radio" name="report_type" value="actual" 
                                {{ request('report_type', 'actual') == 'actual' ? 'checked' : '' }}
                                class="text-purple-600 focus:ring-purple-500">
                            <span class="text-sm text-gray-700">Actual Hours</span>
                        </label>
                        <label class="flex items-center gap-2 cursor-pointer">
                            <input type="radio" name="report_type" value="scheduled" 
                                {{ request('report_type') == 'scheduled' ? 'checked' : '' }}
                                class="text-purple-600 focus:ring-purple-500">
                            <span class="text-sm text-gray-700">Scheduled Hours</span>
                        </label>
                    </div>
                </div>

                <!-- Route Filter -->
                <div class="w-64">
                    <label class="block text-xs font-bold text-gray-600 mb-2 uppercase tracking-wide">Route</label>
                    <select name="route_id" class="w-full text-sm rounded-lg border-gray-300 focus:border-purple-500 focus:ring-purple-500 px-3 py-2 shadow-sm">
                        <option value="">All Routes</option>
                        @foreach($routes as $route)
                            <option value="{{ $route->id }}" {{ request('route_id') == $route->id ? 'selected' : '' }}>
                                {{ $route->name }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <button type="submit" class="h-[38px] px-6 bg-purple-600 text-white text-sm font-medium rounded-lg hover:bg-purple-700 transition-colors shadow-sm">
                    Generate Report
                </button>

                <div class="h-8 w-px bg-gray-200 mx-1"></div>

                <!-- Export Buttons -->
                <div class="flex gap-2">
                    <a href="javascript:void(0)" id="exportRouteMarginExcelBtn"
                       title="Export Excel"
                       class="h-[38px] w-[38px] flex items-center justify-center bg-white border border-gray-300 text-gray-700 rounded-lg hover:bg-gray-50 hover:text-green-600 transition-colors shadow-sm">
                        <svg class="w-5 h-5" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 10v6m0 0l-3-3m3 3l3-3m2 8H7a2 2 0 01-2-2V5a2 2 0 012-2h5.586a1 1 0 01.707.293l5.414 5.414a1 1 0 01.293.707V19a2 2 0 01-2 2z"></path>
                        </svg>
                    </a>
                    <a href="javascript:void(0)" id="exportRouteMarginPdfBtn" title="Export PDF"
                        class="h-[38px] w-[38px] flex items-center justify-center bg-white border border-gray-300 text-gray-700 rounded-lg hover:bg-gray-50 hover:text-red-600 transition-colors shadow-sm">
                        <svg class="w-5 h-5" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2"
                                d="M7 21h10a2 2 0 002-2V9.414a1 1 0 00-.293-.707l-5.414-5.414A1 1 0 0012.586 3H7a2 2 0 00-2 2v14a2 2 0 002 2z">
                            </path>
                        </svg>
                    </a>
                </div>
            </form>
        </div>

        <div class="flex justify-end mb-4">
            <label class="flex items-center gap-2 bg-white px-4 py-2 rounded-lg border border-gray-200 shadow-sm cursor-pointer hover:bg-gray-50 transition-colors">
                <input type="checkbox" id="selectAll" class="rounded border-gray-300 text-purple-600 focus:ring-purple-500">
                <span class="text-sm font-bold text-gray-700">Select All Records</span>
            </label>
        </div>

        <!-- Route Margin Data -->
        @if(count($marginData) > 0)
            @foreach($marginData as $routeId => $data)
                <div class="bg-white rounded-lg shadow-sm border border-gray-200 overflow-hidden mb-6">
                    <!-- Route Header -->
                    <div class="bg-gray-50 px-6 py-4 border-b border-gray-200">
                        <h3 class="text-lg font-bold text-gray-900">{{ $data['route_code'] }} - {{ $data['route_name'] }}</h3>
                    </div>

                    <!-- Employees Table -->
                    <div class="overflow-x-auto">
                        <table class="w-full text-left border-collapse text-xs">
                            <thead class="bg-gray-100 border-b border-gray-200">
                                <tr>
                                    <th class="px-2 py-2 w-8"></th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase tracking-wider">Employee</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase">Duty #</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase">In Time</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase">Out Time</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-center">Total Hrs</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Route Rate</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Total Amt</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase">P. Type</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Sin Rate</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Other Rate</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Gas</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Allowance</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Total</th>
                                    <th class="px-3 py-2 text-[9px] font-bold text-gray-500 uppercase text-right">Margin</th>
                                </tr>
                            </thead>
                            <tbody class="divide-y divide-gray-100">
                                @foreach($data['employees'] as $employee)
                                    <tr class="hover:bg-gray-50">
                                        <td class="px-2 py-2">
                                            <input type="checkbox" name="selected_ids[]" value="{{ $employee['record_id'] }}" class="row-checkbox rounded border-gray-300 text-purple-600 focus:ring-purple-500">
                                        </td>
                                        <td class="px-3 py-2 text-gray-900">{{ $employee['employee_name'] }}</td>
                                        <td class="px-3 py-2 font-mono text-purple-600 font-bold">#{{ $employee['duty_number'] }}</td>
                                        <td class="px-3 py-2 text-gray-600">{{ $employee['in_time'] }}</td>
                                        <td class="px-3 py-2 text-gray-600">{{ $employee['out_time'] }}</td>
                                        <td class="px-3 py-2 text-center font-semibold text-gray-900">{{ $employee['total_hours'] }}</td>
                                        <td class="px-3 py-2 text-right font-semibold text-gray-900">${{ number_format($employee['route_rate'], 2) }}</td>
                                        <td class="px-3 py-2 text-right font-bold text-green-700">${{ number_format($employee['route_total'], 2) }}</td>
                                        <td class="px-3 py-2 text-gray-600 text-[10px]">{{ $employee['payment_type'] }}</td>
                                        <td class="px-3 py-2 text-right text-gray-900">${{ number_format($employee['sin_rate'], 2) }}</td>
                                        <td class="px-3 py-2 text-right text-gray-900">${{ number_format($employee['other_rate'], 2) }}</td>
                                        <td class="px-3 py-2 text-right text-gray-700">${{ number_format($employee['gas'], 2) }}</td>
                                        <td class="px-3 py-2 text-right text-gray-700">${{ number_format($employee['allowance'], 2) }}</td>
                                        <td class="px-3 py-2 text-right font-bold text-blue-700">${{ number_format($employee['total_cost'], 2) }}</td>
                                        <td class="px-3 py-2 text-right font-bold {{ $employee['margin'] >= 0 ? 'text-green-700' : 'text-red-700' }}">${{ number_format($employee['margin'], 2) }}</td>
                                    </tr>
                                @endforeach
                                <!-- Route Total Row -->
                                <tr class="bg-blue-50 font-bold">
                                    <td colspan="5" class="px-3 py-2 text-right text-gray-900">Route Total:</td>
                                    <td class="px-3 py-2 text-center text-gray-900">{{ $data['total_hours'] }}</td>
                                    <td class="px-3 py-2 text-right"></td>
                                    <td class="px-3 py-2 text-right text-green-700">${{ number_format($data['route_total'], 2) }}</td>
                                    <td></td>
                                    <td colspan="4"></td>
                                    <td class="px-3 py-2 text-right text-blue-700">${{ number_format($data['total_cost'], 2) }}</td>
                                    <td class="px-3 py-2 text-right {{ $data['total_margin'] >= 0 ? 'text-green-700' : 'text-red-700' }}">${{ number_format($data['total_margin'], 2) }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            @endforeach
        @else
            <div class="bg-white rounded-lg shadow-sm border border-gray-200 p-12 text-center">
                <p class="text-gray-400 text-sm font-bold uppercase tracking-wider">No margin data found for the selected period</p>
            </div>
        @endif
    </div>

    <!-- Select2 CSS -->
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
    
    <!-- Select2 JS -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    
    <script>
        $(document).ready(function() {
            $('select[name="route_id"]').select2({
                placeholder: 'All Routes',
                allowClear: true,
                width: '100%'
            });

            // Select All functionality
            $('#selectAll').on('change', function() {
                $('.row-checkbox').prop('checked', $(this).prop('checked'));
            });

            $('.row-checkbox').on('change', function() {
                if (!$(this).prop('checked')) $('#selectAll').prop('checked', false);
                if ($('.row-checkbox:checked').length === $('.row-checkbox').length) $('#selectAll').prop('checked', true);
            });

            function handleExport(isExcel) {
                let selectedIds = [];
                $('.row-checkbox:checked').each(function() {
                    selectedIds.push($(this).val());
                });

                let baseUrl = isExcel 
                    ? "{{ route($routePrefix . '.route_margin.export') }}" 
                    : "{{ route($routePrefix . '.route_margin.export.pdf') }}";
                let params = new URLSearchParams(window.location.search);
                if (selectedIds.length > 0) params.set('ids', selectedIds.join(','));
                window.location.href = baseUrl + '?' + params.toString();
            }

            // Handle Export PDF
            $('#exportRouteMarginPdfBtn').on('click', function() {
                handleExport(false);
            });

            // Handle Export Excel
            $('#exportRouteMarginExcelBtn').on('click', function() {
                handleExport(true);
            });
        });
    </script>
@endsection