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

{% block title %}{{parent()}}-Emplois crées par les cahiers des charges{% 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="#">Obligations des entreprises</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="#">Les cahiers des charges</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">Emplois créés par les cahiers des charges</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;">
						📊 Emplois créés par les cahiers des charges
					</h1>
					<p class="text-muted-mine mb-0" style="font-size: 0.9rem">
						Les Statistiques sur les emplois créés par les cahiers des charges
					</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="{{path('app_emine_operateur_employe_projet_cahier_de_charge_tab')}}">
                        <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_operateur_employe_projet_cahier_de_charge_export')}}?annee={{dateAnnee|date('Y')}}&dot={{dot ? dot.id : 0}}">
						<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="dashboard-card mb-4">
				<div class="d-flex flex-column flex-md-row gap-3 p-3">
					<div class="d-flex gap-2 flex-wrap align-items-center">
						<a class="operators-status-chip btn" href="{{path('app_emine_operateur_projet_cahier_de_charge_index')}}">
							Projets programmés
						</a>

						<a class="operators-status-chip btn" href="{{path('app_emine_operateur_projet_cahier_de_charge_terminer')}}">
							Projets réalisés
						</a>

						<a class="operators-status-chip btn" href="{{path('app_emine_operateur_projet_cahier_de_charge_non_terminer')}}">
							Projets en cours
						</a>

						<a class="operators-status-chip btn" href="{{path('app_emine_operateur_projet_cahier_de_charge_non_executer')}}">
							Projets non réalisés
						</a>
					</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">Emplois par genre</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre d'emplois créés par genre en {{dateAnnee|date('Y')}}
                            {% if dot is not null %}
                                <br>
                                Cahier des charges: {{dot.nom}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart11"></div>
						</div>
					</div>
				</div>

                <div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Emplois par nationalité</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre d'emplois créés par nationalité en {{dateAnnee|date('Y')}}
                            {% if dot is not null %}
                                <br>
                                Cahier des charges: {{dot.nom}}
                            {% endif %}
						</p>
						<div>
							<div id="market-chart12"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="mb-4"></div>
			<div class="row g-4">
				<div class="col-lg-12">
					<div class="chart-container p-4">
						<h5 class="fw-semibold mb-1">Emplois par cahier des charges</h5>
						<p class="text-muted-mine mb-3" style='font-size: 0.75rem'>
							Nombre d'emplois créés par cahier des charges en {{dateAnnee|date('Y')}}
						</p>
						<div>
							<div id="market-chart13"></div>
						</div>
					</div>
				</div>
			</div>
            <div class="mb-4"></div>
            <div class="row g-4">
				<div class="col-lg-12">
					<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 d'emplois créés par cahier des charges
						</p>
						<div>
							<div id="market-chart139"></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 emplois
            </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_operateur_employe_projet_cahier_de_charge_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>
					    cahier des charges
					</label>
					<select
					id="filter-status"
					name="dot"
					class="form-select js-choice2">
                        <option value="0">Tous</option>
						{% for item in dots %}
							<option key="{{item.id}}" value="{{item.id}}">{{item.nom}}</option>
						{% endfor %}
					</select>
				</div>
			</div>

				<div class="filter-modal-footer">
					<a class="filter-btn-reset btn" href="{{path('app_emine_operateur_employe_projet_cahier_de_charge_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);

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

            var listeDot   = [];
            var annees     = [];
            var dataAnnee  = [];
            var emploiDot  = [];
            var emploiSexe = [];
            var emploiNat  = [];

            {% for item in emploiBySexe %}
                emploiSexe.push({
                    y: parseInt("{{item.nbre}}"), 
                    name: "{{item.sexe}}"
                });
            {% endfor %}

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

            {% for item in emploiByNat %}
                emploiNat.push({
                    y: parseInt("{{item.nbre}}"), 
                    name: "{{item.pays}}"
                });
            {% endfor %}

            Highcharts.chart('market-chart12', {
                chart: {
                    type: 'pie',
                    backgroundColor: '#f6f7fa',
                    zooming: {
                    type: 'xy'
                    },
                    panning: {
                    enabled: true,
                    type: 'xy'
                    },
                    panKey: 'shift'
                },
                title: {
                    text: ""
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    pie: {
                        showInLegend: true,
                        allowPointSelect: true,
                        showInLegend: true,
                        cursor: 'pointer',
                        dataLabels: [{
                            enabled: true,
                            distance: 20,
                        }, {
                            enabled: true,
                            distance: -40,
                            format: '{point.y}',
                            style: {
                                fontSize: '1.2em',
                                textOutline: 'none',
                                opacity: 0.7
                            },
                                filter: {
                                operator: '>',
                                property: 'percentage',
                                value: 10
                            }
                        }]
                    }
                },
                series: [
                    {
                        name: 'Nombre d\'emplois',
                        colorByPoint: true,
                        data: emploiNat
                    }
                ]
            });
            
            {% for item in emploiByDot %}
                listeDot.push("{{item.cahier}}");
                emploiDot.push(parseInt("{{item.nbre}}"));
            {% endfor %}

            Highcharts.chart('market-chart13', {
                chart: {
                    type: 'column',
                    backgroundColor: '#f6f7fa'
                },
                title: {
                    text: ""
                },
                xAxis: {
                    categories: listeDot,
                    crosshair: true,
                    accessibility: {
                    description: 'Countries'
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                    text: "Nombre d'emplois"
                    }
                },
                tooltip: {
                    valueSuffix: ''
                },
                plotOptions: {
                    column: {
                    pointPadding: 0.2,
                    borderWidth: 0
                    }
                },
                series: [
                    {
                        name: "Nombre d'emplois",
                        color: '#2caffe',
                        data: emploiDot
                    }
                ]
            });

            {% for item in evolution %}
                annees.push("{{item.annee}}");
                dataAnnee.push(parseInt("{{item.nbre}}"));
            {% endfor %}

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