@extends('layouts.app')

@section('title')
Statistiques générales
@endsection

@section('page-title')
Statistiques générales
@endsection

@section('content')

<ul class="nav nav-tabs mB-20" id="myTab" role="tablist">
    <li class="nav-item">
        <a class="nav-link active" id="comptes-tab" data-toggle="tab" href="#comptes" role="tab" aria-controls="comptes" aria-selected="true">Comptes</a>
    </li>
    <li class="nav-item">
        <a class="nav-link" id="graph-tab" data-toggle="tab" href="#graph" role="tab" aria-controls="graph" aria-selected="false">Graphiques</a>
    </li>
    <li class="nav-item">
        <a class="nav-link" id="tags-tab" data-toggle="tab" href="#tags" role="tab" aria-controls="tags" aria-selected="false">Tags</a>
    </li>
</ul>

<div class="tab-content" id="myTabContent">
    <div class="tab-pane fade show active" id="comptes" role="tabpanel" aria-labelledby="comptes-tab">
        <div class="row">
            <div class="col-md-7">
                <div class="masonry-item mB-20">
                    <div class="bgc-white p-20 bd">
                        <h5 class="mB-15">Général</h5>
                        @if (!empty($nb_consultation))
                            <b>Chargements de toutes les consultations : </b> {{ $nb_consultation }}<br />
                        @endif
                        @if (!empty($nb_consultation))
                            <b>Chargements de toutes les propositions :</b> {{ $nb_proposition }}<br />
                        @endif
                        @if (!empty($nb_vote))
                            <b>Clics sur un bouton vote :</b> {{ $nb_vote }}<br />
                        @endif
                        @if (!empty($nb_vote_remove))
                            <b>Votes annulés :</b> {{ $nb_vote_remove }} <br />
                        @endif
                        @if (!empty($votes))
                            <b>Votes effectifs :</b> {{ count($votes) }} <br />
                        @endif
                    </div>
                </div>
            </div>

            <div class="col-md-12">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <table class="dataTable table table-striped">
                        <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Compte</th>
                                <th scope="col">Consultations</th>
                                <th scope="col">Propositions</th>
                                <th scope="col">Propositions envoyées</th>
                                <th scope="col">Votes</th>
                                <th scope="col">Participants</th>
                                <th scope="col">Invités</th>
                                <th scope="col">Chargements des consultations</th>
                                <th scope="col">Moyenne des chargements par consultation</th>
                            </tr>
                        </thead>

                        <tbody>
                            @if (count($comptes))
                                @foreach ($comptes as $compte)
                                    <tr>
                                        <td> {{ $compte->id }}</td>
                                        <td> {{ $compte->name }}</td>
                                        <td> {{ count($compte->consultations) }}</td>
                                        <td> {{ count($compte->propositions) }}</td>
                                        <td> {{ count($compte->sentPropositionsAll()->withTrashed()->get()) }}</td>
                                        <td> {{ count($compte->votes) }}</td>
                                        <td> {{ count($compte->participants) }}</td>
                                        <td> {{ count($compte->guests) }}</td>
                                        <td> {{ count($compte->logs()->whereAction('load consultation')->get()) }}</td>
                                        <td>
                                            @if (count($compte->consultations) > 0)
                                                {{ round(count($compte->logs()->whereAction('load consultation')->get()) / count($compte->consultations), 0) }}
                                            @else
                                                0
                                            @endif</td>
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td class="ta-c font-italic" colspan="10">
                                        Aucun compte enregistré<br />
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>


    <div class="tab-pane fade" id="graph" role="tabpanel" aria-labelledby="graph-tab">
        <div class="row mT-50">
            <div class="col-md-6">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <h4 class="c-grey-900 mB-30">Evolution du nombre de consultations</h4>
                    
                    <canvas id="consultation-evolution" height="100"></canvas>
                </div>
            </div>

            <div class="col-md-6">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <h4 class="c-grey-900 mB-30">Evolution du nombre de propositions</h4>
                    
                    <canvas id="proposition-evolution" height="100"></canvas>
                </div>
            </div>
        </div>

        <div class="row mT-50">
            <div class="col-md-8">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <h4 class="c-grey-900 mB-30">Evolution du nombre de votes</h4>
                    
                    <canvas id="vote-evolution" height="100"></canvas>
                </div>
            </div>

            <div class="col-md-4">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <h4 class="c-grey-900 mB-30">Répartition des consultations</h4>
                    
                    <canvas id="consultation-repartition" height="200"></canvas>
                </div>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tags" role="tabpanel" aria-labelledby="tags-tab">
        <div class="row">
            <div class="col-md-12">
                <div class="bgc-white bd bdrs-3 p-20 mB-20">
                    <table class="dataTable table table-striped">
                        <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Tag</th>
                                <th scope="col">Comptes</th>
                                <th scope="col">Consultations</th>
                                <th scope="col">Propositions</th>
                                <th scope="col">Nombre de votes / Nombre de propositions</th>
                                <th scope="col">Votes via les comptes</th>
                                <th scope="col">Votes via les consultations</th>
                                <th scope="col">Chargements des consultations</th>
                            </tr>
                        </thead>

                        <tbody>
                            @if (count($tags))
                                @foreach ($tags as $tag)
                                    <tr>
                                        <td> {{ $tag->id }}</td>
                                        <td><a href="{{ route('tags.show', $tag) }}"> {{ $tag->name }}</a></td>
                                        <td> {{ count($tag->comptes) }}</td>
                                        <td> {{ count($tag->consultations) }}</td>
                                        <td> {{ $count_tags[$tag->id]['propositions'] }}</td>
                                        <td>
                                            @if ($count_tags[$tag->id]['propositions'] > 0)
                                                {{ round($count_tags[$tag->id]['votes_consultations'] / $count_tags[$tag->id]['propositions'], 2) }}
                                            @else
                                                0
                                            @endif
                                        </td>
                                        <td> {{ $count_tags[$tag->id]['votes_comptes'] }}</td>
                                        <td> {{ $count_tags[$tag->id]['votes_consultations'] }}</td>
                                        <td> {{ $count_tags[$tag->id]['charg_consultations'] }}</td>
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td class="ta-c font-italic" colspan="10">
                                        Aucun tag enregistré<br />
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection


@section('js')
    <script type="text/javascript">

        $(document).ready( function () {
            var ctx = document.getElementById('consultation-evolution').getContext('2d');
            var chart = new Chart(ctx, {
                // The type of chart we want to create
                type: 'line',

                // The data for our dataset
                data: {
                    labels: [
                        @foreach ($total_consultations_by_date as $key => $consultation)
                            '{{ Carbon\Carbon::createFromFormat('Y-m-d', $key)->format('d/m/Y') }}',
                        @endforeach
                    ],
                    datasets: [{
                        label: 'Total des consultations ',
                        backgroundColor: 'rgba(235, 61, 0, 0.2)',
                        borderColor: '#EB3D00',
                        data: [
                            @foreach ($total_consultations_by_date as $key => $consultation)
                                '{{ $consultation }}',
                            @endforeach
                        ]
                    }]
                },

                // Configuration options go here
                options: {
                    legend: {
                        display: false
                    }
                }
            });

            var ctx = document.getElementById('proposition-evolution').getContext('2d');
            var chart = new Chart(ctx, {
                // The type of chart we want to create
                type: 'line',

                // The data for our dataset
                data: {
                    labels: [
                        @foreach ($total_propositions_by_date as $key => $proposition)
                            '{{ Carbon\Carbon::createFromFormat('Y-m-d', $key)->format('d/m/Y') }}',
                        @endforeach
                    ],
                    datasets: [{
                        label: 'Total des propositions ',
                        backgroundColor: 'rgba(235, 61, 0, 0.2)',
                        borderColor: '#EB3D00',
                        data: [
                            @foreach ($total_propositions_by_date as $key => $proposition)
                                '{{ $proposition }}',
                            @endforeach
                        ]
                    }]
                },

                // Configuration options go here
                options: {
                    legend: {
                        display: false
                    }
                }
            });

            var ctx = document.getElementById('vote-evolution').getContext('2d');
            var chart = new Chart(ctx, {
                // The type of chart we want to create
                type: 'line',

                // The data for our dataset
                data: {
                    labels: [
                        @foreach ($total_votes_by_date as $key => $vote)
                            '{{ Carbon\Carbon::createFromFormat('Y-m-d', $key)->format('d/m/Y') }}',
                        @endforeach
                    ],
                    datasets: [{
                        label: 'Total des votes ',
                        backgroundColor: 'rgba(235, 61, 0, 0.2)',
                        borderColor: '#EB3D00',
                        data: [
                            @foreach ($total_votes_by_date as $key => $vote)
                                '{{ $vote }}',
                            @endforeach
                        ]
                    }]
                },

                // Configuration options go here
                options: {
                    legend: {
                        display: false
                    }
                }
            });

            var ctx = document.getElementById('consultation-repartition').getContext('2d');
            var chart = new Chart(ctx, {
                // The type of chart we want to create
                type: 'doughnut',

                // The data for our dataset
                data: {
                    labels: [
                        @foreach ($consultations_by_type as $key => $number)
                            '{{ Config::get('constants.CONSULT_TYPE_STRING')[$key] }} ',
                        @endforeach
                    ],
                    datasets: [{
                            label: 'Répartition des consultations ',
                            /*backgroundColor: 'rgba(235, 61, 0, 0.2)',
                            borderColor: '#EB3D00',*/
                            data: [
                                @foreach ($consultations_by_type as $key => $number)
                                    {{ $number }},
                                @endforeach
                            ],
                            backgroundColor:["rgb(255, 99, 132)","rgb(54, 162, 235)","rgb(255, 205, 86)"]
                        }]
                },

                // Configuration options go here
                options: {
                    legend: {
                        display: true
                    }
                }
            });
        });
    </script>
@endsection