@extends('layouts.app')

@section('title', 'Leave Balance Report')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-4">
    <div>
        <h4 class="mb-0">Leave Balance Report</h4>
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb mb-0">
                <li class="breadcrumb-item"><a href="{{ route('reports.index') }}">Reports</a></li>
                <li class="breadcrumb-item active">Leave Balance</li>
            </ol>
        </nav>
    </div>
    <div>
        <button type="button" class="btn btn-success" onclick="exportToExcel()">
            <i class="bi bi-file-earmark-excel me-2"></i>Export to Excel
        </button>
        <button type="button" class="btn btn-danger" onclick="exportToPDF()">
            <i class="bi bi-file-earmark-pdf me-2"></i>Export to PDF
        </button>
    </div>
</div>

{{-- Filters --}}
<div class="card mb-4">
    <div class="card-body">
        <form method="GET" action="{{ route('reports.leave-balance') }}" class="row g-3">
            <div class="col-md-3">
                <label class="form-label">Year</label>
                <select name="year" class="form-select">
                    @for($y = now()->year; $y >= now()->year - 5; $y--)
                        <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>
                            {{ $y }}
                        </option>
                    @endfor
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label">Department</label>
                <select name="department_id" class="form-select">
                    <option value="">All Departments</option>
                    @foreach($departments as $dept)
                        <option value="{{ $dept->id }}" {{ request('department_id') == $dept->id ? 'selected' : '' }}>
                            {{ $dept->department_name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-6 d-flex align-items-end">
                <button type="submit" class="btn btn-primary me-2">
                    <i class="bi bi-funnel me-2"></i>Apply Filters
                </button>
                <a href="{{ route('reports.leave-balance') }}" class="btn btn-secondary">
                    <i class="bi bi-x-circle me-2"></i>Clear
                </a>
            </div>
        </form>
    </div>
</div>

{{-- Report Table --}}
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Leave Balance for Year {{ $year }}</h5>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-hover" id="leaveBalanceTable">
                <thead>
                    <tr>
                        <th>Employee</th>
                        <th>Department</th>
                        <th>Leave Type</th>
                        <th>Total Quota</th>
                        <th>Used Days</th>
                        <th>Remaining Days</th>
                        <th>Usage %</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($leaveBalances as $employeeBalance)
                        @foreach($employeeBalance['balances'] as $index => $balance)
                            @php
                                $usagePercentage = $balance['total_quota'] > 0
                                    ? ($balance['used_days'] / $balance['total_quota'] * 100)
                                    : 0;
                            @endphp
                            <tr>
                                @if($index === 0)
                                    <td rowspan="{{ count($employeeBalance['balances']) }}">
                                        <div class="d-flex align-items-center">
                                            <div class="avatar bg-label-primary me-2">
                                                <span class="avatar-initial rounded-circle small">
                                                    {{ strtoupper(substr($employeeBalance['employee']->name ?? 'N', 0, 1)) }}
                                                </span>
                                            </div>
                                            {{ $employeeBalance['employee']->name ?? 'Unknown' }}
                                        </div>
                                    </td>
                                    <td rowspan="{{ count($employeeBalance['balances']) }}">
                                        {{ $employeeBalance['employee']->contract?->position?->department?->department_name ?? '-' }}
                                    </td>
                                @endif
                                <td>{{ $balance['leave_type'] }}</td>
                                <td>{{ number_format($balance['total_quota'], 1) }} days</td>
                                <td>{{ number_format($balance['used_days'], 1) }} days</td>
                                <td>
                                    <strong class="{{ $balance['remaining_days'] <= 2 ? 'text-danger' : 'text-success' }}">
                                        {{ number_format($balance['remaining_days'], 1) }} days
                                    </strong>
                                </td>
                                <td>
                                    <div class="progress" style="height: 20px;">
                                        <div class="progress-bar {{ $usagePercentage >= 80 ? 'bg-danger' : ($usagePercentage >= 50 ? 'bg-warning' : 'bg-success') }}"
                                             role="progressbar"
                                             style="width: {{ min($usagePercentage, 100) }}%">
                                            {{ number_format($usagePercentage, 1) }}%
                                        </div>
                                    </div>
                                </td>
                                <td>
                                    @if($balance['remaining_days'] == 0)
                                        <span class="badge bg-danger">Exhausted</span>
                                    @elseif($balance['remaining_days'] <= 2)
                                        <span class="badge bg-warning">Low</span>
                                    @elseif($balance['used_days'] == 0)
                                        <span class="badge bg-info">Unused</span>
                                    @else
                                        <span class="badge bg-success">Available</span>
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                    @empty
                        <tr>
                            <td colspan="8" class="text-center text-muted py-4">No employee records found</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

@push('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.31/jspdf.plugin.autotable.min.js"></script>

<script>
function exportToExcel() {
    // Create a simplified version of the table for export
    const table = document.getElementById('leaveBalanceTable');
    const wb = XLSX.utils.table_to_book(table, {sheet: "Leave Balance Report"});
    XLSX.writeFile(wb, `Leave_Balance_Report_${new Date().toISOString().slice(0,10)}.xlsx`);
}

function exportToPDF() {
    const { jsPDF } = window.jspdf;
    const doc = new jsPDF('l', 'mm', 'a4');

    doc.setFontSize(16);
    doc.text('Leave Balance Report - {{ $year }}', 14, 15);

    doc.setFontSize(10);
    doc.text(`Generated: ${new Date().toLocaleDateString()}`, 14, 22);

    const table = document.getElementById('leaveBalanceTable');
    doc.autoTable({
        html: table,
        startY: 28,
        theme: 'grid',
        headStyles: { fillColor: [79, 70, 229] },
        styles: { fontSize: 8 },
        margin: { top: 28 },
        columns: [
            {header: 'Employee', dataKey: 0},
            {header: 'Department', dataKey: 1},
            {header: 'Entitlement', dataKey: 2},
            {header: 'Used', dataKey: 3},
            {header: 'Remaining', dataKey: 4},
            {header: 'Status', dataKey: 6},
        ]
    });

    doc.save(`Leave_Balance_Report_${new Date().toISOString().slice(0,10)}.pdf`);
}
</script>
@endpush
@endsection