$.getScript("https://cdn.jsdelivr.net/npm/[email protected]/lib/jquery.tabletojson.min.js", function () {
    function download(data, filename, type) {
        var file = new Blob([data], {
            type: type
        });
        if (window.navigator.msSaveOrOpenBlob) // IE10+
            window.navigator.msSaveOrOpenBlob(file, filename);
        else { // Others
            var a = document.createElement("a"),
                url = URL.createObjectURL(file);
            a.href = url;
            a.download = filename;
            document.body.appendChild(a);
            a.click();
            setTimeout(function () {
                document.body.removeChild(a);
                window.URL.revokeObjectURL(url);
            }, 0);
        }
    }

    function sortMarkets(array) {
        return array.sort(function (a, b) {
            var la = a["language"];
            var lb = b["language"];

            var ca = a["country"];
            var cb = b["country"];


            if (la < lb) return -1;
            if (la > lb) return 1;
            if (ca < cb) return -1;
            if (ca > cb) return 1;
            return 0;
        });
    }

    $('th div').each(function () {
        var el = $(this).find("p:first");
        var text = el.text();

        if (!text.endsWith(" - ")) {
            el.text(text + " - ");
        }
    });

    var table = $('#MercedesMeintegrationstatus-CMScontentsetup').nextAll('div').find('table').tableToJSON({
        extractor: function (cellIndex, $cell) {
            var cls = $cell.attr('class');

            if (cls.includes("highlight") && cls.includes("green")) {
                return "YES";
            } else if (cls.includes("highlight")) {
                return "NO";
            }

            return $cell.text();
        }
    });

    var spas = {};
    $.each(table, function (i, row) {
        for (key in row) {
            var region = row["RD-Region"];
            var country = row["Country"];
            var language = row["Language"];

            if (key != "Nr" && key != "Domain" && key != "RD-Region" && key != "Country" && key != "Language") {
                if (!(key in spas)) {
                    spas[key] = {
                        markets: []
                    };
                }

                if (row[key] === "YES") {
                    if (language.indexOf(",") > -1) {
                        var langs = language.split(",");

                        for (var indice = 0; indice < langs.length; indice++) {
                            spas[key].markets.push({
                                "language": langs[indice].trim(),
                                "country": country,
                                "market": "DACH",
                                "region": region
                            });
                        }
                    } else {
                        spas[key].markets.push({
                            "language": language,
                            "country": country,
                            "market": "DACH",
                            "region": region
                        });
                    }
                }
            }
        }
    });

    var envs = {};
    for (var spa in spas) {
        var current = spas[spa];
        envs[spa] = {
            "ECE": [],
            "AMAP": [],
            "CN": []
        };

        for (var i = 0; i < current.markets.length; i++) {
            if (!envs[spa][current.markets[i].region].includes(current.markets[i].country)) {
                envs[spa][current.markets[i].region].push(current.markets[i].country);
                envs[spa][current.markets[i].region].sort();
            }
        }
    }

    var file = "";
    for (var spa in envs) {
        var current = envs[spa];
        file += spa + "\n";
        file += "AMAP:\n\t" + current["AMAP"].join(", ");
        file += "\nCN:\n\t" + current["CN"].join(", ");
        file += "\nECE:\n\t" + current["ECE"].join(", ");
        file += "\n\n";
    }

    download(file, "backend_envs.txt", "text/plain");
});