@extends('layout.template')
@section('intitule')
    <h5 class="font-weight-medium text-uppercase mb-0">ETABLIR LE BILAN D'INSERTION DES NOTES PAR EC</h5>
@endsection

@section('breadcrumb')
    <li class="breadcrumb-item active" aria-current="page">Bilan insertion</li>
@endsection

@section('styles')
@endsection

@section('main')
    <div class="row justify-content-center mt-4" style="min-height: calc(85vh - 60px)">
        <div class="col-lg-12">
            <div class="bg-white p-3 mb-4" style="text-align: right">
                <a href="{{ route('operation.pdf.bilan') }}" target="_blank" style="">
                    <button type="button" class="btn btn-primary">
                        <i class="ti-download" style="font-weight: 900"></i>
                        Générer le PDF
                    </button>
                </a>
            </div>
            <div class="bg-white p-3">
                <h3 class="box-title m-b-0">BILAN INSERTION : {{ $data['session'] == 0 ? 'NORMALE' : 'RATTRAPAGE' }}</h3>
                <p class="text-danger">Filière : {{ $data['sigle'] }} &amp; Année académique :
                    {{ Session::get('RESULTAT_DATA')['RESULTAT_YEAR']->periode }}</p>
                <table class="table-responsive">
                    @foreach ($data['annees'] as $annee)
                        <table class="table table-bordered table-hover" style="border-color:grey" cellpadding="4">
                            <thead>
                                <tr style="background-color:#ffe6e6;color:#0000FF;">
                                    <td width="3%" align="center">#</td>
                                    <td width="8%" align="center">CREDIT UE</td>
                                    <td width="8%" align="center">CODE UE</td>
                                    <td width="35%" class="rotate">
                                        <div>INTITULE UNITE D'ENSEIGNEMENT</div>
                                    </td>
                                    <td width="8%" align="center">CODE EC</td>
                                    <td width="30%">INTITULE ELEMENT CONSTITUTIF (EC)</td>
                                    <td width="8%" align="center">POIDS EC</td>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    if ($annee->annee == 1) {
                                        $ids[0] = 1;
                                        $ids[1] = 2;
                                    } elseif ($annee->annee == 2) {
                                        $ids[0] = 3;
                                        $ids[1] = 4;
                                    } elseif ($annee->annee == 3) {
                                        $ids[0] = 5;
                                        $ids[1] = 6;
                                    }
                                    $sumCredit = App\Models\ElementC::where(['idFiliere' => $data['idFiliere'], 'annee' => $data['etudeYear'], 'niveauFormation' => $data['formation'], 'annee_acad' => $data['acadYear']])->sum('credit');
                                    $j = 0;
                                @endphp
                                @for ($k = 0; $k < 2; $k++)
                                    @php
                                        $sumCreditSem = App\Models\UnitesE::where(['idFIliere' => $data['idFiliere'], 'annee' => $data['etudeYear'], 'niveauFormation' => $data['formation'], 'annee_acad' => $data['acadYear'], 'semestre' => $ids[$k]])->sum('credit');
                                        if ($sumCreditSem < 30) {
                                            $color = '#ff0000';
                                        } else {
                                            $color = '#00ffff';
                                        }
                                    @endphp
                                    <tr style="background-color:#d7e4db;color:#0000FF;">
                                        <td width="3%"></td>
                                        <td width="8%" align="center" style="background-color:{{ $color }}">
                                            {{ $sumCreditSem }}
                                        </td>
                                        <td width="8%"></td>
                                        <td width="35%"></td>
                                        <td width="8%" align="center">SEMESTRE {{ $ids[$k] }}</td>
                                        <td width="30%"></td>
                                        <td width="8%"></td>
                                    </tr>
                                    @php

                                        $inser = $data['session'] == 0 ? 'YES' : 'NO';

                                        $unites = App\Models\UnitesE::where(['idFiliere' => $data['idFiliere'], 'annee' => $data['etudeYear'], 'niveauFormation' => $data['formation'], 'annee_acad' => $data['acadYear'], 'semestre' => $ids[$k]])->get();
                                    @endphp
                                    @foreach ($unites as $unite)
                                        @php
                                            $c = App\Http\Helpers\AdditionalHelpers::couleurAlterner();
                                            if ($unite->type_ue == 0) {
                                                $couleur = '#000000';
                                            } elseif ($unite->type_ue == 1) {
                                                $couleur = '#ff0000';
                                            } elseif ($unite->type_ue == 2) {
                                                $couleur = '#0000ff';
                                            } elseif ($unite->type_ue == 3) {
                                                $couleur = '#008100';
                                            }
                                            $ecus = $data['session'] == 0 ? App\Models\ElementC::where(['idFiliere' => $data['idFiliere'], 'annee' => $data['etudeYear'], 'annee_acad' => $data['acadYear'], 'code_unite' => $unite->code_unite, 'insertion' => $inser])->get() : App\Models\ElementC::where(['idFiliere' => $data['idFiliere'], 'annee' => $data['etudeYear'], 'annee_acad' => $data['acadYear'], 'code_unite' => $unite->code_unite, 'rattrapage' => $inser])->get();
                                            $total = $ecus->count();
                                        @endphp
                                        @if ($total > 0)
                                            @php
                                                $j++;
                                            @endphp
                                            <tr>
                                                <td width="3%" align="center" rowspan="{{ $total }}">
                                                    {{ $j }}</td>
                                                <td width="8%" align="center"
                                                    style="background-color:{{ $c }}"
                                                    rowspan="{{ $total }}">{{ $unite->credit }}
                                                </td>
                                                <td width="8%" align="center" rowspan="{{ $total }}">
                                                    {{ $unite->code_unite }}
                                                </td>
                                                <td width="35%" rowspan="{{ $total }}">
                                                    <font color="{{ $couleur }}">{{ $unite->intituleUnite }}</font>
                                                </td>
                                                <td width="8%" align="center">{{ $ecus[0]->code_ecu }}</td>
                                                <td width="30%">{{ $ecus[0]->intituleEcu }}</td>
                                                <td width="8%"align="center">{{ $ecus[0]->credit }}</td>
                                            </tr>
                                            @for ($i = 1; $i < $ecus->count(); $i++)
                                                <tr>
                                                    <td width="8%" align="center">{{ $ecus[$i]->code_ecu }}</td>
                                                    <td width="30%">{{ $ecus[$i]->intituleEcu }}</td>
                                                    <td width="8%" align="center">{{ $ecus[$i]->credit }}</td>
                                                </tr>
                                            @endfor
                                        @endif
                                    @endforeach
                                @endfor
                                @php
                                    if ($sumCredit < 60) {
                                        $color = '#ff0000';
                                    } else {
                                        $color = '#00ffff';
                                    }
                                @endphp
                                <tr style="background-color:#d7e4db;color:#0000FF;">
                                    <td colspan="6" align="center">
                                        TOTAL CREDIT SEMESTRE {{ $ids[0] }} & SEMESTRE {{ $ids[1] }}
                                    </td>
                                    <td align="center" style="background-color:{{ $color }}">{{ $sumCredit }}
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                        <br>
                    @endforeach

                    <table class="w-50 table table-bordered table-hover"
                        style="margin:0;padding:5;padding-top:20px;border-color:grey" cellpadding="4">
                        <tbody>
                            <tr>
                                <td style="background-color: #d7e4db" colspan="2" align="center"> LEGENDE TABLEAU DE
                                    SPECIFICATION</td>
                            </tr>
                            <tr>
                                <td style="background-color: #000000" width="7%">
                                    <div></div>
                                </td>

                                <td width="40%"> Unité de Connaissance Fondamentales </td>
                            </tr>

                            <tr>
                                <td style="background-color: #ff0000" width="7%"> </td>

                                <td width="40%"> Unité de Spécialité </td>
                            </tr>

                            <tr>
                                <td style="background-color: #0000ff" width="7%"> </td>

                                <td width="40%"> Unité de Méthodologie </td>
                            </tr>

                            <tr>
                                <td style="background-color: #008100" width="7%"> </td>

                                <td width="40%"> Unité de Culture Générale </td>
                            </tr>
                        </tbody>
                    </table>
                </table>

                <div class="bg-white p-3 my-4 border" style="text-align: right">
                    <a href="{{ route('operation.pdf.bilan') }}" target="_blank" style="">
                        <button type="button" class="btn btn-primary">
                            <i class="ti-download" style="font-weight: 900"></i>
                            Générer le PDF
                        </button>
                    </a>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
@endsection