账号管理与兑换平台：三端架构复盘

┌─────────────────────────────────────────────┐
│              生产服务器 198.51.100.10      │
│                                             │
│  ┌───────────┐  ┌───────────┐  ┌──────────┐ │
│  │  Client   │  │   Admin   │  │  Backend │ │
│  │  Frontend │  │ Frontend  │  │  Server  │ │
│  │  :5174    │  │  :5173    │  │  :3000   │ │
│  └─────┬─────┘  └─────┬─────┘  └────┬─────┘ │
│        │              │              │       │
│        └──────────────┴──────────────┘       │
│                       │                      │
│                 ┌─────▼─────┐                │
│                 │   MySQL   │                │
│                 └───────────┘                │
└─────────────────────────────────────────────┘

CREATE TABLE users (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  email VARCHAR(100),
  role ENUM('admin', 'agent', 'client') DEFAULT 'client',
  status ENUM('active', 'disabled') DEFAULT 'active',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE cursor_accounts (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(100) NOT NULL UNIQUE,
  password VARCHAR(255) NOT NULL,
  plan_type ENUM('free', 'pro', 'business') DEFAULT 'pro',
  status ENUM('available', 'used', 'expired') DEFAULT 'available',
  agent_id INT UNSIGNED,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (agent_id) REFERENCES users(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE card_keys (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  key_code VARCHAR(64) NOT NULL UNIQUE,
  account_id INT UNSIGNED NOT NULL,
  status ENUM('unused', 'redeemed', 'expired') DEFAULT 'unused',
  redeemed_by INT UNSIGNED,
  redeemed_at TIMESTAMP NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (account_id) REFERENCES cursor_accounts(id),
  FOREIGN KEY (redeemed_by) REFERENCES users(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE redemption_records (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id INT UNSIGNED NOT NULL,
  card_key_id INT UNSIGNED NOT NULL,
  account_id INT UNSIGNED NOT NULL,
  redeemed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id),
  FOREIGN KEY (card_key_id) REFERENCES card_keys(id),
  FOREIGN KEY (account_id) REFERENCES cursor_accounts(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE sessions (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id INT UNSIGNED NOT NULL,
  token VARCHAR(512) NOT NULL,
  expires_at TIMESTAMP NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

{
  "code": 0,
  "message": "success",
  "data": { }
}

// routes/redeem.js
const express = require('express');
const router = express.Router();
const jwt = require('jsonwebtoken');
const db = require('../db');

// POST /api/redeem
router.post('/', authenticateToken, async (req, res) => {
  const userId = req.user.id;
  const { keyCode } = req.body;

  if (!keyCode) {
    return res.json({ code: 1, message: '卡密不能为空' });
  }

  const connection = await db.getConnection();
  try {
    await connection.beginTransaction();

    // 1. 查询卡密是否存在且未使用
    const [keys] = await connection.execute(
      'SELECT * FROM card_keys WHERE key_code = ? AND status = "unused" FOR UPDATE',
      [keyCode]
    );

    if (keys.length === 0) {
      await connection.rollback();
      return res.json({ code: 1, message: '卡密无效或已被使用' });
    }

    const cardKey = keys[0];

    // 2. 更新卡密状态
    await connection.execute(
      'UPDATE card_keys SET status = "redeemed", redeemed_by = ?, redeemed_at = NOW() WHERE id = ?',
      [userId, cardKey.id]
    );

    // 3. 更新账号状态为已使用
    await connection.execute(
      'UPDATE cursor_accounts SET status = "used" WHERE id = ?',
      [cardKey.account_id]
    );

    // 4. 写入兑换记录
    await connection.execute(
      'INSERT INTO redemption_records (user_id, card_key_id, account_id) VALUES (?, ?, ?)',
      [userId, cardKey.id, cardKey.account_id]
    );

    await connection.commit();
    // 简化示意：先提交，再发通知；生产应考虑可靠 outbox/队列
    sendRedeemEmail(userId, cardKey.account_id).catch(console.error);
    res.json({
      code: 0,
      message: '兑换成功',
      data: { accountId: cardKey.account_id }
    });
  } catch (err) {
    await connection.rollback();
    console.error('Redeem error:', err);
    res.json({ code: 1, message: '服务器错误' });
  } finally {
    connection.release();
  }
});

module.exports = router;

// 账号列表示例（简化版）
import { Table, Button, Tag, Space, message } from 'antd';
import { useEffect, useState } from 'react';
import axios from 'axios';

const AccountList = () => {
  const [data, setData] = useState([]);
  const [loading, setLoading] = useState(false);
  const [pagination, setPagination] = useState({ current: 1, pageSize: 20, total: 0 });

  const fetchData = async (page = 1, pageSize = 20) => {
    setLoading(true);
    try {
      const res = await axios.get('/api/accounts', {
        params: { page, pageSize },
        headers: { Authorization: `Bearer ${localStorage.getItem('token')}` }
      });
      setData(res.data.data.list);
      setPagination({ ...pagination, current: page, pageSize, total: res.data.data.total });
    } catch (err) {
      message.error('加载失败');
    } finally {
      setLoading(false);
    }
  };

  useEffect(() => { fetchData(); }, []);

  const columns = [
    { title: '邮箱', dataIndex: 'email', key: 'email' },
    { title: '套餐', dataIndex: 'plan_type', key: 'plan' },
    {
      title: '状态',
      dataIndex: 'status',
      key: 'status',
      render: (status) => (
        <Tag color={status === 'available' ? 'green' : status === 'used' ? 'orange' : 'red'}>
          {status === 'available' ? '可用' : status === 'used' ? '已使用' : '已过期'}
        </Tag>
      )
    },
    { title: '创建时间', dataIndex: 'created_at', key: 'created_at' },
    {
      title: '操作',
      key: 'action',
      render: (_, record) => (
        <Space>
          <Button size="small" onClick={() => handleEdit(record)}>编辑</Button>
          <Button size="small" danger onClick={() => handleDelete(record)}>删除</Button>
        </Space>
      )
    },
  ];

  return (
    <Table
      columns={columns}
      dataSource={data}
      loading={loading}
      rowKey="id"
      pagination={pagination}
      onChange={(p) => fetchData(p.current, p.pageSize)}
    />
  );
};

## 安装 Node.js 20
curl -fsSL https://deb.nodesource.com/setup_20.x | sudo bash -
sudo apt install -y nodejs

## 安装 PM2
npm install -g pm2

## /etc/nginx/sites-available/getcode
server {
    listen 80;
    server_name app.example.com;

    root /var/www/client-frontend/dist;
    index index.html;

    location / {
        try_files $uri $uri/ /index.html;
    }
}

## /etc/nginx/sites-available/getcodeadmin
server {
    listen 80;
    server_name admin.example.com;

    root /var/www/admin-frontend/dist;
    index index.html;

    location / {
        try_files $uri $uri/ /index.html;
    }
}

## /etc/nginx/sites-available/api
server {
    listen 80;
    server_name app.example.com;

    location /api/ {
        proxy_pass http://127.0.0.1:3000;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }
}

## 启动后端
cd /var/www/backend
pm2 start app.js --name cursor-api

## 设置开机自启
pm2 save
pm2 startup

sudo apt install certbot python3-certbot-nginx
sudo certbot --nginx -d app.example.com -d admin.example.com

const pool = mysql.createPool({
  host: 'localhost',
  user: 'cursor_app',
  password: process.env.DB_PASSWORD,
  database: 'cursor_management',
  waitForConnections: true,
  connectionLimit: 20,
  queueLimit: 0
});