@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;
        }
    </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(\App\Models\Staff::where('status', 1)->with('user')->orderBy('id')->get() 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 = 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)
        <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 text-right text-md-left">
                                <h5>{{ get_setting('site_name') }}</h5>
                                @if(!empty($matrixSubTitle))
                                    <div class="text-muted small">{{ $matrixTitle }} — {{ $matrixSubTitle }}</div>
                                @else
                                    <div class="text-muted small">{{ $matrixTitle ?? '' }}</div>
                                @endif
                            </div>
                        </div>
                    </div>
                    <div class="card-body">
                        <h5 class="text-center mb-3">
                            {{ __('Leave summary report') }}
                            @if(request()->month)
                                — {{ date('F', mktime(0, 0, 0, (int)request()->month, 1)) }}
                            @endif
                            @if($year)
                                — {{ $year }}
                            @endif
                        </h5>

                        @foreach($staff_infos as $staff_info)
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="card mb-3">
                                        <div class="card-body">
                                            <table class="table table-bordered table-responsive-sm mb-0">
                                                <tbody>
                                                @php $leaveTypes = \App\Models\LeaveType::where('group_id', $staff_info->leave_group_id)->get(); @endphp
                                                @php $isFirstRow = true; @endphp

                                                @foreach($leaveTypes as $leave_type)
                                                    @php
                                                        $taken = $leaves->where('staff_id', $staff_info->id)
                                                            ->where('leave_type_id', $leave_type->id)
                                                            ->sum('number_of_days');
                                                        $leave_have = (date('Y', strtotime($staff_info->joing_date)) == $year)
                                                            ? round(($leave_type->day / 12) * (12 - date('m', strtotime($staff_info->joing_date)) + 1), 0)
                                                            : $leave_type->day;
                                                        $adjustment_balance = $adjustment->where('leave_type_id', $leave_type->id)->where('staff_id', $staff_info->id)->sum('balance');
                                                    @endphp

                                                    <tr>
                                                        @if ($isFirstRow)
                                                            <th class="text-center align-middle" rowspan="{{ count($leaveTypes) }}">
                                                                {{ $staff_info->user->name ?? '—' }}
                                                                ({{ $staff_info->user->id ?? '—' }})
                                                                <br>
                                                                <span class="small text-muted">{{ $staff_info->department->name ?? '—' }} / {{ $staff_info->warehouse->name ?? '—' }}</span>
                                                            </th>
                                                            @php $isFirstRow = false; @endphp
                                                        @endif
                                                        <th>{{ $leave_type->name }}</th>
                                                        <td>{{ __('Allowed') }}: {{ $leave_have }}</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>
                        @endforeach

                        <button class="btn btn-primary float-right no-print" type="button" onclick="window.print()">
                            <i class="fas fa-print"></i> {{ __('Print') }}
                        </button>
                    </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