285 lines
8.8 KiB
TypeScript
285 lines
8.8 KiB
TypeScript
export const dynamic = 'force-dynamic';
|
||
|
||
import { NextResponse } from 'next/server';
|
||
import { supabase } from '@/lib/supabase';
|
||
|
||
function addDays(date: Date, days: number): string {
|
||
const result = new Date(date);
|
||
result.setDate(result.getDate() + days);
|
||
return result.toISOString().split('T')[0];
|
||
}
|
||
|
||
export async function POST() {
|
||
const today = new Date();
|
||
const todayStr = today.toISOString().split('T')[0];
|
||
|
||
const ownerUser = {
|
||
name: '老板',
|
||
role: 'owner' as const,
|
||
avatar_url: null,
|
||
};
|
||
|
||
const pmUser = {
|
||
name: '张项目经理',
|
||
role: 'pm' as const,
|
||
avatar_url: null,
|
||
};
|
||
|
||
const memberUser = {
|
||
name: '李工程师',
|
||
role: 'member' as const,
|
||
avatar_url: null,
|
||
};
|
||
|
||
const { data: users, error: usersError } = await supabase
|
||
.from('users')
|
||
.insert([ownerUser, pmUser, memberUser])
|
||
.select();
|
||
|
||
if (usersError || !users) {
|
||
return NextResponse.json({ error: usersError?.message || '创建用户失败' }, { status: 500 });
|
||
}
|
||
|
||
const [owner, pm, member] = users;
|
||
|
||
const project1 = {
|
||
name: '产品升级项目',
|
||
description: '核心产品功能升级与优化',
|
||
owner_id: owner.id,
|
||
pm_id: pm.id,
|
||
project_type: '产品研发',
|
||
status: 'green' as const,
|
||
};
|
||
|
||
const project2 = {
|
||
name: '市场拓展计划',
|
||
description: '新市场开拓与客户获取',
|
||
owner_id: owner.id,
|
||
pm_id: pm.id,
|
||
project_type: '市场营销',
|
||
status: 'yellow' as const,
|
||
};
|
||
|
||
const { data: projects, error: projectsError } = await supabase
|
||
.from('projects')
|
||
.insert([project1, project2])
|
||
.select();
|
||
|
||
if (projectsError || !projects) {
|
||
return NextResponse.json({ error: projectsError?.message || '创建项目失败' }, { status: 500 });
|
||
}
|
||
|
||
const [proj1, proj2] = projects;
|
||
|
||
await supabase.from('project_members').insert([
|
||
{ project_id: proj1.id, user_id: owner.id },
|
||
{ project_id: proj1.id, user_id: pm.id },
|
||
{ project_id: proj1.id, user_id: member.id },
|
||
{ project_id: proj2.id, user_id: owner.id },
|
||
{ project_id: proj2.id, user_id: pm.id },
|
||
]);
|
||
|
||
const objective1 = {
|
||
project_id: proj1.id,
|
||
title: '提升产品用户体验和性能',
|
||
description: '通过优化核心功能，提升用户满意度和系统性能',
|
||
period_start: addDays(today, -15),
|
||
period_end: addDays(today, 15),
|
||
created_by: owner.id,
|
||
};
|
||
|
||
const { data: objectives, error: objectivesError } = await supabase
|
||
.from('objectives')
|
||
.insert([objective1])
|
||
.select();
|
||
|
||
if (objectivesError || !objectives) {
|
||
return NextResponse.json({ error: objectivesError?.message || '创建目标失败' }, { status: 500 });
|
||
}
|
||
|
||
const [obj1] = objectives;
|
||
|
||
const krs = [
|
||
{
|
||
project_id: proj1.id,
|
||
objective_id: obj1.id,
|
||
period_type: '1w' as const,
|
||
period_name: '本周',
|
||
period_start: addDays(today, -3),
|
||
period_end: addDays(today, 4),
|
||
title: '完成首页加载速度优化',
|
||
metric_name: '页面加载时间',
|
||
unit: '秒',
|
||
direction: 'decrease' as const,
|
||
target_value: 2,
|
||
current_value: 2.8,
|
||
owner_user_id: member.id,
|
||
confidence: 85,
|
||
status: 'green' as const,
|
||
reason_code: null,
|
||
note: null,
|
||
need_owner_help: false,
|
||
},
|
||
{
|
||
project_id: proj1.id,
|
||
objective_id: obj1.id,
|
||
period_type: '3d' as const,
|
||
period_name: '紧急任务',
|
||
period_start: todayStr,
|
||
period_end: addDays(today, 3),
|
||
title: '修复关键Bug',
|
||
metric_name: 'Bug修复数',
|
||
unit: '个',
|
||
direction: 'increase' as const,
|
||
target_value: 5,
|
||
current_value: 2,
|
||
owner_user_id: member.id,
|
||
confidence: 70,
|
||
status: 'yellow' as const,
|
||
reason_code: 'RESOURCE' as const,
|
||
note: '需要更多测试资源',
|
||
},
|
||
{
|
||
project_id: proj1.id,
|
||
objective_id: obj1.id,
|
||
period_type: '2w' as const,
|
||
period_name: '双周迭代',
|
||
period_start: addDays(today, -7),
|
||
period_end: addDays(today, 7),
|
||
title: '提升用户满意度评分',
|
||
metric_name: 'NPS评分',
|
||
unit: '分',
|
||
direction: 'increase' as const,
|
||
target_value: 50,
|
||
current_value: 35,
|
||
owner_user_id: pm.id,
|
||
confidence: 60,
|
||
status: 'yellow' as const,
|
||
reason_code: 'DEPENDENCY' as const,
|
||
note: '依赖功能还未上线',
|
||
need_owner_help: false,
|
||
},
|
||
{
|
||
project_id: proj2.id,
|
||
objective_id: null,
|
||
period_type: 'monthly' as const,
|
||
period_name: '月度目标',
|
||
period_start: addDays(today, -10),
|
||
period_end: addDays(today, 20),
|
||
title: '新客户获取',
|
||
metric_name: '新签客户数',
|
||
unit: '家',
|
||
direction: 'increase' as const,
|
||
target_value: 10,
|
||
current_value: 3,
|
||
owner_user_id: pm.id,
|
||
confidence: 45,
|
||
status: 'red' as const,
|
||
reason_code: 'EXECUTION' as const,
|
||
note: '市场推广效果不及预期',
|
||
need_owner_help: true,
|
||
},
|
||
];
|
||
|
||
const { data: krsData, error: krsError } = await supabase
|
||
.from('krs')
|
||
.insert(krs)
|
||
.select();
|
||
|
||
if (krsError || !krsData) {
|
||
return NextResponse.json({ error: krsError?.message || '创建KR失败' }, { status: 500 });
|
||
}
|
||
|
||
const checkins = krsData.flatMap((kr) => {
|
||
const baseCheckins = [];
|
||
for (let i = 0; i < 20; i++) {
|
||
const checkinDate = addDays(today, -i - 1);
|
||
const progressMultiplier = (20 - i) / 21;
|
||
baseCheckins.push({
|
||
kr_id: kr.id,
|
||
project_id: kr.project_id,
|
||
user_id: kr.owner_user_id,
|
||
date: checkinDate,
|
||
current_value: kr.current_value * progressMultiplier,
|
||
delta_value: kr.current_value * 0.1,
|
||
confidence: kr.confidence + (i * 5),
|
||
status_snapshot: i === 0 ? kr.status : 'green',
|
||
reason_code: i === 0 ? kr.reason_code : null,
|
||
note: i === 0 ? `进度更新 - ${kr.title}` : null,
|
||
});
|
||
}
|
||
return baseCheckins;
|
||
});
|
||
|
||
await supabase.from('checkins').insert(checkins);
|
||
|
||
const meeting = {
|
||
project_id: proj1.id,
|
||
period_start: addDays(today, -7),
|
||
period_end: addDays(today, -1),
|
||
summary: `本周期完成情况总结：
|
||
- 页面加载优化进展顺利，预计可按时完成
|
||
- Bug修复进度略有滞后，需要协调测试资源
|
||
- 用户满意度提升依赖新功能上线
|
||
|
||
完成率：约65%`,
|
||
decisions: `1. 协调测试团队支援Bug修复
|
||
2. 推动依赖功能优先上线
|
||
3. 下周进行用户回访收集反馈`,
|
||
risks: `- 测试资源紧张可能影响交付质量
|
||
- 依赖功能延期风险`,
|
||
next_period_commitments: `- 完成所有关键Bug修复
|
||
- 页面加载时间降至2秒以内
|
||
- 收集至少20份用户反馈`,
|
||
created_by: pm.id,
|
||
};
|
||
|
||
await supabase.from('meetings').insert([meeting]);
|
||
|
||
const metrics = [
|
||
{ name: '页面加载时间', unit: '秒', direction: 'decrease' as const, category: '技术性能' },
|
||
{ name: 'Bug修复数', unit: '个', direction: 'increase' as const, category: '质量' },
|
||
{ name: 'NPS评分', unit: '分', direction: 'increase' as const, category: '用户体验' },
|
||
{ name: '新签客户数', unit: '家', direction: 'increase' as const, category: '业务' },
|
||
{ name: '活跃用户数', unit: '人', direction: 'increase' as const, category: '业务' },
|
||
{ name: '客户流失率', unit: '%', direction: 'decrease' as const, category: '业务' },
|
||
{ name: '代码覆盖率', unit: '%', direction: 'increase' as const, category: '质量' },
|
||
{ name: '响应时间', unit: 'ms', direction: 'decrease' as const, category: '技术性能' },
|
||
];
|
||
|
||
await supabase.from('metrics').insert(metrics);
|
||
|
||
const templates = [
|
||
{
|
||
name: '产品迭代模板',
|
||
description: '适用于产品功能迭代的KR模板',
|
||
project_type: '产品研发',
|
||
tags: ['产品', '迭代', '功能'],
|
||
items: [
|
||
{ title: '功能上线', metricName: '功能完成数', unit: '个', direction: 'increase', targetValue: 3 },
|
||
{ title: '性能优化', metricName: '响应时间', unit: 'ms', direction: 'decrease', targetValue: 200 },
|
||
{ title: '质量保障', metricName: 'Bug数', unit: '个', direction: 'decrease', targetValue: 5 },
|
||
],
|
||
},
|
||
{
|
||
name: '市场拓展模板',
|
||
description: '适用于市场营销项目的KR模板',
|
||
project_type: '市场营销',
|
||
tags: ['市场', '营销', '客户'],
|
||
items: [
|
||
{ title: '客户获取', metricName: '新客户数', unit: '家', direction: 'increase', targetValue: 10 },
|
||
{ title: '线索转化', metricName: '转化率', unit: '%', direction: 'increase', targetValue: 30 },
|
||
{ title: '客户留存', metricName: '续约率', unit: '%', direction: 'increase', targetValue: 85 },
|
||
],
|
||
},
|
||
];
|
||
|
||
await supabase.from('templates').insert(templates);
|
||
|
||
return NextResponse.json({
|
||
success: true,
|
||
ownerId: owner.id,
|
||
message: '演示数据已成功创建',
|
||
});
|
||
}
|