Tiny File Manager

Back Back Up Advanced Editor

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Interrogation DB</title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-zoom@latest"></script>

async function estimation() 
        {
            try {
                const response = await fetch("read_estimation_001.php");
                const data = await response.json();
                console.log(data);

const nb_lignes = data.length;
				console.log(nb_lignes);
                                
                				
                let x = [];
                let y = [];

// Parcourez le tableau d'objets et extrayez les valeurs
                data.forEach(objet => {
                y.push(objet.index);
                x.push(objet.duration);
                });

// Affichez les résultats
                console.log("Tableau a (index) :", y);
                console.log("Tableau b (duration) :", x);

y.reverse();
				x.reverse();

// Affichez les résultats
                console.log("Tableau a (index) :", y);
                console.log("Tableau b (duration) :", x);
								
                // Ajoutez un 0 à la fin du tableau a
                y.push("0");

// Ajoutez un 0 au début du tableau b
                x.unshift("0");

// Affichez les résultats
                console.log("Tableau a (index) :", y);
                console.log("Tableau b (duration) :", x);

// Convertir les valeurs du tableau en nombres entiers
                x = x.map(Number);

// Parcourir le tableau à partir de l'indice 1 et effectuer l'addition
                for (let i = 1; i < x.length; i++) 
                {
                    x[i] = x[i] + x[i - 1];
                }
                y = y.map(Number);

// Afficher le résultat
				console.log("Tableau b après addition :", x);
				console.log("Tableau b après addition :", y);

//              const array = [6, 5, 4, 3, 2, 1, 0];
//              const commaSeparatedValues = array.join(', ');
//              console.log(commaSeparatedValues); // Affiche "6, 5, 4, 3, 2, 1, 0"

const separate_x = x.join(', ');
                console.log(separate_x);

const separate_y = y.join(', ');
                console.log(separate_y);

return { separate_x, separate_y };

} catch (error) {
                console.error("Erreur :", error);
                showMessageModal("Une erreur est survenue lors du chargement des données.");
            }
        }

async function wwwwwwwestimation() 
        {
            try {
                const response = await fetch("load.php");
                const data = await response.json();
                const nb_lignes = data.length;
                data.reverse();
                data.forEach(item => {
                    if (Array.isArray(item) && item.length > 1) {
                        item.splice(1, 1);
                    }
                });

let cumulativeData = [];
                let cumulativeSum = 0;

data.forEach(item => {
                    if (Array.isArray(item) && item.length > 0) {
                        cumulativeSum += parseInt(item[item.length - 1], 10);
                        cumulativeData.push([item[0], cumulativeSum]);
                    }
                });

let x1val = cumulativeData.map(item => item[1]);
                let y1val = cumulativeData.map(item => item[0]);

x1val.unshift(0);
                y1val.push(0);
				
				console.log(" ++++++++  x1val " + x1val);	
				console.log(" +++++++++ y1val " + y1val);

return { x1val, y1val };
            } catch (error) {
                console.error("Erreur :", error);
                showMessageModal("Une erreur est survenue lors du chargement des données.");
            }
        }

async function affiche_burndown() {
            const { x1val, y1val } = await estimation();

let data = await load_temps_effectif();
            let jsonData = [];

console.log(" TRACE " + data);

data.forEach((row, rowIndex) => {
                const cells = row.cells;
                const count = countValueOneInCells(cells);
                jsonData.push([rowIndex + 1, count]);
            });

console.log(" TRACE " + jsonData);

let countValues = jsonData.map(row => row[1]);
            countValues.reverse();
            jsonData.forEach((row, index) => {
                row[1] = countValues[index];
            });

let y2val = jsonData.map(row => row[0]);
            y2val.reverse();
            y2val.push(0);

let x2val_tmp = jsonData.map(row => row[1]);
            x2val_tmp.unshift(0);

let x2val = x2val_tmp.slice();
            for (let i = 2; i < x2val.length; i++) {
                x2val[i] = x2val[i] + x2val[i - 1];
            }

console.log(" ++++ " + x2val);
            console.log(" ++++ " + y2val);

console.log(" ++++ " + x1val);

//let xx1val = "0, 6, 37, 46, 57, 81, 98";

// let xx1val = "0, 6, 37, 46, 57, 81, 98";
           // let x1Array = xx1val.split(', ').map(Number); // Convertir la chaîne en tableau de nombres

// double(x1Array, x2val, y2val);
        }

if (context.dataIndex > 0) {
                                        xdeb = context.dataset.data[context.dataIndex - 1].x;
                                    }

let Xdiff = xfin - xdeb;
                                    return `Différence = ${Xdiff}`;
                                }
                            }
                        }
                    }
                }
            });
        }

//debug();
        affiche_burndown();
    </script>
</head>
<body>
    <div class="chart-container">
        <canvas id="myChart"></canvas>
    </div>
</body>
</html>