@extends('layouts.mainlayout')
@section('fullwidth', true)

@section('content')
@php
    $dashboardMetrics = [
        'total_staff' => DB::table('ourstaffs')->count(),
        'active_staff' => DB::table('ourstaffs')->where('status', 2)->count(),
        'active_farms' => DB::table('farm')->where('status', 1)->count(),
        'open_transit' => DB::table('tranzit')->whereIn('status', [1, 2, 6])->count(),
    ];

    $transitSnapshot = [
        'today_arrivals' => DB::table('tranzit')->whereDate('arrival_date', date('Y-m-d'))->count(),
        'tomorrow_arrivals' => DB::table('tranzit')->whereDate('arrival_date', date('Y-m-d', strtotime('+1 day')))->count(),
        'pending_requests' => DB::table('tranzit')->where('status', 1)->count(),
    ];

    $transitSummaryPreview = DB::table('tranzit')
        ->select('arrival_date', DB::raw('COUNT(*) as travel_count'))
        ->whereIn('status', [1, 2])
        ->whereDate('arrival_date', '>=', date('Y-m-d'))
        ->groupBy('arrival_date')
        ->orderBy('arrival_date')
        ->limit(3)
        ->get();

    $recentActivity = DB::table('log')
        ->leftJoin('users', 'users.id', '=', 'log.user')
        ->where('log.content', 'not like', '%chart generated%')
        ->select('log.id', 'log.dattim', 'log.content', 'log.role', 'users.name')
        ->orderByDesc('log.id')
        ->limit(6)
        ->get();

    $dashboardChartData = \App\Services\DashboardChartData::build();

    $charts = [
        ["id" => "farm-staff", "title" => "Active farm staff", "description" => "Current staff distribution across active farms.", "icon" => "fa-users", "url" => "/activestaffs"],
        ["id" => "contracts", "title" => "New contracts by year", "description" => "Yearly development of registered employment contracts.", "icon" => "fa-file-signature", "url" => null],
        ["id" => "potential-departures", "title" => "Potential departures", "description" => "Active farm staff approaching or passing 90 days.", "icon" => "fa-user-clock", "url" => "/farm_staffs_potential_departed"],
        ["id" => "gender", "title" => "Active staff by gender", "description" => "Gender distribution among currently active staff.", "icon" => "fa-venus-mars", "url" => null],
        ["id" => "transit", "title" => "Finalized transit by month", "description" => "Completed transit activity during ".date("Y").".", "icon" => "fa-plane", "url" => "/tranzit_charts"],
        ["id" => "usage", "title" => "Weekly program usage", "description" => "Application usage activity during ".date("Y").".", "icon" => "fa-chart-line", "url" => null],
    ];
@endphp

<div class="smarthr-dashboard">
    <div class="smarthr-dashboard-heading smarthr-demo-page-breadcrumb smarthr-module-page-header">
        <div>
            <h2>Admin Dashboard</h2>
            <ol><li><a href="/home"><i class="fas fa-home"></i></a></li><li>Dashboard</li><li class="active">Admin Dashboard</li></ol>
        </div>
        <div class="smarthr-dashboard-period">
            <i class="far fa-calendar-alt" aria-hidden="true"></i>
            {{ date('F Y') }}
        </div>
    </div>

    <section class="smarthr-welcome-card" aria-labelledby="dashboard-welcome-title">
        <div class="smarthr-welcome-copy">
            <span class="smarthr-welcome-icon"><i class="fas fa-chart-pie" aria-hidden="true"></i></span>
            <div>
                <h2 id="dashboard-welcome-title">Welcome back, {{ Auth::user()->name }}</h2>
                <p>Here is the latest overview of your manpower operations.</p>
            </div>
        </div>
        <div class="smarthr-welcome-actions">
            <a href="/newstaff" class="btn btn-light"><i class="fas fa-user-plus" aria-hidden="true"></i> Add staff</a>
            <a href="/tranzit_list_req" class="btn btn-smarthr-primary"><i class="fas fa-plane-departure" aria-hidden="true"></i> Transit requests</a>
        </div>
    </section>

    <section class="smarthr-dashboard-card smarthr-dashboard-transit-summary" aria-labelledby="dashboard-summary-title">
        <header class="smarthr-simple-card-header">
            <div>
                <h3 id="dashboard-summary-title">Transit summary</h3>
                <p>Upcoming travel dates included in the general email summary.</p>
            </div>
            <a href="/summary" class="smarthr-card-link">View summary <i class="fas fa-arrow-right" aria-hidden="true"></i></a>
        </header>
        <div class="smarthr-summary-list">
            @forelse($transitSummaryPreview as $summaryDate)
                <a href="/summary?date_from={{ $summaryDate->arrival_date }}&amp;date_to={{ $summaryDate->arrival_date }}">
                    <span><i class="far fa-calendar-alt icon-blue" aria-hidden="true"></i> {{ date('F j, Y', strtotime($summaryDate->arrival_date)) }}</span>
                    <strong>{{ $summaryDate->travel_count }} {{ $summaryDate->travel_count == 1 ? 'travel' : 'travels' }}</strong>
                </a>
            @empty
                <div class="smarthr-empty-state">No upcoming transit summary records.</div>
            @endforelse
        </div>
    </section>

    <section class="row smarthr-metric-row" aria-label="Key metrics">
        <div class="col-xl-3 col-md-6">
            <a class="smarthr-metric-card" href="/staff">
                <span class="smarthr-metric-icon icon-blue"><i class="fas fa-users" aria-hidden="true"></i></span>
                <span class="smarthr-metric-content">
                    <small>Total staff</small>
                    <strong>{{ number_format($dashboardMetrics['total_staff']) }}</strong>
                    <span>All staff records</span>
                </span>
                <i class="fas fa-arrow-right smarthr-metric-arrow" aria-hidden="true"></i>
            </a>
        </div>
        <div class="col-xl-3 col-md-6">
            <a class="smarthr-metric-card" href="/activestaffs">
                <span class="smarthr-metric-icon icon-green"><i class="fas fa-user-check" aria-hidden="true"></i></span>
                <span class="smarthr-metric-content">
                    <small>Active staff</small>
                    <strong>{{ number_format($dashboardMetrics['active_staff']) }}</strong>
                    <span>Currently active</span>
                </span>
                <i class="fas fa-arrow-right smarthr-metric-arrow" aria-hidden="true"></i>
            </a>
        </div>
        <div class="col-xl-3 col-md-6">
            <div class="smarthr-metric-card">
                <span class="smarthr-metric-icon icon-orange"><i class="fas fa-seedling" aria-hidden="true"></i></span>
                <span class="smarthr-metric-content">
                    <small>Active farms</small>
                    <strong>{{ number_format($dashboardMetrics['active_farms']) }}</strong>
                    <span>Operational locations</span>
                </span>
            </div>
        </div>
        <div class="col-xl-3 col-md-6">
            <a class="smarthr-metric-card" href="/tranzit_list_req">
                <span class="smarthr-metric-icon icon-purple"><i class="fas fa-route" aria-hidden="true"></i></span>
                <span class="smarthr-metric-content">
                    <small>Open transit</small>
                    <strong>{{ number_format($dashboardMetrics['open_transit']) }}</strong>
                    <span>Requires monitoring</span>
                </span>
                <i class="fas fa-arrow-right smarthr-metric-arrow" aria-hidden="true"></i>
            </a>
        </div>
    </section>

    <section class="smarthr-section-heading">
        <div>
            <h2>Workforce analytics</h2>
            <p>The existing operational charts in the new dashboard layout.</p>
        </div>
    </section>

    <section class="row smarthr-chart-grid">
        @foreach($charts as $dashboardChart)
            <div class="col-xl-6 d-flex">
                <article class="smarthr-dashboard-card smarthr-chart-card">
                    <header class="smarthr-card-header">
                        <div class="smarthr-card-title">
                            <span><i class="fas {{ $dashboardChart['icon'] }}" aria-hidden="true"></i></span>
                            <div>
                                <h3>{{ $dashboardChart['title'] }}</h3>
                                <p>{{ $dashboardChart['description'] }}</p>
                            </div>
                        </div>
                        @if($dashboardChart['url'])
                            <a href="{{ $dashboardChart['url'] }}" class="smarthr-card-link" aria-label="View {{ $dashboardChart['title'] }} details">
                                View details <i class="fas fa-arrow-right" aria-hidden="true"></i>
                            </a>
                        @endif
                    </header>
                    <div class="smarthr-chart-body">
                        <div id="smarthr-chart-{{ $dashboardChart['id'] }}" class="smarthr-apex-chart" role="img" aria-label="{{ $dashboardChart['title'] }} chart"></div>
                    </div>
                </article>
            </div>
        @endforeach
    </section>


    <section class="row smarthr-dashboard-bottom">
        <div class="col-xl-4 d-flex">
            <article class="smarthr-dashboard-card smarthr-summary-card">
                <header class="smarthr-simple-card-header">
                    <div>
                        <h3>Transit snapshot</h3>
                        <p>Current and upcoming travel activity.</p>
                    </div>
                    <i class="fas fa-plane" aria-hidden="true"></i>
                </header>
                <div class="smarthr-summary-list">
                    <a href="/today_travels">
                        <span><i class="fas fa-plane-arrival icon-blue" aria-hidden="true"></i> Arrivals today</span>
                        <strong>{{ $transitSnapshot['today_arrivals'] }}</strong>
                    </a>
                    <a href="/arrival_departure">
                        <span><i class="fas fa-calendar-day icon-green" aria-hidden="true"></i> Arrivals tomorrow</span>
                        <strong>{{ $transitSnapshot['tomorrow_arrivals'] }}</strong>
                    </a>
                    <a href="/tranzit_list_req">
                        <span><i class="fas fa-exclamation-circle icon-orange" aria-hidden="true"></i> Pending requests</span>
                        <strong>{{ $transitSnapshot['pending_requests'] }}</strong>
                    </a>
                </div>
            </article>
        </div>

        <div class="col-xl-4 d-flex">
            <article class="smarthr-dashboard-card smarthr-actions-card">
                <header class="smarthr-simple-card-header">
                    <div>
                        <h3>Quick actions</h3>
                        <p>Frequently used CRM functions.</p>
                    </div>
                    <i class="fas fa-bolt" aria-hidden="true"></i>
                </header>
                <div class="smarthr-quick-actions">
                    <a href="/newstaff"><i class="fas fa-user-plus" aria-hidden="true"></i><span>New staff</span></a>
                    <a href="/staff"><i class="fas fa-search" aria-hidden="true"></i><span>Find staff</span></a>
                    <a href="/csvlists"><i class="fas fa-file-csv" aria-hidden="true"></i><span>CSV lists</span></a>
                    <a href="/tranzit_charts"><i class="fas fa-chart-bar" aria-hidden="true"></i><span>Reports</span></a>
                </div>
            </article>
        </div>

        <div class="col-xl-4 d-flex">
            <article class="smarthr-dashboard-card smarthr-activity-card">
                <header class="smarthr-simple-card-header">
                    <div>
                        <h3>Recent activity</h3>
                        <p>Latest operational actions.</p>
                    </div>
                    <i class="fas fa-history" aria-hidden="true"></i>
                </header>
                <div class="smarthr-activity-list">
                    @forelse($recentActivity as $activity)
                        <div class="smarthr-activity-item">
                            <span class="smarthr-activity-dot"></span>
                            <div>
                                <p>{{ $activity->content }}</p>
                                <small>{{ $activity->name ?: $activity->role }} &middot; {{ date('M j, H:i', strtotime($activity->dattim)) }}</small>
                            </div>
                        </div>
                    @empty
                        <div class="smarthr-empty-state">No recent activity.</div>
                    @endforelse
                </div>
            </article>
        </div>
    </section>
    <script id="smarthr-dashboard-chart-data" type="application/json">@json($dashboardChartData)</script>
    <script src="/vendor/apexcharts/apexcharts.min.js?v=0.4.0"></script>
    <script src="/js/smarthr-dashboard-charts.js?v=0.4.0"></script>
</div>
@endsection