<cfinclude template="/header.cfm">
<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="">


<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>Manage Print Guide</strong></font>
 <font face=verdana size=-1><br />


<Cfif parameterexists(url.send)>


<CFMAIL
TO="#form.toemail#"
SUBJECT="#form.offer#"
        FROM="#form.salesperson#"
SERVER="us-smtp-outbound-1.mimecast.com"
>#form.writeup#</cfmail>



<cfquery name="upda" dataSource="#ds#">
update issueguide
set whosent = '#getuser.email#',
whensent = #currentdatetime#
where id = #url.id#
</cfquery>

SENT

<p>
<a href="javascript: window.history.go(-2)">Go Back</a>


<cfabort>



</Cfif>

<cfquery name="Getstuff" datasource="#ds#">
select *
from issueguide
where id = #url.id#
</cfquery>
<Cfquery name="Getmorestuff" dataSource="#ds#">
SELECT * FROM issueguidecat WHERE issueguideid = #url.id#
</cfquery>
      <Cfquery name="Getregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where id = #getstuff.catid#
order by catname
</CFQUERY>

<cfquery name="getprevious" dataSource="#ds#">
select issueguide.id,issueguide.writeup,issueguidecat.mags,issueguidecat.issuemy,issueguidecat.issue
from issueguide inner join issueguidecat on issueguide.id = issueguidecat.issueguideid
where issueguide.pkid = #Getstuff.pkid#
and year (issuemy) >= 2014
</cfquery>

<Cfquery name="Getname" datasource="#ds#">
select *
from ParentsListings
where id = #Getstuff.pkid#
</Cfquery>

<cfFORM action="emailguide.cfm?id=#url.id#&tid=#url.tid#&mag=#url.mag#&issue=#urlencodedformat(url.issue)#&send=on" method="post"  enctype="multipart/form-data"><Cfoutput>
<input type="hidden" value="#url.id#" name="id" />
<input type="hidden" value="#getname.contactemail#" name="toemail" />
<input type="hidden" value="#getname.salesperson#" name="salesperson" />

 <table>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Subject:</font></b>
  </td><td>
<input name="offer" type="text" size="100" value="NYMP Write-up for #getname.name# for #getregions.catname#	">
  </td></tr>

  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">EMail:</font></b>
  </td><td>
<text name="writeup" cols="100" rows="30" richtext="no">
Dear #getname.contactfirst# #getname.contactlist#,

We need your entry for the for #getname.name# for #getregions.catname# in:
<Cfloop from="1" to="#getmorestuff.recordcount#" index="i">
#getmorestuff.mags[i]# - #getmorestuff.issue[i]#
</Cfloop>

<Cfif #getprevious.recordcount# gt 1> 

Here are your previous entries. To pick-up one of them, simply click the link below.

<cfloop from="1"  to="#getprevious.recordcount#" index="i">


#getprevious.issue[i]# - #getprevious.mags[i]#
#getprevious.writeup[i]#
TO PICKUP - CLICK http://www.nymetroparents.com/addwriteup.cfm?id=#url.id#&pickup=#getprevious.id[i]#
--------------------------------------------------------------------------------

</cfloop>
</Cfif>
This entry is due in by Monday.

To add a new entry, click here.
http://www.nymetroparents.com/addwriteup.cfm?id=#url.id#
</textarea>
  </td></tr>
      </cfoutput>
	 </table><br>
<center><input type="submit" Value="Send"></center>
</cfform>
</td></tr></table>

</cfif>
</cfif>