<cfinclude template="header.cfm">


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


<cfsavecontent variable="sendme">


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




<span class="header">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/directoryarticles.cfm?runme=on&requesttimeout=5000">GO!</a><br><br>
</Cfif>

<Cfif parameterexists(url.save)>

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

<Cfif parameterexists(url.edit)>

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

<cfFORM action="directoryarticles.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">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 directoryarticles
where region <> 'Fairfield'
 order by livedate,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">

<!---
<Cfquery name="Geter" dataSource="#ds#">
	select title,blurb from columntable where id = #colid#
</cfquery>
	<cfquery name="upds" dataSource="#ds#">
		update directoryarticles
		set headline = '#Geter.title#',blurb = '#geter.blurb#'
		where colid = #colid#
</cfquery>

--->




		<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')#>



 <cfquery name="getstuff" datasource="#ds#">
 select issueguide.writeup,issueguide.id, issueguide.pkid, 	issueguide.editedby,issueguidecat.issue,issueguidecat.mags,issueguide.offer,issueguide.expirationdate,issueguidecat.issueguideid,ParentsListings.*,ParentsListingsCatMain.shortname as category
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
1=1

and ( issueguidecat.issue = '#dateformat(now(),'mmmm yyyy')#'
or issueguide.expirationdate  > '#dateformat(now(),'yyyy-mm-dd')#'
or issueguidecat.issue = 'February 2017'

or issueguidecat.issuemy between '2017-01-01' and '#be#'

<!---
or issueguidecat.issue = '#dateformat(gets.livedate,'mmmm yyyy')#'
--->
)

<!--- and
--->
<!--- issueguidecat.issue = '#url.issue#'



(issueguidecat.issue = 'August 2015' or issueguidecat.issue = 'August 2015' )--->

<cfif gets.region contains 'Long'>
and (issueguidecat.mags like '%NP%' or issueguidecat.mags like '%SP%')

<Cfelse>
and issueguidecat.mags like '%#mag#%'


	</Cfif>

and issueguide.writeup <> ''


 and issueguide.catid in (#catid#)

group by pkid
<!--- added --->
 </cfquery>

<Cfif getstuff.recordcount gt 50>

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



		<center>
		#getstuff.recordcount#

	</td>


	<td><b>#region#</b></td>
	<td><b><small>

<cfquery name="getsites" datasource="#ds#">
select *
from ParentsListingsCatMain
where id in (#catid#)
order by catname
</cfquery>

	<cfloop from="1" to="#getsites.recordcount#" index="i">
#getsites.catname[i]# - #getsites.id[i]#<Cfif #i# is not getsites.recordcount>,</Cfif>

	</cfloop>
		<!---<Cfif #catid# eq 0 and #categoryname# is not 'Top Events'>NO MATCH</Cfif></b>

		<p>
			<b><a href="http://www.cityguideny.com/admin/editcol3334.cfm?id=#colid#&mag=5&topr=999999">#colid#</a></b>
		---></td>
	<td>#headline#</b></td>
	<td>#blurb#</b></td>
<td>

	<!--- <cfset CookieCheck =  REFindNoCase(' ', blurb, 1, true)>
#cookiecheck#
--->	</td>

	<!---<td><cfset needle = '25'>
<cfset result = (len(haystack) - len(ReplaceNoCase(haystack,needle,'','ALL'))/len(needle)>

		#result#
		</b></td>
--->


<cfif #DATEFORMAT(LIVEDATE,'mmmm')# eq 'October' or  #DATEFORMAT(LIVEDATE,'mmmm')# eq 'November' or #DATEFORMAT(LIVEDATE,'mmmm')# eq 'December' or #DATEFORMAT(LIVEDATE,'mmmm')# eq 'January'>
	<td><A href="exportonlineguidearticle.cfm?id=#id#">preview</A></td>

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

	</Cfif>

	<td><A href="http://www.nymetroparents.com/2011va.cfm?colid=#colid#">view live article</A></td>


</tr>
</Cfif>

</Cfoutput>
</table>


</Cfif>


</cfsavecontent>


<cfif parameterexists(url.mailme)>

	<CFMAIL
TO="[email protected],[email protected]"
SUBJECT="Directories that are too long..."
        FROM="NYMP <[email protected]>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">

#sendme#</cfmail>


</cfif>

<Cfoutput>#sendme#</Cfoutput>