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

<cfparam name="url.mag" default="">
<cfparam name="url.issue" default="">
<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Manage Print Guide</strong></font>

<p>
<cfquery name="getcities" datasource="#ds#">
select distinct ParentsListings.city
from ParentsListings inner join issueguide on ParentsListings.id = issueguide.pkid
order by city
</cfquery>

<form  method="post"  enctype="multipart/form-data" action="writeupspreadsheet.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="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="SPWEST" <cfif parameterexists(form.mags) and #form.mags# eq 'SPWEST'>checked</cfif>>SP WEST
<input name="mags" type="radio" value="SPROCK" <cfif parameterexists(form.mags) and #form.mags# eq 'SPROCK'>checked</cfif>>SP ROCK
<input name="mags" type="radio" value="SPFAIR" <cfif parameterexists(form.mags) and #form.mags# eq 'SPFAIR'>checked</cfif>>SP FAIR
<input name="mags" type="radio" value="WELCOMEFAM" <cfif parameterexists(form.mags) and #form.mags# eq 'WELCOMEFAM'>checked</cfif>>WELCOME FAM


<Br />
<select name="issue">
		<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

</select>

<cfquery name="getsites" datasource="#ds#">
select *
from ParentsListingsCatMain
order by catname
</cfquery>
<select name="catid">
<option value="0">All</option>

<cfoutput query="getsites">
<option value="#id#">#catname#</option>
</cfoutput>
</select>
<select name="city">
<cfif #parameterexists(form.city)#><Cfoutput><option value="#form.city#">#form.city#</Cfoutput>
</cfif><option value="All">All
<cfoutput query="getcities">
<option value="#city#">#city#

</cfoutput></option>
</select>

<select name="sortby">

<option value="Business">Sort By

<option value="Business">Business
<option value="Salesperson">Salesperson

</select>

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

<cfif parameterexists(url.issue) and url.issue is not ''>
	<Cfset #form.issue# = '#url.issue#'>
	</Cfif>
<Cfif parameterexists(url.mags)>
			<Cfset #form.mags# = '#url.mags#'>
			</Cfif>	
			
		<cfif parameterexists(url.catid)>		<Cfset #form.catid# = #url.catid#>

<cfset form.city = 'All'>
</cfif>	

 <cfif parameterexists(form.issue)>

 <cfquery name="getstuff" datasource="#ds#">
 select issueguide.*, issueguide.pkid, issueguide.editedby,issueguidecat.issue,issueguidecat.mags,issueguide.offer,issueguide.expirationdate,issueguidecat.issueguideid,ParentsListings.*,ParentsListingsCatMain.catname 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
 issueguidecat.issue = '#form.issue#'

<Cfif parameterexists(url.salesperson)>
	and ParentsListings.salesperson = '#url.salesperson#'
</Cfif>
 <Cfif parameterexists(form.mags) and #form.mags# eq 'SPWEST'>
 and issueguidecat.mags like '%SPSUB%' and ParentsListings.region = 'Westchester'
 <Cfelseif parameterexists(form.mags) and #form.mags# eq 'SPROCK'>
 and issueguidecat.mags like '%SPSUB%' and ParentsListings.region = 'Rockland'

 <Cfelseif parameterexists(form.mags) and #form.mags# eq 'SPFAIR'>
and issueguidecat.mags like '%SPSUB%' and ParentsListings.region = 'Fairfield'

 <Cfelseif parameterexists(form.mags) and #form.mags# eq 'WELCOMEFAM'>
and issueguidecat.mags like '%WELCOMEFAM%' and ParentsListings.region = 'Westchester'

 <cfelse>
and issueguidecat.mags like '%#form.mags#%'
 </Cfif>
 <cfif #form.city# is not 'All'>and city = '#form.city#'</cfif>
 <cfif #form.catid# eq 0>

 <cfelse> 
 
 
 and issueguide.catid in (#form.catid#)

 


 </cfif>

<Cfif parameterexists(form.sortby) and #form.sortby# eq 'Salesperson'>
  order by salesperson,category,ParentsListings.name
	
	<cfelse>
  order by category,ParentsListings.name
</Cfif>
 </cfquery>


<table cellpadding="2" cellspacing="0" border="1"><Tr>
<td><B>Advertiser</B></td>
<td><B>Rep</B></td>
<!--<td><B>Sent On</B></td>--->
<td><B>Received On</B></td>
<td><B>Status</B></td>
<td><B>Pickup</B></td>

</Tr>

<Cfoutput query="getstuff">
<Tr>
<td><font size=-1>#name#</B></td>
<td><font size=-1>#salesperson#</B></td>
<!---<td><font size=-1>#dateformat(whensent,'m/d/yyyy')#</B></td>--->
<td><font size=-1>
	<Cfif #dateformat(writeupreceieved,'m/d/yyyy')# is not '1/1/2001'>
	#dateformat(writeupreceieved,'m/d/yyyy')#</Cfif></B></td>
<td><font size=-1><A 
href="https://admin.nymetroparents.com/editguide.cfm?id=#id#&tid=#pkid#">#writeupstatus# 
<cfif #writeupstatus# eq 'Edited'>by #editedby#</cfif></A></B></td>

<td>
<iframe src="writeupiframe.cfm?id=#pkid#&issueguideid=#id#" style="width:300px;height:20px;" frameborder="0" scrolling="no">
	</iframe>
</td>

</Tr>

</Cfoutput>

 </font></div></td></tr></table>

</cfif>