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

{% block title %}
	{{parent()}}-Tableau de bord-Consommation intrants
{% endblock %}

{% block content %}
    {% set mois1 = {
			'01': 'janvier',
			'02': 'février',
			'03': 'mars',
			'04': 'avril',
			'05': 'mais',
			'06': 'juin',
			'07': 'juillet',
			'08': 'août',
			'09': 'septembre',
			'10': 'octobre',
			'11': 'novembre',
			'12': 'décembre'
		}
	%}

	{% set mois2 = mois1[mois] %}

	<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>
                    {% else %}
                        <li>
                            <a href="#">Accès autorités</a>
                        </li>
                    {% endif %}
                    <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">Consommation intrants</li>
				</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">
				<div>
					<h1 class="fw-bold mb-1" style="font-family: var(--font-display); font-size: 1.6rem;">
						📊 Consommation intrants
					</h1>
					<p class="text-muted-mine mb-0" style="font-size: 0.9rem">
						Statistiques de la consommation intrants
					</p>
				</div>

                <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-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Consommation mensuelle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Evolution mensuelle de la consommation de l'intrant en {{dateAnnnee|date('Y')}}
                            {% if intrant is not null %}
                                <br>
                                {{intrant.nom}}
                            {% 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">Consommation trimestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Evolution trimestrielle de la consommation de l'intrant en {{dateAnnnee|date('Y')}}
                            {% if intrant is not null %}
                                <br>
                                {{intrant.nom}}
                            {% 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">Consommation semestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation semestrielle de la taxe en {{dateAnnnee|date('Y')}}
                            {% if intrant is not null %}
                                <br>
                                {{intrant.nom}}
                            {% 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 annuelle de la consommation de l'intrant
                            {% if intrant is not null %}
                                <br>
                                {{intrant.nom}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart1"></div>
						</div>
					</div>
				</div>
			</div>
            <div class="mb-5"></div>
            <div class="row g-4">
                <div class="col-lg-12">
					<div class="dashboard-card p-4">
						<h5 class="fw-semibold mb-1">Consommateurs</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							15 premiers  consommateurs de l'intrant {% if intrant is not null %}({{intrant.nom}}){% endif %}{{dateAnnnee|date('Y')}}
						</p>
						<div>
							<div class="dashboard-table-wrap">
                                <table class="dashboard-table">
                                    <thead>
                                        <tr>
                                            <th>N°</th>
                                            <th>OPERATEUR</th>
                                            <th>PROJET</th>
                                            <th>CENTRE</th>
                                            <th>QUANTITé</th>
                                            <th>POURCENTAGE</th>
                                        </tr>
                                    </thead>
                                    <tbody id="search-results">
                                        {% set compter = 0 %}
                                        {% set total   = 0 %}

                                        {% for item in producteurs %}
                                            {% set total   = total + item.quantite %}
                                        {% endfor %}

                                        {% for proprietaire_reel in producteurs %}
                                            {% set compter  = compter + 1 %}
                                            <tr>
                                                <td style="font-family: var(--font-display); font-weight: 600; font-size:0.82rem; color:var(--copper);">{{ compter }}</td>
                                                <td class="fw-medium">{{ proprietaire_reel.operateur }}</td>
                                                <td class="fw-medium">{{ proprietaire_reel.projet }}</td>
                                                <td class="fw-medium">{{ proprietaire_reel.centre }}</td>
                                                <td style="font-size:0.85rem;">{{ proprietaire_reel.quantite}} L</td>
                                                <td style="font-size:0.85rem;">{{((proprietaire_reel.quantite / total) * 100)|round(2, 'floor')}} %</td>
                                            </tr>
                                        {% else %}
                                            <tr class="text-center">
                                                <td colspan="6" class="text-center py-5 text-muted-mine">Aucune information dans la base de données.</td>
                                            </tr>
                                        {% endfor %}
                                    </tbody>
                                </table>
                            </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 la consommation
            </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_autres_besoin_intrant_reporting_show', {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>
					Mois
					</label>
					<select
					id="filter-year"
					name="mois"
					class="form-select js-choice2">
						<option value="01">Janvier</option>
                        <option value="02">Février</option>
                        <option value="03">Mars</option>
                        <option value="04">Avril</option>
                        <option value="05">Mai</option>
                        <option value="06">Juin</option>
                        <option value="07">Juillet</option>
                        <option value="08">Août</option>
                        <option value="09">Septembre</option>
                        <option value="10">Octobre</option>
                        <option value="11">Novembre</option>
                        <option value="12">Décembre</option>
					</select>
				</div>

                <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>
					    Intrant
					</label>
					<select
					id="filter-status"
					name="intrant"
					class="form-select js-choice3">
						{% for item in intrants %}
							<option key="{{item.id}}" value="{{item.id}}">{{item.nom}}</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 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 = [];

            {% 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}}"));

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


            Highcharts.chart('market-chart', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: ""
			},
			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: ' l'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "{{intrant.nom}}",
					color: '#2caffe',
					data: dataQteMensuel
				}
			]
		}); 

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

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

        Highcharts.chart('market-chart1', {
			chart: {
				type: 'column',
				backgroundColor: '#f6f7fa'
			},
			title: {
				text: ""
			},
			xAxis: {
				categories: dataAnnees,
				crosshair: true,
				accessibility: {
				description: 'Countries'
				}
			},
			yAxis: {
				min: 0,
				title: {
				text: ""
				}
			},
			tooltip: {
				valueSuffix: ' l'
			},
			plotOptions: {
				column: {
				pointPadding: 0.2,
				borderWidth: 0
				}
			},
			series: [
				{
					name: "{{intrant.nom}}",
					color: '#2caffe',
					data: dataQteAnnuel
				}
			]
		});
        }
    </script>
{% endblock %}