Project: Active / Sold Buttons

(Checked In 2/8/11) Revision #13506
Modified Files

Home Page
W/Views/vAbout/dspHomePageMessage.cfmCenter of Main page

Added Active and Sold checkboxes
Added StatusActive=1 to state links to check the checkboxes on subsequent pages. Also adjusted Extent North of Idaho and Extend South of WA. (ci: 12/20/10)
Added form validation to keep search fields numeric and to remove commas from sq ft (ci: 1/28/11)

Property List (List View Page)
W/Controllers/Utility/fbx_switch.cfm-
In switch cfLocation, commented out the "if dev or QA, display dump page" and added the else section (redirect) directly.
W/Query/sel/selSearch_View.cfmSELECT for list view
Put query in if/then to only fire if Active is checked. Added params for selSearch_View['recordCount'][1] and selSearch_View.recordCount (ci: 12/20/10)
Removed if/then around SQL query. Added call to restListingsAppendSoldCount.cfm (ci: 12/23/10)
Added attributes.listingRecordCountActive and attributes.listingRecordCountSold (ci: 1/3/11)
Added nearbyListingID to set the original property. Using listingID caused too many extra things to happen. (ci: 1/6/11)
Put Sold Count Include inside if/then to prevent in clude if past page 1. Instead, set Sold Count Total equal to Form or URL value soldCountOnce. (ci: 1/21/11)
Added soldDataFail to flag when the service is unavailable. Used in dspListView.cfm (ci: 2/8/11)
W/Query/sel/selSearch_ViewUsePagination.cfmSELECT for list view
Added paging to SQL (ci: 1/3/11)
Added if/then around cfinclude restListingsAppendSold.cfm in to only include if attributes.listingRecordCountSold GT (attributes.RESTPage * attributes.paginate) (only while there are pages) (ci: 1/21/11)
W/Views/vListing/dspListView.cfmLeft column of List View page
Added Active, Sold and Date Range to URL string on hyperlink of forward and back paging arrows. (ci:12/3/10)
Removed Active, Sold and Date Range to URL string on hyperlink of forward and back paging arrows because it is now inside the CreateSearchString function. Added Red box around Solds and added sold icon to rt-side of box. Created two copies of rows - if sold (this one) if active (this one) (ci: 12/20/10)
Changed sold icon from circle to bar (ci:12/23/10)
Added attributes.listingRecordCountActive and attributes.listingRecordCountSold. Changed include from selSearch_View.cfm to selSearch_ViewUsePagination.cfm. Added attributes.RESTPage to Prev/next arrows. Added sction to display 1 through 2 of 3 for both Sold and Active in the same space. Added Sortorder variables to each column sort choice. (ci: 1/3/11)
Added soldCountOnce to URL of Next and previous buttons (ci: 1/21/11)
Added soldDataFail to flag when the service is unavailable. Set in selSearch_View.cfm (ci: 2/8/11)
W/Views/vListing/dspSearchForm.cfmRight column of List View page
Active and Sold checlkboxes for list view page
Added Last 2 Years to Sold Drop-down (ci: 12/14/10)
Because URL.statusActive/Sold/Days are now paramed in the URL, changed isDefined to EQ 1? Added if/thens to drop-down to select current days choice. (ci: 12/20/10)
Spanned the column that the Active/Sold checkboxes are in to allow it to spread to the right without changing the column widths. (ci: 1/3/11)
Added form validation to keep search fields numeric and to remove commas from sq ft (ci: 1/28/11)

Search Landing (Map View Page)
W/Models/mListing/fbx_Switch.cfm-
Added case GetSoldListingDetail switch and set AddToQ('q.selSoldPub_View') (ci: 12/14/10)
W/Query/sel/selSearch_ViewGeo.cfmSELECT for map view
Added all columns from selSearch_View
Put query in if/then to only fire if Active is checked. Added param for selSearch_View.recordCount (ci: 12/20/10)
Added attributes.listingRecordCountActive and attributes.listingRecordCountSold (ci: 1/3/11)
Added nearbyListingID to set the original property. Using listingID caused too many extra things to happen. (ci: 1/6/11)
Added if/then around cfinclude restListingsAppendSold.cfm in selSearch_ViewGeo.cfm to only include if attributes.listingRecordCountSold GT (attributes.RESTPage * attributes.paginate) (only while there are pages) (ci: 1/21/11)
W/Views/vGeography/dspInteractiveMapControlListingPagination.cfmPrevious, Next and 1 of x on Detail Tab
Split fuseaction between #attributes.XFA.listingDetailPermaLink# and listing.SoldListingDetail based on listing.statusDescription (ci: 12/14/10)
W/Views/vGeography/dspInteractiveMapPP3.cfmMap and controls - also hidden map form values
Added var activeCount = getListingCollectionXHRActiveCount(); and var soldCount = getListingCollectionXHRSoldCount(); (ci: 1/3/11)
Added code to swap detail tab url dependent on Active/Sold (ci: 2/4/11)
W/Views/vListing/dspPropertyCriteriaPP.cfmTop-Right corner of Map View page
Added Active and Sold checkboxes
Added Last 2 Years to Sold Drop-down (ci: 12/14/10)
Because URL.statusActive/Sold/Days are now paramed in the URL, changed isDefined to EQ 1? Added if/thens to drop-down to select current days choice. (ci: 12/20/10)
Added params and hidden form fields for soldNearby, origLP, origsqft, origBR, origBTH, OrigSoldDate and PageSize. (ci: 1/3/11)
Added params and hidden form fields nearbyListingID. Disabled Active and Sold Radio Buttons when using nearbySolds. Alignment of arrows and 1 of 10 text. (ci: 1/6/11)
Changed absolute positioned div for Active/Sold/Both to float left/right to keep section from wrapping with large font size (ci: 1/19/11)
Added soldCountOnce hidden form field (ci: 1/21/11)
Added form validation to keep search fields numeric and to remove commas from sq ft (ci: 1/28/11)

Listing Detail Tab (Map View and List View)
W/Views/vListing/dspPP3ListingDetailLayout.cfmRight Column Detail tab for Active listings
Updated flyer and photos icons under "Print Options:" (ci: 12/14/10)
W/Views/vListing/dspSoldListingDetailLayout.cfmRight Column Detail tab for Sold listings
Removed gallery, made single image, Removed Mortgage Calculator and Agent info. (ci: 12/14/10)
Removed red border from image (ci: 12/20/10)
Added Nearby Comparable Solds and Features (ci: 12/21/10)
Took out if/then for image and added Java CFC Object call. Added Features by looping over Struct delivered from REST call. (ci: 12/23/10)
Removed Print Options, Flyer and Photo icons. (ci: 1/11/11)

Listing Detail Page (sold flyer)
W/Query/sel/selPub_View.cfmSELECT for the POSTgres Detail in Map View
 
W/Query/sel/selSoldPub_View.cfmSELECT for the POSTgres Detail in Map View
Copied the POSTGRES stuff from /RESTServices/restListingsAppendSold.cfm (ci: 12/14/10)
Added cdom and Features to SQL QueryNew(). Updated URL for REST call with v2 and with var for header URL. (ci: 12/23/10)
W/Views/vGeography/dspInteractiveMapControlListingDetailPagination.cfmPrevious, Next and 1 of x
Split fuseaction between #attributes.XFA.listingDetailPermaLink# and listing.SoldListingDetail based on listing.statusDescription (ci: 12/14/10)
W/Views/vLayout/dspPublicHeader.cfmLogin, Message, Box top of page with logo, and space below
Added listing.SoldListingDetailUpdated fuseaction to if/then to hide H3 page title (ci: 12/13/10)
W/Views/vListing/dspListingDetailPublicUpdated.cfmBody of page - photo, specs and maps

Removed NSEW URL attributes from nearbySolds link and added zoomLevel.(ci: 1/6/11)
Updated Comparable sold link to only display if in MLS 1,2,3 or 57 (ci: 2/7/11)

W/Views/vListing/dspSoldListingDetailPublicUpdated.cfmBody of page - photo, specs and maps

Changed Photo Gallery to single image. Removed Mortgage Calculator and Agent info. (ci: 12/13/10)
Removed Red border from image (ci: 12/20/10)
Took out if/then for image and added Java CFC Object call. Added Nearby Solds link. Converted Features from selSearch_View to Struct format. (ci: 12/23/10)
Added origBR, origBTH, origLP, origsqft and origSoldDate to Nearby Solds link. (ci: 1/3/11)
Removed NSEW URL attributes from nearbySolds link and added zoomLevel.(ci: 1/6/11)
Lowercase Neighborhood. Hide Walking Distance, Bing map, Street View (ci: 1/11/11)
Updated Comparable sold link to only display if in MLS 1,2,3 or 57 (ci: 2/7/11)

W/Views/vListing/dspListingDetailPublicUpdated.cfmBody of page - photo, specs and maps

Removed NSEW URL attributes from nearbySolds link and added zoomLevel (ci: 1/6/11)

Shared Supporting Files
CustomTags/OpenHouseControl.cfmDrop-down for Open House in Search forms

Added option for Last Year of Open Houses and wrapped it with<cfif request.Environment NEQ "prod"> (ci: 1/3/11)
CustomTags/setEnvironment.cfmSettings for dev, wa, beta, preview and prod

Added <cfset varables.RESTServicesHeader = "hampstead.windermere.com:8080" >to top. <cfset request.RESTServicesURL = "http://#variables.RESTServicesHeader#" > to QA, Preview, Beta and Production. And added <cfset request.RESTServicesURL = "http://172.29.8.153:8080" > to dev. (ci: 12/23/10)
W/Controllers/Listing/fbx_Switch.cfm-
Copied the PP3ListingDetail case (Switch) to SoldListingDetail. Changed AddToQ('mListing.GetListingDetail') to AddToQ('mListing.GetSoldListingDetail') and AddToQ('vListing.PP3ListingDetailLayout into blankLayoutFile') to AddToQ('vListing.SoldListingDetailLayout into blankLayoutFile')
Copied listingDetailUpdated case (Switch) to SoldListingDetailUpdated. Changed AddToQ('mListing.GetListingDetail') to AddToQ('mListing.GetSoldListingDetail')> and AddToQ('vListing.ListingDetailPublicUpdated into col2') to AddToQ('vListing.SoldListingDetailPublicUpdated into col2')
Added mListing.CreateSearchString to PropertyListView case (ci: 12/20/10)
W/CFC/image/listingImage.cfcGets Image Data

Added imgStore and imgID to imgStruct for each set (PG, TX, MLS) (ci: 1/7/11)
W/CFC/persist/OpenHouse.cfcOpen House functions

Set width and height of open house icon. Changed 36x32 to 47x18. Set date ranges of search based on ID of drop-down from search form. Added case 999 for last 365 days. (ci: 12/14/10)
W/js/map/lib.jsMouseover icon pop-up box and map view list right-side builder

Added jQuery slide up and down at bottom of script for #soldtime div
Update Open House icon src and size. Add Red box around image if sold. Turn Price: Red. Hide Bed/Bath if result is"/" (ci: 12/14/10)
Set tempY to 0 from +25, Set tempX to +13 , -143 (added offset to right in if/then) Added sold icon to right side of box. (ci: 12/20/10)
Changed sold icon from circle to bar (ci:12/23/10)
Changed sold icon from bar to new icon. Adjusted position and size for new Sold and Open House icons. Added code to handle paging in function listingPagination() (ci: 1/3/11)
Changed 1 of 10 text to handle Both Active and Sold on same page. Removed paging arrows if on first or last set. (ci: 1/6/11)
Added eMsgBoundary height to top value of eMsg so that the message boxes don't overlap (ci: 1/7/11)
Removed height of 55 specific on div of results properties right side table rows to allow expansion when text is more than three lines. (ci: 1/19/11)
Added var soldCountOnce = getListingCollectionXHRSoldCount( ); document.searchListingForm.soldCountOnce.value = soldCountOnce; at end of Build summary function in lib.js after the loop to fill the hidden form field in dspPropertyCriteriaPP.cfm with the total sold value. (ci: 1/21/11)
Added code to change the URL under Remove boundary by updating to current form value of Listing status and sold days. (ci: 1/27/11)
When Sold or Both is selected, clear the values of Lot Size, New in last, Open House, Rentals, Photo Gallery and Single Story. (ci: 2/7/11)
Line 1453 - changed eval(key) to FIX_ARRAY.length to get out of key global variable sometimes becoming "listingID" instead of a number. (ci: 2/7/11)

W/js/map/listingMapRegistry.js-
Added Sold entry for House icon and Condo icon. (ci: 12/3/10)
Added standard and Sold icons for Land, Manufactured and Multi-family (ci:12/9/10)
Commented out icons for Condo, Land, Manufactured and Multi-family. Swapped out pin for map_house icons. (ci: 12/14/10)
Set all iOffsets to 0,0 (ci: 12/20/10)
Set all iOfsetts back to 10,40 (ci: 1/6/11)
Set all iOfsetts to 10,60 (ci: 1/24/11)
W/js/map/listingMapXHR.js-
Added locStatus and statusDescription to the end of various functions (ci: 12/3/10)
Added soldDate (ci:12/6/10)
Added LISTING_COLLECTION_COUNT_ACTIVE and LISTING_COLLECTION_COUNT_SOLD vars and two functions (ci:1/3/11)
W/js/map/map.js-
Added locStatus and statusDescription to the end of various functions (ci: 12/3/10)
Added soldDate (ci:12/6/10)
W/js/map/msve.js-
Added conditional for Sold icon type in function ListingMSVESetMapCallouts() (ci: 12/3/10)
var iconType = (fix.statusDescription == 'Sold') ? "sold_" + this.iconStyle : "std_" + this.iconStyle;
Nested Sold icon assignment within standard conditional of Open House. (ci: 12/14/10)
W/Models/mListing/actCreateSearchStringcfmBuilds Search string in URL
Added Solddays, StatusActive and StatusSold to search String. (ci: 12/20/10)
Added SortOn and Decending to search String. (ci: 1/3/11)
W/Models/mListing/actInitSlideViewer.cfmSets up Photo Gallery slide show viewer
Commented out cflocation that opens error message if the listing is off market. (ci: 12/14/10)
W/Models/mListing/actListingCollectionThin.cfmBuilds XML file that contains values being set
in function addLoctaionFix() and locationFix()
Added statusDescription and ptyp (ci:12/3/10)
Added soldDate (ci:12/6/10)
selSearch_View.statusDescription splits fuseaction #attributes.XFA.listingDetailPermaLink# and listing.SoldListingDetail (ci:12/14/10)
Added attributes.listingRecordCountActive and attributes.listingRecordCountSold (ci: 1/3/11)
W/RESTServices/restListingAppendSold.cfmGets sold data

Changed search criteria (ci:12/3/10)
Added Property Types, Sq Ft, Sold Price, Yr Built, Bed, Bath, Waterfront, View, New Cons., Premier Prop., Sold Days (ci:12/6/10)
Added Lat/Long boundaries, Added Query to get Images.
Added complete Query of selSearch_View.cfm to build empty recordset in case there are 0 results in Active search. (ci: 12/13/10)
Added sortOrder code from selSearch_View.cfm, removed complete query and added just a QueryNew with all column names inside an if/then - if Active is not checked (ci: 12/20/10)
Made REST header URL a variable. Added QuerySetCell lines to add ListingNumber data to ln and MLSid to mls. Added cf_error code in <cfcatch> (ci: 12/23/10)
Added nearbyRank to SoldOnly QueryNew(). Added datatyping to SoldOnly QueryNew(). Added search attributes RESTPage, PageSize, SortOn and Descending. If only 1 record returns from REST, JSON removes a struct layer; Added if/then to put Array layer back in if only one record. Changed if/then around Append code from IsDefined('restfulSoldData') to ListingStruct.listingID NEQ "Invalid JSON". Added formulas for NearbyRank. Added sortorder option 99 for NearbyRank. (ci: 1/3/11)
Changed SELECT * in the Sort QofQ to a listing of every field. (ci: 1/6/11)
Removed REST_images query and replaced with listingImage CFC. (ci: 1/7/11)
Changed references to Sold_LP to Sold_SoldPrice (ci: 1/10/11)
Matched datatypes of QueryNew() with data from Rest Service and updated. (ci: 2/1/11)

W/RESTServices/restListingAppendSoldCount.cfmGets sold data

Create search string and use 'count' REST method. (ci:12/23/10)
W/Style/map/lib.cssStyles for Map page?
Changed position and width and height of Open House icon (#ohpng) over thumb on pop-up over pin. Added top-padding to summary-container. Changed background position of icon and left-padding of drop-down for Open House search area. (ci: 12/14/10)
Copied #ohpng and made #soldpng for icon over image in pop-up table. (ci: 12/20/10)
Adjusted size and position of New Open House and Sold icons (ci: 1/3/11)
W/Views/vLayout/blankLayout.cfmGeneric Layout file <html><head><body>
Added white background to <body> based on fuseaction. If PP3ListingDetail OR listing.SoldListingDetail.
Add SoldListingDetail to conditional to hide message (ci: 12/14/10)

Stephen Lloyd 02/08/2011