@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | '.__('Leave 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;
        }
        .lr-filter-row .form-control,
        .lr-filter-row .custom-select {
            border-radius: 8px;
        }
        .lr-report-type-hint {
            font-size: 12px;
            color: #64748b;
        }

        .els-report-wrap {
            overflow-x: auto;
        }

        .els-report-title {
            text-align: center;
            font-size: 1.35rem;
            font-weight: 700;
            margin-bottom: 0.35rem;
            color: #1e293b;
        }

        .els-report-period {
            display: inline-block;
            background: #fef08a;
            color: #1e293b;
            font-weight: 700;
            font-size: 0.95rem;
            padding: 0.35rem 0.85rem;
            border: 1px solid #eab308;
            margin-bottom: 1rem;
        }

        .els-matrix-table {
            width: 100%;
            border-collapse: collapse;
            font-size: 0.8125rem;
            min-width: 960px;
        }

        .els-matrix-table th,
        .els-matrix-table td {
            border: 1px solid #94a3b8;
            padding: 0.45rem 0.5rem;
            text-align: center;
            vertical-align: middle;
        }

        .els-matrix-table thead th {
            background: #166534;
            color: #fff;
            font-weight: 600;
            white-space: nowrap;
        }

        .els-matrix-table thead tr:nth-child(2) th {
            background: #15803d;
            font-size: 0.75rem;
            font-weight: 500;
        }

        .els-matrix-table tbody td.els-employee {
            text-align: left;
            font-weight: 500;
            white-space: nowrap;
            min-width: 220px;
        }

        .els-matrix-table tbody td.els-num {
            width: 42px;
            font-weight: 600;
        }

        .els-matrix-table tbody tr:nth-child(even) {
            background: #f8fafc;
        }

        .els-matrix-table tbody tr:hover {
            background: #f1f5f9;
        }

        .els-dash {
            color: #94a3b8;
        }

        @media print {
            @page {
                size: A4 landscape;
                margin: 8mm;
            }

            .no-print,
            #preloader,
            .left.side-menu,
            .side-menu,
            .sidebar-overlay,
            .topbar,
            .footer,
            .button-menu-mobile {
                display: none !important;
            }

            html, body {
                background: #fff !important;
                margin: 0 !important;
                padding: 0 !important;
                width: 100% !important;
            }

            body.fixed-left {
                margin-left: 0 !important;
            }

            #wrapper,
            .content-page,
            .content,
            .container-fluid {
                margin: 0 !important;
                padding: 0 !important;
                width: 100% !important;
                max-width: 100% !important;
            }

            .card {
                border: none !important;
                box-shadow: none !important;
            }

            .card-header {
                display: none !important;
            }

            .els-report-wrap {
                overflow: visible !important;
            }

            .els-matrix-table {
                width: 100% !important;
                min-width: 0 !important;
                font-size: 8px;
                page-break-inside: auto;
            }

            .els-matrix-table th,
            .els-matrix-table td {
                padding: 3px 4px !important;
            }

            .els-matrix-table thead th {
                background: #166534 !important;
                color: #fff !important;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }

            .els-matrix-table thead tr:nth-child(2) th {
                background: #15803d !important;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }

            .els-report-period {
                background: #fef08a !important;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }

            .els-matrix-table tbody tr {
                page-break-inside: avoid;
            }

            .table.aiz-table {
                font-size: 9px;
            }
        }
    </style>
    <div class="row mt-4 mb-4 no-print">
        <div class="col-12 col-xl-11 mx-auto no-print">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center flex-wrap">
                    <h5 class="mb-0">{{ __('Leave Report') }}</h5>
                </div>
                <div class="card-body">
                    <form action="{{ route('Leave_report') }}" method="GET" id="leaveReportForm">
                        <div class="form-row lr-filter-row align-items-end">
                            <div class="form-group col-12 col-md-6 col-lg-3 mb-2">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Report type') }}</label>
                                <select name="report_type" id="lr_report_type" class="form-control select2">
                                    <option value="staff" {{ ($report_type ?? 'staff') === 'staff' ? 'selected' : '' }}>{{ __('Staff wise (detail + summary)') }}</option>
                                    <option value="department" {{ ($report_type ?? '') === 'department' ? 'selected' : '' }}>{{ __('Department wise (summary matrix)') }}</option>
                                    <option value="branch" {{ ($report_type ?? '') === 'branch' ? 'selected' : '' }}>{{ __('Branch wise (summary matrix)') }}</option>
                                    <option value="all_staff" {{ ($report_type ?? '') === 'all_staff' ? 'selected' : '' }}>{{ __('All staff / company (summary matrix)') }}</option>
                                </select>
                                <div class="lr-report-type-hint mt-1">{{ __('Matrix reports: pick year; month is optional (yearly vs monthly).') }}</div>
                            </div>
                            <div class="form-group col-12 col-md-6 col-lg-3 mb-2 lr-opt lr-opt-staff">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Staff') }}</label>
                                <select name="staff_id" class="form-control select2" id="lr_staff_id">
                                    <option value="">{{ __('Please Select Staff') }}</option>
                                    @foreach($staffFilterList ?? [] as $staff)
                                        <option value="{{ $staff->id }}" {{ (string)request('staff_id') === (string)$staff->id ? 'selected' : '' }}>
                                            {{ $staff->user->name ?? '—' }} ({{ $staff->user->id ?? $staff->id }})
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="form-group col-12 col-md-6 col-lg-3 mb-2 lr-opt lr-opt-dept" style="display:none;">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Department') }}</label>
                                <select name="department_id" class="form-control select2" id="lr_department_id">
                                    <option value="">{{ __('Select department') }}</option>
                                    @foreach($departments ?? [] as $dept)
                                        <option value="{{ $dept->id }}" {{ (string)request('department_id') === (string)$dept->id ? 'selected' : '' }}>{{ $dept->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="form-group col-12 col-md-6 col-lg-3 mb-2 lr-opt lr-opt-branch" style="display:none;">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Branch') }}</label>
                                <select name="warehouse_id" class="form-control select2" id="lr_warehouse_id">
                                    <option value="">{{ __('Select branch') }}</option>
                                    @foreach($branches ?? [] as $wh)
                                        <option value="{{ $wh->id }}" {{ (string)request('warehouse_id') === (string)$wh->id ? 'selected' : '' }}>{{ $wh->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="form-group col-6 col-md-3 col-lg-2 mb-2">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Year') }}</label>
                                <select name="year" class="form-control select2" id="lr_year">
                                    <option value="">{{ __('Year') }}</option>
                                    @for($i = 2020; $i <= (int)date('Y') + 1; $i++)
                                        <option value="{{ $i }}" {{ (string)request('year') === (string)$i ? 'selected' : '' }}>{{ $i }}</option>
                                    @endfor
                                </select>
                            </div>
                            <div class="form-group col-6 col-md-3 col-lg-2 mb-2">
                                <label class="small font-weight-bold text-uppercase text-muted">{{ __('Month') }} <span class="text-muted font-weight-normal">({{ __('optional') }})</span></label>
                                <select name="month" class="form-control select2">
                                    <option value="">{{ __('Whole year') }}</option>
                                    @foreach(range(1, 12) as $m)
                                        <option value="{{ $m }}" {{ (string)request('month') === (string)$m ? 'selected' : '' }}>
                                            {{ date('F', mktime(0, 0, 0, $m, 1)) }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="form-group col-12 col-md-2 col-lg-1 mb-2">
                                <button class="btn btn-primary btn-block" type="submit"><i class="fas fa-search"></i> {{ __('Search') }}</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    @if(($report_type ?? 'staff') === 'staff' && $staff_id && $staff_info && $leaves !== null)
        <div class="row mt-4 mb-4">
            <div class="col-12 col-xl-11 mx-auto">
                <div class="card">
                    <div class="card-header">
                        <div class="row">
                            <div class="col">
                                @if(get_setting('system_logo_white') != null)
                                    <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>
                                {{ !empty($staff_info->warehouse) ? $staff_info->warehouse->address : '' }}
                            </div>
                        </div>
                    </div>
                    <div class="card-body">
                        <table class="table table-bordered mb-3">
                            <tbody>
                            <tr>
                                <th>{{ __('Employee Code') }}</th>
                                <td>{{ !empty($staff_info->user) ? $staff_info->user->id : '' }}</td>
                                <th>{{ __('Designation') }}</th>
                                <td>{{ !empty($staff_info->designation) ? $staff_info->designation->name : '-' }}</td>
                            </tr>
                            <tr>
                                <th>{{ __('Employee Name') }}</th>
                                <td>{{ !empty($staff_info->user) ? $staff_info->user->name : '-' }}</td>
                                <th>{{ __('Warehouse/Branch') }}</th>
                                <td>{{ !empty($staff_info->warehouse) ? $staff_info->warehouse->name : '-' }}</td>
                            </tr>
                            </tbody>
                        </table>
                        <table class="table aiz-table">
                            <h5 class="text-center mb-4">
                                {{ __('Leave Report') }}
                                @if(request()->month)
                                    {{ date('F', mktime(0, 0, 0, (int)request()->month, 1)) }} —
                                @endif
                                {{ $year ? $year : __('All periods') }}
                            </h5>
                            <thead>
                            <tr>
                                <th>#</th>
                                <th>{{ __('Staff Name') }}</th>
                                <th>{{ __('Apply Date') }}</th>
                                <th class="text-center">{{ __('Paid Leave') }}</th>
                                <th>{{ __('From') }}</th>
                                <th>{{ __('To') }}</th>
                                <th>{{ __('Duration') }}</th>
                                <th>{{ __('Remarks') }}</th>
                                <th class="text-center">{{ __('Approval') }}</th>
                            </tr>
                            </thead>
                            <tbody>
                            @forelse($leaves as $key => $leave)
                                <tr>
                                    <td>{{ $key + 1 }}</td>
                                    <td>{{ !empty($staff_info->user) ? $staff_info->user->name : '-' }}</td>
                                    <td>{{ $leave->apply_date }}</td>
                                    <td class="text-center">
                                        @if($leave->type == 'paid')
                                            <i class="fas fa-check-circle text-success fs-24" title="{{ __('Paid Leave') }}"></i>
                                        @else
                                            <i class="fas fa-times-circle text-danger fs-24" title="{{ __('Unpaid Leave') }}"></i>
                                        @endif
                                    </td>
                                    <td>{{ $leave->start }}</td>
                                    <td>{{ $leave->end }}</td>
                                    <td>{{ $leave->number_of_days }}&nbsp;{{ __('Days') }}</td>
                                    <td>{{ $leave->reason }}</td>
                                    <td class="text-center">
                                        @if($leave->status == 1)
                                            <i class="fas fa-check-circle text-success fs-24"
                                               title="{{ __('Approved by') }} {{ \App\Models\User::where('id', $leave->approved_by)->value('name') }}"></i>
                                        @else
                                            <i class="fas fa-times-circle text-danger fs-24" title="{{ __('Not approved') }}"></i>
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td class="text-danger text-center" colspan="9">{{ __('No record found') }}</td>
                                </tr>
                            @endforelse
                            </tbody>
                        </table>

                        <div class="row">
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h5>{{ __('Leave Summary') }}</h5>
                                    </div>
                                    <div class="card-body">
                                        <table class="table table-bordered table-responsive-sm">
                                            <tbody>
                                            @foreach(\App\Models\LeaveType::where('group_id', $staff_info->leave_group_id)->get() as $leave_type)
                                                @php
                                                    $taken = $leaves->where('leave_type_id', $leave_type->id)->sum('number_of_days');
                                                    $adjustment_balance = $adjustment->where('leave_type_id', $leave_type->id)->sum('balance');
                                                    $sy = (int)($summary_year ?? date('Y'));
                                                @endphp
                                                <tr>
                                                    <th>{{ $leave_type->name }}</th>
                                                    <td>
                                                        {{ __('Allowed') }}:
                                                        @if (date('Y', strtotime($staff_info->joing_date)) == $sy)
                                                            {{ $leave_have = app_round(($leave_type->day / 12) * (12 - date('m', strtotime($staff_info->joing_date)) + 1), 0) }}
                                                        @else
                                                            {{ $leave_have = $leave_type->day }}
                                                        @endif
                                                    </td>
                                                    <td>{{ __('Taken') }}: {{ $taken }}</td>
                                                    <td>{{ __('Adjustment') }}: {{ $adjustment_balance }}</td>
                                                    <td>{{ __('Remaining') }}: {{ ($leave_have + $adjustment_balance) - $taken }}</td>
                                                </tr>
                                            @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <button class="btn btn-primary float-right no-print" type="button" onclick="window.print()">
                            <i class="fas fa-print"></i>
                        </button>
                    </div>
                </div>
            </div>
        </div>
    @endif

    @if(!empty($showMatrixReport) && $staff_infos && $staff_infos->isNotEmpty() && $leaves !== null && !empty($leaveStatusMatrix))
        <div class="row mt-4 mb-4">
            <div class="col-12 mx-auto">
                <div class="card">
                    <div class="card-header d-flex justify-content-between align-items-center flex-wrap no-print">
                        <div>
                            @if(get_setting('system_logo_white') != null)
                                <img class="mw-100 brand-icon mb-2"
                                     src="{{ asset('storage/' . get_setting('system_logo_white')) }}"
                                     alt="{{ get_setting('site_name') }}">
                            @endif
                            <div class="text-muted small">{{ $matrixTitle ?? '' }}@if(!empty($matrixSubTitle)) — {{ $matrixSubTitle }}@endif</div>
                        </div>
                        <button class="btn btn-primary" type="button" onclick="window.print()">
                            <i class="fas fa-print"></i> {{ __('Print') }}
                        </button>
                    </div>
                    <div class="card-body">
                        <div class="text-center mb-3">
                            <div class="els-report-title">{{ __('Employee Leave Status') }}</div>
                            @if(!empty($leaveReportPeriod))
                                <div class="els-report-period">{{ $leaveReportPeriod }}</div>
                            @endif
                        </div>

                        <div class="els-report-wrap">
                            <table class="els-matrix-table">
                                <thead>
                                <tr>
                                    <th rowspan="2">#</th>
                                    <th rowspan="2">{{ __('Employee') }}</th>
                                    @foreach($leaveStatusMatrix['leaveTypes'] as $leaveType)
                                        <th colspan="3">{{ $leaveType->name }}</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach($leaveStatusMatrix['leaveTypes'] as $leaveType)
                                        <th>{{ __('Allocated') }}</th>
                                        <th>{{ __('Used') }}</th>
                                        <th>{{ __('Balance') }}</th>
                                    @endforeach
                                </tr>
                                </thead>
                                <tbody>
                                @forelse($leaveStatusMatrix['rows'] as $row)
                                    <tr>
                                        <td class="els-num">{{ $row['num'] }}</td>
                                        <td class="els-employee">{{ $row['name'] }} ( {{ $row['code'] }} )</td>
                                        @foreach($leaveStatusMatrix['leaveTypes'] as $leaveType)
                                            @php $cell = $row['cells'][$leaveType->key] ?? ['allocated' => null, 'used' => null, 'balance' => null]; @endphp
                                            @if($cell['allocated'] === null)
                                                <td class="els-dash">-</td>
                                                <td class="els-dash">-</td>
                                                <td class="els-dash">-</td>
                                            @else
                                                <td>{{ $cell['allocated'] }}</td>
                                                <td>{{ $cell['used'] }}</td>
                                                <td>{{ $cell['balance'] }}</td>
                                            @endif
                                        @endforeach
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="{{ 2 + ($leaveStatusMatrix['leaveTypes']->count() * 3) }}" class="text-center text-muted py-4">
                                            {{ __('No record found') }}
                                        </td>
                                    </tr>
                                @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    @endif

@endsection

@section('script')
    <script>
        (function () {
            function lrToggleFilters() {
                var t = $('#lr_report_type').val();
                $('.lr-opt-staff, .lr-opt-dept, .lr-opt-branch').hide();
                if (t === 'staff') $('.lr-opt-staff').show();
                if (t === 'department') $('.lr-opt-dept').show();
                if (t === 'branch') $('.lr-opt-branch').show();
            }
            $('#lr_report_type').on('change', lrToggleFilters);
            document.addEventListener('DOMContentLoaded', lrToggleFilters);
        })();
    </script>
@endsection