Module:SubSkillsTable

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

local p = {}

-- Fonction utilitaire pour les traductions classiques
local function getTrans(target_id, type, lang, field, variant, default)
    local query_where = string.format("target_id = '%s' AND type = '%s' AND language = '%s'", target_id, type, lang)
    if variant then query_where = query_where .. string.format(" AND variant = '%s'", variant) end
    
    local res = mw.ext.cargo.query("Translation", field, { where = query_where, limit = 1 })
    local val = (res and #res > 0) and res[1][field] or ""
    return (val ~= "") and val or (default or "")
end

-- Nouvelle fonction pour récupérer les infos d'un SubSkill
local function getSubSkillInfo(sub_id, lang)
    -- On cherche l'icône dans SubSkillDef
    local sub_def = mw.ext.cargo.query("SubSkill", "icon", { where = string.format("id = '%s'", sub_id), limit = 1 })
    local icon = (sub_def and #sub_def > 0) and sub_def[1].icon or "Placeholder"
    
    -- On cherche le nom et la desc dans Translation
    local name = getTrans(sub_id, "sub_skill", lang, "name")
    local desc = getTrans(sub_id, "sub_skill", lang, "description")
    
    return { name = name, desc = desc, icon = icon }
end

function p.display(frame)
    local skill_id = frame.args["id"] or frame.args[1]
    if not skill_id then return "ID requis" end
    local lang = frame.args.language or "en"
    
    local hSkill = getTrans("wiki_skills", "wiki", lang, "name", nil, "Compétence")
    local hSub = getTrans("wiki_sub_skills", "wiki", lang, "name", nil, "Sous-compétence")
    
    local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
        where = string.format("skill_id = '%s'", skill_id),
        orderBy = "level ASC"
    })
    
    local html = {'{| class="wikitable" style="width:100%; border-collapse:collapse;"'}
    table.insert(html, '! colspan=2 | ' .. hSkill .. ' !! colspan=3 | ' .. hSub)

    for _, lvl in ipairs(levels) do
        local name = getTrans(skill_id, "skill_level", lang, "name", lvl.level)
        local desc = getTrans(skill_id, "skill_level", lang, "description", lvl.level)
        local icon = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
        
        table.insert(html, '|-')
        table.insert(html, '| style="width:70px; border-right:0px;" | [[File:' .. icon .. '.png|70px]]')
        table.insert(html, '| style="border-left:0px; width:250px;" | \'\'\'' .. name .. '\'\'\' <br /><small>' .. desc .. '</small>')
        
        -- Parsing des SubSkills
        local subs = {}
        if lvl.offered_sub_skills then
            for s in string.gmatch(lvl.offered_sub_skills, "([^,]+)") do table.insert(subs, s) end
        end
        
        for i = 1, 3 do
            if subs[i] then
                local info = getSubSkillInfo(subs[i], lang)
                table.insert(html, '| style="text-align:center; width:200px;" | [[File:' .. info.icon .. '.png|40px]]<br />\'\'\'' .. info.name .. '\'\'\'<br /><small>' .. info.desc .. '</small>')
            else
                table.insert(html, '| ')
            end
        end
    end
    
    table.insert(html, "|}")
    return table.concat(html, "\n")
end

return p