<Cfif parameterexists(url.delete)>

	<Cfquery name="del" dataSource="#ds#">
		delete from afterschool2019form where id = #url.delete#

	</cfquery>

</Cfif>


<cfquery name="getreg" dataSource="#ds#">
	select distinct region from afterschool2019form
	where region not like '%,%'
</cfquery>
<cfoutput query="getreg">
	<a href="afterschool2019csv.cfm?gridit=on&region=#region#">#region#</a> |
</cfoutput>

<a href="afterschool2019csv.cfm?gridit=on&region=Queens">Queens</a> | 
<a href="afterschool2019csv.cfm?gridit=on&region=Rockland">Rockland</a> | 
<a href="afterschool2019csv.cfm?gridit=on&region=Big Apple">Big Apple</a> | 
<a href="afterschool2019csv.cfm?gridit=on&region=Long Island">Long Island</a> | 
<a href="afterschool2019csv.cfm?gridit=on&region=Westchester">Westchester</a> | 
<a href="afterschool2019csv.cfm?gridit=on&region=Brooklyn">Brooklyn</a>



<Cfquery name="Getpreschools" dataSource="#ds#">
	select * from afterschool2019form
		<Cfif parameterexists(url.region)>
			where 1 =1 
			
			<Cfif #url.region# eq 'Queens'>
				and accountrep = '[email protected]'
			</Cfif>
			
				<Cfif #url.region# eq 'Rockland'>
				and accountrep = '[email protected]'
			</Cfif>
				<Cfif #url.region# eq 'Big Apple'>
				and (accountrep = '[email protected]' or accountrep = '[email protected]')
			</Cfif>
			
				<Cfif #url.region# eq 'Long Island'>
				and (accountrep = '[email protected]' or accountrep = '[email protected]')
			</Cfif>
				<Cfif #url.region# eq 'Westchester'>
				and (accountrep = '[email protected]'
or accountrep = '[email protected]'
or accountrep = '[email protected]'
or accountrep = '[email protected]')
			</Cfif>	
			<Cfif #url.region# eq 'Brooklyn'>
				and accountrep = '[email protected]'
			</Cfif>
			
	</Cfif>

</cfquery>
<Table cellpadding="4" cellspacing="0" border="1">
<tr>
	<td></td>	<td></td>

<td><b>businessname</b></td>
<td><b>region</b></td>
<td><b>accountrep</b></td>
<td><b>micrositeid</b></td>


<Cfquery name="Getreg" dataSource="#ds#">
	select catname, reg,id as catid
	from afterschool2019catmap
</cfquery>

<cfset cat1 = 0>
<cfset cat2 = 0>
<cfset cat3 = 0>
<cfset cat4 = 0>
<cfset cat5 = 0>
<cfset cat6 = 0>
<cfset cat7 = 0>
<cfset cat8 = 0>
<cfset cat9 = 0>
<cfset cat10 = 0>
<cfset cat11 = 0>
<cfset cat12 = 0>
<cfset cat13 = 0>
<cfset cat14 = 0>
<cfset cat15 = 0>
<cfset cat16 = 0>

<Cfloop from="1" to="#getreg.recordcount#" index="i">
<cfoutput>
<td>
<b>#getreg.catname[i]#</b>

</td>	</cfoutput>
</Cfloop>



</tr>

<Cfoutput query="Getpreschools">

<tr>
	<td><a href="afterschool2019email.cfm?id=#id#">email</a></td>

</td>

	<td><a href="afterschool2019.cfm?editone=#id#">edit</a></td>
<td>#businessname#</td>
<td>#region#</td>
<td>#accountrep#</td>
<td><cfif micrositeid eq 0><font color="red">NO</font><cfelse><a href="/listingseditpk.cfm?id=#id#&table=ParentsListings&cat=0&catid=0">#micrositeid#</a></cfif></td>

<Cfloop from="1" to="#getreg.recordcount#" index="i">
<td>

<cfquery name="Geter" dataSource="#ds#">
	select * from afterschool2019formcats
	where campid = #id#
	and catid = #getreg.catid[i]#
</cfquery>

<Cfif #geter.recordcount# gt 0>
1

<cfif  #getreg.catid[i]# eq 1><Cfset cat1 = cat1 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 2><Cfset cat2 = cat2 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 3><Cfset cat3 = cat3 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 4><Cfset cat4 = cat4 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 5><Cfset cat5 = cat5 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 6><Cfset cat6 = cat6 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 7><Cfset cat7 = cat7 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 8><Cfset cat8 = cat8 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 9><Cfset cat9 = cat9 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 10><Cfset cat10 = cat10 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 11><Cfset cat11 = cat11 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 12><Cfset cat12 = cat12 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 13><Cfset cat13 = cat13 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 14><Cfset cat14 = cat14 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 15><Cfset cat15 = cat15 + 1></Cfif>

</Cfif>
</td>
</Cfloop>
</tr>

</Cfoutput>


<tr>
<td><b>TOTAL</b></td>
<td></td>
<td></td>
<td></td>
<td></td>
<Cfoutput>
<td>#cat1#</td>
<td>#cat2#</td>
<td>#cat3#</td>
<td>#cat4#</td>
<td>#cat5#</td>
<td>#cat6#</td>
<td>#cat7#</td>
<td>#cat8#</td>
<td>#cat9#</td>
<td>#cat10#</td>
<td>#cat11#</td>
<td>#cat12#</td>
<td>#cat13#</td>
<td>#cat14#</td>
<td>#cat15#</td>


 </Cfoutput>
</tr>

</Table>