@extends('layout')
@section('css')
  <link rel="stylesheet" href="{{ asset('inscription/chart.min.css') }}">
@endsection
@section('content')
<style type="text/css">
    #myChart {
        height: 600px !important;
    }
</style>
<div class="content-wrapper">

    <div class="container">
        <div class="row justify-content-center">
        <img src="{{ asset('img/bandesv.jpg') }}" style="height: 400px; width: 100%;">
        </div>
                <div class="content-header">
        </div>
        @if (Auth::user()->role!='evaluateur')
<div class="row">
    <div class="col-lg-4 col-6">
      <!-- small box -->
      <div class="small-box bg-info">
        <div class="inner">
          <h3>{{ $nbCollectivite }}</h3>

          <p>Collectivités Territoriales</p>
        </div>
        <div class="icon">
          <i class="ion ion-bag"></i>
        </div>
         <a href="{{ route('homect') }}" class="small-box-footer">Plus d'infos<i class="fas fa-arrow-circle-right"></i></a>
      </div>
    </div>
    <!-- ./col -->
    <div class="col-lg-4 col-6">
      <!-- small box -->
      <div class="small-box bg-success">
        <div class="inner">
          <h3>{{  $nbJournaliste }}<sup style="font-size: 20px"></sup></h3>

          <p>Journalistes et Communicants</p>
        </div>
        <div class="icon">
          <i class="ion ion-stats-bars"></i>
        </div>
        <a href="{{ route('homejc') }}" class="small-box-footer">Plus d'infos <i class="fas fa-arrow-circle-right"></i></a>
      </div>
    </div>
    <!-- ./col -->
    <div class="col-lg-4 col-6">
      <!-- small box -->
      <div class="small-box bg-danger">
        <div class="inner">
          <h3>{{ $nbUniversitaire }} </h3>

          <p>Universitaires et Chercheurs</p>
        </div>
        <div class="icon">
          <i class="ion ion-person-add"></i>
        </div>
         <a href="{{ route('homeuc') }}" class="small-box-footer">Plus d'infos <i class="fas fa-arrow-circle-right"></i></a>
      </div>
    </div>
    <!-- ./col -->

  </div>

  <div class="row">
     {{--   <div class="col-lg-12">
    <div class="card border-danger border-0">
        <div class="card-header bg-info text-center">Nombre de Soumision par categorie</div>
            <div class="card-body">
    <canvas id="myChart" width="200" height="200" style="height: 400px !important;"></canvas>
            </div>
    </div>

  </div>  --}}
  <div class="col-lg-6">
    <div class="card border-danger border-0">
        <div class="card-header bg-info text-center">Nombre de Soumision  par catégorie CT</div>
            <div class="card-body">
    <canvas id="pie" width="200" height="200" style="height: 400px !important;"></canvas>
            </div>
    </div>
  </div>
  <div class="col-lg-6">
    <div class="card border-danger border-0">
        <div class="card-header bg-info text-center">Nombre de Soumision des Journalistes par categorie </div>
            <div class="card-body">
    <canvas id="piejc" width="200" height="200" style="height: 400px !important;"></canvas>
            </div>
    </div>
  </div>
</div>
@else
<div class="row">
    <div class="col-md-2 col-sm-2"></div>
    <div class="col-md-9 col-sm-9 col-12">
        <div class="badge badge-danger text-center">
            <h2>
                <span  id="days"></span>
                <span id="hours" ></span>
                <span id="minutes" ></span>
                <span id="seconds" ></span></h2>
        </div>
      </div>
</div>
<br>
@endif
<div class="row">
    <div class="col-12">
        <div class="card border-danger border-0">
            <div class="card-header bg-warning text-center" style="color: black !important;"><b>LISTE DES SOUMISSIONS DES COLLECTIVITES TERRITORIALES</b></div>
                <div class="card-body">
                    @if (session()->has('message'))
                    <div class="alert alert-danger">
                        {{ session()->get('message') }}
                    </div>

                    @endif
                    <table id="example1" class="table table-bordered table-responsive-md table-striped text-center">
                        <thead>
                            <tr>
                                <th>date</th>
                                <th>Catégorie</th>
                                <th>Collectivite - Territoriale</th>
                                <th>Titre de l'expérience</th>
                                @if (Auth::user()->role=='evaluateur')  <th>Evaluer</th> @endif
                                @if (Auth::user()->role=='evaluateur')  <th>Note</th> @endif
                                @if (Auth::user()->role!='evaluateur')   <th>Actions</th> @endif
                            </tr>
                        </thead>
                        <tbody>
                        @foreach ($collectivites as $user)
                        @if (Auth::user()->role=='evaluateur')
                        <tr>
                            <td> {{  Carbon\Carbon::parse($user->collectivite->created_at)->format('d-m-Y') }}</td>
                            <td> @if(!empty( $user->collectivite->categorie->nomc ))
                                {{  $user->collectivite->categorie->nomc  }}
                            @endif</td>
                            <td>{{ $user->collectivite->nom }}</td>
                            <td>
                                @foreach ($user->collectivite->descriptions as $description )
                                    {{ $description->titre }}
                                @endforeach
                            </td>
                            <td>
                                @if (sizeOf($user->notes) > 0)
                                @foreach ($user->notes as $note)
                                @if ($note->nobje==0 ||  $note->ndesc==0 || $note->npert==0 || $note->ncorh==0 ||  $note->ndura==0 || $note->nmeth==0 || $note->neffi==0 || $note->nefce==0 || $note->ncapt==0 || $note->nefpp==0 || $note->nefpa==0 || $note->nutfu==0 || $note->nviab==0 || $note->ndiff==0 || $note->nelem==0 || $note->ndefi==0 || $note->noppo==0 || $note->nrabp==0 || $note->nrame==0)
                                <a href=" {{ route('modifier.note', ['idct'=>$user->collectivite->id,'idnote'=>$note->id]) }} " role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>
                                @else
                                <a href=" {{ route('modifier.note', ['idct'=>$user->collectivite->id,'idnote'=>$note->id]) }} " role="button" class="btn btn-success"><i class="fas fa-edit"></i></a>
                                @endif
                                @endforeach
                                @else
                                <a href=" {{ route('detailCollectivite.Correcteur', ['id'=>$user->collectivite->id]) }} " role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>

                                @endif
                               </td>
                               <td>
                                @if (sizeOf($user->notes) > 0)
                                @foreach ($user->notes as $note)
                                @if ($note->nobje!=0 &&  $note->ndesc!=0 && $note->npert!=0 && $note->ncorh!=0 &&  $note->ndura!=0 && $note->nmeth!=0 && $note->neffi!=0 && $note->nefce!=0 && $note->ncapt!=0 && $note->nefpp!=0 && $note->nefpa!=0 && $note->nutfu!=0 && $note->nviab!=0 && $note->ndiff!=0 && $note->nelem!=0 && $note->ndefi!=0 && $note->noppo!=0 && $note->nrabp!=0 && $note->nrame!=0)
                            <strong> {{number_format(( $note->nobje +  $note->ndesc + $note->npert + $note->ncorh +  $note->ndura + $note->nmeth + $note->neffi + $note->nefce + $note->ncapt
                                    + $note->nefpp + $note->nefpa + $note->nutfu + $note->nviab + $note->ndiff + $note->nelem + $note->ndefi + $note->noppo + $note->nrabp + $note->nrame)/ 19,1)
                                                            }}</strong>
                                @endif
                                @endforeach
                                @endif
                            </td>

                        </tr>
                        @else
                        <tr>
                            <td> {{  Carbon\Carbon::parse($user->created_at)->format('d-m-Y') }}</td>
                            <td> @if(!empty( $user->categorie->nomc ))
                                {{  $user->categorie->nomc  }}
                            @endif</td>
                            <td>{{ $user->nom }}</td>
                            <td>
                                @foreach ($user->descriptions as $description )
                                    {{ $description->titre }}
                                @endforeach
                            <td>
                                <a href=" {{ route('detailCollectivite', ['id'=>$user->id]) }} " role="button" class="btn btn-success"><i class="fas fa-eye"></i></a>
                            </td>

                        </tr>

                        @endif

                            @endforeach

                        </tbody>
                    </table>



                </div>

            </div>
        </div>
        <div class="col-12">
            <div class="card border-danger border-0">
                <div class="card-header bg-warning text-center" style="color: black !important;"><b>LISTE DES SOUMISSIONS DES JOURNALISTES - COMMUNICANTS </b></div>
                    <div class="card-body">
                        <table id="example2" class="table table-bordered table-responsive-md table-striped text-center">
                            <thead>
                                <tr>
                                    <th>date</th>
                                    <th>Catégorie</th>
                                    <th>Titre</th>
                                    <th>Prenom - Nom de l'auteur</th>
                                    @if (Auth::user()->role=='evaluateur')  <th>Evaluer</th> @endif
                                    @if (Auth::user()->role=='evaluateur')  <th>Note</th> @endif
                                    @if (Auth::user()->role!='evaluateur') <th>Actions</th> @endif
                                </tr>
                            </thead>
                            <tbody>
                            @foreach ($journalistes as $journaliste)
                            @if (Auth::user()->role=='evaluateur')
                            <tr>
                                <td> {{  Carbon\Carbon::parse($journaliste->journaliste->created_at)->format('d-m-Y') }}</td>
                                <td>{{ $journaliste->journaliste->genre }}</td>
                                <td>
                                    {{ $journaliste->journaliste->titre }}
                                </td>
                                <td>{{ $journaliste->journaliste->nom }}</td>
                                <td>
                                @if (sizeOf($journaliste->notejs) > 0)
                                @foreach ($journaliste->notejs as $note)
                                @if ($note->nexpe==0 ||  $note->nappp==0 || $note->nonte==0 || $note->nipea==0 || $note->ndesc==0 || $note->ncontr==0 || $note->nqrsm==0 || $note->nprat==0 || $note->nlprod==0)
                                <a href="{{ route('modifier.notej', ['idj'=>$journaliste->journaliste_id,'idnote'=>$note->id]) }}" role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>
                                @else
                                <a href="{{ route('modifier.notej', ['idj'=>$journaliste->journaliste_id,'idnote'=>$note->id]) }}" role="button" class="btn btn-success"><i class="fas fa-edit"></i></a>
                                @endif
                                @endforeach
                                @else
                                <a href="{{ route('detailJournaliste', ['id'=>$journaliste->journaliste_id]) }}" role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>

                                @endif
                            </td>
                            <td>
                                @if (sizeOf($journaliste->notejs) > 0)
                                @foreach ($journaliste->notejs as $note)
                                @if ($note->nexpe!=0 &&  $note->nappp!=0 && $note->nonte!=0 && $note->nipea!=0 && $note->ndesc!=0 && $note->ncontr!=0 && $note->nqrsm!=0 && $note->nprat!=0 && $note->nlprod!=0)
                            <strong> {{number_format(( $note->nexpe +  $note->nappp + $note->nonte + $note->nipea + $note->ndesc + $note->ncontr + $note->nqrsm + $note->nprat + $note->nlprod)/ 9,1) }}</strong>
                                @endif
                                @endforeach
                                @endif
                            </td>
                            </tr>
                            @else
                            <tr>
                                <td> {{  Carbon\Carbon::parse($journaliste->created_at)->format('d-m-Y') }}</td>
                                <td>{{ $journaliste->genre }}</td>
                                <td>{{ $journaliste->nom }}</td>
                                <td>
                                    {{ $journaliste->email }}
                                <td>
                                    <a href=" {{ route('detailJournaliste', ['id'=>$journaliste->id]) }} " role="button" class="btn btn-success"><i class="fas fa-eye"></i></a>
                                </td>

                            </tr>
                            @endif

                                @endforeach

                            </tbody>
                        </table>



                    </div>

                </div>
            </div>
            <div class="col-12">
                <div class="card border-danger border-0">
                    <div class="card-header bg-warning text-center" style="color: black !important;"><b>LISTE DES SOUMISSIONS DES UNIVERSITAIRES - CHERCHEURS </b></div>
                        <div class="card-body">
                            <table id="example3" class="table table-bordered table-responsive-md table-striped text-center">
                                <thead>
                                    <tr>
                                        <th>date</th>
                                        <th>Nom</th>
                                        <th>Email</th>
                                        <th>Téléphone</th>
                                        @if (Auth::user()->role=='evaluateur')  <th>Evaluer</th> @endif
                                        @if (Auth::user()->role=='evaluateur')  <th>Note</th> @endif
                                        @if (Auth::user()->role!='evaluateur')   <th>Actions</th> @endif
                                    </tr>
                                </thead>
                                <tbody>
                                @foreach ($universitaires as $universitaire)
                                @if (Auth::user()->role=='evaluateur')
                                <tr>
                                    <td> {{  Carbon\Carbon::parse($universitaire->universitaire->created_at)->format('d-m-Y') }}</td>
                                    <td>{{ $universitaire->universitaire->nom }}</td>
                                    <td>
                                        {{ $universitaire->universitaire->email }}</td>

                                        <td>{{ $universitaire->universitaire->tel }}</td>
                                        <td>
                                            @if (sizeOf($universitaire->notecus) > 0)
                                            @foreach ($universitaire->notecus as $note)
                                            @if ($note->npert==0 || $note->ncohe==0 || $note->npbpr==0 || $note->ndscm==0)
                                            <a href="{{ route('modifier.notecu', ['idcu'=>$universitaire->universitaire_id,'idnote'=>$note->id]) }}" role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>
                                            @else
                                            <a href="{{ route('modifier.notecu', ['idcu'=>$universitaire->universitaire_id,'idnote'=>$note->id]) }}" role="button" class="btn btn-success"><i class="fas fa-edit"></i></a>
                                            @endif

                                            @endforeach
                                            @else
                                            <a href="{{ route('detailUniversitaire', ['id'=>$universitaire->universitaire_id]) }}" role="button" class="btn btn-danger"><i class="fas fa-edit"></i></a>
                                            @endif
                                        </td>
                                        <td>
                                            @if (sizeOf($universitaire->notecus) > 0)
                                            @foreach ($universitaire->notecus as $note)
                                            @if ($note->npert!=0 && $note->ncohe!=0 && $note->npbpr!=0 && $note->ndscm!=0)
                                         <strong>{{number_format(( $note->npert +  $note->ncohe + $note->npbpr + $note->ndscm  )/ 4,1) }}</strong>
                                         @endif
                                            @endforeach
                                            @endif
                                        </td>
                                </tr>
                                @else
                                <tr>
                                    <td> {{  Carbon\Carbon::parse($universitaire->created_at)->format('d-m-Y') }}</td>
                                    <td>{{ $universitaire->nom }}</td>
                                    <td>
                                        {{ $universitaire->email }}</td>

                                        <td>{{ $universitaire->tel }}</td>
                                       <td> <a href=" {{ route('detailUniversitaire', ['id'=>$universitaire->id]) }} " role="button" class="btn btn-success"><i class="fas fa-eye"></i></a>
                                    </td>

                                </tr>
                                @endif
                                    @endforeach

                                </tbody>
                            </table>



                        </div>

                    </div>
                </div>
</div>
    </div>
</div>
@endsection
@section('script')

<script src="{{ asset('assets/dist/js/main.js') }}"></script>
<script>


        var ctx1 = document.getElementById('pie').getContext('2d');
        //var ctx = document.getElementById('myChart').getContext('2d');
        var ctxjc = document.getElementById('piejc').getContext('2d');
        var label = [];
        var donnee = [];
        var color = [];
        var labeljc = [];
        var donneejc = [];
        var colorjc = [];

    var dynamicColors = function() {
        var r = Math.floor(Math.random() * 255);
        var g = Math.floor(Math.random() * 255);
        var b = Math.floor(Math.random() * 255);
        var e = 1;

        return "rgba(" + r + "," + g + "," + b + ","+e + ")";
    };
     @foreach ($nbCollectiviteByCategorie as $CollectiviteByCategorie)
     label.push('{{$CollectiviteByCategorie->nomc}}');
     donnee.push('{{$CollectiviteByCategorie->nb}}');
     color.push(dynamicColors());
     @endforeach

{{--  var myChart = new Chart(ctx, {
    type: 'bar',
    data: {
        labels: label,
        datasets: [{
            label: 'Soumission ECOPOP',
            data: donnee,
            backgroundColor: color,
            borderColor: color,
            borderWidth: 1
        }]
    },
    options: {
        scales: {
            y: {
                beginAtZero: true
            }
        }
    }
});  --}}

var myChart = new Chart(ctx1, {
    type: 'pie',
    data: {
        labels: label,
        datasets: [{
            label: 'Soumission Collectivité territoriale',
            data: donnee,
            backgroundColor: color,
            borderColor: color,
            borderWidth: 1
        }]
    },
    options: {
        scales: {
            y: {
                beginAtZero: true
            }
        }
    }
});
@foreach ($nbJournalisteByCategorie as $journalisteByCategorie)
labeljc.push('{{$journalisteByCategorie->genre}}');
donneejc.push('{{$journalisteByCategorie->nb}}');
colorjc.push(dynamicColors());
@endforeach
var myChart = new Chart(ctxjc, {
    type: 'pie',
    data: {
        labels: labeljc,
        datasets: [{
            label: 'Soumission Journaliste et Communicant',
            data: donneejc,
            backgroundColor: colorjc,
            borderColor: colorjc,
            borderWidth: 1
        }]
    },
    options: {
        scales: {
            y: {
                beginAtZero: true
            }
        }
    }
});
var ctx = document.getElementById('myChart').getContext('2d');



</script>

@endsection