space.rb

require 'models/service_space'
require 'models/reservation'
require 'models/event'

get '/:service_space_url_name/?' do
	require_login
	load_service_space

	page = params[:page].to_i
	page = 1 if page.nil? || page <= 0

	reservations = Reservation.joins(:resource).includes(:event).
		where(:resources => {:service_space_id => @space.id}).
		where(:user_id => @user.id).
		where('end_time >= ?', Time.now.midnight).
		order(:start_time).limit(5).offset((page-1)*5)

	total_pages = (Reservation.joins(:resource).includes(:event).
		where(:resources => {:service_space_id => @space.id}).
		where(:user_id => @user.id).
		where('end_time >= ?', Time.now.midnight).count + 4) / 5

	events = Event.includes(:event_type).joins(:event_signups).
		where(:event_signups => {:user_id => @user.id}, :service_space_id => @space.id).
		where('end_time >= ?', Time.now.midnight).
		order(:start_time).all

	erb :space_home, :layout => :fixed, :locals => {
		:reservations => reservations,
		:events => events,
		:total_pages => total_pages,
		:page => page
	}
end