Module:Indicator datasets table - Revision history

Uschuetzenmeister at 20:41, 9 May 2024

2024-05-09T20:41:19Z

← Older revision		Revision as of 20:41, 9 May 2024
Line 54:		Line 54:
	-- Number or percent		-- Number or percent
	local entity = frame.args.entity		local entity = frame.args.entity
			-- local entity = mw.slots.slotContent('jsondata', 'Tasks/Test_Task').schemas['Task']['title']
	local suffix = ''		local suffix = ''
	if entity == 'percent' then		if entity == 'percent' then
	suffix = '%'		suffix = '%'
	end		end

Line 64:		Line 65:
	local html = mw.html.create()		local html = mw.html.create()
	local tableNode = html:tag('table'):addClass('wikitable sortable')		local tableNode = html:tag('table'):addClass('wikitable sortable')

			-- Check if the dataset contains sub-classes and sub-sub-classes
			local dataset = datasets[1] -- Check first dataset
			local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''
			local hasSubSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] ~= ''


	-- Erstelle die Tabelle mit Legenden aus dem ersten Datensatz		-- Erstelle die Tabelle mit Legenden aus dem ersten Datensatz
	local headerRow = tableNode:tag('tr')		local headerRow = tableNode:tag('tr')
	headerRow:tag('th'):wikitext('Class')		headerRow:tag('th'):wikitext('Class')
			if hasSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name']) end
			if hasSubSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name']) end
	for _, dataset in ipairs(datasets) do		for _, dataset in ipairs(datasets) do
	local formattedDate = formatDate(dataset.schemas.Dataset['date'])		local formattedDate = 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()):tag('div'):tag('small')
	end		end

Line 78:		Line 87:
	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']
	for i, subClassData in ipairs(classData['sub-classes']) do		for _, subClassData in ipairs(classData['sub-classes']) do
	local row = tableNode:tag('tr')		local subClass = subClassData['sub-class name']
	row:tag('td'):wikitext(class)		for _, subSubClassData in ipairs(subClassData['sub-sub-classes']) do
	for j, ~~subSubClassData~~ in ipairs(~~subClassData~~['~~sub-~~sub-classes']) do		local subSubClass = subSubClassData['sub-sub-class name']
	~~local value~~ = {}		local row = tableNode:tag('tr')
	for k, ~~dataset~~ in ipairs(~~datasets~~) do		row:tag('td'):wikitext(class)
	local val = tonumber(~~subSubClassData~~.value) or 0		if hasSubClasses then row:tag('td'):wikitext(subClass) end
	table.insert(value, val)		if hasSubSubClasses then row:tag('td'):wikitext(subSubClass) end
			for i, dataset in ipairs(datasets) do
	-- Berechne Summen und Anzahlen für jede Spalte		local value = {}
	columnSums[k] = columnSums[k] or 0		for _, currentClassData in ipairs(dataset.schemas.Dataset.classes) do
	columnCounts[k] = columnCounts[k] or 0		if currentClassData['class name'] == class then
	columnSums[k] = columnSums[k] + val		for _, currentSubClassData in ipairs(currentClassData['sub-classes']) do
	columnCounts[k] = columnCounts[k] + 1		if currentSubClassData['sub-class name'] == subClass then
			for _, currentSubSubClassData in ipairs(currentSubClassData['sub-sub-classes']) do
			if currentSubSubClassData['sub-sub-class name'] == subSubClass then
			local val = tonumber(currentSubSubClassData.value) or 0
			table.insert(value, val)

			-- Berechne Summen und Anzahlen für jede Spalte
			columnSums[i] = columnSums[i] or 0
			columnCounts[i] = columnCounts[i] or 0
			columnSums[i] = columnSums[i] + val
			columnCounts[i] = columnCounts[i] + 1
			end
			end
			end
			end
			end
			end
			row:tag('td'):wikitext(table.concat(value, ", ") .. suffix)
	end		end
	~~row:tag('td'):wikitext(table.concat(value, ", ") .. suffix)~~
	end		end
	end		end
Line 101:		Line 126:
	local totalRow = tableNode:tag('tr'):addClass('sortbottom')		local totalRow = tableNode:tag('tr'):addClass('sortbottom')
	totalRow:tag('th'):wikitext('Total')		totalRow:tag('th'):wikitext('Total')
			if hasSubClasses then totalRow:tag('th'):wikitext('') end
			if hasSubSubClasses then totalRow:tag('th'):wikitext('') end
	for i, dataset in ipairs(datasets) do		for i, dataset in ipairs(datasets) do
	local totalValue		local totalValue
	if columnCounts[i] and columnCounts[i] > 0 then		if columnCounts[i] and columnCounts[i] > 0 then
	if entity == 'percent' then		if entity == 'percent' then
	totalValue = columnSums[i] / columnCounts[i] -- Berechne Durchschnitt, falls Werte vorhanden sind		totalValue = columnSums[i] / columnCounts[i] -- Berechne Durchschnitt, falls Werte vorhanden sind
	else		else
	totalValue = columnSums[i]		totalValue = columnSums[i]
	end		end
	else		else

Uschuetzenmeister at 20:36, 9 May 2024

2024-05-09T20:36:36Z

@@ Line 1: / Line 1: @@
 function p.generateTable(frame)
      local datasets = p.getDatasets(frame)
@@ Line 70: / Line 117: @@
      return tostring(html)
 end

Uschuetzenmeister at 20:35, 9 May 2024

2024-05-09T20:35:59Z

Show changes

Uschuetzenmeister at 16:55, 8 May 2024

2024-05-08T16:55:39Z

← Older revision		Revision as of 16:55, 8 May 2024
Line 75:		Line 75:
	local headerRow = tableNode:tag('tr')		local headerRow = tableNode:tag('tr')
	headerRow:tag('th'):wikitext('Class')		headerRow:tag('th'):wikitext('Class')
	if hasSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['~~sub-sub-classes'][1]['sub-~~sub-class name']) end		if hasSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name']) end
	if hasSubSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name']) end		if hasSubSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name']) end
	for _, dataset in ipairs(datasets) do		for _, dataset in ipairs(datasets) do

Uschuetzenmeister at 16:54, 8 May 2024

2024-05-08T16:54:08Z

← Older revision		Revision as of 16:54, 8 May 2024
Line 75:		Line 75:
	local headerRow = tableNode:tag('tr')		local headerRow = tableNode:tag('tr')
	headerRow:tag('th'):wikitext('Class')		headerRow:tag('th'):wikitext('Class')
	if hasSubClasses then headerRow:tag('th'):wikitext('~~Sub~~-class') end		if hasSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name']) end
	if hasSubSubClasses then headerRow:tag('th'):wikitext('~~Sub~~-sub-classes') end		if hasSubSubClasses then headerRow:tag('th'):wikitext(dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name']) end
	for _, dataset in ipairs(datasets) do		for _, dataset in ipairs(datasets) do
	local formattedDate = formatDate(dataset.schemas.Dataset['date'])		local formattedDate = formatDate(dataset.schemas.Dataset['date'])

Uschuetzenmeister at 16:45, 8 May 2024

2024-05-08T16:45:05Z

Uschuetzenmeister at 16:40, 8 May 2024

2024-05-08T16:40:23Z

← Older revision		Revision as of 16:40, 8 May 2024
Line 69:		Line 69:
	local dataset = datasets[1] -- Check first dataset		local dataset = datasets[1] -- Check first dataset
	local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''		local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''
	local hasSubSubClasses = ~~hasSubClasses and~~ dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] ~~> 0~~		local hasSubSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] ~= ''

Uschuetzenmeister at 16:38, 8 May 2024

2024-05-08T16:38:37Z

← Older revision		Revision as of 16:38, 8 May 2024
Line 69:		Line 69:
	local dataset = datasets[1] -- Check first dataset		local dataset = datasets[1] -- Check first dataset
	local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''		local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''
	local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] > 0		local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'][1]['sub-sub-class name'] > 0

Uschuetzenmeister at 16:36, 8 May 2024

2024-05-08T16:36:34Z

← Older revision		Revision as of 16:36, 8 May 2024
Line 68:		Line 68:
	-- Check if the dataset contains sub-classes and sub-sub-classes		-- Check if the dataset contains sub-classes and sub-sub-classes
	local dataset = datasets[1] -- Check first dataset		local dataset = datasets[1] -- Check first dataset
	local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] and #dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] ~~> 0~~		local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-class name'] ~= ''
	local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] > 0		local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] > 0

Uschuetzenmeister at 16:30, 8 May 2024

2024-05-08T16:30:04Z

← Older revision		Revision as of 16:45, 8 May 2024
Line 76:		Line 76:
	headerRow:tag('th'):wikitext('Class')		headerRow:tag('th'):wikitext('Class')
	if hasSubClasses then headerRow:tag('th'):wikitext('Sub-class') end		if hasSubClasses then headerRow:tag('th'):wikitext('Sub-class') end
	headerRow:tag('th'):wikitext('Sub-sub-classes')		if hasSubSubClasses then headerRow:tag('th'):wikitext('Sub-sub-classes') end
	for _, dataset in ipairs(datasets) do		for _, dataset in ipairs(datasets) do
	local formattedDate = formatDate(dataset.schemas.Dataset['date'])		local formattedDate = formatDate(dataset.schemas.Dataset['date'])
Line 94:		Line 94:
	row:tag('td'):wikitext(class)		row:tag('td'):wikitext(class)
	if hasSubClasses then row:tag('td'):wikitext(subClass) end		if hasSubClasses then row:tag('td'):wikitext(subClass) end
	row:tag('td'):wikitext(subSubClass)		if hasSubSubClasses then row:tag('td'):wikitext(subSubClass) end
	for i, dataset in ipairs(datasets) do		for i, dataset in ipairs(datasets) do
	local value = {}		local value = {}
Line 127:		Line 127:
	totalRow:tag('th'):wikitext('Total')		totalRow:tag('th'):wikitext('Total')
	if hasSubClasses then totalRow:tag('th'):wikitext('') end		if hasSubClasses then totalRow:tag('th'):wikitext('') end
	totalRow:tag('th'):wikitext('')		if hasSubSubClasses then totalRow:tag('th'):wikitext('') end
	for i, dataset in ipairs(datasets) do		for i, dataset in ipairs(datasets) do
	local totalValue		local totalValue

← Older revision		Revision as of 16:30, 8 May 2024
Line 68:		Line 68:
	-- Check if the dataset contains sub-classes and sub-sub-classes		-- Check if the dataset contains sub-classes and sub-sub-classes
	local dataset = datasets[1] -- Check first dataset		local dataset = datasets[1] -- Check first dataset
	--local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] and #dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] > 0		local hasSubClasses = dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] and #dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] > 0
	~~if dataset.schemas.Dataset.classes[1]['sub-classes']['sub-class name'] ~= '' then local hasSubClasses = true end~~
	local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] > 0		local hasSubSubClasses = hasSubClasses and dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] and #dataset.schemas.Dataset.classes[1]['sub-classes'][1]['sub-sub-classes'] > 0

Line 76:		Line 75:
	local headerRow = tableNode:tag('tr')		local headerRow = tableNode:tag('tr')
	headerRow:tag('th'):wikitext('Class')		headerRow:tag('th'):wikitext('Class')
	if hasSubClasses ~~== true~~ then headerRow:tag('th'):wikitext('Sub-class') end		if hasSubClasses then headerRow:tag('th'):wikitext('Sub-class') end
	headerRow:tag('th'):wikitext('Sub-sub-classes')		headerRow:tag('th'):wikitext('Sub-sub-classes')
	for _, dataset in ipairs(datasets) do		for _, dataset in ipairs(datasets) do
Line 94:		Line 93:
	local row = tableNode:tag('tr')		local row = tableNode:tag('tr')
	row:tag('td'):wikitext(class)		row:tag('td'):wikitext(class)
	if hasSubClasses ~~== true~~ then row:tag('td'):wikitext(subClass) end		if hasSubClasses then row:tag('td'):wikitext(subClass) end
	row:tag('td'):wikitext(subSubClass)		row:tag('td'):wikitext(subSubClass)
	for i, dataset in ipairs(datasets) do		for i, dataset in ipairs(datasets) do
Line 127:		Line 126:
	local totalRow = tableNode:tag('tr'):addClass('sortbottom')		local totalRow = tableNode:tag('tr'):addClass('sortbottom')
	totalRow:tag('th'):wikitext('Total')		totalRow:tag('th'):wikitext('Total')
	if hasSubClasses ~~== true~~ then totalRow:tag('th'):wikitext('') end		if hasSubClasses then totalRow:tag('th'):wikitext('') end
	totalRow:tag('th'):wikitext('')		totalRow:tag('th'):wikitext('')
	for i, dataset in ipairs(datasets) do		for i, dataset in ipairs(datasets) do