<Cfquery name="getcoupon" datasource="#ds#">
select *  from liveeventpackages
    where id = #url.id#
</cfquery>
<!---
<cfif (#url.id# eq 6 or #url.id# eq 7) and not parameterexists(url.order)>
    <cflocation url="event-wait.cfm?id=#url.id#" addtoken="no">
</cfif>--->

<cfif parameterexists(url.article)>
    <Cfset url.id = #getcoupon.id#>
</cfif>
<cfsavecontent variable="headercontent">
<title><cfoutput>#getcoupon.package# - Women in Tourism</cfoutput></title>
<meta property="og:image"              content="https://www.cityguideny.com/uploads2/156894/files/Tourism-is-Back.png" />


</cfsavecontent>

<Cfinclude template="/header.cfm">
<cfinclude template="/rossavings.cfm">

    <main>
	            <div class="white_bg" >
            <div class="container margin_60" style="max-width: 800px;">
               <!--- <div class="main_title">
                    <h2>Order</span></h2>
                </div>
                --->
                <cfinclude template="css.htm">

                
                	  
	        <Cfif parameterexists(url.process)>

<Cfquery name="getcoupon" datasource="#ds#">
select *  from liveeventpackages
    where id = #url.id#

</cfquery>

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>


<Cfparam name="form.adultsquantity" default="0">
    
    <cfif #form.adultsquantity# gt 0>
        <cfset totalq = form.adultsquantity>
<cfelse>
    <cfset totalq = getcoupon.numtickets>
</cfif>


<Cfparam name="form.kidsquantity" default="0">
<Cfparam name="form.seniorquantity" default="0">
<Cfparam name="form.otherquantity" default="0">
<Cfparam name="form.ccnum" default="1234">

<Cfparam name="form.password" default="">
<Cfparam name="form.saver" default="">
<Cfparam name="form.subber" default="">

<cfset totalq = 0>

<cfif #form.adultsquantity# gt 0>
<Cfif #form.adultsquantity# eq 1><Cfset total = 195></cfif>
<Cfif #form.adultsquantity# eq 2><Cfset total = 390></cfif>
<Cfif #form.adultsquantity# eq 3><Cfset total = 585></cfif>
<Cfif #form.adultsquantity# eq 4><Cfset total = 780></cfif>
<Cfif #form.adultsquantity# eq 5><Cfset total = 975></cfif>
<Cfif #form.adultsquantity# eq 6><Cfset total = 1170></cfif>
<Cfif #form.adultsquantity# eq 7><Cfset total = 1365></cfif>
<Cfif #form.adultsquantity# eq 8><Cfset total = 1560></cfif>
<cfelse>
<Cfset total = #getcoupon.price#>
</cfif>




         <!---  <cfif parameterexists(form.coupon)>
                <cfquery name="upds" dataSource="#ds#">
                    update cgdirectorycoupons set usedtickets = usedtickets + #totalq#
                    where couponcode = '#form.coupon#'
                </cfquery>
                </cfif>    --->
                
 <cfif parameterexists(form.coupon)><Cfset codeused = '#form.coupon#'><cfelse><cfset codeused = ''></cfif>
 
<cfif #total# eq 0>
    <Cfset approved = 'on'>
</cfif>

<cfif parameterexists(form.ccnum) and #form.ccnum# eq '1234'>
        <Cfset approved = 'on'>

</cfif>



<Cfquery name="checkdupe" dataSource="cityguide">
    select email from liveeventorder  where email = '#form.email#'
</Cfquery>
                     <Cfif #checkdupe.recordcount# gt 10000><br><Br>
                         Error, you've already registered. Please contact [email protected] for help. </div><br><Br></div><Cfabort>
                        </cfif> 

<!----<Cfset approved = 'on'> ColdFusion's cfhttp object is specifically designed to create a post,
and retrieve the results.  Those results are accessed in cfhttp.filecontent --->
<!--- By default, this sample code is designed to post to our test server
for developer accounts: https://test.authorize.net/gateway/transact.dll
for real accounts (even in test mode), please make sure that you are\posting to: https://secure.authorize.net/gateway/transact.dll --->
<cfhttp method="Post" url="https://secure.authorize.net/gateway/transact.dll ">
	<!--- the API Login ID and Transaction Key must be replaced with valid values --->
	<cfhttpparam type="Formfield" name="x_login" value="5U8ra7ayMS4u">
	<cfhttpparam type="Formfield" name="x_tran_key" value="7aw5VqK99Ye327F2">

	<cfhttpparam type="Formfield" name="x_delim_data" value="TRUE">
	<cfhttpparam type="Formfield" name="x_delim_char" value="|">
	<cfhttpparam type="Formfield" name="x_relay_response" value="FALSE">
	<cfhttpparam type="Formfield" name="x_test_request" value="FALSE">

	<cfhttpparam type="Formfield" name="x_type" value="AUTH_CAPTURE">
	<cfhttpparam type="Formfield" name="x_method" value="CC">
	<cfhttpparam type="Formfield" name="x_card_num" value="#form.ccnum#">
	<cfhttpparam type="Formfield" name="x_exp_date" value="#form.ccexpire#">

	<cfhttpparam type="Formfield" name="x_amount" value="#total#">
	<cfhttpparam type="Formfield" name="x_description" value="CG WIT Order - #getcoupon.package#">

	<cfhttpparam type="Formfield" name="x_first_name" value="#form.firstname#">
	<cfhttpparam type="Formfield" name="x_last_name" value="#form.lastname#">
	<cfhttpparam type="Formfield" name="x_address" value="#form.address#">
	<cfhttpparam type="Formfield" name="x_state" value="#form.state#">
	<cfhttpparam type="Formfield" name="x_zip" value="#form.zip#">
	<!--- Additional fields can be added here as outlined in the AIM integration
	guide at: http://developer.authorize.net --->
	<!--- The following fields show an example of how to include line item details, they are commented out by default.
	<cfhttpparam type="Formfield" name="x_line_item" value="item1<|>golf balls<|><|>2<|>18.95<|>Y">
	<cfhttpparam type="Formfield" name="x_line_item" value="item2<|>golf bag<|>Wilson golf carry bag, red<|>1<|>39.99<|>Y">
	<cfhttpparam type="Formfield" name="x_line_item" value="item3<|>book<|>Golf for Dummies<|>1<|>21.99<|>Y">
	--->
</cfhttp>
<!--- Because coldfusion's ListToArray object ignores empty fields, we must
put a space in all empty fields to make sure that they are not skipped --->
<cfset post_response=Replace(cfhttp.filecontent,"||","| |", "all")>
<!--- the same command is run twice, because the first time it only adjusts
every other empty field --->
<cfset post_response=Replace(post_response,"||","| |", "all")>

<!--- now the ListToArray method can be used without skipping fields --->
<cfset response_array=ListToArray(post_response, "|")>

<!--- the results are output to the screen in the form of an html numbered list. --->
<!--- individual elements of the array could be accessed to read certain
response fields.  For example, response_array[1] would return the Response
Code, response_array[3] would return the Response Reason Code.
For a list of response fields, please review the AIM Implementation Guide --->

 <Cfif #response_array[4]#  contains 'Approved' or parameterexists(approved)>
<!---
<Cfif #response_array[4]#  contains 'Approved' >
---->

<cfset robpic = #createUUID()#>
<cfset robpic = '#right(robpic,8)#'>

<cfparam name="form.sendtype" default="">
<Cfset totalvendor = #total#>



<cfparam name="form.subscribenewsletter" default="">
<cfparam name="form.company" default="">
<cfparam name="form.jobtitle" default="">

<cfif #form.ccnum# eq '1234'>
    <cfset total = 0>
    <cfset price = 0>
    <Cfset paid = 0>
</cfif>
<cfquery name=addphoto datasource="cityguide">

INSERT INTO liveeventorder (datetime,
firstname,
email,
subscribenewsletter,
lastname,
address,
city,
state,
zip,
country,
paid,
couponid,
used,
last4,
Adults,
Kids,
Senior,
Other,
Total,password,saver,subber,mobilephone,sendtype,uid,totalfees,company,jobtitle,codeused

)

VALUES	(#currentdatetime#,'#form.firstname#','#form.email#','#form.subscribenewsletter#','#form.lastname#','#form.address#','#form.city#','#form.state#','#form.zip#','',1,0,0,#right(form.ccnum,4)#,#totalq#,#form.kidsquantity#,#form.seniorquantity#,#form.otherquantity#,#total#,'#form.password#','#form.saver#','#form.subber#','#form.mobilephone#','#form.sendtype#','#robpic#',#total#,'#form.company#','#form.jobtitle#','#url.id#')

		</cfquery>



		<cfquery name="Getorder" dataSource="#ds#">
			select id from liveeventorder 
			order by id desc limit 0,1
			</cfquery>





<CFMAIL
TO="#form.email#"
bcc="[email protected]"
SUBJECT="Women in Tourism"
 FROM="Women in Tourism <[email protected]>"
SERVER="127.0.0.1"
type="html"
>
   #getcoupon.packageconfirmationemail#
<p>

<p>
Please do not reply to this email. If you have any questions, please contact Heather Gambaro, [email protected].



</cfmail>
<Cfoutput>
</Cfoutput>
<p>
    <div class="btn-block4"><h3 style="text-align:center"><a href="https://www.addevent.com/event/qclp195p4k0s" target="_blank"><span style="color:#fff">Add Event to Your Calendar</span></a> <script src="https://cdn.addevent.com/libs/atc/1.6.1/atc.min.js" async defer></script></h3></div><p>

</p>

<Cfoutput>
    


<cfif #form.adultsquantity# gt 0>
        <cfset totalq = form.adultsquantity-1>
<cfelse>
    <cfset totalq = getcoupon.numtickets>
</cfif>


<Cfif #totalq# lte 1>
    #getcoupon.PACKATECONFIRMATIONPAGE# 
</Cfif>

<form action="cgconfirm.cfm?id=#1#&order=#getorder.id#&totalq=#totalq#&package=#getcoupon.id#" method="post">


<Cfif #totalq# gt 1>
You're almost done, please fill out your guest's information below. Don't worry, if you don't know your guest's names, you can tell us later. 

<Table>
<cfloop from="1" to="#totalq#" index="i">
    <Tr><Td>
        <input name="guestname#i#" placeholder="Guest Name #i#" style="width:100%;padding:3px;" >
    </Td></Tr>
    <Tr><Td>
        <input name="guestemail#i#" placeholder="Guest Email #i#" style="width:100%;padding:3px;" >
    </Td></Tr>
        <Tr><Td>
        <input name="guestphone#i#" placeholder="Guest Phone #i#" >
    </Td></Tr>

    

    
    </cfloop>
    </Table>
           <div class="col-lg-12">
                                                <div class="form-group text-center">
                                                    <input class="button btn_1" type="submit" value="Confirm">
                                                </div>
                                            </div>
                                        </div>
                                    </form></Cfif>
</form>
</Cfoutput>
<Cfelse>
<Font  size="+1" color="red">
Your transaction was declined, please <a href = "javascript:history.back()">click here</a> to go back and check your payment information.
<br><br><br>

</Cfif>




            <div class="span3 sidebar-left">
       <!---         <h4>Payment for <Cfoutput>#getcoupon.eventname# at #getcoupon.venue#</Cfoutput></h4>
                <!-- COUPON THUMBNAIL -->
      --->




                     

                    </div>
                </div>
            <div class="span5">
	         
    
<Cfelse>
    
    
               <cfoutput query="getcoupon">

                    <p style="color:black;">#getcoupon.packagetext#</p>





                    </ul>
</a>
<p>

               </cfoutput><br>

</p>
    <cfif parameterexists(url.code)>
                <Cfset #url.coupon# = '#url.code#'>

    </cfif>    
    <Cfif parameterexists(form.sponsorcode)>
        <Cfset #url.coupon# = '#form.sponsorcode#'>
        </cfif>    
    <cfif not parameterexists(url.coupon)> 
<div class=link3new>
     
<Cfelse>
    <Cfquery name="checkc" dataSource="#ds#">
        select * from cgdirectorycoupons where couponcode = '#url.coupon#' 
    </Cfquery>
                  <Cfif #checkc.recordcount# gt 0>
                     <Cfoutput>Welcome #checkc.companyname#!</Cfoutput> 
                     
                     <Cfif #checkc.usedtickets# gt #checkc.allowedtickets#>
                         Error, code has been used its maximum number of times. </div></div><Cfabort>
                        </cfif> 
                      <cfelse>
                      Not found!
                  </Cfif>

                </cfif>
                
     <cfif currentdatetime lt '2024-02-28' and not parameterexists(url.preview)>
Tickets to this event will go on sale shortly. Thank you!<br><br>

    <!-- //////////////////////////////////
//////////////END PAGE CONTENT/////////
////////////////////////////////////-->
                           </div>
        </div>

                </div>
            </div>
        </div>
    </main>

    <cfinclude template="/footer.cfm">

<Cfabort>
    </cfif>
<cfform name="autoSumForm" action="event-order.cfm?process=on&id=#url.id#" method="post"  enctype="multipart/form-data">
    
    <Cfif parameterexists(url.coupon)>
<Cfoutput>    <input type="hidden" name="coupon" value="#url.coupon#"></Cfoutput>
    </cfif>    
    
       <cfif parameterexists(session.id) and parameterexists(session.accesslevel) and parameterexists(session.member)>
<cfquery name="Getdata" dataSource="#ds#">
	select * from liveeventorder
	where email = '#session.email#'
</cfquery>
<cfelse>

<cfparam name="getdata.firstname" default="">
<cfparam name="getdata.lastname" default="">
<cfparam name="getdata.email" default="">
<cfparam name="getdata.mobilephone" default="">
<cfparam name="getdata.address" default="">
<cfparam name="getdata.address2" default="">
<cfparam name="getdata.city" default="">
<cfparam name="getdata.state" default="">
<cfparam name="getdata.zip" default="">
<cfparam name="getdata.country" default="">


</cfif>



<table>
       <tr><Td>

         <label>Company</label>
                    </td><td>
  	  <cfinput NAME="company" class="span5" required="Yes" message="You must provide your company" >

                                        </Td></tr>  
                 
                   <tr><Td>

         <label>Job Title</label>
                    </td><td>
  	  <cfinput NAME="jobtitle" class="span5" required="Yes" message="You must provide your job title" >

                                        </Td></tr>                         
                                        
                                        <tr><Td>         <label>First Name</label></td><Td>
	  <cfinput NAME="firstname" class="span5" required="Yes" message="You must provide your first name" value="#getdata.firstname#">
                    
                                        </Td></tr>   <tr><Td>

                    
                    <label>Last Name</label>
                    </td><td>
  	  <cfinput NAME="lastname" class="span5" required="Yes" message="You must provide your last name" value="#getdata.lastname#">

                                        </Td></tr>     <tr><Td>


            <label>Your Email Address:</label></td><td>
  	  <cfinput NAME="email" class="span5" required="Yes" message="You must provide your email address" value="#getdata.email#">
                                            </Td></tr>     <tr><Td>


	 <label>Mobile Phone:</label></td><TD>
  	  <cfinput NAME="mobilephone" class="span5" required="Yes" message="You must enter your phone" value="#getdata.mobilephone#">
 </Td></tr>   <tr><Td>
	 <label>Address:</label></td><TD>
  	  <cfinput NAME="address" class="span5" required="Yes" message="You must enter your address" value="#getdata.address#">
	 </Td></tr>   <tr><Td>
	
	  <label>City:</label></td><TD>
  	  <cfinput NAME="city" class="span5" required="Yes" message="You must enter your city" value="#getdata.city#">
  	      
  	       </Td></tr>   <tr><Td>
  	           
	  <label>State:</label>
</td><Td>
<SELECT SIZE="1" NAME="State" style="width:50px;">
  <cfoutput><OPTION VALUE="#getdata.state#">#getdata.state#</option></cfoutput>
  <OPTION VALUE="AB">AB</option>
  <OPTION VALUE="AE">AE</option>
  <OPTION VALUE="AK">AK</option>
  <OPTION VALUE="AL">AL</option>
  <OPTION VALUE="AR">AR</option>
  <OPTION VALUE="AS">AS</option>
  <OPTION VALUE="AZ">AZ</option>
  <OPTION VALUE="BC">BC</option>
  <OPTION VALUE="CA">CA</option>
  <OPTION VALUE="CO">CO</option>
  <OPTION VALUE="CT">CT</option>
  <OPTION VALUE="DC">DC</option>
  <OPTION VALUE="DE">DE</option>
  <OPTION VALUE="FL">FL</option>
  <OPTION VALUE="GA">GA</option>
  <OPTION VALUE="GU">GU</option>
  <OPTION VALUE="HI">HI</option>
  <OPTION VALUE="IA">IA</option>
  <OPTION VALUE="ID">ID</option>
  <OPTION VALUE="IL">IL</option>
  <OPTION VALUE="IN">IN</option>
  <OPTION VALUE="KS">KS</option>
  <OPTION VALUE="KY">KY</option>
  <OPTION VALUE="LA">LA</option>
  <OPTION VALUE="MA">MA</option>
  <OPTION VALUE="MB">MB</option>
  <OPTION VALUE="MD">MD</option>
  <OPTION VALUE="ME">ME</option>
  <OPTION VALUE="MI">MI</option>
  <OPTION VALUE="MN">MN</option>
  <OPTION VALUE="MO">MO</option>
  <OPTION VALUE="MP">MP</option>
  <OPTION VALUE="MS">MS</option>
  <OPTION VALUE="MT">MT</option>
  <OPTION VALUE="NB">NB</option>
  <OPTION VALUE="NC">NC</option>
  <OPTION VALUE="ND">ND</option>
  <OPTION VALUE="NE">NE</option>
  <OPTION VALUE="NF">NF</option>
  <OPTION VALUE="NH">NH</option>
  <OPTION VALUE="NJ">NJ</option>
  <OPTION VALUE="NM">NM</option>
  <OPTION VALUE="NS">NS</option>
  <OPTION VALUE="NT">NT</option>
  <OPTION VALUE="NV">NV</option>
  <OPTION VALUE="NY">NY</option>
  <OPTION VALUE="OH">OH</option>
  <OPTION VALUE="OK">OK</option>
  <OPTION VALUE="ON">ON</option>
  <OPTION VALUE="OR">OR</option>
  <OPTION VALUE="PA">PA</option>
  <OPTION VALUE="PE">PE</option>
  <OPTION VALUE="PQ">PQ</option>
  <OPTION VALUE="PR">PR</option>
  <OPTION VALUE="PW">PW</option>
  <OPTION VALUE="RI">RI</option>
  <OPTION VALUE="SC">SC</option>
  <OPTION VALUE="SD">SD</option>
  <OPTION VALUE="SK">SK</option>
  <OPTION VALUE="TN">TN</option>
  <OPTION VALUE="TX">TX</option>
  <OPTION VALUE="UT">UT</option>
  <OPTION VALUE="VA">VA</option>
  <OPTION VALUE="VI">VI</option>
  <OPTION VALUE="VT">VT</option>
  <OPTION VALUE="WA">WA</option>
  <OPTION VALUE="WV">WV</option>
  <OPTION VALUE="WI">WI</option>
  <OPTION VALUE="WY">WY</option>
  <OPTION VALUE="YT">YT</option>
  </SELECT>
 </Td></tr>   <tr><Td>
	  <label>Zip:</label></td><Td>
  	  <cfinput NAME="zip" class="span5" required="Yes" message="You must enter your zip code" value="#getdata.zip#">
 </Td></tr>   </table>
<Br>
                  
                  




</table><cfoutput>

<cfif parameterexists(url.id) and #url.id# eq 7>
Number of Tickets:     
    <select name="adultsquantity" id="adultsquantity"
                                                        class="form-control"
                                                        onchange="if (!window.__cfRLUnblockHandlers) return false; fun(this.value)">
                                                        <option value="1">1 - $195</option>
                                                        <option value="2">2 - $390</option>
                                                        <option value="3">3 - $585</option>
                                                        <option value="4">4 - $780</option>
                                                        <option value="5">5 - $975</option>
                                                        <option value="6">6 - $1170</option>
                                                        <option value="7">7 - $1365</option>
                                                        <option value="8">8 - $1560</option>
                                                    </select>
    <Cfelse>
           	<input type="hidden" name="ansval1" value="#getcoupon.price#" id="ansval1">

Total Price: $#getcoupon.price# <br>
</cfif>
 </cfoutput>
<!--- Total Fees: $<input type="text" name="ansval6" id="ansval6" style="width:70px;" value="0" readonly><br>
 Total Cost: $<input type="text" name="ansval7" id="ansval7" style="width:70px;" value="0" readonly>--->

<cfif not parameterexists(pricerfree)>


<Br><br>
                    <legend>Payment Method</legend>
<table><tr><Td>
                    <label>Credit Card Type</label></td><td>
<select name="cctype">
<option value="American Express">American Express</option>
<option value="Mastercard">Mastercard</option>
<option value="Visa">Visa</option>
<option value="Discover">Discover</option>
</select>
              </td></tr><tr><Td>
              <label>Credit Card Number</label>
              </td><Td>
	  <cfinput NAME="ccnum"  required="yes" message="You Must Enter Your Credit Card Number">
</Td></tr><tr><Td>
                            <label>Expiration Date</label>
                                          </td><Td>

	  <cfinput NAME="ccexpire"  required="yes" message="You Must Enter Your Expiration Date" placeholder="MMYY">

</td></tr>
</table>
<cfelse>
<input type="hidden" name="ccnum" value="0">
<input type="hidden" name="ccexpire" value="0">

</cfif>
<br><br>
                    <div class="gap gap-mini"></div>
                    <input type="submit" class="btn btn-primary btn-block btn-large span6" style="color:white;background-color:black;" value="Submit "><br><center>
                    <br><br>
                    
                    Reminder: ALL SALES ARE FINAL
                    
                    <p>&nbsp;</p>

<h3 style="text-align:center"><span style="color:#000000">Sponsors</span></h3>

<p style="text-align:center"><img alt="" height="100%" src="https://www.cityguideny.com/uploads2/157223/WITFooter2_5_2026.jpg" width="800" /></p>
</cfform>
            </div>
        </div>
        <div class="gap"></div>

      </cfif>
    </div>


    <!-- //////////////////////////////////
//////////////END PAGE CONTENT/////////
////////////////////////////////////-->
                           </div>
        </div>

                </div>
            </div>
        </div>
    </main>

    <cfinclude template="/footer.cfm">