https://www.ellipsecloud.com/

Search Ellipse hotels

Search the gateway registry (mpc_tenants). Text uses FULLTEXT index ft_hotel_search when available (MATCH on hotel_name, aliases, keywords, short_description, tourist_locality, city — NATURAL LANGUAGE MODE), otherwise word-by-word LIKE across those fields (stop-words like short prepositions are stripped). tags[] filter the JSON tags column via JSON_OVERLAPS when the server supports it, else JSON_CONTAINS. facilities[] are property_facility slugs: preferred path is EXISTS on mpc_tenant_facility;

Get hotel profile

Returns hotel description, amenities, location, rooms preview with image URLs/galleries for AI thumbnails, and supported booking tools.

Check hotel availability and rates

Live availability and rates. Always send hotel_id + adults (≥1). Dates: either canonical arrival + nights (1–30), OR arrival + exclusive departure day, OR date_from + date_to / check_in + check_out / start_date + end_date, OR any arrival synonym + nights. Checkout day is exclusive (same as Ellipse web booking URLs).

Search stays across hotels (central index)

Fast cross-hotel stay search using precomputed mpc_stay_offer_index (ARI snapshot). Combines registry filters (query, country, tags[], facilities[]) with arrival + nights + adults. Returns ranked stays by price_total without live PMS fan-out. Use check_availability on one hotel_id before booking. Rebuild index via cron rebuild_stay_offer_index.php or automatically after pricing push.

Search daily rates (MCP DB snapshot)

Reads mpc_ari_rate_day rows synced from Ellipse pricing push: per-day price_web vs price_chm by room_internal_id (no live PMS). Use scopes rates.read.web / rates.read.cm. Prefer check_availability for bookable quotes and inventory. Set include_stay_breakdown=true (+ arrival, nights, adults, optional children[]) to add lodging_subtotal + mandatory_fees snapshot + grand_total.

Get hotel offers / packages

Returns active offer packages for a hotel. Required: hotel_id. Optional arrival/departure (YYYY-MM-DD, exclusive checkout) narrows packages that apply to a stay.

Get price quote and booking link

Precise quote for a chosen room/rate and dates. Required: hotel_id, arrival (YYYY-MM-DD first night), departure (exclusive checkout day YYYY-MM-DD), adults (1–10). Optional children ages and rate selectors from check_availability.

Find cheaper stay periods (flex calendar)

Samples future check-in dates and ranks cheap periods. Required: hotel_id, adults (1–10). Optional: nights (default 2), horizon_days, room_type_id, pricing_model. Children are not priced in flex_calendar — call price_quote for exact totals.

List gift vouchers for sale

Lists purchasable gift vouchers. Required: hotel_id only.

List active price drops across hotels

Returns hotels with active price drop alerts (mpc_price_alerts) — daily prices that fell ≥15% below the 30-day median for the same room/rate. Tiers: mild (⚡ 15–24%), strong (🔥 25–39%), huge (💸 40%+). Aggregated as one entry per hotel-day (top alert kept). Useful for "deals" / "kde sú zľavy" / "lacný pobyt". Filters by country, region, tags, tier, min_drop_pct, date window, optional single hotel_id.

Timi/Tomi services catalog & time slots

Timi/Tomi spa services: omit service_id or use 0 for catalog; set service_id≥1 and date (YYYY-MM-DD) for available start times that day.

List hotel FAQ pairs

Returns the hotel's manually curated FAQ pairs (question + answer) — used for the public FAQ section on the portal page (with FAQPage JSON-LD) and AI chat. Required: hotel_id. Optional: language (default sk), category, limit (1–200, default 50). Returns items[] with question, answer, category, sort_order; falls back to sk if requested language has no entries.