@extends('dashboard.admin.layouts.master')

@section('content')
<div class="d-flex flex-column flex-column-fluid">
    {{-- Toolbar --}}
    <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
        <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
            <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">
                    {{ trans('hr.analytics.title') }}
                </h1>
                <ul class="breadcrumb breadcrumb-separatorless fw-semibold fs-7 my-0 pt-1">
                    <li class="breadcrumb-item text-muted">{{ trans('sidebar.hr') }}</li>
                    <li class="breadcrumb-item"><span class="bullet bg-gray-400 w-5px h-2px"></span></li>
                    <li class="breadcrumb-item text-muted">{{ trans('hr.analytics.title') }}</li>
                </ul>
            </div>
        </div>
    </div>

    <div id="kt_app_content" class="app-content flex-column-fluid">
        <div id="kt_app_content_container" class="app-container container-xxl">

            {{-- Filters --}}
            <div class="card mb-7">
                <div class="card-body py-5">
                    <form method="GET" action="{{ route('admin.dashboard.hr.analytics.dashboard.index') }}" class="row g-4 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label fs-7 fw-semibold text-muted">{{ trans('hr.analytics.filter_branch') }}</label>
                            <select name="branch_id" class="form-select form-select-sm">
                                <option value="">{{ trans('hr.analytics.all_branches') }}</option>
                                @foreach($branches as $branch)
                                    <option value="{{ $branch->id }}" @selected($selectedBranch == $branch->id)>
                                        {{ $branch->name }} ({{ $branch->code }})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fs-7 fw-semibold text-muted">{{ trans('hr.analytics.filter_month') }}</label>
                            <input type="month" name="month" class="form-control form-control-sm" value="{{ $selectedMonth }}">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fs-7 fw-semibold text-muted">{{ trans('hr.analytics.filter_year') }}</label>
                            <select name="year" class="form-select form-select-sm">
                                @foreach($years as $yr)
                                    <option value="{{ $yr }}" @selected($selectedYear == $yr)>{{ $yr }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <button type="submit" class="btn btn-primary btn-sm w-100">
                                {{ trans('hr.analytics.apply_filters') }}
                            </button>
                        </div>
                    </form>
                </div>
            </div>

            {{-- Summary Cards --}}
            <div class="row g-5 mb-7">
                <div class="col-md-3">
                    <div class="card h-100 border-0 shadow-sm">
                        <div class="card-body d-flex align-items-center">
                            <div class="symbol symbol-50px me-5 symbol-light-primary">
                                <span class="symbol-label">
                                    <i class="ki-duotone ki-people fs-2x text-primary"><span class="path1"></span><span class="path2"></span></i>
                                </span>
                            </div>
                            <div>
                                <div class="fs-2 fw-bold text-dark">{{ number_format($employeeStats['total']) }}</div>
                                <div class="fs-7 text-muted">{{ trans('hr.analytics.total_employees') }}</div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card h-100 border-0 shadow-sm">
                        <div class="card-body d-flex align-items-center">
                            <div class="symbol symbol-50px me-5 symbol-light-success">
                                <span class="symbol-label">
                                    <i class="ki-duotone ki-verify fs-2x text-success"><span class="path1"></span><span class="path2"></span></i>
                                </span>
                            </div>
                            <div>
                                <div class="fs-2 fw-bold text-dark">{{ number_format($employeeStats['active']) }}</div>
                                <div class="fs-7 text-muted">{{ trans('hr.analytics.active_employees') }}</div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card h-100 border-0 shadow-sm">
                        <div class="card-body d-flex align-items-center">
                            <div class="symbol symbol-50px me-5 symbol-light-warning">
                                <span class="symbol-label">
                                    <i class="ki-duotone ki-document fs-2x text-warning"><span class="path1"></span><span class="path2"></span></i>
                                </span>
                            </div>
                            <div>
                                <div class="fs-2 fw-bold text-dark">{{ $contractAlerts['total_30'] }}</div>
                                <div class="fs-7 text-muted">{{ trans('hr.analytics.contracts_expiring_30') }}</div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card h-100 border-0 shadow-sm">
                        <div class="card-body d-flex align-items-center">
                            <div class="symbol symbol-50px me-5 symbol-light-info">
                                <span class="symbol-label">
                                    <i class="ki-duotone ki-dollar fs-2x text-info"><span class="path1"></span><span class="path2"></span></i>
                                </span>
                            </div>
                            <div>
                                <div class="fs-2 fw-bold text-dark">{{ number_format($payrollCost['total_net'], 0) }}</div>
                                <div class="fs-7 text-muted">{{ trans('hr.analytics.last_payroll_net') }}</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Row: Employee Distribution --}}
            <div class="row g-5 mb-7">
                {{-- By Branch --}}
                <div class="col-lg-6">
                    <div class="card h-100">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.by_branch') }}</span>
                            </h3>
                        </div>
                        <div class="card-body pt-0">
                            @if($branchDist->isEmpty())
                                <p class="text-muted fs-7">{{ trans('hr.analytics.no_data') }}</p>
                            @else
                                <div class="table-responsive">
                                    <table class="table table-row-dashed table-row-gray-200 align-middle gs-0 gy-3">
                                        <thead>
                                            <tr class="border-0">
                                                <th class="p-0 fw-bold fs-7 text-muted">{{ trans('hr.analytics.branch') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted text-end">{{ trans('hr.analytics.total') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted text-end">{{ trans('hr.analytics.active') }}</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($branchDist as $row)
                                            <tr>
                                                <td class="fw-semibold text-dark fs-7">{{ $row->name }}</td>
                                                <td class="text-end fw-bold text-dark fs-7">{{ $row->employees_count }}</td>
                                                <td class="text-end">
                                                    <span class="badge badge-light-success">{{ $row->active_count }}</span>
                                                </td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>

                {{-- By Department --}}
                <div class="col-lg-6">
                    <div class="card h-100">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.by_department') }}</span>
                            </h3>
                        </div>
                        <div class="card-body pt-0">
                            @if($departmentDist->isEmpty())
                                <p class="text-muted fs-7">{{ trans('hr.analytics.no_data') }}</p>
                            @else
                                <div class="table-responsive">
                                    <table class="table table-row-dashed table-row-gray-200 align-middle gs-0 gy-3">
                                        <thead>
                                            <tr class="border-0">
                                                <th class="p-0 fw-bold fs-7 text-muted">{{ trans('hr.analytics.department') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted text-end">{{ trans('hr.analytics.total') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted text-end">{{ trans('hr.analytics.active') }}</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($departmentDist as $row)
                                            <tr>
                                                <td class="fw-semibold text-dark fs-7">{{ $row->name }}</td>
                                                <td class="text-end fw-bold text-dark fs-7">{{ $row->employees_count }}</td>
                                                <td class="text-end">
                                                    <span class="badge badge-light-success">{{ $row->active_count }}</span>
                                                </td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>
            </div>

            {{-- Row: Attendance + Payroll --}}
            <div class="row g-5 mb-7">
                {{-- Attendance Stats --}}
                <div class="col-lg-6">
                    <div class="card h-100">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.attendance_stats') }}</span>
                                <span class="text-muted mt-1 fw-semibold fs-7">{{ $attendanceStats['month'] }}</span>
                            </h3>
                        </div>
                        <div class="card-body pt-3">
                            <div class="row g-4">
                                <div class="col-6">
                                    <div class="bg-light-success rounded p-4 text-center">
                                        <div class="fs-2 fw-bold text-success">{{ number_format($attendanceStats['present']) }}</div>
                                        <div class="fs-8 text-muted mt-1">{{ trans('hr.analytics.present') }}</div>
                                    </div>
                                </div>
                                <div class="col-6">
                                    <div class="bg-light-danger rounded p-4 text-center">
                                        <div class="fs-2 fw-bold text-danger">{{ number_format($attendanceStats['absent']) }}</div>
                                        <div class="fs-8 text-muted mt-1">{{ trans('hr.analytics.absent') }}</div>
                                    </div>
                                </div>
                                <div class="col-6">
                                    <div class="bg-light-warning rounded p-4 text-center">
                                        <div class="fs-2 fw-bold text-warning">{{ number_format($attendanceStats['late_count']) }}</div>
                                        <div class="fs-8 text-muted mt-1">{{ trans('hr.analytics.late') }}</div>
                                    </div>
                                </div>
                                <div class="col-6">
                                    <div class="bg-light-info rounded p-4 text-center">
                                        <div class="fs-2 fw-bold text-info">{{ number_format($attendanceStats['on_leave']) }}</div>
                                        <div class="fs-8 text-muted mt-1">{{ trans('hr.analytics.on_leave') }}</div>
                                    </div>
                                </div>
                            </div>
                            <div class="mt-4 pt-3 border-top">
                                <div class="d-flex justify-content-between fs-7">
                                    <span class="text-muted">{{ trans('hr.analytics.avg_worked_hours') }}</span>
                                    <span class="fw-bold text-dark">{{ $attendanceStats['avg_worked_hours'] }}h</span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                {{-- Payroll Cost --}}
                <div class="col-lg-6">
                    <div class="card h-100">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.payroll_cost') }}</span>
                                @if($payrollCost['run_code'])
                                    <span class="text-muted mt-1 fw-semibold fs-7">{{ $payrollCost['run_code'] }}</span>
                                @endif
                            </h3>
                        </div>
                        <div class="card-body pt-3">
                            @if(! $payrollCost['run_code'])
                                <p class="text-muted fs-7">{{ trans('hr.analytics.no_payroll_data') }}</p>
                            @else
                                <div class="table-responsive">
                                    <table class="table table-row-dashed table-row-gray-200 align-middle gs-0 gy-2">
                                        <tr>
                                            <td class="text-muted fs-7">{{ trans('hr.analytics.employees_count') }}</td>
                                            <td class="text-end fw-bold fs-7">{{ number_format($payrollCost['employee_count']) }}</td>
                                        </tr>
                                        <tr>
                                            <td class="text-muted fs-7">{{ trans('hr.analytics.basic_salary') }}</td>
                                            <td class="text-end fw-bold fs-7">{{ number_format($payrollCost['total_basic'], 2) }}</td>
                                        </tr>
                                        <tr>
                                            <td class="text-muted fs-7">{{ trans('hr.analytics.total_earnings') }}</td>
                                            <td class="text-end fw-bold text-success fs-7">{{ number_format($payrollCost['total_earnings'], 2) }}</td>
                                        </tr>
                                        <tr>
                                            <td class="text-muted fs-7">{{ trans('hr.analytics.total_deductions') }}</td>
                                            <td class="text-end fw-bold text-danger fs-7">{{ number_format($payrollCost['total_deductions'], 2) }}</td>
                                        </tr>
                                        <tr class="border-top">
                                            <td class="fw-bold fs-6">{{ trans('hr.analytics.net_salary') }}</td>
                                            <td class="text-end fw-bolder fs-6 text-primary">{{ number_format($payrollCost['total_net'], 2) }}</td>
                                        </tr>
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>
            </div>

            {{-- Row: Contract Expiry + Turnover --}}
            <div class="row g-5 mb-7">
                {{-- Contract Expiry Alerts --}}
                <div class="col-lg-8">
                    <div class="card">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.contract_expiry') }}</span>
                                <span class="text-muted mt-1 fw-semibold fs-7">
                                    {{ trans('hr.analytics.expiring_30_label', ['count' => $contractAlerts['total_30']]) }} &nbsp;|&nbsp;
                                    {{ trans('hr.analytics.expiring_60_label', ['count' => $contractAlerts['total_60']]) }}
                                </span>
                            </h3>
                        </div>
                        <div class="card-body pt-0">
                            @php $allAlerts = $contractAlerts['in_30_days']->merge($contractAlerts['in_60_days']) @endphp
                            @if($allAlerts->isEmpty())
                                <p class="text-muted fs-7 pt-3">{{ trans('hr.analytics.no_expiry_alerts') }}</p>
                            @else
                                <div class="table-responsive">
                                    <table class="table table-row-dashed table-row-gray-200 align-middle gs-0 gy-2">
                                        <thead>
                                            <tr class="border-0">
                                                <th class="p-0 fw-bold fs-7 text-muted">{{ trans('hr.analytics.employee') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted">{{ trans('hr.analytics.contract_end') }}</th>
                                                <th class="p-0 fw-bold fs-7 text-muted text-end">{{ trans('hr.analytics.days_left') }}</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($contractAlerts['in_30_days'] as $contract)
                                            <tr>
                                                <td class="fw-semibold text-dark fs-7">
                                                    {{ $contract->employee->name ?? '—' }}
                                                    <span class="text-muted ms-1">{{ $contract->employee->code ?? '' }}</span>
                                                </td>
                                                <td class="fs-7">{{ $contract->end_date?->format('Y-m-d') }}</td>
                                                <td class="text-end">
                                                    <span class="badge badge-light-danger">
                                                        {{ now()->diffInDays($contract->end_date) }}d
                                                    </span>
                                                </td>
                                            </tr>
                                            @endforeach
                                            @foreach($contractAlerts['in_60_days'] as $contract)
                                            <tr>
                                                <td class="fw-semibold text-dark fs-7">
                                                    {{ $contract->employee->name ?? '—' }}
                                                    <span class="text-muted ms-1">{{ $contract->employee->code ?? '' }}</span>
                                                </td>
                                                <td class="fs-7">{{ $contract->end_date?->format('Y-m-d') }}</td>
                                                <td class="text-end">
                                                    <span class="badge badge-light-warning">
                                                        {{ now()->diffInDays($contract->end_date) }}d
                                                    </span>
                                                </td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>

                {{-- Turnover --}}
                <div class="col-lg-4">
                    <div class="card h-100">
                        <div class="card-header border-0 pt-5">
                            <h3 class="card-title align-items-start flex-column">
                                <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.turnover') }}</span>
                                <span class="text-muted mt-1 fw-semibold fs-7">{{ $turnoverStats['year'] }}</span>
                            </h3>
                        </div>
                        <div class="card-body pt-3">
                            <div class="text-center mb-5">
                                <div class="fs-1 fw-bolder text-dark">{{ $turnoverStats['total_resignations'] }}</div>
                                <div class="fs-7 text-muted">{{ trans('hr.analytics.resignations') }}</div>
                                <div class="mt-2 badge badge-light-danger fs-7">
                                    {{ trans('hr.analytics.turnover_rate') }}: {{ $turnoverStats['turnover_rate'] }}%
                                </div>
                            </div>
                            @if(! empty($turnoverStats['by_month']))
                                <div class="separator mb-4"></div>
                                @php $monthNames = ['','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'] @endphp
                                @foreach($turnoverStats['by_month'] as $mon => $count)
                                    <div class="d-flex justify-content-between fs-7 mb-2">
                                        <span class="text-muted">{{ $monthNames[$mon] }}</span>
                                        <span class="fw-bold text-dark">{{ $count }}</span>
                                    </div>
                                @endforeach
                            @endif
                        </div>
                    </div>
                </div>
            </div>

            {{-- Employee Status Breakdown --}}
            <div class="card mb-7">
                <div class="card-header border-0 pt-5">
                    <h3 class="card-title align-items-start flex-column">
                        <span class="card-label fw-bold fs-5 mb-1">{{ trans('hr.analytics.employee_status_breakdown') }}</span>
                    </h3>
                </div>
                <div class="card-body pt-0">
                    <div class="row g-4">
                        @foreach($employeeStats['by_status'] as $status => $count)
                        <div class="col-md-2 col-sm-4 col-6">
                            <div class="border rounded p-4 text-center">
                                <div class="fs-3 fw-bold text-dark">{{ $count }}</div>
                                <div class="fs-8 text-muted mt-1">{{ ucwords(str_replace('_', ' ', $status)) }}</div>
                            </div>
                        </div>
                        @endforeach
                        @foreach($employeeStats['by_gender'] as $gender => $count)
                        <div class="col-md-2 col-sm-4 col-6">
                            <div class="border border-dashed rounded p-4 text-center">
                                <div class="fs-3 fw-bold text-primary">{{ $count }}</div>
                                <div class="fs-8 text-muted mt-1">{{ ucfirst($gender) }}</div>
                            </div>
                        </div>
                        @endforeach
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
@endsection