<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="approveactivityplannerupwork.cfm?requesttimeout=5000">All</a> | 

<a href="approveactivityplannerupwork.cfm?region=Manhattan&requesttimeout=5000">Manhattan</a> | 
<a href="approveactivityplannerupwork.cfm?region=Brooklyn&requesttimeout=5000">Brooklyn</a> | 
<a href="approveactivityplannerupwork.cfm?region=Queens&requesttimeout=5000">Queens</a> | 
<a href="approveactivityplannerupwork.cfm?region=Bronx&requesttimeout=5000">Bronx</a> | 
<a href="approveactivityplannerupwork.cfm?region=Westchester&requesttimeout=5000">Westchester</a> | 
<a href="approveactivityplannerupwork.cfm?region=Rockland&requesttimeout=5000">Rockland</a> | 
<a href="approveactivityplannerupwork.cfm?region=Fairfield&requesttimeout=5000">Fairfield</a> | 
<a href="approveactivityplannerupwork.cfm?region=Nassau&requesttimeout=5000">Nassau</a> | 
<a href="approveactivityplannerupwork.cfm?region=Suffolk&requesttimeout=5000">Suffolk</a> | 
<a href="approveactivityplannerupwork.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 ActivityPlannerHoldUpwork
where 1=1
and statusnum=0
and id > 100000
and (catid = 0 and catid2 = 0)
and dateend = '2006-01-01'
order by dateend 
</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 ActivityPlannerHoldUpwork
	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
from ActivityPlannerHoldUpwork
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 dateend > '2018-01-01'
and (catid = 0 and catid2 = 0)
order by dateend </cfquery>

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

<cfoutput query="getevents">
		
	<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
		
			and 
				#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
				>
<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">
	
	
	<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
		
			and 
				#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
				>
<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 ActivityPlannerHoldUpwork
	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')#
<cfif #address# is not ''><br>#address#  </cfif> #city#, #state#
<p>
#description#<br />
 <cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="approvecalendarupwork.cfm?eventid=#id#&blank=on">approve entry</a>

&nbsp;&nbsp;&nbsp;

<a href="delplannerholdupwork.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">