Module:Transfers - Revision history

Couchor at 13:10, 23 December 2022

2022-12-23T13:10:31Z

← Older revision		Revision as of 13:10, 23 December 2022
Line 16:		Line 16:
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
	~~-- mw.logObject(results)~~
	if #results > 0 then		if #results > 0 then
	local tableContainer = mw.html.create('table')		local tableContainer = mw.html.create('table')
Line 39:		Line 39:
	-- local transfer = mw.html.create('div')		-- local transfer = mw.html.create('div')
	-- :addClass('transferItem')		-- :addClass('transferItem')



	local transfer = mw.html.create('tr')		local transfer = mw.html.create('tr')
Line 69:		Line 67:
	local fields = '_pageName, logoLight, logoDark, logoAll, start, end'		local fields = '_pageName, logoLight, logoDark, logoAll, start, end'
	local currentDate = os.date('%Y-%m-%d')		local currentDate = os.date('%Y-%m-%d')
			local companyName = mw.text.split(result._pageName, '/')[2] or ''
	local cargoArgs = {		local cargoArgs = {
	where = '(_pageName= "' .. result._pageName .. '") AND (start is NULL OR start < "' .. currentDate .. '") AND (end is NULL OR end > "' .. currentDate .. '")'		where = '(_pageName= "' .. result._pageName .. '" OR _pageName= "' .. companyName .. '") AND (start is NULL OR start < "' .. currentDate .. '") AND (end is NULL OR end > "' .. currentDate .. '")'
	}		}
	local logoResult = cargo.query(tables, fields, cargoArgs)		local logoResult = cargo.query(tables, fields, cargoArgs)
Line 78:		Line 77:
	oldTeamLogo:node(Transfers.createLogo(logoResult[1].logoAll))		oldTeamLogo:node(Transfers.createLogo(logoResult[1].logoAll))
	elseif logoResult[1].logoLight and logoResult[1].logoDark then		elseif logoResult[1].logoLight and logoResult[1].logoDark then
	oldTeamLogo:node(Transfers.createLogo(logoResult[1].logoLight, 'light')):node(Transfers.createLogo(~~results~~[1].logoDark, 'dark'))		oldTeamLogo:node(Transfers.createLogo(logoResult[1].logoLight, 'light')):node(Transfers.createLogo(logoResult[1].logoDark, 'dark'))
	else		else
	local logo = logoResult[1].logoLight or logoResult[1].logoDark		local logo = logoResult[1].logoLight or logoResult[1].logoDark
Line 98:		Line 97:

	transfer:node(oldTeam)		transfer:node(oldTeam)

	-- Show new teams logo, if exists		-- Show new teams logo, if exists
	local newTeam = mw.html.create('td')		local newTeam = mw.html.create('td')
	local newTeamDiv = mw.html.create('div'):addClass('d-flex')		local newTeamDiv = mw.html.create('div'):addClass('d-flex')
	newTeam:node(newTeamDiv)		newTeam:node(newTeamDiv)
			local newTeamLogo = mw.html.create('div')
	if result.leavedate then		if result.leavedate then
	if result.newteam then		if result.newteam then
Line 113:		Line 114:
	}		}
	local logoResult = cargo.query(tables, fields, cargoArgs)		local logoResult = cargo.query(tables, fields, cargoArgs)

	if #logoResult > 0 then		if #logoResult > 0 then
	if logoResult[1].logoAll then		if logoResult[1].logoAll then

Couchor at 11:24, 23 December 2022

2022-12-23T11:24:28Z

Show changes

Couchor at 10:11, 23 December 2022

2022-12-23T10:11:12Z

@@ Line 1: / Line 1: @@
 local getArgs = require('Module:Arguments').getArgs
 local cargo = mw.ext.cargo
@@ Line 9: / Line 10: @@
 	if args.game ~= nil then
 		local tables = 'Transfers'
-		local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag'
+		local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag, joinref, leaveref, joinrefname, leaverefname'
 		local cargoArgs = {
 			where = '_pageName LIKE "' .. args.game .. '%"',
@@ Line 15: / Line 16: @@
+		}
 		local results = cargo.query(tables, fields, cargoArgs)
-		mw.logObject(results)
+		-- mw.logObject(results)
 		if #results > 0 then
 			for r = 1, #results do
 				local result = results[r]
 				local transfer = mw.html.create('div')
-					:wikitext('[[' .. result.id .. ']]')
+					:addClass('transferItem')
 				parent:node(transfer)

Couchor: Created page with "local getArgs = require('Module:Arguments').getArgs local cargo = mw.ext.cargo local Transfers = {} function Transfers.main(frame) local args = getArgs(frame) local parent = mw.html.create('div') if args.game ~= nil then local tables = 'Transfers' local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag' local cargoArgs = { where = '_pageName LIKE "' .. args.game .. '%"', orderBy = 'joindate DESC, leavedate DESC' } local result..."

2022-12-13T01:19:54Z

Created page with "local getArgs = require('Module:Arguments').getArgs local cargo = mw.ext.cargo local Transfers = {} function Transfers.main(frame) local args = getArgs(frame) local parent = mw.html.create('div') if args.game ~= nil then local tables = 'Transfers' local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag' local cargoArgs = { where = '_pageName LIKE "' .. args.game .. '%"', orderBy = 'joindate DESC, leavedate DESC' } local result..."

New page

local getArgs = require('Module:Arguments').getArgs
local cargo = mw.ext.cargo

local Transfers = {}

function Transfers.main(frame)
local args = getArgs(frame)
local parent = mw.html.create('div')
if args.game ~= nil then
local tables = 'Transfers'
local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag'
local cargoArgs = {
where = '_pageName LIKE "' .. args.game .. '%"',
orderBy = 'joindate DESC, leavedate DESC'
}
local results = cargo.query(tables, fields, cargoArgs)
mw.logObject(results)
if #results > 0 then
for r = 1, #results do
local result = results[r]
local transfer = mw.html.create('div')
:wikitext('[[' .. result.id .. ']]')

parent:node(transfer)
end
end
else

end
return parent
end

return Transfers