<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">





					<table border="0" cellpadding="8" cellspacing="0" width="100%">
					<tr>
					<td valign="top">




<span class="header">Camp Directory Articles Admin</span></strong><br>

<!---<cfset thismonth = dateformat(now(),'mmmm')>
<cfoutput>#thismonth# 1
</cfoutput>		yes!
--->

<Cfif parameterexists(getuser.email)>
<br><br>	<a href="http://google.cityguideny.com/admin/directoryarticlescamp.cfm?runme=on&requesttimeout=5000">GO!</a><br><br>
</Cfif>

<Cfif parameterexists(url.save)>

	<cfquery name="upds" dataSource="#ds#">
		update directoryarticlescamps
		set <!---catid = '#form.catid#', --->headline = '#form.headline#',blurb = '#form.blurb#', catname = '#form.catname#', bottomtext = '#form.bottomtext#'
		where id = #url.save#
</cfquery>
</Cfif>

<Cfif parameterexists(url.edit)>

<Cfquery name="Gets" dataSource="#ds#">
	select * from directoryarticlescamps
where id = #url.edit#
limit 0,1
</cfquery>

<cfFORM action="directoryarticlescamp.cfm?save=#url.edit#" method="post" name="MyForm" enctype="multipart/form-data">

<table>
  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Headline:</font></b>
  </td><td><Cfoutput>
	  <input NAME="headline" SIZE="100" value="#Gets.Headline#">
  </td></tr></Cfoutput>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Blurb:</font></b>
  </td><td>
	 <Textarea name="blurb" style="width:100%;height:100px;"><Cfoutput>#gets.blurb#</Cfoutput></Textarea>

  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Category Name:</font></b>
  </td><td>

<Cfoutput>
	  <input NAME="catname" SIZE="100" value="#Gets.catname#">
  </td></tr></Cfoutput>

  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Type:</font></b>
  </td><td>

<Cfoutput>
	  <input NAME="typer" SIZE="100" value="#Gets.typer#">
  </td></tr></Cfoutput>

  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Bottom Text:</font></b>
  </td><td>

<script src="//cdn.ckeditor.com/4.6.2/standard/ckeditor.js"></script>
        <textarea name="bottomtext"><Cfoutput>#gets.bottomtext#</Cfoutput></textarea>
        <script>
            CKEDITOR.replace( 'bottomtext' );
        </script>



  </td></tr>


</table><input name="entry" type="submit" Value="Update ">


</cfFORM>

<cfabort>
<cfelse>


<Cfquery name="Gets" dataSource="#ds#">
	select * from directoryarticlescamps
where region <> 'Fairfield'
 order by region,ID
</cfquery>

<table cellpadding="2" cellspacing="0" border="1">

	<tr style="background-color: black;">
<td></td>

<Td><font color="white" face="verdana" size="-1"><b>Count</Td>
<Td><font color="white" face="verdana" size="-1"><b>Region</Td>

<Td><font color="white" face="verdana" size="-1"><b>Category</Td>
<Td><font color="white" face="verdana" size="-1"><b>Headline</Td>

<Td><font color="white" face="verdana" size="-1"><b>Blurb</Td>
<Td><font color="white" face="verdana" size="-1"><b>Preview</Td>
<Td><font color="white" face="verdana" size="-1"><b>Live</Td>
</tr>
<Cfoutput query="Gets">

	<cfif region eq 'Manhattan'>
	<Cfset #mag# = 'BAP'>
	</Cfif>

<cfif region eq 'Manahttan'>
	<Cfset #mag# = 'BAP'>
	</Cfif>


<cfif region eq 'Westchester'>
	<Cfset #mag# = 'WP'>
	</Cfif>

	<cfif region eq 'Brooklyn'>
	<Cfset #mag# = 'BP'>
	</Cfif>

	<cfif region eq 'Queens'>
	<Cfset #mag# = 'QP'>
	</Cfif>

	<cfif region eq 'Rockland'>
	<Cfset #mag# = 'RP'>
	</Cfif>


	<cfif region eq 'Fairfield'>
	<Cfset #mag# = 'FP'>
	</Cfif>


<Cfset be = #dateformat(now(),'2018-mm-dd')#>


<cfif typer eq 'Suburbs' and catname contains 'STEAM'>
	
<cfset catname = 'STEAM/Academic Enrichment'> 

</cfif>	

 <cfquery name="getstuffb" datasource="#ds#">
	 select id from camp2018catmap
	 where reg = '#typer#'
	 and catname = '#catname#'
 </cfquery>
 

<Cftry> 
<cfquery name="Getstuff" dataSource="#ds#">
select camp2018form.id from camp2018form
inner join camp2018formcats on 
camp2018formcats.campid = camp2018form.id
where catid = #getstuffb.id#
<cfif #region# contains 'Manhattan'>
	and  region like '%Big Apple%' 
<cfelseif #region# contains 'Nassau'>
	and  region like '%Long%' 

<cfelse>
and  region like '%#region#%' 
</cfif>
</cfquery>
<cfcatch>
</cfcatch>

</Cftry>


<tr <Cfif getstuff.recordcount eq 0 or (getstuff.recordcount gt 3 and blurb eq '')>bgcolor="pink"</Cfif>>
	<td><A href="directoryarticlescamp.cfm?edit=#id#">edit</A></td>
	<td>



		<center>
		#getstuff.recordcount#

	</td>


	<td><b>#region#</b></td>
	<td><b><small>
#catname# - #typer#
	
	</td>
	<td>#headline#</b></td>
	<td>#blurb#</b></td>



	<td><A href="exportonlineguidearticlecamp.cfm?id=#id#">preview</A></td>

<cfquery name="Getseo" dataSource="#ds#">
	select seo_friendly from columntable
	where id = #lid# 
</cfquery>
	<td><A href="https://www.nymetroparents.com/article/#Getseo.seo_friendly#">view live</A></td>


<Cfif parameterexists(url.runme)
	>
		yes!

<cfobjectcache action="clear">


	<cfhttp url="http://google.cityguideny.com/admin/exportonlineguidearticlecamp.cfm?id=#id#"
    method="GET" resolveurl="YES" timeout="50000">
</cfhttp>

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
<cfset monthvar = '#dateformat(currentdatetime,'MMMM')#'>

<Cfset newheadline = '#rereplace(Headline,'MONTHNAME','#monthvar#')#'>
<Cfset newblurb = '#rereplace(blurb,'MONTHNAME','#monthvar#')#'>


<Cfquery name="upds" dataSource="#ds#">
	update columntable
	set title = '#newheadline#', blurb = '#newblurb#', copy = '#cfhttp.filecontent#', dateposted = '#dateformat(now(),'yyyy-mm-dd')#',postedby = 'System', Editedby = 'System'
	where id = #lid#
</cfquery>
</Cfif>
</tr>
<cfobjectcache action="clear">

</Cfoutput>
</table>


</Cfif>

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