<cfset a = 'on'>
<cfinclude template="header.cfm">

    <Table><tr><Td width="800" bgcolor="#ffffcd" valign="top">

<font face="helvetica" size=+1>
<center>
<strong>
Concierge Choice Awards Finalists Information <br />
</strong></center>
<p>


<Cfif parameterexists(url.edit)>
	<cfquery name="update" dataSource="#ds#">
		update cca2018
		set phone = '#form.phone#',
		contactname = '#form.contactname#',
		website = '#form.website#',
		email = '#form.email#',
		excellence = '#form.excellence#'
		where id = #url.id#
		
	</cfquery>	
	
	
	
	<cfif parameterexists(form.photo1) and #form.photo1# is not ''>

	<cfset imagepath="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics">
  <cffile action="upload" 
	      nameconflict="makeunique"
			  filefield="photo1"
			  destination="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics/#url.id#aaa1.jpg"
              accept="image/jpeg,image/pjpeg,image/gif,image/png"   
>
           
             
<cfset photo = "#File.ServerFile#">
  <cfset photo = replace(photo," ","_","ALL")>
  
  
 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo#" 
   mode = "644"  >
   
   	<cfquery name="update" dataSource="#ds#">
		update cca2018
		set photo1 = '#photo#'
		where id = #url.id#
		
	</cfquery>	
	
   
   </cfif>

	<cfif parameterexists(form.photo2) and #form.photo2# is not ''>

	<cfset imagepath="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics">
  <cffile action="upload" 
	      nameconflict="makeunique"
			  filefield="photo2"
			  destination="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics/#url.id#aaa2.jpg"
              accept="image/jpeg,image/pjpeg,image/gif,image/png"   
>
           
             
<cfset photo = "#File.ServerFile#">
  <cfset photo = replace(photo," ","_","ALL")>
  
  
 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo#" 
   mode = "644"  >
   
   	<cfquery name="update" dataSource="#ds#">
		update cca2018
		set photo2 = '#photo#'
		where id = #url.id#
		
	</cfquery>	
	
   
   </cfif>

	<cfif parameterexists(form.photo3) and #form.photo3# is not ''>

	<cfset imagepath="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics">
  <cffile action="upload" 
	      nameconflict="makeunique"
			  filefield="photo3"
			  destination="/home/home2/domains/conciergechoiceawards.org/public_html/2018pics/#url.id#aaa3.jpg"
              accept="image/jpeg,image/pjpeg,image/gif,image/png"   
>
           
             
<cfset photo = "#File.ServerFile#">
  <cfset photo = replace(photo," ","_","ALL")>
  
  
 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo#" 
   mode = "644"  >
   
   	<cfquery name="update" dataSource="#ds#">
		update cca2018
		set photo3 = '#photo#'
		where id = #url.id#
		
	</cfquery>	
	
   
   </cfif>



Thank you!
<cfabort>
<cfelse>


<Cfquery name="getall" dataSource="#ds#">
	select * from cca2018 where id = #url.id#
</Cfquery>	
<div style="padding:6px;"><font face=helvetica size=-1>
Here's your opportunity to shine. Tell both consumers and voters how you deliver excellence.


 </div>
<cfform name=log action="sendinfo.cfm?id=#id#&edit=on&requesttimeout=5000" method="post" enctype="multipart/form-data">
<font face=verdana size=-2>
<table>
<tr><td style="padding:4px;"><font face=helvetica size=-1>
<b>Name:</b></td><td style="padding:4px;"><cfinput TYPE="text" SIZE="25" NAME="contactname" required="yes" message="Please complete all fields." value="#getall.contactname#"></Td></tr>
<tr><td style="padding:4px;"><font face=helvetica size=-1>
<b>Email:</b></td><td style="padding:4px;"><cfinput TYPE="text" SIZE="25" NAME="email" required="yes" message="Please complete all fields." value="#getall.email#"></Td></tr>

<tr><td style="padding:4px;">

<font face=helvetica size=-1>
<b>Phone:</b></td><td style="padding:4px;"><cfinput TYPE="text" SIZE="25" NAME="phone" required="yes" message="Please complete all fields." value="#getall.phone#"></Td></tr>
<tr><td style="padding:4px;">
<font face=helvetica size=-1>
<b>Website:</b></td><td style="padding:4px;"><cfinput TYPE="text" SIZE="25" NAME="website" required="yes" message="Please complete all fields." value="#getall.website#"></Td></tr>
<tr><td style="padding:4px;">
<font face=helvetica size=-1>

<b>How you deliver excellence to<br>
NYC visitors?<br>(max 100 words):</b></td><td style="padding:4px;">
	
	     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
	<script type="application/javascript"> 
          counter = function() {
    var value = $('#experat-answer').val();

    if (value.length == 0) {
        $('#wordCount').html(0);
        $('#totalChars').html(0);
        $('#charCount').html(0);
        $('#charCountNoSpace').html(0);
        return;
    }

    var regex = /\s+/gi;
    var wordCount = value.trim().replace(regex, ' ').split(' ').length;
    var totalChars = value.length;
    var charCount = value.trim().length;
    var charCountNoSpace = value.replace(regex, '').length;

    $('#wordCount').html(wordCount);
    $('#totalChars').html(totalChars);
    $('#charCount').html(charCount);
    $('#charCountNoSpace').html(charCountNoSpace);
};

$(document).ready(function() {
    $('#experat-answer').click(counter);
    $('#experat-answer').change(counter);
    $('#experat-answer').keydown(counter);
    $('#experat-answer').keypress(counter);
    $('#experat-answer').keyup(counter);
    $('#experat-answer').blur(counter);
    $('#experat-answer').focus(counter);
});
          </script>
                      
                      
	<textarea name="excellence" id="experat-answer"  style="width:300px;height:100px;"><cfoutput>#getall.excellence#</cfoutput></textarea>
<br>	                      Words: <span id="wordCount">0</span><br/>

	</Td></tr>
	
	<Tr>
		<td style="padding:4px;" colspan="2">
<font face=helvetica size=-1>
		PHOTO REQUIREMENTS: Photos must be horizontally oriented (landscape), at least 630 pixels wide by 415 pixels high, and less than 2 mb.<br><br>
</font></td></Tr>

<tr><td style="padding:4px;">
<font face=helvetica size=-1>
<b>Photo 1:</b></td><td style="padding:4px;">
	        <input name="photo1" type="file" class="form-control" id="expert-contact-full-name" placeholder="" style="border:0px;">


</Td></tr>


<tr><td style="padding:4px;">
<font face=helvetica size=-1>
<b>Photo 2 (optional):</b></td><td style="padding:4px;">
	        <input name="photo2" type="file" class="form-control" id="expert-contact-full-name" placeholder="" style="border:0px;">


</Td></tr>

<tr><td style="padding:4px;">
<font face=helvetica size=-1>
<b>Photo 3  (optional):</b></td><td style="padding:4px;">
	        <input name="photo3" type="file" class="form-control" id="expert-contact-full-name" placeholder="" style="border:0px;">


</Td></tr>


</table>

<br>
<div align="" style="padding-left:50px;"><input type="submit" Value="Submit Your Info..." style="font-weight: bold;">&nbsp;&nbsp;</div>
</cfform>
 </td></tr>
 </table>

</cfif>

<cfinclude template="footer.cfm">