Module:Indicator datasets table
Documentation for this module may be created at Module:Indicator datasets table/doc
function p.generateTable(frame)
local datasets = p.getDatasets(frame)
if not datasets or #datasets == 0 then
return "No data" -- Keine Datensätze gefunden, gib leeren String zurück
end
-- Sortiere die Datensätze nach dem Datum
table.sort(datasets, function(a, b) return a.schemas.Dataset['date'] < b.schemas.Dataset['date'] end)
local html = mw.html.create()
-- Erstelle die erste Tabelle
local tableNode = html:tag('table'):addClass('wikitable sortable')
local headerRow = tableNode:tag('tr')
headerRow:tag('th'):wikitext('Class')
headerRow:tag('th'):wikitext('Sub-class')
for _, dataset in ipairs(datasets) do
local formattedDate = p.formatDate(dataset.schemas.Dataset['date'])
headerRow:tag('th'):wikitext(formattedDate):tag('div'):tag('small'):wikitext(mw.message.new('webmo-' .. dataset.schemas.Dataset['dataset type']):plain())
end
-- Füge die Datenzeilen hinzu
for _, classData in ipairs(datasets[1].schemas.Dataset.classes) do
local class = classData['class name']
for _, subClassData in ipairs(classData['sub-classes']) do
local subClass = subClassData['sub-class name']
local row = tableNode:tag('tr')
row:tag('td'):wikitext(class)
row:tag('td'):wikitext(subClass)
for i, dataset in ipairs(datasets) do
local value = {}
for _, currentClassData in ipairs(dataset.schemas.Dataset.classes) do
if currentClassData['class name'] == class then
for _, currentSubClassData in ipairs(currentClassData['sub-classes']) do
if currentSubClassData['sub-class name'] == subClass then
value[i] = {}
for _, currentSubSubClassData in ipairs(currentSubClassData['sub-sub-classes']) do
local val = tonumber(currentSubSubClassData.value) or 0
table.insert(value[i], val)
end
end
end
end
end
row:tag('td'):wikitext(table.concat(value[i] or {}, ", "))
end
end
end
-- Erstelle eine neue Tabelle für die Totalzeile
local totalTableNode = html:tag('table'):addClass('wikitable')
local totalRow = totalTableNode:tag('tr')
totalRow:tag('td'):wikitext('Total')
totalRow:tag('td'):wikitext('')
for i, dataset in ipairs(datasets) do
local totalValue
local entity = frame.args.entity
if columnCounts[i] and columnCounts[i] > 0 then
if entity == 'percent' then
totalValue = columnSums[i] / columnCounts[i] -- Berechne Durchschnitt, falls Werte vorhanden sind
else
totalValue = columnSums[i]
end
else
totalValue = 'N/A'
end
totalRow:tag('td'):wikitext(totalValue .. entity)
end
return tostring(html)
end