<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;"><Br>
<Font size=+1>
<a href="approveactivityplanner.cfm?requesttimeout=5000">All</a> |

<a href="approveactivityplanner.cfm?region=Manhattan&requesttimeout=5000">Manhattan</a> |
<a href="approveactivityplanner.cfm?region=Brooklyn&requesttimeout=5000">Brooklyn</a> |
<a href="approveactivityplanner.cfm?region=Queens&requesttimeout=5000">Queens</a> |
<a href="approveactivityplanner.cfm?region=Bronx&requesttimeout=5000">Bronx</a> |
<a href="approveactivityplanner.cfm?region=Westchester&requesttimeout=5000">Westchester</a> |
<a href="approveactivityplanner.cfm?region=Rockland&requesttimeout=5000">Rockland</a> |
<a href="approveactivityplanner.cfm?region=Fairfield&requesttimeout=5000">Fairfield</a> |
<a href="approveactivityplanner.cfm?region=Nassau&requesttimeout=5000">Nassau</a> |
<a href="approveactivityplanner.cfm?region=Suffolk&requesttimeout=5000">Suffolk</a> |
<a href="approveactivityplanner.cfm?region=None&requesttimeout=5000">None</a>

</Font><br>

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
<cfparam name="form.arrivedate" default="#dateformat(currentdatetime,'yyyy-mm-dd')#">
<cfif #form.arrivedate# eq ''>
<cfset form.arrivedate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>

<cfset newdeparturedate = #dateadd('d',7,CurrentDateTime)#>

<cfparam name="form.departuredate" default="#dateformat(newdeparturedate,'yyyy-mm-dd')#">
<cfif #form.departuredate# eq ''>
<cfset form.departuredate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>


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

	select id,astart,aend,description,event,address,city,state,nympregion,zip
from ActivityPlannerHold
where 1=1
and statusnum=0
and id > 100000
and (catid = 0 and catid2 = 0)
and (aend like '%22%' or aend like '%2021%')

order by id
</cfquery>

<Cfoutput query="Getm">
<Cfset startme = #dateformat(astart,'yyyy-mm-dd')#>
<Cfset endme = #dateformat(aend,'yyyy-mm-dd')#>

<Cfif endme eq ''>
	<cfset endme = '#startme#'>
</Cfif>

<Cftry>
<cfquery name="upme" dataSource="#ds#">
	update ActivityPlannerHold
	set DateStart = '#startme#', DateEnd = '#endme#'
	where id = #id#
</cfquery>


<Cfcatch>

</Cfcatch>
		</Cftry>
</Cfoutput>




<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend,dtentered,venuename
from ActivityPlannerHold
where 1=1
and statusnum=0
<Cfif parameterexists(url.region) and #Url.region# is not 'None'>
	and nympregion = '#url.region#'
</Cfif>
<Cfif parameterexists(url.region) and #Url.region# eq 'None'>
	and nympregion is null
</Cfif>
and (catid = 0 and catid2 = 0)
and (aend like '%22%' or aend like '%2021%')
order by id
 </cfquery>

<cfset total = 0>
<Cfset redtotal = 0>

<cfoutput query="getevents">

<cfset bananna = #dateformat (aend,'yyyy-mm-dd')#>
	<Cfif #isdate(bananna)# and #datediff('d',currentdatetime,bananna)# gt 0   >
<Cfif #description# does not contain 'http'>


<cfset total = total + 1>


<cfif #datediff('d',currentdatetime,dateend)# lt 60>
	<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>

<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>

<table class="table color-table inverse-table table-hover table-striped">
					<tr>
					<td valign="top"
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<cfset bananna = #dateformat (aend,'yyyy-mm-dd')#>


	<Cfif
			#isdate(bananna)#	and #datediff('d',currentdatetime,bananna)# gt 0			>


<Cfif #description# does not contain 'http'>


		<cfif #len(nympregion)# lt 3>
			<Cfquery name="checkregion" dataSource="#ds#">
				select county from Zip_code_table2017
				where zip = '#zip#'
			</cfquery>

<cfquery name="upds" dataSource="#ds#">
	update ActivityPlannerHold
	set nympregion = '#checkregion.county#'
	where id = #id#
</cfquery>

	</cfif>

<div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>

<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')#  - #dateformat (aend,'mm/dd/yy')#
<br>#venuename#<cfif #address# is not ''><br>#address#  </cfif> #city#, #state#
<br>Entered on #dtentered#
<p>
#description#<br />
 <cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>

&nbsp;&nbsp;&nbsp;

<a href="delplannerhold.cfm?id=#id#&blank=on">delete entry</a>

 </div>



 </cfif>
<hr>

 </Cfif>
 </Cfif>

</cfoutput>

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

   </div>
<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">