模块:OWMOMarket

此模块的文档可以在模块:OWMOMarket/doc创建

local p = {}

function p.renderSidebar(frame)
    local extData = mw.ext.externalData
    if not extData or not extData.getDbData then
        return "错误：未找到 External Data 的 Lua 接口，请确保插件已正确安装且版本支持。"
    end

    -- 1. 获取最新期数 (注意 getDbData 和 ['order by'] 的正确语法)
    local latest_data, err1 = extData.getDbData{
        db = 'wp_db', 
        from = 'wp_owmc_currency_rates',
        ['order by'] = 'year DESC, month DESC', 
        limit = 1,
        data = 'year=year, month=month'
    }
    
    if not latest_data or not latest_data[1] then return "暂无行情数据" end
    local max_y = tonumber(latest_data[1].year)
    local max_m = tonumber(latest_data[1].month)

    -- 2. 计算 8 期前（1 个月前）的期数
    local current_abs = max_y * 104 + max_m
    local old_abs = current_abs - 8
    local old_y = math.floor((old_abs - 1) / 104)
    local old_m = ((old_abs - 1) % 104) + 1

    -- 3. 抓取本期和上月的数据及元数据
    local current_rates = extData.getDbData{ 
        db = 'wp_db', 
        from = 'wp_owmc_currency_rates', 
        where = string.format("year=%d AND month=%d", max_y, max_m), 
        limit = 200,
        data = 'currency_code=currency_code, rate=rate'
    }
    local old_rates = extData.getDbData{ 
        db = 'wp_db', 
        from = 'wp_owmc_currency_rates', 
        where = string.format("year=%d AND month=%d", old_y, old_m), 
        limit = 200,
        data = 'currency_code=currency_code, rate=rate'
    }
    local meta_data = extData.getDbData{ 
        db = 'wp_db', 
        from = 'wp_owmc_currency_meta', 
        limit = 200,
        data = 'currency_code=currency_code, currency_name=currency_name'
    }

    -- 4. 数据映射与处理
    local meta_map, old_map = {}, {}
    if meta_data then 
        for _, r in ipairs(meta_data) do 
            meta_map[r.currency_code] = r.currency_name 
        end 
    end
    if old_rates then 
        for _, r in ipairs(old_rates) do 
            old_map[r.currency_code] = tonumber(r.rate) 
        end 
    end

    local stats = {}
    if current_rates then
        for _, row in ipairs(current_rates) do
            local code = row.currency_code
            local c_rate = tonumber(row.rate)
            local o_rate = old_map[code]

            if c_rate and o_rate and c_rate > 0 then
                -- 计算相对价值 (1 本币 = ? 参照)，并算出涨跌幅
                local val_current = 1 / c_rate
                local val_old = 1 / o_rate
                local pct = ((val_current - val_old) / val_old) * 100
                table.insert(stats, { code = code, name = meta_map[code] or code, val = val_current, pct = pct })
            end
        end
    end

    -- 按照涨跌幅降序排序
    table.sort(stats, function(a, b) return a.pct > b.pct end)

    -- 5. 开始渲染 HTML
    local html = mw.html.create('div')
        :cssText("width: 260px; float: right; clear: right; margin: 0 0 16px 16px; background: #ffffff; border: 1px solid #e2e8f0; border-radius: 12px; padding: 16px; box-shadow: 0 4px 12px rgba(0,0,0,0.03); font-family: -apple-system, 'Segoe UI', sans-serif;")

    local function renderRow(item)
        local is_up = item.pct >= 0
        local color = is_up and "#f43f5e" or "#10b981"
        local sign = is_up and "▲ +" or "▼ "
        local pct_str = string.format("%.2f%%", item.pct)
        local val_str = string.format("%.4f", item.val)

        -- SVG 原生绘制极简走势线
        local svg_path = is_up and "M2,16 L18,10 L38,4" or "M2,4 L18,10 L38,16"
        if item.pct == 0 then svg_path = "M2,10 L38,10" end
        local sparkline = string.format('<svg width="40" height="20" viewBox="0 0 40 20"><path d="%s" fill="none" stroke="%s" stroke-width="2" stroke-linecap="round"/></svg>', svg_path, color)

        return string.format([[
        <div style="display: flex; justify-content: space-between; align-items: center; padding: 10px 0; border-bottom: 1px solid #f8fafc;">
            <div style="flex: 1; text-align: left;">
                <div style="font-weight: 900; color: #0f172a; font-size: 14px; font-family: 'Courier New', monospace;">%s</div>
                <div style="font-size: 11px; color: #64748b; font-weight: 500; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; max-width: 80px;">%s</div>
            </div>
            <div style="flex: 0 0 45px; text-align: center;">%s</div>
            <div style="flex: 1; text-align: right;">
                <div style="font-weight: bold; font-family: 'Courier New', monospace; font-size: 14px; color: #0f172a;">%s</div>
                <div style="font-size: 11px; font-weight: 800; color: %s; letter-spacing: -0.5px;">%s%s</div>
            </div>
        </div>
        ]], item.code, item.name, sparkline, val_str, color, sign, pct_str)
    end

    -- 渲染主币
    html:node(mw.html.create('div'):cssText("font-size: 12px; font-weight: 800; color: #94a3b8; text-transform: uppercase; margin-bottom: 4px;"):wikitext("Core Assets / 主币"))
    local cores = {WMC=true, KCK=true, SKV=true, COS=true}
    for _, item in ipairs(stats) do
        if cores[item.code] then html:node(mw.html.create('div'):wikitext(renderRow(item))) end
    end

    -- 渲染领涨 Top 3
    html:node(mw.html.create('div'):cssText("font-size: 12px; font-weight: 800; color: #f43f5e; text-transform: uppercase; margin-top: 16px; margin-bottom: 4px;"):wikitext("Top Gainers / 领涨"))
    local count = 0
    for _, item in ipairs(stats) do
        if not cores[item.code] and item.pct > 0 then
            html:node(mw.html.create('div'):wikitext(renderRow(item)))
            count = count + 1
            if count >= 3 then break end
        end
    end

    -- 渲染领跌 Top 3
    html:node(mw.html.create('div'):cssText("font-size: 12px; font-weight: 800; color: #10b981; text-transform: uppercase; margin-top: 16px; margin-bottom: 4px;"):wikitext("Top Losers / 领跌"))
    count = 0
    for i = #stats, 1, -1 do
        local item = stats[i]
        if not cores[item.code] and item.pct < 0 then
            html:node(mw.html.create('div'):wikitext(renderRow(item)))
            count = count + 1
            if count >= 3 then break end
        end
    end

    return tostring(html)
end

return p