| Server IP : 104.21.21.239 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/nympadmin/ |
Upload File : |
<body style="margin:0;padding:0;">
<cfif parameterexists(url.submit)>
<cfquery name="geter" dataSource="#ds#">
select * from issueguide
where id = #form.picker#
</cfquery>
<Cfquery name="deleter" datasource="#ds#">
update
issueguide
set writeup = '#geter.writeup#',
editedby = 'Pickup',
writeupstatus = 'Submitted',
writeupreceieved = #currentdatetime#
where id = #url.issueguideid#
</Cfquery>
DONE<cfabort>
<cfelse>
<cfform name=log action="writeupiframe.cfm?id=#url.id#&issueguideid=#url.issueguideid#&submit=on" method="post" enctype="multipart/form-data">
<font face=verdana size=-2>
<Cfset lastmonth = dateadd('m',-1, currentdatetime)>
<Cfset lastmonth = dateformat(lastmonth,'m')>
<cfquery name="egetprevious" 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 = #url.id#
and year (issuemy) >= 2014
and month(issuemy) > #lastmonth#
and issueguide.id <> #url.issueguideid#
order by issueguide.id desc
</cfquery>
<cfif #egetprevious.recordcount# gt 0>
<select name="picker">
<option value="Pick for Pickup">Pick for Pickup</option>
<cfloop from="1" to="#egetprevious.recordcount#" index="z">
<Cfoutput>
<option value="#egetprevious.id[z]#">
#egetprevious.issue[z]# - <Cfif #egetprevious.mags[z]# eq 'RP'>
Rockland
<cfelseif #egetprevious.mags[z]# eq 'BAP'>
Big Apple
<cfelseif #egetprevious.mags[z]# eq 'WP'>
Westchester
<cfelseif #egetprevious.mags[z]# eq 'BP'>
Brooklyn
<cfelseif #egetprevious.mags[z]# eq 'QP'>
Queens
<cfelseif #egetprevious.mags[z]# eq 'FP'>
Fairfield
<cfelseif #egetprevious.mags[z]# eq 'NP'>
Nassau
<cfelseif #egetprevious.mags[z]# eq 'SP'>
Suffolk
<cfelse>
#egetprevious.mags[z]#
</Cfif> Parent</option></Cfoutput>
</cfloop>
</select>
</cfif>
<input type="submit" Value="PICKUP">
</cfform>
</cfif>
</body>