@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="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0 text-info">Tableau de bord</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                    <li class="breadcrumb-item"><a href="{{ route('home') }}" role="button" class="btn btn-primary">ACCUEIL</a></li>

                    </ol>
                </div><!-- /.col -->
                </div><!-- /.row -->
                <div class="row">
                    @foreach ($nbCollectiviteByCategorie as $CollectiviteByCategorie)
                    <div class="col-lg-4 col-6">
                        <!-- small box -->
                        <div class="small-box bg-info">
                          <div class="inner">
                            <p> {{ $CollectiviteByCategorie->nomc }}</p>

                            <p>{{ $CollectiviteByCategorie->nb }}</p>
                          </div>
                          <div class="icon">
                            <i class="ion ion-bag"></i>
                          </div>
                          {{-- <a href="#" class="small-box-footer">Projets en cours <i class="fas fa-arrow-circle-right"></i></a> --}}
                        </div>
                      </div>
                    @endforeach

                  </div>
            </div><!-- /.container-fluid -->
        </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 categorie</div>
            <div class="card-body">
    <canvas id="pie" width="200" height="200" style="height: 400px !important;"></canvas>
            </div>
    </div>
  </div>
</div>
<div class="row">
    <div class="col-12">
        <div class="card border-danger border-0">
            <div class="card-header bg-info text-center">Liste des soumissions des collectivités territoriales</div>
                <div class="card-body">
                    <table id="example1" class="table table-bordered table-responsive-md table-striped text-center">
                        <thead>
                            <tr>
                                <th>date</th>
                                <th>Categorie</th>
                                <th>Collectivite territoriale </th>
                                <th>Titre de l'experience</th>
                                <th>Evaluateurs et Notes</th>
                                <th>Moyenne</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                        @foreach ($collectivites as $collectivite)
                            <tr>
                                <td> {{  Carbon\Carbon::parse($collectivite->created_at)->format('d-m-Y') }}</td>
                                <td>@if(!empty( $collectivite->categorie->nomc))
                                    {{ $collectivite->categorie->nomc }} @endif</td>
                                <td>{{ $collectivite->nom }}</td>
                                <td>
                                    @foreach ($collectivite->descriptions as $description )
                                        {{ $description->titre }}
                                    @endforeach
                                </td>
                                <td>
                                    @foreach ($collectivite->affecters as $affecter )
                                       <p> {{ $affecter->user->name }}

                                        @if (sizeOf($affecter->notes) > 0)
                                @foreach ($affecter->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)
                                {{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)
                                                            }}
                                 @endif
                                @endforeach
                                @endif
                                       </p>
                                    @endforeach
                                </td>
                                <td>
                                @foreach($listeMoyenne as $key => $moyenne)

                                    @if ($key==$collectivite->id)
                                        {{ $moyenne }}
                                    @endif
                                @endforeach
                            </td>
                                <td>
                                    <a href=" {{ route('detailCollectivite', ['id'=>$collectivite->id]) }} " role="button" class="btn btn-success"><i class="fas fa-eye"></i></a>
                                    <button type="button" class="btn btn-default" data-toggle="modal" data-target="#modal-default{{ $collectivite->id }}">
                                        Affecter Correcteur
                                      </button>
                                      {!! Form::open(['method' => 'DELETE', 'route'=>['collectivite.destroy', $collectivite->id], 'style'=> 'display:inline', 'onclick'=>"if(!confirm('Êtes-vous sûr de vouloir supprimer cet enregistrement ?')) { return false; }"]) !!}
                                <button class="btn btn-danger"><i class="far fa-trash-alt"></i></button>
                                {!! Form::close() !!}
                                </td>

                            </tr>
                            <div class="modal fade" id="modal-default{{ $collectivite->id }}">
                                <div class="modal-dialog">
                                  <div class="modal-content">
                                    <div class="modal-header">
                                      <h4 class="modal-title">Affecter Evaluateur</h4>
                                      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                        <span aria-hidden="true">&times;</span>
                                      </button>
                                    </div>
                                    <form id="msform" action="{{ route('affecter.store') }}" method="POST" enctype="multipart/form-data">
                                        @csrf
                                    <div class="modal-body">

                                            <label class="fieldlabels">Nom Evaluateur</label>
                                        <select class="form-control" id="user_id" name="user_id" required>
                                            <option value="">Selectionnez</option>
                                            @foreach ($users as $user)
                                            <option value="{{$user->id}}"  {{ old('user_id') == $user->id? 'selected' : '' }}>{{$user->name}}</option>
                                                @endforeach

                                        </select>

                                        <input type="hidden" value="{{ $collectivite->id }}" name="collectivite_id">
                                    </div>
                                    <div class="modal-footer justify-content-between">
                                      <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                                      <button type="submit" class="btn btn-primary">Affecter</button>
                                    </div>
                                </form>
                                  </div>
                                  <!-- /.modal-content -->
                                </div>
                                <!-- /.modal-dialog -->
                              </div>
                              <!-- /.modal -->
                            @endforeach

                        </tbody>
                    </table>

                {{-- Tableu des notes  --}}

                <table id="example2" class="table table-bordered table-responsive-md table-striped text-center">
                    <thead>
                        <tr>
                            <th>Evaluateur</th>
                            <th>Collectivite</th>
                            <th>Categorie</th>
                             <th>Objectif</th>
                            <th>Description</th>
                            <th>Pertinance</th>
                            <th>Coherence</th>
                            <th>Durabilité</th>
                            <th>Methodologie</th>
                            <th>Effcacité</th>
                            <th>Efficience</th>
                            <th>Capitalisation</th>
                            <th>Effet PPL</th>
                            <th>Effet APAL</th>
                            <th>Utilisation Future</th>
                            <th>viabilté</th>
                            <th>Diffusion</th>
                            <th>Element Saillant</th>
                            <th>Defis</th>
                            <th>Opportunités</th>
                            <th>Raison BP</th>
                            <th>Raison SM</th>
                            <th>Moyenne</th>
                        </tr>
                    </thead>
                    <tbody>
                    @foreach ($affecters as $affecter)
                        <tr>
                            <td>{{ $affecter->user->name }}</td>
                            <td>{{ $affecter->collectivite->nom }}</td>
                            <td>@if(!empty( $affecter->collectivite->categorie->nomc)){{ $affecter->collectivite->categorie->nomc }} @endif</td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ndesc}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nobje}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->npert}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ncorh}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ndura}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nmeth}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->neffi}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nefce}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ncapt}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nefpp}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nefpa}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nutfu}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nviab}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ndiff}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nelem}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->ndefi}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->noppo}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nrabp}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>
                                @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->notes as $note)
                           {{ $note->nrame}}
                            @endforeach
                            @else
                            0
                            @endif
                            </td>
                            <td>

                                    @if (sizeOf($affecter->notes) > 0)
                            @foreach ($affecter->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)
                            {{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)
                                                        }}
                             @endif
                            @endforeach
                            @endif
                            </td>
                        </tr>
                        <div class="modal fade" id="modal-default{{ $collectivite->id }}">
                            <div class="modal-dialog">
                              <div class="modal-content">
                                <div class="modal-header">
                                  <h4 class="modal-title">Affecter Evaluateur</h4>
                                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                  </button>
                                </div>
                                <form id="msform" action="{{ route('affecter.store') }}" method="POST" enctype="multipart/form-data">
                                    @csrf
                                <div class="modal-body">

                                        <label class="fieldlabels">Nom Evaluateur</label>
                                    <select class="form-control" id="user_id" name="user_id" required>
                                        <option value="">Selectionnez</option>
                                        @foreach ($users as $user)
                                        <option value="{{$user->id}}"  {{ old('user_id') == $user->id? 'selected' : '' }}>{{$user->name}}</option>
                                            @endforeach

                                    </select>

                                    <input type="hidden" value="{{ $collectivite->id }}" name="collectivite_id">
                                </div>
                                <div class="modal-footer justify-content-between">
                                  <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                                  <button type="submit" class="btn btn-primary">Affecter</button>
                                </div>
                            </form>
                              </div>
                              <!-- /.modal-content -->
                            </div>
                            <!-- /.modal-dialog -->
                          </div>
                          <!-- /.modal -->
                        @endforeach

                    </tbody>
                </table>


                </div>

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


<script>


        var ctx1 = document.getElementById('pie').getContext('2d');
        var ctx = document.getElementById('myChart').getContext('2d');
        var label = [];
        var donnee = [];
        var color = [];

    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 ECOPOP',
            data: donnee,
            backgroundColor: color,
            borderColor: color,
            borderWidth: 1
        }]
    },
    options: {
        scales: {
            y: {
                beginAtZero: true
            }
        }
    }
});
var ctx = document.getElementById('myChart').getContext('2d');



</script>
@endsection