@extends('layouts.app')
@section('title','Executive Dashboard')
@section('page-title','Executive Dashboard')

@section('content')
<div class="page-header">
    <div class="d-flex align-items-start justify-content-between flex-wrap gap-2">
        <div>
            <h1>Executive Dashboard</h1>
            <nav aria-label="breadcrumb"><ol class="breadcrumb"><li class="breadcrumb-item active">Overview</li></ol></nav>
        </div>
        <div class="text-end">
            <div class="fw-semibold" style="font-size:.82rem;color:#64748b;">{{ now()->format('l, F j, Y') }}</div>
            <div style="font-size:.75rem;color:#94a3b8;">University of Liberia</div>
        </div>
    </div>
</div>

<!-- Stat Cards Row 1 -->
<div class="row g-3 mb-4">
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-primary">
            <div class="stat-icon"><i class="bi bi-people-fill"></i></div>
            <div class="stat-value">{{ number_format($total_employees) }}</div>
            <div class="stat-label">Active Employees</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-teal">
            <div class="stat-icon"><i class="bi bi-building"></i></div>
            <div class="stat-value">{{ $total_departments }}</div>
            <div class="stat-label">Departments</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-warning">
            <div class="stat-icon"><i class="bi bi-hourglass-split"></i></div>
            <div class="stat-value">{{ $pending_leaves }}</div>
            <div class="stat-label">Pending Approvals</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-gold">
            <div class="stat-icon"><i class="bi bi-currency-dollar"></i></div>
            <div class="stat-value">${{ number_format($monthly_payroll_usd/1000,1) }}K</div>
            <div class="stat-label">Monthly Payroll</div>
        </div>
    </div>
</div>

<div class="row g-3 mb-4">
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-danger">
            <div class="stat-icon"><i class="bi bi-shield-exclamation"></i></div>
            <div class="stat-value">{{ $discipline_open }}</div>
            <div class="stat-label">Open Cases</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-success">
            <div class="stat-icon"><i class="bi bi-calendar-check"></i></div>
            <div class="stat-value">{{ $leaves_this_month }}</div>
            <div class="stat-label">Leaves This Month</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-info">
            <div class="stat-icon"><i class="bi bi-mortarboard"></i></div>
            <div class="stat-value">{{ $trainings_scheduled }}</div>
            <div class="stat-label">Scheduled Trainings</div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card stat-card-purple">
            <div class="stat-icon"><i class="bi bi-bar-chart-steps"></i></div>
            <div class="stat-value">{{ $evaluations_pending }}</div>
            <div class="stat-label">Evals Pending Review</div>
        </div>
    </div>
</div>

<div class="row g-3">
    <!-- Leave Trend Chart -->
    <div class="col-12 col-lg-8">
        <div class="card h-100">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span><i class="bi bi-graph-up-arrow me-2 text-primary"></i>Leave Trend — Last 6 Months</span>
            </div>
            <div class="card-body">
                <canvas id="leaveTrendChart" height="100"></canvas>
            </div>
        </div>
    </div>

    <!-- Employment Type Breakdown -->
    <div class="col-12 col-lg-4">
        <div class="card h-100">
            <div class="card-header"><i class="bi bi-pie-chart me-2 text-primary"></i>Staff Breakdown</div>
            <div class="card-body d-flex flex-column align-items-center justify-content-center">
                <canvas id="staffBreakdownChart" height="180"></canvas>
            </div>
        </div>
    </div>

    <!-- Department Headcount -->
    <div class="col-12 col-lg-6">
        <div class="card">
            <div class="card-header"><i class="bi bi-building me-2 text-primary"></i>Department Headcount</div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table mb-0">
                        <thead><tr><th>Department</th><th>Type</th><th class="text-end">Staff</th></tr></thead>
                        <tbody>
                        @foreach($dept_headcount as $dept)
                        <tr>
                            <td class="fw-semibold">{{ $dept->name }}</td>
                            <td><span class="badge bg-light text-dark text-capitalize">{{ str_replace('_',' ',$dept->type) }}</span></td>
                            <td class="text-end">
                                <span class="fw-bold text-primary">{{ $dept->active_count }}</span>
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <!-- Pending Approvals -->
    <div class="col-12 col-lg-6">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span><i class="bi bi-hourglass-split me-2 text-warning"></i>Awaiting Your Approval</span>
                <a href="{{ route('leaves.index') }}?status=hr_approved" class="btn btn-sm btn-outline-primary">View All</a>
            </div>
            <div class="card-body p-0">
                @forelse($pending_approvals as $leave)
                <div class="d-flex align-items-center gap-3 px-3 py-2 border-bottom">
                    <div class="avatar avatar-sm" style="background:linear-gradient(135deg,#003366,#0055b3);color:#fff;flex-shrink:0;">
                        {{ strtoupper(substr($leave->employee->first_name,0,1)) }}
                    </div>
                    <div class="flex-1 overflow-hidden">
                        <div class="fw-semibold" style="font-size:.84rem;white-space:nowrap;overflow:hidden;text-overflow:ellipsis;">{{ $leave->employee->full_name }}</div>
                        <div class="text-muted-sm">{{ $leave->leaveType->name }} · {{ $leave->date_from->format('M d') }}–{{ $leave->date_to->format('M d, Y') }}</div>
                    </div>
                    <div class="d-flex gap-1 flex-shrink-0">
                        <form method="POST" action="{{ route('leaves.approve_president', $leave) }}" class="d-inline">
                            @csrf
                            <button class="btn btn-success btn-sm btn-icon" title="Approve"><i class="bi bi-check-lg"></i></button>
                        </form>
                        <a href="{{ route('leaves.show', $leave) }}" class="btn btn-outline-secondary btn-sm btn-icon" title="View"><i class="bi bi-eye"></i></a>
                    </div>
                </div>
                @empty
                <div class="text-center py-4 text-muted-sm"><i class="bi bi-check-circle text-success d-block fs-3 mb-1"></i>No pending approvals</div>
                @endforelse
            </div>
        </div>
    </div>

    <!-- Announcements -->
    <div class="col-12">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span><i class="bi bi-megaphone me-2 text-primary"></i>Recent Announcements</span>
            </div>
            <div class="row g-0">
                @forelse($announcements as $ann)
                <div class="col-12 col-md-6 col-lg-4 p-3">
                    <div class="border rounded-3 p-3 h-100" style="border-color:#e8ecf0!important;">
                        <div class="d-flex justify-content-between mb-2">
                            <span class="badge bg-{{ $ann->priority === 'urgent' ? 'danger' : ($ann->priority === 'high' ? 'warning' : 'secondary') }}">{{ ucfirst($ann->priority) }}</span>
                            <span class="text-muted-sm">{{ $ann->publish_date->format('M d') }}</span>
                        </div>
                        <div class="fw-bold mb-1" style="font-size:.9rem;">{{ $ann->title }}</div>
                        <div style="font-size:.8rem;color:#64748b;line-height:1.5;">{{ Str::limit($ann->content, 100) }}</div>
                    </div>
                </div>
                @empty
                <div class="col-12 text-center py-3 text-muted-sm">No announcements</div>
                @endforelse
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
// Leave Trend
const trendData = @json($leave_trend);
new Chart(document.getElementById('leaveTrendChart'), {
    type: 'bar',
    data: {
        labels: trendData.map(d => d.month),
        datasets: [{
            label: 'Total Leaves',
            data: trendData.map(d => d.count),
            backgroundColor: 'rgba(0,51,102,.15)',
            borderColor: '#003366',
            borderWidth: 2,
            borderRadius: 8,
        },{
            label: 'Approved',
            data: trendData.map(d => d.approved),
            backgroundColor: 'rgba(13,104,65,.15)',
            borderColor: '#198754',
            borderWidth: 2,
            borderRadius: 8,
        }]
    },
    options: { responsive:true, plugins:{ legend:{ position:'top' } }, scales:{ y:{ beginAtZero:true, ticks:{ stepSize:1 } } } }
});

// Staff Breakdown
const empTypes = @json($employment_types);
const colors = ['#003366','#0055b3','#198754','#d4af37'];
new Chart(document.getElementById('staffBreakdownChart'), {
    type: 'doughnut',
    data: {
        labels: Object.keys(empTypes).map(k => k.replace('_',' ').replace(/\b\w/g,c=>c.toUpperCase())),
        datasets: [{ data: Object.values(empTypes), backgroundColor: colors, borderWidth: 0 }]
    },
    options: { responsive:true, cutout:'70%', plugins:{ legend:{ position:'bottom', labels:{ font:{ size:11 } } } } }
});
</script>
@endpush