@extends('layouts.app')

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

@section('content')
<div class="d-flex justify-content-between align-items-center mb-4">
    <div>
        <h4 class="mb-0">Leave 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</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>

{{-- Summary Cards --}}
<div class="row mb-4">
    <div class="col-md-3 mb-3">
        <div class="card">
            <div class="card-body">
                <div class="d-flex align-items-center">
                    <div class="avatar bg-label-primary me-3">
                        <span class="avatar-initial rounded-circle">
                            <i class="bi bi-list-check fs-4"></i>
                        </span>
                    </div>
                    <div>
                        <p class="text-muted mb-0 small">Total Leaves</p>
                        <h4 class="mb-0">{{ number_format($summary['total_leaves']) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-2 mb-3">
        <div class="card">
            <div class="card-body">
                <div class="d-flex align-items-center">
                    <div class="avatar bg-label-success me-3">
                        <span class="avatar-initial rounded-circle">
                            <i class="bi bi-check-circle fs-4"></i>
                        </span>
                    </div>
                    <div>
                        <p class="text-muted mb-0 small">Approved</p>
                        <h4 class="mb-0">{{ number_format($summary['approved']) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-2 mb-3">
        <div class="card">
            <div class="card-body">
                <div class="d-flex align-items-center">
                    <div class="avatar bg-label-warning me-3">
                        <span class="avatar-initial rounded-circle">
                            <i class="bi bi-clock-history fs-4"></i>
                        </span>
                    </div>
                    <div>
                        <p class="text-muted mb-0 small">Pending</p>
                        <h4 class="mb-0">{{ number_format($summary['pending']) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-2 mb-3">
        <div class="card">
            <div class="card-body">
                <div class="d-flex align-items-center">
                    <div class="avatar bg-label-danger me-3">
                        <span class="avatar-initial rounded-circle">
                            <i class="bi bi-x-circle fs-4"></i>
                        </span>
                    </div>
                    <div>
                        <p class="text-muted mb-0 small">Rejected</p>
                        <h4 class="mb-0">{{ number_format($summary['rejected']) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-3">
        <div class="card">
            <div class="card-body">
                <div class="d-flex align-items-center">
                    <div class="avatar bg-label-info me-3">
                        <span class="avatar-initial rounded-circle">
                            <i class="bi bi-calendar-event fs-4"></i>
                        </span>
                    </div>
                    <div>
                        <p class="text-muted mb-0 small">Total Days (Approved)</p>
                        <h4 class="mb-0">{{ number_format($summary['total_days']) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

{{-- Filters --}}
<div class="card mb-4">
    <div class="card-body">
        <form method="GET" action="{{ route('reports.leave') }}" class="row g-3">
            <div class="col-md-3">
                <label class="form-label">Start Date</label>
                <input type="date" name="start_date" class="form-control" value="{{ request('start_date') }}">
            </div>
            <div class="col-md-3">
                <label class="form-label">End Date</label>
                <input type="date" name="end_date" class="form-control" value="{{ request('end_date') }}">
            </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-3">
                <label class="form-label">Status</label>
                <select name="status" class="form-select">
                    <option value="">All Status</option>
                    <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                    <option value="approved" {{ request('status') == 'approved' ? 'selected' : '' }}>Approved</option>
                    <option value="rejected" {{ request('status') == 'rejected' ? 'selected' : '' }}>Rejected</option>
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label">Leave Type</label>
                <select name="leave_type_id" class="form-select">
                    <option value="">All Types</option>
                    @foreach($leaveTypes as $type)
                        <option value="{{ $type->id }}" {{ request('leave_type_id') == $type->id ? 'selected' : '' }}>
                            {{ $type->leave_name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label">Employee</label>
                <select name="employee_id" class="form-select">
                    <option value="">All Employees</option>
                    @foreach($employees as $emp)
                        <option value="{{ $emp->id }}" {{ request('employee_id') == $emp->id ? 'selected' : '' }}>
                            {{ $emp->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') }}" 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-body">
        <div class="table-responsive">
            <table class="table table-hover" id="leaveTable">
                <thead>
                    <tr>
                        <th>Employee</th>
                        <th>Department</th>
                        <th>Leave Type</th>
                        <th>Start Date</th>
                        <th>End Date</th>
                        <th>Total Days</th>
                        <th>Status</th>
                        <th>Reason</th>
                        <th>Applied On</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($leaves as $leave)
                        <tr>
                            <td>
                                <div class="d-flex align-items-center">
                                    <div class="avatar bg-label-primary me-2">
                                        <span class="avatar-initial rounded-circle small">
                                            {{ strtoupper(substr($leave->employee?->name ?? 'N', 0, 1)) }}
                                        </span>
                                    </div>
                                    {{ $leave->employee?->name ?? 'Unknown' }}
                                </div>
                            </td>
                            <td>{{ $leave->employee?->contract?->position?->department?->department_name ?? '-' }}</td>
                            <td>
                                <span class="badge bg-info">{{ $leave->leaveType?->leave_name ?? 'N/A' }}</span>
                            </td>
                            <td>{{ $leave->start_date?->format('d M Y') ?? '-' }}</td>
                            <td>{{ $leave->end_date?->format('d M Y') ?? '-' }}</td>
                            <td>{{ $leave->total_days ?? 0 }} days</td>
                            <td>
                                @if($leave->status == 'approved')
                                    <span class="badge bg-success">Approved</span>
                                @elseif($leave->status == 'rejected')
                                    <span class="badge bg-danger">Rejected</span>
                                @elseif($leave->status == 'pending')
                                    <span class="badge bg-warning">Pending</span>
                                @else
                                    <span class="badge bg-secondary">{{ ucfirst($leave->status) }}</span>
                                @endif
                            </td>
                            <td>{{ Str::limit($leave->reason ?? '-', 30) }}</td>
                            <td>{{ $leave->created_at?->format('d M Y') ?? '-' }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center text-muted py-4">No leave records found</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>

        <div class="mt-3">
            {{ $leaves->links() }}
        </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() {
    const table = document.getElementById('leaveTable');
    const wb = XLSX.utils.table_to_book(table, {sheet: "Leave Report"});
    XLSX.writeFile(wb, `Leave_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 Report', 14, 15);

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

    const table = document.getElementById('leaveTable');
    doc.autoTable({
        html: table,
        startY: 28,
        theme: 'grid',
        headStyles: { fillColor: [79, 70, 229] },
        styles: { fontSize: 8 },
        margin: { top: 28 }
    });

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