Module:Sponsored teams - Revision history

Couchor at 23:09, 5 May 2023

2023-05-05T23:09:28Z

← Older revision		Revision as of 23:09, 5 May 2023
Line 40:		Line 40:
	:addClass('linkID')		:addClass('linkID')

	tables = '~~TeamImages~~'		tables = 'Logos'
	fields = '_pageName, iconLight, iconDark, iconAll'		fields = '_pageName, logoLight, logoDark, logoAll, iconLight, iconDark, iconAll'

	local pageNameSplit = mw.text.split(result._pageName,'/')[2] or ''		local pageNameSplit = mw.text.split(result._pageName,'/')[2] or ''

Couchor at 11:23, 28 September 2022

2022-09-28T11:23:19Z

← Older revision		Revision as of 11:23, 28 September 2022
Line 10:		Line 10:
	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors'		local tables = 'Sponsors'
	-- local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, TeamImages.iconLight=iconLight, TeamImages.iconDark=iconDark, TeamImages.iconAll=iconAll'
	local fields = '_pageName, start, end, startRef, startRefName, endRef, endRefName'		local fields = '_pageName, start, end, startRef, startRefName, endRef, endRefName'
	local currentDate = os.date('%Y-%m-%d')		local currentDate = os.date('%Y-%m-%d')

	local cargoArgs = {		local cargoArgs = {
	~~-- join = 'Sponsors._pageName = TeamImages._pageName',~~
	-- where = 'Sponsors.id ="' .. currentTitle .. '" AND (TeamImages._pageName=Sponsors._pageName or TeamImages._pageName=SUBSTRING_INDEX(Sponsors._pageName, "/", -1)) AND Sponsors.type="team" AND (Sponsors.end is NULL OR Sponsors.end < "' .. currentDate .. '")',
	where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end > "' .. currentDate .. '")',		where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end > "' .. currentDate .. '")',
	limit=10,		limit=10,

Couchor at 11:20, 28 September 2022

2022-09-28T11:20:12Z

← Older revision		Revision as of 11:20, 28 September 2022
Line 24:		Line 24:
	local list = mw.html.create('table')		local list = mw.html.create('table')
	:addClass('sortable striped-table')		:addClass('sortable striped-table')
	~~mw.logObject(results)~~
	if #results > 0 then		if #results > 0 then
	local titleRow = mw.html.create('tr')		local titleRow = mw.html.create('tr')
Line 45:		Line 45:
	tables = 'TeamImages'		tables = 'TeamImages'
	fields = '_pageName, iconLight, iconDark, iconAll'		fields = '_pageName, iconLight, iconDark, iconAll'
	~~mw.log('pagename')~~
	~~mw.log(result._pageName)~~
	local pageNameSplit = mw.text.split(result._pageName,'/')[2] or ''		local pageNameSplit = mw.text.split(result._pageName,'/')[2] or ''

Line 53:		Line 52:
	}		}
	local iconResult = cargo.query(tables, fields, cargoArgs)		local iconResult = cargo.query(tables, fields, cargoArgs)
	~~mw.log('ICONRESULT: ')~~
	~~mw.logObject(iconResult)~~
	~~mw.logObject(iconResult[1])~~

	if #iconResult > 0 then		if #iconResult > 0 then
	~~mw.log('SAIN SISSE')~~
	if iconResult[1].iconAll then		if iconResult[1].iconAll then
	~~mw.log('LOGO ALLLLL')~~		teamName:wikitext('<span class="team-icon">[[File:' .. iconResult[1].iconAll .. '\|20px]]</span>')
	teamName:wikitext('<span class="icon">[[File:' .. iconResult[1].iconAll .. '\|~~18px~~]]</span>')
	else		else
	~~mw.log('ELSEEEEEEEESLEEE')~~
	if iconResult[1].iconLight and iconResult[1].iconDark then		if iconResult[1].iconLight and iconResult[1].iconDark then
	~~mw.log('BOTH LOGOS')~~		teamName:wikitext('<span class="team-icon light">[[File:' .. iconResult[1].iconLight .. '\|18px]]</span>')
	teamName:wikitext('<span class="icon light">[[File:' .. iconResult[1].iconLight .. '\|18px]]</span>')		teamName:wikitext('<span class="team-icon dark-inline-flex">[[File:' .. iconResult[1].iconDark .. '\|18px]]</span>')
	teamName:wikitext('<span class="icon dark-inline">[[File:' .. iconResult[1].iconDark .. '\|18px]]</span>')
	elseif iconResult[1].iconLight or iconResult[1].iconDark then		elseif iconResult[1].iconLight or iconResult[1].iconDark then
	~~mw.log('EITHER LOGO')~~
	local file = iconResult[1].iconLight or iconResult[1].iconDark		local file = iconResult[1].iconLight or iconResult[1].iconDark
	teamName:wikitext('<span class="icon">[[File:' .. file .. '\|~~18px~~]]</span>')		teamName:wikitext('<span class="team-icon">[[File:' .. file .. '\|20px]]</span>')
	end		end
	end		end

Couchor at 07:27, 28 September 2022

2022-09-28T07:27:39Z

← Older revision		Revision as of 07:27, 28 September 2022
Line 9:		Line 9:

	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors~~, Teams~~'		local tables = 'Sponsors'
	local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, ~~Teams~~.~~image~~=~~icon~~'		-- local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, TeamImages.iconLight=iconLight, TeamImages.iconDark=iconDark, TeamImages.iconAll=iconAll'
			local fields = '_pageName, start, end, startRef, startRefName, endRef, endRefName'
	local currentDate = os.date('%Y-%m-%d')		local currentDate = os.date('%Y-%m-%d')

	local cargoArgs = {		local cargoArgs = {
	join = 'Sponsors._pageName = ~~Teams~~._pageName',		-- join = 'Sponsors._pageName = TeamImages._pageName',
	where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end < ' .. currentDate .. ')',		-- where = 'Sponsors.id ="' .. currentTitle .. '" AND (TeamImages._pageName=Sponsors._pageName or TeamImages._pageName=SUBSTRING_INDEX(Sponsors._pageName, "/", -1)) AND Sponsors.type="team" AND (Sponsors.end is NULL OR Sponsors.end < "' .. currentDate .. '")',
			where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end > "' .. currentDate .. '")',
	limit=10,		limit=10,
	orderBy='start'		orderBy='start'
Line 23:		Line 24:
	local list = mw.html.create('table')		local list = mw.html.create('table')
	:addClass('sortable striped-table')		:addClass('sortable striped-table')
			mw.logObject(results)
	if #results > 0 then		if #results > 0 then
	local titleRow = mw.html.create('tr')		local titleRow = mw.html.create('tr')
Line 41:		Line 42:
	local teamName = mw.html.create('td')		local teamName = mw.html.create('td')
	:addClass('linkID')		:addClass('linkID')
	if ~~result~~.icon then
	teamName:wikitext('<span class="icon">[[File:' .. ~~result~~.icon .. '\|18px]]</span>')		tables = 'TeamImages'
			fields = '_pageName, iconLight, iconDark, iconAll'
			mw.log('pagename')
			mw.log(result._pageName)
			local pageNameSplit = mw.text.split(result._pageName,'/')[2] or ''

			cargoArgs = {
			where = '(_pageName="' .. result._pageName .. '" OR _pageName ="' .. pageNameSplit.. '" ) AND (start is null or start < "' .. currentDate.. '") AND (end is NULL OR end > "' .. currentDate .. '")'
			}
			local iconResult = cargo.query(tables, fields, cargoArgs)
			mw.log('ICONRESULT: ')
			mw.logObject(iconResult)
			mw.logObject(iconResult[1])

			if #iconResult > 0 then
			mw.log('SAIN SISSE')
			if iconResult[1].iconAll then
			mw.log('LOGO ALLLLL')
			teamName:wikitext('<span class="icon">[[File:' .. iconResult[1].iconAll .. '\|18px]]</span>')
			else
			mw.log('ELSEEEEEEEESLEEE')
			if iconResult[1].iconLight and iconResult[1].iconDark then
			mw.log('BOTH LOGOS')
			teamName:wikitext('<span class="icon light">[[File:' .. iconResult[1].iconLight .. '\|18px]]</span>')
			teamName:wikitext('<span class="icon dark-inline">[[File:' .. iconResult[1].iconDark .. '\|18px]]</span>')
			elseif iconResult[1].iconLight or iconResult[1].iconDark then
			mw.log('EITHER LOGO')
			local file = iconResult[1].iconLight or iconResult[1].iconDark
			teamName:wikitext('<span class="icon">[[File:' .. file .. '\|18px]]</span>')
			end
			end
	end		end
	teamName:wikitext('[[' .. result._pageName .. ']]')		teamName:wikitext('[[' .. result._pageName .. ']]')
	if result.startRef then		if result.startRef then
	local startRefName = result.startRefName or ''		local startRefName = result.startRefName or ''

Couchor at 11:33, 27 September 2022

2022-09-27T11:33:39Z

← Older revision		Revision as of 11:33, 27 September 2022
Line 13:		Line 13:

	local currentDate = os.date('%Y-%m-%d')		local currentDate = os.date('%Y-%m-%d')
	~~mw.log(currentDate)~~
	local cargoArgs = {		local cargoArgs = {
	join = 'Sponsors._pageName = Teams._pageName',		join = 'Sponsors._pageName = Teams._pageName',

Couchor at 11:15, 27 September 2022

2022-09-27T11:15:58Z

← Older revision		Revision as of 11:15, 27 September 2022
Line 12:		Line 12:
	local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, Teams.image=icon'		local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, Teams.image=icon'

	local currentDate = os.date('%Y-%m-%d')~~, os~~.~~time~~()		local currentDate = os.date('%Y-%m-%d')
			mw.log(currentDate)
	local cargoArgs = {		local cargoArgs = {
	join = 'Sponsors._pageName = Teams._pageName',		join = 'Sponsors._pageName = Teams._pageName',

Couchor at 22:58, 26 September 2022

2022-09-26T22:58:00Z

← Older revision		Revision as of 22:58, 26 September 2022
Line 9:		Line 9:

	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors'		local tables = 'Sponsors, Teams'
	local fields = '_pageName, start, end, startRef, startRefName, endRef, endRefName'		local fields = 'Sponsors._pageName=_pageName, Sponsors.start=start, Sponsors.end=end, Sponsors.startRef=startRef, Sponsors.startRefName=startRefName, Sponsors.endRef=endRef, Sponsors.endRefName=endRefName, Teams.image=icon'

	local currentDate = os.date('%Y-%m-%d'), os.time()		local currentDate = os.date('%Y-%m-%d'), os.time()
	local cargoArgs = {		local cargoArgs = {
			join = 'Sponsors._pageName = Teams._pageName',
	where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end < ' .. currentDate .. ')',		where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end < ' .. currentDate .. ')',
	limit=10,		limit=10,
Line 18:		Line 20:
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
	local ul = mw.html.create('ul')		local list = mw.html.create('table')
			:addClass('sortable striped-table')

	if #results > 0 then		if #results > 0 then
			local titleRow = mw.html.create('tr')
			:addClass('headerRow')
			local nameCell = mw.html.create('th')
			:wikitext('Team')
			local startCell = mw.html.create('th')
			:wikitext('Sponsored since')
			local endCell = mw.html.create('th')
			:wikitext('Sponsored until')
			list:node(titleRow:node(nameCell):node(startCell):node(endCell))
	for r = 1, #results do		for r = 1, #results do
	local result = results[r]		local result = results[r]
	local li = mw.html.create('li')
	:wikitext('[[' .. result._pageName .. ']]')		local teamRow = mw.html.create('tr')
			:addClass('bodyRow')
			local teamName = mw.html.create('td')
			:addClass('linkID')
			if result.icon then
			teamName:wikitext('<span class="icon">[[File:' .. result.icon .. '\|18px]]</span>')
			end
			teamName:wikitext('[[' .. result._pageName .. ']]')
	if result.startRef then		if result.startRef then
	local startRefName = result.startRefName or ''		local startRefName = result.startRefName or ''
	li:wikitext(frame:preprocess('<ref name='.. startRefName .. '>' ..result.startRef .. '</ref>'))		teamName:wikitext(frame:preprocess('<ref name='.. startRefName .. '>' ..result.startRef .. '</ref>'))
	end		end

	ul:node(li)		local startDate = mw.html.create('td')
			:addClass('tc')
			:wikitext(result.start)
			local endDate = mw.html.create('td')
			:addClass('tc')
			:wikitext(result['end'])

			list:node(teamRow:node(teamName):node(startDate):node(endDate))
	end		end
	else		else
Line 35:		Line 62:
	end		end

	return container:node(ul)		return container:node(list)
	end		end

	return Sponsored		return Sponsored

Couchor at 18:19, 23 September 2022

2022-09-23T18:19:11Z

← Older revision		Revision as of 18:19, 23 September 2022
Line 10:		Line 10:
	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors'		local tables = 'Sponsors'
	local fields = '_pageName, start, end'		local fields = '_pageName, start, end, startRef, startRefName, endRef, endRefName'
			local currentDate = os.date('%Y-%m-%d'), os.time()
	local cargoArgs = {		local cargoArgs = {
	where = '~~Sponsors.~~id ="' .. currentTitle .. '" AND ~~Sponsors.~~type="team"',		where = 'id ="' .. currentTitle .. '" AND type="team" AND (end is NULL OR end < ' .. currentDate .. ')',
	limit=10,		limit=10,
	orderBy='~~Sponsors.~~start'		orderBy='start'
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
Line 21:		Line 21:
	if #results > 0 then		if #results > 0 then
	for r = 1, #results do		for r = 1, #results do
			local result = results[r]
	local li = mw.html.create('li')		local li = mw.html.create('li')
	:wikitext('[[' .. ~~results[r]~~._pageName .. ']]')		:wikitext('[[' .. result._pageName .. ']]')
			if result.startRef then
			local startRefName = result.startRefName or ''
			li:wikitext(frame:preprocess('<ref name='.. startRefName .. '>' ..result.startRef .. '</ref>'))
			end

	ul:node(li)		ul:node(li)
	end		end

Couchor at 14:51, 23 September 2022

2022-09-23T14:51:39Z

← Older revision		Revision as of 14:51, 23 September 2022
Line 9:		Line 9:

	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors~~, Teams~~'		local tables = 'Sponsors'
	local fields = '~~Sponsors.~~_pageName~~=sponsorPage~~, ~~Teams._pageName=teamPage~~, ~~Teams.org=org~~'		local fields = '_pageName, start, end'

	local cargoArgs = {		local cargoArgs = {
	~~join = 'Sponsors._pageName=Teams.org',~~		where = 'Sponsors.id ="' .. currentTitle .. '" AND Sponsors.type="team"',
	where = 'Sponsors.id= "' ..currentTitle .. '"',
	limit=10,		limit=10,
	orderBy='Sponsors.start'		orderBy='Sponsors.start'
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
	~~mw.logObject(results)~~
	local ul = mw.html.create('ul')		local ul = mw.html.create('ul')
	if #results > 0 then		if #results > 0 then
	for r = 1, #results do		for r = 1, #results do
	~~mw.log(results[r].org == nil and #mw.text.split(results[r].sponsorPage, '/'))~~		local li = mw.html.create('li')
	~~if ( results[r].org or ( results[r].org == nil and #mw.text.split(results[r].sponsorPage, '/') ~= 1)) then~~		:wikitext('[[' .. results[r]._pageName .. ']]')
	~~mw.log(results[r])~~		ul:node(li)
	~~mw.logObject(results[r])~~

	~~local result = results[r]~~
	~~mw.log(result.sponsorPage)~~
	~~mw.log(type(result.sponsorPage))~~
	~~mw.logObject(result.sponsorPage)~~
	local li = mw.html.create('li')
	:wikitext('[[' .. ~~result~~.~~sponsorPage~~ .. ']]')
	ul:node(li)
	~~end~~
	end		end
	else		else
	return nil		return nil
	end		end
	~~mw.log(ul)~~
	~~mw.logObject(ul)~~

	return container:node(ul)		return container:node(ul)

Couchor at 18:42, 22 September 2022

2022-09-22T18:42:15Z

← Older revision		Revision as of 18:42, 22 September 2022
Line 7:		Line 7:
	:addClass('sponsored')		:addClass('sponsored')
	local currentTitle = mw.title.getCurrentTitle().text		local currentTitle = mw.title.getCurrentTitle().text

	-- Look up Cargo table teams with current page as sponsor		-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors, Teams'		local tables = 'Sponsors, Teams'
	local fields = 'Sponsors._pageName'		local fields = 'Sponsors._pageName=sponsorPage, Teams._pageName=teamPage, Teams.org=org'

	local cargoArgs = {		local cargoArgs = {
	join = '~~Sponsors._pageName=Teams._pageName,~~ Sponsors._pageName=Teams.org',		join = 'Sponsors._pageName=Teams.org',
	where = 'Sponsors.id~~= "' ..currentTitle .. '" OR Teams.org~~="' .. currentTitle .. '"',		where = 'Sponsors.id= "' ..currentTitle .. '"',
	limit=10,		limit=10,
	orderBy='Sponsors.start'		orderBy='Sponsors.start'
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
			mw.logObject(results)
			local ul = mw.html.create('ul')
	if #results > 0 then		if #results > 0 then
	~~local ul = mw.html.create('ul')~~
	for r = 1, #results do		for r = 1, #results do
	mw.log(results[r])		mw.log(results[r].org == nil and #mw.text.split(results[r].sponsorPage, '/'))
	mw.logObject(results[r])		if ( results[r].org or ( results[r].org == nil and #mw.text.split(results[r].sponsorPage, '/') ~= 1)) then
	local result = results[r]		mw.log(results[r])
	local li = mw.html.create('li')		mw.logObject(results[r])
	:wikitext('[[' .. result.~~_pageName~~ .. ']]')
	ul:node(li)		local result = results[r]
			mw.log(result.sponsorPage)
			mw.log(type(result.sponsorPage))
			mw.logObject(result.sponsorPage)
			local li = mw.html.create('li')
			:wikitext('[[' .. result.sponsorPage .. ']]')
			ul:node(li)
			end
	end		end
	else		else
	return nil		return nil
	end		end
			mw.log(ul)
			mw.logObject(ul)

	return container:node(ul)		return container:node(ul)