Module:Game/Transfers - Revision history

Couchor at 21:45, 12 February 2024

2024-02-12T21:45:34Z

← Older revision		Revision as of 21:45, 12 February 2024
Line 8:		Line 8:
	local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]		local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]
	local tables = 'Transfers'		local tables = 'Transfers'
	local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, date'		local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, maxdate=date'
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = '~~date~~ DESC, _pageName ASC',		orderBy = 'maxdate DESC, _pageName ASC',
	limit = 50		limit = 50
	}		}

Couchor at 10:31, 16 November 2023

2023-11-16T10:31:29Z

← Older revision		Revision as of 10:31, 16 November 2023
Line 31:		Line 31:
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]
			-- Prevent duplicate if joined a new team on same date as they left the previous one
	if not tableContains(prevTransfers, result.id, result.date) then		if not tableContains(prevTransfers, result.id, result.date) then
	table.insert(prevTransfers, {id = result.id, date = result.date})		table.insert(prevTransfers, {id = result.id, date = result.date})

Couchor at 10:27, 16 November 2023

2023-11-16T10:27:39Z

← Older revision		Revision as of 10:27, 16 November 2023
Line 11:		Line 11:
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = 'date DESC, _pageName ASC~~, leavedate DESC~~',		orderBy = 'date DESC, _pageName ASC',
	limit = 50		limit = 50
	}		}

Couchor at 10:26, 16 November 2023

2023-11-16T10:26:57Z

← Older revision		Revision as of 10:26, 16 November 2023
Line 8:		Line 8:
	local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]		local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]
	local tables = 'Transfers'		local tables = 'Transfers'
	local fields = '_pageName, id, flag, joindate, leavedate, inactivedate'		local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, date'
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = '~~leavedate~~ DESC, ~~joindate~~ DESC',		orderBy = 'date DESC, _pageName ASC, leavedate DESC',
	limit = 50		limit = 50
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
			local prevTransfers = {}

	local container = mw.html.create('div')		local container = mw.html.create('div')
	if #results > 0 then		if #results > 0 then
Line 30:		Line 31:
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]
			if not tableContains(prevTransfers, result.id, result.date) then
			table.insert(prevTransfers, {id = result.id, date = result.date})
	local year, month, day = result.joindate:match("(%d+)-(%d+)-(%d+)")		local year, month, day = result.joindate:match("(%d+)-(%d+)-(%d+)")
	local monthName = monthNames[tonumber(month)]		local monthName = monthNames[tonumber(month)]
Line 67:		Line 70:
	tables = 'Transfers'		tables = 'Transfers'
	fields = '_pageName, id, flag, joindate, leavedate, inactivedate'		fields = '_pageName, id, flag, joindate, leavedate, inactivedate'

	cargoArgs = {		cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. result.leavedate.. '"',		where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. result.leavedate.. '"',
Line 95:		Line 99:
	to:node(getTeamLogo(result._pageName, game, size))		to:node(getTeamLogo(result._pageName, game, size))
	end		end

	end		end
	transfer:node(transferDate):node(player):node(from):node(to)		transfer:node(transferDate):node(player):node(from):node(to)

	transfersContainer:node(transfer)		transfersContainer:node(transfer)
			end
	end		end
	return transfersWrapper		return transfersWrapper
Line 107:		Line 111:
	end		end

	function ~~p.createLogo~~(~~url~~, ~~teamPage~~, ~~class~~, ~~game, size~~)		function tableContains(tbl, targetId, targetDate)
	~~size~~ = ~~size or '20px'~~		for _, transfer in ipairs(tbl) do
	~~local className~~ = ~~class~~ and ~~class .~~. ~~' h-100' or 'h-100'~~		if transfer.id == targetId and transfer.date == targetDate then
	~~local logoURL~~ = ~~url and url or 'Team_placeholder_' .. class .. '.png'~~		return true -- The table with the specified id and date exists
	~~local logoContainer~~ = ~~mw.html.create('div'):addClass(className)~~		end
	~~local logo = mw.html.create('div')~~		end
	~~:addClass('team~~-~~list~~-~~logo')~~		return false -- The table with the specified id and date does not exist
	~~:node('[[File:' .. logoURL .. '\|' .. size .. '\|link=' .. teamPage .. '\|' .. string.gsub(teamPage, game .. '/', '') .. ']]')~~

	~~logoContainer:node(logo)~~
	return ~~logoContainer~~
	end		end

	return p		return p

Couchor at 15:32, 10 November 2023

2023-11-10T15:32:08Z

← Older revision		Revision as of 15:32, 10 November 2023
Line 68:		Line 68:
	fields = '_pageName, id, flag, joindate, leavedate, inactivedate'		fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
	cargoArgs = {		cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. ~~leaveDate~~ .. '"',		where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. result.leavedate.. '"',
	orderBy = 'joindate ASC',		orderBy = 'joindate ASC',
	limit = 10		limit = 10

Couchor at 12:05, 6 November 2023

2023-11-06T12:05:09Z

← Older revision		Revision as of 12:05, 6 November 2023
Line 11:		Line 11:
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = 'joindate DESC',		orderBy = 'leavedate DESC, joindate DESC',
	limit = 50		limit = 50
	}		}

Couchor at 08:56, 2 November 2023

2023-11-02T08:56:29Z

← Older revision		Revision as of 08:56, 2 November 2023
Line 34:		Line 34:
	local joinDate = monthName .. " " .. day .. ", " .. year		local joinDate = monthName .. " " .. day .. ", " .. year

	local ~~leavedate~~ = nil		local leaveDate = nil
	if result.leavedate then		if result.leavedate then
	year, month, day = result.leavedate:match("(%d+)-(%d+)-(%d+)")		year, month, day = result.leavedate:match("(%d+)-(%d+)-(%d+)")
Line 68:		Line 68:
	fields = '_pageName, id, flag, joindate, leavedate, inactivedate'		fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
	cargoArgs = {		cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. ~~result.leavedate~~ .. '"',		where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. leaveDate .. '"',
	orderBy = 'joindate ASC',		orderBy = 'joindate ASC',
	limit = 10		limit = 10

Couchor: Created page with "local Flags = require('Module:Flags') local p = {} local VariablesLua = mw.ext.VariablesLua local getTeamLogo = require('Module:Functions').getTeamLogo local cargo = mw.ext.cargo function p.main(frame) local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1] local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate' local cargoArgs = { where = '_pageName LIKE "' .. game .. '/%"', orderBy = 'joindate DESC', lim..."

2023-09-29T11:40:00Z

Created page with "local Flags = require('Module:Flags') local p = {} local VariablesLua = mw.ext.VariablesLua local getTeamLogo = require('Module:Functions').getTeamLogo local cargo = mw.ext.cargo function p.main(frame) local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1] local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate' local cargoArgs = { where = '_pageName LIKE "' .. game .. '/%"', orderBy = 'joindate DESC', lim..."

New page

local Flags = require('Module:Flags')
local p = {}
local VariablesLua = mw.ext.VariablesLua
local getTeamLogo = require('Module:Functions').getTeamLogo
local cargo = mw.ext.cargo

function p.main(frame)
local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]
local tables = 'Transfers'
local fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
local cargoArgs = {
where = '_pageName LIKE "' .. game .. '/%"',
orderBy = 'joindate DESC',
limit = 50
}
local results = cargo.query(tables, fields, cargoArgs)

local container = mw.html.create('div')
if #results > 0 then
local transfersContainer = mw.html.create('div'):addClass('transfer__container')
local transfersWrapper = mw.html.create('div'):addClass('box__container'):node(mw.html.create('div'):addClass('box__title'):wikitext('Latest transfers')):node(transfersContainer)

-- Header row
local transferHeader = mw.html.create('div'):addClass('transfer__row transfer__header')
transferHeader:node(mw.html.create('div'):wikitext('Date')):node(mw.html.create('div'):wikitext('Player')):node(mw.html.create('div'):wikitext('From')):node(mw.html.create('div'):wikitext('To'))
transfersContainer:node(transferHeader)

local monthNames = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}
-- Loop through all transfers
for i = 1, #results do
local result = results[i]
local year, month, day = result.joindate:match("(%d+)-(%d+)-(%d+)")
local monthName = monthNames[tonumber(month)]
local joinDate = monthName .. " " .. day .. ", " .. year

local leavedate = nil
if result.leavedate then
year, month, day = result.leavedate:match("(%d+)-(%d+)-(%d+)")
monthName = monthNames[tonumber(month)]
leaveDate = monthName .. " " .. day .. ", " .. year
end

local transfer = mw.html.create('div'):addClass('transfer__row')
local transferDate = mw.html.create('div'):wikitext(leaveDate or joinDate)

local flag = ''
if result.flag then
flag = Flags.icon(result.flag, game)
else
tables = 'People'
fields = '_pageName, nationality, name, romanized'
cargoArgs = {
where = '_pageName="' .. result.id .. '"'
}
local personResult = cargo.query(tables, fields, cargoArgs)
if #personResult > 0 then
flag = Flags.icon(personResult[1].nationality, game)
end
end

local player = mw.html.create('div'):addClass('transfer__player'):node(flag):node('[[' .. result.id .. '|' .. string.gsub(result.id, 'People/', '') .. ']]')

local from = mw.html.create('div')
local to = mw.html.create('div')
-- If left the current team then check if has joined a new one, else check for older entries from the same player to see which team he joined from
if leaveDate then
tables = 'Transfers'
fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
cargoArgs = {
where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate = "' .. result.leavedate .. '"',
orderBy = 'joindate ASC',
limit = 10
}
local newTeamResult = cargo.query(tables, fields, cargoArgs)

from:node(getTeamLogo(result._pageName, game, size))
if #newTeamResult > 0 then to:node(getTeamLogo(newTeamResult[1]._pageName, game, size))
else to:wikitext('X') end
else
tables = 'Transfers'
fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
cargoArgs = {
where = '_pageName LIKE "' .. game .. '/%" AND id="' .. result.id .. '" AND joindate < "' .. result.joindate .. '" AND leavedate="' .. result.joindate .. '"',
orderBy = 'joindate DESC',
limit = 10
}
local fromResults = cargo.query(tables, fields, cargoArgs)

-- If had previous teams
if #fromResults > 0 then
from:node(getTeamLogo(fromResults[1]._pageName, game, size))
to:node(getTeamLogo(result._pageName, game, size))
else
from:wikitext('X')
to:node(getTeamLogo(result._pageName, game, size))
end

end
transfer:node(transferDate):node(player):node(from):node(to)

transfersContainer:node(transfer)
end
return transfersWrapper
end

return container
end

function p.createLogo(url, teamPage, class, game, size)
size = size or '20px'
local className = class and class .. ' h-100' or 'h-100'
local logoURL = url and url or 'Team_placeholder_' .. class .. '.png'
local logoContainer = mw.html.create('div'):addClass(className)
local logo = mw.html.create('div')
:addClass('team-list-logo')
:node('[[File:' .. logoURL .. '|' .. size .. '|link=' .. teamPage .. '|' .. string.gsub(teamPage, game .. '/', '') .. ']]')

logoContainer:node(logo)
return logoContainer
end

return p