rendered paste body <cffunction name="getMarkersBrowse" access="remote" returntype="query">
<cfargument name="searchstr" required="no" hint="searchstr" displayname="Keyword to search for">
<cfargument name="car_make" required="no" hint="car_make" displayname="The Car Make if defined">
<cfargument name="searchzip" required="no" hint="searchzip" displayname="Zip code if user is not dragging the map">
<cfargument name="radiusmiles" required="no" hint="radiusmiles" displayname="Search within this mile radius.">
<cfargument name="searchview" required="no" hint="searchview" displayname="Search through what type FALSE=members TRUE=Cars.">
<cfargument name="lat" required="no" hint="Latitude" displayname="Current Map Centered Latitude">
<cfargument name="lng" required="no" hint="Longitude" displayname="Current Map Centered Longitude">
<cfargument name="zoomlvl" required="no" hint="Zoom" displayname="Current Map Zoom Level">
<cfset var getBrowseQueryResultsTMP = "" />
<cfset var getBrowseQueryResults = "" />
<cfset var GeoBoxed = "" />
<cfset GeoBoxed = CreateObject("component","geo").GeoBox(arguments.lat,arguments.lng,arguments.radiusmiles)>
<CFQUERY NAME="getBrowseQueryResultsTMP" DATASOURCE="streets">
SELECT
markers.id,
markers.streetsid,
markers.address1,
markers.address2,
markers.city,
markers.state,
markers.zip,
markers.country,
markers.eventdate,
markers.iconid,
markers.latitude,
markers.longitude,
markers.lonlatmatch,
markers.markerdetails,
markers.markername,
markers.view,
icontypes.id AS IconTypesID,
icontypes.IconImgPath,
icontypes.IconImgName
FROM markers
LEFT JOIN icontypes ON markers.iconid = icontypes.ID
WHERE
markers.latitude
BETWEEN
#geoboxed.latmin#
AND
#geoboxed.latmax#
AND
markers.longitude
BETWEEN
#geoboxed.lonmin#
AND
#geoboxed.lonmax#
AND
markers.view = 6
AND
(
markers.streetsid = 0
OR
(markers.streetsid IN(select id FROM users WHERE users.username LIKE '%#arguments.searchstr#%' OR users.name LIKE '%#arguments.searchstr#%'))
OR
(markers.streetsid IN(select userid FROM garage WHERE garage.car_name LIKE '%#arguments.searchstr#%'))
OR
(markers.streetsid IN(select streetsid FROM garagedescriptions WHERE garagedescriptions.details LIKE '%#arguments.searchstr#%'))
OR
(markers.streetsid IN(select userid FROM garage WHERE garage.car_make LIKE '%#arguments.car_make#%'))
)
GROUP BY markers.streetsid
</CFQUERY>
<cfset getBrowseQueryResults = QueryNew(
"ADDRESS1,ADDRESS2,CITY,COUNTRY,EVENTDATE,ICONID,ICONIMGNAME,ICONIMGPATH,ICONTYPESID,ID,LATITUDE,LONGITUDE,LONLATMATCH,MARKERDETAILS,MARKERNAME,STATE,STREETSID,VIEW,ZIP",
"VarChar,VarChar,VarChar,VarChar,Date,Integer,VarChar,VarChar,Integer,Integer,VarChar,VarChar,Integer,VarChar,VarChar,VarChar,Integer,Integer,Integer"
)>
<cfset holder = ArrayNew(1)>
<cfset newlon = "" />
<cfset newlat = "" />
<cfset adby = ".000005000000">
<cfset cfloopcounter = 0>
<cfoutput query="getBrowseQueryResultsTMP">
<cfset cfloopcounter = cfloopcounter+1>
<cfif #ArrayLen(holder)# GT 1>
<cfloop index="Dim1" from="1" to="#ArrayLen(holder)#">
<cfif holder[Dim1] CONTAINS LATITUDE or holder[Dim1] CONTAINS "LONGITUDE">
<cfset NEWLATITUDE = LATITUDE+adby>
<cfset NEWLONGITUDE = LONGITUDE+adby>
<cfelse>
<cfset NEWLATITUDE = LATITUDE>
<cfset NEWLONGITUDE = LONGITUDE>
</cfif>
</cfloop>
<cfelse>
<cfset NEWLATITUDE = LATITUDE>
<cfset NEWLONGITUDE = LONGITUDE>
</cfif>
<cfset holder[cfloopcounter] = "#LATITUDE#,#LONGITUDE#">
<cfset temp = QueryAddRow(getBrowseQueryResults)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ADDRESS1", ADDRESS1)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ADDRESS2", ADDRESS2)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "CITY", CITY)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "COUNTRY", COUNTRY)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "EVENTDATE", EVENTDATE)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ICONID", ICONID)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ICONIMGNAME", ICONIMGNAME)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ICONIMGPATH", ICONIMGPATH)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ICONTYPESID", ICONTYPESID)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ID", ID)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "LATITUDE", NEWLATITUDE)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "LONGITUDE", NEWLONGITUDE)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "LONLATMATCH", LONLATMATCH)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "MARKERDETAILS", MARKERDETAILS)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "MARKERNAME", MARKERNAME)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "STATE", STATE)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "STREETSID", STREETSID)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "VIEW", VIEW)>
<cfset temp = QuerySetCell(getBrowseQueryResults, "ZIP", ZIP)>
<cfset adby = adby+.000005000000>
</cfoutput>
<cfreturn getBrowseQueryResults />
</cffunction>