Function getWarehousePrizes

lottery/lottery.ts:244–253

(warehouseName: string)

    ORDER BY order_index
  `);
  return stmt.all(warehouseName);
}

function getNextAvailablePrize(warehouseName: string): any | null {
  if (!db) return null;
  
  const stmt = db.prepare(`
    SELECT * FROM prize_warehouse 
    WHERE warehouse_name = ? AND stock_count > 0 
    ORDER BY order_index 
    LIMIT 1
  `);
  return stmt.get(warehouseName) || null;