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

{% block title %}
	{{parent()}}-Tableau de bord-Ventes-Locales
{% 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">Ventes locales</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;">
						📊 Ventes locales
					</h1>
					<p class="text-muted-mine mb-0" style="font-size: 0.9rem">
						Statistiques des ventes locales
					</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>

                    <a class="operators-btn operators-btn-primary btn" href="#">
                        <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 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">Vente journalière</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation journalière la vente locale en {{mois2}} {{dateAnnnee|date('Y')}}
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</p>
						<div>
							<div id="journaliere"></div>
						</div>
					</div>
				</div>

                <div class="col-lg-6">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Vente hebdomadaire</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation hebdomadaire sur la vente locale en {{mois2}} {{dateAnnnee|date('Y')}}
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</p>
						<div>
							<div id="semaine"></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">Vente mensuelle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation mensuelle sur la vente locale en {{dateAnnnee|date('Y')}}
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</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">Vente trimestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation trimestrielle sur la vente locale en {{dateAnnnee|date('Y')}}
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</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">Vente semestrielle</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisation semestrielle sur la vente locale en {{dateAnnnee|date('Y')}}
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</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 la vente locale durant les années
                            {% if operateur is not null %}
                                <br>
                                Par {{operateur.denomination}}
                            {% endif %}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</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">Ventes par commodité</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Réalisations mensuelles sur la vente locale en {{anneeProd}}
						</p>
						<div>
							<div class="box-body row">
								{% for commodite in commodites %}
									<div class="col-lg-4 col-12 mb-3">
										<div class="box pull-up overflow-hidden contracts-summary-card">
											<div class="box-body">
												<h5 class="mb-1">
                                                    <span class="float-start dashboard-badge" style="background: {{commodite.color}}18; color: {{commodite.color}}; borderColor:{{commodite.color}}44;font-size: 0.75rem;">
                                                        {{commodite.nom}}
                                                    </span>

                                                    <span class="float-end dashboard-badge" style="background: #f59e0b18; color: #d97706, borderColor:#f59e0b44;font-size: 0.75rem;">
                                                        {{anneeProd}}
                                                    </span>
												</h5>
												<br>
												<div class="d-flex justify-content-between">
													<p class="fs-26">{{tatalIndustru[loop.index0]}}
														{{commodite.filiere.unite}}; {{totalCoutVente[loop.index0]}}$</p>
													<div>
                                                    </div>
												</div>
											</div>
											<div class="box-body p-0">
												<div id="spark_prod_indu_{{commodite.id}}"></div>
											</div>
										</div>
									</div>
								{% endfor %}
							</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">Vendeurs mensuels</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							15 premiers vendeurs locaux en {{mois2}} {{dateAnnnee|date('Y')}}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</p>
						<div>
							<div class="dashboard-table-wrap">
                                <table class="dashboard-table">
                                    <thead>
                                        <tr>
                                            <th>N°</th>
                                            <th>OPERATEUR</th>
                                            <th>QUANTITé vendue</th>
                                            <th>POURCENTAGE vente</th>
                                            <th>Prix</th>
                                        </tr>
                                    </thead>
                                    <tbody id="search-results">
                                        {% set compter = 0 %}
                                        {% set total   = 0 %}

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

                                        {% for proprietaire_reel in producteurs1 %}
                                            {% set compter  = compter + 1 %}

                                            <tr class="animate-fade-in-up">
                                                <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 style="font-size:0.85rem;">{{ proprietaire_reel.quantite}} {{commodite ? commodite.filiere.unite : ' '}}</td>
                                                <td style="font-size:0.85rem;">{{((proprietaire_reel.quantite / total) * 100)|round(2, 'floor')}} %</td>
                                                <td style="font-size:0.85rem;">{{ proprietaire_reel.cout ? proprietaire_reel.cout : 0 }} USD</td>
                                            </tr>
                                        {% else %}
                                            <tr>
                                                <td colspan="5" 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 class="col-lg-12">
					<div class="dashboard-card p-4">
						<h5 class="fw-semibold mb-1">Vendeurs annuels</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							15 premiers vendeurs locaux en {{anneeProd}}
                            <br>
                            {{commodite ? commodite.nom : ' '}}
						</p>
						<div>
							<div class="dashboard-table-wrap">
                                <table class="dashboard-table">
                                    <thead>
                                        <tr>
                                            <th>N°</th>
                                            <th>OPERATEUR</th>
                                            <th>QUANTITé vendue</th>
                                            <th>POURCENTAGE vente</th>
                                            <th>PRIX</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 style="font-size:0.85rem;">{{ proprietaire_reel.quantite}} {{commodite ? commodite.filiere.unite : ' '}}</td>
                                                <td style="font-size:0.85rem;">{{((proprietaire_reel.quantite / total) * 100)|round(2, 'floor')}} %</td>
                                                <td style="font-size:0.85rem;">{{ proprietaire_reel.cout ? proprietaire_reel.cout : 0 }} USD</td>
                                            </tr>
                                        {% else %}
                                            <tr class="text-center">
                                                <td colspan="5" 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 production
            </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_vente', {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-choice7">
						<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="anneeProdJour"
					class="form-select js-choice8">
						{% 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-choice9">
						{% 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_vente', {menu: 'menu'})}}">Réinitialiser</a>
					<button class="filter-btn-apply" type='submit' style="background: #17418a;">
						Appliquer les filtres
					</button>
				</div>
			</form>
		</div>
    </div>
{% 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] %}

	<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 de la vente locale</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">Ventes locales</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:30px;margin-bottom:30px;">
									<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="#staticBackdropanneeProdJour">
											<i class="fa fa-filter"></i>
											Filtrer</a>
									</div>
								</div>

			
									<div class="col-xl-6 col-12" style="margin-top:30px;">
										<div class="box">
											<div class="table-responsive">
												<div>
													<div class="box-header bg-primary-light tex-dark">
														<h4 class="box-title text-dark">Réalisation journalière sur la vente locale ({{commodite ? commodite.nom : ' '}}) en
															{{mois2}}
															{{dateAnnnee|date('Y')}}</h4>
													</div>
													<div class="box-body">
														<div id="journaliere" class="h-450"></div>
													</div>
												</div>
											</div>
										</div>
									</div>

									<div class="col-xl-6 col-12" style="margin-top:30px;">
										<div class="box">
											<div>
												<div>
													<div class="box-header bg-primary-light">
														<h4 class="box-title text-dark">Réalisation hebdomadaire sur la vente locale ({{commodite ? commodite.nom : ' '}}) en
															{{mois2}}
															{{dateAnnnee|date('Y')}}</h4>
													</div>
													<div class="box-body">
														<div id="semaine" class="h-450"></div>
													</div>
												</div>
											</div>
										</div>
									</div>
							</div>
						</div>

						<div class="col-xl-6 col-12">
							<div class="box" id="statistique">
								<div class="table-responsive">
									<div>
										<div class="box-header">
											<h4 class="box-title">Réalisation mensuelle sur la vente locale ({{commodite ? commodite.nom : ' '}}) en {{dateAnnnee|date('Y')}}</h4>
										</div>
										<div class="box-body">
											<div id="market-chart"></div>
										</div>
									</div>
								</div>
							</div>
						</div>

						<div class="col-xl-6 col-12" id="emplois">
							<div class="box">
								<div class="table-responsive">
									<div>
										<div class="box-header">
											<h4 class="box-title">Réalisation trimestrielle sur la vente locale  ({{commodite ? commodite.nom : ' '}}) en {{dateAnnnee|date('Y')}}</h4>
										</div>
										<div class="box-body">
											<div id="market-chart2"></div>	
										</div>
									</div>
								</div>
							</div>
						</div>

						<div class="col-xl-6 col-12" id="evolution">
							<div class="box">
								<div class="table-responsive">
									<div>
										<div class="box-header">
											<h4 class="box-title">Réalisation semestrielle sur la vente locale ({{commodite ? commodite.nom : ' '}}) en {{dateAnnnee|date('Y')}}</h4>
										</div>
										<div class="box-body">
											<div id="market-chart3"></div>	
										</div>
									</div>
								</div>
							</div>
						</div>

						<div class="col-xl-6 col-12">
							<div class="box" id="statistique">
								<div class="table-responsive">
									<div>
										<div class="box-header">
											<h4 class="box-title">Evolution de la vente locale ({{commodite ? commodite.nom : ' '}})</h4>
										</div>
										<div class="box-body">
											<div id="market-chart1"></div>
										</div>
									</div>
								</div>
							</div>
						</div>

						<div class="box mix production all">
							<div class="box-header bg-primary-light">
								<h4 class="box-title">Réalisations mensuelles sur la vente locale ({{commodite ? commodite.nom : ' '}}) en {{dateAnnnee|date('Y')}}
									{{anneeProd}}
                                </h4>
							</div>

							<div class="box-body row">
								{% for commodite in commodites %}
									<div class="col-lg-4 col-12">
										<div class="box pull-up overflow-hidden">
											<div class="box-body">
												<h5 class="mb-0">
													<span class="text-uppercase fs-18">
														<svg xmlns="http://www.w3.org/2000/svg" width="55" height="55" fill="{{commodite.color}}" class="bi bi-record-fill text-primary" viewbox="0 0 16 16">
															<path fill-rule="evenodd" d="M8 13A5 5 0 1 0 8 3a5 5 0 0 0 0 10"/>
														</svg>
														{{commodite.nom}}
													</span>
													<span class="float-end badge badge-light">{{anneeProd}}</span>
												</h5>
												<br>
												<div class="d-flex justify-content-between">
													<p class="fs-26">{{tatalIndustru[loop.index0]}}
														{{commodite.filiere.unite}}; {{totalCoutVente[loop.index0]}}$   </p>
													<div>
														<i class="ion-arrow-graph-up-right me-1 text-success"></i>
														<strong>Vente locale</strong></div>
												</div>
											</div>
											<div class="box-body p-0">
												<div id="spark_prod_indu_{{commodite.id}}"></div>
											</div>
										</div>
									</div>
								{% endfor %}
							</div>
						</div>

                        <div class="col-xl-6 col-12">
                            <div class="box mix production all col-xl-6 col-12">
                                <div class="box-header bg-primary-light">
                                    <h4 class="box-title">15 premiers vendeurs locaux ({{commodite ? commodite.nom : ' '}}) en
                                        {{mois2}}
										{{dateAnnnee|date('Y')}}
                                    </h4>
                                </div>

                                <div class="box-body row">
                                    <div class="table-responsive " style="margin-top: 40px;">
                                        <table class="table table-bordered table-hover display nowrap margin-top-10 w-p100 shadow bg-body">
                                            <thead>
                                                <tr style="background-color: #17418a;">
                                                    <th class="bb-2 text-white">N°</th>
                                                    <th class="bb-2 text-white">OPERATEUR</th>
                                                    <th class="bb-2 text-white">QUANTITE VENDUE</th>
                                                    <th class="bb-2 text-white">POURCENTAGE VENTE</th>
                                                    <th class="bb-2 text-white">PRIX</th>
                                                </tr>
                                            </thead>
                                            <tbody id="search-results">
                                                {% set compter = 0 %}
                                                {% set total   = 0 %}

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

                                                {% for proprietaire_reel in producteurs1 %}
                                                    {% set compter  = compter + 1 %}

                                                    <tr>
                                                        <td>{{ compter }}</td>
                                                        <td>{{ proprietaire_reel.operateur }}</td>
                                                        <td>{{ proprietaire_reel.quantite}} {{commodite ? commodite.filiere.unite : ' '}}</td>
                                                        <td>{{((proprietaire_reel.quantite / total) * 100)|round(2, 'floor')}} %</td>
                                                        <td>{{ proprietaire_reel.cout}} USD</td>
                                                    </tr>
                                                {% else %}
                                                    <tr class="text-center">
                                                        <td colspan="5">Aucune information dans la base de données.</td>
                                                    </tr>
                                                {% endfor %}
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="col-xl-6 col-12">
                            <div class="box mix production all col-xl-6 col-12">
                                <div class="box-header bg-primary-light">
                                    <h4 class="box-title">15 premiers vendeurs locaux ({{commodite ? commodite.nom : ' '}}) en
                                        {{anneeProd}}</h4>
                                </div>

                                <div class="box-body row">
                                    <div class="table-responsive " style="margin-top: 40px;">
                                        <table class="table table-bordered table-hover display nowrap margin-top-10 w-p100 shadow bg-body">
                                            <thead>
                                                <tr style="background-color: #17418a;">
                                                    <th class="bb-2 text-white">N°</th>
                                                    <th class="bb-2 text-white">OPERATEUR</th>
                                                    <th class="bb-2 text-white">QUANTITE VENDUE</th>
                                                    <th class="bb-2 text-white">POURCENTAGE VENTE</th>
                                                    <th class="bb-2 text-white">PRIX</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>{{ compter }}</td>
                                                        <td>{{ proprietaire_reel.operateur }}</td>
                                                        <td>{{ proprietaire_reel.quantite}} {{commodite ? commodite.filiere.unite : ' '}}</td>
                                                        <td>{{((proprietaire_reel.quantite / total) * 100)|round(2, 'floor')}} %</td>
                                                        <td>{{ proprietaire_reel.cout}} USD</td>
                                                    </tr>
                                                {% else %}
                                                    <tr class="text-center">
                                                        <td colspan="5">Aucune information dans la base de données.</td>
                                                    </tr>
                                                {% endfor %}
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
					</div>
				</div>
			</div>
		</div>
	</div>


	<!-- Modal -->
	<div class="modal fade" id="staticBackdropanneeProdJour" 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_vente')}}" method="POST">
					<div class="modal-body">
						<div class="mb-3">
							<div class="form-group">
								<label class="form-label"><strong>Mois</strong></label>
								<select class="form-control js-choice7" style="width: 100%;" name="mois">
									<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="form-group">
								<label class="form-label"><strong>Année</strong></label>
								<select class="form-control js-choice8" style="width: 100%;" name="anneeProdJour">
									{% for item in 2000..2050 %}
										<option value="{{item}}">{{item}}</option>
									{% endfor %}    
								</select>
							</div>

							<div class="form-group">
								<label class="form-label"><strong>Commodité</strong></label>
								<select class="form-control js-choice9" style="width: 100%;" name="commodite">
									{% for item in commodites %}
										<option value="{{item.id}}">{{item.nom}}</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>

	<!-- Modal -->
	<div class="modal fade" id="staticBackdropLabelExport" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabelProd" 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_home_private')}}" method="POST">
					<div class="modal-body">
						<div class="mb-3">
							<div class="form-group">
								<label class="form-label">Année</label>
								<select class="form-control js-choice6" style="width: 100%;" name="anneeExport">
									{% for item in 2000..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 src="{{asset('js/pages/ico-filter.js')}}"></script>
    <script src="{{asset('js/apexChart.js')}}"></script>
	<script>
		var element = document.querySelector('.js-choice7');
        const choices6 = new Choices(element);

        var element = document.querySelector('.js-choice8');
        const choices7 = new Choices(element);

        var element = document.querySelector('.js-choice9');
        const choices8 = new Choices(element);

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

		window.onload = function () {
			var dataJour             = [];
            var dataSemaine          = [];
            var coutJour             = [];
            var coutSemaine          = [];

            {% for item in semaines %}
                var data = {
                    x: "{{item}}",
                    y: 0
                }
                dataSemaine.push(data);
                
                var data = {
                    x: "{{item}}",
                    y: 0
                }

                coutSemaine.push(data);
            {% endfor %}

            var dateOne = new Date("{{dateAnnnee|date('Y')}}" + "-{{mois}}-01");

            {% for item in prodJour %}
                var data = {
                    x: new Date("{{item.dateProd|date('Y-m-d')}}").getTime(),
                    y: "{{item.quantite}}"
                }
                dataJour.push(data);

                {% if item.cout is not null %}
                    var data = {
                        x: new Date("{{item.dateProd|date('Y-m-d')}}").getTime(),
                        y: "{{item.cout}}"
                    }
                {% else %}
                    var data = {
                        x: new Date("{{item.dateProd|date('Y-m-d')}}").getTime(),
                        y: 0
                    }
                {% endif %}
                coutJour.push(data);

                var dateTwo = new Date("{{item.dateProd|date('Y-m-d')}}");

                var dure = dateTwo - dateOne;
                dure     = dure/86400000;
                dure     = dure/7;

                console.log(dure);

                if(dure <= 1) {
                    dataSemaine[0].y = parseFloat(dataSemaine[0].y) + parseFloat("{{item.quantite}}");

                    {% if item.cout is not null %}
                        coutSemaine[0].y = parseFloat(coutSemaine[0].y) + parseFloat("{{item.cout}}");
                    {% endif %}
                    
                } else if(dure > 4) {
                    dataSemaine[4].y = parseFloat(dataSemaine[4].y) + parseFloat("{{item.quantite}}");

                    {% if item.cout is not null %}
                        coutSemaine[4].y = parseFloat(coutSemaine[4].y) + parseFloat("{{item.cout}}");
                    {% endif %}
                } else {
                    var step = parseInt(dure);

                    dataSemaine[step].y = parseFloat(dataSemaine[step].y) + parseFloat("{{item.quantite}}");

                    {% if item.cout is not null %}
                        coutSemaine[step].y = parseFloat(coutSemaine[step].y) + parseFloat("{{item.cout}}");
                    {% endif %}
                }
            {% endfor %}

            var options = {
                series: [{
                    name: "Quantité",
                    type: 'column',
                    data: dataJour
                },
                {
                    name: "Coût",
                    type: 'line',
                    data: coutJour
                }],
                colors: ['{{commodite.color}}', '#17418a'],
                chart: {
                height: 350,
                type: 'line',
                zoom: {
                    enabled: false
                }
                },
                markers: {
                    size: 5,
                },
                dataLabels: {
                    enabled: false
                },
                stroke: {
                    curve: 'straight'
                },
                title: {
                    text: "",
                    align: 'center'
                },
                grid: {
                row: {
                    colors: ['#f4f6f9', 'transparent'],
                    opacity: 0.5
                },
                },
                xaxis: {
                    type: 'datetime',
                },
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            };

            var chart = new ApexCharts(document.querySelector("#journaliere"), options);
            chart.render();

            var options = {
                series: [{
                    name: "Quantité",
                    type: 'column',
                    data: dataSemaine
                },
                {
                    name: "Coût",
                    type: 'line',
                    data: coutSemaine
                }],
                colors: ['{{commodite.color}}', '#17418a'],
                chart: {
                height: 350,
                type: 'line',
                zoom: {
                    enabled: false
                }
                },
                markers: {
                    size: 5,
                },
                dataLabels: {
                    enabled: false
                },
                stroke: {
                    curve: 'straight'
                },
                title: {
                    text: "",
                    align: 'center'
                },
                grid: {
                row: {
                    colors: ['#f4f6f9', 'transparent'],
                    opacity: 0.5
                },
                },
                xaxis: {
                    type: 'string',
                },
                yaxis: [{
                    title: {
                    text: '',
                    },
                }],
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            };

            var chart = new ApexCharts(document.querySelector("#semaine"), options);
            chart.render(); 


            {% for commodite in commodites %}
                {% set step = loop.index0 %}
                var dataProdIndu = [];
                var dataProdArti = [];
                var dataExport1   = [];

                {% for item in prodIndust[step] %}
                    dataProdIndu["{{loop.index0}}"] = "{{item}}";
                {% endfor %}

                var spark2 = {
                chart: {
                    type: 'area',
                    height: 120,
                    sparkline: {
                    enabled: true
                    },
                },
                stroke: {
                    curve: 'smooth'
                },
                fill: {
                    opacity: 0,
                    type: 'solid',
                    gradient: {
                    gradientToColors: ['{{commodite.color}}']
                    },
                },
                series: [{
                    name: 'Production industrielle',
                    data: dataProdIndu
                }],
                labels: ['Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre'],
                yaxis: {
                    min: 0
                },
                xaxis: {
                    type: 'string',
                },
                colors: ['{{commodite.color}}'],
                    tooltip: {
                        theme: 'dark',
                        y: {
                            formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            return value + " {{commodite.filiere ? commodite.filiere.unite : ''}}";
                        }
                    }
                    },
                }
                
                var spark2 = new ApexCharts(document.querySelector("#spark_prod_indu_{{commodite.id}}"), spark2);
                spark2.render();                     
            {% endfor %}


			var dataQteMensuel   = [];
            var dataCoutsMensuel = [];
            var dataQteAnnuel    = [];
            var dataCoutsAnnuel  = [];
            var dataAnnees       = [];
            var dataCoutSemestre     = [];
            var dataQteSemestre      = [];
            var dataCoutTrimestre    = [];
            var dataQteTrimestre     = [];

            {% set qteTrimeste1  = 0 %}
            {% set coutTrimeste1 = 0 %}

            {% set qteTrimeste2  = 0 %}
            {% set coutTrimeste2 = 0 %}

            {% set qteTrimeste3  = 0 %}
            {% set coutTrimeste3 = 0 %}

            {% set qteTrimeste4  = 0 %}
            {% set coutTrimeste4 = 0 %}

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

                {% if coutsMensuel[item] is defined %}
                    {% if coutsMensuel[item] is not null %}
                        dataCoutsMensuel.push("{{coutsMensuel[item]}}");
                    {% else %}
                        dataCoutsMensuel.push(0);
                    {% endif %}
                {% else %}
                    dataCoutsMensuel.push(0);
                {% endif %}

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

                    {% if coutsMensuel[item] is defined %}
                        {% set coutTrimeste1 = coutTrimeste1 + coutsMensuel[item] %}
                    {% endif %}
                {% endif %}

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

                    {% if coutsMensuel[item] is defined %}
                        {% set coutTrimeste2 = coutTrimeste2 + coutsMensuel[item] %}
                    {% endif %}
                {% endif %}

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

                    {% if coutsMensuel[item] is defined %}
                        {% set coutTrimeste3 = coutTrimeste3 + coutsMensuel[item] %}
                    {% endif %}
                {% endif %}

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

                    {% if coutsMensuel[item] is defined %}
                        {% set coutTrimeste4 = coutTrimeste4 + coutsMensuel[item] %}
                    {% endif %}
                {% endif %}
            {% endfor %}

            var dataCoutSemestre     = [];
            var dataQteSemestre      = [];
            

            dataCoutTrimestre.push("{{coutTrimeste1}}");
            dataQteTrimestre.push("{{qteTrimeste1}}");

            dataCoutTrimestre.push("{{coutTrimeste2}}");
            dataQteTrimestre.push("{{qteTrimeste2}}");

            dataCoutTrimestre.push("{{coutTrimeste3}}");
            dataQteTrimestre.push("{{qteTrimeste3}}");

            dataCoutTrimestre.push("{{coutTrimeste4}}");
            dataQteTrimestre.push("{{qteTrimeste4}}");

            dataCoutSemestre.push("{{coutTrimeste1 + coutTrimeste2}}");
            dataQteSemestre.push("{{qteTrimeste1 + qteTrimeste2}}");

            dataCoutSemestre.push("{{coutTrimeste3 + coutTrimeste4}}");
            dataQteSemestre.push("{{qteTrimeste3 + qteTrimeste4}}");

            {% for item in prodEvolution %}
                dataAnnees.push("{{item.annee}}");

                {% if item.cout is not null %}
                    dataCoutsAnnuel.push("{{item.cout}}");
                {% else %}
                    dataCoutsAnnuel.push(0);
                {% endif %}

                dataQteAnnuel.push("{{item.quantite}}");
            {% endfor %}

			var paramsYMensuel = [{
                title: {
                text: '',
                }
            }];

            var paramsYAnnuel = [{
                    title: {
                    text: '',
                }
            }];

            var paramsYSemestre = [{
                    title: {
                    text: '',
                }
            }];

            var paramsYTrimestre = [{
                    title: {
                    text: '',
                }
            }];


            var options = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['{{commodite.color}}', '#17418a'],
                series: [{
                    name: 'Quantité',
                    type: 'column',
                    data: dataQteMensuel
                }, {
                    name: 'Coût',
                    type: 'line',
                    data: dataCoutsMensuel
                }],
                stroke: {
                    width: [0, 3]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: ['Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre'],
                xaxis: {
                    type: 'string'
                },
                yaxis: paramsYMensuel,
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            }

            var chart = new ApexCharts(
                document.querySelector("#market-chart"),
                options
            );
            chart.render(); 

			var options1 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['{{commodite.color}}', '#17418a'],
                series: [{
                    name: 'Quantité',
                    type: 'column',
                    data: dataQteAnnuel
                }, {
                    name: 'Coût',
                    type: 'line',
                    data: dataCoutsAnnuel
                }],
                stroke: {
                    width: [0, 3]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: dataAnnees,
                xaxis: {
                    type: 'string'
                },
                yaxis:paramsYAnnuel,
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            }

            var chart1 = new ApexCharts(
                document.querySelector("#market-chart1"),
                options1
            );

            chart1.render(); 

            var options2 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['{{commodite.color}}', '#17418a'],
                series: [{
                    name: 'Quantité',
                    type: 'column',
                    data: dataQteTrimestre
                }, {
                    name: 'Coût',
                    type: 'line',
                    data: dataCoutTrimestre
                }],
                stroke: {
                    width: [0, 3]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: ['1er trimestre', '2è trimestre', '3è trimestre', '4è trimestre'],
                xaxis: {
                    type: 'string'
                },
                yaxis: paramsYTrimestre,
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            }

            var chart2 = new ApexCharts(
                document.querySelector("#market-chart2"),
                options2
            );

            chart2.render(); 

            var options3 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['{{commodite.color}}', '#17418a'],
                series: [{
                    name: 'Quantité',
                    type: 'column',
                    data: dataQteSemestre
                }, {
                    name: 'Coût',
                    type: 'line',
                    data: dataCoutSemestre
                }],
                stroke: {
                    width: [0, 3]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: ['1er Semestre', '2è Semestre'],
                xaxis: {
                    type: 'string'
                },
                yaxis: paramsYSemestre,
                tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            if(seriesIndex == 0) {
                                return value + " {{commodite.filiere.unite}}";
                            } else {
                                return value + " USD";
                            }
                        }
                    }
                }
            }

            var chart3 = new ApexCharts(
                document.querySelector("#market-chart3"),
                options3
            );

            chart3.render();
		}
	</script>
	
{% endblock %}