Module:GameLanding/Transfers - Revision history

Couchor at 21:44, 12 February 2024

2024-02-12T21:44:49Z

← Older revision		Revision as of 21:44, 12 February 2024
Line 9:		Line 9:
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = '~~date~~ DESC, _pageName ASC',		orderBy = 'maxdate DESC, _pageName ASC',
	limit = 10		limit = 10
	}		}

Couchor at 10:31, 16 November 2023

2023-11-16T10:31:08Z

Show changes

Couchor at 09:19, 13 November 2023

2023-11-13T09:19:32Z

← Older revision		Revision as of 09:19, 13 November 2023
Line 9:		Line 9:
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = '~~leavedate~~ DESC, ~~joindate~~ DESC',		orderBy = 'joindate DESC, leavedate DESC',
	limit = 10		limit = 10
	}		}

Couchor at 15:31, 10 November 2023

2023-11-10T15:31:49Z

← Older revision		Revision as of 15:31, 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 22:29, 31 October 2023

2023-10-31T22:29:51Z

← Older revision		Revision as of 22:29, 31 October 2023
Line 9:		Line 9:
	local cargoArgs = {		local cargoArgs = {
	where = '_pageName LIKE "' .. game .. '/%"',		where = '_pageName LIKE "' .. game .. '/%"',
	orderBy = 'joindate DESC',		orderBy = 'leavedate DESC, joindate DESC',
	limit = 10		limit = 10
	}		}
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 cargo = mw.ext.cargo local Flags = require('Module:Flags') local getTeamLogo = require('Module:Functions').getTeamLogo local p = {} function p.latestTransfers(game) local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate' local cargoArgs = { where = '_pageName LIKE "' .. game .. '/%"', orderBy = 'joindate DESC', limit = 10 } local size = '25px' local results = cargo.query(tables, fields, cargoArgs) if #resul..."

2023-09-29T11:30:20Z

Created page with "local cargo = mw.ext.cargo local Flags = require('Module:Flags') local getTeamLogo = require('Module:Functions').getTeamLogo local p = {} function p.latestTransfers(game) local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate' local cargoArgs = { where = '_pageName LIKE "' .. game .. '/%"', orderBy = 'joindate DESC', limit = 10 } local size = '25px' local results = cargo.query(tables, fields, cargoArgs) if #resul..."

New page

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

function p.latestTransfers(game)
local tables = 'Transfers'
local fields = '_pageName, id, flag, joindate, leavedate, inactivedate'
local cargoArgs = {
where = '_pageName LIKE "' .. game .. '/%"',
orderBy = 'joindate DESC',
limit = 10
}
local size = '25px'
local results = cargo.query(tables, fields, cargoArgs)

if #results > 0 then
local list = ''

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 nil
end

return p