{# @var ea \EasyCorp\Bundle\EasyAdminBundle\Context\AdminContext #}
{% extends '@EasyAdmin/layout.html.twig' %}

{% block content_title  %}{% endblock %}
{% block head_javascript %}
	{{ parent() }}

	<script src="https://cdn.jsdelivr.net/npm/chart.js"></script> 
	
{% endblock head_javascript %}

{% block body_javascript %}
		
	 <script src="{{ asset('assets/js/stats/index.js')}}"></script> 

{% endblock body_javascript %}

{% block head_stylesheets %}
	{{ parent() }}
    {# {{ knp_pagination_rel_links(totaldevices) }} #}

{% endblock %}


{% block main %}
				
    
<div>
	<ul class="nav nav-tabs" id="myTab" role="tablist">
		<li class="nav-item" role="presentation">
			<button class="nav-link active" data-bs-toggle="tab" data-bs-target="#map-pane" type="button" role="tab" aria-selected="true">Salon</button>
		</li>
		<li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#totem-pane" type="button" role="tab" aria-selected="false">Consultation par totem</button>
		</li>
        <li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#rubriques-pane" type="button" role="tab" aria-selected="false">Consultation par rubriques</button>
		</li>
        <li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#jours-pane" type="button" role="tab" aria-selected="false">Consultation par jours</button>
		</li>
         <li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#heures-pane" type="button" role="tab" aria-selected="false">Consultation par heures</button>
		</li>
        <li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#exposants-pane" type="button" role="tab" aria-selected="false">Consultation par exposants</button>
		</li>
        <li class="nav-item" role="presentation">
			<button class="nav-link" data-bs-toggle="tab" data-bs-target="#conferences-pane" type="button" role="tab" aria-selected="false">Consultation par conferences</button>
		</li>
	</ul>

	<div class="tab-content" id="myTabContent">
		
        {#  Salon - map #}
        <div class="tab-pane fade show active" id="map-pane" role="tabpanel" tabindex="0">

            <div class="row mt-4 mb-3">
                <label for="map-file" class="form-label h5 mb-2">Choississez le plan du salon</label>
                 <input id="map-file" class="form-control"  type="file" accept="image/*" onchange="loadFile(event)"> 
            </div>

            <div class="row mb-3 border border-secondary d-flex align-content-center">
                <div class="row col-3 mb-5 mt-5">
                    <div><b>Organisateur : </b>{{ salon.name  }}</div>
                    <div><b>Début du salon : </b>{{ salon.startedAt |date("d/m/Y")  }}</div>
                    <div><b>Fin du salon : </b>{{ salon.endedAt |date("d/m/Y")  }}</div>
                    <div><b>Lieu: </b>{{ salon.pacExpo  }}</div>
                    <div><b>Chart : </b>{{ salon.chart  }}</div>
                    <div><b>Env: </b>{{ salon.env  }}</div>
                    <div><b>Mode : </b>{{ salon.mode  }}</div>
                    <div><b>Opérateur : </b>{{ salon.operateurapi }}</div>
                    <div><b>Nombre de devices présents dans les stats : </b>{{ totaldevices }}</div>
                </div>

                <div class="d-flex col-9 justify-content-center">
                    <img class="" id="map-img" src="images/planOK.svg" style="max-height : 60vh;">
                </div>				

            </div>
        </div>

        {#  Consultation par totem #}
        <div class="tab-pane fade" id="totem-pane" role="tabpanel" tabindex="0">
            
            {# <div class="h3 mt-5">Consultation par totem</div> #}
            
            <div class="row mt-4 d-flex">
                <table id="table-totem" class="table table-striped table-hover">
                    <thead>
                        <tr>
                            <th scope="col">Nom du device</th>
                            <th scope="col">Nombre de hits</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                    
                        {% for device in deviceslist %}

                            <tr>
                                <td>{{ device[0].deviceid }}</td>
                                <td>{{ device.total }}</td>
                            </tr>

                        {% endfor %}
                        <tr class="fw-bold h6">
                            <td>Total de hits</td>
                            <td>{{ totalhits }}</td>
                        </tr> 
                    </tbody>

                </table>

                {# pagination #}
                <div class="d-flex justify-content-between h6">
                    <div class="mt-1">{{ deviceslist | length }} devices trouvés</div>
                    <div>
                         <select class="form-select h7" id="itemperpage-totem">
                            <option>10</option> 
                            <option>20</option>
                            <option>50</option> 
                            <option>100</option> 
                        </select>
                    </div>
                    <div>
                        <nav>
                            <ul id="pagination-totem" class="pagination">
                            </ul>
                        </nav>
                    </div>
                </div>

                {# <div class="navigation">
                    {{ knp_pagination_render(deviceslist) }}
                </div> #}
            </div>
        
        </div>

         {#  Consultation par rubrique #}
        <div class="tab-pane fade" id="rubriques-pane" role="tabpanel" tabindex="0">

            {# <div class="h3 mt-5">Consultation par rubriques</div>     #}
            <div class="row mt-2 border d-flex">
                    <table class="table table-striped table-hover">
                        <thead>
                            <tr>
                                <th scope="col">Statistique par rubriques</th>
                                <th scope="col">Nombre de hits</th>
                                <th scope="col">Map-stand</th>
                                <th scope="col">View-map</th>
                                <th scope="col">View-stand</th>
                                <th scope="col">Link conf</th>
                                <th scope="col">Link encours</th>
                                <th scope="col">Link expo</th>
                                <th scope="col">Link map</th>
                                <th scope="col">open popup</th>
                                <th scope="col">Link innov</th>
                                <th scope="col">Link speakers</th>
                                <th scope="col">Link partners</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            
                             {% set totalhitscol1 = 0 %}

                                <tr>
                                    {% set totalhitscol1 = 0 %}
                                    {% set totalhitscol2 = 0 %}
                                    {% set totalhitscol3 = 0 %}
                                    {% set totalhitscol4 = 0 %}
                                    {% set totalhitscol5 = 0 %}
                                    {% set totalhitscol6 = 0 %}
                                    {% set totalhitscol7 = 0 %}
                                    {% set totalhitscol8 = 0 %}
                                    {% set totalhitscol9 = 0 %}
                                    {% set totalhitscol10 = 0 %}
                                    {% set totalhitscol11 = 0 %}
                                    {% set totalhitscol12 = 0 %}

                                    <td>Conférences</td>
                                    {% if devicesByOrigin.conferences is not null %} 
                                         {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.conferences.total %}
                                        <td>{{ devicesByOrigin.conferences.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                     <td>0</td>
                                     {% if devicesByActions.conferencesclicviewmap is not null %} 
                                         {% set totalhitscol3 = totalhitscol3 + devicesByActions.conferencesclicviewmap.total %}
                                        <td>{{ devicesByActions.conferencesclicviewmap.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      <td>0</td>
                                    {% if devicesByActions.linktoconferences.conferences is not null %} 
                                     {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.conferences.total %}
                                        <td>{{ devicesByActions.linktoconferences.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktoencours.conferences is not null %} 
                                      {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.conferences.total %}
                                        <td>{{ devicesByActions.linktoencours.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      {% if devicesByActions.linktoexhibitors.conferences is not null %} 
                                        {% set totalhitscol7 = totalhitscol7 + devicesByActions.linktoexhibitors.conferences.total %} 
                                        <td>{{ devicesByActions.linktoexhibitors.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                       {% if devicesByActions.linktomaps.conferences is not null %} 
                                         {% set totalhitscol8 = totalhitscol8 + devicesByActions.linktomaps.conferences.total %} 
                                        <td>{{ devicesByActions.linktomaps.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.openpopupconferences is not null %} 
                                        {% set totalhitscol9 = totalhitscol9 + devicesByActions.openpopupconferences.total %}
                                        <td>{{ devicesByActions.openpopupconferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                       {% if devicesByActions.linktoinnovation.conferences is not null %} 
                                        <td>{{ devicesByActions.linktoinnovation.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktospeakers.conferences is not null %} 
                                         {% set totalhitscol11 = totalhitscol11 + devicesByActions.linktospeakers.conferences.total %} 
                                        <td>{{ devicesByActions.linktospeakers.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktopartners.conferences is not null %} 
                                         {% set totalhitscol12 = totalhitscol12 + devicesByActions.linktopartners.conferences.total %} 
                                        <td>{{ devicesByActions.linktopartners.conferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      

                                </tr>

                                <tr>
                                    <td>En cours</td>
                                     {% if devicesByOrigin.encours is not null %} 
                                     {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.encours.total %}
                                        <td>{{ devicesByOrigin.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                     <td>0</td>
                                     <td>0</td>
                                      <td>0</td>
                                    {% if devicesByActions.linktoconferences.encours is not null %} 
                                      {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.encours.total %}
                                        <td>{{ devicesByActions.linktoconferences.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktoencours.encours is not null %} 
                                     {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.encours.total %}
                                        <td>{{ devicesByActions.linktoencours.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      {% if devicesByActions.linktoexhibitors.encours is not null %}
                                        {% set totalhitscol7 = totalhitscol7 + devicesByActions.linktoexhibitors.encours.total %} 
                                        <td>{{ devicesByActions.linktoexhibitors.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                       {% if devicesByActions.linktomaps.encours is not null %} 
                                         {% set totalhitscol8 = totalhitscol8 + devicesByActions.linktomaps.encours.total %} 
                                        <td>{{ devicesByActions.linktomaps.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                        <td>0</td>
                                       {% if devicesByActions.linktoinnovation.encours is not null %} 
                                        <td>{{ devicesByActions.linktoinnovation.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktospeakers.encours is not null %} 
                                         {% set totalhitscol11 = totalhitscol11 + devicesByActions.linktospeakers.encours.total %} 
                                        <td>{{ devicesByActions.linktospeakers.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktopartners.encours is not null %} 
                                         {% set totalhitscol12 = totalhitscol12 + devicesByActions.linktopartners.encours.total %} 
                                        <td>{{ devicesByActions.linktopartners.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}

                                </tr>

                                <tr>
                                    <td>Exposants</td>
                                     {% if devicesByOrigin.exhibitors is not null %} 
                                       {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.exhibitors.total %}
                                        <td>{{ devicesByOrigin.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                     <td>0</td>
                                     <td>0</td>
                                      {% if devicesByActions.exhibitorsclicviewexhibitormap is not null %} 
                                       {% set totalhitscol4 = totalhitscol4 +  devicesByActions.exhibitorsclicviewexhibitormap.total %}
                                        <td>{{ devicesByActions.exhibitorsclicviewexhibitormap.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                    {% if devicesByActions.linktoconferences.exhibitors is not null %} 
                                        {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.exhibitors.total %}
                                        <td>{{ devicesByActions.linktoconferences.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktoencours.exhibitors is not null %} 
                                     {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.exhibitors.total %}
                                        <td>{{ devicesByActions.linktoencours.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      {% if devicesByActions.linktoexhibitors.exhibitors is not null %} 
                                        {% set totalhitscol7 = totalhitscol7 + devicesByActions.linktoexhibitors.exhibitors.total %} 
                                        <td>{{ devicesByActions.linktoexhibitors.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                       {% if devicesByActions.linktomaps.exhibitors is not null %} 
                                        {% set totalhitscol8 = totalhitscol8 + devicesByActions.linktomaps.exhibitors.total %} 
                                        <td>{{ devicesByActions.linktomaps.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                        <td>0</td>
                                       {% if devicesByActions.linktoinnovation.exhibitors is not null %} 
                                        {% set totalhitscol10 = totalhitscol10 + devicesByActions.linktoinnovation.exhibitors.total %}
                                        <td>{{ devicesByActions.linktoinnovation.exhibitors.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     <td>0</td>
                                     <td>0</td>

                                </tr>

                                <tr>
                                    <td>Speakers</td>
                                    {% if devicesByOrigin.speakers is not null %} 
                                       {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.speakers.total %}
                                        <td>{{ devicesByOrigin.speakers.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    <td>0</td>
                                    <td>0</td>
                                    <td>0</td>
                                    {% if devicesByActions.linktoconferences.speakers is not null %} 
                                        {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.speakers.total %}
                                        <td>{{ devicesByActions.linktoconferences.speakers.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                      {% if devicesByActions.linktoencours.speakers is not null %} 
                                        {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.speakers.total %}
                                        <td>{{ devicesByActions.linktoencours.speakers.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                    <td>0</td>
                                    <td>0</td>
                                    {% if devicesByActions.openpopupspeakers is not null %} 
                                        {% set totalhitscol9 = totalhitscol9 + devicesByActions.openpopupspeakers.total %}
                                        <td>{{ devicesByActions.openpopupspeakers.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    <td>0</td>
                                    {% if devicesByActions.linktospeakers.speakers is not null %} 
                                         {% set totalhitscol11 = totalhitscol11 + devicesByActions.linktospeakers.speakers.total %} 
                                        <td>{{ devicesByActions.linktospeakers.speakers.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktopartners.speakers is not null %} 
                                         {% set totalhitscol12 = totalhitscol12 + devicesByActions.linktopartners.speakers.total %} 
                                        <td>{{ devicesByActions.linktopartners.speakers.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}

                                </tr>

                                <tr>
                                    <td>Partenaires</td>
                                    {% if devicesByOrigin.partners is not null %} 
                                       {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.partners.total %}
                                        <td>{{ devicesByOrigin.partners.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    <td>0</td>
                                    <td>0</td>
                                    <td>0</td>
                                    {% if devicesByActions.linktoconferences.partners is not null %} 
                                        {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.partners.total %}
                                        <td>{{ devicesByActions.linktoconferences.partners.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    {% if devicesByActions.linktoencours.partners is not null %} 
                                        {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.partners.total %}
                                        <td>{{ devicesByActions.linktoencours.partners.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    

                                    <td>0</td>
                                    <td>0</td>
                                     {% if devicesByActions.openpopuppartners is not null %} 
                                        {% set totalhitscol9 = totalhitscol9 + devicesByActions.openpopuppartners.total %}
                                        <td>{{ devicesByActions.openpopuppartners.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                    <td>0</td>
                                     {% if devicesByActions.linktospeakers.partners is not null %} 
                                         {% set totalhitscol11 = totalhitscol11 + devicesByActions.linktospeakers.partners.total %} 
                                        <td>{{ devicesByActions.linktospeakers.partners.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     <td>0</td>
                                </tr>

                                <tr>
                                    <td>Maps</td>
                                     {% if devicesByOrigin.map is not null %} 
                                        {% set totalhitscol1 = totalhitscol1 + devicesByOrigin.map.total %}
                                        <td>{{ devicesByOrigin.map.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                   
                                        {% if devicesByActions.mapsclicstand is not null %} 
                                              {% set totalhitscol2 = totalhitscol2 + devicesByActions.mapsclicstand.total %}
                                            <td>{{ devicesByActions.mapsclicstand.total }}</td>
                                        {% else %} 
                                            <td>0</td>
                                        {% endif %}     
                                   
                                     <td>0</td>
                                       <td>0</td>

                                    {% if devicesByActions.linktoconferences.maps is not null %} 
                                        {% set totalhitscol5 = totalhitscol5 + devicesByActions.linktoconferences.maps.total %}
                                        <td>{{ devicesByActions.linktoconferences.maps.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     {% if devicesByActions.linktoencours.maps is not null %} 
                                     {% set totalhitscol6 = totalhitscol6 + devicesByActions.linktoencours.maps.total %}
                                        <td>{{ devicesByActions.linktoencours.maps.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                      {% if devicesByActions.linktoexhibitors.maps is not null %} 
                                        {% set totalhitscol7 = totalhitscol7 + devicesByActions.linktoexhibitors.maps.total %} 
                                        <td>{{ devicesByActions.linktoexhibitors.maps.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                       {% if devicesByActions.linktomaps.maps is not null %} 
                                        {% set totalhitscol8 = totalhitscol8 + devicesByActions.linktomaps.maps.total %} 
                                        <td>{{ devicesByActions.linktomaps.maps.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                        <td>0</td>
                                           
                                       {% if devicesByActions.linktoinnovation.maps is not null %} 
                                        {% set totalhitscol10 = totalhitscol10 + devicesByActions.linktoinnovation.maps.total %}
                                        <td>{{ devicesByActions.linktoinnovation.maps.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                     <td>0</td>
                                     <td>0</td>
                                  

                                </tr>
                                    <td>Conférences search</td>
                                    {% if devicesByActions.conferencessearch is not null %} 
                                    {% set totalhitscol1 = totalhitscol1 + devicesByActions.conferencessearch.total %}
                                      <td>{{ devicesByActions.conferencessearch.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                     <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                </tr>
                                <tr>
                                    <td>Exposants search</td>
                                      {% if devicesByActions.exhibitorssearch is not null %} 
                                       {% set totalhitscol1 = totalhitscol1 + devicesByActions.exhibitorssearch.total %}
                                        <td>{{ devicesByActions.exhibitorssearch.total }}</td>
                                      {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                </tr>

                                 <tr>
                                    <td>Speakers search</td>
                                      {% if devicesByActions.speakerssearch is not null %} 
                                       {% set totalhitscol1 = totalhitscol1 + devicesByActions.speakerssearch.total %}
                                        <td>{{ devicesByActions.speakerssearch.total }}</td>
                                      {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                </tr>

                                <tr>
                                </tr>
                                {# <tr>
                                    <td>En cours</td>
                                    {% if devicesByOrigin.encours is not null %} 
                                        <td>{{ devicesByOrigin.encours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                </tr>
                                </tr>
                                <tr>
                                    <td>Exposant</td>
                                    {% if devicesByOrigin.exhibitors is not null %} 
                                        <td>{{ devicesByOrigin.exhibitors.total }}</td>
                                    {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                </tr>
                                <tr>
                                    <td>Plan</td>
                                    {% if devicesByOrigin.map is not null %} 
                                        <td>{{ devicesByOrigin.map.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                </tr>
                                <tr>
                                    <td>Plan clik exposants</td>
                                    {% if devicesByActions.mapsclicstand is not null %} 
                                        <td>{{ devicesByActions.mapsclicstand.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %} 
                                </tr>
                                <tr>
                                    <td>Conférences search</td>
                                    {% if devicesByActions.conferencessearch is not null %} 
                                      <td>{{ devicesByActions.conferencessearch.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                    {% endif %}
                                </tr>
                                <tr>
                                    <td>Exposants search</td>
                                      {% if devicesByActions.exhibitorssearch is not null %} 
                                        <td>{{ devicesByActions.exhibitorssearch.total }}</td>
                                      {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                </tr>
                                <tr>
                                    <td>Conférences to plan</td>
                                     {% if devicesByActions.conferencesclicviewmap is not null %} 
                                        <td>{{ devicesByActions.conferencesclicviewmap.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                </tr> #}
                                <tr>
                                    <td>click-filter</td>
                                     {% if devicesByActions.clickfilter is not null %} 
                                          {% set totalhitscol1 = totalhitscol1 + devicesByActions.clickfilter.total %}
                                        <td>{{ devicesByActions.clickfilter.total }}</td>
                                       {% else %} 
                                        <td>0</td>
                                     {% endif %}

                                     <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>

                                </tr>
                                {# <tr>
                                    <td>exhibitors-clic-view-exhibitor-map</td>
                                     {% if devicesByActions.exhibitorsclicviewexhibitormap is not null %} 
                                        <td>{{ devicesByActions.exhibitorsclicviewexhibitormap.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                </tr>
                                <tr>
                                    <td>link-to-conferences</td>
                                      {% if devicesByActions.linktoconferences is not null %} 
                                        <td>{{ devicesByActions.linktoconferences.total }}</td>
                                      {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                </tr>
                                <tr>
                                    <td>link-to-encours</td>
                                     {% if devicesByActions.linktoencours is not null %} 
                                        <td>{{ devicesByActions.linktoencours.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                     {% endif %}
                                </tr>
                                <tr>
                                    <td>link-to-exhibitors</td>
                                      {% if devicesByActions.linktoexhibitors is not null %} 
                                        <td>{{ devicesByActions.linktoexhibitors.total }}</td>
                                       {% else %} 
                                        <td>0</td>
                                      {% endif %}

                                </tr>
                                <tr>
                                    <td>link-to-maps</td>
                                     {% if devicesByActions.linktomaps is not null %} 
                                        <td>{{ devicesByActions.linktomaps.total }}</td>
                                      {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                </tr>
                                <tr>
                                    <td>open-popup-conferences</td>
                                     {% if devicesByActions.openpopupconferences is not null %} 
                                        <td>{{ devicesByActions.openpopupconferences.total }}</td>
                                     {% else %} 
                                        <td>0</td>
                                      {% endif %}
                                </tr> #}

                            <tr class="fw-bold h6">
                                <td>Total de hits</td>
                                <td>{{totalhitscol1}}</td>
                                <td>{{totalhitscol2}}</td>
                                <td>{{totalhitscol3}}</td>
                                <td>{{totalhitscol4}}</td>
                                <td>{{totalhitscol5}}</td>
                                <td>{{totalhitscol6}}</td>
                                <td>{{totalhitscol7}}</td>
                                <td>{{totalhitscol8}}</td>
                                <td>{{totalhitscol9}}</td>
                                <td>{{totalhitscol10}}</td>
                                <td>{{totalhitscol11}}</td>
                                <td>{{totalhitscol12}}</td>
                            </tr> 
                        </tbody>

                    </table>
            </div>
            
        </div>


         {#  Consultation par jours #}
        <div class="tab-pane fade" id="jours-pane" role="tabpanel" tabindex="0">
            {# <div class="h3 mt-5">Consultation par jours</div>     #}

            <div class="row mt-5 border d-flex">
                <table class="table table-striped table-hover">
                    <thead>
                        <tr>
                            <th scope="col">Journée</th>
                            <th scope="col">Nombre de hits</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                        {% for devicesByDay in devicesByDays %}
                            <tr>
                                <td>{{ devicesByDay.date }}</td>
                                <td>{{ devicesByDay.total }}</td>
                            </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>

        {#  Consultation par heures #}
        <div class="tab-pane fade" id="heures-pane" role="tabpanel" tabindex="0">
            {# <div class="h3 mt-2">Consultation par heures</div>  #}
            <select class="form-select w-25 mt-5" aria-label="Default select example" id="dates">
                    <option selected disabled>Choisir une date</option>
                        {% for devicesByDay in devicesByDays %}	
                            <option value="{{ loop.index0 }}">{{ devicesByDay.date }}</option>
                        {% endfor %}
            </select>
            <div>
                <div id="charts" data-charts="{{ devicesByHours }}"></div>
                <canvas id="myChart" style="max-height : 65vh;"> </canvas>
            </div> 
        </div>

         {#  Consultation par exposants #}
        <div class="tab-pane fade" id="exposants-pane" role="tabpanel" tabindex="0">
            {# <div class="h3 mt-5">Consultation par exposants</div> #}
    
            <div class="row mt-5 border d-flex">
                    <table id="table-exposant" class="table table-striped table-hover">
                        <thead>
                            <tr>
                                <th scope="col">Nom de l'exposants</th>
                                <th scope="col">Nombre de hits</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            {% for exposant in exposantslist %}

                                <tr>
                                    <td>{{ exposant.name }}</td>
                                    <td>{{ exposant.total }}</td>
                                </tr>

                            {% endfor %}
                            <tr class="fw-bold h6">
                                <td>Total de hits</td>
                                <td>{{ totalhitsexposants }}</td>
                            </tr> 
                        </tbody>

                    </table>


                {# pagination #}
                <div class="d-flex justify-content-between h6">
                    <div class="mt-1">{{ exposantslist | length }} exposants trouvés</div>
                    <div>
                         <select class="form-select h7" id="itemperpage-exposant">
                            <option>10</option> 
                            <option>20</option>
                            <option>50</option> 
                            <option>100</option> 
                        </select>
                    </div>
                    <div>
                        <nav>
                            <ul id="pagination-exposant" class="pagination">
                            </ul>
                        </nav>
                    </div>
                </div> 

                    {# <div class="navigation">
                        {{ knp_pagination_render(exposantslist) }}
                    </div> #}
            </div>
        </div>

          {#  Consultation par conferences #}
        <div class="tab-pane fade" id="conferences-pane" role="tabpanel" tabindex="0">
            {# <div class="h3 mt-5">Consultation par conferences</div> #}
            <div class="row mt-5 border d-flex">
                    <table id="table-conference" class="table table-striped table-hover">
                        <thead>
                            <tr>
                                <th scope="col">Nom de la conférence</th>
                                <th scope="col">Nombre de hits</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            {% for conference in conferenceslist %}

                                <tr>
                                    <td>{{ conference.name }}</td>
                                    <td>{{ conference.total }}</td>
                                </tr>

                            {% endfor %}
                            <tr class="fw-bold h6">
                                <td>Total de hits</td>
                                <td>{{ totalhitsconferences }}</td>
                            </tr> 
                        </tbody>

                    </table>

                    {# pagination #}
                    <div class="d-flex justify-content-between h6">
                        <div class="mt-1">{{ conferenceslist | length }} conferences trouvés</div>
                        <div>
                            <select class="form-select h7" id="itemperpage-conference">
                                <option>10</option> 
                                <option>20</option>
                                <option>50</option> 
                                <option>100</option> 
                            </select>
                        </div>
                        <div>
                            <nav>
                                <ul id="pagination-conference" class="pagination">
                                </ul>
                            </nav>
                        </div>
                    </div> 
                    {# <div class="navigation">
                        {{ knp_pagination_render(conferenceslist) }}
                    </div> #}
            </div>
        </div>
    
    </div>



    

   

    

     
</div>
{% endblock %}