@extends('organizations.layouts.default')
@section('content')
    <main>
        <div class="max-w-screen-2xl mx-auto p-2 md:p-2 2xl:p-4">
            <div class="flex justify-between m-0 p-0">
                @include('organizations.layouts.partials.breadcrumb')
                <div class="">
                    <button onclick="printDiv('printable')"
                        class="mt-4 bg-brandBlue text-white px-4 py-2 rounded-lg hover:bg-brandOrange">
                        <i class="bi bi-printer"></i> Print
                    </button>
                </div>
                <div class="py-2">
                    <a type="button"
                        class="text-white bg-brandOrange hover:bg-brandBlue focus:outline-none focus:ring-4 focus:ring-red-300 font-medium rounded-full text-md px-5 py-2.5 text-center me-2 mb-2 dark:bg-red-600 dark:hover:bg-red-700 dark:focus:ring-red-900"
                        href="{{ url()->previous() }}">
                        <i class="bi bi-arrow-left me-2"></i>Back
                    </a>
                </div>
            </div>
            <div class="flex flex-col gap-10 mt-2" id="printable">
                <div
                    class="rounded-sm border border-stroke bg-white px-5 pt-6 pb-2.5 shadow-default dark:border-strokedark dark:bg-boxdark sm:px-7.5 xl:pb-1">
                    <div class="max-w-full overflow-x-auto">
                        @php
                            $groupedEvaluation = $summary->groupBy('criteria_name');
                            $tender = $summary->pluck('applications.tenders.title')->unique()->first();
                            $uniqueApplicants = $summary
                                ->pluck('applications.applicants.name', 'application_id')
                                ->unique();
                            $uniqueEvaluators = $summary->pluck('evaluators.name', 'evaluator_id')->unique();
                            $totalFullMarks = $groupedEvaluation->sum(fn($results) => $results->first()->full_marks);
                            $applicantEvaluatorTotals = [];

                            // Calculate average scores for ranking
                            $applicantAverages = [];
                            foreach ($uniqueApplicants as $applicantId => $applicantName) {
                                $applicantTotalMarks = $summary
                                    ->where('application_id', $applicantId)
                                    ->sum('obtained_marks');
                                $applicantAverages[$applicantId] = [
                                    'name' => $applicantName,
                                    'average' => $applicantTotalMarks / $uniqueEvaluators->count(),
                                ];
                            }
                            $rankedApplicants = collect($applicantAverages)->sortByDesc('average')->values();
                        @endphp
                        @if ($totalFullMarks > 0)
                            <table class="w-full table-auto">
                                <h1 class="font-semibold text-2xl text-center py-4 underline">
                                    Evaluation summary of tender " {{ $tender }} " based on the applications
                                </h1>
                                <thead>
                                    <tr class="bg-gray-2 text-center dark:bg-meta-4">
                                        <th
                                            class="font-semibold text-black dark:text-white xl:pl-11 border border-[#eee] py-4 px-2 dark:border-strokedark">
                                            S.N</th>
                                        <th
                                            class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white">
                                            Criteria</th>
                                        <th
                                            class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white">
                                            Full Mark</th>
                                        @foreach ($uniqueApplicants as $applicant)
                                            <th class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white"
                                                colspan="{{ $uniqueEvaluators->count() }}">
                                                <div class="text-center">
                                                    <p class="border-b border-[#eee] p-2 dark:border-strokedark">
                                                        Applicant:
                                                        {{ $applicant }}</p>
                                                    <div class="grid grid-cols-{{ $uniqueEvaluators->count() }}">
                                                        @foreach ($uniqueEvaluators as $evaluatorName)
                                                            <p class="px-2">{{ $evaluatorName }}</p>
                                                        @endforeach
                                                    </div>
                                                </div>
                                            </th>
                                        @endforeach
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($groupedEvaluation as $criteria => $results)
                                        <tr class="text-center">
                                            <td
                                                class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white xl:pl-11">
                                                {{ nepali_number($loop->iteration) }}.</td>
                                            <td class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold">
                                                {{ $criteria }}</td>
                                            <td class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold">
                                                {{ $results->first()->full_marks }}</td>
                                            @foreach ($uniqueApplicants as $applicantId => $applicant)
                                                @foreach ($uniqueEvaluators as $evaluatorId => $evaluatorName)
                                                    @php
                                                        $marks =
                                                            $results
                                                                ->where('application_id', $applicantId)
                                                                ->where('evaluator_id', $evaluatorId)
                                                                ->first()->obtained_marks ?? 0;
                                                        $applicantEvaluatorTotals[$applicantId][$evaluatorId] =
                                                            ($applicantEvaluatorTotals[$applicantId][$evaluatorId] ??
                                                                0) +
                                                            $marks;
                                                    @endphp
                                                    <td
                                                        class="border border-[#eee] py-4 px-2 dark:border-strokedark text-center">
                                                        {{ $marks }}</td>
                                                @endforeach
                                            @endforeach
                                        </tr>
                                    @endforeach
                                </tbody>
                                <tfoot>
                                    <tr class="bg-gray-2 text-center dark:bg-meta-4">
                                        <th class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white"
                                            colspan="2">
                                            Total</th>
                                        <th
                                            class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white">
                                            {{ $totalFullMarks }}
                                        </th>
                                        @foreach ($uniqueApplicants as $applicantId => $applicant)
                                            @foreach ($uniqueEvaluators as $evaluatorId => $evaluatorName)
                                                <th
                                                    class="border border-[#eee] py-4 px-2 dark:border-strokedark text-center font-semibold text-black dark:text-white">
                                                    {{ $applicantEvaluatorTotals[$applicantId][$evaluatorId] ?? 0 }}
                                                </th>
                                            @endforeach
                                        @endforeach
                                    </tr>
                                    <tr class="bg-gray-2 text-center dark:bg-meta-4">
                                        <th class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white"
                                            colspan="2">
                                            Average</th>
                                        <th class="border border-[#eee] py-4 px-2 dark:border-strokedark"></th>
                                        {{-- @foreach ($uniqueApplicants as $applicantId => $applicant)
                                            @php
                                                $avg = $summary
                                                    ->where('application_id', $applicantId)
                                                    ->sum('obtained_marks');
                                                $average = $avg / count($uniqueEvaluators);
                                            @endphp
                                            <th class="border border-[#eee] py-4 px-2 dark:border-strokedark text-center font-semibold text-black dark:text-white"
                                                colspan="{{ $uniqueEvaluators->count() }}">
                                                {{ number_format($average, 2) }}
                                            </th>
                                        @endforeach --}}
                                        @foreach ($applicantAverages as $index => $applicantData)
                                            {{-- <td class="border border-[#eee] py-4 px-2 dark:border-strokedark">
                                                {{ number_format($applicantData['average'], 2) }}</td> --}}
                                            <th class="border border-[#eee] py-4 px-2 dark:border-strokedark text-center font-semibold text-black dark:text-white"
                                                colspan="{{ $uniqueEvaluators->count() }}">
                                                {{ number_format($applicantData['average'], 2) }}
                                            </th>
                                        @endforeach
                                    </tr>
                                </tfoot>
                            </table>

                            <table class="w-full table-auto">
                                <h1 class="font-semibold text-2xl text-center py-4 underline">
                                    Rankings of Applicants based on their obtained marks
                                </h1>
                                <thead>
                                    <tr class="bg-gray-2 text-center dark:bg-meta-4">
                                        <th
                                            class="font-semibold text-black dark:text-white xl:pl-11 border border-[#eee] py-4 px-2 dark:border-strokedark">
                                            Rank
                                        </th>
                                        <th
                                            class="font-semibold text-black dark:text-white xl:pl-11 border border-[#eee] py-4 px-2 dark:border-strokedark">
                                            Applicant
                                        </th>
                                        <th
                                            class="font-semibold text-black dark:text-white xl:pl-11 border border-[#eee] py-4 px-2 dark:border-strokedark">
                                            Average Marks
                                        </th>
                                        <th
                                            class="font-semibold text-black dark:text-white xl:pl-11 border border-[#eee] py-4 px-2 dark:border-strokedark">
                                            Recommended
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $previousAverage = null; // Variable to store the previous applicant's average
                                    @endphp
                                    @foreach ($rankedApplicants as $index => $applicantData)
                                        <tr class="text-center">
                                            <td
                                                class="border border-[#eee] py-4 px-2 dark:border-strokedark font-semibold text-black dark:text-white xl:pl-11">
                                                {{ $index + 1 }}</td>
                                            <td class="border border-[#eee] py-4 px-2 dark:border-strokedark">
                                                {{ $applicantData['name'] }}</td>
                                            <td class="border border-[#eee] py-4 px-2 dark:border-strokedark">
                                                {{ number_format($applicantData['average'], 2) }}
                                            </td>
                                            <td class="border border-[#eee] py-4 px-2 dark:border-strokedark">
                                                @if ($index + 1 == 1 || $applicantData['average'] == $previousAverage)
                                                    <i class="bi bi-award-fill text-brandBlue"></i>
                                                @endif
                                            </td>
                                        </tr>
                                        @php
                                            $previousAverage = $applicantData['average'];
                                        @endphp
                                    @endforeach
                                </tbody>
                            </table>
                        @else
                            <p class="text-lg text-brandOrange font-semibold print:hidden">Evaluation Criteria not set, so
                                all details included in summary !!!</p>
                        @endif

                        <div class="py-2">
                            @isset($uniqueApplicants)
                                @foreach ($uniqueApplicants as $key => $applicantName)
                                    <div class="font-semibold text-lg underline pt-4">Summary of applicant
                                        {{ $applicantName }}:
                                    </div>
                                    <div class="grid grid-cols-2 gap-4">
                                        @foreach ($uniqueEvaluators as $evaluatorId => $evaluatorName)
                                            <div class="">
                                                <p class="font-semibold text-md py-1">{{ $loop->index + 1 }}.
                                                    {{ $evaluatorName }}:
                                                </p>
                                                {!! $summary->where('application_id', $key)->where('evaluator_id', $evaluatorId)->unique('summary')->first()->summary ?? '' !!}
                                            </div>
                                        @endforeach
                                    </div>
                                @endforeach
                            @else
                                <p class="text-danger">evaluation not done</p>
                            @endisset
                        </div>
                    </div>
                </div>
            </div>



        </div>
    </main>

    <script>
        function printDiv(divId) {
            var divContents = document.getElementById(divId).innerHTML;
            var originalContents = document.body.innerHTML;

            document.body.innerHTML = "<html><head><title>Print</title></head><body>" + divContents + "</body>";
            window.print();
            document.body.innerHTML = originalContents;
        }
    </script>
@endsection