@extends('layouts.base', [
	"breadcrumb" => [  // see partials/breadcrumb.blade.php for default options
		"title" => "ETABLIR LE TABLEAU DE SPÉCIFICATION",
		// "showNav" => true,
		"nav" => [
			"Dashboard" => route("home"),
			"Tableau de spécification" => "",
			],
		"btnText" => "GestStudent v17.04",
	]
])

@section('title', "Tableau de spécification | GestStudent Admin")

@section('css')
    <link href="{{ asset('assets/extra-libs/datatables.net-bs4/css/dataTables.bootstrap4.css') }}" rel="stylesheet">
	<link href="{{ asset('assets/extra-libs/datatables.net-bs4/css/responsive.dataTables.min.css') }}" rel="stylesheet">
    <style>
        .form-select{ 
            background-image:url({{asset('assets/images/custom-select.png')}});
        }

        th, td {
            text-align: start;
            border-collapse: collapse;
            border: solid 1px;
            height: 2.1em;
            padding-left: 10px;
            padding-right: 10px;
        }

        tr:hover{
            background-color: aliceblue;
        }

        .odd{
            background-color: #8888FF;
        }

        .even{
            background-color: #CCCCFF;
        }

        .semestre{
            background-color: #d7e4db;
            color:#0000FF;
        }

        .semestre td{
            border: none;
        }

        .type_0{
            color: #000000;
        }

        .type_1{
            color: #ff0000;
        }

        .type_2{
            color: #0000ff;
        }

        .type_3{
            color: #008100;
        }
    </style>
@endsection

@section('content')
    <div class="row">
        <div class="col-sm-12">
            <div class="card">
                <div class="border-bottom mb-3 title-part-padding" style="display: block ruby;">
                <form target="_blank" method="POST" action="{{ route('unites.genSpecTablePDF', 2) }}" style="width: 50%;">
                        @csrf
                        <input id="filiere" name="idFiliere" style="display:none;" required="" value="{{$data['request']->idFiliere}}" readonly/>
                        <input id="annee_acad" name="annee_acad" style="display:none;" required="" value="{{$data['request']->annee_acad}}" readonly/>
                        <input id="niveauFormation" name="niveauFormation" style="display:none;" required="" value="{{$data['request']->niveauFormation}}" readonly/>
                        <input id="annee" name="annee" style="display:none;" required="" value="{{$data['request']->annee}}" readonly/>
                        <button class="btn btn-primary" type="submit">
                            <i class="fas fa-download"></i>
                            Générer le PDF + Liste enseignants
                        </button>
                    </form>
                    <form target="_blank" method="POST" action="{{ route('unites.genSpecTablePDF', 1) }}" style="width: 50%;text-align: end;">
                        @csrf
                        <input id="filiere" name="idFiliere" style="display:none;" required="" value="{{$data['request']->idFiliere}}" readonly/>
                        <input id="annee_acad" name="annee_acad" style="display:none;" required="" value="{{$data['request']->annee_acad}}" readonly/>
                        <input id="niveauFormation" name="niveauFormation" style="display:none;" required="" value="{{$data['request']->niveauFormation}}" readonly/>
                        <input id="annee" name="annee" style="display:none;" required="" value="{{$data['request']->annee}}" readonly/>
                        <button class="btn btn-primary" type="submit">
                            <i class="fas fa-download"></i>
                            Générer le pdf
                        </button>
                    </form>
                </div>
            </div>
            <div class="card">
                <div class="card-body">
                    <h2 style="font-weight: normal;">TABLEAU DE SPÉCIFICATION</h2>
                    <p class="text-danger">Filière : {{$data['filiere']->sigleFilieres}} & Année académique : {{$data['periode']}}</p>
                    <div class="table-responsive">
                        @foreach ($data['annees'] as $annee)
                            @php
                                $idSemestre[1] = ($annee * 2) - 1;
                                $idSemestre[2] = $annee * 2;
                                $sumCredit[$idSemestre[1]] = $data["unites"][$annee][$idSemestre[1]]->sum('credit');
                                $sumCredit[$idSemestre[2]] = $data["unites"][$annee][$idSemestre[2]]->sum('credit');
                                $cpt = 0;
                            @endphp
                            <table class="table-condensed table-hover"  border = "1" width="100%">
                                <thead>
                                    <tr style="background-color:#ffe6e6;color:#0000FF;">
                                        <td width="3%"  style="text-align:center">#</td>
                                        <td width="8%"  style="text-align:center">CRÉDIT UE</td>
                                        <td width="8%" style="text-align:center">CODE UE</td>
                                        <td width="35%" class="rotate" ><div>INTITULÉ UNITÉ D'ENSEIGNEMENT</div></td>
                                        <td width="8%"  style="text-align:center">CODE EC</td>
                                        <td width="30%" >INTITULÉ  ÉLÉMENT CONSTITUTIF (EC)</td>
                                        <td width="8%" style="text-align:center">POIDS EC</td>
                                    </tr>
                                </thead>
                                <tr class="semestre">
                                    <td width="3%" ></td>
                                    <td width="8%"  style="text-align:center" bgcolor = {{($sumCredit[$idSemestre[1]] < 30) ? '#ff0000' : '#00ffff'}}>{{$sumCredit[$idSemestre[1]]}}</td>
                                    <td width="8%" ></td>
                                    <td width="35%"></td>
                                    <td width="8%" style="text-align:center">SEMESTRE {{$idSemestre[1]}}</td>
                                    <td width="30%" ></td>
                                    <td width="8%" ></td>
                                </tr>
                                @foreach ($data["unites"][$annee][$idSemestre[1]] as $ue)
                                    @php
                                        $cpt++;
                                        $classCredit = ($cpt%2)? "odd" : "even";
                                        $isFirstEcu = true;
                                    @endphp
                                    <tr>   	 	
                                        <td width="3%"   style="text-align:center" rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}">{{$cpt}}</td>
                                        <td width="8%" style="text-align:center" class="{{$classCredit}}"  rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" >{{$ue->credit}}</td>
                                        <td width="8%"  style="text-align:center" rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" >{{$ue->code_unite}}</td>
                                        <td width="35%"  rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" class="type_{{$ue->type_ue}}">{{$ue->intituleUnite}}</td>
                                        @foreach ($data["ecues"][$annee][$ue->code_unite] as $ecu)
                                            @if ($isFirstEcu)
                                                <td width="8%"  style="text-align:center">{{$ecu->code_ecu}}</td>
                                                <td width="30%" >{{$ecu->intituleEcu}}</td>
                                                <td  width="8%"style="text-align:center">{{$ecu->credit}}</td>
                                                @php $isFirstEcu = false; @endphp
                                            @else
                                                <tr>
                                                    <td width="8%"  style="text-align:center">{{$ecu->code_ecu}}</td>
                                                    <td width="30%" >{{$ecu->intituleEcu}}</td>
                                                    <td  width="8%"style="text-align:center">{{$ecu->credit}}</td>
                                                </tr>
                                            @endif
                                        @endforeach
                                    </tr>
                                @endforeach
                                <tr class="semestre">
                                    <td width="3%" ></td>
                                    <td width="8%"  style="text-align:center" bgcolor = {{($sumCredit[$idSemestre[2]] < 30) ? '#ff0000' : '#00ffff'}}>{{$sumCredit[$idSemestre[2]]}}</td>
                                    <td width="8%" ></td>
                                    <td width="35%"></td>
                                    <td width="8%" style="text-align:center">SEMESTRE {{$idSemestre[2]}}</td>
                                    <td width="30%" ></td>
                                    <td width="8%" ></td>
                                </tr>
                                @foreach ($data["unites"][$annee][$idSemestre[2]] as $ue)
                                    @php
                                        $cpt++;
                                        $couleur = ($ue->type_ue==0)?'#000000':(($ue->type_ue==1)?'#ff0000':(($ue->type_ue==2)?'#0000ff':'#008100'));
                                        $classCredit = ($cpt%2)? "odd" : "even";
                                        $isFirstEcu = true;
                                    @endphp
                                    <tr>   	 	
                                        <td width="3%"   style="text-align:center" rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}">{{$cpt}}</td>
                                        <td width="8%" style="text-align:center" class="{{$classCredit}}"  rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" >{{$ue->credit}}</td>
                                        <td width="8%"  style="text-align:center" rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" >{{$ue->code_unite}}</td>
                                        <td width="35%"  rowspan="{{$data["ecues"][$annee][$ue->code_unite]->count()}}" class="type_{{$ue->type_ue}}">{{$ue->intituleUnite}}</td>
                                        @foreach ($data["ecues"][$annee][$ue->code_unite] as $ecu)
                                            @if ($isFirstEcu)
                                                <td width="8%"  style="text-align:center">{{$ecu->code_ecu}}</td>
                                                <td width="30%" >{{$ecu->intituleEcu}}</td>
                                                <td  width="8%"style="text-align:center">{{$ecu->credit}}</td>
                                                @php $isFirstEcu = false; @endphp
                                            @else
                                                <tr>
                                                    <td width="8%"  style="text-align:center">{{$ecu->code_ecu}}</td>
                                                    <td width="30%" >{{$ecu->intituleEcu}}</td>
                                                    <td  width="8%"style="text-align:center">{{$ecu->credit}}</td>
                                                </tr>
                                            @endif
                                        @endforeach
                                    </tr>
                                @endforeach
                                <tr class="semestre">
                                    <td colspan = "6" style="text-align:center">
                                        TOTAL CRÉDITS SEMESTRES {{$idSemestre[1]}} & SEMESTRE {{$idSemestre[2]}}
                                    </td>
                                    <td style="text-align:center"  bgcolor = {{($sumCredit[$idSemestre[1]] + $sumCredit[$idSemestre[2]] < 60) ? '#ff0000' : '#00ffff'}}>{{$sumCredit[$idSemestre[1]] + $sumCredit[$idSemestre[2]]}}</td>
                                </tr>
                            </table>
                            <br/><br/>
                        @endforeach

                        <table class="table-condensed table-hover" style="margin:0;padding:5;padding-top:20px;" border="1">
                            <tbody>
                                <tr>
                                    <td colspan="2" width="47%" bgcolor="#d7e4db" style="text-align:center"> LEGENDE TABLEAU DE SPECIFICATION</td>
                                </tr>
                                <tr>
                                    <td width="7%" bgcolor="#000000"> </td>
                                    <td width="40%"> Unité de Connaissance Fondamentales </td>
                                </tr>
                                <tr>
                                    <td width="7%" bgcolor="#ff0000"> </td>
                                    <td width="40%"> Unité de Spécialité </td>
                                </tr>
                                <tr>
                                    <td width="7%" bgcolor="#0000ff"> </td>
                                    <td width="40%"> Unité de Méthodologie </td>
                                </tr>
                                <tr>
                                    <td width="7%" bgcolor="#008100"> </td>
                                    <td width="40%"> Unité de Culture Générale </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
            <div class="card">
                <div class="border-bottom mb-3 title-part-padding" style="text-align: end;">
                    <a href="#" target="_blank">
                        <button class="btn btn-primary">
                            <i class="fas fa-download"></i>
                            Générer le pdf
                        </button>
                    </a>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('script')
    <script src="{{ asset('assets/extra-libs/datatables.net/js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('assets/extra-libs/datatables.net-bs4/js/dataTables.responsive.min.js') }}"></script>
    <!-- start - This is for export functionality only -->
    <script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script>
@endsection