select o.option_id, o.shop_id, o.option_label, o.option_order, o.option_type, q.id as answer_id, q.ans_name, q.ans_price, q.ans_order, d.min, d.max, ifnull(d.event_id, '0') as event_id , ifnull(r.reservation_id, '0') as rid, r.label as text_answer from shop_custom_options o, shop_custom_questions q, shop_dive_options d LEFT OUTER JOIN reservation_options r ON ( r.option_id = d.option_id AND r.reservation_id = #arguments.reservation_id# ) where o.option_id = q.option_id and d.option_id = q.id and d.event_id = #arguments.dive_id# and o.shop_id = #arguments.shop_id# order by o.option_order, q.ans_order #rereplace(ans_name, ' ', ' ')#
#rereplace(ans_name, ' ', ' ')#:
#text_answer#

st = structnew(); st.html = html; st.qry = qryOpts; select * from arguments.qry WHERE reservation_event_id = #arguments.event_id# order by reservation_id,option_id

select dive_start, dive_site_id from shop_dives where dive_id = #arguments.event_id# select * from shop_dive_site where dive_site_id = #qstart.dive_site_id# looptotal = 0; taxable_amount = 0; taxtotal = 0; stMoney[rezQry.reservation_id] = structnew(); reztotal = reztotal + theprice; if (activity_taxable is "1") { taxable_amount = taxable_amount + activity_price; } else if ( isnumeric(arguments.taxrate) AND arguments.taxrate GT 0 AND activity_taxable is "" ) { taxable_amount = taxable_amount + activity_price; } looptotal = theprice; divercount = divercount +1; stMoney[rezQry.reservation_id].fname = user_fname; stMoney[rezQry.reservation_id].lname = user_lname;

Name

Price

Options

#user_fname# #user_lname#

#activity_description# $#theprice#

reztotal = reztotal + price; if (ans_taxable is "1") { taxable_amount = taxable_amount + price; } looptotal = looptotal + price;

#option_label##ans_name#:

#label#

$#price#

Subtotal: $#numberformat(looptotal, '.99')#

Tax: $#taxtotal#

Total W/Tax: $#divertotalwithtax#

st = structnew(); st.qry = rezQry; st.divers = stMoney; st.html = html; st.reztotal = reztotal; st.taxable_amount = taxable_amount; st.divercount = divercount; st.taxtotal = taxtotal; DELETE FROM shop_dive_options where event_id = #arguments.dive_id# str = evaluate('arguments.form.groupcheck_' & ids); fval = evaluate('arguments.form.optioncheck_' & ids); minval = evaluate('arguments.form.min_' & ids); maxval = evaluate('arguments.form.max_' & ids); INSERT INTO shop_dive_options ( event_id, option_id, sortorder, min, max ) VALUES ( #arguments.dive_id#, #oids#, #srt#, #minval#, #maxval# ) DELETE FROM reservation_options where reservation_id = #arguments.reservation_id# select o.option_id, o.shop_id, o.option_label, o.option_order, o.option_type, o.show_outside, q.id as answer_id, q.ans_name, q.ans_price, q.ans_required, q.ans_order, q.sublist, r.subchoice, ifnull(d.event_id, '0') as event_id , ifnull(r.reservation_id, '0') as rid, r.label as text_answer, d.max, d.min from shop_custom_options o, shop_custom_questions q, shop_dive_options d LEFT OUTER JOIN reservation_options r ON ( r.option_id = d.option_id AND r.reservation_id = #arguments.reservation_id# ) where o.option_id = q.option_id and d.option_id = q.id and d.event_id = #arguments.dive_id# and o.shop_id = #arguments.shop_id# and o.show_outside = 1 order by o.option_order, q.ans_order

#option_label#
*Required(#min#)
*For Internal Use Only

checked /> #ans_name# $#ans_price# (#HTMLEditFormat(subchoice)#) #ans_name# *Required

st = structnew(); st.html = html; st.js = js; st.qry = qryOpts;

*For Internal Use Only #option_label#
*Required(#min#)

#ans_name# $#ans_price#

SELECT * FROM shop_option_sublist WHERE sublist_id = #sublist# ORDER BY sublist_option #ans_name# *Required

st = structnew(); st.html = html; st.js = js; select o.option_id, o.shop_id, o.option_label, o.option_order, o.option_type, o.show_outside, q.id as answer_id, q.ans_name, q.ans_price, q.ans_required, q.ans_order, q.sublist, ifnull(d.event_id, '0') as event_id, d.min, d.max from shop_custom_options o, shop_custom_questions q, shop_dive_options d where o.option_id = q.option_id and d.option_id = q.id and d.event_id = #arguments.dive_id# and o.shop_id = #arguments.shop_id# order by o.option_order, q.ans_order

style="background-color:##C0C0C0;">

#option_label#

*For Internal Use Only

*Required(#min#)

#ans_name# $#ans_price# SELECT * FROM shop_option_sublist WHERE sublist_id = #sublist# ORDER BY sublist_option #ans_name#
*Required

st = structnew(); st.ids = lst; st.qry = qryOpts; st.html = html; st.js = js; select o.option_id, o.shop_id, o.option_label, o.option_order, o.option_type, q.id as answer_id, q.ans_name, q.ans_price, q.ans_order, d.min, d.max, ifnull(d.event_id, '0') as event_id , ifnull(r.reservation_id, '0') as rid, r.label as text_answer from shop_custom_options o, shop_custom_questions q, shop_dive_options d LEFT OUTER JOIN reservation_options r ON ( r.option_id = d.option_id AND r.reservation_id = #arguments.reservation_id# ) where o.option_id = q.option_id and d.option_id = q.id and d.event_id = #arguments.dive_id# and o.shop_id = #arguments.shop_id# order by o.option_order, q.ans_order #ans_name#
st = structnew(); st.html = html; st.qry = qryOpts; select user_custom_1, user_custom_2, user_custom_3, user_custom_4 from reservations where reservation_id = #arguments.reservation_id# arr = ArrayNew(1); cntr = 1; gouser = 0; fieldname = "shop_custom_" & i; fieldtype = "shop_custom_" & i & "_type"; tmp = StructNew(); tmp.label = customquestions["#fieldname#"]; tmp.type = customquestions["#fieldtype#"]; tmp.data = ""; userfield = "user_custom_" & i; box = ""; if ( structkeyexists(arguments,'fieldvariable') AND structkeyexists(arguments,'reservation_id') ) { userfield = userfield & '|' & arguments.fieldvariable & '|' & arguments.reservation_id; } else if ( structkeyexists(arguments,'fieldvariable') ) { userfield = userfield & '|' & arguments.fieldvariable; } if ( structkeyexists(arguments, 'reservation_id') ) { qryUser = getUserResInfo(arguments.reservation_id); tmp.data = qryUser["user_custom_#i#"]; gouser = 1; } select shop.shop_custom_1, shop.shop_custom_2, shop.shop_custom_3, shop.shop_custom_4, shop.shop_custom_1_type, shop.shop_custom_2_type, shop.shop_custom_3_type, shop.shop_custom_4_type from shop WHERE shop.shop_id = #arguments.shop_id# SELECT question_num,ans_abrev,ans_name FROM shop_custom_questions WHERE shop_id = #arguments.shop_id# order by question_num,ans_name #dateformat(arguments.qryDive.dive_start, 'mm/dd/yyyy')# #timeformat(arguments.qryDive.dive_time_start, 'short')# #arguments.qryDive.dive_site_name# - #arguments.qryDive.dive_name#

MESSAGE: #arguments.message#

#trim(txt)#

#response_array[i]#

--->