miaoguo_system_server/scripts/verify_44_users.mjs

import Miaoguo from '../src/model/miaoguo.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
];

const placeholders = USER_IDS.map(() => '?').join(',');
const rows = await Miaoguo.RunSql(USER_IDS, `
    SELECT UserID,
           COUNT(DISTINCT DATE(CreateTime)) as days,
           MAX(DayNumber) as maxDay,
           MIN(DayNumber) as minDay
    FROM MiaoguoTask
    WHERE CardTask>0 AND UserID IN (${placeholders})
    GROUP BY UserID
    HAVING maxDay > days OR minDay <> 1;`);

if (rows.length === 0)
    console.log('✅ 44 个用户全部 DayNumber 连续且无膨胀，无残留异常。');
else
    console.log('❌ 仍有异常用户:', rows.map(r => `${r.UserID}(max=${r.maxDay},days=${r.days})`).join(', '));
process.exit(0);