PagesController

class PagesController < ApplicationController
  def home
    @hotels = Hotel.where(active: true).limit(3)
  end

  def search
    session[:loc_search] = params[:search] if params[:search].present?
    hotels = Hotel.where(active: true)
    hotels = hotels.near(session[:loc_search], 5, order: 'distance') if session[:loc_search].present?

    if (params[:start_date].present? && params[:end_date].present?)
      start_date = Date.parse(params[:start_date])
      end_date = Date.parse(params[:end_date])

      hotels = hotels.left_outer_joins(rooms: [:reservations, :calendars]).where.not(
          "(((reservations.start_date BETWEEN :start_date AND :end_date)
         OR (reservations.end_date BETWEEN :start_date AND :end_date)
         OR (reservations.start_date < :start_date AND :end_date < reservations.end_date))
         AND reservations.status = :status)
         OR (calendars.status = :status AND calendars.day BETWEEN :start_date AND :end_date)",
          { start_date: start_date, end_date: end_date, status: 1 }
        )

    end
    @search = hotels.ransack(params[:q])
    @hotels = @search.result
    Rails.logger.info "=============="
    Rails.logger.info @hotels.count
  end

end