Rollenmanagement der Mitarbeiter

//Create the array
let originalArray= [],cleanedData = []; 
//Fetch the data from the API, convert them to json and store the users into "originalArray"
await fetch("/api/allianceinfo").then(res =>res.json()).then(res => originalArray=res.users);
//Run over each entry in orginalData and check if there are any user.roles entries. If not push "[user.name, "no roles"]". If the user has roles they are seperated by comma.
originalArray.forEach(user => {
    if(user.roles.length >0){
        cleanedData.push([user.name, user.roles.toString()])
    }
    else {
        cleanedData.push([user.name, "no role"])
    }
});
console.table(cleanedData);

/** Convert a 2D array into a CSV string
 * Stolen from: https://stackoverflow.com/questions/14964035/how-to-export-javascript-array-info-to-csv-on-client-side/68146412#68146412
 */
function arrayToCsv(data){
  return data.map(row =>
    row
    .map(String)  // convert every value to String
    .map(v => v.replaceAll('"', '""'))  // escape double quotes
    .map(v => `"${v}"`)  // quote it
    .join(',')  // comma-separated
  ).join('\r\n');  // rows starting on new lines
}

//Create the array
let originalArray= [],cleanedData = []; 
//Fetch the data from the API, convert them to json and store the users into "originalArray"
await fetch("/api/allianceinfo").then(res =>res.json()).then(res => originalArray=res.users);
//Run over each entry in orginalData and check if there are any user.roles entries. If not push "[user.name, "no roles"]". If the user has roles they are seperated by comma.
originalArray.forEach(user => {
    if(user.roles.length >0){
        cleanedData.push([user.name, user.roles.toString()])
    }
    else {
        cleanedData.push([user.name, "no role"])
    }
});
arrayToCsv(cleanedData)

// Funktion zum Herunterladen der CSV-Datei
function downloadCsv(data, filename) {
    const csvData = new Blob([data], { type: 'text/csv' });
    const csvUrl = URL.createObjectURL(csvData);
    const hiddenElement = document.createElement('a');
    hiddenElement.href = csvUrl;
    hiddenElement.target = '_blank';
    hiddenElement.download = filename;
    hiddenElement.click();
}

// Funktion zum Konvertieren eines 2D-Arrays in eine CSV-Zeichenkette
function arrayToCsv(data) {
    return data.map(row =>
        `"${row.join('","')}"`
    ).join('\r\n');
}

// Fetch-Daten und Erstellen des Arrays mit den Daten
let originalArray = [];
fetch("/api/allianceinfo")
    .then(res => res.json())
    .then(res => {
        originalArray = res.users.map(user => [
            user.name,
            user.role_flags.owner,
            user.role_flags.admin,
            user.role_flags.coadmin,
            user.role_flags.schooling,
            user.role_flags.finance,
            user.role_flags.staff,
            user.role_flags.transport_requests,
            user.role_flags.view_logs,
            user.id
        ]);

        // Spaltenüberschriften hinzufügen
        originalArray.unshift([
            "Name",
            "Owner",
            "Admin",
            "Coadmin",
            "Schooling",
            "Finance",
            "Staff",
            "Transport Requests",
            "View Logs",
            "ID"
        ]);

        // CSV-Datei erstellen
        const csvContent = arrayToCsv(originalArray);

        // CSV-Datei herunterladen
        downloadCsv(csvContent, 'user_roles.csv');
    });