<Cfif parameterexists(form.datetime)>
	<cfcookie name="datetime" value="#form.datetime#" expires="NEVER">
</Cfif>
<Cfif parameterexists(form.datetimeyear)>
	<cfcookie name="datetimeyear" value="#form.datetimeyear#" expires="NEVER">
</Cfif>
<Cfif parameterexists(form.laststatussentyear)>
	<cfcookie name="laststatussentyear" value="#form.laststatussentyear#" expires="NEVER">
</Cfif>
<Cfif parameterexists(form.laststatussent)>
	<cfcookie name="laststatussent" value="#form.laststatussent#" expires="NEVER">
</Cfif>

<Cfif parameterexists(form.area)>
	<cfcookie name="area" value="#form.area#" expires="NEVER">
</Cfif>
<Cfif parameterexists(form.assignedto)>
	<cfcookie name="assignedto" value="#form.assignedto#" expires="NEVER">
</Cfif>
<Cfif parameterexists(form.status)>
	<cfcookie name="status" value="#form.status#" expires="NEVER">
</Cfif>




<cfif IsDefined("Cookie.datetime")>
<Cfparam name="form.datetime" default="#cookie.datetime#">
</cfif>
<cfif IsDefined("Cookie.datetimeyear")>
<Cfparam name="form.datetimeyear" default="#cookie.datetimeyear#">
</cfif>

<cfif IsDefined("Cookie.laststatussentyear")>
<Cfparam name="form.laststatussentyear" default="#cookie.laststatussentyear#">
</cfif>
<cfif IsDefined("Cookie.laststatussent")>
<Cfparam name="form.laststatussent" default="#cookie.laststatussent#">
</cfif>
<cfif IsDefined("Cookie.area")>
<Cfparam name="form.area" default="#cookie.area#">
</cfif>
<cfif IsDefined("Cookie.assignedto")>
<Cfparam name="form.assignedto" default="#cookie.assignedto#">
</cfif>
<cfif IsDefined("Cookie.status")>
<Cfparam name="form.status" default="#cookie.status#">
</cfif>










<cfif parameterexists(Session.email) and (Session.email IS NOT -1)>

<cfif parameterexists(url.del)>
<cfquery name="getsites" datasource="cityguide">
delete
from mediakit
where id = #url.id#</cfquery>

</cfif>
<cfif parameterexists(url.sendme)>
<cfparam name="form.assignedcomments" default="">
<cfquery name="getsites" datasource="cityguide">
select *
from mediakit
where id = #url.id#</cfquery>

<cfset assignme = #rereplace(form.assignedto,' ','','ALL')#>

<CFMAIL
TO="#assignme#"
SUBJECT="Lead from Website - #getsites.subject#"
        FROM="David Miller <[email protected]>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
This lead came in through the website.
 <p>
 #form.assignedcomments#
 <p>
Please contact the client IMMEDIATELY. Report back to me in 72 hours on the form you will be emailed..
<p>
David

<p>

<font face=verdana size=-1>Subject: #getsites.subject# <br />
Name: #getsites.name# <br />
<font face=verdana size=-1>Email: #getsites.email#<br />
<font face=verdana size=-1>Area: #getsites.area# <br />
<font face=verdana size=-1>Phone: #getsites.phonenumber# <br />
<font face=verdana size=-1>Message: #getsites.message#
<br /><br />
<font face=verdana size=-1>Submitted On: #dateformat(getsites.datetime,'m/d/yyyy')#
<br /><br />



</cfmail>


<Cfquery name="updater" datasource="cityguide">
update mediakit
set assignedto = '#form.assignedto#',
assignedcomments = '#form.assignedcomments#',
assignedon = #currentdatetime#,
laststatussent = #currentdatetime#
where id = #url.id#
</Cfquery>


</cfif>

<cfif #dateformat(now(),'m')# gt 6>
<Cfparam name="form.datetime" default="1">
<Cfparam name="form.datetimeyear" default="#dateformat(now(),'yyyy')#">
<Cfelse>
<Cfparam name="form.datetime" default="1">
<Cfset zzz = #dateadd('yyyy',-1,now())#>
    <Cfif #currentdatetime# lt '2020-07-31'>
<Cfparam name="form.datetimeyear" default="#dateformat(zzz,'yyyy')#">
    <cfelse>
<Cfparam name="form.datetimeyear" default="#dateformat(now(),'yyyy')#">
</Cfif>
</cfif>


<cfquery name="getsites" datasource="cityguide">
select *
from mediakit
where 1 = 1

<Cfif parameterexists(url.rep) and parameterexists(form.area) and #form.area# is not ''>and area = '#form.area#'</Cfif>
<Cfif parameterexists(url.rep) and parameterexists(form.assignedto) and #form.assignedto# is not ''>and assignedto = '#form.assignedto#'</Cfif>
<Cfif parameterexists(url.rep) and parameterexists(form.laststatus) and #form.laststatus# is not ''>and laststatus = '#form.laststatus#'</Cfif>


<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and datetime >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>


<Cfif parameterexists(url.rep) and parameterexists(form.datetime) and #form.datetime# is not ''>and datetime >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>

<Cfif parameterexists(url.rep) and parameterexists(form.laststatussent) and #form.laststatussent# is not ''>
and datetime <= '#form.laststatussentyear#-#form.laststatussent#-30'
</Cfif>



<Cfif parameterexists(url.rep) and parameterexists(url.area) and #url.area# is not ''>and area = '#url.area#'</Cfif>
<Cfif parameterexists(url.rep) and parameterexists(url.assignedto) and #url.assignedto# is not ''>and assignedto = '#url.assignedto#'</Cfif>
<Cfif parameterexists(url.rep) and parameterexists(url.laststatus) and #url.laststatus# is not ''>and laststatus = '#url.laststatus#'</Cfif>


<Cfif parameterexists(url.rep) and parameterexists(url.datetime) and #url.datetime# is not ''>and datetime >= '#url.datetimeyear#-#url.datetime#-01'</Cfif>

<Cfif parameterexists(url.rep) and parameterexists(url.laststatussent) and #url.laststatussent# is not ''>
and datetime <= '#url.laststatussentyear#-#url.laststatussent#-30'
</Cfif>

<Cfif parameterexists(form.searcher)>
and (name like '%#form.searcher#%' or message like '%#form.searcher#%' or email like '%#form.searcher#%'  or subject like '%#form.searcher#%' )

</cfif>



order by ID desc

<cfif (#cgi.HTTP_USER_AGENT# contains 'iphone' or #cgi.http_user_agent# contains 'ipad')>
limit 0,100</cfif>
</cfquery>

<cfoutput></cfoutput>

<cfif not parameterexists(Url.exportexcel)>



<div align="center"><font face=verdana size=+1><strong>View Leads</strong></font><br />

<Cfoutput>
<a href="assignleads.cfm?rep=on&exportexcel=on<Cfif parameterexists(url.rep) and parameterexists(form.area) and #form.area# is not ''>&area=#form.area#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.assignedto) and #form.assignedto# is not ''>&assignedto=#form.assignedto#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.laststatus) and #form.laststatus# is not ''>&laststatus=#form.laststatus#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.datetime) and #form.datetime# is not ''>&datetime=#form.datetime#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.laststatussent) and #form.laststatussent# is not ''>&laststatussent=#form.laststatussent#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.datetimeyear) and #form.datetimeyear# is not ''>&datetimeyear=#form.datetimeyear#</Cfif><Cfif parameterexists(url.rep) and parameterexists(form.laststatussentyear) and #form.laststatussentyear# is not ''>&laststatussentyear=#form.laststatussentyear#</Cfif>">Export to Excel</a>

<cfif parameterexists(url.rep)>| <a href="assignleads.cfm">Back...</a></cfif>

 </Cfoutput>


<p>
<form name=log action="assignleads.cfm?rep=on" method="post">

<select name="area">
<Cfif parameterexists(form.area) and #form.area# is not ''><cfoutput><option value="#form.area#">#form.area#</option></cfoutput></Cfif>
<Cfif parameterexists(url.area) and #url.area# is not ''><cfoutput><option value="#url.area#">#url.area#</option></cfoutput></Cfif>

<option value="">View All Areas</option>
<cfquery name="getars" datasource="cityguide">select distinct area from mediakit where area <> '' and area <> "-1'" order by area</cfquery><cfoutput query="getars"><option value="#area#">#area#</a></cfoutput></select>


<select name="assignedto">
<Cfif parameterexists(form.assignedto) and #form.assignedto# is not ''><cfoutput><option value="#form.assignedto#">#form.assignedto#</option></cfoutput></Cfif>
<Cfif parameterexists(url.assignedto) and #url.assignedto# is not ''><cfoutput><option value="#url.assignedto#">#url.assignedto#</option></cfoutput></Cfif>

<option value="">View All Reps</option>
<cfquery name="getars" datasource="cityguide">select distinct assignedto from mediakit where assignedto <> '' and year(assignedon) >= 2016 order by assignedto</cfquery><cfoutput query="getars"><option value="#assignedto#">#assignedto#</a></cfoutput></select>

<select name="laststatus">
<Cfif parameterexists(form.laststatus) and #form.laststatus# is not ''><cfoutput><option value="#form.laststatus#">#form.laststatus#</option></cfoutput></Cfif>
<Cfif parameterexists(url.laststatus) and #url.laststatus# is not ''><cfoutput><option value="#url.laststatus#">#url.laststatus#</option></cfoutput></Cfif>


<option value="">View All Status</option>
<cfquery name="getars" datasource="cityguide">select distinct laststatus from mediakit where laststatus <> '' order by laststatus</cfquery><cfoutput query="getars"><option value="#laststatus#">#laststatus#</a></cfoutput></select>

<Cfoutput>
Request Month Start:
<select name="datetime" style="width:50px">

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''><option value="#form.datetime#">#form.datetime#</option></Cfif>
<Cfif parameterexists(url.datetime) and #url.datetime# is not ''><option value="#url.datetime#">#url.datetime#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="datetimeyear"  style="width:60px">


<Cfif parameterexists(form.datetimeyear) and #form.datetimeyear# is not ''><option value="#form.datetimeyear#">#form.datetimeyear#</option></Cfif>
<Cfif parameterexists(url.datetimeyear) and #url.datetimeyear# is not ''><option value="#url.datetimeyear#">#url.datetimeyear#</option></Cfif>


<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>

</select>

Request Month End:
<select name="laststatussent" >
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''><option value="#form.laststatussent#">#form.laststatussent#</option></Cfif>
<Cfif parameterexists(url.laststatussent) and #url.laststatussent# is not ''><option value="#url.laststatussent#">#url.laststatussent#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="laststatussentyear">
<Cfif parameterexists(form.laststatussentyear) and #form.laststatussentyear# is not ''><option value="#form.laststatussentyear#">#form.laststatussentyear#</option></Cfif>
<Cfif parameterexists(url.laststatussentyear) and #url.laststatussentyear# is not ''><option value="#url.laststatussentyear#">#url.laststatussentyear#</option></Cfif>

<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>

</select>

<input name="searcher" placeholder="Enter Text to Search">

 </Cfoutput>


<input type="submit" Value="Filter"></font></form>

</cfif>

<p>


<table width="100%" cellpadding="4" cellspacing="0" border="1"><tr bgcolor="black">
<td><font face=verdana size=-1 color=white><b>SUBJECT</td>
<td><font face=verdana size=-1 color=white><b>NAME</td>
<td><font face=verdana size=-1 color=white><b>EMAIL</td>
<td><font face=verdana size=-1 color=white><b>PHONE</td>

<td><font face=verdana size=-1 color=white><b>AREA</td>
<td><font face=verdana size=-1 color=white><b>MESSAGE</td>
<td><font face=verdana size=-1 color=white><b>DATE</td>
<td><font face=verdana size=-1 color=white><b>ASSIGNED</td>
<cfif not parameterexists(Url.exportexcel)>
<td><font face=verdana size=-1 color=white><b>ASSIGNED ON</td>
</cfif>

<td><font face=verdana size=-1 color=white><b>LAST STATUS</td>
<td><font face=verdana size=-1 color=white><b>LAST STATUS UPDATE</td>
<td><font face=verdana size=-1 color=white><b>LAST STATUS COMMENTS</td>
<td><font face=verdana size=-1 color=white><b>ASSIGNED TO</td>

</tr>
<cfoutput query="getsites"><tr>
<td><font face=verdana size=-1>#subject#</td><td><font face=verdana size=-1>#name#</td><td><font face=verdana size=-1><a href="mailto:#email#">#email#</a></td><td><font face=verdana size=-1>#phonenumber#</td>
<td><font face=verdana size=-1><a href="assignleads.cfm?area=#area#">#area#</a></td>
<td><font face=verdana size=-2>#message#</td><td><font face=verdana size=-1>#dateformat(datetime,'m/d/yy')#</td>
<cfif not parameterexists(Url.exportexcel)><td><font face=verdana size=-1><form name=log action="assignleads.cfm?sendme=on&id=#ID#" method="post" enctype="multipart/form-data"><font face=verdana size=-1>e:<input name="assignedto" value="#assignedto#" size="20"><br />c:<input name="assignedcomments" value="#assignedcomments#" size="20"><br />
<input type="submit" Value="SEND"></font></form><table width="150"><Tr><Td></Td></Tr></table></td></cfif>
<td><font face=verdana size=-1><cfif #assignedon# is not ''>#dateformat(assignedon,'m/d/yy')#</small> </cfif></td>
<td><font face=verdana size=-1>#laststatus#</td><td><font face=verdana size=-1>#dateformat(laststatussent,'m/d/yy')#</td><td><font face=verdana size=-1>#laststatusother#</td><td><font face=verdana size=-1>#assignedto#</td>
<cfif not parameterexists(Url.exportexcel)><td><font face=verdana size=-1><a href="assignleads.cfm?del=on&id=#ID#"onclick="return confirm('Are you sure?');">Delete</a><p></td></cfif></tr></cfoutput>
</table>

<p>

</cfif>