<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)><cfparam name="url.mag" default="">
<cfparam name="url.issue" default=""> <cfparam name="url.catid" default="">


<Cfquery name="gett" datasource="#ds#">
select distinct issue
from issueguidecat
where issuemy is null
</Cfquery>

<cfoutput query="Gett">

<Cfset zzz = dateformat(gett.issue,'yyyy-mm-dd')>
<cfquery name="upper" datasource="#ds#">
update issueguidecat
set issuemy = '#zzz#'
where issue = '#gett.issue#'
</cfquery>

</cfoutput>



<cfquery name="getsites" datasource="#ds#">
select *
from issueguide
where pkid = #url.id#
order by id
</cfquery>
<table width=100%><tr><td style="padding:4px;">
<div align="center"><font face=verdana size=+1><strong>Manage Print Guide</strong></font>
 <font face=verdana size=-1><br />


<Cfoutput>
<a href="exportguideedit.cfm?mag=#url.mag#&issue=#urlencodedformat(url.issue)#&catid=#url.catid#">Back to Guide Edit...</a> | <a href="addguide2015.cfm?id=#url.id#">New Add Form</a>
</Cfoutput>
<br><br>
<cfoutput>

<fORM action="addguide.cfm?id=#url.id#" method="post">

<font face=verdana size=-1><strong>Send History To:</strong>
<input name="emailto" size="20" />
<INPUT type=submit value="Go!" class="search">
</cfoutput>

</fORM>

<p>

<cfif parameterexists(form.emailto)>

<Cfquery name="getrecord" datasource="#ds#">
select name
from ParentsListings
where id = #url.id#
</Cfquery>

<cfsavecontent variable="temp">




<cfoutput query="getsites">
<Cfquery name="Getname" datasource="#ds#">
select catname
from ParentsListingsCatMain
where id = #catid#
</Cfquery>

<font face=verdana size=-1><b>#getname.catname#</b>
<p>
<Cfquery name="Getissues" datasource="#ds#">
select *
from issueguidecat
where issueguideid = #getsites.id#
</Cfquery>


<Cfloop from="1" to="#getissues.recordcount#" index="i">
#getissues.mags[i]# - #getissues.issue[i]#</a>
<Br />

<cfquery name="Getwrite" datasource="#ds#">
select writeup
from issueguide
where id = #getissues.issueguideid[i]#
</cfquery>

#getwrite.writeup#<p>

</Cfloop>

</cfoutput>

</small>


</cfsavecontent>



<CFMAIL TO="#form.emailto#"
		FROM="[email protected]"
        SUBJECT="NYMP Print Guide: #getrecord.name#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#temp#
</CFMAIL>




</cfif>


<form name="validate" action="/listsearchpk.cfm" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0" onsubmit="return _CF_checkvalidate(this)"><input name="name" id="Crit1_Value" type="text" size="18"  />
<input name="neighborhood" type="hidden" Value="All">&nbsp;<INPUT type=submit value="Search" class="search"></form>

<p>

   <table cellspacing=5 cellpadding=5 border=1>
<tr><td colspan=2>
<font face=verdana size=-1>

</div>
<ul>
<table width="100%"><tr bgcolor="black">

<td style="padding:4px;"><font face=verdana size=-1 color=white><b>GUIDE NAME</td>
<td style="padding:4px;"><font face=verdana size=-1 color=white><b>ADD TO</td>
<td style="padding:4px;"><font face=verdana size=-1 color=white><b>EDIT</td>
<td style="padding:4px;"><font face=verdana size=-1 color=white><b>DELETE</td>
<td style="padding:4px;"><font face=verdana size=-1 color=white><b>EMAIL</td>


</tr>
<cfoutput query="getsites">
<tr>

<Cfquery name="Getname" datasource="#ds#">
select catname
from ParentsListingsCatMain
where id = #catid#
</Cfquery>


<td style="padding:4px;">

<font face=verdana size=-2><b>#getname.catname#</a>  <p/>
<small>
<Cfquery name="Getissues" datasource="#ds#">
select *
from issueguidecat
where issueguideid = #getsites.id#
</Cfquery>

<Cfloop from="1" to="#getissues.recordcount#" index="i">
#getissues.mags[i]# - #getissues.issue[i]#</a> <cfif #getissues.pickup[i]# eq 'on'>(Pickup)</cfif><br />
</Cfloop>

</td>
<td style="padding:4px;"><font face=verdana size=-2>
<form  method="post"  enctype="multipart/form-data" action="addguidecat2.cfm?id=#getsites.id#&tid=#url.id#">
<input name="mags" type="checkbox" value="BAP" />BAP
<input name="mags" type="checkbox" value="WP" />WP
<input name="mags" type="checkbox" value="BP" />BP
<input name="mags" type="checkbox" value="QP" />QP
<input name="mags" type="checkbox" value="RP" />RP
<input name="mags" type="checkbox" value="FP" />FP
<input name="mags" type="checkbox" value="NP" />NP
<input name="mags" type="checkbox" value="SP" />SP
<br />
<input name="mags" type="checkbox" value="SPSUB" />SP SUBURBS
<input name="mags" type="checkbox" value="SPCITY" />SP CITY
<input name="mags" type="checkbox" value="SPLI" />SP LI
<input name="mags" type="checkbox" value="WELCOMEFAM" />WELCOME FAM

<Br />
<select name="issue">
        <option value="January 2022">January 2022
<option value="February 2022">February 2022
<option value="March 2022">March 2022
<option value="April 2022">April 2022
<option value="May 2022">May 2022
<option value="June 2022">June 2022
<option value="July 2022">July 2022
<option value="August 2022">August 2022
<option value="September 2022">September 2022
<option value="October 2022">October 2022
<option value="November 2022">November 2022
<option value="December 2022">December 2022

    
    <option value="January 2021">January 2021
<option value="February 2021">February 2021
<option value="March 2021">March 2021
<option value="April 2021">April 2021
<option value="May 2021">May 2021
<option value="June 2021">June 2021
<option value="July 2021">July 2021
<option value="August 2021">August 2021
<option value="September 2021">September 2021
<option value="October 2021">October 2021
<option value="November 2021">November 2021
<option value="December 2021">December 2021
				<option value="January 2020">January 2020
<option value="February 2020">February 2020
<option value="March 2020">March 2020
<option value="April 2020">April 2020
<option value="May 2020">May 2020
<option value="June 2020">June 2020
<option value="July 2020">July 2020
<option value="August 2020">August 2020
<option value="September 2020">September 2020
<option value="October 2020">October 2020
<option value="November 2020">November 2020
<option value="December 2020">December 2020

			<option value="January 2019">January 2019
<option value="February 2019">February 2019
<option value="March 2019">March 2019
<option value="April 2019">April 2019
<option value="May 2019">May 2019
<option value="June 2019">June 2019
<option value="July 2019">July 2019
<option value="August 2019">August 2019
<option value="September 2019">September 2019
<option value="October 2019">October 2019
<option value="November 2019">November 2019
<option value="December 2019">December 2019





</select>


<select name="issue2">
				<option value="Second Issue">Second Issue
				
				    <option value="January 2022">January 2022
<option value="February 2022">February 2022
<option value="March 2022">March 2022
<option value="April 2022">April 2022
<option value="May 2022">May 2022
<option value="June 2022">June 2022
<option value="July 2022">July 2022
<option value="August 2022">August 2022
<option value="September 2022">September 2022
<option value="October 2022">October 2022
<option value="November 2022">November 2022
<option value="December 2022">December 2022

				<option value="January 2021">January 2021
<option value="February 2021">February 2021
<option value="March 2021">March 2021
<option value="April 2021">April 2021
<option value="May 2021">May 2021
<option value="June 2021">June 2021
<option value="July 2021">July 2021
<option value="August 2021">August 2021
<option value="September 2021">September 2021
<option value="October 2021">October 2021
<option value="November 2021">November 2021
<option value="December 2021">December 2021

			<option value="January 2020">January 2020
<option value="February 2020">February 2020
<option value="March 2020">March 2020
<option value="April 2020">April 2020
<option value="May 2020">May 2020
<option value="June 2020">June 2020
<option value="July 2020">July 2020
<option value="August 2020">August 2020
<option value="September 2020">September 2020
<option value="October 2020">October 2020
<option value="November 2020">November 2020
<option value="December 2020">December 2020

			<option value="January 2019">January 2019
<option value="February 2019">February 2019
<option value="March 2019">March 2019
<option value="April 2019">April 2019
<option value="May 2019">May 2019
<option value="June 2019">June 2019
<option value="July 2019">July 2019
<option value="August 2019">August 2019
<option value="September 2019">September 2019
<option value="October 2019">October 2019
<option value="November 2019">November 2019
<option value="December 2019">December 2019


</select>


<select name="issue3">
				<option value="Third Issue">Third Issue
		    <option value="January 2022">January 2022
<option value="February 2022">February 2022
<option value="March 2022">March 2022
<option value="April 2022">April 2022
<option value="May 2022">May 2022
<option value="June 2022">June 2022
<option value="July 2022">July 2022
<option value="August 2022">August 2022
<option value="September 2022">September 2022
<option value="October 2022">October 2022
<option value="November 2022">November 2022
<option value="December 2022">December 2022

		<option value="January 2021">January 2021
<option value="February 2021">February 2021
<option value="March 2021">March 2021
<option value="April 2021">April 2021
<option value="May 2021">May 2021
<option value="June 2021">June 2021
<option value="July 2021">July 2021
<option value="August 2021">August 2021
<option value="September 2021">September 2021
<option value="October 2021">October 2021
<option value="November 2021">November 2021
<option value="December 2021">December 2021
			<option value="January 2020">January 2020
<option value="February 2020">February 2020
<option value="March 2020">March 2020
<option value="April 2020">April 2020
<option value="May 2020">May 2020
<option value="June 2020">June 2020
<option value="July 2020">July 2020
<option value="August 2020">August 2020
<option value="September 2020">September 2020
<option value="October 2020">October 2020
<option value="November 2020">November 2020
<option value="December 2020">December 2020

			<option value="January 2019">January 2019
<option value="February 2019">February 2019
<option value="March 2019">March 2019
<option value="April 2019">April 2019
<option value="May 2019">May 2019
<option value="June 2019">June 2019
<option value="July 2019">July 2019
<option value="August 2019">August 2019
<option value="September 2019">September 2019
<option value="October 2019">October 2019
<option value="November 2019">November 2019
<option value="December 2019">December 2019
		


</select>
<input name="pickup" type="checkbox" />Pick-Up?

 <input type="submit" Value="Add"></form>
<td style="padding:4px;"><font face=verdana size=-2><a href="editguide.cfm?id=#id#&tid=#url.id#">edit</a></td>
<td style="padding:4px;"><font face=verdana size=-2><a href="deleteguide.cfm?id=#id#&tid=#url.id#"  onClick="return confirm('Do you really want to delete this guide entry?');">delete</a></td>
<td style="padding:4px;"><font face=verdana size=-2><a href="emailguide.cfm?id=#id#&tid=#url.id#">email</a></td>

</tr>
</cfoutput>

<!---
<cfoutput query="getsites">

<Cfquery name="Getname" datasource="#ds#">
select catname
from ParentsListingsCatMain2011
where id = #catid#
</Cfquery>
<Cfif #getname.recordcount# gt 0>
<tr>


<td style="padding:4px;"><font face=verdana size=-2><b>#getname.catname#</a>  <p/>
<small>
<Cfquery name="Getissues" datasource="#ds#">
select *
from issueguidecat
where issueguideid = #getsites.id#
</Cfquery>


<Cfloop from="1" to="#getissues.recordcount#" index="i">
#getissues.mags[i]# - #getissues.issue[i]#</a> <cfif #getissues.pickup[i]# eq 'on'>(Pickup)</cfif><br />
</Cfloop>

</td>
<td style="padding:4px;"><font face=verdana size=-2>

<form  method="post"  enctype="multipart/form-data" action="addguidecat2.cfm?id=#getsites.id#&tid=#url.id#">
<input name="mags" type="checkbox" value="BAP" />BAP
<input name="mags" type="checkbox" value="WP" />WP
<input name="mags" type="checkbox" value="BP" />BP
<input name="mags" type="checkbox" value="QP" />QP
<input name="mags" type="checkbox" value="RP" />RP
<input name="mags" type="checkbox" value="FP" />FP
<input name="mags" type="checkbox" value="NP" />NP
<input name="mags" type="checkbox" value="SP" />SP<br />
<input name="mags" type="checkbox" value="SPSUB" />SP SUBURBS
<input name="mags" type="checkbox" value="SPCITY" />SP CITY
<input name="mags" type="checkbox" value="SPLI" />SP LI
<input name="mags" type="checkbox" value="WELCOMEFAM" />WELCOME FAM

<Br />
<select name="issue">

<option value="January 2013">January 2013
<option value="February 2013">February 2013
<option value="March 2013">March 2013
<option value="April 2013">April 2013
<option value="May 2013">May 2013
<option value="June 2013">June 2013
<option value="July 2013">July 2013
<option value="August 2013">August 2013
<option value="September 2013">September 2013
<option value="October 2013">October 2013
<option value="November 2013">November 2013
<option value="December 2013">December 2013

<option value="January 2008">January 2008
<option value="February 2008">February 2008
<option value="March 2008">March 2008
<option value="April 2008">April 2008
<option value="May 2008">May 2008
<option value="June 2008">June 2008
<option value="July 2008">July 2008
<option value="August 2008">August 2008
<option value="September 2008">September 2008
<option value="October 2008">October 2008
<option value="November 2008">November 2008
<option value="December 2008">December 2008
<option value="January 2009">January 2009
<option value="February 2009">February 2009
<option value="March 2009">March 2009
<option value="April 2009">April 2009
<option value="May 2009">May 2009
<option value="June 2009">June 2009
<option value="July 2009">July 2009
<option value="August 2009">August 2009
<option value="September 2009">September 2009

<option value="October 2009">October 2009
<option value="November 2009">November 2009
<option value="December 2009">December 2009
<option value="January 2010">January 2010
<option value="February 2010">February 2010
<option value="March 2010">March 2010
<option value="April 2010">April 2010
<option value="May 2010">May 2010
<option value="June 2010">June 2010
<option value="July 2010">July 2010
<option value="August 2010">August 2010
<option value="September 2010">September 2010
<option value="October 2010">October 2010
<option value="November 2010">November 2010
<option value="December 2010">December 2010
<option value="January 2011">January 2011
<option value="February 2011">February 2011
<option value="March 2011">March 2011
<option value="April 2011">April 2011
<option value="May 2011">May 2011
<option value="June 2011">June 2011
<option value="July 2011">July 2011
<option value="August 2011">August 2011
<option value="September 2011">September 2011
<option value="October 2011">October 2011
<option value="November 2011">November 2011
<option value="December 2011">December 2011

<option value="January 2012">January 2012
<option value="February 2012">February 2012
<option value="March 2012">March 2012
<option value="April 2012">April 2012
<option value="May 2012">May 2012
<option value="June 2012">June 2012
<option value="July 2012">July 2012
<option value="August 2012">August 2012
<option value="September 2012">September 2012
<option value="October 2012">October 2012
<option value="November 2012">November 2012
<option value="December 2012">December 2012
</select>
<input name="pickup" type="checkbox" />Pick-Up?

 <input type="submit" Value="Add"></form>
<td style="padding:4px;"><font face=verdana size=-2><a href="editguide.cfm?id=#id#&tid=#url.id#">edit</a></td>
<td style="padding:4px;"><font face=verdana size=-2><a href="deleteguide.cfm?id=#id#&tid=#url.id#"  onClick="return confirm('Do you really want to delete this guide entry?');">delete</a></td>
</tr>
</Cfif>
</cfoutput>
---->

</table>

<p><Cfoutput><FORM action="addguide2.cfm?id=#url.id#" method="post"  enctype="multipart/form-data"></cfoutput>
</td></tr>
  <tr><td style="padding:4px;">
	  <b><font SIZE="-1" FACE="verdana">Write-Up:</font></b>
  </td><td style="padding:4px;">
<textarea name="writeup" cols="60" rows="10"></textarea>
  </td></tr>


  <tr>
	  <td style="padding:4px;">
	  <b><font SIZE="-1" FACE="verdana" >Category:</font></b>
	  </td><td style="padding:4px;">

      <Cfquery name="Getregionso" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where catname like '%print guide%'
order by catname
</CFQUERY>


<select name="catid">

<Cfquery name="Getregionsm" datasource="#ds#">
SELECT *
FROM pkmastersource2011 where id = 0
order by catname
</CFQUERY>


<cfquery name="Getarticleregions" datasource="#ds#">
select *
from ParentsListingsCat2011
where pkid = #url.id# and id = 0
</cfquery>

<Cfloop from="1" to="#getregionsm.recordcount#" index="i">
<Cfquery name="Getregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain2011
where mastercat = #getregionsm.id[i]# and id = 0
order by catname
</CFQUERY>

<cfoutput>
 <option value="0"></option>

 <option value="0">#ucase(getregionsm.catname[i])#</option>
 <option value="0"></option>

</cfoutput>

<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.catid[i]# eq #getregions.id#>
 <Cfset ab = 'off'>
 <option value="#getregions.id#" selected>#getregions.catname#</option>
 <cfelse>

  </cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
  <option value="#getregions.id#">#getregions.catname#</option>
</CFIF>

 </CFOUTPUT>

</Cfloop>

<cfoutput query="Getregionso">
<option value="#Getregionso.id#">#Getregionso.catname#</option>
</cfoutput>

</select>

  </td></tr>

    <tr><td style="padding:4px;">
	  <b><font SIZE="-1" FACE="verdana">Special Offer:</font></b>
  </td><td style="padding:4px;">
<input name="offer" type="text" size="100" />
  </td></tr>

    <tr><td style="padding:4px;">
	  <b><font SIZE="-1" FACE="verdana">Expiration Date:</font></b>
  </td><td style="padding:4px;">
	  	<Cfset nextmonth = dateadd('m',0,currentdatetime)>

		<Cfset nextyear = dateadd('yyyy',1,currentdatetime)>


<input name="expirationdate" type="text" size="100" value="<Cfoutput>#dateformat(nextmonth,'m')#/#dateformat(currentdatetime,'d')#/#dateformat(nextyear,'yyyy')#</Cfoutput>"/>
<!---
<input name="expirationdate" type="text" size="100" />
--->

  </td></tr>
  
  
    <tr><td style="padding:4px;">
	  <b><font SIZE="-1" FACE="verdana">Digital Only:</font></b>
  </td><td style="padding:4px;">
	<input name="digitalonly" type="checkbox">
	 </td></tr>

 </table><br>
<center><input type="submit" Value="Add"></center>
</form>
</td></tr></table>

</cfif>
</cfif>