<cfif not parameterexists(url.batch)><cfinclude template="header.cfm"></cfif>



<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
      
      <cfparam name="url.email" default="">

<cfif len(trim(url.email))>
    <!--- Retrieve user data for the email --->
    <cfquery name="getUserData" datasource="#ds#">
        SELECT *
        FROM temp_table2
        WHERE email = <cfqueryparam value="#url.email#" cfsqltype="CF_SQL_VARCHAR">
    </cfquery>
    
    <cfif getUserData.recordCount>
        <!--- Prepare the email body with user data and point breakdown --->
        <cfsavecontent variable="emailBody">
            <img src="https://www.cityguideny.com/img/cggte.jpg" alt="CG GTE">
            <Cfset totpot = 0>
            <cfoutput>
                <p>Hello #getUserData.name#,</p>

                    
                           <cfif  getUserData.points GTE 25>

<p style="text-align:start">Thanks for being part of the City Guide Rewards program! &nbsp;Good news &mdash; you&rsquo;ve reached the redemption threshold and can now claim a gift card!</p>

<p style="text-align:start"><strong>Your current balance: $#getuserdata.points#</strong></p>

<p style="text-align:start">Gift cards are available for Amazon, Target, Starbucks, Chipotle, and over 150 other top brands.&nbsp; Visit&nbsp;<a href="http://cgr.bucketlist.org/" target="_blank">City Guide Rewards</a>&nbsp;to redeem.</p>

<p style="text-align:start">Earn more points by attending events, completing surveys, or &mdash; for big points &mdash; booking tickets for your guests with&nbsp;<a href="http://www.guestticketsexpress.com/" target="_blank">Guest Tickets Express</a>. &nbsp;Need help getting started? &nbsp;Email:&nbsp;<a href="mailto:[email protected]" target="_blank">[email protected]</a></p>


<cfelseif getuserdata.points gte 15 and getuserdata.points lt 25>
<p style="text-align:start">You&rsquo;ve been earning points through the City Guide Rewards program, and your balance is on its way to our $25 gift card redemption threshold.</p>

<p style="text-align:start"><strong>Your current balance: $#getuserdata.points#</strong><br />
<strong>You need $<cfset zz = 25-#getuserdata.points#>#zz# more to redeem a gift card.</strong></p>

<p style="text-align:start">Amazon, Starbucks and more gift cards are closer than you think &mdash; keep it up!</p>

<p style="text-align:start">Earn more points by attending events, completing surveys, or &mdash; for big points &mdash; booking tickets for your guests with&nbsp;<a href="http://www.guestticketsexpress.com/" target="_blank">Guest Tickets Express</a>. &nbsp;Need help getting started? &nbsp;Email:&nbsp;<a href="mailto:[email protected]" target="_blank">[email protected]</a></p>

<cfelse>
<p style="text-align:start">You&rsquo;ve been earning points through the City Guide Rewards program, and your balance is on its way to our $25 gift card redemption threshold.</p>

<p style="text-align:start"><strong>Your current balance: $#getuserdata.points#</strong><br />
<strong>You need $<cfset zz = 25-#getuserdata.points#>#zz# more to redeem a gift card.</strong></p>

<p style="text-align:start">There are lots of ways to earn: attending events, completing surveys, or &mdash; for big points &mdash; booking tickets for your guests with&nbsp;<a href="http://www.guestticketsexpress.com/" target="_blank">Guest Tickets Express</a>. &nbsp;Need help getting started? &nbsp;Email:&nbsp;<a href="mailto:[email protected]" target="_blank">[email protected]</a></p>


                </cfif>
                
                

            </cfoutput>
        </cfsavecontent>

<Cfoutput>#emailBody#</Cfoutput>


   <p><a href="upload2.cfm">Back to User List</a> | <a href="email2.cfm?email=<cfoutput>#url.email#</cfoutput>&send=on">Send Email</a></p>
    <cfelse>
        <cfoutput>
            <p>No user data found for email: #url.email#</p>
            <p><a href="upload2.cfm">Back to User List</a></p>
        </cfoutput>
    </cfif>
<cfelse>
    <cfoutput>
        <p>No email address provided.</p>
        <p><a href="upload2.cfm">Back to User List</a></p>
    </cfoutput>
</cfif>

<Cfif parameterexists(url.send)>
    
        <!--- Send the email --->
      <CFMAIL
TO="#url.email#"
SUBJECT="City Guide Rewards statement"
        FROM="CG Rewards <[email protected]>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
          
            #emailBody#
        </cfmail>

        <cfoutput>
            <p>Email sent to #url.email#.</p>
           </cfoutput>
</cfif>
   </div>
<!--Footer-part-->
<br><br><br><br>

<cfif not parameterexists(url.batch)><cfinclude template="footer.cfm"></cfif>