@php use App\Models\Staff;use Carbon\Carbon; @endphp
@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Attendance Report')
@section('content')
    <style>
        .select2-selection__rendered {
            line-height: 31px !important;
        }

        .select2-container .select2-selection--single {
            height: 35px !important;
        }

        .select2-selection__arrow {
            height: 34px !important;
        }

        .ar-card {
            border: 0;
            border-radius: 0.5rem;
            box-shadow: 0 0.125rem 0.5rem rgba(0, 0, 0, 0.06);
        }

        .ar-card .card-header {
            background: #fff;
            border-bottom: 1px solid rgba(0, 0, 0, 0.06);
            padding: 1rem 1.25rem;
        }

        .ar-card .card-body {
            padding: 1.25rem;
        }

        .ar-filter label {
            display: block;
            font-size: 0.75rem;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.04em;
            color: #5f6368;
            margin-bottom: 0.25rem;
        }

        .ar-table thead th {
            font-size: 0.8125rem;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.02em;
            color: #5f6368;
            border-top: 0;
            white-space: nowrap;
            vertical-align: middle;
        }

        .ar-table tbody td {
            vertical-align: middle;
        }

        @media print {
            .ar-card {
                box-shadow: none !important;
            }
        }

        .ar-grid-table th,
        .ar-grid-table td{
            padding: 6px 6px !important;
        }
        .ar-grid-table .cell{
            text-align: center;
            font-weight: 700;
            font-variant-numeric: tabular-nums;
            width: 28px;
            min-width: 28px;
        }
        .ar-grid-table .cell.p{ color:#166534; background: rgba(34,197,94,.10); }
        .ar-grid-table .cell.l{ color:#92400e; background: rgba(245,158,11,.12); }
        .ar-grid-table .cell.a{ color:#991b1b; background: rgba(239,68,68,.10); }
        .ar-grid-table .cell.h{ color:#1d4ed8; background: rgba(59,130,246,.10); }
        .ar-grid-table .cell.w{ color:#374151; background: rgba(107,114,128,.10); }
        .ar-grid-table .cell.lv{ color:#0f172a; background: rgba(15,23,42,.06); }
        .ar-grid-table .cell.hl{ color:#0f172a; background: rgba(15,23,42,.10); }

        @media print {
            /* For matrix reports, use landscape */
            @page { size: A4 landscape; }
            .ar-grid-table { font-size: 10px; }
        }
    </style>
    <div class="row">
        <div class="col-md-12 col-lg-12 col-xl-10 mx-auto">
            <div class="card ar-card no-print">
                <div class="card-header">
                    <h5 class="mb-0">{{ __('Attendance Report') }}</h5>
                </div>
                <div class="card-body">
                    <form action="" method="GET">
                        <div class="form-row align-items-end ar-filter">
                            <div class="form-group col-12 col-md-4 mb-2 mb-md-0">
                                <label for="ar_report">{{ __('Report Type') }}</label>
                                <select id="ar_report" name="report" class="form-control select2">
                                    <option value="staff" @selected(($report ?? 'staff') === 'staff')>{{ __('Staff Wise (Monthly)') }}</option>
                                    <option value="department_grid" @selected(($report ?? '') === 'department_grid')>{{ __('Department Wise (Monthly Grid)') }}</option>
                                    <option value="branch_grid" @selected(($report ?? '') === 'branch_grid')>{{ __('Branch Wise (Monthly Grid)') }}</option>
                                    <option value="department_summary" @selected(($report ?? '') === 'department_summary')>{{ __('Department Wise (Monthly Summary)') }}</option>
                                    <option value="branch_summary" @selected(($report ?? '') === 'branch_summary')>{{ __('Branch Wise (Monthly Summary)') }}</option>
                                    <option value="date" @selected(($report ?? '') === 'date')>{{ __('Specific Date Wise') }}</option>
                                </select>
                            </div>

                            <div class="form-group col-6 col-md-2 mb-2 mb-md-0">
                                <label for="ar_year">{{ __('Year') }}</label>
                                <select id="ar_year" name="year" class="form-control select2">
                                    <option value="">{{ __('Year') }}</option>
                                    @for($i = 2010; $i <= date('Y'); $i++)
                                        <option value="{{ $i }}" @selected((string)($year ?? '') === (string)$i || (empty($year) && $i == date('Y')))>{{ $i }}</option>
                                    @endfor
                                </select>
                            </div>

                            <div class="form-group col-6 col-md-2 mb-2 mb-md-0">
                                <label for="ar_month">{{ __('Month') }}</label>
                                <select id="ar_month" name="month" class="form-control select2">
                                    <option value="">{{ __('Month') }}</option>
                                    @foreach(range(1, 12) as $m)
                                        <option value="{{ $m }}" @selected((string)($month ?? '') === (string)$m || (empty($month) && date('m') == $m))>
                                            {{ date('F', mktime(0, 0, 0, $m, 1)) }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="form-group col-12 col-md-4 mb-2 mb-md-0">
                                <label for="ar_staff">{{ __('Staff') }}</label>
                                <select id="ar_staff" name="staff_id" class="form-control select2">
                                    <option value="">{{ __('Select Staff') }}</option>
                                    @foreach(\App\Models\Staff::all() as $staff)
                                        @if($staff->user->is_active)
                                            <option value="{{ $staff->id }}" @selected((string)request()->staff_id === (string)$staff->id)>
                                                {{ $staff->user->name }} ({{ $staff->user->id }})
                                            </option>
                                        @endif
                                    @endforeach
                                </select>
                                <small class="text-muted d-block mt-1">{{ __('For Staff Wise Report Only') }}</small>
                            </div>

                            <div class="form-group col-6 col-md-3 mt-2">
                                <label for="ar_branch">{{ __('Branch') }}</label>
                                <select id="ar_branch" name="branch_id" class="form-control select2">
                                    <option value="">{{ __('All branches') }}</option>
                                    @foreach($branches ?? [] as $b)
                                        <option value="{{ $b->id }}" @selected((string)request('branch_id') === (string)$b->id)>{{ $b->name }}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="form-group col-6 col-md-3 mt-2">
                                <label for="ar_department">{{ __('Department') }}</label>
                                <select id="ar_department" name="department_id" class="form-control select2">
                                    <option value="">{{ __('All departments') }}</option>
                                    @foreach($departments ?? [] as $d)
                                        <option value="{{ $d->id }}" @selected((string)request('department_id') === (string)$d->id)>{{ $d->name }}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="form-group col-6 col-md-3 mt-2">
                                <label for="ar_date">{{ __('Date') }}</label>
                                <input id="ar_date" type="date" name="date" class="form-control" value="{{ request('date') }}">
                                <small class="text-muted d-block mt-1">{{ __('For Specific Date Wise Only') }}</small>
                            </div>

                            <div class="form-group col-12 col-md-3 mt-2 mb-0 d-flex flex-wrap" style="gap: 0.5rem;">
                                <button type="submit" class="btn btn-primary">
                                    <i class="las la-filter"></i> {{ __('Filter') }}
                                </button>
                                <a href="{{ route('attendance.report') }}" class="btn btn-outline-secondary">
                                    <i class="las la-undo"></i> {{ __('Reset') }}
                                </a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    {{-- ---------- STAFF WISE MONTHLY (Printable) ---------- --}}
    @if(($report ?? 'staff') === 'staff' && ($year && $month && $staff_details))
        <div class="card ar-card col-md-12 col-lg-12 col-xl-10 mx-auto mb-2">
            <div class="card-header row gutters-5">
                <div class="col">
                    @if(get_setting('system_logo_white'))
                        <img class="mw-100 brand-icon" src="{{ asset('storage/' . get_setting('system_logo_white')) }}"
                             alt="{{ get_setting('site_name') }}">
                    @endif
                </div>
                <div class="col">
                    <h5>{{ get_setting('site_name') }}</h5>
                    {{ optional($staff_details->warehouse)->address }}
                </div>
                <div class="col text-right no-print">
                    <button type="button" class="btn btn-sm btn-primary" onclick="window.print()">
                        <i class="las la-print"></i> {{ __('Print') }}
                    </button>
                    <a class="btn btn-sm btn-outline-secondary ml-2"
                       href="{{ route('attendance.report.export', request()->query()) }}">
                        <i class="las la-download"></i> {{ __('Export CSV') }}
                    </a>
                </div>
            </div>
            <div class="card-body">
                <h5 class="text-center mb-2">
                    Attendance Report On {{ Carbon::create($year, $month, 1)->format('F') }} - {{ $year }}
                </h5>
                <table class="table table-bordered mb-3">
                    <tbody>
                    <tr>
                        <th>Employee Code</th>
                        <td>0{{ optional($staff_details->user)->id }}</td>
                        <th>Designation</th>
                        <td>{{ optional($staff_details->designation)->name ?? '-' }}</td>
                    </tr>
                    <tr>
                        <th>Employee Name</th>
                        <td>{{ optional($staff_details->user)->name }}</td>
                        <th>Warehouse/Branch</th>
                        <td>{{ optional($staff_details->warehouse)->name }}</td>
                    </tr>
                    </tbody>
                </table>
                <table class="table table-bordered ar-table mb-0">
                    <thead>
                    <tr>
                        <th>Date</th>
                        <th>Status</th>
                        <th>In Time</th>
                        <th>Out Time</th>
                        <th>Remarks</th>
                    </tr>
                    </thead>
                    <tbody>
                    @for($day = 1; $day <= Carbon::create($year, $month, 1)->daysInMonth; $day++)
                        @php
                            $currentDate = Carbon::create($year, $month, $day)->format('Y-m-d');
                            $foundStatus = false;
                        @endphp
                        <tr>
                            <td>{{ $currentDate }} ({{ date('l', strtotime($currentDate)) }})</td>
                            <td class="text-center">
                                @foreach($salesData as $sale)
                                    @if($sale->date == $currentDate)
                                        {{ $sale->status }}
                                        @php $foundStatus = true; @endphp
                                    @endif
                                @endforeach

                                @foreach($holiday_data as $sale)
                                    @if($sale == $currentDate)
                                        {{ __('H') }}
                                        @php $foundStatus = true; @endphp
                                    @endif
                                @endforeach
                                @foreach($half_leaves as $half)
                                    @if($half == $currentDate)
                                        {{ __('Half Leave') }}
                                        @php $foundStatus = true; @endphp
                                    @endif
                                @endforeach
                                @foreach($weekend_data as $weekend)
                                    @if(date('l', strtotime($currentDate)) == $weekend)
                                        {{ __('W') }}
                                        @php $foundStatus = true; @endphp
                                    @endif
                                @endforeach
                                @foreach($leave_data as $leave)
                                    @if($leave == $currentDate)
                                        {{ __('L') }}
                                        @php $foundStatus = true; @endphp
                                    @endif
                                @endforeach
                                @if(!$foundStatus)
                                    {{ __('A') }}
                                @endif
                            </td>
                            <td>
                                @foreach($salesData as $sale)
                                    @if($sale->date == $currentDate && $sale->status != 'L')
                                        {{date('h:i A',strtotime($sale->signIn))}}
                                    @endif
                                @endforeach
                            </td>
                            <td>
                                @foreach($salesData as $sale)
                                    @if($sale->date == $currentDate && $sale->status != 'L')
                                        {{date('h:i A',strtotime($sale->signOut))}}
                                    @endif
                                @endforeach
                            </td>
                            <td> @foreach($salesData as $sale)

                                    @if(Carbon::create($year,$month,$day)->format('Y-m-d')==$sale->date)
                                        {!! $sale->remarks !!}
                                    @endif

                                @endforeach</td>
                        </tr>
                    @endfor
                    </tbody>
                </table>
            </div>
        </div>
    @endif

    {{-- ---------- Department Wise / Branch Wise (Monthly Summary) ---------- --}}
    @if((($report ?? '') === 'department_summary' || ($report ?? '') === 'branch_summary') && !empty($monthly))
        <div class="card ar-card col-md-12 col-lg-12 col-xl-11 mx-auto mt-3">
            <div class="card-header row gutters-5">
                <div class="col">
                    @if(get_setting('system_logo_white'))
                        <img class="mw-100 brand-icon" src="{{ asset('storage/' . get_setting('system_logo_white')) }}"
                             alt="{{ get_setting('site_name') }}">
                    @endif
                </div>
                <div class="col">
                    <h5 class="mb-0">{{ get_setting('site_name') }}</h5>
                    <div class="text-muted small">
                        {{ __('Monthly Attendance Summary') }} — {{ Carbon::create($monthly['year'], $monthly['month'], 1)->format('F') }} {{ $monthly['year'] }}
                    </div>
                </div>
                <div class="col text-right no-print">
                    <button type="button" class="btn btn-sm btn-primary" onclick="window.print()">
                        <i class="las la-print"></i> {{ __('Print') }}
                    </button>
                    <a class="btn btn-sm btn-outline-secondary ml-2"
                       href="{{ route('attendance.report.export', request()->query()) }}">
                        <i class="las la-download"></i> {{ __('Export CSV') }}
                    </a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered ar-table mb-0">
                        <thead>
                        <tr>
                            <th>#</th>
                            <th>{{ __('Employee') }}</th>
                            <th>{{ __('Department') }}</th>
                            <th>{{ __('Branch') }}</th>
                            <th class="text-center">{{ __('Present') }}</th>
                            <th class="text-center">{{ __('Late') }}</th>
                            <th class="text-center">{{ __('Absent') }}</th>
                            <th class="text-center">{{ __('Leave') }}</th>
                            <th class="text-center">{{ __('Half leave') }}</th>
                            <th class="text-center">{{ __('Holiday') }}</th>
                            <th class="text-center">{{ __('Weekend') }}</th>
                            <th class="text-center">{{ __('Total') }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @forelse($monthly['rows'] as $k => $r)
                            <tr>
                                <td>{{ $k+1 }}</td>
                                <td>{{ optional($r['staff']->user)->name }} ({{ $r['staff']->user_id ?? optional($r['staff']->user)->id }})</td>
                                <td>{{ optional($r['staff']->department)->name ?? '—' }}</td>
                                <td>{{ optional($r['staff']->warehouse)->name ?? '—' }}</td>
                                <td class="text-center">{{ $r['present'] }}</td>
                                <td class="text-center">{{ $r['late'] }}</td>
                                <td class="text-center">{{ $r['absent'] }}</td>
                                <td class="text-center">{{ $r['leave'] }}</td>
                                <td class="text-center">{{ $r['half'] }}</td>
                                <td class="text-center">{{ $r['holiday'] }}</td>
                                <td class="text-center">{{ $r['weekend'] }}</td>
                                <td class="text-center">{{ $r['total_days'] }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="12" class="text-center text-muted py-3">{{ __('No records found') }}</td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif

    {{-- ---------- Department Wise / Branch Wise (Monthly Grid) ---------- --}}
    @if((($report ?? '') === 'department_grid' || ($report ?? '') === 'branch_grid') && !empty($monthlyGrid))
        <div class="card ar-card col-md-12 col-lg-12 col-xl-12 mx-auto mt-3">
            <div class="card-header row gutters-5">
                <div class="col">
                    <h5 class="mb-0">{{ __('Monthly Attendance Grid') }}</h5>
                    <div class="text-muted small">
                        {{ Carbon::create($monthlyGrid['year'], $monthlyGrid['month'], 1)->format('F') }} {{ $monthlyGrid['year'] }}
                        — {{ __('Legend') }}: P={{__('Present')}}, L={{__('Late')}}, A={{__('Absent')}}, H={{__('Holiday')}}, W={{__('Weekend')}}, LV={{__('Leave')}}, HL={{__('Half Leave')}}
                    </div>
                </div>
                <div class="col text-right no-print">
                    <button type="button" class="btn btn-sm btn-primary" onclick="window.print()">
                        <i class="las la-print"></i> {{ __('Print') }}
                    </button>
                    <a class="btn btn-sm btn-outline-secondary ml-2"
                       href="{{ route('attendance.report.export', request()->query()) }}">
                        <i class="las la-download"></i> {{ __('Export CSV') }}
                    </a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered ar-table ar-grid-table mb-0">
                        <thead>
                        <tr>
                            <th>#</th>
                            <th>{{ __('Employee') }}</th>
                            <th>{{ __('Department') }}</th>
                            <th>{{ __('Branch') }}</th>
                            @foreach($monthlyGrid['dayNumbers'] as $d)
                                <th class="cell">{{ $d }}</th>
                            @endforeach
                            <th class="text-center">{{ __('P') }}</th>
                            <th class="text-center">{{ __('L') }}</th>
                            <th class="text-center">{{ __('A') }}</th>
                            <th class="text-center">{{ __('LV') }}</th>
                            <th class="text-center">{{ __('HL') }}</th>
                            <th class="text-center">{{ __('H') }}</th>
                            <th class="text-center">{{ __('W') }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @forelse($monthlyGrid['rows'] as $k => $r)
                            <tr>
                                <td>{{ $k+1 }}</td>
                                <td>{{ optional($r['staff']->user)->name }} ({{ $r['staff']->user_id ?? optional($r['staff']->user)->id }})</td>
                                <td>{{ optional($r['staff']->department)->name ?? '—' }}</td>
                                <td>{{ optional($r['staff']->warehouse)->name ?? '—' }}</td>
                                @foreach($r['cells'] as $c)
                                    @php
                                        $cls = strtolower($c);
                                        if ($cls === 'p') $cls = 'p';
                                        elseif ($cls === 'l') $cls = 'l';
                                        elseif ($cls === 'a') $cls = 'a';
                                        elseif ($cls === 'h') $cls = 'h';
                                        elseif ($cls === 'w') $cls = 'w';
                                        elseif ($cls === 'lv') $cls = 'lv';
                                        elseif ($cls === 'hl') $cls = 'hl';
                                        else $cls = '';
                                    @endphp
                                    <td class="cell {{ $cls }}">{{ $c }}</td>
                                @endforeach
                                <td class="text-center">{{ $r['totals']['P'] }}</td>
                                <td class="text-center">{{ $r['totals']['L'] }}</td>
                                <td class="text-center">{{ $r['totals']['A'] }}</td>
                                <td class="text-center">{{ $r['totals']['LV'] }}</td>
                                <td class="text-center">{{ $r['totals']['HL'] }}</td>
                                <td class="text-center">{{ $r['totals']['H'] }}</td>
                                <td class="text-center">{{ $r['totals']['W'] }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="{{ 4 + ($monthlyGrid['daysInMonth'] ?? 31) + 7 }}" class="text-center text-muted py-3">
                                    {{ __('No records found') }}
                                </td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif

    {{-- ---------- Specific Date Wise ---------- --}}
    @if((($report ?? '') === 'date') && !empty($daily))
        <div class="card ar-card col-md-12 col-lg-12 col-xl-11 mx-auto mt-3">
            <div class="card-header row gutters-5">
                <div class="col">
                    @if(get_setting('system_logo_white'))
                        <img class="mw-100 brand-icon" src="{{ asset('storage/' . get_setting('system_logo_white')) }}"
                             alt="{{ get_setting('site_name') }}">
                    @endif
                </div>
                <div class="col">
                    <h5 class="mb-0">{{ get_setting('site_name') }}</h5>
                    <div class="text-muted small">
                        {{ __('Specific Date Wise Attendance Report') }} — {{ $daily['date'] }} ({{ date('l', strtotime($daily['date'])) }})
                    </div>
                </div>
                <div class="col text-right no-print">
                    <button type="button" class="btn btn-sm btn-primary" onclick="window.print()">
                        <i class="las la-print"></i> {{ __('Print') }}
                    </button>
                    <a class="btn btn-sm btn-outline-secondary ml-2"
                       href="{{ route('attendance.report.export', request()->query()) }}">
                        <i class="las la-download"></i> {{ __('Export CSV') }}
                    </a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered ar-table mb-0">
                        <thead>
                        <tr>
                            <th>#</th>
                            <th>{{ __('Employee') }}</th>
                            <th>{{ __('Department') }}</th>
                            <th>{{ __('Branch') }}</th>
                            <th class="text-center">{{ __('Status') }}</th>
                            <th class="text-center">{{ __('In') }}</th>
                            <th class="text-center">{{ __('Out') }}</th>
                            <th>{{ __('Remarks') }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @forelse($daily['rows'] as $k => $r)
                            <tr>
                                <td>{{ $k+1 }}</td>
                                <td>{{ optional($r['staff']->user)->name }} ({{ $r['staff']->user_id ?? optional($r['staff']->user)->id }})</td>
                                <td>{{ optional($r['staff']->department)->name ?? '—' }}</td>
                                <td>{{ optional($r['staff']->warehouse)->name ?? '—' }}</td>
                                <td class="text-center">{{ $r['status'] }}</td>
                                <td class="text-center">{{ $r['signIn'] ? date('h:i A', strtotime($r['signIn'])) : '—' }}</td>
                                <td class="text-center">{{ $r['signOut'] ? date('h:i A', strtotime($r['signOut'])) : '—' }}</td>
                                <td>{!! $r['remarks'] ?? '—' !!}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center text-muted py-3">{{ __('No Records Found') }}</td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif
@endsection


@section('script')

@endsection