app.get('/api/transaction-records', (req, res) => {
    const { userId, dateRange } = req.query;
    const query = `SELECT * FROM records WHERE user_id = ? AND date BETWEEN ? AND ?`;
    db.query(query, [userId, dateRange.start, dateRange.end], (err, results) => {
        if (err) return res.status(500).send('查询失败');
        res.json(results);
    });
});

app.post('/api/withdraw', (req, res) => {
    const { userId, amount } = req.body;
    if (amount <= 0) return res.status(400).send('金额错误');
    const query = `INSERT INTO withdraw_requests (user_id, amount, status) VALUES (?, ?, 'pending')`;
    db.query(query, [userId, amount], (err) => {
        if (err) return res.status(500).send('申请失败');
        res.send('申请已提交');
    });
});

CREATE DATABASE agent_backend CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE agent_backend;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE withdraw_requests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    requested_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

git clone https://github.com/example/agent-backend-v2.git
cd agent-backend-v2

npm install

{
  "database": {
    "host": "localhost",
    "user": "root",
    "password": "your_password",
    "database": "agent_backend"
  }
}

npm start