function statDecNom() {
    $.ajax({
        type: 'POST',
        url: 'form.php',
        data: 'fonction=statsNomDec',
        success: function(results) {
            results = JSON.parse(results);
            if (results && results.length) {
                var arr = [];
                for (var i = 0; i < results.length; i++) {
                    var arr2 = results[i].split(" ");
                    for (var j = 0; j < arr2.length; j++) {
                        arr.push(arr2[j]);
                    }
                }

                var r = countOccurences(arr);
                bubbleSort(r[1], r[0]);
                r[1].reverse();
                r[0].reverse();
                r[1].length = 10;
                r[0].length = 10;
                r[2] = results.length;

                var options = {
                    chart: {
                        type: 'bar',
                    },
                    plotOptions: {
                        bar: {
                            dataLabels: {
                                position: 'top', // top, center, bottom
                            },
                        }
                    },
                    colors: ['#A9A9A9'],
                    dataLabels: {
                        enabled: true,
                        formatter: function(val, opt) {
                            return customFormatter(val, opt,
                                r[2]);
                        },
                        offsetY: -20,
                        style: {
                            fontSize: '12px',
                            colors: ["#304758"]
                        }
                    },
                    series: [{
                        name: 'Nombre de défunts',
                        data: r[1]
                    }],
                    xaxis: {
                        categories: r[0],
                        position: 'bottom',
                        labels: {
                            offsetY: 0,
                        },
                        axisBorder: {
                            show: false
                        },
                        axisTicks: {
                            show: false
                        }
                    },
                    title: {
                        text: 'Occurrences des noms de familles des défunts',
                        align: 'center',
                        floating: false,
                        style: {
                            color: '#444'
                        }
                    },
                }

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

                chart.render();
            }
        }
    });
}

function statDecGender() {

    $.ajax({
        type: "POST",
        url: 'form.php',
        data: 'fonction=statsGenreDec',
        success: function(results) {
            results = JSON.parse(results);
            if (results && results.length) {
                var arrLabel = [];
                var arrValue = [];
                arrLabel.push(results[1][0]);
                arrLabel.push(results[0][0]);
                arrValue.push(results[1][1]);
                arrValue.push(results[0][1]);
                var arr = [];
                arr.push(arrLabel);
                arr.push(arrValue);

                var options = {
                    chart: {
                        type: 'donut',
                        width: '80%'
                    },
                    plotOptions: {
                        pie: {
                            customScale: 1
                        }
                    },
                    series: arr[1],
                    colors: ['#27AAC8', '#FFB6C1'],
                    labels: arr[0],
                    title: {
                        text: 'Proportion de défunts homme et femme',
                        align: 'center',
                        floating: false,
                        style: {
                            color: '#444'
                        }
                    },
                    legend: {
                        position: 'bottom'
                    }
                }

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

                chart.render();
            }
        }
    });



}

function statDecPrenom(totalBap) {
    $.ajax({
        type: "POST",
        url: 'form.php',
        data: 'fonction=statsPreDec',
        success: function(results) {
            results = JSON.parse(results);
            if (results && results.length) {
                results = splitMaleFemale(results);

                var optionsM = {
                    chart: {
                        type: 'bar',
                    },
                    plotOptions: {
                        bar: {
                            dataLabels: {
                                position: 'top', // top, center, bottom
                            },
                        }
                    },
                    colors: ['#27AAC8'],
                    dataLabels: {
                        enabled: true,
                        formatter: function(val, opt) {
                            return customFormatter(val, opt,
                                results[2]);
                        },
                        offsetY: -20,
                        style: {
                            fontSize: '12px',
                            colors: ["#304758"]
                        }
                    },
                    series: [{
                        name: 'Nombre de défunts',
                        data: results[0][1]
                    }],
                    xaxis: {
                        categories: results[0][0],
                        position: 'bottom',
                        labels: {
                            offsetY: 0,
                        },
                        axisBorder: {
                            show: false
                        },
                        axisTicks: {
                            show: false
                        }
                    },
                    title: {
                        text: 'Occurrences des prénoms des défunts (composés ou non)',
                        align: 'center',
                        floating: false,
                        style: {
                            color: '#444'
                        }
                    },
                }

                var chartM = new ApexCharts(
                    document.querySelector("#dec_prenoms_m"),
                    optionsM
                );

                chartM.render();

                var optionsF = {
                    chart: {
                        type: 'bar',
                    },
                    plotOptions: {
                        bar: {
                            dataLabels: {
                                position: 'top', // top, center, bottom
                            },
                        }
                    },
                    colors: ['#FFB6C1'],
                    dataLabels: {
                        enabled: true,
                        formatter: function(val, opt) {
                            return customFormatter(val, opt,
                                results[3]);
                        },
                        offsetY: -20,
                        style: {
                            fontSize: '12px',
                            colors: ["#304758"]
                        }
                    },
                    series: [{
                        name: 'Nombre de défuntes',
                        data: results[1][1]
                    }],
                    xaxis: {
                        categories: results[1][0],
                        position: 'bottom',
                        labels: {
                            offsetY: 0,
                        },
                        axisBorder: {
                            show: false
                        },
                        axisTicks: {
                            show: false
                        }
                    },
                    title: {
                        text: 'Occurrences des prénoms des défuntes (composés ou non)',
                        align: 'center',
                        floating: false,
                        style: {
                            color: '#444'
                        }
                    },
                }

                var chartF = new ApexCharts(
                    document.querySelector("#dec_prenoms_f"),
                    optionsF
                );

                chartF.render();
            }
        }
    });
}

function statDecYear() {
    $.ajax({
        type: "POST",
        url: 'form.php',
        data: 'fonction=statsYearDec',
        success: function(results) {
            results = JSON.parse(results);
            if (results && results.length) {
                var arrYear = [];
                var arrNmbr = [];
                for (var i = 0; i < results.length; i++) {
                    if (parseInt(results[i][0]) >= 1772) {
                        arrYear.push(results[i][0]);
                        arrNmbr.push(results[i][1]);
                    }
                }

                var r = [];
                r.push(arrYear);
                r.push(arrNmbr);
				
                var options = {
                    chart: {
                        height: 350,
                        type: 'line',
                        zoom: {
                            enabled: false
                        }
                    },
					colors: ['#A9A9A9'],
                    dataLabels: {
                        enabled: false
                    },
                    stroke: {
                        curve: 'straight'
                    },
                    series: [{
                        name: "Nombre de défunts",
                        data: r[1]
                    }],
                    title: {
                        text: 'Nombre de défunts par années',
                        align: 'center'
                    },
                    grid: {
                        row: {
                            colors: ['#f3f3f3',
                            'transparent'], // takes an array which will be repeated on columns
                            opacity: 0.5
                        },
                    },
                    xaxis: {
                        categories: r[0],
						type: 'datetime'
                    },
					tooltip: {
						x: {
						  format: 'yyyy'
						}
					  }
                }

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

                chart.render();


            }
        }
    });
}


function statDecMonth() {
    $.ajax({
        type: "POST",
        url: 'form.php',
        data: 'fonction=statsMonthDec',
        success: function(results) {
            results = JSON.parse(results);
            if (results && results.length) {
				
				var arrMonth = [];
                var arrNmbr = [];
				var total = 0;
                for (var i = 0; i < results.length; i++) {
					arrMonth.push(results[i][0]);
					arrNmbr.push(results[i][1]);
					total += results[i][1];
                }

                var r = [];
                r.push(arrMonth);
                r.push(arrNmbr);
				r.push(total);
				
				var optionsM = {
                    chart: {
                        type: 'bar'
                    },
                    plotOptions: {
                        bar: {
                            dataLabels: {
                                position: 'top', // top, center, bottom
                            },
                        }
                    },
                    colors: ['#A9A9A9'],
                    dataLabels: {
                        enabled: true,
                        formatter: function(val, opt) {
                            return customFormatter(val, opt,
                                r[2]);
                        },
                        offsetY: -20,
                        style: {
                            fontSize: '12px',
                            colors: ["#304758"]
                        }
                    },
                    series: [{
                        name: 'Nombre de défunts',
                        data: r[1]
                    }],
                    xaxis: {
                        categories: month_txt,
                        position: 'bottom',
                        labels: {
                            offsetY: 0
                        },
                        axisBorder: {
                            show: false
                        },
                        axisTicks: {
                            show: false
                        }
                    },
                    title: {
                        text: 'Nombre de défunts par mois',
                        align: 'center',
                        floating: false,
                        style: {
                            color: '#444'
                        }
                    },
                }

                var chartM = new ApexCharts(
                    document.querySelector("#dec_month"),
                    optionsM
                );

                chartM.render();
            }
        }
    });
}