// 语言判定伪代码
function determineLanguage(user: User, req: Request): 'zh-CN' | 'en-US' {
  if (user?.language) return user.language;
  if (req.cookies.lang) return req.cookies.lang;
  if (req.headers['accept-language']?.startsWith('zh')) return 'zh-CN';
  
  const geo = geoip.lookup(req.ip);
  if (geo?.country === 'CN') return 'zh-CN';
  return 'en-US';
}

interface ProjectSpec {
  // 基础信息
  name: string;                  // 项目名
  scenario: 'new' | 'refactor';  // 场景
  description: string;           // 一句话描述
  
  // 技术栈
  frontend: {
    framework: 'nextjs' | 'vite-react' | 'nuxt' | 'svelte';
    language: 'typescript' | 'javascript';
    styling: 'tailwind' | 'css-modules' | 'styled-components';
    ui: 'shadcn' | 'antd' | 'mui' | 'none';
  };
  backend: {
    runtime: 'node' | 'python' | 'go' | 'none';
    framework: 'express' | 'nestjs' | 'fastapi' | 'none';
    database: 'postgres' | 'mysql' | 'sqlite' | 'mongodb' | 'none';
    orm: 'prisma' | 'typeorm' | 'drizzle' | 'none';
  };
  deployment: {
    target: 'vercel' | 'docker' | 'pm2' | 'none';
    cicd: 'github-actions' | 'none';
  };
  
  // 功能清单
  features: Array<{
    name: string;
    description: string;
    priority: 'must' | 'should' | 'could';
  }>;
  
  // 业务规则
  businessRules: string;  // 自由文本
  
  // 约束
  constraints: {
    performance?: string;  // "首屏 < 1s"
    security?: string;     // "需要 HTTPS / CSP"
    compatibility?: string; // "兼容 Chrome 90+"
  };
  
  // 附加(自由 Markdown)
  additionalNotes: string;
}

// 生成服务接口
interface CodeGenerator {
  // 首版生成
  generateFirstVersion(spec: ProjectSpec): Promise<{
    fileTree: FileNode[];
    zipUrl: string;
    creditsUsed: number;
  }>;
  
  // 后续 API 调用(改/补/重构)
  callApi(
    projectId: number,
    action: 'modify' | 'add' | 'refactor',
    target: string,        // 文件路径
    instruction: string
  ): Promise<{
    newContent: string;    // 新文件内容
    diff?: string;         // 差异
    creditsUsed: number;
  }>;
  
  // 解析存量项目
  parseExistingProject(zipUrl: string): Promise<{
    spec: Partial<ProjectSpec>;  // 自动推断的规格
    suggestedImprovements: string[];
  }>;
}

// 续作 API 设计
POST /api/v1/projects/:id/generate
{
  "action": "modify" | "add_feature" | "refactor" | "explain",
  "target_files": ["src/api/user.ts"],  // 涉及文件
  "instruction": "给用户 API 加上分页参数,每页 20 条",
  "context": {  // 可选上下文
    "currentSpec": {...}
  }
}
 
Response:
{
  "status": "success",
  "creditsUsed": 10,
  "newFiles": [
    {
      "path": "src/api/user.ts",
      "content": "...",
      "diff": "@@ -10,3 +10,15 @@..."
    }
  ],
  "explanation": "在 listUsers API 中添加了 page 和 pageSize 参数...",
  "remainingCredits": 150
}

-- 1. 用户表
CREATE TABLE users (
  id BIGSERIAL PRIMARY KEY,
  email VARCHAR(255) UNIQUE,
  phone VARCHAR(20) UNIQUE,
  password_hash VARCHAR(255),
  nickname VARCHAR(50),
  avatar_url TEXT,
  language VARCHAR(10) DEFAULT 'zh-CN',
  timezone VARCHAR(50) DEFAULT 'Asia/Shanghai',
  last_login_ip INET,
  oauth_provider VARCHAR(20),  -- 'google'/'github'/'wechat'
  oauth_id VARCHAR(255),
  is_banned BOOLEAN DEFAULT FALSE,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
 
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_users_phone ON users(phone);
 
-- 2. 钱包/积分表
CREATE TABLE wallets (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT UNIQUE NOT NULL REFERENCES users(id),
  credits_remaining INT DEFAULT 0,
  credits_total INT DEFAULT 0,  -- 历史总获得
  credits_used INT DEFAULT 0,   -- 历史总消耗
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
 
-- 3. 订阅表
CREATE TABLE subscriptions (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT NOT NULL REFERENCES users(id),
  plan_type VARCHAR(20) NOT NULL,  -- 'monthly'/'yearly'
  status VARCHAR(20) NOT NULL,     -- 'active'/'expired'/'cancelled'
  start_at TIMESTAMPTZ NOT NULL,
  end_at TIMESTAMPTZ NOT NULL,
  price_paid DECIMAL(10,2),
  payment_channel VARCHAR(20),     -- 'wechat'/'alipay'/'stripe'
  external_order_id VARCHAR(255),  -- 支付平台订单号
  created_at TIMESTAMPTZ DEFAULT NOW()
);
 
CREATE INDEX idx_subs_user_status ON subscriptions(user_id, status);
 
-- 4. 项目表
CREATE TABLE projects (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT NOT NULL REFERENCES users(id),
  name VARCHAR(100) NOT NULL,
  scenario VARCHAR(20) NOT NULL,    -- 'new'/'refactor'
  spec JSONB NOT NULL,             -- 完整 SDD 规格
  generated_files JSONB,           -- 生成的 file tree
  zip_url TEXT,                    -- OSS 下载链接
  zip_expires_at TIMESTAMPTZ,      -- 链接过期时间
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
 
CREATE INDEX idx_projects_user ON projects(user_id, created_at DESC);
 
-- 5. 生成日志表
CREATE TABLE generation_logs (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT NOT NULL REFERENCES users(id),
  project_id BIGINT REFERENCES projects(id),
  action VARCHAR(20) NOT NULL,      -- 'first_gen'/'api_call'/'refactor'
  credits_used INT NOT NULL,
  prompt JSONB,
  response JSONB,
  duration_ms INT,
  status VARCHAR(20) DEFAULT 'success',  -- 'success'/'failed'
  error_message TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
 
CREATE INDEX idx_logs_user_date ON generation_logs(user_id, created_at DESC);

-- 支付订单表
CREATE TABLE payment_orders (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT REFERENCES users(id),
  order_type VARCHAR(20) NOT NULL,  -- 'buyout'/'subscription'/'credits'
  amount DECIMAL(10,2) NOT NULL,
  status VARCHAR(20) NOT NULL,      -- 'pending'/'paid'/'refunded'
  payment_channel VARCHAR(20),
  external_order_id VARCHAR(255),
  paid_at TIMESTAMPTZ,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
 
-- 积分流水表(对账用)
CREATE TABLE credit_transactions (
  id BIGSERIAL PRIMARY KEY,
  user_id BIGINT REFERENCES users(id),
  delta INT NOT NULL,                -- +/- 积分变化
  reason VARCHAR(50) NOT NULL,       -- 'buyout_bonus'/'subscription'/'consume'/'refund'
  related_id BIGINT,                 -- 关联订单/项目 ID
  created_at TIMESTAMPTZ DEFAULT NOW()
);
 
-- 模板库表
CREATE TABLE spec_templates (
  id BIGSERIAL PRIMARY KEY,
  name VARCHAR(100),
  category VARCHAR(50),              -- 'saas'/'ecommerce'/'blog'...
  scenario VARCHAR(20),              -- 'new'/'refactor'
  spec JSONB,
  is_public BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

// AI 模型路由(国内/海外分开)
interface ModelRouter {
  domestic: {
    // 中文任务,代码生成质量已足够
    default: 'deepseek-v3';          // 最便宜
    premium: 'MiniMax-m3';    // 高质量
  };
  international: {
    // 英文任务或高质量要求
    default: 'claude-sonnet-5';
    premium: 'claude-opus-4-8';
  };
}
 
function selectModel(spec: ProjectSpec, userRegion: string): string {
  if (userRegion === 'CN') {
    return spec.complexity === 'high' ? 'MiniMax-m3' : 'deepseek-v3';
  }
  return spec.complexity === 'high' ? 'claude-opus-4-8' : 'claude-sonnet-5';
}

// 关键代码:积分扣减必须用数据库行锁
async function consumeCredits(userId: number, amount: number, reason: string) {
  return await prisma.$transaction(async (tx) => {
    // 1. 行锁查询
    const wallet = await tx.$queryRaw<Wallet[]>`
      SELECT * FROM wallets WHERE user_id = ${userId} FOR UPDATE
    `;
    
    if (wallet[0].credits_remaining < amount) {
      throw new InsufficientCreditsError();
    }
    
    // 2. 扣减
    await tx.wallets.update({
      where: { user_id: userId },
      data: { credits_remaining: { decrement: amount } }
    });
    
    // 3. 流水记录
    await tx.credit_transactions.create({
      data: {
        user_id: userId,
        delta: -amount,
        reason,
        created_at: new Date()
      }
    });
  });
}

// packages/shared-types/src/index.ts
export interface ProjectSpec {
  // ... 完整定义
}
 
export interface GenerationRequest {
  projectId: number;
  action: 'modify' | 'add' | 'refactor';
  target: string;
  instruction: string;
}
 
export interface GenerationResponse {
  status: 'success' | 'failed';
  creditsUsed: number;
  newFiles: Array<{
    path: string;
    content: string;
    diff?: string;
  }>;
  explanation: string;
  remainingCredits: number;
}