5 年前端|企业官网··活动落地页··后台管理系统

export function createOrder(input: {
  customerId: number;
  productId: number;
  qty: number;
  amount: number;
  status?: OrderStatus;
}) {
  const db = getDb();

  // 1. 先校验商品存在
  const product = db
    .prepare("SELECT id, name, price, stock FROM products WHERE id = ?")
    .get(input.productId);
  if (!product) throw new Error("商品不存在");

  // 2. 真写订单主表
  const res = db.prepare(
    `INSERT INTO orders (order_no, customer_id, product_id,
       product_name, qty, amount, status, created_at)
     VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,
  ).run(orderNo, customer.id, product.id, product.name,
       input.qty, amount, status, now.toISOString());

  const orderId = Number(res.lastInsertRowid);

  // 3. 同步商品销量与客户消费额
  db.prepare(
    "UPDATE products SET sales = sales + ?, stock = MAX(stock - ?, 0) WHERE id = ?",
  ).run(input.qty, input.qty, product.id);
  db.prepare(
    "UPDATE customers SET total_spend = total_spend + ?, order_count = order_count + 1 WHERE id = ?",
  ).run(amount, customer.id);

  // 4. 记一条操作日志，后台可查
  writeLog("管理员 · 陈澜", "创建订单", orderNo, `登记了订单 ${orderNo}`);

  return getOrderDetail(orderId);
}