<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="approveactivityplannermarch.cfm?region=Manhattan&requesttimeout=5000">Manhattan</a> | 
<a href="approveactivityplannermarch.cfm?region=Brooklyn&requesttimeout=5000">Brooklyn</a> | 
<a href="approveactivityplannermarch.cfm?region=Queens&requesttimeout=5000">Queens</a> | 
<a href="approveactivityplannermarch.cfm?region=Bronx&requesttimeout=5000">Bronx</a> | 
<a href="approveactivityplannermarch.cfm?region=Westchester&requesttimeout=5000">Westchester</a> | 
<a href="approveactivityplannermarch.cfm?region=Rockland&requesttimeout=5000">Rockland</a> | 
<a href="approveactivityplannermarch.cfm?region=Fairfield&requesttimeout=5000">Fairfield</a> | 
<a href="approveactivityplannermarch.cfm?region=Nassau&requesttimeout=5000">Nassau</a> | 
<a href="approveactivityplannermarch.cfm?region=Suffolk&requesttimeout=5000">Suffolk</a> | 
<a href="approveactivityplannermarch.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="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip
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)
order by id desc
limit 0,2000
</cfquery>



<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">
	
	
	<Cfif #dateformat(astart,'mm/dd/yy')# gt '01/01/18'
		
			and 
				#dateformat(aend,'mm/dd/yy')# lte '01/31/18'
									and 	#dateformat(astart,'mm/dd/yy')# lt '01/31/18'

				>
<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>	

<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')#  - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address#  </cfif> #city#, #state#
<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>
 
 
 
 </cfif>
<hr>

 </Cfif>
 </Cfif>

</cfoutput>

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

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

<cfinclude template="footer.cfm">