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


<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>

<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Export Print Guide</strong></font>
 <font face=verdana size=-1><br /><a href="exportonlineguide.cfm">Export Online Guide</a></div>
<p><font face=verdana size=-2>

<form  method="post"  enctype="multipart/form-data" action="exportguide.cfm">
<input name="mags" type="radio" value="BAP" <cfif parameterexists(form.mags) and #form.mags# eq 'BAP'>checked</cfif>/>BAP
<input name="mags" type="radio" value="WP" <cfif parameterexists(form.mags) and #form.mags# eq 'WP'>checked</cfif>>WP
<input name="mags" type="radio" value="BP" <cfif parameterexists(form.mags) and #form.mags# eq 'BP'>checked</cfif>>BP
<input name="mags" type="radio" value="QP" <cfif parameterexists(form.mags) and #form.mags# eq 'QP'>checked</cfif>>QP
<input name="mags" type="radio" value="RP" <cfif parameterexists(form.mags) and #form.mags# eq 'RP'>checked</cfif>>RP
<input name="mags" type="radio" value="FP" <cfif parameterexists(form.mags) and #form.mags# eq 'FP'>checked</cfif>>FP
<input name="mags" type="radio" value="NP" <cfif parameterexists(form.mags) and #form.mags# eq 'NP'>checked</cfif>>NP
<input name="mags" type="radio" value="SP" <cfif parameterexists(form.mags) and #form.mags# eq 'SP'>checked</cfif>>SP
<input name="mags" type="radio" value="NPSP" <cfif parameterexists(form.mags) and #form.mags# eq 'NPSP'>checked</cfif>>NPSP



<input name="mags" type="radio" value="SPSUB" <cfif parameterexists(form.mags) and #form.mags# eq 'SPSUB'>checked</cfif>>SP SUBURBS
<input name="mags" type="radio" value="SPCITY" <cfif parameterexists(form.mags) and #form.mags# eq 'SPCITY'>checked</cfif>>SP CITY
<input name="mags" type="radio" value="SPLI" <cfif parameterexists(form.mags) and #form.mags# eq 'SPLI'>checked</cfif>>SP LI
<input name="mags" type="radio" value="WELCOMEFAM" <cfif parameterexists(form.mags) and #form.mags# eq
'WELCOMEFAM'>checked</cfif>>WELCOME FAM
<input name="mags" type="radio" value="BAPBPQP" <cfif parameterexists(form.mags) and #form.mags# eq 'BAPBPQP'>checked</cfif>>BAPBPQP

<input name="mags" type="radio" value="ALL" <cfif parameterexists(form.mags) and #form.mags# eq 'ALL'>checked</cfif>>ALL

<br>
<Br />
Start:
<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

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


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

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

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

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

<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="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>


End:
<select name="issueend">
 <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

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


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

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

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

<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="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>




<cfquery name="getsites" datasource="#ds#">
select *
from ParentsListingsCatMain
order by catname
</cfquery>
<select name="catid" style="width:200px;">
<option value="0">All</option>
<cfoutput query="getsites">
<option value="#id#">#catname#</option>
</cfoutput>
</select>

<strong>Sort By: </strong>
<select name="sortby">
<option value="0">Name</option>
<option value="1">Random</option>

</select>


<strong>Write Up Length: </strong>
<select name="writeuplength">
<option value="90">90</option>
<option value="25">25</option>
<option value="Both">Both</option>

</select>

<strong>Digital Only: </strong>
<select name="digitalonly">
<option value="Include">Include</option>
<option value="Exclude">Exclude</option>

</select>


<strong>Advertisers: </strong>
<select name="advertisers">
<option value="All">All</option>
<option value="Premium">Premium</option>

</select>


 <input type="submit" Value="Search"></form>

 <cfif parameterexists(form.issue)>

 <Cfset starter = #dateformat(form.issue,'yyyy-mm-dd')#>

 <Cfset ender = #dateformat(form.issueend,'yyyy-mm-dd')#>

 <cfquery name="getstuff" datasource="#ds#">
 select issueguide.writeup, issueguide.eventtyper, issueguide.pkid, issueguidecat.issue,issueguidecat.mags,issueguide.offer,issueguide.expirationdate,issueguidecat.issueguideid,ParentsListings.*,ParentsListingsCatMain.catname as category,issueguidecat.issuemy, issueguide.writeupshort
 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 (issueguidecat.issuemy between '#starter#' and '#ender#')
 <!--- where issueguidecat.issue = '#form.issue#' ---> 
 <cfif form.mags eq 'NPSP'>
	  and (issueguidecat.mags like '%NP%' or issueguidecat.mags like '%SP%')

 <cfelseif form.mags eq 'BAPBPQP'>
	  and (issueguidecat.mags like '%BAP%' or issueguidecat.mags like '%BP%' or issueguidecat.mags like '%QP%')

 <cfelseif form.mags eq 'ALL'>
and 1 = 1
	 <cfelse>
 and issueguidecat.mags like '%#form.mags#%'
  </cfif>
 <cfif #form.catid# eq 0>

 <cfelse> and issueguide.catid = #form.catid#


 </cfif>
 
 <Cfif parameterexists(form.advertisers) and form.advertisers eq 'Premium'>
  
  and ParentsListings.advertiser = 4
 </Cfif>

<cfif form.digitalonly eq 'Exclude'>
	and (issueguide.digitalonly <> 'on' or issueguide.digitalonly is null or issueguide.digitalonly = '')
</cfif>	

<cfif #form.writeuplength# eq 25>
	and writeupshort <> ''
<cfelseif form.writeuplength eq 90>
and writeup <> ''
</cfif>



 <cfif #form.sortby# eq 0>
  order by category,sortby,name,issuemy desc

 <cfelse>

 order by category,rand()
 </cfif>
 </cfquery>
 
 <p>
	
<Cfoutput query="Getstuff">
 <cfif #name# eq #name[currentrow-1]# and #category# eq #category[currentrow-1]#>

 <Cfelse>
<Cfquery name="getm" datasource="#ds#">
select locationmultiple,phone,website,website2,address,city
from ParentsListings
where id = #Getstuff.pkid#
</CFQUERY>
<Cfif #category# is not #getstuff.category[currentrow-1]#>
<font size=+2><b><strong>#category#</strong></b></font>
<p>

</Cfif><span class="adv name"><font size=+1>#name#<cfif #showothername# eq 'yes'><br />#othername#</cfif><br></span></font><span class="adv list">
<cfif #address# is not ''>#address#, #city#<Cfif #category# contains 'Special Parent'>, #state# #zip# </Cfif> <br></cfif>

<Cfif #phone# is not ''>#phone#<br>
</CFIF><cfif #getm.recordcount# gt 0 and #getm.locationmultiple# is not ''><br /><br />

<cfset spec = ReReplace(getm.locationmultiple,"#chr(13)##chr(10)#","<br>","ALL")>
#spec#<br /></cfif></span>

<cfif #website# is not ''><span class="adv url">
<cfset zz = rereplace(website,'www.','','ALL')>
<cfset zz = rereplace(zz,'http://','','ALL')>
<cfset zz = rereplace(zz,'https://','','ALL')>

#zz#

<cfif #website2# is not ''>
	<cfset zz = rereplace(website2,'www.','','ALL')>
<cfset zz = rereplace(zz,'http://','','ALL')>
<cfset zz = rereplace(zz,'https://','','ALL')>

#zz#
</cfif>

</span><br /></cfif>
<cfif #email# is not '' and #showemail# eq 0><span class="adv email"><em>#email#</em></span><br /></cfif>
<cfif #offer# is not ''><span class="adv offer"><font face=arial size=+0>#offer#</font></span><br /></cfif>

<p><font size=+1 face=arial><span class="adv writeup">


<cfif #form.writeuplength# eq 25>
	<cfset zzz = rereplace(writeupshort,'www.','','ALL')>#zzz#
<cfelseif form.writeuplength eq 90>
<cfset zzz = rereplace(writeup,'www.','','ALL')>#zzz#
<Cfelse>
<cfset zzz = rereplace(writeupshort,'www.','','ALL')>#zzz#
<p>
<cfset zzz = rereplace(writeup,'www.','','ALL')>#zzz#
</cfif>

</span></font><br><br>
<!---<b>#eventtyper#</b>--->
<!---<cfif #expirationdate# is not ''><span class="adv expirationdate"><font face=times>#expirationdate#</span></font><br /></cfif>--->
<p>
</cfif>
 </Cfoutput></cfif>
</td></tr></table>