Project: Agent Website: MLS Compliance

Restrict searching on Agent websites to only their MLS

Start Date: February 23, 2011
Deadline:  
Assigned by: Cass Herrin/Mark Carlson

To do:

To be able to view an agent's website in dev:

2/24/11Start Doing Stuff

From the Home Page

  • Click on the map:  http://localhost:8500/agent/index.cfm?fuseaction=listing.SearchPropertyMapv2&st=wa
  • Search My Area:  http://localhost:8500/agent/index.cfm?fuseaction=listing.searchPropertyMap
  • My Listings:  http://localhost:8500/agent/index.cfm?fuseaction=listing.PropertySearchResults&searchString=ptyp=1,2,3|st=|premier=|sss=|ar=|cou=|cit=
    |minPrice=0|maxPrice=0|br=|bth=|minSqft=|maxSqft=|water=|ybtMin=|ybtMax=|hsn=|stor=|vew=|daysback=|NC=|ls=|address=|ln=|sub=|zip=
    |searchAgentMetauser_ID=59292|showPhotos=1|extentNorth=|extentSouth=|extentEast=|extentWest=|zoomLevel=|mapCenterX=|mapCenterY=
    |mapExtentBorder=|mapExtentLeft=|mapExtentRight=|mapExtentTop=|mapExtentBottom=|listingAction=|mapExtentLeftDefault=|mapExtentRightDefault=
    |mapExtentTopDefault=|mapExtentBottomDefault=|agencyID=|amenities=0|sftype=|mapHeight=428|mapWidth=320|sortOrder=1|searchMLS=
  • My Recent Sales:  http://localhost:8500/agent/index.cfm?fuseaction=listing.AgentSold&searchString=searchAgentMetauser_ID=59292|sftype=listing.AgentSold

Property Search Page

  • Interactive Map:  http://localhost:8500/agent/index.cfm?fuseaction=listing.SearchPropertyMapV2
  • County / City:  http://localhost:8500/agent/index.cfm?fuseaction=Listing.SearchPropertyNeighborhood
    • The count is coming from selSearch_View.cfm
  • Address / Zip:  http://localhost:8500/agent/index.cfm?fuseaction=Listing.SearchPropertyAddress
  • MLS Numbers:   http://localhost:8500/agent/index.cfm?fuseaction=Listing.SearchPropertyMLSNum
/Controllers/Listing/fbx_Switch.cfm

SearchPropertyMapV2

  • <cfset AddToQ('Listing.SearchPropertyMapV2_5')>
    • SearchPropertyMapV2_5
    • <cfset attributes.XFA.ProcessSearchProperty = "Listing.actSearchProperty">
      • In case actSearchProperty: <cfset attributes.XFA_target = "Listing.PropertySearchResults">
        • In case PropertySearchResults: <cfset AddToQ('mListing.GetProperty')>
          • In /Models/mListing/fbx_Switch.cfm, case GetProperty: <cfset AddToQ('q.selSearch_ViewAgent')>
    • <cfset attributes.XFA.ProcessSearchPropertyUpdate = "Listing.SearchPropertyMapGetListingLocationXML">

SearchPropertyNeighborhood

  • <cfset attributes.XFA.ProcessSearchProperty = "Listing.actSearchProperty">
    <cfset attributes.XFA.ProcessSearchPropertyUpdate = "Listing.SearchPropertyNeighborhood">
    <cfset AddToQ('mListing.GetProperty')>
    • In /Models/mListing/fbx_Switch.cfm, case GetProperty: <cfset AddToQ('q.selSearch_ViewAgent')>
  • <cfset AddToQ('mGeography.getCounties')>
    <cfset AddToQ('mGeography.getDistinctCityCounty')>
    <cfset AddToQ('vListing.CityNeighborhood INTO searchConstraint')>
    <cfset AddToQ('vListing.PropertyCriteria INTO searchForm')>
    <cfset AddToQ('Listing.SearchPropertyForm INTO col2 AS Layout')>
    • case SearchPropertyForm:
      <cfparam name="attributes.XFA.SearchPropertyMap" default="listing.SearchPropertyMapV2">
      <cfset attributes.XFA.SearchPropertyMLSNum = "Listing.SearchPropertyMLSNum">
      <cfset attributes.XFA.SearchPropertyAddress = "Listing.SearchPropertyAddress">
      <cfset attributes.XFA.SearchPropertyNeighborhood = "Listing.SearchPropertyNeighborhood">
      <cfset attributes.XFA.SearchPropertyArea = "listing.searchmap&map=west">
      <cfset AddToQ('vListing.SearchByConstraint')>
      • dspSearchByConstraint.cfm
        available: #request.agent.mlsid#
        navigation tabs (county/city, address, etc.)
        <div id="formContent">
        <form name="#attributes.searchFormName#"
        onsubmit="#request.onSubVar#" method="post"
        action="index.cfm?fuseaction=#attributes.XFA.ProcessSearchPropertyUpdate#" enctype="multipart/form-data">
        #searchConstraint#
        <div id="ppSearchFormContainer">#searchForm#</div>

SearchPropertyAddress

SearchPropertyMLSNum

  • <cfset attributes.XFA.ProcessSearchProperty = "Listing.actSearchByMLSNum">
    • <cfset AddToQ('Listing.PropertySearchResults')>
  • Putting the MLSID code in the PropertySearchResults CASE filters this one.

PropertySearchResults

 

Database
  • In Roster - fk_metauser_id: 59292, FirstName: Rebecca, LastName: Harksook, AgencyID: 60, mlslist: psm, mlsoffice: 7117
  • In MLS - mls_id: 1, mlsName: Northwest MLS, abbreviation: psm
  • In pub_data - id: 67451283, username: rebhart, ln: 45684, address: 10247 39th Ave SW, mls: 1, mls_office: 7117

(Checked In 2/24/11) Revision # 13534
Modified Files

Initial Search page (map count), Counties/Cities, Adress/Zip, MLS, and Results page

/Controllers/Listing/fbx_Switch.cfmSwitch for Listings page

Added <cfset attributes.searchmls = request.agent.mlsID> to 3 cases: SearchPropertyNeighborhood, PropertySearchResults, SearchPropertyAddress (ci: 2/24/11)
Added <cfparam name="request.agent.mlsID" default=""> to 3 cases: SearchPropertyNeighborhood, PropertySearchResults, SearchPropertyAddress (ci: 3/3/11, rev 13550)


Stephen Lloyd 03/03/2011