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

<Cfquery name="getc" datasource="#ds#">
    select copy from columntable where id = 157300
</Cfquery>
<Cfquery name="getc2" datasource="#ds#">
    select copy from columntable where id = 157301
</Cfquery>

<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_table
        WHERE email = <cfqueryparam value="#url.email#" cfsqltype="CF_SQL_VARCHAR">
        ORDER BY point_for,event_name;
    </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>Hi #getUserData.first_name#,</p>
                <p></p><br>
                <cfset lastMonthDate = dateAdd("m", -1, now())>
<cfset firstDayLastMonth = createDate(year(lastMonthDate), month(lastMonthDate), 1)>

<!--- Get the month name for the first day of last month --->
<cfset lastMonthName = monthAsString(month(firstDayLastMonth))>

<!--- Output the month name for the previous month --->
<cfoutput>#getc.copy#</cfoutput>
<p></p>
                Here is your City Guide Rewards statement for #lastMonthName#.
                <p></p><br>

   <cfloop query="getUserData">
                     <cfset totpot = totpot +points>
                    </cfloop>
                <p>For participating in CG activities, you earned <font size=+1><strong>#totpot#</font></strong> points last month:

</p>
                <table border="1">
                   <!---   <tr>
                      <th style="padding:4px;">Award</th>

                        <th style="padding:4px;">Event Name</th>
                        <th style="padding:4px;">Points</th>
                    </tr>--->
                    <cfloop query="getUserData">
                        <tr>
                                                        <td  style="padding:4px;">#point_for#</td>

                            <td style="padding:4px;">#event_name#</td>
                            <td  style="padding:4px;">#points#</td>
                        </tr>
                    </cfloop>
                </table>
                <br>
       
         <!--- Display the lifetime earnings and redeemable points --->
                <p>Your lifetime City Guide Rewards earnings: $<strong>#getUserData.Total_Earned#</strong> worth of points.</p>
<!--- . --->
                <cfif  getUserData.Total_Earned GT getUserData.Redeemable AND getUserData.Redeemable GTE 25>
                    <p>You have $<strong>#numberFormat(getUserData.Redeemable)#</strong> worth of points available to be redeemed. </p>
                </cfif>
                    
                           <cfif  getUserData.Redeemable GTE 25>
                    <p>Visit <a href="https://cgr.bucketlist.org/">City Guide Rewards</a> to redeem today.</p>
                </cfif>
                
                
       <cfoutput>#getc2.copy#</cfoutput>
<p></p>

            </cfoutput>
        </cfsavecontent>

<Cfoutput>#emailBody#</Cfoutput>


   <p><a href="upload.cfm">Back to User List</a> | <a href="email.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="upload.cfm">Back to User List</a></p>
        </cfoutput>
    </cfif>
<cfelse>
    <cfoutput>
        <p>No email address provided.</p>
        <p><a href="upload.cfm">Back to User List</a></p>
    </cfoutput>
</cfif>

<Cfif parameterexists(url.send)>
    
        <!--- Send the email --->
      <CFMAIL
TO="#url.email#"
SUBJECT="You've Earned New City Guide Rewards Points!"
        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>