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

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

{% block content %}
	<div class="content-wrapper" style="margin-top:180px;">
		<div class="container-full">
			<div class="content-header">
				<div class="d-flex align-items-center">
					<div class="me-auto">
						<h3 class="page-title">Dashboard de droits</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">Droits</li>
								</ol>
							</nav>
						</div>
					</div>
				</div>
			</div>

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

						<div class="col-xl-6 col-12">
							<div class="box" id="statistique">
                                <div>
                                    <div>
                                        <div class="box-header">
                                            <h4 class="box-title">Réalisation mensuelle de droits {% if type is not null %}({{type.nom}}){% endif %} en {{dateAnnnee|date('Y')}} ({{devise}})</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>
                                    <div>
                                        <div class="box-header">
                                            <h4 class="box-title">Réalisation trimestrielle de droits {% if type is not null %}({{type.nom}}){% endif %} en {{dateAnnnee|date('Y')}} ({{devise}})</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>
                                    <div>
                                        <div class="box-header">
                                            <h4 class="box-title">Réalisation semestrielle de droits {% if type is not null %}({{type.nom}}){% endif %}
                                             en {{dateAnnnee|date('Y')}} ({{devise}})</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>
                                    <div>
                                        <div class="box-header">
                                            <h4 class="box-title">Evolution de droits {% if type is not null %}({{type.nom}}){% endif %} ({{devise}})</h4>
                                        </div>
                                        <div class="box-body">
                                            <div id="market-chart1"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
						</div>

                        <div class="col-xl-12 col-12 mix dotation sponsored all">
                            <div class="box">
                                <div class="box-body analytics-info">
                                    <h4 class="box-title">Réalisation de droits par type de droits
                                        en {{dateAnnnee|date('Y')}} ({{devise}})
                                    </h4>
                                    <div id="basic-pie" style="height:400px;"></div>
                                </div>
                            </div>
                        </div>

                        <div class="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 payeurs en {{dateAnnnee|date('Y')}} {% if type is not null %}({{type.nom}}){% endif %}</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">MONTANT PAYE EN {{devise}}</th>
                                                    <th class="bb-2 text-white">POURCENTAGE</th>
                                                </tr>
                                            </thead>
                                            <tbody id="search-results">
                                                {% set compter = 0 %}
                                                {% set total   = 0 %}

                                                {% for item in operateurs %}
                                                    {% set total   = total + item.montant %}
                                                {% endfor %}

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

                                                    <tr>
                                                        <td>{{ compter }}</td>
                                                        <td>{{ proprietaire_reel.operateur }}</td>
                                                        <td>{{ proprietaire_reel.montant}} {{devise}}</td>
                                                        <td>{{((proprietaire_reel.montant / total) * 100)|round(2, 'floor')}} %</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="staticBackdrop1" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
            <div class="modal-header bg-primar text-white">
                <h5 class="modal-title" id="staticBackdropLabel">Filtrage de données</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
                <form action="{{path('app_reporting_dashbord_droit')}}" method="POST">
                    <div class="modal-body">
                        <div class="form-group">
                            <label class="form-label"><strong>Type droit</strong></label>
                            <select class="form-control js-choice3" style="width: 100%;" name="type">
                                <option value="0">Tous</option>
                                {% for item in types %}
                                    <option value="{{item.id}}">{{item.nom}}</option>
                                {% endfor %}
                            </select>
                        </div>

                        <div class="mb-3">
                            <div class="form-group">
                                <label class="form-label"><strong>Année</strong></label>
                                <select class="form-control js-choice2" style="width: 100%;" name="annee">
                                    {% for item in 2016..2050 %}
                                        <option value="{{item}}">{{item}}</option>
                                    {% endfor %}
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="form-label"><strong>Devise</strong></label>
                            <select class="form-control js-choice1" style="width: 100%;" name="devise">
                                <option value="CDF">CDF</option>
                                <option value="USD">USD</option>
                            </select>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal"><i class="fa fa-close"></i> Fermer</button>
                        <button type="submit" class="btn text-white" style="background-color:#17418a;"><i class="fa fa-check"></i> Valider</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

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

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

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

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

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

            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("{{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("{{qteTrimeste1}}");
            dataQteTrimestre.push("{{qteTrimeste2}}");
            dataQteTrimestre.push("{{qteTrimeste3}}");
            dataQteTrimestre.push("{{qteTrimeste4}}");

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

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


            var options = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['#17418a'],
                series: [{
                    name: 'Montant',
                    type: 'column',
                    data: dataQteMensuel
                }],
                stroke: {
                    width: [0]
                },
                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: [{
                    title: {
                    text: '',
                    },

                }],tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            return value + " {{devise}}";
                        }
                    }
                }
            }

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

            chart.render(); 


            var options1 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['#17418a'],
                series: [{
                    name: 'Montant',
                    type: 'column',
                    data: dataQteAnnuel
                }],
                stroke: {
                    width: [0]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: dataAnnees,
                xaxis: {
                    type: 'string'
                },
                yaxis: [{
                    title: {
                    text: '',
                    },

                }],tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            return value + " {{devise}}";
                        }
                    }
                }
            }

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

            chart1.render(); 

            var options2 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['#17418a'],
                series: [{
                    name: 'Montant',
                    type: 'column',
                    data: dataQteTrimestre
                }],
                stroke: {
                    width: [0]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: ['1er trimestre', '2è trimestre', '3è trimestre', '4è trimestre'],
                xaxis: {
                    type: 'string'
                },
                yaxis: [{
                    title: {
                    text: '',
                    },

                }],tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            return value + " {{devise}}";
                        }
                    }
                }
            }

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

            chart2.render(); 

            var options3 = {
                chart: {
                    height: 330,
                    type: 'line',
                    zoom: {
                        enabled: false,
                    }
                },
                colors: ['#17418a'],
                series: [{
                    name: 'Montant',
                    type: 'column',
                    data: dataQteSemestre
                }],
                stroke: {
                    width: [0]
                },
                legend: {				
                    position: 'top',
                    horizontalAlign: 'left',
                },
                labels: ['1er Semestre', '2è Semestre'],
                xaxis: {
                    type: 'string'
                },
                yaxis: [{
                    title: {
                    text: '',
                    },

                }],tooltip: {
                    y: {
                        formatter: function(value, { series, seriesIndex, dataPointIndex, w }) {
                            return value + " {{devise}}";
                        }
                    }
                }
            }

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

            chart3.render();

            var natures        = [];
            var dataNature     = [];
            var colorsNature   = [];
            var compter        = 0;
            var colors         = ["#17418a", "#b52825", "#edb717", "#ee1044", "#278A2F", "#C98714" , '#276B8A', '#307868', '#553078', '#667830', '#783050'];

            {% for item in prodMensuelType %}
                dataNature.push({value: "{{item.montant}}", name: '{{item.type}}'});
                natures.push("{{item.type}}");

                if(compter < 12) {
					colorsNature.push(colors[compter]);
				} else {
					compter = 0;
					colorsNature.push(colors[compter]);
				}
				compter++;
            {% endfor %}


                var basicpieChart = echarts.init(document.getElementById('basic-pie'));
                var option = {
                // Add title
                    title: {
                        text: '',
                        subtext: '',
                        x: 'center'
                    },

                    // Add tooltip
                    tooltip: {
                        trigger: 'item',
                        formatter: "{a} <br/>{b}: {c} ({d}%)"
                    },

                    // Add legend
                    legend: {
                        orient: 'vertical',
                        x: 'left',
                        data: natures
                    },

                    // Add custom colors
                    color: colorsNature,

                    // Display toolbox
                    toolbox: {
                        show: true,
                        orient: 'vertical',
                        feature: {
                            mark: {
                                show: true,
                                title: {
                                    mark: 'Markline switch',
                                    markUndo: 'Undo markline',
                                    markClear: 'Clear markline'
                                }
                            },
                            dataView: {
                                show: true,
                                readOnly: false,
                                title: 'View data',
                                lang: ['View chart data', 'Close', 'Update']
                            },
                            magicType: {
                                show: true,
                                title: {
                                    pie: 'Switch to pies',
                                    funnel: 'Switch to funnel',
                                },
                                type: ['pie', 'funnel'],
                                option: {
                                    funnel: {
                                        x: '25%',
                                        y: '20%',
                                        width: '50%',
                                        height: '70%',
                                        funnelAlign: 'left',
                                        max: 1548
                                    }
                                }
                            },
                            restore: {
                                show: true,
                                title: 'Restore'
                            },
                            saveAsImage: {
                                show: true,
                                title: 'Same as image',
                                lang: ['Save']
                            }
                        }
                    },

                    // Enable drag recalculate
                    calculable: true,

                    // Add series
                    series: [{
                        name: 'Montant',
                        type: 'pie',
                        radius: '80%',
                        center: ['50%', '57.5%'],
                        data: dataNature
                    }]
            };
        
            basicpieChart.setOption(option);
        }
    </script>
{% endblock %}