<cfsetting requestTimeout="5000">
<Cfset requesttimeout=5000>
<cfif parameterexists(url.month)>
	<Cfset today = dateadd('d',-30,currentdatetime)>

	<Cfelse>
<Cfset today = dateadd('d',-7,currentdatetime)>
</cfif>
<Cfset today = dateformat(today,'yyyy-mm-dd')>


<cfsavecontent variable="reporter">

<Cfoutput><h1>Report for #dateformat(today,'dddd mmmm d, yyyy')# - #dateformat(currentdatetime,'dddd mmmm d, yyyy')#</h1></Cfoutput>

<Cfquery name="Geter" dataSource="#ds#">

	select ActivityPlanner.activityname, ActivityPlanner.id, ActivityPlanner.name, ActivityPlanner.DateStart,ActivityPlanner.DateEnd,ActivityPlanner.seo_friendly, CatActivityPlanner.Cat, CatActivityPlanner.mastercat, count(newmastertrackevents.id) as views, nympregion
from newmastertrackevents FORCE INDEX (statme) inner join ActivityPlanner on newmastertrackevents.idnumber = ActivityPlanner.id inner join CatActivityPlanner on ActivityPlanner.catid3 = CatActivityPlanner.catid
where 1 = 1
<Cfif parameterexists(url.region)>
	and nympregion = '#url.region#'
</Cfif>	
and DateEnd >= '#today#'
and newmastertrackevents.datetime > '#today#'
group by newmastertrackevents.idnumber
order by views desc
</cfquery>

</Cfoutput>
<cfif not parameterexists(url.region)> 

<table><Tr><Td valign="top">
<cfquery name="getm" dbtype="query">
	select nympregion,sum(views) as sumviews, count(id) as counter
	from geter
	where nympregion <> ''
	and nympregion <> 'None'
group by nympregion
order by sumviews desc
</cfquery>
<Cfset totvar = 0>
<Cfset totvarb = 0>

<cfoutput query="getm">
<cfset totvar = totvar + sumviews></cfoutput>




<table border="1" cellspacing="0" cellpadding="4"> 
<tr style="background-color: black;">
<Td><Font color="white"><b>Region</b></Font></Td>
<Td><Font color="white"><b># of Events</b></Font></Td>
<Td><Font color="white"><b>Views</b></Font></Td>
<Td><Font color="white"><b>%</b></Font></Td>
<Td><Font color="white"><b>Avg</b></Font></Td>

</tr>
<cfoutput query="getm">
<Cfif len(nympregion) gt 3> 
<Tr>
<td>
	<b><a href="https://www.cityguideny.com/admin/dailyreportevents.cfm?requesttimeout=5000&region=#nympregion#">#nympregion#</a></b></td> </td>
	<td> 
	<cfquery name="getcount" datasource="#ds#">
		select count(distinct ActivityPlanner.id) as counter from newmastertrackevents FORCE INDEX (statme) inner join ActivityPlanner on newmastertrackevents.idnumber = ActivityPlanner.id  
		where 1 = 1 and 
		nympregion = '#nympregion#'
and newmastertrackevents.datetime > '#today#'
and DateEnd >= '#today#'

	</cfquery>
	#getcount.counter#
	<Cfset totvarb = totvarb + #getcount.counter#>

	</td>
	
	<td> #sumviews# </td> 
<td>	<cfset newperc = sumviews / totvar>
<cfset newperc = newperc * 100>
#round(newperc)#%
	</td>
	
	<td>
		<cfset avgme = sumviews / #getcount.counter#>
		#numberformat(avgme,0.00)#
	</td>
	
</Tr>
		</Cfif>
</cfoutput>
<tr><Td><B>TOTAL</B></Td>
<td><Cfoutput>#totvarb#</Cfoutput></td>

<td><Cfoutput>#totvar#</Cfoutput></td>
</tr>
</table>


</Td>
<Td valign="top"> 




<cfquery name="getm" dbtype="query">
	select Cat,sum(views) as sumviews
	from geter
	where nympregion <> ''
	and nympregion <> 'None'
	and nympregion <> 'Bronx'
group by Cat
order by sumviews desc
</cfquery>
<Cfset totvar = 0>
<Cfset totvarc = 0>

<cfoutput query="getm">
<cfset totvar = totvar + sumviews></cfoutput>


<table border="1" cellspacing="0" cellpadding="4"> 
<tr style="background-color: black;">
<Td><Font color="white"><b>Online Category</b></Font></Td>
<Td><Font color="white"><b># of Events</b></Font></Td>
<Td><Font color="white"><b>Views</b></Font></Td>
<Td><Font color="white"><b>%</b></Font></Td>
<Td><Font color="white"><b>Avg</b></Font></Td>

</tr>
<cfoutput query="getm">
<Tr>
<td>
	<b>#cat#</b></td> 
	
	
<Cfquery name="Getcatid" datasource="#ds#">
	select catid from CatActivityPlanner
	where cat = '#cat#'
	and mag = 5
</Cfquery>	
		<td> 
	<cfquery name="getcount" datasource="#ds#">
		select distinct ActivityPlanner.id as counter from newmastertrackevents FORCE INDEX (statme) inner join ActivityPlanner on newmastertrackevents.idnumber = ActivityPlanner.id
		inner join CatActivityPlanner on ActivityPlanner.catid3 = CatActivityPlanner.catid  
		where 1 = 1 
		and CatActivityPlanner.catid = #Getcatid.catid#
		and DateEnd >= '#today#'

and newmastertrackevents.datetime > '#today#'
	</cfquery>
	#getcount.recordcount#
	<Cfset totvarc = totvarc + #getcount.recordcount#>

	</td>
	
	<td> #sumviews# </td> 
<td>	<cfset newperc = sumviews / totvar>
<cfset newperc = newperc * 100>
#round(newperc)#%
	</td>
	
		<td>
		<cfset avgme = sumviews / #getcount.recordcount#>
		#numberformat(avgme,0.00)#
	</td>
	
</Tr>
</cfoutput>
<tr><Td><B>TOTAL</B></Td>
<td><Cfoutput>#totvarc#</Cfoutput></td>

<td><Cfoutput>#totvar#</Cfoutput></td>
</tr>
</table>





</Td>

</Tr></table>

<br><br></cfif>

<table width="600" border="1" cellpadding="4" cellspacing="0">
<tr style="background-color: black;">
<td><font color="white"><b>Event</b></td>
<td><font color="white"><b>Venue</b></td>
<td><font color="white"><b>Posted</b></td>
<td><font color="white"><b>Category</b></td>
<td><font color="white"><b>Region</b></td>

<td><font color="white"><b>Views</b></td>
</tr>		
	
<cfoutput query="geter" >
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
	
                            <td><a href="https://www.nymetroparents.com/event/#seo_friendly#">#left(activityname,20)#</a></td><td>#left(name,20)#</td>
                            <td>#dateformat(datestart,'mm/dd/yy')#<Cfif #datestart# is not #dateend#>-#dateformat(DateEnd,'mm/dd/yy')#</Cfif></td>
                            <td>#cat#</td>
                            <td>#nympregion#</td>
                            <td>#views#</td>
                        </tr>
</cfoutput>
</table>

	</td></tr></table>


</cfsavecontent>

<Cfoutput>
	#reporter#</Cfoutput>
	
	https://www.cityguideny.com/admin/dailyreportevents.cfm?requesttimeout=5000&sendit=on

<cfif parameterexists(url.sendit)>
<CFMAIL
TO="[email protected],[email protected],[email protected],[email protected],[email protected]"
SUBJECT="NYMP Calendar Report for #dateformat(today,'dddd mmmm d, yyyy')# - #dateformat(currentdatetime,'dddd mmmm d, yyyy')#"
        FROM="NYMP <[email protected]>"
SERVER="127.0.0.1"
type="html">
Below are stats for the last 7 days of all events viewed on nymetroparents.com, by region and by primary category. 
<p></p>
#reporter#


</cfmail>


</cfif>