Couchor: Created page with "local cargo = mw.ext.cargo local Flags = require('Module:Flags') local getTeamLogo = require('Module:Functions').getTeamLogo local p = {} function p.main() local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, maxdate' local cargoArgs = { orderBy = 'maxdate DESC', limit = 30 } local size = '25px' local results = cargo.query(tables, fields, cargoArgs) if #results > 0 then local prevTransfers = {} loca..."

2024-02-12T14:39:32Z

Created page with "local cargo = mw.ext.cargo local Flags = require('Module:Flags') local getTeamLogo = require('Module:Functions').getTeamLogo local p = {} function p.main() local tables = 'Transfers' local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, maxdate' local cargoArgs = { orderBy = 'maxdate DESC', limit = 30 } local size = '25px' local results = cargo.query(tables, fields, cargoArgs) if #results > 0 then local prevTransfers = {} loca..."

New page

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

function p.main()
local tables = 'Transfers'
local fields = '_pageName, id, flag, joindate, leavedate, inactivedate, maxdate'
local cargoArgs = {
orderBy = 'maxdate DESC',
limit = 30
}
local size = '25px'
local results = cargo.query(tables, fields, cargoArgs)

if #results > 0 then
local prevTransfers = {}

local transfersContainer = mw.html.create('div'):addClass('news-transfer-container')
local transfersWrapper = mw.html.create('div'):addClass('news-transfers-wrapper'):node(mw.html.create('div'):addClass('news-transfers-title'):wikitext('Latest transfers')):node(transfersContainer)

-- Header row
-- local transferHeader = mw.html.create('div'):addClass('news-transfer-row news-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 game = mw.text.split(result._pageName, '/')[1]
-- 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
table.insert(prevTransfers, {id = result.id, date = result.date})

local gameLogo = mw.html.create():wikitext('[[File:' .. game .. '_logo.png|20x20px|link=' .. game .. '/Transfers]]')

local transfer = mw.html.create('div'):addClass('news-transfer-row')

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('news-transfer-player'):node(flag):node('[[' .. result.id .. '|' .. string.gsub(result.id, 'People/', '') .. ']]')
local team = mw.html.create('div'):node(getTeamLogo(result._pageName, game, size))
local action = mw.html.create('div'):attr('title', result.leavedate and 'Left' or 'Joined'):wikitext(result.leavedate and 'X' or '=>')

transfer:node(gameLogo):node(player):node(action):node(team)

transfersContainer:node(transfer)

-- OLD TYPE TABLE
-- 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('news-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
end
return transfersWrapper
end
return nil
end

function tableContains(tbl, targetId, targetDate)
for _, transfer in ipairs(tbl) do
if transfer.id == targetId and transfer.date == targetDate then
return true -- The table with the specified id and date exists
end
end
return false
end

return p

Module:NewsLanding/Transfers - Revision history