Module:Indicator datasets table: Difference between revisions
Jump to navigation
Jump to search
No edit summary Tag: Reverted |
No edit summary Tag: Reverted |
||
Line 49: | Line 49: | ||
headerRow:tag('th'):wikitext('Class') | headerRow:tag('th'):wikitext('Class') | ||
headerRow:tag('th'):wikitext('Sub-class') | headerRow:tag('th'):wikitext('Sub-class') | ||
for | local columnValues = {} -- Eine Tabelle, um die Werte für jede Spalte zu sammeln | ||
for i, dataset in ipairs(datasets) do | |||
local formattedDate = p.formatDate(dataset.schemas.Dataset['date']) | 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()) | headerRow:tag('th'):wikitext(formattedDate):tag('div'):tag('small'):wikitext(mw.message.new('webmo-' .. dataset.schemas.Dataset['dataset type']):plain()) | ||
columnValues[i] = {} -- Initialisiere die Tabelle für die aktuellen Spalte | |||
end | end | ||
-- Sammle die Werte für jede Spalte | |||
-- | |||
for _, classData in ipairs(datasets[1].schemas.Dataset.classes) do | for _, classData in ipairs(datasets[1].schemas.Dataset.classes) do | ||
local class = classData['class name'] | local class = classData['class name'] | ||
Line 70: | Line 70: | ||
for _, currentSubClassData in ipairs(currentClassData['sub-classes']) do | for _, currentSubClassData in ipairs(currentClassData['sub-classes']) do | ||
if currentSubClassData['sub-class name'] == subClass then | if currentSubClassData['sub-class name'] == subClass then | ||
for _, currentSubSubClassData in ipairs(currentSubClassData['sub-sub-classes']) do | for _, currentSubSubClassData in ipairs(currentSubClassData['sub-sub-classes']) do | ||
local val = tonumber(currentSubSubClassData.value) or 0 | local val = tonumber(currentSubSubClassData.value) or 0 | ||
table.insert( | table.insert(columnValues[i], val) -- Füge den Wert der Spalte hinzu | ||
end | end | ||
end | end | ||
Line 79: | Line 78: | ||
end | end | ||
end | end | ||
row:tag('td'):wikitext(table.concat(value | row:tag('td'):wikitext(table.concat(value or {}, ", ")) -- Füge den Wert in die Tabelle ein | ||
end | end | ||
end | end | ||
end | end | ||
-- | -- Berechne die Summen bzw. Durchschnitte für jede Spalte und füge die Totalzeile hinzu | ||
local totalRow = tableNode:tag('tr') | local totalRow = tableNode:tag('tr') | ||
totalRow:tag('td'):wikitext('Total') | totalRow:tag('td'):wikitext('Total') | ||
totalRow:tag('td'):wikitext('') | totalRow:tag('td'):wikitext('') | ||
for i, | for i, values in ipairs(columnValues) do | ||
local totalValue | local totalValue | ||
local dataType = | local dataType = datasets[i].schemas.Dataset.entry | ||
if dataType == "number" then | |||
-- Berechne die Summe | |||
totalValue = 0 | |||
totalValue = | for _, val in ipairs(values) do | ||
elseif dataType == "percent" then | totalValue = totalValue + val | ||
end | |||
elseif dataType == "percent" then | |||
-- Berechne den Durchschnitt | |||
local sum = 0 | |||
for _, val in ipairs(values) do | |||
sum = sum + val | |||
end | end | ||
totalValue = #values > 0 and sum / #values or 'N/A' | |||
totalValue = 'N/A' | |||
end | end | ||
totalRow:tag('td'):wikitext(totalValue) | totalRow:tag('td'):wikitext(totalValue) |
Revision as of 09:54, 8 May 2024
Documentation for this module may be created at Module:Indicator datasets table/doc
local p = {}
function p.getDatasets(frame)
local articleids = frame.args.articleids
if not articleids or articleids == '' then
return {}
end
-- Entferne alle Kommas und Leerzeichen am Ende von articleids
articleids = mw.ustring.gsub(articleids, '[,%s]*$', '')
local ids = mw.text.split(articleids, ",")
local datasets = {}
local titleobject
for _, id in ipairs(ids) do
titleobject = mw.title.new(tonumber(id))
local existspage = titleobject.exists
if existspage then
local content = titleobject:getContent()
local dataset = mw.text.jsonDecode(content)
-- Überprüfe, ob belongs to der aktuellen PageID entspricht
if tonumber(dataset.schemas.Dataset['belongs to']) == mw.title.getCurrentTitle().id then
table.insert(datasets, dataset)
end
else
return "Error: Page not found for ID " .. id
end
end
return datasets
end
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()
local tableNode = html:tag('table'):addClass('wikitable sortable')
-- Erstelle die Tabelle mit Legenden aus dem ersten Datensatz
local headerRow = tableNode:tag('tr')
headerRow:tag('th'):wikitext('Class')
headerRow:tag('th'):wikitext('Sub-class')
local columnValues = {} -- Eine Tabelle, um die Werte für jede Spalte zu sammeln
for i, 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())
columnValues[i] = {} -- Initialisiere die Tabelle für die aktuellen Spalte
end
-- Sammle die Werte für jede Spalte
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
for _, currentSubSubClassData in ipairs(currentSubClassData['sub-sub-classes']) do
local val = tonumber(currentSubSubClassData.value) or 0
table.insert(columnValues[i], val) -- Füge den Wert der Spalte hinzu
end
end
end
end
end
row:tag('td'):wikitext(table.concat(value or {}, ", ")) -- Füge den Wert in die Tabelle ein
end
end
end
-- Berechne die Summen bzw. Durchschnitte für jede Spalte und füge die Totalzeile hinzu
local totalRow = tableNode:tag('tr')
totalRow:tag('td'):wikitext('Total')
totalRow:tag('td'):wikitext('')
for i, values in ipairs(columnValues) do
local totalValue
local dataType = datasets[i].schemas.Dataset.entry
if dataType == "number" then
-- Berechne die Summe
totalValue = 0
for _, val in ipairs(values) do
totalValue = totalValue + val
end
elseif dataType == "percent" then
-- Berechne den Durchschnitt
local sum = 0
for _, val in ipairs(values) do
sum = sum + val
end
totalValue = #values > 0 and sum / #values or 'N/A'
end
totalRow:tag('td'):wikitext(totalValue)
end
return tostring(html)
end
-- Funktion zur Formatierung des Datums gemäß den Nutzereinstellungen
function p.formatDate(date)
return mw.language.getContentLanguage():formatDate(date)
end
return p