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

<cfsavecontent  variable="dodah"> <cfquery name="uper" dataSource="cityguide">
update mediakit
set laststatus = 'sold - ink on paper-YEAH!'
where laststatus like '%ink on paper%'
</cfquery>

<cfquery name="uper" dataSource="cityguide">
update mediakit
set laststatus = 'None'
where laststatus is NULL
</cfquery>

<Cfif not parameterexists(url.datetime)>
<Cfset zz = #dateadd('m',-6, now())#>
<Cfset zz = #dateformat(zz,'yyyy-mm-01')#>
<Cfparam name="form.datetime" default="#zz#">
<Cfparam name="form.laststatussent" default="#dateformat(now(),'yyyy-mm-dd')#">
 </Cfif>



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


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

<Cfif parameterexists(url.areaemail)>
and area = '#url.areaemail#'

</Cfif>


<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.datetime#'</Cfif>


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

<Cfif parameterexists(url.rep) and parameterexists(form.laststatussent) and #form.laststatussent# is not ''>
and datetime <= '#form.laststatussent#'
</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.datetime#'</Cfif>

<Cfif parameterexists(url.rep) and parameterexists(url.laststatussent) and #url.laststatussent# is not ''>
and datetime <= '#url.laststatussent#'
</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
</cfquery>




<cfquery name="count" datasource="cityguide">
select count(laststatus) as counter
from mediakit
where 1 = 1

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


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

<Cfif parameterexists(url.rep) and parameterexists(form.laststatussent) and #form.laststatussent# is not ''>
and datetime <= '#form.laststatussent#'
</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.datetime#'</Cfif>

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

</cfquery>



<cfquery name="getdavlerstats" datasource="cityguide">
select laststatus, count(laststatus) as counter
from mediakit
where 1 = 1

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


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

<Cfif parameterexists(url.rep) and parameterexists(form.laststatussent) and #form.laststatussent# is not ''>
and datetime <= '#form.laststatussent#'
</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.datetime#'</Cfif>

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

group by laststatus
order by counter desc
</cfquery>


<cfquery name="countrep" datasource="cityguide">
select count(laststatus) as counter
from mediakit
where 1 = 1
<Cfif parameterexists(url.rep) and parameterexists(form.assignedto) and #form.assignedto# is not ''>and assignedto = '#form.assignedto#'</Cfif>
<Cfif parameterexists(url.rep) and parameterexists(url.assignedto) and #url.assignedto# is not ''>and assignedto = '#url.assignedto#'</Cfif>

<Cfif parameterexists(url.areaemail)>
and area = '#url.areaemail#'

</Cfif>

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

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and datetime >= '#form.datetime#'</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(form.datetime) and #form.datetime# is not ''>and datetime >= '#form.datetime#'</Cfif>

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


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

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

</cfquery>



<cfquery name="getdavlerstatsrep" datasource="cityguide">
select laststatus, count(laststatus) as counter
from mediakit
where 1 = 1
<Cfif parameterexists(url.rep) and parameterexists(form.assignedto) and #form.assignedto# is not ''>and assignedto = '#form.assignedto#'</Cfif>

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

<Cfif parameterexists(url.areaemail)>
and area = '#url.areaemail#'

</Cfif>

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

<Cfif parameterexists(url.rep) and parameterexists(form.area) and #form.area# is not ''>and area = '#form.area#'</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.laststatus) and #url.laststatus# is not ''>and laststatus = '#url.laststatus#'</Cfif>

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

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


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

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

group by laststatus
order by counter desc
</cfquery>




<div align="center"><font face=verdana size=+1><strong>Leads Stat Report

<Cfif parameterexists(form.assignedto) and #form.assignedto# is not '' and #form.assignedto# is not 'all'>
<Cfquery name="selecter" dataSource="cityguide">
select * from davlersales
where email = '#form.assignedto#'
</cfquery>
(<cfif #selecter.recordcount# eq 1><Cfoutput query="selecter">#first# #last#</Cfoutput><cfelse><Cfoutput>#form.assignedto#</Cfoutput></cfif>)
</cfif>


<Cfif parameterexists(url.assignedto) and #url.assignedto# is not '' and #url.assignedto# is not 'all'>
<Cfquery name="selecter" dataSource="cityguide">
select * from davlersales
where email = '#url.assignedto#'
</cfquery>
(<cfif #selecter.recordcount# eq 1><Cfoutput query="selecter">#first# #last#</Cfoutput><cfelse><Cfoutput>#url.assignedto#</Cfoutput></cfif>)
</cfif>

</strong></font><br /></div>

<Cfoutput>
<!--<a href="assignleadsreport.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) and not parameterexists(url.emailver)><a href="assignleadsreport.cfm">Back...</a></cfif>

 </Cfoutput>

<br>


<table><tr><td width="50%" valign="top">

<table border="1" cellpadding="4" cellspacing="0">
<tr><td bgcolor="black" colspan="3"><font face=verdana size=-1 color="white">DAVLER STATS</font></td></tr>

<tr bgcolor="black">
<td><font face=verdana size=-1 color=white><b>Status</td>
<td><font face=verdana size=-1 color=white><b>Rec'd</td>
<td><font face=verdana size=-1 color=white><b>%</td>
</tr>

<Cfoutput query="getdavlerstats">
<Cfif #laststatus# eq 'sold - ink on paper-YEAH!'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls1 = #round(perc)#>
</cfif>
</cfoutput>
<Cfoutput query="getdavlerstats">

<Cfif #laststatus# eq 'met and there is interest'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls2 = #round(perc)#>

</cfif></cfoutput>
<Cfoutput query="getdavlerstats">
<cfset ls3 = 0>
<Cfif #laststatus# eq 'have an appointment'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls3 = #round(perc)#>

</cfif>
</cfoutput>
<Cfoutput query="getdavlerstats">

<Cfif #laststatus# eq 'was unable to reach, yet'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls4 = #round(perc)#>

</cfif></cfoutput>
<Cfoutput query="getdavlerstats">
<Cfif #laststatus# eq 'met and there is no interest for now'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls5 = #round(perc)#>

</cfif></cfoutput>
<Cfoutput query="getdavlerstats">
<Cfif #laststatus# eq 'None'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#count.counter#) * 100>#round(perc)#%</td>
</tr><cfset ls6 = #round(perc)#>

</cfif>
</Cfoutput>


<tr>
<td><font face=verdana size=-1><b>Total Leads</b></td>
<td colspan="2"><center><font face=verdana size=-1><Cfoutput>#count.counter#</Cfoutput></td>
</tr>

</table>
</td>

<td width="50%" valign="top">

<cfif parameterexists(form.assignedto) or parameterexists(url.assignedto)>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td bgcolor="black" colspan="4"><font face=verdana size=-1 color="white">REP STATS</font></td></tr>

<tr bgcolor="black">
<td><font face=verdana size=-1 color=white><b>Status</td>
<td><font face=verdana size=-1 color=white><b>Rec'd</td>
<td><font face=verdana size=-1 color=white><b>%</td>
<td><font face=verdana size=-1 color=white><b>% vs. Co.</td>
</tr>


<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'sold - ink on paper-YEAH!'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls1#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>
<cfset var1 = 'on'>

</tr>
</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'met and there is interest'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls2#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var2 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'have an appointment'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>	#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls3#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var3 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'was unable to reach, yet'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls4#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var4 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'met and there is no interest for now'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls5#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var5 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
<Cfif #laststatus# eq 'None'>
<Tr>
<td><font face=verdana size=-1><b>#laststatus#</b></td>
<td><font face=verdana size=-1>#counter#</td>
<td><font face=verdana size=-1><Cfset perc = (#counter#/#countrep.counter#) * 100>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls6#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var6 = 'on'>

</cfif>
</Cfoutput>


















<cfif parameterexists(ls1)>


<Cfoutput query="getdavlerstatsrep">
<Cfif not parameterexists(var1)>
<Tr>
<td><font face=verdana size=-1><b>sold - ink on paper-YEAH</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls1#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>
<cfset var1 = 'on'>

</tr>
</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
	<Cfif not parameterexists(var2)>

<Tr>
<td><font face=verdana size=-1><b>met and there is interest</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><cfif parameterexists(ls2)><Cfset percnew = (#round(perc)#-#ls2#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></cfif></td>

</tr><cfset var2 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
		<Cfif not parameterexists(var3)>

<Tr>
<td><font face=verdana size=-1><b>have an appointment</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls3#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var3 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
		<Cfif not parameterexists(var4)>
<Tr>
<td><font face=verdana size=-1><b>was unable to reach, yet</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><cfif parameterexists(ls2)><Cfset percnew = (#round(perc)#-#ls4#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></cfif></td>

</tr><cfset var4 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
		<Cfif not parameterexists(var5)>
<Tr>
<td><font face=verdana size=-1><b>met and there is no interest for now</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><cfif parameterexists(ls5)><Cfset percnew = (#round(perc)#-#ls5#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></cfif></td>

</tr><cfset var5 = 'on'>

</cfif>
</Cfoutput>
<Cfoutput query="getdavlerstatsrep">
			<Cfif not parameterexists(var6)>

<Tr>
<td><font face=verdana size=-1><b>None</b></td>
<td><font face=verdana size=-1>0</td>
<td><font face=verdana size=-1><Cfset perc = 0>#round(perc)#%</td>
<td><font face=verdana size=-1><cfif #perc# gt 0><Cfset percnew = (#round(perc)#-#ls1#)><Cfif #percnew# lt 0><font color="red"></cfif>#percnew#%</cfif></td>

</tr><cfset var6 = 'on'>

</cfif>
</Cfoutput>

</cfif>






<tr>
<td><font face=verdana size=-1><b>Total Leads</b></td>
<td colspan="3"><center><font face=verdana size=-1><Cfoutput>#countrep.counter#</Cfoutput></td>
</tr>



</table> </cfif>


</td></tr></table>

<cfif not parameterexists(url.emailver)>
<p>
<form name=log action="assignleadsreport.cfm?rep=on" method="post">



<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 email,first,last from davlersales
	where email <> '[email protected]'
	and email <> '[email protected]'
		and email <> '[email protected]'
	and email <> '[email protected]'
	and email <> '[email protected]'

	order by last,first</cfquery><cfoutput query="getars"><option value="#email#">#last#, #first#</a></cfoutput></select>

<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 not like '%-1%' order by area</cfquery><cfoutput query="getars"><option value="#area#">#area#</a></cfoutput></select>




<Cfoutput>
Start:
<select name="datetime">

<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="">All Time</option>
<Cfloop from="1" to="12" index="i">
<option value="2022-#i#-01">2022-#i#-01</option>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<option value="2021-#i#-01">2021-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2020-#i#-01">2020-#i#-01</option>
</Cfloop>


<Cfloop from="1" to="12" index="i">
<option value="2019-#i#-01">2019-#i#-01</option>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<option value="2018-#i#-01">2018-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2017-#i#-01">2017-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2016-#i#-01">2016-#i#-01</option>
</Cfloop>


</select>


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>
<Cfloop from="1" to="12" index="i">
<option value="2022-#i#-01">2022-#i#-01</option>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<option value="2021-#i#-01">2021-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2020-#i#-01">2020-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2019-#i#-01">2019-#i#-01</option>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<option value="2018-#i#-01">2018-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2017-#i#-01">2017-#i#-01</option>
</Cfloop>

<Cfloop from="1" to="12" index="i">
<option value="2016-#i#-01">2016-#i#-01</option>
</Cfloop>


</select>

 </Cfoutput>


<select name="laststatus">
	<option value="">View Type</option>
	<option value="None" />None</option>

	<option value="sold - ink on paper-YEAH!" /> sold - ink on paper-YEAH!</option>
	<option value="met and there is interest" /> met and there is interest</option>
<option value="met and there is no interest for now" /> met and there is no interest for now</option>
<option value="have an appointment" /> have an appointment</option>
<option value="was unable to reach, yet" /> was unable to reach, yet</option>


</select>

<select name="excel">
<cfif parameterexists(form.excel)>
<cfoutput>
<option value="#form.excel#">#form.excel#</option>

</cfoutput>
</cfif>

<option value="ExcelOff">Excel Off</option>
<option value="ExcelOn">Excel On</option>

</select>



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

<cfif parameterexists(form.assignedto)>
<cfoutput>

<cfif #form.assignedto# is not ''><a href="https://www.cityguideny.com/newadmin/assignleadsreport.cfm?rep=on&assignedto=#form.assignedto#&emailver=on&datetime=#form.datetime#&laststatussent=#form.laststatussent#">Email Rep</a>
</cfif>
|
<a href="https://www.cityguideny.com/newadmin/assignleadsreport.cfm?rep=on&assignedto=#form.assignedto#&emailver=on&david=on&datetime=#form.datetime#&laststatussent=#form.laststatussent#&laststatus=#form.laststatus#">Email David</a>

<Cfif parameterexists(form.area) and #form.area# is not 'All' and #form.area# is not ''>
|
<a href="https://www.cityguideny.com/newadmin/assignleadsreport.cfm?rep=on&assignedto=#form.assignedto#&emailver=on&datetime=#form.datetime#&laststatussent=#form.laststatussent#&areaemail=#form.area#">Email Region</a>
</Cfif>

</cfoutput>
</cfif>

</form>


 </cfif>
<p>


<table width="100%" cellpadding="4" cellspacing="0" border="1">
<tr bgcolor="black">
<td></td>
<td><font face=verdana size=-1 color=white><b>SUBJECT</td>
<td><font face=verdana size=-1 color=white><b>CONTACT</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>
<cfif not parameterexists(Url.exportexcel)>
<td><font face=verdana size=-1 color=white><b>ASSGND 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 UPDATE</td>
<td><font face=verdana size=-1 color=white><b>LAST COMMENTS</td>

<td><font face=verdana size=-1 color=white><b>ASSIGNED TO</td>
</tr>
<cfoutput query="getsites"><tr>
<td><a href="https://www.cityguideny.com/newadmin/leadform.cfm?id=#id#">update</a></td>
<td><font face=verdana size=-1>#subject#</td><td>

<font face=verdana size=-1>
<Cfif parameterexists(form.excel) and #form.excel# eq 'ExcelOn'>
#name# - <a href="mailto:#email#">#email#</a> - #phonenumber#

<cfelse>
#name#<Br><font face=verdana size=-1><a href="mailto:#email#">#email#</a><br><font face=verdana size=-2>#phonenumber#
</cfif>
</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>


<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>
</tr></cfoutput>
</table>


</cfsavecontent>


<cfoutput>#dodah#</cfoutput>

<Cfif parameterexists(url.emailver)>

   <font color="red" size="+2">EMAIL SENT!</font>

<Cfquery name="Gettop" dataSource="cityguide">
select copy from columntable where id = 98023
</cfquery>

<cfif parameterexists(url.datetime)>
	<cfset form.datetime = '#url.datetime#'>
</cfif>
<cfif parameterexists(url.laststatussent)>
	<cfset form.laststatussent = '#url.laststatussent#'>
</cfif>

<cfif parameterexists(url.laststatus)>
	<cfset form.laststatus = '#url.laststatus#'>
</cfif>


<Cfif parameterexists(url.david)>

<CFMAIL
TO="[email protected]"
SUBJECT="Your Leads Report"
        FROM="David Miller <[email protected]>"
      SERVER="127.0.0.1"
type="html">
#gettop.copy#
<p><cfif not parameterexists(url.nomess)>

Below is a report showing the leads that were received from #form.datetime# to #form.laststatussent#. <p>
#dodah#</cfif>
<p>
</cfmail>

<cfelse>

<Cfif parameterexists(url.areaemail)>
<Cfquery name="Getarea" dataSource="cityguide">
select email from davlersales
where region = '#url.areaemail#'
</cfquery>

<cfoutput query="getarea">

<CFMAIL
TO="#email#"
SUBJECT="Your Leads Report"
        FROM="David Miller <[email protected]>"
 SERVER="127.0.0.1"
type="html">
#gettop.copy#
<p><cfif not parameterexists(url.nomess)>

Below is a report showing the leads that were received from #form.datetime# to #form.laststatussent#. The summary shows how you manage them compared to the Company as a whole.</cfif>
<p>
#dodah#
<p>
</cfmail>
</cfoutput>

<cfelse>

<cfif parameterexists(url.tester)>
<CFMAIL
TO="[email protected]"
SUBJECT="Your Leads Report"
        FROM="David Miller <[email protected]>"
        SERVER="127.0.0.1"
type="html">
#gettop.copy#
<cfif not parameterexists(url.nomess)>
<p>
Below is a report showing the leads that were received from #form.datetime# to #form.laststatussent#.  The summary shows how you manage them compared to the Company as a whole.
<p></cfif>
#dodah#
<p>
</cfmail>
<cfelse>

<CFMAIL
TO="#url.assignedto#"
SUBJECT="Your Leads Report"
        FROM="David Miller <[email protected]>"
       SERVER="127.0.0.1"
type="html">
#gettop.copy#
<p><cfif not parameterexists(url.nomess)>

Below is a report showing the leads that were received from #form.datetime# to #form.laststatussent#.  The summary shows how you manage them compared to the Company as a whole.</cfif>
<p>
#dodah#
<p>
</cfmail>
</cfif>


</Cfif>


</cfif>

</Cfif>

</cfif>