Oxygen Hotel

const checkAvailability = async (req, res) => {
  const { checkIn, checkOut, roomType, guests } = req.body;

  try {
    // Check cache first for performance
    const cacheKey = `availability:${roomType}:${checkIn}:${checkOut}`;
    const cached = await redis.get(cacheKey);
    
    if (cached) {
      return res.json(JSON.parse(cached));
    }

    // Query database for available rooms
    const availableRooms = await Room.findAll({
      where: {
        type: roomType,
        status: 'available',
        maxOccupancy: { [Op.gte]: guests }
      },
      include: [{
        model: Booking,
        where: {
          [Op.or]: [
            {
              checkIn: { [Op.between]: [checkIn, checkOut] }
            },
            {
              checkOut: { [Op.between]: [checkIn, checkOut] }
            }
          ]
        },
        required: false
      }]
    });

    // Filter out booked rooms
    const available = availableRooms.filter(
      room => room.Bookings.length === 0
    );

    // Calculate dynamic pricing
    const pricing = await calculateDynamicPrice({
      roomType,
      checkIn,
      checkOut,
      occupancyRate: available.length / availableRooms.length
    });

    const result = {
      available: available.length > 0,
      roomCount: available.length,
      pricing,
      rooms: available.map(r => ({
        id: r.id,
        number: r.roomNumber,
        amenities: r.amenities,
        view: r.view
      }))
    };

    // Cache result for 5 minutes
    await redis.setex(cacheKey, 300, JSON.stringify(result));

    res.json(result);
  } catch (error) {
    res.status(500).json({ error: 'Availability check failed' });
  }
};