@extends('layouts.site')
@php
    $my_name_view = 'Statystyki szkolen - JO';
    $my_short_view_name = 'Statystyki JO';
@endphp
@php
    // Lata bazujemy na danych szkolen.
    $trainingCountByYear = DB::table('t051_szkolenia')
        ->whereNotNull('data')
        ->whereRaw("TRIM(COALESCE(data, '')) <> ''")
        ->select(DB::raw('YEAR(data) as rok'), DB::raw('COUNT(*) as szkolenia_count'))
        ->whereRaw('YEAR(data) > 0')
        ->groupBy(DB::raw('YEAR(data)'))
        ->pluck('szkolenia_count', 'rok');

    // Przypisanie uczestnika do struktury:
    // bierzemy pierwszy aktywny wpis pracownika w strukturze.
    $participantDepartmentSub = DB::table('t021_pracownicy_w_dziale')
        ->select('pracownik_id', DB::raw('MIN(id) as row_id'))
        ->where('status', 1)
        ->groupBy('pracownik_id');

    // Statystyki uczestnikow per rok, z przypisaniem osoby przez strukture.
    // Nie korzystamy z t051.szkolenie_dla_ko_id.
    $participantStatsByYear = DB::table('t052_szkolenie_osoba as so')
        ->join('t051_szkolenia as s', 's.id', '=', 'so.id_szkolenie')
        ->joinSub($participantDepartmentSub, 'pwd_first', function ($join) {
            $join->on('pwd_first.pracownik_id', '=', 'so.id_osoba');
        })
        ->join('t021_pracownicy_w_dziale as pwd', 'pwd.id', '=', 'pwd_first.row_id')
        ->whereNotNull('s.data')
        ->whereRaw("TRIM(COALESCE(s.data, '')) <> ''")
        ->whereRaw('YEAR(s.data) > 0')
        ->select([
            DB::raw('YEAR(s.data) as rok'),
            DB::raw('COUNT(*) as zapisani_count'),
            DB::raw('SUM(CASE WHEN COALESCE(so.zaliczono, 0) = 1 THEN 1 ELSE 0 END) as ukonczyli_pozytywnie_count'),
            DB::raw('SUM(CASE WHEN COALESCE(so.uczestnictwo, 0) = 1 AND COALESCE(so.zaliczono, 0) <> 1 THEN 1 ELSE 0 END) as nie_ukonczyli_pozytywnie_count'),
            DB::raw('SUM(CASE WHEN COALESCE(so.uczestnictwo, 0) <> 1 AND COALESCE(so.zaliczono, 0) <> 1 THEN 1 ELSE 0 END) as nie_przystapili_count'),
        ])
        ->groupBy(DB::raw('YEAR(s.data)'))
        ->get()
        ->keyBy('rok');

    // Zawsze pokazujemy ostatnie 6 lat (nawet gdy wszystkie sa zerowe).
    $currentYear = (int) date('Y');
    $allYears = collect(range($currentYear - 5, $currentYear));

    $yearRows = collect();
    foreach ($allYears as $year) {
        $year = (int) $year;
        $participantStats = $participantStatsByYear->get($year);

        $passedCount = (int) ($participantStats->ukonczyli_pozytywnie_count ?? 0);
        $notPassedCount = (int) ($participantStats->nie_ukonczyli_pozytywnie_count ?? 0);
        $notStartedCount = (int) ($participantStats->nie_przystapili_count ?? 0);
        $signedCount = $passedCount + $notPassedCount + $notStartedCount;

        $yearRows->push([
            'rok' => $year,
            'szkolenia_count' => (int) ($trainingCountByYear[$year] ?? 0),
            'zapisani_count' => $signedCount,
            'ukonczyli_pozytywnie_count' => $passedCount,
            'nie_ukonczyli_pozytywnie_count' => $notPassedCount,
            'nie_przystapili_count' => $notStartedCount,
        ]);
    }

    $orgSummary = [
        'szkolenia_count' => (int) $yearRows->sum('szkolenia_count'),
        'zapisani_count' => (int) $yearRows->sum('zapisani_count'),
        'ukonczyli_pozytywnie_count' => (int) $yearRows->sum('ukonczyli_pozytywnie_count'),
        'nie_ukonczyli_pozytywnie_count' => (int) $yearRows->sum('nie_ukonczyli_pozytywnie_count'),
        'nie_przystapili_count' => (int) $yearRows->sum('nie_przystapili_count'),
    ];

    $chartLabels = $yearRows->pluck('rok')->map(function ($year) {
        return (string) $year;
    })->values();
    $chartPassed = $yearRows->pluck('ukonczyli_pozytywnie_count')->values();
    $chartNotPassed = $yearRows->pluck('nie_ukonczyli_pozytywnie_count')->values();
    $chartNotStarted = $yearRows->pluck('nie_przystapili_count')->values();
@endphp

@section('title', 'SZKOL - Statystyki szkolen - JO')

@section('procesy')
    {{-- Statystyki szkolen nie korzystaja z panelu procesow. --}}
@endsection

@section('content')
    <div class="border-rounded-top tab-content_2 my_TabContentRounded">
        <div class="row site_header">
            <div class="col-8 site_name">
                Statystyki organizacji - uczestnicy szkolen w podziale na lata
            </div>
            <div class="col-4 text-right">
                <x-view-export-buttons
                    id="szkolenia-jo-lata-export-toolbar"
                    target-selector="#szkolenia-jo-lata-export-root"
                    filename-prefix="SZKOL_statystyka_organizacja_lata"
                    :doc-landscape="true"
                />
            </div>
        </div>

        <hr class="separator_site">

        <div id="szkolenia-jo-lata-export-root" style="height: 75vh; overflow-y: auto;">
            @if ($yearRows->count() > 0)
                <div class="px-3 pt-2 pb-3">
                    <div class="p-3" style="background:#f6fbff; border:1px solid #cfe0f2; border-radius:.5rem;">
                        <div class="row mb-3">
                            <div class="col-lg-2 col-md-4 col-sm-6 mb-2">
                                <div class="p-2 text-center" style="background:#eef7ff; border:1px solid #cfe0f2; border-radius:.35rem;">
                                    <div style="font-size:.9rem;">Szkolenia</div>
                                    <strong style="font-size:1.2rem;">{{ $orgSummary['szkolenia_count'] }}</strong>
                                </div>
                            </div>
                            <div class="col-lg-2 col-md-4 col-sm-6 mb-2">
                                <div class="p-2 text-center" style="background:#eef7ff; border:1px solid #cfe0f2; border-radius:.35rem;">
                                    <div style="font-size:.9rem;">Zapisani</div>
                                    <strong style="font-size:1.2rem;">{{ $orgSummary['zapisani_count'] }}</strong>
                                </div>
                            </div>
                            <div class="col-lg-3 col-md-4 col-sm-6 mb-2">
                                <div class="p-2 text-center" style="background:#f4fff6; border:1px solid #cfe8d7; border-radius:.35rem;">
                                    <div style="font-size:.9rem;">Ukonczyli pozytywnie</div>
                                    <strong style="font-size:1.2rem; color:#2fa35a;">{{ $orgSummary['ukonczyli_pozytywnie_count'] }}</strong>
                                </div>
                            </div>
                            <div class="col-lg-3 col-md-6 col-sm-6 mb-2">
                                <div class="p-2 text-center" style="background:#fff8e9; border:1px solid #f2d6a8; border-radius:.35rem;">
                                    <div style="font-size:.9rem;">Ukonczyli negatywnie</div>
                                    <strong style="font-size:1.2rem; color:#e59a2f;">{{ $orgSummary['nie_ukonczyli_pozytywnie_count'] }}</strong>
                                </div>
                            </div>
                            <div class="col-lg-2 col-md-6 col-sm-6 mb-2">
                                <div class="p-2 text-center" style="background:#f4f5f7; border:1px solid #d9dde2; border-radius:.35rem;">
                                    <div style="font-size:.9rem;">Nie przystapili</div>
                                    <strong style="font-size:1.2rem; color:#6c757d;">{{ $orgSummary['nie_przystapili_count'] }}</strong>
                                </div>
                            </div>
                        </div>
                        <div style="position:relative; min-height:320px;">
                            <canvas id="szkoleniaOrgYearsChart"></canvas>
                        </div>
                    </div>
                </div>

                <div class="px-3 pb-3">
                    <div class="col-sm-12 m-md-auto div_new_table px-0">
                        <div class="tab-pane fade show active tableFixHead my_scrollbar_new">
                            <table class="table table-sm new_table_app">
                                <thead>
                                    <tr class="tabela-naglowek">
                                        <th class="text-center">Lp</th>
                                        <th class="text-center">Rok</th>
                                        <th class="text-center">Szkolenia</th>
                                        <th class="text-center">Zapisani</th>
                                        <th class="text-center">Ukonczyli pozytywnie</th>
                                        <th class="text-center">Ukonczyli negatywnie</th>
                                        <th class="text-center">Nie przystapili</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($yearRows as $index => $row)
                                        <tr>
                                            <td class="text-center">{{ $index + 1 }}</td>
                                            <td class="text-center">{{ $row['rok'] }}</td>
                                            <td class="text-center">{{ $row['szkolenia_count'] }}</td>
                                            <td class="text-center">{{ $row['zapisani_count'] }}</td>
                                            <td class="text-center">{{ $row['ukonczyli_pozytywnie_count'] }}</td>
                                            <td class="text-center">{{ $row['nie_ukonczyli_pozytywnie_count'] }}</td>
                                            <td class="text-center">{{ $row['nie_przystapili_count'] }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                                <tfoot>
                                    <tr style="font-weight: 700; background: #eef5ff;">
                                        <td class="text-center">-</td>
                                        <td class="text-center">Suma</td>
                                        <td class="text-center">{{ $orgSummary['szkolenia_count'] }}</td>
                                        <td class="text-center">{{ $orgSummary['zapisani_count'] }}</td>
                                        <td class="text-center">{{ $orgSummary['ukonczyli_pozytywnie_count'] }}</td>
                                        <td class="text-center">{{ $orgSummary['nie_ukonczyli_pozytywnie_count'] }}</td>
                                        <td class="text-center">{{ $orgSummary['nie_przystapili_count'] }}</td>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            @else
                <div class="alert alert-warning m-3">Brak danych do prezentacji.</div>
            @endif
        </div>
    </div>
@endsection

@section('navbar')
    @include('sites.szkol._navbar_szkol')
@endsection

@section('menu')
    @include('sites.szkol.menu_szkol')
@endsection

@push('scripts')
    @if ($yearRows->count() > 0)
        <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.js"></script>
        <script>
            (function () {
                var labels = @json($chartLabels);
                var passed = @json($chartPassed);
                var notPassed = @json($chartNotPassed);
                var notStarted = @json($chartNotStarted);
                var totals = labels.map(function (_, index) {
                    return (Number(passed[index]) || 0) + (Number(notPassed[index]) || 0) + (Number(notStarted[index]) || 0);
                });
                var maxTotal = totals.length ? Math.max.apply(null, totals) : 0;
                var ySuggestedMax = maxTotal + Math.max(2, Math.ceil(maxTotal * 0.1));

                var ctx = document.getElementById('szkoleniaOrgYearsChart').getContext('2d');
                new Chart(ctx, {
                    type: 'bar',
                    data: {
                        labels: labels,
                        datasets: [
                            {
                                label: 'Ukonczyli pozytywnie',
                                data: passed,
                                backgroundColor: 'rgba(47, 163, 90, 0.85)',
                                borderColor: '#2fa35a',
                                borderWidth: 1,
                                stack: 'uczestnicy'
                            },
                            {
                                label: 'Ukonczyli negatywnie',
                                data: notPassed,
                                backgroundColor: 'rgba(229, 154, 47, 0.90)',
                                borderColor: '#e59a2f',
                                borderWidth: 1,
                                stack: 'uczestnicy'
                            },
                            {
                                label: 'Nie przystapili',
                                data: notStarted,
                                backgroundColor: 'rgba(108, 117, 125, 0.88)',
                                borderColor: '#6c757d',
                                borderWidth: 1,
                                stack: 'uczestnicy'
                            }
                        ]
                    },
                    options: {
                        responsive: true,
                        maintainAspectRatio: false,
                        animation: {
                            onComplete: function () {
                                var chart = this;
                                var chartCtx = chart.chart.ctx;
                                var datasetMeta = chart.getDatasetMeta(chart.data.datasets.length - 1);
                                var yAxis = chart.scales['y-axis-0'];

                                chartCtx.save();
                                chartCtx.fillStyle = '#1f2d3d';
                                chartCtx.font = 'bold 11px Arial';
                                chartCtx.textAlign = 'center';
                                chartCtx.textBaseline = 'bottom';

                                labels.forEach(function (_, index) {
                                    var total = (Number(passed[index]) || 0) + (Number(notPassed[index]) || 0) + (Number(notStarted[index]) || 0);
                                    var bar = datasetMeta.data[index];
                                    if (!bar) {
                                        return;
                                    }
                                    var rawLabelY = yAxis.getPixelForValue(total) - 4;
                                    var minLabelY = (chart.chartArea && typeof chart.chartArea.top === 'number') ? chart.chartArea.top + 12 : 12;
                                    var labelY = Math.max(minLabelY, rawLabelY);
                                    chartCtx.fillText(String(total), bar._model.x, labelY);
                                });

                                chartCtx.restore();
                            }
                        },
                        legend: {
                            display: true,
                            position: 'bottom'
                        },
                        layout: {
                            padding: {
                                top: 12
                            }
                        },
                        scales: {
                            xAxes: [{
                                stacked: true,
                                categoryPercentage: 0.8,
                                barPercentage: 0.45,
                                scaleLabel: {
                                    display: true,
                                    labelString: 'Rok'
                                }
                            }],
                            yAxes: [{
                                stacked: true,
                                ticks: {
                                    beginAtZero: true,
                                    precision: 0,
                                    suggestedMax: ySuggestedMax
                                },
                                scaleLabel: {
                                    display: true,
                                    labelString: 'Liczba osob'
                                }
                            }]
                        },
                        tooltips: {
                            mode: 'index',
                            intersect: false
                        }
                    }
                });
            })();
        </script>
    @endif
@endpush