Function addPrizeToWarehouse

lottery/lottery.ts:172–204

(warehouseName: string, prizeText: string, stock: number)

    WHERE warehouse_name = ? AND prize_text = ?
  `).get(warehouseName, prizeText) as any;
  
  if (existingPrize) {
    // Update existing prize stock
    const updateStmt = db.prepare(`
      UPDATE prize_warehouse 
      SET stock_count = stock_count + ? 
      WHERE id = ?
    `);
    updateStmt.run(stock, existingPrize.id);
  } else {
    // Get next order index for new prize
    const maxOrderStmt = db.prepare(`
      SELECT COALESCE(MAX(order_index), 0) + 1 as next_order 
      FROM prize_warehouse WHERE warehouse_name = ?
    `);
    const nextOrder = (maxOrderStmt.get(warehouseName) as any)?.next_order || 1;
    
    // Insert new prize
    const stmt = db.prepare(`
      INSERT INTO prize_warehouse (warehouse_name, prize_text, stock_count, order_index, created_at)
      VALUES (?, ?, ?, ?, ?)
    `);
    stmt.run(warehouseName, prizeText, stock, nextOrder, Date.now());
  }
}

function getPrizeWarehouses(): string[] {
  if (!db) return [];
  
  const stmt = db.prepare(`
    SELECT DISTINCT warehouse_name FROM prize_warehouse 
    ORDER BY warehouse_name
  `);
  return stmt.all().map((row: any) => row.warehouse_name);
}