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

{% block title %}{{parent()}}-Exportations{% 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>
                <li>
                    <a href="#">Statistiques</a>
                </li>
                {% if operateur is null %}
                    <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">Exportations</li>
                {% else %}
                    <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><a href="#">Exportations</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">{{operateur.denomination}}</li>
                {% endif %}

            </ol>
          </nav>
            {% if operateur is null %}
                <div class="d-flex flex-column flex-md-row align-items-start align-items-md-center justify-content-between gap-3 mb-4">
                    <div>
                        <h1 class="fw-bold mb-1" style="font-family: var(--font-display); font-size: 1.6rem;">
                            📊 Exportations
                        </h1>
                        <p class="text-muted-mine mb-0" style="font-size: 0.9rem">
                            Statistiques des exportations en {{dateAnnnee|date('Y')}}
                        </p>
                    </div>

                    <div class="d-flex gap-2 flex-wrap">
                        <a
                            href="{{path('app_emine_production_exportation_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--copper);
                            color: #fff;
                            border: 1px solid var(--copper);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>📦</span> Exportations
                        </a>

                        <a
                            href="{{path('app_emine_production_production_stat_industriel')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>⛏️</span> Production
                        </a>

                        <a
                            href="{{path('app_emine_production_vente_local_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>🏪</span> Vente locale
                        </a>

                        <a
                            href="{{path('app_emine_obligation_rapatriement_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>🏦</span> Rapatriement 60%
                        </a>

                        <a
                            href="{{path('app_emine_obligation_taxe_analyse')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>💰</span> Recettes
                        </a>
                    </div>
                </div>
            {% else %}
                <div class="d-flex flex-column flex-md-row align-items-start align-items-md-center justify-content-between gap-3 mb-4">
                    <div>
                        <h1 class="fw-bold mb-1" style="font-family: var(--font-display); font-size: 1.6rem;">
                            📊 Exportations
                        </h1>
                        <p class="text-muted-mine mb-0" style="font-size: 0.9rem">
                            Statistiques des exportations en {{dateAnnnee|date('Y')}}
                        </p>
                    </div>

                    <div class="d-flex gap-2 flex-wrap">
                        <a
                            href="{{path('app_emine_production_exportation_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--copper);
                            color: #fff;
                            border: 1px solid var(--copper);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>📦</span> Exportations
                        </a>

                        <a
                            href="{{path('app_emine_production_production_stat_industriel')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>⛏️</span> Production
                        </a>

                        <a
                            href="{{path('app_emine_production_vente_local_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>🏪</span> Vente locale
                        </a>

                        <a
                            href="{{path('app_emine_obligation_rapatriement_stat')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>🏦</span> Rapatriement 60%
                        </a>

                        <a
                            href="{{path('app_emine_obligation_taxe_analyse')}}"
                            class="btn btn-sm d-flex align-items-center gap-2"
                            style="
                            background: var(--card-bg);
                            color: var(--bs-body-color);
                            border: 1px solid var(--border-color);
                            borderRadius: 8;
                            fontWeight: 600;
                            fontSize: 0.85rem;
                            padding: 8px 18px;
                            transition: all 0.2s ease;"
                        >
                            <span>💰</span> Recettes
                        </a>
                    </div>
                </div>
            {% endif %}

            <div class="dashboard-card mb-4">
				<div class="d-flex flex-column flex-md-row gap-3 p-3 float-end">
					<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>

                        <a class="operators-btn operators-btn-primary btn" href="{{path('app_emine_production_exportation_stat_tab')}}?annee={{dateAnnnee|date('Y')}}&commodite={{commodite.id}}">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-grid-3x2" viewBox="0 0 16 16">
                                <path d="M0 3.5A1.5 1.5 0 0 1 1.5 2h13A1.5 1.5 0 0 1 16 3.5v8a1.5 1.5 0 0 1-1.5 1.5h-13A1.5 1.5 0 0 1 0 11.5zM1.5 3a.5.5 0 0 0-.5.5V7h4V3zM5 8H1v3.5a.5.5 0 0 0 .5.5H5zm1 0v4h4V8zm4-1V3H6v4zm1 1v4h3.5a.5.5 0 0 0 .5-.5V8zm0-1h4V3.5a.5.5 0 0 0-.5-.5H11z"/>
                            </svg>
                            Tableaux
                        </a>

                        <a class="operators-btn operators-btn-primary btn" href="{{path('app_emine_production_exportation_export', {cmt: commodite.id, annee: dateAnnnee|date('Y')})}}">
                            <svg width="15" height="15" viewbox="0 0 24 24" fill="none" stroke="currentColor" strokewidth="2" strokelinecap="round" strokelinejoin="round">
                                <path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/>
                            </svg>
                            Exporter en Excel
                        </a>
					</div>
				</div>
			</div>

			<div class="mb-5"></div>
			<div class="row g-4">
				<div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Exportation mensuelle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation mensuelle de l'exportation en {{dateAnnnee|date('Y')}}
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart"></div>
						</div>
					</div>
				</div>

                <div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Exportation trimestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation trimestrielle de l'exportation en {{dateAnnnee|date('Y')}}
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart2"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="mb-5"></div>
			<div class="row g-4">
				<div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Exportation semestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation semestrielle de l'exportation en {{dateAnnnee|date('Y')}}
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart3"></div>
						</div>
					</div>
				</div>

				<div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Evolution</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Evolution de l'exportation durant les années
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart1"></div>
						</div>
					</div>
				</div>
			</div>

            {% if operateur is null %}
                <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">Titulaires des droits miniers & Entités de traitements</h5>
                            <p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
                                Exportations provenant des Titulaires des droits miniers et des Entités de traitements
                            </p>
                            <div>
                                <div id="market-chart11"></div>
                            </div>
                        </div>
                    </div>
                    <div class="mb-1"></div>
                    <div class="col-lg-12">
                        <div class="chart-container p-4">
                            <h5 class="fw-semibold mb-1">Entités de traitements</h5>
                            <p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
                                Exportations des entités de traitements provenant des Titulaires des droits miniers et les Artisanaux
                            </p>
                            <div class="table-responsive">
                                <div id="market-chart12"></div>
                            </div>
                        </div>
                    </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">Entités de traitements</h5>
                            <p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
                                Exportations des entités de traitements selon les provenances
                            </p>
                            <div class="table-responsive">
                                <div id="market-chart14"></div>
                            </div>
                        </div>
                    </div>
                    <div class="mb-1"></div>
                    <div class="col-lg-12">
                        <div class="chart-container p-4">
                            <h5 class="fw-semibold mb-1">Opérateurs Industriels & opérateurs Artisanaux</h5>
                            <p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
                                Exportations provenant des opérateurs Industriels et les opérateurs Artisanaux
                            </p>
                            <div class="table-responsive">
                                <div id="market-chart13"></div>
                            </div>
                        </div>
                    </div>
                </div>
            {% endif %}
            <div class="mb-5"></div>
            <div class="row g-4">
                <div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Exportation annuelle par pays</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation de l'exportation par pays de destination en {{dateAnnnee|date('Y')}}
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div class="table-responsive">
							<div id="market-chart4"></div>
						</div>
					</div>
				</div>
		
                <div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Exportation globale par pays</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation globale de l'exportation par pays de destination
                            <br>
                            {% if operateur is not null %}
                                Par {{operateur.denomination}}
                            {% endif %}
						</p>
						<div class="table-responsive">
							<div id="customized-chart"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="mb-5"></div>
        </div>
    </main>  

    <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 exportations
            </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_production_exportation_stat')}}" 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="annee"
					class="form-select js-choice1">
						{% for item in 1999..'now'|date('Y') %}
							<option value="{{item}}">{{item}}</option>
						{% endfor %}
					</select>
				</div>

                <div class="filter-group">
					<label class="filter-label" htmlFor="filter-status">
					    <span class="filter-label-icon" style='background: $17418a18; color: #17418a;'>💎</span>
					    Commodité
					</label>
					<select
					id="filter-status"
					name="commodite"
					class="form-select js-choice3">
						{% for item in commodites %}
							<option key="{{item.id}}" value="{{item.id}}">{{item.nom}}</option>
						{% endfor %}
					</select>
				</div>

				<div class="filter-group">
					<label class="filter-label" htmlFor="filter-status">
					    <span class="filter-label-icon" style='background: $17418a18; color: #17418a;'>🏭</span>
					    Operateur
					</label>
					<select
					id="filter-status"
					name="operateur"
					class="form-select js-choice2">
                        <option value="0">Tous</option>
						{% for item in operateurs %}
							<option key="{{item.id}}" value="{{item.id}}">{{item.denomination}}</option>
						{% endfor %}
					</select>
				</div>
			</div>

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


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

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

            var element = document.querySelector('.js-choice2');
            const choices1 = new Choices(element);

            var element = document.querySelector('.js-choice3');
            const choices2 = new Choices(element);

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

            var dataQteMensuel   = [];
            var dataQteAnnuel    = [];
            var dataAnnees       = [];
            var dataQteSemestre  = [];
            var dataQteTrimestre = [];
            var dataPays         = [];
            var dataPays1        = [];

            {% set qteTrimeste1  = 0 %}
            {% set qteTrimeste2  = 0 %}
            {% set qteTrimeste3  = 0 %}
            {% set qteTrimeste4  = 0 %}

            {% for item in 0..11 %}
                {% if qteMensuel[item] is defined %}
                    dataQteMensuel.push(parseFloat("{{qteMensuel[item]}}"));
                {% else %}
                    dataQteMensuel.push(0);
                {% endif %}

                {% if item < 3 %}
                    {% if qteMensuel[item] is defined %}
                        {% set qteTrimeste1  = qteTrimeste1 + qteMensuel[item] %}
                    {% endif %}
                {% endif %}

                {% if item >= 3 and item <= 5 %}
                    {% if qteMensuel[item] is defined %}
                        {% set qteTrimeste2  = qteTrimeste2 + qteMensuel[item] %}
                    {% endif %}
                {% endif %}

                {% if item >= 6 and item <= 8 %}
                    {% if qteMensuel[item] is defined %}
                        {% set qteTrimeste3  = qteTrimeste3 + qteMensuel[item] %}
                    {% endif %}
                {% endif %}

                {% if item >= 9 and item <= 11 %}
                    {% if qteMensuel[item] is defined %}
                        {% set qteTrimeste4  = qteTrimeste4 + qteMensuel[item] %}
                    {% endif %}
                {% endif %}
            {% endfor %}

            var dataQteSemestre      = [];
            
            dataQteTrimestre.push(parseFloat("{{qteTrimeste1}}"));
            dataQteTrimestre.push(parseFloat("{{qteTrimeste2}}"));
            dataQteTrimestre.push(parseFloat("{{qteTrimeste3}}"));
            dataQteTrimestre.push(parseFloat("{{qteTrimeste4}}"));

            dataQteSemestre.push(parseFloat("{{qteTrimeste1 + qteTrimeste2}}"));
            dataQteSemestre.push(parseFloat("{{qteTrimeste3 + qteTrimeste4}}"));

            var pays         = [];
            var colorsPays   = [];
            var compter      = 0;
            var global       = [];
            var colorsGlobal = [];

            {% for item in exportAnnuel %}
                dataAnnees.push("{{item.annee}}");
                dataQteAnnuel.push(parseFloat("{{item.quantite}}"));
            {% endfor %}


            {% for item in exportPays %}
                var data = {
                   y: parseFloat("{{item.quantite}}"),
                   name: "{{item.pays}}"
                };

                dataPays.push(data);
                pays.push("{{item.pays}}");
            {% endfor %}

            {% for item in exportPaysGlob %}
                var data = {
                   y: parseFloat("{{item.quantite}}"),
                   name: "{{item.pays}}"
                };

                dataPays1.push(data);
                global.push("{{item.pays}}");
            {% endfor %}

        Highcharts.chart('market-chart', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: ['Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre'],
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Exportation",
					color: '{{commodite.color}}',
					data: dataQteMensuel
				}
			]
		}); 

        Highcharts.chart('market-chart2', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: ['1er trimestre', '2è trimestre', '3è trimestre', '4è trimestre'],
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Exportation",
					color: '{{commodite.color}}',
					data: dataQteTrimestre
				}
			]
		});

        Highcharts.chart('market-chart3', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: ['1er Semestre', '2è Semestre'],
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Exportation",
					color: '{{commodite.color}}',
					data: dataQteSemestre
				}
			]
		});

        Highcharts.chart('market-chart1', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: dataAnnees,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Exportation",
					color: '{{commodite.color}}',
					data: dataQteAnnuel
				}
			]
		});

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

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

        var artisanal  = [];
        var entite     = [];
        var indistruel = [];
        var titulaire  = [];
        var titulaireSecond = [];
        var anneeTutilaire  = [];
        var artisanauxCoop  = [];
        var stock           = [];
        var traitementFacon = [];
        var cooperative     = [];
        var tutilaireFacon  = [];

        {% for item in anneeMin..anneeMax %}
            anneeTutilaire.push("{{item}}");

            {% for item5 in exportProvenance %}
                {% if item5.annee == item %}
                    {% if item5.provenance == 7  %}
                        artisanauxCoop.push(parseFloat("{{item5.quantite}}"));
                    {% elseif item5.provenance == 6 %}
                        stock.push(parseFloat("{{item5.quantite}}"));
                    {% elseif item5.provenance == 5 %}
                        traitementFacon.push(parseFloat("{{item5.quantite}}"));
                    {% elseif item5.provenance == 2 %}
                        cooperative.push(parseFloat("{{item5.quantite}}"));
                    {% elseif item5.provenance == 1 %}
                        tutilaireFacon.push(parseFloat("{{item5.quantite}}"));
                    {% endif %}
                {% endif %}
            {% endfor %}

            {% for item1 in exportEntite %}
                {% if item1.annee == item %}
                    entite.push(parseFloat("{{item1.quantite}}"));
                {% endif %}
            {% endfor %}

            {% for item1 in exportTitulaire %}
                {% if item1.annee == item %}
                    titulaire.push(parseFloat("{{item1.quantite}}"));
                {% endif %}
            {% endfor %}

            {% for item2 in exportArtisanal %}
                {% if item2.annee == item %}
                    artisanal.push(parseFloat("{{item2.quantite}}"));
                {% endif %}
            {% endfor %}

            {% for item3 in exportTitulaireSecond %}
                {% if item3.annee == item %}
                    titulaireSecond.push(parseFloat("{{item3.quantite}}"));
                {% endif %}
            {% endfor %}

            if(entite["{{loop.index0}}"] == null) {
                entite["{{loop.index0}}"] = 0
            }

            if(titulaire["{{loop.index0}}"] == null) {
                titulaire["{{loop.index0}}"] = 0
            }

            if(indistruel["{{loop.index0}}"] == null) {
                indistruel["{{loop.index0}}"] = 0
            }

            if(artisanal["{{loop.index0}}"] == null) {
                artisanal["{{loop.index0}}"] = 0
            }

            if(titulaireSecond["{{loop.index0}}"] == null) {
                titulaireSecond["{{loop.index0}}"] = 0
            }

            if(artisanauxCoop["{{loop.index0}}"] == null) {
                artisanauxCoop["{{loop.index0}}"] = 0
            }

            if(stock["{{loop.index0}}"] == null) {
                stock["{{loop.index0}}"] = 0
            }

            if(traitementFacon["{{loop.index0}}"] == null) {
                traitementFacon["{{loop.index0}}"] = 0
            }

            if(cooperative["{{loop.index0}}"] == null) {
                cooperative["{{loop.index0}}"] = 0
            }

            if(tutilaireFacon["{{loop.index0}}"] == null) {
                tutilaireFacon["{{loop.index0}}"] = 0
            }
        {% endfor %}

        Highcharts.chart('market-chart11', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: anneeTutilaire,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Titulaires de droits miniers",
					color: '#2caffe',
					data: titulaire
				},
                {
					name: "Entités des traitements",
					color: '#00e272',
					data: entite
				}
			]
		}); 

        Highcharts.chart('market-chart12', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: anneeTutilaire,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Titulaires des droits miniers",
					color: '#2caffe',
					data: titulaireSecond
				},
                {
					name: "Opérateurs Artisanaux",
					color: '#00e272',
					data: artisanal
				}
			]
		});

        Highcharts.chart('market-chart13', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: anneeTutilaire,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Opérateurs Artisanaux",
					color: '#00e272',
					data: artisanal
				},
                {
					name: "Opérateurs Industriels",
					color: '#2caffe',
					data: titulaire
				}
			]
		});

        Highcharts.chart('market-chart14', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: "{{commodite.nom}}"
			},
			xAxis: {
				categories: anneeTutilaire,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' {{commodite.filiere.unite}}'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "Artisanaux par Coopératives",
					color: '#00e272',
					data: artisanauxCoop
				},
                {
					name: "Titulaire de droits par traitement à façon",
					color: '#2caffe',
					data: tutilaireFacon
				},
                {
					name: "Stock",
					color: '#edb717',
					data: stock
				}
			]
		});
    }
</script>
{% endblock %}