{% extends 'base_emine.html.twig' %}

{% block title %}
	{{parent()}}-Tableau de bord-Obligations des opérateurs
{% endblock %}

{% block content %}
	<main style="padding-top: 180px; min-height: 100vh;" class="bg-charcoal-light">
		<div class="container py-4">
			<nav class="operators-breadcrumb mb-4">
				<ol>
					<li>
						<a href="/">
							<svg width="15" height="15" viewbox="0 0 24 24" fill="none" stroke="currentColor" strokewidth="2" strokelinecap="round" strokelinejoin="round">
								<path d="m3 9 9-7 9 7v11a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2z"/><polyline points="9 22 9 12 15 12 15 22"/>
							</svg>
							Accueil
						</a>
					</li>
					<li class="separator">
						<svg width="14" height="14" viewbox="0 0 24 24" fill="none" stroke="currentColor" strokewidth="2" strokelinecap="round" strokelinejoin="round">
							<polyline points="9 18 15 12 9 6"/>
						</svg>
					</li>
					{% if menu == 'ctcpm' %}
                        <li>
                            <a href="#">Accès CTCPM</a>
                        </li>
                        <li class="separator">
                            <svg width="14" height="14" viewbox="0 0 24 24" fill="none" stroke="currentColor" strokewidth="2" strokelinecap="round" strokelinejoin="round">
                                <polyline points="9 18 15 12 9 6"/>
                            </svg>
                        </li>
                        <li class="active">Dotation de 0,3% </li>
                    {% else %}
                        <li>
                            <a href="#">Accès autorités</a>
                        </li>
                        <li class="separator">
                            <svg width="14" height="14" viewbox="0 0 24 24" fill="none" stroke="currentColor" strokewidth="2" strokelinecap="round" strokelinejoin="round">
                                <polyline points="9 18 15 12 9 6"/>
                            </svg>
                        </li>
                        <li class="active">Obligations des opérateurs</li>
                    {% endif %}
				</ol>
			</nav>

			<div class="d-flex flex-column flex-md-row align-items-start align-items-md-center justify-content-between gap-3 mb-4">
                {% if menu == 'ctcpm' %}
                    <div>
                        <h1 class="fw-bold mb-1" style="font-family: var(--font-display); font-size: 1.6rem;">
                            📊 Dotation de 0,3%
                        </h1>
                        <p class="text-muted-mine mb-0" style="font-size: 0.9rem">
                            Statistiques sur la dotation de 0,3%
                        </p>
                    </div>
                {% else %}
                    <div>
                        <h1 class="fw-bold mb-1" style="font-family: var(--font-display); font-size: 1.6rem;">
                            📊 Obligations des opérateurs
                        </h1>
                        <p class="text-muted-mine mb-0" style="font-size: 0.9rem">
                            Statistiques sur les obligations des opérateurs
                        </p>
                    </div>
                {% endif %}

                <div class="d-flex gap-2 flex-wrap">
                    <button class="operators-btn operators-btn-outline btn-flitre-prod" data-bs-toggle="modal" data-bs-target="#staticBackdrop1">
                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-funnel" viewBox="0 0 16 16">
                            <path d="M1.5 1.5A.5.5 0 0 1 2 1h12a.5.5 0 0 1 .5.5v2a.5.5 0 0 1-.128.334L10 8.692V13.5a.5.5 0 0 1-.342.474l-3 1A.5.5 0 0 1 6 14.5V8.692L1.628 3.834A.5.5 0 0 1 1.5 3.5zm1 .5v1.308l4.372 4.858A.5.5 0 0 1 7 8.5v5.306l2-.666V8.5a.5.5 0 0 1 .128-.334L13.5 3.308V2z"/>
                        </svg>
                        Filtrer
                    </button>
				</div>
			</div>

			<div class="mb-4" style='background-color: var(--card-bg);border: 1px solid var(--border-color);border-radius: 1rem;transition: all 0.3s ease;'>
				<div class="d-flex flex-column flex-md-row gap-3 p-3">
					{% if menu == 'ctcpm' %}
                        {{ include('menu/ctcpm.html.twig') }}
                    {% else %}
                        {{ include('menu/autorite.html.twig') }}
                    {% endif %}
				</div>
			</div>

            <div class="mb-5"></div>
			<div class="row g-4">
				<div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Dotation de 0,3%</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Suivi de la dotation de 0,3% des entreprises
						</p>
						<div>
							<div id="market-chart-dotation"></div>
						</div>
					</div>
				</div>

                <div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Versement</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Versement de la dotation de 0,3% par Dot
						</p>
						<div>
							 <div id="market-chart-dotation12"></div>
						</div>
					</div>
				</div>
			
				<div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Coût</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Coût de projets par Dot
						</p>
						<div class="table-responsive">
							<div id="market-chart-dotation123"></div>
						</div>
					</div>
				</div>
			
				<div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Redevance, dotation & cahiers des charges</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Evolution comparative entre la redevance, la dotation de 0,3% et les cahiers des charges.
						</p>
						<div class="table-responsive">
							<div id="market-chart-dotation-evolution"></div>
						</div>
					</div>
				</div>

				<div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Projets par type d'infrastructures</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombres de projets réalisés sur la Dotation par type d'infrastructures
						</p>
						<div class="table-responsive">
							<div id="container11" style='background:#f6f7fa;'></div>
						</div>
					</div>
				</div>

                <div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Projets par stade</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre des projets sur la Dotation par stades des projets
						</p>
						<div class="table-responsive">
							<div id="container21" style='background:#f6f7fa;'></div>
						</div>
					</div>
				</div>

                <div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Projets par filière</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre de projets sur la dotation par filière
						</p>
						<div class="table-responsive">
							<div id="container21111" style='background:#f6f7fa;'></div>
						</div>
					</div>
				</div>

                <div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Projets par province</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre de projets sur la dotation par province
						</p>
						<div class="table-responsive">
							<div id="container21111111" style='background:#f6f7fa;'></div>
						</div>
					</div>
				</div>
			</div>
            <div class="mb-5"></div>
		</div>
	</main>

    <div style='position:relative;z-index:999999999999999999;'>
        <elevenlabs-convai agent-id="agent_0701kh8g5nenf9y9jcwbs8qfmvyw"></elevenlabs-convai><script src="https://unpkg.com/@elevenlabs/convai-widget-embed" async type="text/javascript"></script>
    </div>

    <div class="filter-modal-overlay modal-prod" style='display:none;'>
      <div class="filter-modal">
        <div class="filter-modal-header">
          <div>
            <h5 class="fw-bold mb-0" style="font-family:var(--font-display);color:var(--bs-body-color)">
              Filtrer les obligations
            </h5>
            <small style="color:var(--muted-color); font-size: 0.8rem">
              Affinez les résultats affichés
            </small>
          </div>
          <button class="filter-modal-close btn-flitre-prod">✕</button>
        </div>

		<form action="{{path('app_emine_cadre_juridique_arrete_reporting', {menu: menu})}}" method="POST">
			<div class="filter-modal-body">
                <div class="filter-group">
					<label class="filter-label" htmlFor="filter-year">
					<span class="filter-label-icon" style="background:$17418a18;color:17418a;">📅</span>
					Année
					</label>
					<select
					id="filter-year"
					name="anneeProdJour"
					class="form-select js-choice1">
						{% for item in 1999..'now'|date('Y') %}
							<option value="{{item}}">{{item}}</option>
						{% endfor %}
					</select>
				</div>
			</div>

				<div class="filter-modal-footer">
					<button class="filter-btn-reset">Réinitialiser</button>
					<button class="filter-btn-apply" type='submit' style="background: #17418a;">
						Appliquer les filtres
					</button>
				</div>
			</form>
		</div>
    </div>
{% endblock %}

{#
    {% block content %}
        <div class="content-wrapper" style="margin-top:180px;">
            <div class="container-full">
                <div class="content-header">
                    <div class="d-flex align-items-center">
                        <div class="me-auto">
                            <h3 class="page-title">Dashboard des arrêtés</h3>
                            <div class="d-inline-block align-items-center">
                                <nav>
                                    <ol class="breadcrumb">
                                        <ol class="breadcrumb">
                                        <li class="breadcrumb-item"><a href="{{path('app_home')}}"><i class="mdi mdi-home-outline"></i></a></li>
                                        <li class="breadcrumb-item" aria-current="page">Dashboard</li>
                                        <li class="breadcrumb-item active" aria-current="page">Arrêtés</li>
                                    </ol>
                                </nav>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-lg-12 col-12">
                        <div class="row ico-filter content" data-ref="ico-filter">
                            <div class="mix production all">
                                <div class="row">
                                    <div class="col-12 mix production all" style="margin-top:20px;margin-bottom:40px;">
                                        <div class="btn-group pull-right" role="group" aria-label="Basic outlined example">
                                            <a href="#" class="badge badge-pill badge-xl badge-primary px-15 btn-outline btn-primary-light text-white" style="background-color:#17418a;" data-bs-toggle="modal" data-bs-target="#staticBackdrop1">
                                                <i class="fa fa-filter"></i>
                                                Filtrer</a>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xl-6 col-12 mb-5">
                                <div class="box" id="statistique">
                                    <div>
                                        <div>
                                            <div class="box-header bg-primary-light">
                                                <h4 class="box-title">Statistiques des arrêtés signés en {{annee}}</h4>
                                            </div>
                                            <div class="box-body">
                                                <div id="market-chart-arrete"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xl-6 col-12 mb-5">
                                <div class="box" id="statistique">
                                    <div>
                                        <div>
                                            <div class="box-header bg-primary-light">
                                                <h4 class="box-title">Statistiques des arrêtés signés en {{annee}}</h4>
                                            </div>
                                            <div class="box-body">
                                                <div id="market-chart-arrete1"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xl-4 col-12" style="margin-top:30px;">
                                <div class="box">
                                    <div class="box-header with-border">
                                        <h6 class="box-title">Nombre d'arrêtés par opérateur</h6>
                                    </div>

                                <div class="box-body">
                                    {% set totalContrib = 0 %}
                                    {% set valeurs = "" %}
                                    {% set compter = 1 %}

                                    {% for item in arretesOperateurs %}
                                        {% set totalContrib = totalContrib +  item.nbre %}
                                        {% set valeurs      = valeurs~item.nbre %}	

                                        {% if compter !=  contrubs|length %}
                                            {% set valeurs      = valeurs~',' %}
                                        {% endif %}

                                        {% set compter = compter + 1 %}
                                    {% endfor %}

                                    <div class="text-center py-20">                 
                                        <div class="donut" data-peity='{ "fill": ["#17418a", "#edb717", "#b52825", "#8aecd0", "#666ee8", "#17418a"], "radius": 78, "innerRadius": 58  }' >{{valeurs}}</div>
                                    </div>

                                    <ul class="list-inline">
                                        {% set compter = 1 %}

                                        {% for item in arretesOperateurs %}
                                            <li class="flexbox mb-5">
                                                <div>
                                                    <a href="{{path('app_emine_cadre_juridique_arrete_operateur', {denomination: item.operateur})}}" class="text-dark">
                                                        <span class="badge badge-dot badge-lg me-1" {% if compter == 1 %}style="background-color: #17418a"{% elseif compter == 2 %}style="background-color: #edb717"{% elseif compter == 3 %}style="background-color: #b52825"{% elseif compter == 4 %}style="background-color: #8aecd0"{% elseif compter == 5 %}style="background-color: #666ee8"{% elseif compter == 6 %}style="background-color: #17418a"{% endif %}></span>
                                                        <span>{{item.operateur}}</span>
                                                    </a>
                                                </div>
                                                <div>
                                                    <a href="{{path('app_emine_cadre_juridique_arrete_operateur', {denomination: item.operateur})}}" class="text-dark">
                                                        {{item.nbre}} ({{ ((item.nbre / totalContrib) * 100)|round(1, 'floor') }}%)
                                                    </a>
                                                </div>
                                            </li>

                                            {% set compter = compter + 1 %}
                                        {% endfor %}
                                    </ul>
                                </div>
                                </div>
                            </div>


                            <div class="col-xl-4 col-12" style="margin-top:30px;">
                                <div class="box">
                                    <div class="box-header with-border">
                                        <h6 class="box-title">Nombre d'arrêtés par catégorie d'arrêtés</h6>
                                    </div>

                                <div class="box-body">
                                    {% set totalContrib = 0 %}
                                    {% set valeurs = "" %}
                                    {% set compter = 1 %}

                                    {% for item in arretesCategorie %}
                                        {% set totalContrib = totalContrib +  item.nbre %}
                                        {% set valeurs      = valeurs~item.nbre %}	

                                        {% if compter !=  contrubs|length %}
                                            {% set valeurs      = valeurs~',' %}
                                        {% endif %}

                                        {% set compter = compter + 1 %}
                                    {% endfor %}

                                    <div class="text-center py-20">                  
                                        <div class="donut" data-peity='{ "fill": ["#17418a", "#edb717", "#b52825", "#8aecd0", "#666ee8", "#17418a"], "radius": 78, "innerRadius": 58  }' >{{valeurs}}</div>
                                    </div>

                                    <ul class="list-inline">
                                        {% set compter = 1 %}

                                        {% for item in arretesCategorie %}
                                            <li class="flexbox mb-5">
                                                <div>
                                                    <a href="{{path('app_emine_cadre_juridique_arrete_categorie', {categorie: item.categorie})}}" class="text-dark">
                                                        <span class="badge badge-dot badge-lg me-1" {% if compter == 1 %}style="background-color: #17418a"{% elseif compter == 2 %}style="background-color: #edb717"{% elseif compter == 3 %}style="background-color: #b52825"{% elseif compter == 4 %}style="background-color: #8aecd0"{% elseif compter == 5 %}style="background-color: #666ee8"{% elseif compter == 6 %}style="background-color: #17418a"{% endif %}></span>
                                                        <span>{{item.categorie}}</span>
                                                    </a>
                                                </div>
                                                <div>
                                                    <a href="{{path('app_emine_cadre_juridique_arrete_categorie', {categorie: item.categorie})}}" class="text-dark">
                                                        {{item.nbre}} ({{ ((item.nbre / totalContrib) * 100)|round(1, 'floor') }}%)
                                                    </a>
                                                </div>
                                            </li>

                                            {% set compter = compter + 1 %}
                                        {% endfor %}
                                    </ul>
                                </div>
                                </div>
                            </div>


                            <div class="col-xl-4 col-12" style="margin-top:30px;">
                                <div class="box">
                                    <div class="box-header with-border">
                                        <h6 class="box-title">Nombre d'arrêtés par type d'arrêtés</h6>
                                    </div>

                                    <div class="box-body">
                                        {% set totalContrib = 0 %}
                                        {% set valeurs = "" %}
                                        {% set compter = 1 %}

                                        {% for item in arretesType %}
                                            {% set totalContrib = totalContrib +  item.nbre %}
                                            {% set valeurs      = valeurs~item.nbre %}	

                                            {% if compter !=  contrubs|length %}
                                                {% set valeurs      = valeurs~',' %}
                                            {% endif %}

                                            {% set compter = compter + 1 %}
                                        {% endfor %}

                                        <div class="text-center py-20">                  
                                            <div class="donut" data-peity='{ "fill": ["#17418a", "#edb717", "#b52825", "#8aecd0", "#666ee8", "#17418a"], "radius": 78, "innerRadius": 58  }' >{{valeurs}}</div>
                                        </div>

                                        <ul class="list-inline" style="margin-bottom:120px;">
                                            {% set compter = 1 %}

                                            {% for item in arretesType %}
                                                <li class="flexbox mb-5">
                                                    <div>
                                                        <a href="{{path('app_emine_cadre_juridique_arrete_type', {type: item.type})}}" class="text-dark">
                                                            <span class="badge badge-dot badge-lg me-1" {% if compter == 1 %}style="background-color: #17418a"{% elseif compter == 2 %}style="background-color: #edb717"{% elseif compter == 3 %}style="background-color: #b52825"{% elseif compter == 4 %}style="background-color: #8aecd0"{% elseif compter == 5 %}style="background-color: #666ee8"{% elseif compter == 6 %}style="background-color: #17418a"{% endif %}></span>
                                                            <span>{{item.type}}</span>
                                                        </a>
                                                    </div>
                                                    <div>
                                                        <a href="{{path('app_emine_cadre_juridique_arrete_type', {type: item.type})}}" class="text-dark">
                                                            {{item.nbre}} ({{ ((item.nbre / totalContrib) * 100)|round(1, 'floor') }}%)
                                                        </a>
                                                    </div>
                                                </li>

                                                {% set compter = compter + 1 %}
                                            {% endfor %}
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Modal -->
        <div class="modal fade" id="staticBackdrop1" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
            <div class="modal-dialog modal-dialog-centered">
                <div class="modal-content">
                <div class="modal-header bg-primar text-white">
                    <h5 class="modal-title" id="staticBackdropLabel">Filtrage de données</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                    <form action="{{path('app_reporting_dashbord_arrete')}}" method="POST">
                        <div class="modal-body">
                            <div class="mb-3">
                                <div class="form-group">
                                    <label class="form-label"><strong>Année</strong></label>
                                    <select class="form-control js-choice1" style="width: 100%;" name="annee">
                                        {% for item in 2005..2050 %}
                                            <option value="{{item}}">{{item}}</option>
                                        {% endfor %}
                                    </select>
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal"><i class="fa fa-close"></i> Fermer</button>
                            <button type="submit" class="btn text-white" style="background-color:#17418a;"><i class="fa fa-check"></i> Valider</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>

        <elevenlabs-convai agent-id="agent_0701kh8g5nenf9y9jcwbs8qfmvyw"></elevenlabs-convai><script src="https://unpkg.com/@elevenlabs/convai-widget-embed" async type="text/javascript"></script>
    {% endblock %}
#}

{% block javascripts %}
	{{parent()}}

	<script>
		window.onload = function () {
            var element   = document.querySelector('.js-choice1');
            const choices = new Choices(element);

            $('.btn-flitre-prod').click(function() {
				$('.modal-prod').toggle();
			});

            var dataQteAnnuel        = [];
            var dataAnnees1          = [];
            var chiffreAffaire       = [];
            var dataDot              = [];
            var dataTotalProjet      = [];
            var dataCoutProjet       = [];
            var dataProjetTermine    = [];
            var dataProjetNonTermine = [];
            var dataProjetNonExecute = [];
            var dataDotation         = [];
            var dataCahier           = [];
            var dataRedevance        = [];
            var totalProjetTermine    = 0;
            var totalProjetNonTermine = 0;
            var totalProjetNonExecute = 0;

            {% for item1 in anneeMinDot..anneeMaxDot %}
                dataAnnees1[dataAnnees1.length] = "{{item1}}";

                {% for item in dotations %}
                    {% if item1 == item.annee %}
                        dataDotation[dataDotation.length] = parseFloat("{{item.montant}}");
                    {% endif %}
                {% endfor %}

                {% for item in cahier %}
                    {% if item1 == item.annee %}
                        dataCahier[dataCahier.length] = parseFloat("{{item.montant}}");
                    {% endif %}
                {% endfor %}

                {% for item in redevance %}
                    {% if item1 == item.annee %}
                        dataRedevance[dataRedevance.length] = parseFloat("{{item.montant}}");
                    {% endif %}
                {% endfor %}


                if(dataDotation['{{loop.index0}}'] == null) {
                    dataDotation[dataDotation.length] = 0;
                }

                if(dataCahier['{{loop.index0}}'] == null) {
                    dataCahier[dataCahier.length] = 0;
                }

                if(dataRedevance['{{loop.index0}}'] == null) {
                    dataRedevance[dataRedevance.length] = 0;
                }
            {% endfor %}

            var dataAnnees           = [];
            
            {% for item1 in anneeMin..anneeMax %}
                dataAnnees[dataAnnees.length] = "{{item1}}";

                {% for item in dotations %}
                    {% if item1 == item.annee %}
                        dataQteAnnuel[dataQteAnnuel.length]   = parseFloat("{{item.montant}}");
                        chiffreAffaire[chiffreAffaire.length] = parseFloat("{{item.montant}}");
                    {% endif %}
                {% endfor %}

                {% for item in dots %}
                    {% if item1 == item.annee %}
                        dataDot.push(parseFloat("{{item.nbre}}"));
                    {% endif %}
                {% endfor %}

                {% for item in totalProjet %}
                    {% if item1 == item.annee %}
                        dataTotalProjet.push(parseFloat("{{item.nbre}}"));
                    {% endif %}
                {% endfor %}

                {% for item in coutProjet %}
                    {% if item1 == item.annee %}
                        dataCoutProjet.push(parseFloat("{{item.montant}}"));
                    {% endif %}
                {% endfor %}

                {% for item in projetTermine %}
                    {% if item1 == item.annee %}
                        dataProjetTermine.push(parseFloat("{{item.nbre}}"));
                    {% endif %}
                {% endfor %}

                {% for item in projetNonTermine %}
                    {% if item1 == item.annee %}
                        dataProjetNonTermine.push(parseFloat("{{item.nbre}}"));
                    {% endif %}
                {% endfor %}

                {% for item in projetNonExecute %}
                    {% if item1 == item.annee %}
                        dataProjetNonExecute.push(parseFloat("{{item.nbre}}"));
                    {% endif %}
                {% endfor %}

                if(dataProjetNonExecute['{{loop.index0}}'] == null) {
                    dataProjetNonExecute.push(0);
                }

                if(dataProjetNonTermine['{{loop.index0}}'] == null) {
                    dataProjetNonTermine.push(0);
                }

                if(dataProjetTermine['{{loop.index0}}'] == null) {
                    dataProjetTermine.push(0);
                }

                if(dataCoutProjet['{{loop.index0}}'] == null) {
                    dataCoutProjet.push(0);
                }

                if(dataTotalProjet['{{loop.index0}}'] == null) {
                    dataTotalProjet.push(0);
                }

                if(dataDot['{{loop.index0}}'] == null) {
                    dataDot.push(0);
                }

                if(dataDot['{{loop.index0 - 1}}'] != null) {
                    var total = parseInt(dataDot['{{loop.index0 - 1}}']) + parseInt(dataDot['{{loop.index0}}']);
                    dataDot['{{loop.index0}}'] = total;
                }
 
                if(chiffreAffaire['{{loop.index0}}'] == null) {
                    chiffreAffaire.push(0);
                    dataQteAnnuel.push(0);
                }
            {% endfor %}

            {% for item in projetTermine1 %}
                totalProjetTermine = totalProjetTermine + parseInt("{{item.nbre}}");
            {% endfor %}

            {% for item in projetNonTermine1 %}
                totalProjetNonTermine = totalProjetNonTermine + parseInt("{{item.nbre}}");
            {% endfor %}

            {% for item in projetNonExecute1 %}
                totalProjetNonExecute = totalProjetNonExecute + parseInt("{{item.nbre}}");
            {% endfor %}

            Highcharts.chart('market-chart-dotation', {
                chart: {
                    type: 'column',
                    backgroundColor: '#f6f7fa'
                },
                title: {
                    text: ""
                },
                xAxis: {
                    categories: dataAnnees,
                    crosshair: true,
                    accessibility: {
                    description: 'Countries'
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                    text: ""
                    }
                },
                tooltip: {
                    valueSuffix: ' USD'
                },
                plotOptions: {
                    column: {
                    pointPadding: 0.2,
                    borderWidth: 0
                    }
                },
                series: [
                    {
                        name: "Chiffre d'affaires",
                        color: '#2caffe',
                        data: chiffreAffaire
                    },
                     {
                        name: "Dotation 0,3%",
                        color: '#b52825',
                        data: dataQteAnnuel
                    },
                     {
                        name: "Coût de projets",
                        color: '#edb717',
                        data: dataCoutProjet
                    }
                ]
            });

            var dotProjet    = [];
            var dotVersement = [];
            var montantDotProjet    = [];
            var montantDotVersement = [];

            {% for item in versementByDot %}
                dotVersement.push('{{item.dot}}');
                montantDotVersement.push(parseFloat('{{item.montant}}'));
            {% endfor %}

            {% for item in coutProjetByDot %}
                dotProjet.push('{{item.dot}}');
                montantDotProjet.push(parseFloat('{{item.montant}}'));
            {% endfor %}

            Highcharts.chart('market-chart-dotation12', {
                chart: {
                    type: 'column',
                    backgroundColor: '#f6f7fa'
                },
                title: {
                    text: ""
                },
                xAxis: {
                    categories: dotVersement,
                    crosshair: true,
                    accessibility: {
                    description: 'Countries'
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                    text: ""
                    }
                },
                tooltip: {
                    valueSuffix: ' USD'
                },
                plotOptions: {
                    column: {
                    pointPadding: 0.2,
                    borderWidth: 0
                    }
                },
                series: [
                    {
                        name: "Dotation 0,3% versée",
                        color: '#2caffe',
                        data: montantDotVersement
                    }
                ]
            });

            Highcharts.chart('market-chart-dotation123', {
                chart: {
                    type: 'column',
                    backgroundColor: '#f6f7fa'
                },
                title: {
                    text: ""
                },
                xAxis: {
                    categories: dotProjet,
                    crosshair: true,
                    accessibility: {
                    description: 'Countries'
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                    text: ""
                    }
                },
                tooltip: {
                    valueSuffix: ' USD'
                },
                plotOptions: {
                    column: {
                    pointPadding: 0.2,
                    borderWidth: 0
                    }
                },
                series: [
                    {
                        name: "Coût de projets",
                        color: '#2caffe',
                        data: montantDotProjet
                    }
                ]
            });

            Highcharts.chart('market-chart-dotation-evolution', {
                chart: {
                    type: 'column',
                    backgroundColor: '#f6f7fa'
                },
                title: {
                    text: ""
                },
                xAxis: {
                    categories: dataAnnees1,
                    crosshair: true,
                    accessibility: {
                    description: 'Countries'
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                    text: ""
                    }
                },
                tooltip: {
                    valueSuffix: ' USD'
                },
                plotOptions: {
                    column: {
                    pointPadding: 0.2,
                    borderWidth: 0
                    }
                },
                series: [
                    {
                        name: "Cahier des charges",
                        color: '#2caffe',
                        data: dataCahier
                    },
                     {
                        name: "Dotation 0,3%",
                        color: '#b52825',
                        data: dataDotation
                    },
                     {
                        name: "Redevance",
                        color: '#edb717',
                        data: dataRedevance
                    }
                ]
            });

            var natures        = [];
            var filieres       = [];
            var dataFiliere    = [];
            var colorsFiliere  = [];
            var dataNature     = [];
            var colorsNature   = [];
            var compter        = 0;
            var provinces      = [];
            var dataProvinces  = [];

            {% for item in projetDotByNature %}
                dataNature.push({y: parseInt("{{item.nbre}}"), name: '{{item.nature}}'});
                natures.push("{{item.nature}}");
            {% endfor %}

            {% for item in dotByProvince %}
                dataProvinces.push({y: parseInt("{{item.nbre}}"), name: '{{item.province}}'});
                provinces.push("{{item.province}}");
            {% endfor %}

            {% for item in dotByFiliere %}
                dataFiliere.push({y: parseInt("{{item.nbre}}"), name: '{{item.filiere}}'});
                filieres.push("{{item.filiere}}");
            {% endfor %}

            Highcharts.chart('container11', {
                chart: {
                    type: 'pie',
                    backgroundColor: '#f6f7fa',
                    zooming: {
                    type: 'xy'
                    },
                    panning: {
                    enabled: true,
                    type: 'xy'
                    },
                    panKey: 'shift'
                },
                title: {
                    text: ""
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: [{
                        enabled: true,
                        distance: 20
                    }, {
                        enabled: true,
                        distance: -40,
                        format: '{point.y}',
                        style: {
                        fontSize: '1.2em',
                        textOutline: 'none',
                        opacity: 0.7
                        },
                        filter: {
                        operator: '>',
                        property: 'percentage',
                        value: 10
                        }
                    }]
                    }
                },
                series: [
                    {
                        name: 'Nombre des projets',
                        colorByPoint: true,
                        data: dataNature
                    }
                ]
                })
            ;

            Highcharts.chart('container21', {
                chart: {
                    type: 'pie',
                    backgroundColor: '#f6f7fa',
                    zooming: {
                    type: 'xy'
                    },
                    panning: {
                    enabled: true,
                    type: 'xy'
                    },
                    panKey: 'shift'
                },
                title: {
                    text: ''
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: [{
                        enabled: true,
                        distance: 20
                    }, {
                        enabled: true,
                        distance: -40,
                        format: '{point.y}',
                        style: {
                        fontSize: '1.2em',
                        textOutline: 'none',
                        opacity: 0.7
                        },
                        filter: {
                        operator: '>',
                        property: 'percentage',
                        value: 10
                        }
                    }]
                    }
                },
                series: [
                    {
                    name: 'Nombre des projets',
                    colorByPoint: true,
                    data: [
                        {
                            name: 'En cours',
                            sliced: true,
                            selected: true,
                            y: totalProjetNonTermine
                        },
                        {
                            name: 'Non exécutés',
                            y: totalProjetNonExecute
                        },
                        {
                            name: 'Terminés',
                            y: totalProjetTermine
                        }
                    ]
                    }
                ]
                })
            ;

            Highcharts.chart('container21111', {
                chart: {
                    type: 'pie',
                    backgroundColor: '#f6f7fa',
                    zooming: {
                    type: 'xy'
                    },
                    panning: {
                    enabled: true,
                    type: 'xy'
                    },
                    panKey: 'shift'
                },
                title: {
                    text: ''
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: [{
                        enabled: true,
                        distance: 20
                    }, {
                        enabled: true,
                        distance: -40,
                        format: '{point.y}',
                        style: {
                        fontSize: '1.2em',
                        textOutline: 'none',
                        opacity: 0.7
                        },
                        filter: {
                        operator: '>',
                        property: 'percentage',
                        value: 10
                        }
                    }]
                    }
                },
                series: [
                    {
                        name: 'Nombre des projets',
                        colorByPoint: true,
                        data: dataFiliere
                    }
                ]
                })
            ;

            Highcharts.chart('container21111111', {
                chart: {
                    type: 'pie',
                    backgroundColor: '#f6f7fa',
                    zooming: {
                    type: 'xy'
                    },
                    panning: {
                    enabled: true,
                    type: 'xy'
                    },
                    panKey: 'shift'
                },
                title: {
                    text: ''
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: [{
                        enabled: true,
                        distance: 20
                    }, {
                        enabled: true,
                        distance: -40,
                        format: '{point.y}',
                        style: {
                        fontSize: '1.2em',
                        textOutline: 'none',
                        opacity: 0.7
                        },
                        filter: {
                        operator: '>',
                        property: 'percentage',
                        value: 10
                        }
                    }]
                    }
                },
                series: [
                    {
                        name: 'Nombre des projets',
                        colorByPoint: true,
                        data: dataProvinces
                    }
                ]
                })
            ;
        }
    </script>
{% endblock %}