import { writeFileSync } from 'node:fs'
import { join, dirname } from 'node:path'
import { fileURLToPath } from 'node:url'

const BASE = 'http://localhost:8080/api/v1'

async function api(path, options = {}) {
  const res = await fetch(`${BASE}${path}`, options)
  const text = await res.text()
  let json = null
  try { json = JSON.parse(text) } catch { /* empty body */ }
  if (!res.ok) {
    throw new Error(`${options.method || 'GET'} ${path} -> ${res.status} ${text}`)
  }
  return json
}

function auth(token) {
  return { 'content-type': 'application/json', authorization: `Bearer ${token}` }
}

// deadline 相对天数（正值未来/负值过去），null 表示无截止日期
const dl = (n) => {
  if (n === null || n === undefined) return null
  const d = new Date(Date.now() + n * 86400000)
  const pad = (x) => String(x).padStart(2, '0')
  return `${d.getFullYear()}-${pad(d.getMonth() + 1)}-${pad(d.getDate())}T${pad(d.getHours())}:${pad(d.getMinutes())}:${pad(d.getSeconds())}`
}

// daysAgo: 0=今天, 6=6天前；time: 当天创建时刻；closedDaysAfter: 关闭距创建天数
const issues = [
  // ============ D-6（6 天前）============
  { title: '用户注册流程中重复邮箱校验失败提示不明确', description: '重复邮箱注册时仅提示「注册失败」无具体原因，需明确提示邮箱已被占用。', status: 'closed', priority: 'medium', phase: '基本设计', subProject: '用户管理子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-3), daysAgo: 6, time: '00:00:00', closedDaysAfter: 2 },
  { title: '接口鉴权异常返回状态码与文档不一致', description: 'Token 过期时接口返回 403，而接口文档约定为 401，前端异常处理无法正确触发刷新。', status: 'closed', priority: 'high', phase: '详细设计', subProject: '权限控制子系统', category: '安全漏洞', impactLevel: '较高', impactScope: '影响全部用户', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(-4), daysAgo: 6, time: '10:20', closedDaysAfter: 3 },
  { title: '大屏报表在高峰时段刷新导致页面卡死（已逾期）', description: '数据大屏每分钟自动刷新，高峰时段后端响应慢，前端堆叠请求导致页面卡死，属逾期紧急问题。', status: 'pending', priority: 'urgent', phase: '综合测试 (ST)', subProject: '数据报表子系统', category: '性能问题', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-6), daysAgo: 6, time: '00:00:00' },
  { title: '用户批量导入时角色字段被忽略', description: '批量导入用户时角色列数据未写入，导入后全部用户无角色权限。', status: 'in_progress', priority: 'medium', phase: '单体测试', subProject: '用户管理子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(2), daysAgo: 6, time: '14:05' },
  { title: '报表导出按钮在移动端被遮挡', description: '移动端打开报表页，导出按钮被底部导航遮挡，需调整响应式布局。', status: 'draft', priority: 'low', phase: '基本设计', subProject: '数据报表子系统', category: 'UI/UX问题', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 4, deadline: null, daysAgo: 6, time: '16:40' },
  // ============ D-5（5 天前）============
  { title: '角色权限矩阵说明文档缺少新增权限项', description: '新增「报表导出」权限后，角色权限矩阵说明文档未同步更新。', status: 'closed', priority: 'low', phase: '详细设计', subProject: '权限控制子系统', category: '文档错误', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(-3), daysAgo: 5, time: '09:30', closedDaysAfter: 2 },
  { title: '用户停用后再启用，登录时提示账号不存在', description: '停用再启用的用户登录时被缓存系统判定不存在，需清理登录缓存或调整查询逻辑。', status: 'pending_confirm', priority: 'high', phase: '结合测试 (IT)', subProject: '用户管理子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(1), daysAgo: 5, time: '11:10' },
  { title: '报表筛选条件切换时偶发白屏', description: '快速切换筛选条件时偶发白屏，前端异常未捕获，需增加错误边界。', status: 'in_progress', priority: 'medium', phase: '单体测试', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(2), daysAgo: 5, time: '13:45', attachments: ['report-white-screen.log'] },
  { title: '密码重置链接可在过期后仍被使用', description: '密码重置链接生成 30 分钟后仍可使用，安全窗口过长，需收紧有效期并校验。', status: 'pending', priority: 'urgent', phase: '综合测试 (ST)', subProject: '权限控制子系统', category: '安全漏洞', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-4), daysAgo: 5, time: '15:20' },
  { title: '个人中心头像上传后不即时刷新', description: '上传头像成功后页面仍显示旧头像，需刷新浏览器才更新。', status: 'draft', priority: 'medium', phase: '基本设计', subProject: '用户管理子系统', category: 'UI/UX问题', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 4, deadline: null, daysAgo: 5, time: '17:55' },
  // ============ D-4（4 天前）============
  { title: '子账号无法继承上级部门的默认权限', description: '新建子账号后未继承所属部门默认权限，需手动逐个配置，影响开通效率。', status: 'closed', priority: 'high', phase: '详细设计', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-2), daysAgo: 4, time: '09:00', closedDaysAfter: 2 },
  { title: '报表时间筛选默认值不正确导致首屏查询异常', description: '默认时间范围取到上个月而非当月，首屏数据与预期不符。', status: 'closed', priority: 'medium', phase: '单体测试', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(-1), daysAgo: 4, time: '10:15', closedDaysAfter: 3, attachments: ['report-date-filter.log'] },
  { title: '用户详情页部门信息保存后丢失', description: '编辑用户部门后保存成功，但刷新页面部门回退为原值，保存逻辑未持久化。', status: 'pending', priority: 'medium', phase: '结合测试 (IT)', subProject: '用户管理子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(3), daysAgo: 4, time: '12:30' },
  { title: '权限配置界面缺少操作指引文案', description: '权限树配置界面无任何操作指引，新用户难以理解继承与覆盖规则。', status: 'in_progress', priority: 'low', phase: '基本设计', subProject: '权限控制子系统', category: '文档错误', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(3), daysAgo: 4, time: '14:50' },
  { title: '报表缓存命中率低导致频繁全量查询', description: '缓存 key 未细化到筛选条件，命中率低，频繁触发全量查询拖慢接口。', status: 'pending_confirm', priority: 'high', phase: '综合测试 (ST)', subProject: '数据报表子系统', category: '性能问题', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-1), daysAgo: 4, time: '16:25' },
  // ============ D-3（3 天前）============
  { title: '登录日志中明文记录密码字段', description: '审计日志将密码字段明文写入，存在泄露风险，需脱敏处理。', status: 'closed', priority: 'urgent', phase: '综合测试 (ST)', subProject: '用户管理子系统', category: '安全漏洞', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(-1), daysAgo: 3, time: '09:10', closedDaysAfter: 2 },
  { title: '菜单权限下发后部分终端 5 分钟未生效', description: '角色菜单权限更新后，部分终端最长 5 分钟才生效，需清理网关侧权限缓存。', status: 'in_progress', priority: 'high', phase: '结合测试 (IT)', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(2), daysAgo: 3, time: '10:40' },
  { title: '图表导出 Excel 后公式失效', description: '报表图表导出 Excel 后数据变为静态值，原有公式/联动丢失。', status: 'pending', priority: 'medium', phase: '详细设计', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(2), daysAgo: 3, time: '13:20' },
  { title: '深色主题下校验错误提示看不清', description: '深色主题下表单校验错误文字对比度不足，难以辨认。', status: 'pending_confirm', priority: 'low', phase: '基本设计', subProject: '用户管理子系统', category: 'UI/UX问题', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 4, deadline: dl(-1), daysAgo: 3, time: '15:35' },
  { title: '权限变更审计日志缺少操作前后对比', description: '权限变更日志只记录变更后结果，缺少变更前后对比，无法追溯误操作。', status: 'draft', priority: 'medium', phase: '详细设计', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '影响部分模块', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(4), daysAgo: 3, time: '17:10' },
  // ============ D-2（2 天前）============
  { title: '报表订阅任务偶发重复推送', description: '订阅报表在任务重试时未做幂等处理，偶发同一份报表重复推送。', status: 'closed', priority: 'medium', phase: '单体测试', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-1), daysAgo: 2, time: '09:25', closedDaysAfter: 1, attachments: ['subscribe-duplicate.log'] },
  { title: '用户导出接口存在越权查看他人信息风险', description: '用户导出接口未按数据权限过滤，可导出全部用户信息，已加数据权限校验。', status: 'closed', priority: 'high', phase: '结合测试 (IT)', subProject: '用户管理子系统', category: '安全漏洞', impactLevel: '较高', impactScope: '影响全部用户', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 2, time: '10:50', closedDaysAfter: 2 },
  { title: '权限变更后旧 Token 权限未即时回收（已逾期）', description: '调整角色权限后，用户已签发的旧 Token 仍持有旧权限，需在鉴权时实时校验。', status: 'in_progress', priority: 'urgent', phase: '综合测试 (ST)', subProject: '权限控制子系统', category: '安全漏洞', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(-1), daysAgo: 2, time: '12:00', agent: { goal: '分析旧 Token 权限未即时回收问题并生成对应方案', action: 'approve-pending' } },
  { title: '大数据量筛选查询未走索引', description: '报表大表筛选条件未命中索引，全表扫描导致响应慢，需评估加复合索引。', status: 'pending', priority: 'medium', phase: '详细设计', subProject: '数据报表子系统', category: '性能问题', impactLevel: '一般', impactScope: '影响部分模块', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(3), daysAgo: 2, time: '14:30' },
  { title: '用户操作手册缺少批量操作章节', description: '操作手册未收录用户批量导入/停用/导出说明，新员工无法按手册操作。', status: 'draft', priority: 'low', phase: '基本设计', subProject: '用户管理子系统', category: '文档错误', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: 2, reviewerId: 1, departmentId: 3, deadline: null, daysAgo: 2, time: '16:05' },
  // ============ D-1（1 天前）============
  { title: '权限树刷新后折叠状态丢失', description: '刷新页面后权限树展开/折叠状态丢失，需记忆用户浏览位置。', status: 'closed', priority: 'high', phase: '综合测试 (ST)', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 1, time: '09:15', closedDaysAfter: 1 },
  { title: '报表订阅邮件正文乱码', description: '订阅邮件正文中文显示乱码，邮件未指定 UTF-8 编码。', status: 'in_progress', priority: 'medium', phase: '结合测试 (IT)', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 1, time: '10:30', agent: { goal: '分析订阅邮件乱码问题并生成修复方案', action: 'reject' } },
  { title: '验证码接口未限制调用频率（即将到期）', description: '图形验证码接口可被高频调用，存在资源耗尽与爆破风险，需限流。', status: 'in_progress', priority: 'urgent', phase: '综合测试 (ST)', subProject: '用户管理子系统', category: '安全漏洞', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: 3, reviewerId: 1, departmentId: 2, deadline: dl(1), daysAgo: 1, time: '11:50' },
  { title: '角色复制时资源权限合并逻辑错误', description: '角色 A 复制给 B 时，B 原有资源权限被整体覆盖而非合并，导致权限丢失。', status: 'pending_confirm', priority: 'high', phase: '单体测试', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 1, time: '14:10' },
  { title: '移动端表单在输入法弹出时遮挡提交按钮', description: '移动端输入时软键盘遮挡提交按钮，无法完成提交，需处理键盘弹出滚动。', status: 'pending', priority: 'medium', phase: '详细设计', subProject: '用户管理子系统', category: 'UI/UX问题', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 4, deadline: dl(1), daysAgo: 1, time: '16:45' },
  // ============ D0（今天）============
  { title: '权限复制操作未校验目标角色是否存在', description: '权限复制时未校验目标角色 ID 有效性，传非法 ID 返回成功但实际未复制。', status: 'in_progress', priority: 'high', phase: '结合测试 (IT)', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '较高', impactScope: '影响部分模块', assigneeId: 2, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 0, time: '09:05' },
  { title: '报表导出任务失败后无重试机制', description: '报表导出失败后任务直接终止，无重试与失败通知，需增加重试策略。', status: 'pending', priority: 'medium', phase: '单体测试', subProject: '数据报表子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '仅本页面', assigneeId: 3, reviewerId: 1, departmentId: 3, deadline: dl(1), daysAgo: 0, time: '10:35' },
  { title: '页面底部固定操作栏遮挡内容', description: '详情页底部固定操作栏遮挡正文内容，滚动到底部时无法查看最后几行。', status: 'pending_confirm', priority: 'low', phase: '基本设计', subProject: '用户管理子系统', category: 'UI/UX问题', impactLevel: '轻微', impactScope: '仅本页面', assigneeId: null, reviewerId: 1, departmentId: 2, deadline: null, daysAgo: 0, time: '14:20' },
  { title: '权限模板缺少批量应用入口', description: '权限模板只能逐个应用到角色，缺少批量应用入口，操作效率低。', status: 'draft', priority: 'medium', phase: '详细设计', subProject: '权限控制子系统', category: '功能缺陷', impactLevel: '一般', impactScope: '影响部分模块', assigneeId: null, reviewerId: 1, departmentId: 2, deadline: null, daysAgo: 0, time: '16:00' },
  { title: '登录失败三次后未触发锁定策略（今日截止）', description: '连续登录失败三次后账号未被锁定，暴力破解防护缺失，今日截止需尽快整改。', status: 'pending', priority: 'urgent', phase: '综合测试 (ST)', subProject: '用户管理子系统', category: '安全漏洞', impactLevel: '严重', impactScope: '影响全部用户', assigneeId: null, reviewerId: 1, departmentId: 2, deadline: dl(0), daysAgo: 0, time: '17:30' },
]

const FLOW = {
  draft: [],
  pending: ['pending'],
  in_progress: ['pending', 'in_progress'],
  pending_confirm: ['pending', 'in_progress', 'pending_confirm'],
  closed: ['pending', 'in_progress', 'pending_confirm', 'closed'],
}

const ATTACH_CONTENT = {
  'report-white-screen.log': '2026-08-0X 13:47:32 ERROR  Uncaught TypeError: Cannot read properties of undefined (reading map)',
  'report-date-filter.log': '2026-08-0X 10:16:01 WARN  default date range resolved to 2026-06-01 ~ 2026-06-30',
  'subscribe-duplicate.log': '2026-08-0X 09:26:40 ERROR  duplicated push job#7821 retried 2 times',
}

async function main() {
  const login = await api('/auth/login', {
    method: 'POST',
    headers: { 'content-type': 'application/json' },
    body: JSON.stringify({ username: 'admin', password: 'Admin@2026' }),
  })
  const token = login.data.accessToken
  console.log('登录成功\n')

  const sql = ['-- generated by seed-7d.mjs']
  const created = []

  for (const [i, it] of issues.entries()) {
    const num = String(i + 1).padStart(2, '0')
    const { status, daysAgo, time, closedDaysAfter, attachments, agent, ...payload } = it
    const res = await api('/issues', {
      method: 'POST',
      headers: auth(token),
      body: JSON.stringify(payload),
    })
    const issue = res.data
    console.log(`[${num}] 创建 ${issue.issueNo} (D-${daysAgo} ${time}) - ${issue.title}`)

    for (const s of FLOW[status] || []) {
      await api(`/issues/${issue.id}/status`, {
        method: 'PATCH',
        headers: auth(token),
        body: JSON.stringify({ status: s, remark: '7天数据流转' }),
      })
    }

    if (attachments && attachments.length) {
      for (const name of attachments) {
        const fd = new FormData()
        fd.append('file', new Blob([ATTACH_CONTENT[name] || name], { type: 'text/plain' }), name)
        await api(`/issues/${issue.id}/attachments`, { method: 'POST', headers: { authorization: `Bearer ${token}` }, body: fd })
        console.log(`     上传附件 ${name}`)
      }
    }

    if (agent) {
      const exec = await api('/agent/execute', {
        method: 'POST',
        headers: auth(token),
        body: JSON.stringify({ issueId: issue.id, goal: agent.goal }),
      })
      const planId = exec.data.planId
      console.log(`     Agent 执行 -> plan#${planId}`)
      if (agent.action === 'reject') {
        await api(`/agent/approval/${planId}/reject`, {
          method: 'POST',
          headers: auth(token),
          body: JSON.stringify({ comment: '方案不适用，请人工处理' }),
        })
        console.log(`     Agent 已驳回 plan#${planId}`)
      } else if (agent.action === 'approve-pending') {
        console.log(`     Agent 审批保持 pending`)
      }
    }

    // 回填 created_at（今天 - daysAgo 天 + time 时刻）
    const [hh, mm, ss = '00'] = time.split(':')
    sql.push(`UPDATE issues SET created_at = date_trunc('day', now()) - interval '${daysAgo} days' + interval '${hh} hours ${mm} minutes ${ss} seconds', updated_at = date_trunc('day', now()) - interval '${daysAgo} days' + interval '${hh} hours ${mm} minutes ${ss} seconds' WHERE id = ${issue.id};`)
    if (closedDaysAfter !== undefined) {
      sql.push(`UPDATE issues SET closed_at = created_at + interval '${closedDaysAfter} days' WHERE id = ${issue.id};`)
    }
    created.push(issue)
  }

  // 回填 issue_logs.created_at（按创建时刻逐条 +30 分钟错开）
  sql.push(`UPDATE issue_logs l SET created_at = i.created_at + (rn.rn * interval '30 minutes') FROM issues i, (SELECT id, row_number() OVER (PARTITION BY issue_id ORDER BY id) rn FROM issue_logs) rn WHERE l.id = rn.id AND l.issue_id = i.id;`)

  const outPath = join(dirname(fileURLToPath(import.meta.url)), 'seed-7d-backdate.sql')
  writeFileSync(outPath, sql.join('\n') + '\n', 'utf8')

  console.log(`\n完成：共创建 ${created.length} 条 7 天数据`)
  console.log(`回填 SQL 已生成：${outPath}`)
  console.log(`请在 WSL 执行：docker exec -i ims-postgres psql -U ims -d ims -v ON_ERROR_STOP=1 < /mnt/c/Users/NB-070/Desktop/work2/ims-master/frontend/scripts/seed-7d-backdate.sql`)
}

main().catch((e) => { console.error('失败:', e.message); process.exit(1) })