GongFuServer/webServer/src/model/OrderModel.ts

import { query } from '../sql/query'; // 确保路径是正确的

class OrderModel {
    //获取订单
    async getOrder(order_id: any) {
        return await query(`SELECT * FROM game_order WHERE order_id = '${order_id}'`)
    }

    //添加订单
    async createOrder(
        orderId: any,
        uid: any,
        level: any,
        amount: any,
        role_id: any,
        role_name: any,
        product_id: any,
        create_time: string
    ) {
        return await query(`INSERT INTO game_order(order_id, uid, level,amount,role_id,role_name,product_id,create_time) VALUES('${orderId}', '${uid}', '${level}', '${amount}', '${role_id}', '${role_name}','${product_id}', '${create_time}')`)
    }

    async updateOrderStats(
        orderId: any,
        status: any,
        update_time: string
    ) {

        const sql = 'UPDATE game_order SET status = ?, update_time = ? WHERE order_id = ?';
        return await query(sql, [status, update_time, orderId])
    }
}

module.exports = new OrderModel()