Module:SubSkillsTable

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

local p = {}

-- 1. Fonction utilitaire pour récupérer des traductions (Translation)
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 result = (res and #res > 0) and res[1][field] or ""
    
    return (result ~= "") and result or (default or "")
end

-- 2. Création de la carte des liens (Nom -> ID)
local function getSkillLinkMap(lang)
    local skillIdsRes = mw.ext.cargo.query('Skill', 'id', { where = "variant = 'production'" })
    local validIds = {}
    for _, row in ipairs(skillIdsRes) do table.insert(validIds, "'" .. row.id .. "'") end
    local idList = table.concat(validIds, ",")

    local enNames = mw.ext.cargo.query('Translation', 'target_id, name', {
        where = "type = 'skill' AND language = 'en' AND target_id IN (" .. idList .. ")"
    })
    local idToEnName = {}
    for _, row in ipairs(enNames) do idToEnName[row.target_id] = row.name end

    local localNames = mw.ext.cargo.query('Translation', 'target_id, name', {
        where = "type = 'skill' AND language = '" .. lang .. "' AND target_id IN (" .. idList .. ")"
    })
    
    local map = {}
    for _, row in ipairs(localNames) do
        local enName = idToEnName[row.target_id]
        if enName then
            map[row.name] = enName
        end
    end
    return map
end

-- Fonction utilitaire pour échapper les caractères spéciaux
local function escapePattern(str)
    return str:gsub("([%^%$%(%)%%%.%[%]%*%+%-%?])", "%%%1")
end

-- 3. Remplacement des noms de skills par des liens wiki
local function linkSkillsInText(text, lang, linkMap)
    if not text or text == "" then return "" end
    
    local sortedNames = {}
    for name, id in pairs(linkMap) do table.insert(sortedNames, name) end
    table.sort(sortedNames, function(a, b) return #a > #b end)
    
    for _, name in ipairs(sortedNames) do
        local englishName = linkMap[name]
        
        -- Si la langue est 'en', on ne met pas le suffixe /en
        local target = (lang == "en") and englishName or (englishName .. "/" .. lang)
        
        -- On construit le lien : [[NomAnglais|NomTraduit]] ou [[NomAnglais/lang|NomTraduit]]
        local replacement = "[[" .. target .. "|" .. name .. "]]"
        
        local pattern = escapePattern(name)
        text = mw.ustring.gsub(text, pattern, replacement)
    end
    return text
end

-- 4. Fonction pour récupérer les infos d'un SubSkill
local function getSubSkillInfo(sub_id, lang, linkMap)
    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"
    local name = getTrans(sub_id, "sub_skill", lang, "name")
    local desc = getTrans(sub_id, "sub_skill", lang, "description")
    
    desc = linkSkillsInText(desc, lang, linkMap)
    return { name = name, desc = desc, icon = icon }
end

-- 5. Fonction principale d'affichage
function p.display(frame)
    local args = frame.args
    local skill_id = args["id"] or args[1]
    local pagename = mw.title.getCurrentTitle().text
    
    -- DÉTECTION AUTOMATIQUE DE LA LANGUE
    local lang = args["language"]
    if not lang then
        -- On cherche un suffixe de type "/fr", "/it", "/zh_cn" en fin de titre
        local detectedLang = mw.ustring.match(pagename, "/([a-z_]+)$")
        lang = detectedLang or "en"
    end
    
    -- DÉTECTION AUTOMATIQUE DE L'ID
    if not skill_id then
        local baseName = mw.ustring.gsub(pagename, "/.*", "")
        
        -- Nettoyage : On retire tout ce qui est entre parenthèses et les espaces inutiles
        baseName = mw.ustring.gsub(baseName, "%s*%([^%)]*%)", "")
        baseName = mw.text.trim(baseName)
        
        local res = mw.ext.cargo.query("Translation", "target_id", {
            where = "type = 'skill' AND language = 'en' AND name = '" .. baseName .. "'",
            limit = 1
        })
        
        if res and #res > 0 then
            skill_id = res[1].target_id
        end
    end
    
    if not skill_id then return "ID requis (indiquez |id=... ou nommez correctement votre page)" end
    
    local linkMap = getSkillLinkMap(lang)
    local hSkill = getTrans("wiki_skills", "wiki", lang, "name", nil, "Skills")
    local hSub = getTrans("wiki_sub_skills", "wiki", lang, "name", nil, "Subskills")
    
    local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
        where = string.format("skill_id = '%s'", skill_id),
        orderBy = "level ASC"
    })
    
    if not levels or #levels == 0 then return "Aucun niveau trouvé pour cet ID : " .. skill_id end
    
    local html = {'{| class="wikitable" style="width:100%; border-collapse:collapse;"'}
    table.insert(html, '! colspan=2 | ' .. hSkill .. ' !! colspan=6 | ' .. 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)
        desc = linkSkillsInText(desc, lang, linkMap)
        
        local icon = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
        
        table.insert(html, '|- style="vertical-align:top;"')
        table.insert(html, '| style="width:70px; border-right:0px;" | [[File:' .. icon .. '.png|70px]]')
        table.insert(html, '| style="border-left:0px; width:200px;" | \'\'\'' .. name .. '\'\'\' <br /><br />' .. desc .. '')
        
        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, linkMap)
                table.insert(html, '| style="width:30px; border-right:0px; padding-left:10px;" | [[File:' .. info.icon .. '.png|30px]]')
                table.insert(html, '| style="width:180px; border-left:0px;" | \'\'\'' .. info.name .. '\'\'\'<br /><br />' .. info.desc .. '')
            else
                table.insert(html, '| colspan=2 style="border-left:1px solid #ccc;" | &nbsp;')
            end
        end
    end
    
    table.insert(html, "|}")
    return table.concat(html, "\n")
end

function p.debugMap(frame)
    local lang = frame.args["language"] or "en"
    local linkMap = getSkillLinkMap(lang)
    
    local output = {"=== Contenu de la LinkMap (" .. lang .. ") ==="}
    for name, id in pairs(linkMap) do
        table.insert(output, "* " .. name .. " -> " .. id)
    end
    return table.concat(output, "\n")
end

return p