@php use Carbon\Carbon; @endphp
@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | Attendance Report')
@push('css')
    <link href="{{ asset('assets/plugins/summernote/summernote-bs4.css') }}" rel="stylesheet"/>
@endpush

@section('content')
    <style>
        .ar-wrap .card { border-radius: 14px; border: 1px solid #edf0f6; box-shadow: 0 0.125rem 0.5rem rgba(15, 23, 42, 0.04); }
        .ar-wrap .card-header { background: #fff; border-bottom: 1px solid #edf0f6; font-weight: 700; }
        .ar-filters { background: #f8fafc; border-bottom: 1px solid #edf0f6; padding: 14px 16px; }
        .ar-filters label, .ar-wrap .ar-label { font-weight: 700; font-size: 12px; text-transform: uppercase; letter-spacing: .06em; color: rgba(15,23,42,.55); margin-bottom: 6px; }
        .ar-wrap .select2-container { width: 100% !important; }
        .ar-wrap .select2-selection__rendered { line-height: 31px !important; }
        .ar-wrap .select2-container .select2-selection--single { height: 38px !important; }
        .ar-stat { background: #fff; border: 1px solid #edf0f6; border-radius: 10px; padding: 10px 14px; text-align: center; height: 100%; }
        .ar-stat .num { font-size: 1.25rem; font-weight: 800; line-height: 1.2; }
        .ar-stat .lbl { font-size: 11px; text-transform: uppercase; letter-spacing: .06em; color: #64748b; }
        .ar-table thead th { font-size: 11px; text-transform: uppercase; letter-spacing: .08em; color: rgba(15,23,42,.65); border-top: 0; white-space: nowrap; vertical-align: middle; }
        .ar-table tbody td { vertical-align: middle; }
        .ar-staff-cell { font-weight: 600; }
        .ar-badge { display: inline-flex; align-items: center; padding: 4px 10px; border-radius: 999px; font-size: 11px; font-weight: 800; min-width: 34px; justify-content: center; }
        .ar-badge.p, .ar-badge.present { background: rgba(34,197,94,.12); color: #166534; }
        .ar-badge.l, .ar-badge.late { background: rgba(245,158,11,.12); color: #b45309; }
        .ar-badge.a, .ar-badge.absent { background: rgba(239,68,68,.12); color: #991b1b; }
        .ar-badge.h, .ar-badge.holiday { background: rgba(59,130,246,.12); color: #1d4ed8; }
        .ar-badge.w, .ar-badge.weekend { background: rgba(107,114,128,.12); color: #374151; }
        .ar-badge.lv, .ar-badge.leave { background: rgba(15,23,42,.08); color: #0f172a; }
        .ar-badge.hl, .ar-badge.half { background: rgba(15,23,42,.12); color: #0f172a; }
        .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); }
        .ar-report-head { background: #f8fafc; border: 1px solid #edf0f6; border-radius: 12px; padding: 14px 16px; margin-bottom: 16px; }
        @media print {
            .no-print { display: none !important; }
            .ar-wrap .card { box-shadow: none !important; border: none !important; }
        }
    </style>

    <div class="container-fluid ar-wrap">
        <div class="row mt-3">
            <div class="col-12 d-flex flex-wrap justify-content-between align-items-center mb-3 no-print">
                <div>
                    <h4 class="page-title mb-0">{{ __('Attendance Report') }}</h4>
                    <p class="text-muted mb-0">{{ __('Staff, department, branch, and date-wise attendance reporting with export.') }}</p>
                </div>
            </div>

            <div class="col-12 mb-3 no-print">
                <div class="card">
                    <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
                        <span>{{ __('Filters') }}</span>
                        <a href="{{ route('attendance.report') }}" class="btn btn-sm btn-outline-secondary">{{ __('Clear Filters') }}</a>
                    </div>
                    <form action="{{ route('attendance.report') }}" method="GET">
                        <div class="ar-filters">
                            <div class="form-row align-items-end">
                                <div class="form-group col-12 col-lg-4">
                                    <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">
                                    <label for="ar_year">{{ __('Year') }}</label>
                                    <select id="ar_year" name="year" class="form-control select2">
                                        @for($i = 2010; $i <= date('Y'); $i++)
                                            <option value="{{ $i }}" @selected((string) ($year ?? '') === (string) $i)>{{ $i }}</option>
                                        @endfor
                                    </select>
                                </div>
                                <div class="form-group col-6 col-md-2">
                                    <label for="ar_month">{{ __('Month') }}</label>
                                    <select id="ar_month" name="month" class="form-control select2">
                                        @foreach(range(1, 12) as $m)
                                            <option value="{{ $m }}" @selected((string) ($month ?? '') === (string) $m)>
                                                {{ date('F', mktime(0, 0, 0, $m, 1)) }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="form-group col-12 col-lg-4">
                                    <label for="ar_staff">{{ __('Employee') }}</label>
                                    <select id="ar_staff" name="staff_id" class="form-control select2">
                                        <option value="">{{ __('Select employee') }}</option>
                                        @foreach($staffList ?? [] as $staff)
                                            <option value="{{ $staff->id }}" @selected((string) request('staff_id') === (string) $staff->id)>
                                                {{ $staff->user?->name ?? __('Unknown') }}({{ $staff->user_id }})-{{ $staff->designation?->name ?? 'No Designation' }}
                                            </option>
                                        @endforeach
                                    </select>
                                    <small class="text-muted">{{ __('Staff wise report only') }}</small>
                                </div>
                                <div class="form-group col-6 col-md-3">
                                    <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">
                                    <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">
                                    <label for="ar_date">{{ __('Date') }}</label>
                                    <input id="ar_date" type="date" name="date" class="form-control" value="{{ request('date') }}">
                                    <small class="text-muted">{{ __('Specific date report only') }}</small>
                                </div>
                                <div class="form-group col-6 col-md-3">
                                    <button type="submit" class="btn btn-primary btn-block"><i class="las la-filter"></i> {{ __('Generate') }}</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            @if(!empty($reportStats))
                <div class="col-12 mb-3 no-print">
                    <div class="form-row">
                        <div class="col-6 col-md-3 mb-2"><div class="ar-stat"><div class="num text-primary">{{ (int) ($reportStats['staff_count'] ?? 0) }}</div><div class="lbl">{{ __('Staff') }}</div></div></div>
                        <div class="col-6 col-md-3 mb-2"><div class="ar-stat"><div class="num text-success">{{ (int) ($reportStats['present'] ?? 0) }}</div><div class="lbl">{{ __('Present') }}</div></div></div>
                        <div class="col-6 col-md-3 mb-2"><div class="ar-stat"><div class="num text-warning">{{ (int) ($reportStats['late'] ?? 0) }}</div><div class="lbl">{{ __('Late') }}</div></div></div>
                        <div class="col-6 col-md-3 mb-2"><div class="ar-stat"><div class="num text-danger">{{ (int) ($reportStats['absent'] ?? 0) }}</div><div class="lbl">{{ __('Absent') }}</div></div></div>
                    </div>
                </div>
            @endif

            @if(($report ?? 'staff') === 'staff' && ! $staffReport)
                <div class="col-12 mb-3">
                    <div class="alert alert-info mb-0">{{ __('Select an employee, year, and month, then click Generate to view the staff monthly report.') }}</div>
                </div>
            @endif

            @if(($report ?? '') === 'date' && empty($daily))
                <div class="col-12 mb-3">
                    <div class="alert alert-info mb-0">{{ __('Select a specific date and click Generate to view the daily attendance report.') }}</div>
                </div>
            @endif

            @if(in_array($report ?? '', ['department_grid', 'branch_grid', 'department_summary', 'branch_summary'], true) && empty($monthly) && empty($monthlyGrid))
                <div class="col-12 mb-3">
                    <div class="alert alert-info mb-0">{{ __('Select year and month, then click Generate to view the monthly report.') }}</div>
                </div>
            @endif

            @if(($report ?? 'staff') === 'staff' && !empty($staffReport) && $staff_details)
                <div class="col-12 mb-3">
                    <div class="card">
                        <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
                            <div>
                                <div class="font-weight-bold">{{ __('Staff Monthly Report') }}</div>
                                <div class="small text-muted">{{ Carbon::create($year, $month, 1)->format('F Y') }}</div>
                            </div>
                            <div class="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-1" href="{{ route('attendance.report.export', request()->query()) }}"><i class="las la-download"></i> {{ __('Export CSV') }}</a>
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="ar-report-head">
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="small text-muted">{{ __('Employee') }}</div>
                                        <div class="ar-staff-cell">{{ $staff_details->user?->name ?? '—' }} ({{ $staff_details->user_id }})</div>
                                        <div class="small text-muted mt-1">{{ $staff_details->designation?->name ?? '—' }} · {{ $staff_details->warehouse?->name ?? '—' }}</div>
                                    </div>
                                    <div class="col-md-6 text-md-right mt-3 mt-md-0">
                                        @if(get_setting('system_logo_white'))
                                            <img class="mw-100 brand-icon mb-2" style="max-height:48px;" src="{{ asset('storage/' . get_setting('system_logo_white')) }}" alt="{{ get_setting('site_name') }}">
                                        @endif
                                        <div class="small text-muted">{{ get_setting('site_name') }}</div>
                                    </div>
                                </div>
                            </div>
                            <div class="table-responsive">
                                <table class="table table-bordered ar-table mb-0">
                                    <thead>
                                    <tr>
                                        <th>{{ __('Date') }}</th>
                                        <th class="text-center">{{ __('Status') }}</th>
                                        <th>{{ __('In Time') }}</th>
                                        <th>{{ __('Out Time') }}</th>
                                        <th>{{ __('Remarks') }}</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($staffReport['rows'] as $row)
                                        <tr>
                                            <td>{{ $row['date'] }} ({{ $row['day_name'] }})</td>
                                            <td class="text-center"><span class="ar-badge {{ $row['badge_class'] }}">{{ $row['status'] }}</span></td>
                                            <td>{{ $row['sign_in'] ?? '—' }}</td>
                                            <td>{{ $row['sign_out'] ?? '—' }}</td>
                                            <td>{!! $row['remarks'] ?? '—' !!}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            @endif

            @if((($report ?? '') === 'department_summary' || ($report ?? '') === 'branch_summary') && !empty($monthly))
                <div class="col-12 mb-3">
                    <div class="card">
                        <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
                            <div>
                                <div class="font-weight-bold">{{ __('Monthly Attendance Summary') }}</div>
                                <div class="small text-muted">{{ Carbon::create($monthly['year'], $monthly['month'], 1)->format('F Y') }}</div>
                            </div>
                            <div class="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-1" href="{{ route('attendance.report.export', request()->query()) }}"><i class="las la-download"></i> {{ __('Export CSV') }}</a>
                            </div>
                        </div>
                        <div class="card-body p-0">
                            <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') }}</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 class="ar-staff-cell">{{ $r['staff']->user?->name ?? '—' }} ({{ $r['staff']->user_id }})</td>
                                            <td>{{ $r['staff']->department?->name ?? '—' }}</td>
                                            <td>{{ $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 py-4 text-muted">{{ __('No records found') }}</td></tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            @endif

            @if((($report ?? '') === 'department_grid' || ($report ?? '') === 'branch_grid') && !empty($monthlyGrid))
                <div class="col-12 mb-3">
                    <div class="card">
                        <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
                            <div>
                                <div class="font-weight-bold">{{ __('Monthly Attendance Grid') }}</div>
                                <div class="small text-muted">
                                    {{ Carbon::create($monthlyGrid['year'], $monthlyGrid['month'], 1)->format('F Y') }}
                                    — {{ __('Legend') }}: P={{ __('Present') }}, L={{ __('Late') }}, A={{ __('Absent') }}, H={{ __('Holiday') }}, W={{ __('Weekend') }}, LV={{ __('Leave') }}, HL={{ __('Half Leave') }}
                                </div>
                            </div>
                            <div class="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-1" href="{{ route('attendance.report.export', request()->query()) }}"><i class="las la-download"></i> {{ __('Export CSV') }}</a>
                            </div>
                        </div>
                        <div class="card-body p-0">
                            <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 class="ar-staff-cell">{{ $r['staff']->user?->name ?? '—' }} ({{ $r['staff']->user_id }})</td>
                                            <td>{{ $r['staff']->department?->name ?? '—' }}</td>
                                            <td>{{ $r['staff']->warehouse?->name ?? '—' }}</td>
                                            @foreach($r['cells'] as $c)
                                                @php $cls = strtolower($c); @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 py-4 text-muted">{{ __('No records found') }}</td>
                                        </tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            @endif

            @if(($report ?? '') === 'date' && !empty($daily))
                <div class="col-12 mb-3">
                    <div class="card">
                        <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
                            <div>
                                <div class="font-weight-bold">{{ __('Daily Attendance Report') }}</div>
                                <div class="small text-muted">{{ $daily['date'] }} ({{ date('l', strtotime($daily['date'])) }})</div>
                            </div>
                            <div class="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-1" href="{{ route('attendance.report.export', request()->query()) }}"><i class="las la-download"></i> {{ __('Export CSV') }}</a>
                            </div>
                        </div>
                        <div class="card-body p-0">
                            <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)
                                        @php $code = strtolower((string) $r['status']); if ($code === 'half leave') $code = 'hl'; @endphp
                                        <tr>
                                            <td>{{ $k + 1 }}</td>
                                            <td class="ar-staff-cell">{{ $r['staff']->user?->name ?? '—' }} ({{ $r['staff']->user_id }})</td>
                                            <td>{{ $r['staff']->department?->name ?? '—' }}</td>
                                            <td>{{ $r['staff']->warehouse?->name ?? '—' }}</td>
                                            <td class="text-center"><span class="ar-badge {{ $code }}">{{ $r['status'] }}</span></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 py-4 text-muted">{{ __('No records found') }}</td></tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            @endif
        </div>
    </div>
@endsection

@push('css')
    <style>
        @media print {
            @page { size: A4 landscape; margin: 8mm; }
            body { -webkit-print-color-adjust: exact; print-color-adjust: exact; }
            .table-responsive { overflow: visible !important; }
            .ar-wrap .card-body { padding: 0 !important; }
            .ar-table { width: 100% !important; font-size: 9px; }
            .ar-table thead th, .ar-table tbody td { padding: 3px 4px !important; white-space: nowrap; }
            .ar-grid-table { font-size: 8px; }
            .ar-grid-table .cell { width: 22px; min-width: 22px; }
        }
    </style>
@endpush

@section('script')
@endsection