Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Module:Statistics: Difference between revisions

From eSportsAmaze
No edit summary
No edit summary
 
(27 intermediate revisions by 2 users not shown)
Line 3: Line 3:
local html = mw.html
local html = mw.html
local text = mw.text
local text = mw.text
-- ============================================================
-- HELPER: Argument Fetcher
-- ============================================================
local function getArgs(frame)
    local args = {}
    for k, v in pairs(frame.args) do args[k] = v end
    if frame:getParent() then
        for k, v in pairs(frame:getParent().args) do args[k] = v end
    end
    return args
end


-- ============================================================
-- ============================================================
-- CONFIGURATION
-- CONFIGURATION
-- ============================================================
-- ============================================================
-- The "Blue Theme" Color for Heatmaps (RGB: 59, 130, 246 is #3b82f6)
local HEATMAP_R, HEATMAP_G, HEATMAP_B = 59, 130, 246
-- Standard Header Mapping (DB Field -> Display Name)
local HEADERS = {
local HEADERS = {
    -- BASICS
     rank = "#", team = "Team", player = "Player", matches_played = "Matches",
     rank = "#",
     finishes = "Finishes", fpm = "FPM", knocks = "Knocks", damage = "Damage",
    team = "Team",
     headshots = "Headshots", longest = "Longest", assists = "Assists",
    player = "Player",
     grenade_kills = "Grenade Fin", vehicle_kills = "Vehicle Fin", contribution = "Contrib %",  
    matches_played = "Matches", -- RENAMED FIELD
     survival = "Surv. Time", healings = "Heals", revives = "Revives", damage_taken = "Dmg Recv",
   
     grenades_used = "Nades Used", smokes_used = "Smokes Used", utility_used = "Util Used",
    -- KILLS / OFFENSE
     dist_drive = "Drive Dist", dist_walk = "Walk Dist", dist_total = "Total Dist",
     finishes = "Finishes",
     bluezone = "Bluezone Time", air_drops = "Air Drops",
    fpm = "FPM",  
     total_pts = "Total Pts", place_pts = "Place Pts", elims = "Elims",
    knocks = "Knocks",
     avg_place = "Avg Place", avg_place_pts = "Avg Place Pts", avg_elims = "Avg Elims", avg_total = "Avg Pts",
    damage = "Damage",
     wwcd = "🥇", place_2 = "🥈", place_3 = "🥉", top_5 = "Top 5", top_8 = "Top 8", place_low = "> 8th",
     headshots = "Headshots",
     g_0 = "0", g_1_5 = "1–5", g_6_10 = "6–10", g_11_15 = "11–15", g_16_20 = "16–20", g_20_plus = "20+"
    longest = "Longest",  
    assists = "Assists",
     grenade_kills = "Grenade Kills",
    vehicle_kills = "Vehicle Kills",
    contribution = "Contrib %",  
   
    -- SURVIVAL / SUPPORT
     survival = "Surv. Time",
    healings = "Heals",
    revives = "Revives",  
    damage_taken = "Dmg Recv",
   
    -- UTILITY
     grenades_used = "Nades Used",
    smokes_used = "Smokes Used",
    utility_used = "Util Used",
   
    -- MOVEMENT
     dist_drive = "Drive Dist",
    dist_walk = "Walk Dist",
    dist_total = "Total Dist",
     bluezone = "Bluezone Time",
    air_drops = "Air Drops",
   
    -- TEAM SPECIFIC
     total_pts = "Total Pts",
    place_pts = "Place Pts",
    elims = "Elims",
   
    -- AVERAGES (Team)
     avg_place = "Avg Place",
    avg_place_pts = "Avg Place Pts",
    avg_elims = "Avg Elims",
    avg_total = "Avg Pts",
   
    -- PLACEMENT COUNTS
     wwcd = "🥇", -- 1st
    place_2 = "🥈", -- 2nd
    place_3 = "🥉", -- 3rd
    top_5 = "Top 5",
    top_8 = "Top 8",
    place_low = "> 8th",
   
    -- POINT BUCKETS
     g_0 = "0",
    g_1_5 = "1–5",
    g_6_10 = "6–10",
    g_11_15 = "11–15",
    g_16_20 = "16–20",
    g_20_plus = "20+"
}
}
-- Columns that should NOT get a heatmap background
local NO_HEATMAP = { rank=true, team=true, player=true, matches_played=true }


-- ============================================================
-- ============================================================
-- HELPER: Calculate Heatmap Color
-- HELPER FUNCTIONS
-- ============================================================
-- ============================================================
local function getHeatmapStyle(value, maxVal)
 
     if not tonumber(value) or not tonumber(maxVal) or maxVal == 0 then return "" end
local function formatNumber(val)
     local v = tonumber(value)
     if not val then return "" end
      
    local n = tonumber(val)
     -- Calculate opacity (0.05 to 0.5 to keep text readable)
    if not n then return val end
     local ratio = v / maxVal
    if n == math.floor(n) then return math.floor(n) else return string.format("%.2f", n) end
     local alpha = 0.05 + (ratio * 0.45)  
end
 
local function getTeamLogo(teamName)
    if not teamName then return "" end
     local cleanName = teamName:gsub("'", "")
     local lightFile = cleanName .. '.png'
     local darkFile = cleanName .. '_dark.png'
     local hasLight = mw.title.new('File:' .. lightFile).exists
     local hasDark = mw.title.new('File:' .. darkFile).exists
      
      
     -- Return CSS
     local html = ""
     return string.format("background-color: rgba(%d, %d, %d, %.2f);", HEATMAP_R, HEATMAP_G, HEATMAP_B, alpha)
    if hasLight then html = html .. '[[File:' .. lightFile .. '|25px|link=' .. teamName .. '|class=logo-lightmode]]'
    else html = html .. '[[File:Shield_team.png|25px|link=' .. teamName .. '|class=logo-lightmode]]' end
    if hasDark then html = html .. '[[File:' .. darkFile .. '|25px|link=' .. teamName .. '|class=logo-darkmode]]'
     elseif hasLight then html = html .. '[[File:' .. lightFile .. '|25px|link=' .. teamName .. '|class=logo-darkmode]]'
    else html = html .. '[[File:Shield_team_dark.png|25px|link=' .. teamName .. '|class=logo-darkmode]]' end
    return html .. " "
end
end


Line 98: Line 66:
-- ============================================================
-- ============================================================
function p.main(frame)
function p.main(frame)
     local args = frame:getParent().args
     local args = getArgs(frame)
     local type = args.type or "player" -- 'player' or 'team'
     local type = args.type or "player"
     local tournament = args.tournament or mw.title.getCurrentTitle().subpageText
     local tournament = args.tournament
    if not tournament or tournament == "" then tournament = mw.title.getCurrentTitle().text end
     local map = args.map or "All"
     local map = args.map or "All"
    local stage = args.stage
    local group = args.group
      
      
    -- 1. Determine Columns to Show
     local colsInput = args.columns or ""
     local colsInput = args.columns or ""
     local colKeys = {}
     local colKeys = {}
    if colsInput == "" then
        if type == "player" then colKeys = {"rank", "player", "team", "matches_played", "finishes", "damage"}
        else colKeys = {"rank", "team", "matches_played", "total_pts", "wwcd"} end
    else colKeys = text.split(colsInput, ",") end
      
      
     if colsInput == "" then
     local queryFields = {}
        -- Default defaults
    for _, k in ipairs(colKeys) do
         if type == "player" then
         local cleanK = k:match("^%s*(.-)%s*$")
            colKeys = {"rank", "player", "team", "matches_played", "finishes", "damage", "headshots", "assists"}
         if cleanK ~= "rank" then table.insert(queryFields, cleanK) end
         else
            colKeys = {"rank", "team", "matches_played", "total_pts", "wwcd", "top_5"}
        end
    else
        colKeys = text.split(colsInput, ",")
     end
     end
      
      
     -- 2. Fetch Data
     local whereParts = {}
    table.insert(whereParts, string.format("tournament='%s'", tournament:gsub("'", "\\'")))
    if map ~= "Any" then table.insert(whereParts, string.format("map='%s'", map:gsub("'", "\\'"))) end
    if stage and stage ~= "" then table.insert(whereParts, string.format("stage='%s'", stage:gsub("'", "\\'"))) end
    if group and group ~= "" then table.insert(whereParts, string.format("groupname='%s'", group:gsub("'", "\\'"))) end
   
     local table_name = (type == "player") and "Player_Stats" or "Team_Stats"
     local table_name = (type == "player") and "Player_Stats" or "Team_Stats"
     local fields = table.concat(colKeys, ",")
     local selectString = table.concat(queryFields, ",") .. ", team"
    local where = string.format("tournament='%s' AND map='%s'", tournament:gsub("'", "\\'"), map)
      
      
    -- We select ALL fields to perform math, even if not displayed
     local results = cargo.query(table_name, selectString, {
     local results = cargo.query(table_name, fields .. ", team", {
         where = table.concat(whereParts, " AND "),
         where = where,
         orderBy = (type == "player" and "finishes DESC" or "total_pts DESC"),
         orderBy = (type == "player" and "finishes DESC" or "total_pts DESC"),
         limit = 100
         limit = 100
Line 131: Line 103:
      
      
     if not results or #results == 0 then
     if not results or #results == 0 then
         return '<div style="padding:20px; color:#666;">No statistics available for ' .. map .. '.</div>'
         return '<div style="padding:20px; color:var(--text-muted); font-style:italic;">No statistics found for: ' .. table.concat(whereParts, " | ") .. '</div>'
    end
   
    -- 3. Pre-Process: Find Max Values for Heatmap
    local maxValues = {}
    for _, row in ipairs(results) do
        for _, key in ipairs(colKeys) do
            -- Clean and check number
            local val = tonumber(row[key]) or 0
            if val > (maxValues[key] or 0) then
                maxValues[key] = val
            end
        end
     end
     end
      
      
    -- 4. Build Table
     local root = html.create('div'):addClass('stats-table-wrapper')
     local root = html.create('div'):addClass('stats-table-wrapper')
     local tbl = root:tag('table'):addClass('wikitable flat-table sortable stats-table')
     local tbl = root:tag('table'):addClass('flat-data-table sortable')
    tbl:css('width', 'auto')
      
      
    -- Headers
     local trHead = tbl:tag('tr')
     local trHead = tbl:tag('tr')
     for _, key in ipairs(colKeys) do
     for _, key in ipairs(colKeys) do
         local label = HEADERS[key:match("^%s*(.-)%s*$")] or key:upper()
         local cleanKey = key:match("^%s*(.-)%s*$")
         trHead:tag('th'):wikitext(label)
        local label = HEADERS[cleanKey] or cleanKey:upper()
          
        local th = trHead:tag('th'):wikitext(label):css("text-align", "center"):css("white-space", "nowrap")
       
        if cleanKey == "rank" then
            th:addClass('sticky-col sticky-1')
        elseif type == "team" and cleanKey == "team" then
            -- TEAM STATS (PC): Width 220px to fit long names
            th:addClass('sticky-col sticky-2'):css('width', '220px'):css('min-width', '220px'):css('max-width', '220px')
        elseif type == "player" and cleanKey == "player" then
            -- PLAYER STATS (PC): Width 180px for player names
            th:addClass('sticky-col sticky-2'):css('width', '180px'):css('min-width', '180px'):css('max-width', '180px')
        end
     end
     end
      
      
    -- Rows
     for i, row in ipairs(results) do
     for i, row in ipairs(results) do
         local tr = tbl:tag('tr')
         local tr = tbl:tag('tr')
       
         for _, key in ipairs(colKeys) do
         for _, key in ipairs(colKeys) do
             local cleanKey = key:match("^%s*(.-)%s*$")
             local cleanKey = key:match("^%s*(.-)%s*$")
            local rawVal = row[cleanKey]
             local cell = tr:tag('td')
             local cell = tr:tag('td')
              
              
            -- Special Formatting
             if cleanKey == "rank" then
             if cleanKey == "rank" then
                 cell:wikitext(i) -- Auto-rank based on sort
                 cell:addClass('sticky-col sticky-1')
                 cell:css("font-weight", "bold")
            elseif type == "team" and cleanKey == "team" then
                cell:addClass('sticky-col sticky-2'):css('width', '220px'):css('min-width', '220px'):css('max-width', '220px')
            elseif type == "player" and cleanKey == "player" then
                cell:addClass('sticky-col sticky-2'):css('width', '180px'):css('min-width', '180px'):css('max-width', '180px')
            end
 
            if cleanKey == "rank" then
                 cell:wikitext(i .. '.'):css("font-weight", "bold"):css("text-align", "center"):css("white-space", "nowrap"):css("padding", "5px 0")
             elseif cleanKey == "team" then
             elseif cleanKey == "team" then
                 cell:wikitext('[[' .. (rawVal or "") .. ']]')
                 local teamName = row.team or ""
                cell:css("text-align", "left")
                cell:attr("data-sort-value", teamName)
                if type == "player" then
                    cell:wikitext(getTeamLogo(teamName)):css("text-align", "center")
                else
                    cell:wikitext(getTeamLogo(teamName) .. '[[' .. teamName .. ']]'):css("text-align", "left"):css("white-space", "nowrap")
                end
             elseif cleanKey == "player" then
             elseif cleanKey == "player" then
                 cell:wikitext('[[' .. (rawVal or "") .. ']]')
                 cell:wikitext('[[' .. (row.player or "") .. ']]'):css("text-align", "left"):css("font-weight", "bold")
                cell:css("text-align", "left")
                cell:css("font-weight", "bold")
             else
             else
                -- Numeric Data
                 cell:wikitext(formatNumber(row[cleanKey])):css("text-align", "center")
                 cell:wikitext(rawVal)
                cell:css("text-align", "center")
               
                -- Heatmap Application
                if not NO_HEATMAP[cleanKey] then
                    local style = getHeatmapStyle(rawVal, maxValues[cleanKey])
                    if style ~= "" then
                        cell:attr("style", style .. " text-align:center;")
                    end
                end
             end
             end
         end
         end
     end
     end
   
     return tostring(root)
     return tostring(root)
end
end


return p
return p

Latest revision as of 23:08, 1 February 2026

Documentation for this module may be created at Module:Statistics/doc

local p = {}
local cargo = mw.ext.cargo
local html = mw.html
local text = mw.text

-- ============================================================
-- HELPER: Argument Fetcher
-- ============================================================
local function getArgs(frame)
    local args = {}
    for k, v in pairs(frame.args) do args[k] = v end
    if frame:getParent() then
        for k, v in pairs(frame:getParent().args) do args[k] = v end
    end
    return args
end

-- ============================================================
-- CONFIGURATION
-- ============================================================
local HEADERS = {
    rank = "#", team = "Team", player = "Player", matches_played = "Matches",
    finishes = "Finishes", fpm = "FPM", knocks = "Knocks", damage = "Damage",
    headshots = "Headshots", longest = "Longest", assists = "Assists",
    grenade_kills = "Grenade Fin", vehicle_kills = "Vehicle Fin", contribution = "Contrib %", 
    survival = "Surv. Time", healings = "Heals", revives = "Revives", damage_taken = "Dmg Recv",
    grenades_used = "Nades Used", smokes_used = "Smokes Used", utility_used = "Util Used",
    dist_drive = "Drive Dist", dist_walk = "Walk Dist", dist_total = "Total Dist",
    bluezone = "Bluezone Time", air_drops = "Air Drops",
    total_pts = "Total Pts", place_pts = "Place Pts", elims = "Elims",
    avg_place = "Avg Place", avg_place_pts = "Avg Place Pts", avg_elims = "Avg Elims", avg_total = "Avg Pts",
    wwcd = "🥇", place_2 = "🥈", place_3 = "🥉", top_5 = "Top 5", top_8 = "Top 8", place_low = "> 8th",
    g_0 = "0", g_1_5 = "1–5", g_6_10 = "6–10", g_11_15 = "11–15", g_16_20 = "16–20", g_20_plus = "20+"
}

-- ============================================================
-- HELPER FUNCTIONS
-- ============================================================

local function formatNumber(val)
    if not val then return "" end
    local n = tonumber(val)
    if not n then return val end 
    if n == math.floor(n) then return math.floor(n) else return string.format("%.2f", n) end
end

local function getTeamLogo(teamName)
    if not teamName then return "" end
    local cleanName = teamName:gsub("'", "")
    local lightFile = cleanName .. '.png'
    local darkFile = cleanName .. '_dark.png'
    local hasLight = mw.title.new('File:' .. lightFile).exists
    local hasDark = mw.title.new('File:' .. darkFile).exists
    
    local html = ""
    if hasLight then html = html .. '[[File:' .. lightFile .. '|25px|link=' .. teamName .. '|class=logo-lightmode]]'
    else html = html .. '[[File:Shield_team.png|25px|link=' .. teamName .. '|class=logo-lightmode]]' end
    if hasDark then html = html .. '[[File:' .. darkFile .. '|25px|link=' .. teamName .. '|class=logo-darkmode]]'
    elseif hasLight then html = html .. '[[File:' .. lightFile .. '|25px|link=' .. teamName .. '|class=logo-darkmode]]'
    else html = html .. '[[File:Shield_team_dark.png|25px|link=' .. teamName .. '|class=logo-darkmode]]' end
    return html .. " "
end

-- ============================================================
-- MAIN GENERATOR
-- ============================================================
function p.main(frame)
    local args = getArgs(frame)
    local type = args.type or "player"
    local tournament = args.tournament 
    if not tournament or tournament == "" then tournament = mw.title.getCurrentTitle().text end
    local map = args.map or "All"
    local stage = args.stage
    local group = args.group
    
    local colsInput = args.columns or ""
    local colKeys = {}
    if colsInput == "" then
        if type == "player" then colKeys = {"rank", "player", "team", "matches_played", "finishes", "damage"}
        else colKeys = {"rank", "team", "matches_played", "total_pts", "wwcd"} end
    else colKeys = text.split(colsInput, ",") end
    
    local queryFields = {}
    for _, k in ipairs(colKeys) do
        local cleanK = k:match("^%s*(.-)%s*$")
        if cleanK ~= "rank" then table.insert(queryFields, cleanK) end
    end
    
    local whereParts = {}
    table.insert(whereParts, string.format("tournament='%s'", tournament:gsub("'", "\\'")))
    if map ~= "Any" then table.insert(whereParts, string.format("map='%s'", map:gsub("'", "\\'"))) end
    if stage and stage ~= "" then table.insert(whereParts, string.format("stage='%s'", stage:gsub("'", "\\'"))) end
    if group and group ~= "" then table.insert(whereParts, string.format("groupname='%s'", group:gsub("'", "\\'"))) end
    
    local table_name = (type == "player") and "Player_Stats" or "Team_Stats"
    local selectString = table.concat(queryFields, ",") .. ", team"
    
    local results = cargo.query(table_name, selectString, {
        where = table.concat(whereParts, " AND "),
        orderBy = (type == "player" and "finishes DESC" or "total_pts DESC"),
        limit = 100
    })
    
    if not results or #results == 0 then
        return '<div style="padding:20px; color:var(--text-muted); font-style:italic;">No statistics found for: ' .. table.concat(whereParts, " | ") .. '</div>'
    end
    
    local root = html.create('div'):addClass('stats-table-wrapper')
    local tbl = root:tag('table'):addClass('flat-data-table sortable')
    tbl:css('width', 'auto')
    
    local trHead = tbl:tag('tr')
    for _, key in ipairs(colKeys) do
        local cleanKey = key:match("^%s*(.-)%s*$")
        local label = HEADERS[cleanKey] or cleanKey:upper()
        
        local th = trHead:tag('th'):wikitext(label):css("text-align", "center"):css("white-space", "nowrap")
        
        if cleanKey == "rank" then
            th:addClass('sticky-col sticky-1')
        elseif type == "team" and cleanKey == "team" then
            -- TEAM STATS (PC): Width 220px to fit long names
            th:addClass('sticky-col sticky-2'):css('width', '220px'):css('min-width', '220px'):css('max-width', '220px')
        elseif type == "player" and cleanKey == "player" then
            -- PLAYER STATS (PC): Width 180px for player names
            th:addClass('sticky-col sticky-2'):css('width', '180px'):css('min-width', '180px'):css('max-width', '180px')
        end
    end
    
    for i, row in ipairs(results) do
        local tr = tbl:tag('tr')
        for _, key in ipairs(colKeys) do
            local cleanKey = key:match("^%s*(.-)%s*$")
            local cell = tr:tag('td')
            
            if cleanKey == "rank" then
                cell:addClass('sticky-col sticky-1')
            elseif type == "team" and cleanKey == "team" then
                cell:addClass('sticky-col sticky-2'):css('width', '220px'):css('min-width', '220px'):css('max-width', '220px')
            elseif type == "player" and cleanKey == "player" then
                cell:addClass('sticky-col sticky-2'):css('width', '180px'):css('min-width', '180px'):css('max-width', '180px')
            end

            if cleanKey == "rank" then
                cell:wikitext(i .. '.'):css("font-weight", "bold"):css("text-align", "center"):css("white-space", "nowrap"):css("padding", "5px 0")
            elseif cleanKey == "team" then
                local teamName = row.team or ""
                cell:attr("data-sort-value", teamName)
                if type == "player" then
                    cell:wikitext(getTeamLogo(teamName)):css("text-align", "center")
                else
                    cell:wikitext(getTeamLogo(teamName) .. '[[' .. teamName .. ']]'):css("text-align", "left"):css("white-space", "nowrap")
                end
            elseif cleanKey == "player" then
                cell:wikitext('[[' .. (row.player or "") .. ']]'):css("text-align", "left"):css("font-weight", "bold")
            else
                cell:wikitext(formatNumber(row[cleanKey])):css("text-align", "center")
            end
        end
    end
    return tostring(root)
end

return p