@extends('layouts.app')

@section('content')
<div class="container-fluid py-4">
    <!-- Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h1 class="h3 mb-0">
                        <i class="bi bi-people me-2"></i>Global HR Report
                    </h1>
                    <p class="text-muted">Comprehensive HR analytics across all companies</p>
                </div>
                <div>
                    <a href="{{ route('global.reporting.index') }}" class="btn btn-outline-secondary">
                        <i class="bi bi-arrow-left"></i> Back to Dashboard
                    </a>
                </div>
            </div>
        </div>
    </div>

    <!-- Date Range Filter -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" class="row g-3 align-items-center">
                <div class="col-md-3">
                    <label class="form-label">Date From</label>
                    <input type="date" name="date_from" class="form-control" 
                           value="{{ request('date_from', $dateRange['start']->format('Y-m-d')) }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">Date To</label>
                    <input type="date" name="date_to" class="form-control" 
                           value="{{ request('date_to', $dateRange['end']->format('Y-m-d')) }}">
                </div>
                <div class="col-md-4">
                    <label class="form-label">Company Filter</label>
                    <select name="company_id" class="form-select">
                        <option value="">All Companies</option>
                        @foreach($companies as $company)
                            <option value="{{ $company->id }}" {{ request('company_id') == $company->id ? 'selected' : '' }}>
                                {{ $company->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">
                        <i class="bi bi-search"></i> Filter
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Employee Overview -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card text-white bg-primary">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <i class="bi bi-people fs-2"></i>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <h6 class="mb-1">Total Employees</h6>
                            <h3 class="mb-0">{{ number_format($hrData['employee_overview']['total']) }}</h3>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-success">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <i class="bi bi-person-check fs-2"></i>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <h6 class="mb-1">Active Employees</h6>
                            <h3 class="mb-0">{{ number_format($hrData['employee_overview']['active']) }}</h3>
                            <small>{{ $hrData['employee_overview']['total'] > 0 ? number_format(($hrData['employee_overview']['active'] / $hrData['employee_overview']['total']) * 100, 1) : 0 }}% of total</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-warning">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <i class="bi bi-person-x fs-2"></i>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <h6 class="mb-1">Inactive Employees</h6>
                            <h3 class="mb-0">{{ number_format($hrData['employee_overview']['inactive']) }}</h3>
                            <small>{{ $hrData['employee_overview']['total'] > 0 ? number_format(($hrData['employee_overview']['inactive'] / $hrData['employee_overview']['total']) * 100, 1) : 0 }}% of total</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-info">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <i class="bi bi-building fs-2"></i>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <h6 class="mb-1">Departments</h6>
                            <h3 class="mb-0">{{ $hrData['employee_overview']['by_department']->count() }}</h3>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- HR Analytics Charts Row -->
    <div class="row mb-4">
        <!-- Employee Growth Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-person-plus me-2"></i>Employee Growth Trends
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="employeeGrowthChart" height="300"></canvas>
                </div>
            </div>
        </div>

        <!-- Department Distribution Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-pie-chart me-2"></i>Employees by Department
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="departmentChart" height="300"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Payroll & Attendance Charts Row -->
    <div class="row mb-4">
        <!-- Payroll Trends Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-cash-stack me-2"></i>Payroll Trends
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="hrPayrollTrendsChart" height="300"></canvas>
                </div>
            </div>
        </div>

        <!-- Attendance Analytics Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-clock me-2"></i>Attendance Analytics
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="attendanceChart" height="300"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Employee by Department -->
    @if($hrData['employee_overview']['by_department']->count() > 0)
        <div class="card mb-4">
            <div class="card-header">
                <h5 class="mb-0">Department Summary</h5>
            </div>
            <div class="card-body">
                <div class="row">
                    @foreach($hrData['employee_overview']['by_department'] as $dept)
                        <div class="col-md-4 mb-3">
                            <div class="d-flex justify-content-between align-items-center p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">{{ $dept->department }}</h6>
                                    <span class="badge bg-primary">{{ $dept->count }} employees</span>
                                </div>
                                <div class="text-end">
                                    <div class="progress" style="width: 80px; height: 8px;">
                                        <div class="progress-bar" 
                                             style="width: {{ ($dept->count / $hrData['employee_overview']['by_department']->max('count')) * 100 }}%"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    @endforeach
                </div>
            </div>
        </div>
    @endif

    <!-- Payroll Analytics -->
    <div class="row mb-4">
        <div class="col-lg-8">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Payroll Analytics</h5>
                </div>
                <div class="card-body">
                    <div class="row mb-4">
                        <div class="col-md-3">
                            <div class="text-center">
                                <h4 class="text-success">RM {{ number_format($hrData['payroll_analytics']['total_processed'], 0) }}</h4>
                                <small class="text-muted">Total Processed</small>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="text-center">
                                <h4 class="text-primary">RM {{ number_format($hrData['payroll_analytics']['total_gross'], 0) }}</h4>
                                <small class="text-muted">Total Gross</small>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="text-center">
                                <h4 class="text-info">RM {{ number_format($hrData['payroll_analytics']['average_salary'], 2) }}</h4>
                                <small class="text-muted">Average Salary</small>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="text-center">
                                <h4 class="text-warning">{{ number_format($hrData['payroll_analytics']['payroll_count']) }}</h4>
                                <small class="text-muted">Payroll Records</small>
                            </div>
                        </div>
                    </div>

                    @if($hrData['payroll_analytics']['by_status']->count() > 0)
                        <h6 class="mb-3">Payroll by Status</h6>
                        @foreach($hrData['payroll_analytics']['by_status'] as $status)
                            <div class="mb-2">
                                <div class="d-flex justify-content-between">
                                    <span class="fw-bold">{{ ucfirst($status->status) }}</span>
                                    <span>RM {{ number_format($status->total, 0) }} ({{ $status->count }} records)</span>
                                </div>
                                <div class="progress" style="height: 6px;">
                                    <div class="progress-bar bg-{{ 
                                        $status->status == 'paid' ? 'success' : 
                                        ($status->status == 'processed' ? 'primary' : 'warning') 
                                    }}" 
                                         style="width: {{ ($status->total / $hrData['payroll_analytics']['by_status']->max('total')) * 100 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @endif
                </div>
            </div>
        </div>

        <!-- Payroll Trends -->
        <div class="col-lg-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Monthly Payroll Trends</h5>
                </div>
                <div class="card-body">
                    @if($hrData['payroll_trends']->count() > 0)
                        @foreach($hrData['payroll_trends'] as $trend)
                            <div class="mb-3">
                                <div class="d-flex justify-content-between mb-1">
                                    <span class="fw-bold">{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('M Y') }}</span>
                                    <span>RM {{ number_format($trend->total, 0) }}</span>
                                </div>
                                <small class="text-muted">{{ $trend->count }} payroll records</small>
                                <div class="progress mt-1" style="height: 6px;">
                                    <div class="progress-bar bg-success" 
                                         style="width: {{ ($trend->total / $hrData['payroll_trends']->max('total')) * 100 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <div class="text-center text-muted">
                            <i class="bi bi-graph-down fs-2"></i>
                            <p class="mt-2">No payroll data for selected period</p>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Attendance Analytics -->
    <div class="row mb-4">
        <div class="col-lg-6">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Attendance Analytics</h5>
                </div>
                <div class="card-body">
                    @if($hrData['attendance_trends']->count() > 0)
                        <div class="text-center mb-4">
                            <h3 class="text-primary">{{ number_format($hrData['attendance_trends']->avg('avg_hours'), 1) }}</h3>
                            <p class="text-muted">Average Hours per Day</p>
                        </div>

                        <h6 class="mb-3">Monthly Attendance Trends</h6>
                        @foreach($hrData['attendance_trends'] as $trend)
                            <div class="mb-3">
                                <div class="d-flex justify-content-between mb-1">
                                    <span>{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('M Y') }}</span>
                                    <span class="fw-bold">{{ number_format($trend->avg_hours, 1) }}h</span>
                                </div>
                                <small class="text-muted">{{ $trend->active_employees }} active employees</small>
                                <div class="progress mt-1" style="height: 8px;">
                                    <div class="progress-bar bg-info" 
                                         style="width: {{ ($trend->avg_hours / 8) * 100 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <div class="text-center text-muted">
                            <i class="bi bi-clock fs-2"></i>
                            <p class="mt-2">No attendance data for selected period</p>
                        </div>
                    @endif
                </div>
            </div>
        </div>

        <!-- Expense Analytics -->
        <div class="col-lg-6">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Expense Claims Analytics</h5>
                </div>
                <div class="card-body">
                    @if($hrData['expense_trends']->count() > 0)
                        <div class="text-center mb-4">
                            <h3 class="text-danger">RM {{ number_format($hrData['expense_trends']->sum('total_amount'), 0) }}</h3>
                            <p class="text-muted">Total Expense Claims</p>
                        </div>

                        <h6 class="mb-3">Monthly Expense Trends</h6>
                        @foreach($hrData['expense_trends'] as $trend)
                            <div class="mb-3">
                                <div class="d-flex justify-content-between mb-1">
                                    <span>{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('M Y') }}</span>
                                    <span class="fw-bold">RM {{ number_format($trend->total_amount, 0) }}</span>
                                </div>
                                <small class="text-muted">{{ $trend->claim_count }} claims</small>
                                <div class="progress mt-1" style="height: 8px;">
                                    <div class="progress-bar bg-danger" 
                                         style="width: {{ ($trend->total_amount / $hrData['expense_trends']->max('total_amount')) * 100 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <div class="text-center text-muted">
                            <i class="bi bi-receipt fs-2"></i>
                            <p class="mt-2">No expense data for selected period</p>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Leave Analytics -->
    @if($hrData['leave_utilization']->count() > 0)
        <div class="card mb-4">
            <div class="card-header">
                <h5 class="mb-0">Leave Utilization</h5>
            </div>
            <div class="card-body">
                <div class="row">
                    @foreach($hrData['leave_utilization'] as $leave)
                        <div class="col-md-3 mb-3">
                            <div class="card">
                                <div class="card-body text-center">
                                    <i class="bi bi-calendar-x fs-2 text-{{ 
                                        $leave->leave_type == 'annual' ? 'primary' : 
                                        ($leave->leave_type == 'sick' ? 'danger' : 'info') 
                                    }}"></i>
                                    <h6 class="mt-2">{{ ucfirst($leave->leave_type) }} Leave</h6>
                                    <h4 class="text-{{ 
                                        $leave->leave_type == 'annual' ? 'primary' : 
                                        ($leave->leave_type == 'sick' ? 'danger' : 'info') 
                                    }}">
                                        {{ $leave->total_days }} days
                                    </h4>
                                    <small class="text-muted">{{ $leave->count }} requests</small>
                                </div>
                            </div>
                        </div>
                    @endforeach
                </div>
            </div>
        </div>
    @endif

    <!-- Company HR Stats -->
    @if(isset($hrData['company_hr_stats']) && $hrData['company_hr_stats']->count() > 0)
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0">HR Statistics by Company</h5>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-hover mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Company</th>
                                <th>Employees</th>
                                <th>Payroll Processed</th>
                                <th>Avg Salary</th>
                                <th>Attendance Rate</th>
                                <th>Leave Utilization</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($hrData['company_hr_stats'] as $stats)
                                <tr>
                                    <td>
                                        <div class="d-flex align-items-center">
                                            <div class="bg-primary rounded-circle me-2" style="width: 30px; height: 30px; display: flex; align-items: center; justify-content: center;">
                                                <span class="text-white fw-bold" style="font-size: 12px;">
                                                    {{ strtoupper(substr($stats->company_name, 0, 1)) }}
                                                </span>
                                            </div>
                                            <span class="fw-bold">{{ $stats->company_name }}</span>
                                        </div>
                                    </td>
                                    <td>
                                        <span class="badge bg-primary">{{ $stats->employee_count }}</span>
                                    </td>
                                    <td>
                                        <span class="fw-bold text-success">RM {{ number_format($stats->total_payroll, 0) }}</span>
                                    </td>
                                    <td>
                                        RM {{ number_format($stats->avg_salary, 2) }}
                                    </td>
                                    <td>
                                        <span class="badge bg-info">{{ number_format($stats->attendance_rate, 1) }}%</span>
                                    </td>
                                    <td>
                                        <span class="badge bg-warning">{{ $stats->total_leave_days }} days</span>
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif
</div>

@push('styles')
<style>
.progress {
    background-color: rgba(0, 0, 0, 0.1);
}

.card {
    box-shadow: 0 0.125rem 0.25rem rgba(0, 0, 0, 0.075);
    border: 1px solid rgba(0, 0, 0, 0.125);
}
</style>
@endpush

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    
    // Employee Growth Chart
    const employeeGrowthCtx = document.getElementById('employeeGrowthChart').getContext('2d');
    const employeeGrowthChart = new Chart(employeeGrowthCtx, {
        type: 'line',
        data: {
            labels: [
                @foreach($hrData['employee_growth'] ?? [] as $growth)
                    '{{ \Carbon\Carbon::createFromFormat('Y-m', $growth->month)->format('M Y') }}',
                @endforeach
            ],
            datasets: [{
                label: 'New Employees',
                data: [
                    @foreach($hrData['employee_growth'] ?? [] as $growth)
                        {{ $growth->count }},
                    @endforeach
                ],
                borderColor: '#0dcaf0',
                backgroundColor: 'rgba(13, 202, 240, 0.1)',
                borderWidth: 3,
                fill: true,
                tension: 0.4
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'top'
                }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'New Employees'
                    }
                }
            }
        }
    });

    // Department Distribution Pie Chart
    const departmentCtx = document.getElementById('departmentChart').getContext('2d');
    const departmentChart = new Chart(departmentCtx, {
        type: 'doughnut',
        data: {
            labels: [
                @foreach($hrData['employee_overview']['by_department'] as $dept)
                    '{{ $dept->department }}',
                @endforeach
            ],
            datasets: [{
                data: [
                    @foreach($hrData['employee_overview']['by_department'] as $dept)
                        {{ $dept->count }},
                    @endforeach
                ],
                backgroundColor: [
                    '#0d6efd',
                    '#198754', 
                    '#fd7e14',
                    '#dc3545',
                    '#6f42c1',
                    '#20c997',
                    '#e83e8c',
                    '#ffc107',
                    '#17a2b8',
                    '#28a745'
                ],
                borderWidth: 2,
                borderColor: '#fff'
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'bottom'
                }
            }
        }
    });

    // Payroll Trends Chart
    const hrPayrollTrendsCtx = document.getElementById('hrPayrollTrendsChart').getContext('2d');
    const hrPayrollTrendsChart = new Chart(hrPayrollTrendsCtx, {
        type: 'bar',
        data: {
            labels: [
                @foreach($hrData['payroll_trends'] ?? [] as $trend)
                    '{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('M Y') }}',
                @endforeach
            ],
            datasets: [{
                label: 'Payroll Amount (RM)',
                data: [
                    @foreach($hrData['payroll_trends'] ?? [] as $trend)
                        {{ $trend->total }},
                    @endforeach
                ],
                backgroundColor: '#198754',
                borderColor: '#146c43',
                borderWidth: 1
            }, {
                label: 'Payroll Count',
                data: [
                    @foreach($hrData['payroll_trends'] ?? [] as $trend)
                        {{ $trend->count }},
                    @endforeach
                ],
                backgroundColor: '#fd7e14',
                borderColor: '#fd7e14',
                borderWidth: 1,
                yAxisID: 'y1'
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'top'
                }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Amount (RM)'
                    }
                },
                y1: {
                    type: 'linear',
                    display: true,
                    position: 'right',
                    title: {
                        display: true,
                        text: 'Count'
                    },
                    grid: {
                        drawOnChartArea: false,
                    },
                    beginAtZero: true
                }
            }
        }
    });

    // Attendance Analytics Chart
    const attendanceCtx = document.getElementById('attendanceChart').getContext('2d');
    const attendanceChart = new Chart(attendanceCtx, {
        type: 'line',
        data: {
            labels: [
                @foreach($hrData['attendance_trends'] ?? [] as $attendance)
                    '{{ \Carbon\Carbon::createFromFormat('Y-m', $attendance->month)->format('M Y') }}',
                @endforeach
            ],
            datasets: [{
                label: 'Average Hours',
                data: [
                    @foreach($hrData['attendance_trends'] ?? [] as $attendance)
                        {{ round($attendance->avg_hours, 1) }},
                    @endforeach
                ],
                borderColor: '#6f42c1',
                backgroundColor: 'rgba(111, 66, 193, 0.1)', 
                borderWidth: 3,
                fill: true,
                tension: 0.4
            }, {
                label: 'Active Employees',
                data: [
                    @foreach($hrData['attendance_trends'] ?? [] as $attendance)
                        {{ $attendance->active_employees }},
                    @endforeach
                ],
                borderColor: '#dc3545',
                backgroundColor: 'rgba(220, 53, 69, 0.1)',
                borderWidth: 2,
                fill: false,
                yAxisID: 'y1'
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'top'
                }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Hours'
                    }
                },
                y1: {
                    type: 'linear',
                    display: true,
                    position: 'right',
                    title: {
                        display: true,
                        text: 'Employees'
                    },
                    grid: {
                        drawOnChartArea: false,
                    },
                    beginAtZero: true
                }
            }
        }
    });

});
</script>
@endpush
@endsection