Function getNextAvailablePrize

lottery/lottery.ts:255–265

(warehouseName: string)

    WHERE warehouse_name = ? AND stock_count > 0 
    ORDER BY order_index 
    LIMIT 1
  `);
  return stmt.get(warehouseName) || null;
}

function consumePrize(prizeId: number): boolean {
  if (!db) return false;
  
  const stmt = db.prepare(`
    UPDATE prize_warehouse 
    SET stock_count = stock_count - 1 
    WHERE id = ? AND stock_count > 0
  `);
  const result = stmt.run(prizeId);