miaoguo_system_server/scripts/fix_44_users.mjs

// 批量修复最近一个月存在 DayNumber 膨胀/断号的活跃用户（与 42792 相同的去重+按天连续重编号逻辑）。
import Miaoguo from '../src/model/miaoguo.js';
import constantClass from '../src/util/constant/index.js';
import { stringUtils } from '../src/util/stringClass.js';

const USER_IDS = [
    1, 2, 321, 658, 699, 1586, 1631, 3232, 14845, 14916, 15220, 15278,
    15360, 15362, 15387, 16297, 16791, 17315, 22192, 23093, 24084, 24142,
    24149, 25310, 26887, 27170, 29864, 30393, 30894, 31436, 31917, 33746,
    34777, 39733, 39769, 40981, 41301, 41496, 42666, 42668, 42702, 42792,
    42860, 43485
];

async function fixUser(userID) {
    const tasks = await Miaoguo.RunSql([userID],
        "SELECT * FROM MiaoguoTask where CardTask>0 and UserID=? order by CreateTime, ID desc;");
    if (!tasks || tasks.length === 0) return `User ${userID}: 无记录`;

    const dayBest = new Map();
    const score = (x) => (x.IsShare > 0 ? 4 : 0) + (x.MilestoneDayNumber > 0 ? 2 : 0) + (x.AphorismID > 0 ? 1 : 0);
    for (const t of tasks) {
        const best = dayBest.get(t.CreateTime);
        if (!best) dayBest.set(t.CreateTime, t);
        else if (score(t) > score(best) || (score(t) === score(best) && t.ID > best.ID))
            dayBest.set(t.CreateTime, t);
    }

    let deleted = 0;
    for (const t of tasks) {
        if (dayBest.get(t.CreateTime).ID !== t.ID) {
            await Miaoguo.RunSql([t.ID], "delete from MiaoguoTask where ID=?;");
            deleted++;
        }
    }

    const dayTasks = [...dayBest.values()].sort((a, b) =>
        a.CreateTime < b.CreateTime ? -1 : a.CreateTime > b.CreateTime ? 1 : a.ID - b.ID);

    const milestone = constantClass.GetMilestone();
    let milestoneIDs = [];
    for (let i = 0; i < 40; i++) milestoneIDs.push(i + 1);
    milestoneIDs = stringUtils.RandomArray(milestoneIDs);
    let milestoneIndex = 0, hardworkingIndex = 0;
    for (let i = 0; i < dayTasks.length; i++) {
        const t = dayTasks[i];
        const update = { ID: t.ID, DayNumber: i + 1 };
        const milestoneItem = milestone.find(item => item.DayNumber == i + 1);
        if (milestoneItem) {
            update.MilestoneDayNumber = milestoneItem.DayNumber;
            update.MilestoneID = milestoneIDs[milestoneIndex++];
        }
        if (t.IsShare > 0 || update.MilestoneDayNumber > 0 || t.AphorismID > 0)
            update.HardworkingNumber = ++hardworkingIndex;
        await Miaoguo.UpdateMiaoguoTask(update);
    }
    return `User ${userID}: 删除 ${deleted} 条重复，重编号 ${dayTasks.length} 天 (DayNumber 1..${dayTasks.length})`;
}

for (const id of USER_IDS) {
    const msg = await fixUser(id);
    console.log(msg);
}
console.log(`\n完成，共处理 ${USER_IDS.length} 个用户。`);
process.exit(0);