<cfquery name="getc" datasource="#ds#">
              select copy,imageurlbig from columntable inner join columntableimages on columntable.id = columntableimages.colid where id = 
157113    </cfquery>
    
                            <cfparam name="form.couponme" default="BMaddy">

    <cfif parameterexists(url.code)>
<cfparam name="form.couponme" default="#url.code#">
        </cfif>
<cfsavecontent variable="headercontent">
<title><cfoutput>Women in Tourism Nomination Form</cfoutput></title>
<meta property="og:image"              content="<cfoutput>#getc.imageurlbig#</cfoutput>" />


</cfsavecontent>

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

    <main>
	            <div class="white_bg" >
            <div class="container margin_60" style="max-width: 800px;">
                
                <Cfinclude template="css.htm">

 
               <!--- <div class="main_title">
                    <h2>Order</span></h2>
                </div>
                --->

                
                	   
                
	        <Cfif parameterexists(url.process)>

<Cfquery name="getcoupon" datasource="#ds#">
select *  from cgevent
where id = 1

</cfquery>

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


<Cfparam name="form.adultsquantity" default="0">
<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="">
<Cfparam name="form.total" default="0">
<Cfparam name="form.ccexpire" default="0">
<Cfparam name="form.firstname" default="0">
<Cfparam name="form.lastname" default="0">
<Cfparam name="form.city" default="0">
<Cfparam name="form.state" default="0">
<Cfparam name="form.zip" default="0">

<Cfparam name="form.question3" default="">
<Cfparam name="form.question4" default="">

<Cfparam name="form.address" default="0">

<cfset totalq = 1>

<Cfset total = #form.total#>

           <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 parameterexists(form.ccnum) and #form.ccnum# eq '1234'>
        <Cfset approved = 'on'>

</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="#form.total#">
	<cfhttpparam type="Formfield" name="x_description" value="CG Order - Women in Tourism Nomination">

	<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 = #form.total#>




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

<cfquery name=addphoto datasource="cg22">

INSERT INTO womenintourismnoms(datetime,
name,
title,
company,
website,
email,
mobile,
category,
linkedin,
question1,
question2,
question3,
question4,
billingfirst,
billinglast,
address,
city,
state,
zip,
total,
couponcode,nominatorname,nominatoremail,nominatorcompany

)

VALUES	(#currentdatetime#,'#form.name#',
'#form.title#',
'#form.company#',
'#form.website#',
'#form.email#',
'#form.mobile#',
'#form.category#',
'#form.linkedin#',
'#form.question1#',
'#form.question2#',
'#form.question3#',
'#form.question4#',
'#form.firstname#',
'#form.lastname#',
'#form.address#',
'#form.city#',
'#form.state#',
'#form.zip#',#form.total#,'#form.couponme#','#form.nominatorname#','#form.nominatoremail#','#form.nominatorcompany#'

)

		</cfquery>


<Cftry>
		
<Cfif parameterexists(form.nominatoremail) and #form.nominatoremail# is not ''>
    <Cfset emailto = '#form.email#,#form.nominatoremail#'>
<cfelse>
    <Cfset emailto = '#form.email#'>

</Cfif>


<CFMAIL
TO="#emailto#"
SUBJECT="Women in Tourism Nomination Confirmation"
 FROM="City Guide <[email protected]>"
SERVER="127.0.0.1"
type="html"
>
    <cfquery name="getc" datasource="#ds#">
        select copy from columntable where id = 157114
    </cfquery>
    <cfoutput>#getc.copy#</cfoutput>
    

Thank you for submitting the nomination for: 
#form.name#
<br><br>
Category: #form.category#

<br><br>
 

This is your receipt for the $#form.total# submission form.


</cfmail>
<Cfcatch></Cfcatch>
</Cftry>

Thank you - your nomination has been received! <!--<Cfoutput>#form.total#</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>
    

    <cfinclude template="copyoutput.cfm">
    
<p></p>
                
     
     
<Cfif #currentdatetime# gt '2022-03-08'>
    
The nomination period has closed. Honorees will be announced on Monday, March 21 at 12 noon during a "live" Facebook event on the City Guide FB page
<cfabort>
</Cfif>
<h2>Nominee Information</h2>
<cfif not parameterexists(form.couponme)>
<cfform name="autoSumForm" action="/wit/nominate.cfm" method="post"  enctype="multipart/form-data">

Do you have a promo code? Enter it here first. 
  	  <cfinput NAME="couponme" class="span5" required="Yes" message="You must enter a coupon code." style="width:100px">


 <input type="submit" style="color:white;background-color:black;" value="Submit ">
</cfform>
<hr>
</cfif>

<cfform name="autoSumForm" action="/wit/nominate.cfm?process=on" method="post"  enctype="multipart/form-data">
    
    <Cfif parameterexists(url.coupon)>
<Cfoutput>    <input type="hidden" name="coupon" value="#url.coupon#"></Cfoutput>
    </cfif>    
    
      <cfquery name="Getdata" dataSource="#ds#">
	select * from cgorder
	where email = '1'
</cfquery>

<table >
       <tr><Td>

         <label>Name</label>
                    </td><td>
  	  <cfinput NAME="name" class="span5" required="Yes" message="You must provide all information." style="width:100%">

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

         <label>Title</label>
                    </td><td>
  	  <cfinput NAME="title" class="span5" required="Yes" message="You must provide all information."  style="width:100%">

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

         <label>Company</label>
                    </td><td>
  	  <cfinput NAME="company" class="span5" required="Yes" message="You must provide all information."   style="width:100%">

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

         <label>Website</label>
                    </td><td>
  	  <cfinput NAME="website" class="span5" required="Yes" message="You must provide all information."  style="width:100%">

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

         <label>Email</label>
                    </td><td>
  	  <cfinput NAME="email" class="span5" required="Yes" message="You must provide all information."  style="width:100%">

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

         <label>Mobile</label>
                    </td><td>
  	  <cfinput NAME="mobile" class="span5" required="Yes" message="You must provide all information."  style="width:100%">

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

         <label> LinkedIn</label>
                    </td><td>
  	  <cfinput NAME="linkedin" class="span5" required="No" message="You must provide all information."  style="width:100%">

                                        </Td></tr>  
                                        
           
           
                  <tr><Td colspan="2">
<br>
         <label>How long has the nominee been in their position?


</label><br>
  	  <cfinput NAME="question1" class="span5" required="No" message="You must provide all information." >

                                        </Td></tr>                
                                        
                   <tr><Td  colspan="2">
<br>
         <label>Describe why the nominee deserves to be the honoree.



</label>
              <br>
                        <textarea name="question2" style="width:100%;height:200px;"></textarea>

                                        </Td></tr>           
              <!---      <tr><Td  colspan="2"> 
<br>
         <label>What are the nominees major achievements in this position?


</label>
                   <br>
                        <textarea name="question3" style="width:100%;height:200px;"></textarea>

                                        </Td></tr>                                       
                     <tr><Td  colspan="2">
<br>
         <label>How does the nominee create great visitor experiences?


</label>
                  <br>
                        <textarea name="question4" style="width:100%;height:200px;"></textarea>

                                        </Td></tr>        --->                              
                   <tr><Td colspan="2">
<br>
         <label>Category  (check one)</label><br>
For category descriptions, <a href="categories.cfm" target="_new">click here</a>
<Table style="width:100%;"><Tr><td>

<input name="category" value="Attractions" type="radio"> Attractions<br>
<input name="category" value="BIDs/Government Agency" type="radio"> BIDs/Government Agency<br>
<input name="category" value="Cultural Arts/Museums" type="radio"> Cultural Arts/Museums<br>
<input name="category" value="Hotel Concierge" type="radio"> Hotel Concierge<br>
<input name="category" value="Hotel Management" type="radio"> Hotel Management<br>
<input name="category" value="Meeting/Event Planner" type="radio"> Meeting/Event Planner<br>
<input name="category" value="Multi-tenant venue" type="radio"> Multi-tenant venue<br>
<input name="category" value="Nightlife" type="radio"> Nightlife<br>


<input name="category" value="Restaurant Operations" type="radio"> Restaurant Operations<br>
<input name="category" value="Restaurant Owner" type="radio"> Restaurant Owner<br>
<input name="category" value="Retail" type="radio"> Retail<br>
<input name="category" value="Theater" type="radio"> Theater<br>
<input name="category" value="Tour Guide" type="radio"> Tour Guide<br>
<input name="category" value="Tour Operator" type="radio"> Tour Operator<br>
<input name="category" value="Tourism/Ticketing Services" type="radio"> Tourism/Ticketing Services<br>
<input name="category" value="Transportation" type="radio"> Transportation<br><br>
<strong>Special Awards:</strong>
<br><br>
<input name="category" value="Special Awards - Lifetime Achievement" type="radio"> Lifetime Achievement<br>
<input name="category" value="Special Awards - Up and Comer" type="radio"> Up and Comer<br>

</td></Tr></Table>

                                        </Td></tr>                         
                                        
                                        
                  </table>                      
<Br><br>
  <legend>If you are not self nominating:</legend>
  
  <Table>                          
                                        <tr><Td>         <label>Nominator Name</label></td><Td>
	  <cfinput NAME="nominatorname" class="span5" required="no" message="You must provide your first name" style="width:100%">
                    
                                        </Td></tr> 
                                        
                                         <tr><Td>         <label>Nominator's Company/Organization</label></td><Td>
	  <cfinput NAME="nominatorcompany" class="span5" required="no" message="You must provide your company" style="width:100%">
                    
                                        </Td></tr>  
                                        
                                        <tr><Td>

                    
                    <label>Nominator Email</label>
                    </td><td>
  	  <cfinput NAME="nominatoremail" class="span5" required="no" message="You must provide your last name"   style="width:100%">

                                        </Td></tr> </table>
  <br><Br>
<!---
                    <legend>Payment Method</legend>
        
                    Submission fee: <Cfoutput>
                        
                        
                        <cfif parameterexists(form.couponme)>
                            
                            <Cfif #form.couponme# eq 'City Guide'><Cfset tm = 25></Cfif> 
                            <Cfif #form.couponme# eq 'CityGuide'><Cfset tm = 25></Cfif> 

                            <Cfif #form.couponme# eq 'BID'><Cfset tm = 50></Cfif> 
                            <Cfif #form.couponme# eq 'BMaddy'><Cfset tm = 0></Cfif> 

                       	<input type="hidden" name="couponme" value="<cfoutput>#form.couponme#</cfoutput>" >

                	<input type="hidden" name="ansval1" value="<cfoutput>#tm#</cfoutput>" >
                	                	<input type="hidden" name="total" value="<cfoutput>#tm#</cfoutput>" >

<cfoutput>$#tm#</cfoutput> 

       <Cfelse>       
            	<input type="hidden" name="couponme" value="None" >

                        	<input type="hidden" name="ansval1" value="100" id="ansval1">
                        	<input type="hidden" name="total" value="100" id="ansval1">
$100 - Fee credited towards 1 luncheon ticket.</cfif>    
                        
                    </Cfoutput>
                            <Cfif parameterexists(form.couponme) and #form.couponme# eq 'BMaddy'>
                   	  <cfinput NAME="ccnum" type="hidden" value="1234" required="yes" message="You Must Enter Your Credit Card Number">
             
                                                   	  <cfinput NAME="ccexpire" type="hidden" value="1234" required="yes" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="firstname" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="lastname" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="city" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="state" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="zip" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">
                                                   	  <cfinput NAME="address" type="hidden" value="" required="no" message="You Must Enter Your Credit Card Number">

                                <cfelse>
                                

<br>
<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>

<br><br>
           <Table>                          
                                        <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#"  style="width:100%">
                    
                                        </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#"  style="width:100%">

                                        </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#"  style="width:100%">
 </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#"  style="width:100%">
	 </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# "  style="width:100%">
  	      
  	       </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>


                            </Cfif> 



</table>--->
<!--- Total Tickets: $<input type="text" name="ansval5" id="ansval5" style="width:50px;" readonly><br> --->
<!--- 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>--->



                    <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>
                   
</cfform>
            </div>
        </div>
        <div class="gap"></div>

      </cfif>
    </div>


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

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

    <cfinclude template="/footer.cfm">