SELECT Profiles.ProfileName, Room.*, RoomOption.*, ProfilesRooms.RoomPrice, ProfilesRooms.RoomNumber
FROM Room INNER JOIN (RoomOption INNER JOIN (Profiles INNER JOIN ProfilesRooms ON Profiles.PID = ProfilesRooms.PID) ON RoomOption.OID = ProfilesRooms.OID) ON Room.RID = ProfilesRooms.RID
WHERE Profiles.ProfileName = 'GENERIC' and
Profiles.Location = '#thisHotel#'
ORDER BY Room.RoomName, RoomOption.OptionName
insert into Profiles
(
ProfileName,
Location,
EventName,
EventLocation,
EventDateBegin,
EventDateEnd,
EventDesc,
CreatedBy,
CreatedDate,
Active
)
values
(
'#ProfileName#',
'#thisHotel#',
'#form.EventName#',
'#form.EventLocation#',
#CreateODBCDate(form.EventDateBegin)#,
#CreateODBCDate(form.EventDateEnd)#,
'#form.EventDesc#',
'Website Submission',
#timeStamp#,
TRUE
)
select PID
from Profiles
where CreatedDate = #timeStamp#
insert into ProfilesUsers
(
PID,
GroupName,
UserName,
UserAddress,
UserCity,
UserState,
UserZip,
UserPhone,
UserFAX,
UserEmail,
UserNotes,
UserRoomInfo,
ReservationType,
PaymentType,
ReservationDateBegin,
ReservationDateEnd,
Completed,
SubmittedDate
)
values
(
#GetPid.PID#,
'#form.Groupname#',
'#form.UserName#',
'#form.UserAddress#',
'#form.UserCity#',
'#form.UserState#',
'#form.UserZip#',
'#form.UserPhone#',
'#form.UserFAX#',
'#form.UserEmail#',
'#form.UserNotes#',
'Submitted Generic Request - Rooms Listed in Profile',
'#form.ReservationType#',
'#form.PaymentType#',
#CreateODBCDate(form.ReservationDateBegin)#,
#CreateODBCDate(form.ReservationDateEnd)#,
FALSE,
#CreateODBCDateTime(Now())#
)
select *
from Room
where Location='#thisHotel#' and Active=Yes
select *
from RoomOption
where Location='#thisHotel#' and Active=Yes
SELECT ProfilesRooms.*, Profiles.ProfileName, Profiles.Location
FROM Profiles INNER JOIN ProfilesRooms ON Profiles.PID = ProfilesRooms.PID
WHERE Profiles.ProfileName = 'GENERIC' and
Profiles.Location = '#thisHotel#'
select RoomPrice
from GetGenericPrice
where rid = #curRoomID# and
oid = #oid#
insert into ProfilesRooms
(
PID,
RID,
OID,
RoomPrice,
RoomNumber
)
values
(
#GetPid.PID#,
#curRoomID#,
#oid#,
#GetGenericPriceSpecific.RoomPrice#,
#Evaluate(curFormRoomField)#
)
#form.UserName#,
Your group request for rooms was received on #DateFormat(Now(),"mmmm d")# at #TimeFormat(Now(),"h:mm:ss tt")#.
==============================================
Group: #form.GroupName#
Event: #form.EventName#
Event Location: #form.EventLocation#
Event Dates: #DateFormat(form.EventDateBegin,"mmm d, yyyy")# - #DateFormat(form.EventDateEnd,"mmm d, yyyy")#
Event Description: #form.EventDesc#
Reservation Dates: #form.ReservationDates#
Payment: #ListGetAt(PaymentTypeDesc, ListFind(PaymentTypeList,form.PaymentType))#
Reservation: #ListGetAt(ReservationTypeDesc, ListFind(ReservationTypeList,form.ReservationType))#
#roomListing#
Name: #form.UserName#
Address: #form.UserAddress#, #form.UserState# #form.UserZip#
Phone: #form.UserPhone#
FAX: #form.UserFAX#
Email: #form.UserEmail#
==============================================
A #whoThisMin# representative will be in contact with you shortly.
Sincerely,
#whoThis#
#contactInfo#
Your room request has been successfully submitted.
We have e-mailed you a copy of your request for your records.
Please be aware you have made a room request, not a reservation. A #whoThisMin# representative will contact you within two business days to guarantee your reservation. Thank you for choosing to stay at #whoThisMin#.
Please feel free to call us at #whoThisPhone# if you have any questions or concerns.
#introtext#
Please fill out the form below to request a block of rooms for your group. The sales department will get back to your request as soon as possible.
|
