Stephen Lloyd

Software Engineer

3/29/11Tuesday
  • Basic Agent websites produce "The map file specified (map=) could not be found." added to listing.fbx_Switch.cfm Case: SearchMap <cfelse><cfset attributes.map = "west">
3/28/11Monday
  • Found the list of Cities in the autocomplete - js/jquery/autocomplete_cities.js
  • Gmail error inbox 6257 of 7566 (82%), earliest message = Feb 15.
3/24/11Thursday
  • Updated QA issues with criteria form alignment, catcha box size
  • Gmail error inbox limit = 7564. Had 7503 in morning, changed to 7093 in afternoon. Earliest message = Feb 15
3/23/11Wednesday
  • Windermere only Rentals
  • Captcha - figured out double jquery.js link
3/22/11Tuesday
  • Windermere only Rentals
    • Joy: use WHERE username <> NWMLS
  • Captcha all working, except, now autocomplete is broken on the home page. Can't have two versions of the jquery libraries apparently.
3/21/11Monday
  • Captcha ticket - sent JP question about PHP files
  • Friday Harbor, San Juan Island
3/20/11Sunday
  • Made progress on captcha ticket
  • Had car broken into
3/18/11Friday
  • Sent Facebook/Twitter project to QA
    • Click the facebook button on Events: http://localhost:8500/pub/index.cfm?fuseaction=content.libraryHTMl&contentID=114989 the description should be "Looking for a Great Family..." still shows "Windermere's communiuty involvement..."
      May have to lint.
  • Added Orcas Island to list of fixes.
  • Looked at captcha ticket
3/17/11Thursday
  • Bug 168620 – City, State, Took out space between city and comma, rev 13569
  • Bug 113945 – Walkscore, also removed View Map and Nearby Solds link, rev
  • Bug 152626 – Fixed Lincoln City, OR
3/16/11Wednesday

Sent three bugs to QA

  • Bug 168620 – City, State, rev 13564
  • Bug 168656 – Office Attribution, rev 13565
  • Bug 113945 – Walkscore, rev 13566
3/15/11Tuesday
  • Facebook link from property doesn't grab image or description or title. Because link from dev database targets a bad id in the live database. Need to find a property that exists in both. id=76232455
  • JP: to resolve the syntax error of fix.earth.y= ; add an if '', set current center. Look at 6.3 Bing Map API docs online to find correct call.
  • 11 apples in a bowl put out just before lunch were gone by 4. Apples - 1, John Jones - 0.
3/14/11Monday
  • Bug Triage meeting
  • 3/14 release went live.
  • Asked Database team (Joy) to add descriptions of about us pages to Live database
  • Asked JP to create branch Fiyero
  • Believe to have fixed the minsqft js error in IE on MLS view with
    if( document.searchListingForm.searchConstraintTypeWidget[1].checked ) return; in the valThis() function
  • Switching between paginate true and false makes the windermere logo at the bottom of the photo Gallery go behind the Print/Send/Details banner
  • http://developers.facebook.com/tools/lint
  • Testing stuff that went live
3/11/11Friday
  • Mail server in CFADMIN is set to mail.neverinyourlifeinthisworld.net.org Anu suggested I change it to cfrelay.windermere.com
  • From Paul Quinn
    Go to https://webmail.windermere.com and log in using
    devtest@windermere.com
    pw: winder09
3/9/11Wednesday
  • Looked for quick Iteration 2 items to put in Iteration 1
  • fixed issue with Inactive Listing ID going into Detail Tab
  • Asked QA team to send me URL of error page if they ever can get it again.
  • Added help text to youTube upload form in WORC
3/8/11Tuesday
  • Updated text on Detail pages - comparable
  • Updated text around AVM on Detail page. Un-Randomized table rows.
  • Unsubscribe link in JAVA repository - added sb.append("?") to URL string
3/7/11Monday
  • Updated text around AVM on Detail page. Randomized table rows.
  • Looked at printing the flyer as a PDF
  • Restrict flyer to just one page, but allow page 2 in Firefox just in case
    • Views: MasterLayout.cfm and dspFlyer.cfm
    • /Style/print.css - added overflow-x:visible; to BODY
    • /Views/vListing/dspFlyer.cfm - Added
      <cfsetting showDebugOutput="No">
      style="text-align:left" to Main Table to fix IE centering everything
      Took out <br> above Headline
      Wrapped comments area inside <div style="height:400px; overflow:hidden">
3/4/11Friday
  • Looked at Captcha options
  • Looked at PAWS broken map search
  • Helped QA with iFrame error testing
  • Downloaded IZArc so tha I can open .jar files
  • Asked Bob for help on java files - sent him the ticket
3/3/11Thursday
  • Checked in files for iframe bug
  • Switched to Trunk
  • Investigated Agent Map search
  • Checked in fix for Maple Valley office id
3/2/11Wednesday
  • Checked in files for share this , inactive listing id error, and city name google parser results
3/1/11Tuesday
  • Investigated 163386 AEN to Public User is showing original Listing Agent
  • Discovered you can just go to https://vc.wretech.com/repos/cf/trunk/ and browse all the branches and the trunk. .cfm files open as text-only display in the browser. Good for comparing between branches
  • Flyer fix: add style="overflow: visible;" to the body tag
  • Investigated Agent Map search
2/28/11Monday
  • Updated Share this entries in Agilefant
  • Spokane Valley fix - 167270
  • Looking at North End fix - 166218
2/25/11Friday
  • Attended @task training
  • Documented Share_this stuff
  • review Fogbugs for estimation meeting
2/24/11Thursday
  • Agent website MLS compliance - checked in
  • 166378 CMA import not working message - changed text in /Views/vListing/dspMlsUpload.cfm - checked in

Attention Northwest MLS users:  NWMLS recently changed the format of their export function to something other than HP Real Estate Marketing standard.  The result is that the data does not import correctly into our tool.  Our development team is aware of this problem and will work with NWMLS to find a solution.
2/23/11Wednesday
  • 166378 CMA import not working message - added text to /Views/vListing/dspMlsUpload.cfm
Attention! If you are attempting to import data from the Northwest MLS, this tool is currently not in compliance with the most recent changes to the MLS format. Our development team is aware of this error and will fix it as soon as possible.
We apologize for any inconvenience. (Posted 2/24/11)
2/22/11Tuesday

Flyers

  • In IE, the last line goes to page 2.
  • If the text in any feild is too large, the overflow goes to page 2
2/18/11Friday
  • Null Square feet creating error on live for nearby solds link.
  • Error for live - can we add reference number that displays on screen so that we can later match it with gmail?
  • W/errorMessage.html - displays public info (could put visual ref# here)
    CustomTags/error.cfm - displays verbose gray table for dev and qa
2/17/11Thursday
  • Looked up bit.ly and tried to track down how to integrate
  • Sent Jim a comparizon of our and Redfin's TITLE and DESCRIPTION implementation
  • Went through old tickets
  • Reviewed Share this code to be sure it does not interfere with other pages.
  • Filled out weekly status thing
  • worked with IT to get my e-mail working again.
  • Reviewed Agile, Scrum, Waterfall (Just give me what you have and I'll post it - it can't wait until it is perfect, or it will never happen!)(SUSD)
2/16/11Wednesday
  • Worked on Share Widget
  • Looked at error for not found property

Kailua-Kona

  • 11 properties show up when searching for Kailua-Kona, hundreds show up for Kailua Kona. Can we do a search that combines the two?
  • Yes, the database query loops over a list of cities, however, earlier code only sends the first in the list to the query. So, fix.city = "Kailua Kona"; can be changed to fix.city = "Kailua Kona,Kailua-Kona";
    But also, <cfset attributes.city1 = "#listGetAt( attributes.cit, 1 )#"> in the SearchPropertyMapV3 switch would have to be changed to <cfset attributes.city1 = "#attributes.cit#"> This would allow lists into the city search, as we haven't before and would have to be thoroughly tested.

    This code is currently working in the share_this branch
2/15/11Tuesday

Worked on Share Widget

2/14/11Monday
Worked on Share Widget
2/11/11Friday
  • Looked into Attachments not saving to \\victoriamail_temp
  • Discovered lots of errors going into gmail account
  • Added Share widget to detail listing
2/10/11Thursday
  • Verified that multiple result MLS number from front page still works
  • Google Street view not working on QA or Live
2/9/11Wednesday
  • Pushed Sold Data Live
  • Fixed www.windermere.com/11532 wher the listing ID goes directly to the detail page

New Research

  • CMA Descriptions. Jim asked me to investigate adding a description next to One Sheets. Gave two options to resolve. Jim came back later to abort project.

 
2/8/11Tuesday
  • Fix on List View: Displaying 1 to 0 of 0 listings
  • if web service is down and you get -1, show error message n just sold is now 0. 'Both' still works
  • hid ActiveSOldBoth if MLS is selected on map view
2/7/11Monday
  • Add (if prod) to iFrameLocation test
  • if Detail page is in markets 1,2,3,57 - hide nearby comparable link
  • Fix ListingID not defined was preventing over 5000 message from coming up.
2/4/11Friday
  • Took valThis() off the onBlur of all of the pages to try and prevent the double message.
  • using keypress invalidates greater than for square feet and year built.
2/3/11Thursday
  • Added valThis(); to onSubmit of List View and Home Page forms to catch the enter key. Also added valThis() to onKeyDown of containg div's in all three spots. Left valThis() in the onBlur of one of the pages.
  • Set stuff to hide if Sold or Both (on home page, Map View and List View): Lot Size, New In Last X Days, Open Houses, Rentals, Photo Gallery, Single-Story Homes.
  • Pushed to QA: rev 13485
  • Met with Mark to discuss my background and where I see myself in 3 years.
2/2/11Wednesday
  • Met Mark - my new super?
  • Met with Joe to discuss errors on QA. He will organize with Clayton.
  • Verified new QA build - whole thumbnail clickable on pop-up.
  • Added address to Sold search by adding hsn to restListingAppendSold (and Count) and hidden form field on Map view. Since it is already in the URL, List View just works automatically.
2/1/11Tuesday
  • Paul's First Day (Again)
  • Got datatypes of Rest Service from Joe. - Matched datatypes and updated QueryNew()
  • Fixed -1 bug in upper-left message box
  • Active listings 1 of x was hidden if Solds broke. Put Active 1 of x back.
  • Investigated ticket 164058 where 0 results of sold data on 1st try. Saw error message on timeout of CFmail. Asked JP if we can set up mail server.
1/31/11Monday
  • Updated Flowchart: Map/List to selSearch_View and selSearch_ViewGeo

New Tickets

  • 164219 - YouTube Videos in Gallery Embed Code. Sent back to Bug Triage with suggestion of removing iframe from reg ex and/or tell users about "Use old Embed Code" checkbox in YouTube window.
  • 162970 - Wrong Office ID in Google Search. Sent back to Carolyn with suggestion of robots.txt to exclude officeID and/or add if/then to redirect id.

Sold Data

  • 164067 (continuing) - Active numbers carry over to Sold 1 of x. Sent back to Chad. I can no longer reproduce.
  • 164621 - Hotspot for image in pop-up in Map View too small. Made transparency larger.
1/28/11 QA Stuff: Sold Data
  • Only numeric values in text feilds in search forms. Added valThis(0); to all feilds on home/map/list
  • Tried to trouble-shoot 0 solds in QA
  • Set the default soldTotal to -1. Later, if it is still -1, show an error message.
1/27/11 QA Stuff: Sold Data
  • Responded to QA questions - 365 default sold days, Sold Price: Not Available, Remove Listing Number off tab and detail,
  • Added code to change the URL under Remove boundary by updating to current form value of Listing status and sold days.
  • Tried to trouble-shoot 0 solds in QA
1/26/11 QA Stuff: Sold Data
  • Responded to QA questions - Nearby Solds, no REST call after page 1
  • Fixed ticket 164060 - drop-down not re-appearing on home page. Forgot to add toggleTime() to this page
  • Sold listing 4122 NW 3rd Ave in fremont was throwing error because the MLS field wasn't coming through. Discovered that the looping structure in restListtingsAppendSold was starting on line 2 instead of 1 omitting MLS
1/25/11 Tuesday

Sick Day - Stomach Flu?

1/24/11 Monday

Looking at map pin rollover area. Changed offset from 40 to 60 which puts the hot area in the center.

<cfset this.ASSET_REST_SERVICES_URL_DEFAULT = "localhost:8080"> changed from 172.29.8.224

Went home at noon - sick
1/21/11 Friday

Fix Map View double-hit sold data on pages.

  • 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.
    • That way, it becomes part of attributes.soldCountOnce
    • soldCountOnce is in the URL for List View, and in the form for Map View, which Fusebox puts those scopes into attributes.
    • SoldCountOnce is then used in selSearch_View.cfm during the "selectType=count" pass
  • 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)
1/20/11 Get Tomcat
  • Bob Installed JAVA and TomCat on laptop. Shortcut on desktop for Start Tomcat and Stop Tomcat. Can see sold search requests in command shell.
  • Bob's share: ramp1057\share Sh@re2011
  • Thought about moving cfinclude restListingsAppendSold.cfm out of the bottom of selSearch_View.cfm and selSearch_ViewUsePagination.cfm. Put into fuse construct.

Fix List View double-hit sold data on pages.

  • Added if/then around cfinclude restListingsAppendSoldCount.cfm in selSearch_View.cfm to only include if attributes.RESTPage EQ 0 (only on page 1)
  • Added if/then around cfinclude restListingsAppendSold.cfm in selSearch_ViewUsePagination.cfm to only include if attributes.listingRecordCountSold GT (attributes.RESTPage * attributes.paginate) (only while there are pages)
1/19/11 Start and Finish Modern Logo
  • 3 more Comment header Block to go
  • Switch to new branch
  • Start new project. Be in cf_trunk folder
    svn switch https://vc.wrtech.com/repos/cf/branches/modern
  • Clayton observation: when paging through Sold data, it counts each time. After page 1, there is no need for the count query.
  • Addressed all bugs in fogbugs
1/18/11 Add More Comments
  • Add more Comments and Comment header Block to files
  • Fixed java error. Other errors: setenvironment doesn't seem to be picking up "localhost" images are missing. Also, map service broken.
  • JP set up other services on my laptop. Sold thumbnails broken.
  • Sold project merged to trunk, sent to QA
  • QA: Clayton still hasn't updated the WAR. missing sizedpage method
1/17/11 Add More Comments
  • Add more Comments and Comment header Block to files
  • Connectivity went down for about an hour.
  • Will JP put Sold Data back on QA?
  • JP help to make my laptop my dev environment - stuck on java error.
1/14/11 Add More Comments
  • Add more Comments and Comment header Block to files
  • New Fogbugz project: Add Modern Program Logo to Detail Tab, Detail Page and management radio buttons to the Edit Listing Attributes window.
1/13/11 CMA Bumped Us Out!
  • JP: CMA needs to go out sooner than Sold Data, so we need to un-merge your stuff. You can continue to work on it on the branch rather trhan the trunk.
  • I did an SVN switch on my laptop which then had me saving things to the "trunk" on Jetty, but I never did the switch on Jetty, so my changes never really went to the trunk.
1/12/11 MERGE DAY!
  • Add more Comments and Comment header Block to files
  • reviewed code with JP. resolved one conlflict, found one bug, one issue.
    • Bug: Nearby sold link hard coded to 172.20.0.74
    • issue: List Results frame in Map view scrolls to the right.
  • Switch SVN view to "Trunk"
    • Be in the root in Putty slloyd@hammersmith:/cf-instance/root$
    • svn switch https://vc.wretech.com/repos/cf/trunk
1/11/11 George took us to lunch / Dress-up day for AZ visitors
  • Add Comments and Comment header Block to files
  • Adjusted orig lat/long by truncating value to 4 decimal places to minimize wrong-side arrow issue.
1/10/11 Monday
  • QA changes
    • Adjusted jquery code for IE - (sold days drop-down)
    • Nearby sold results page: 1st tile rollover results in table pop-up wrong direction arrow.
    • zip code 98107, $389,000 sold listing on first set List view. Out of sort order.
    • A single property from Web Service
      http://172.29.8.153:8080/rest/service/Sold/v2/listing?ID=7481360
  • Create Expectations document for QA
1/7/11Thumbnail Issue Solved
  • Look at Thumbnail image on List and Map view panels and Map View pop-up table.
  • Added CFC/image/listingImage call that was already in Detail pages and added it to restListingsAppendSold.cfm
  • Moved "more than 5000" alert box below the "remove Boundary" box
1/6/11 Zoom Level Solved!
  • More Zoom on Nearby sold
  • If mapCenterLatitude and mapCenterLongtitude and zoomLevel are sent, but the 4 sides are left out, the zoom takes over. Using /js/map/listingMapRegistry.js - ListingMapRegistrySetZoomView() and clued in from the comments at the top of /Models/mGeography/actMapListingRegionResolver.cfm
  • Disabled Active and Sold Radio Buttons when using nearbySolds
  • Next arrow missing from SoldNearby resuilts GT 100. Shows up when Total is GT 1000.
1/5/11 Wednesday
  • Hide arrows on Map View if on first or last page so that it matches the functionality of List View - hidden
  • Fix nearby Sold results from Sold Detail Flyer page - fixed
  • Set Zoom on Nearby sold
1/4/11 Tuesday
  • Comments on detail page? - No
  • Add nearby Sold link to Active Detail Flyer page
1/3/11 Push to QA Day?
  • Added new ico
  • Added new sold icons and new white border Open House Icon
  • Check in files
12/30/10 Even More REST Pagination
  • Activated List View Sort by Columns to SOLD data by adding SortOn and Decending to the URL of the buttons and to /Models/mListing/actCreateSearchString.cfm
  • Fixed arrow pagination in list view by hiding the arrow when both sets of data run out, and displaying how much of each Active or Sold.
12/29/10 More REST Pagination
  • PROBLEM: a $69,000 houser is more expensive than a $500,000 house because alphabetically, 6 comes after 5. Added datatypes to QueryNew() in restListingsAppendSold.cfm to sort Price and Square Feet as numbers.
  • GEORGE THOUGHT: If just actives and just solds work well, and the combo option is giving headaches, make the user choose Active or Sold more often than both.
    SUGGESTION: convert checkboxes to radio buttons and add "Both"
12/28/10 REST Pagination
  • Map View is 100 results, List View is 10. We are asking for 100 Actives, then appending 100 Solds, then shuffling. Try: 50 active and 50 Sold Max.
  • List View: Don't use paging, return all. Asked for 4999, got 1000. Is there a built-in limit?
  • QueryNew() - if you don't assign datatypes, CF will do it for you based on the first few records it gets. So a field that is mostly numbers, but then down the line becomes a string will throw an error.
  • Map View REST Pagination - solved with javascript targeting a hidden form field.
12/27/10Nearby Solds and REST pagination
  • Added soldNearby to end of URL link on detail page to compare the search terms with the results, adds a value of the differences and re-sorts on that value. Original proprty shows at top, and changed sort message to "Listings Sorted by Relevance"
  • Upgraded REST links to v2 -2 (sizedPage.json?) : Now paramaterizing PageIndex, PageSize (# of results), SortOn and Decending
12/23/10Check-in @ revision 13303
  • Moved REST URL from Application.cfm to setEnvironment.cfm
  • Added cf_error in cftry/catch of restListingAppendSold
  • Used George's new Features (Struct) to fill out Detail (rt-column and flyer) pages
12/22/10Wednesday
Solved List View only solds: Took out if/then that skips SQL query if only sold.
12/21/10Nearby Comparable Solds and Features
  • Added nearby comparable solds to Sold Detail Page
  • Added Features to Detail pages

ISSUE: In List View, if you search for only solds, attributes.listingRecordCount is a struct and cannot be used for GT comparisons. In selSearch_View, during the count, Solds are not being counted correctly. Map view works fine.

ALSO DISCOVERED: Pagination in Map View is keeping the Solds on the first page and not getting the next set.

ALSO DISCOVERED: List view has no sold photos.

12/20/10Check-in
  • Added if/then around selSearch_View query in selSearch_View.cfm and selSearch_ViewGeo.cfm to skip SQL query if Active is not checked.
  • Added params to selSearch_View.cfm -
    <cfif attributes.selectType EQ "COUNT">
        <cfparam name="selSearch_View['recordCount'][1]" default="0">
    <cfelse>
        <cfparam name="selSearch_View.recordCount" default="0">
    </cfif>
12/16/10?

Added Sold icon to rt-side list view

Uploaded sweeps files for Brendan Johnson <bjohnson@faethom.com>.

  • Set application variables for DSN and host.
  • Set custom mapping in CFADMIN for sweeps
12/15/10Icon Hot Spot

Things to fix:

  • Enlarge Icon Hot Spot
  • List page -
    • Restful loop would only add one row.
    • At the end of that row add I had put in a query for images and added the data into those columns.
    • Noticed that a dump of the initial selSearch_View query from the List page did not contain the image columns.
    • selSearch_View.cfm has an if/then around the image columns in the SELECT statement, but selSearch_ViewGeo does not.
    • The if/ then was : <cfif attributes.lis> and it is param-ed <cfparam name="attributes.lis" default="0">
    • in /Controllers/Listing/fbx_Switch.cfm, I added <cfparam name="attributes.lis" default="1">
  • Max Rows
12/14/10Check in Files
All checked in.
12/13/10Replace Icons and Pins

Toolbar

  • Large Photos, Send, More Info, Clip It, Save. Took screen shot of new design, cropped to tool bar. Pasted old images on new layers, save .psd to slloyd/myPictures. Sliced icons. Saved new designs over old in refresh folder.

Flyer Icon

  • (icon_document.png) to replace refresh/pp3-icon-flyer.gif. Updated HTML in
    /Views/vListing/dspPP3ListingDetailLayout.cfm
    /Views/vListing/dspSoldListingDetailLayout.cfm
    <a class="option" style="background-image:url('#request.appImages#/refresh/icon_document.png');"
    Cropped bottom of icon 2px

Photos Icon

  • (icon_photos.png) to replace map/pp3-icon-photos.gif. Updated HTML in
    /Views/vListing/dspPP3ListingDetailLayout.cfm
    /Views/vListing/dspSoldListingDetailLayout.cfm
    <a class="option" style="background-image:url('#request.appImages#/map/icon_photos.png');"

Open House Icon

  • For testing:
    • added an option 999 to open house drop-down from now() to -365 in /CFC/persist/OpenHouse.cfc
      <!--- In the Last Year --->
      <cfcase value = "999">
          <cfset this.startDate = DateAdd( "d", -365, Now() ) />
          <cfset this.endDate = Now() />
      </cfcase>
    • in /CustomTags/OpenHouseControl.cfm, added <option value="999">!THE LAST YEAR!</option>
    • in /Views/vAbout/dspHomePageMessage.cfm, added <option value="999">Through a year</option>
  • Renamed new file to old: images/OpenHouseIcon.png and uploaded.
    Edited width and height from 36 x 32 to 47 x 18 in:
    • /CFC/persist/OpenHouse.cfc
      <cfset this.flag = "<img src=""#request.appImages#/OpenHouseIcon.png"" width=""47"" height=""18"" alt=""Open House"" title=""Open House"" />">
    • /js/map/lib.js, buildSummary function
      listingInfo.innerHTML += "<img style=\"float:right; display:block; clear:right;\" width=\"47\" height=\"18\" alt=\"Open House\" title=\"Open House\" src=\"" + basepath + "OpenHouseIcon.png\" \/>";
  • /style/map/lib.css
    • #contentSearch .OpenHouse
      Updated background-position: 10px 10px; to background-position: 10px 18px;
      Updated padding-left: 52px; to padding-left: 68px;
    • #ohpng
      Updated width: 75px; height: 55px; to width: 47px; height: 18px;
      Updated left:-12px; to left:-22px;
  • /js/map/lib.js, listingDropDown function
    From <img id="ohpng" src="images/map/pp3-oh-popup.gif" width="75" height="55">
    To <img id="ohpng" src="images/OpenHouseIcon.png" width="47" height="18">

Pins

  • Commented out nodes 2, 3, 4, 7 (condo, land, manufactured, multi-family) in /js/map/listingMapRegistry.js
  • Updated icon src and sizes in node 1:
    • From pin.png 22 x 34 to map_house.png 44 x 50
    • From pin_sold.png 22 x 34 to map_house_sold.png 44 x 50
    • From pin-open2.png 41 x 49 to map_house_open.png 51 x 50
    • From shadow.png 41 x 36 to map_house_shadow.png 44 x 50
    • From shadow-open.png 41 x 49 to map_house_open_shadow.png 51 x 50
    • Changed inverted icons to basic new ones
      • pin_inverted.png to map_house.png
      • pin_sold_inverted.png to map_house_sold.png
      • pin-open-reversed2.png to map_house_open.png
12/10/10Add Photo on Column Detail Page and Create "More Detail" page

Column Detail Page

  • Removed entire Gallery section and replaced with a single line for img src=
  • Removed row of tools
  • Put 3px red border around image.

More Detail Page

  • Put 3px red border around image.
  • Removed row of links under pagination
  • Added" Sold Price" at top and "Sold" in table, turned both red
  • removed Mortgage calculator
  • To get styles to fix, had to add fuse name to /Views/vLayout/dspPublicHeader.cfm
12/9/10More Detail Page
  • Commented out "listing not found" cflocation redirect in /Models/mListing/actInitSlideViewer.cfm to get past that error.
  • Got image section to show, even if there is no image.
  • Set up next and previous detail buttons.
  • Changed background of Sold Detail page to red.
  • Removed Photo and Clip it icons
12/8/10Detail Page and Icons

Icons

  • Added 6 new icons for Multi-family (Standard, Sold, Open House | Standard, inverted).
  • Added 4 new icons for Land (Standard, Sold | Standard, inverted).
  • Added 4 new icons for Manufactured (Standard, Sold | Standard, inverted).
  • Added Multi-family, Land and Manufactured to listingMapRegistry.js

Detail Column

  • Change the details lilnk to /index.cfm?fuseaction=listing.PP3SoldListingDetail, add a case in the controller, and basically copy the attributes and addtoq's but substitute PP3SoldListingDetailLayout
12/7/10Search Integration

Completed in restListingsAppendSold.cfm

  • Added Lat/Longs Boundaries
  • Set show_address to true for ALL sold results
  • added query to get image thumbnail for Sold Listings
  • Added cftry around REST call in restListingsAppendSold.cfm If there are no results from the REST call, the page throws an error, and the map never finishes loading

Also added sold visual change to icon pop-up table using lib.js
12/6/10Search Integration

Completed

  • Have added Property Types, Square Feet, Sold Price, Year Built, Bed, Bath, Waterfront, View, New Construction, Premier Property, Sold Days.
  • Added Sold Date to Right column list boxes in Map view (had to add to /Models/mListing/actListingCollectionThin.cfm, js/map/lib.js, js/map/map.js, js/map/listingMapXHR.cfm)

TO DO:

  • Search values in Sold search: Lot Size, Photo Gallery, Single-Story Homes, Ignore: New lin last __ Days
  • Connect Detail Page

Notes From Cass

  1. I think that we need to figure out a better way to deal with Solds when the there are more than 100.
    1. If less than 100 do as you are doing now.
    2. If more than 100, show the first 100 actives and the first 100 solds on the map but leave the summary logic as is.
  2. It looks like the detail pages are not wired up yet. I would like to have those wired up before showing Brett if possible. The sold details will need to use the Sold Web Service as well.
  3. On the map hover thumbnails for Solds we will need to remove the more “Photos� option
  4. I notice that no images are showing for solds.
  5. When I use the Sold Last drop down my results do not change so I can’t tell if that is working or not. (FIXED)
  6. Not all of the markets we are in have Sold Data. We will need to come up with some way to tell the user that there are no solds. I wonder if something like “Your search for sold listings did not return any results. Sold Listings are not available in all areas.�

 
12/3/10Demo Ready and Clean up Hammersmith

To view 4 icons (Active and Sold House and Condo) : zip code 98107, at least 1000 square feet, 2 bathrooms, Active and Sold checkboxes.

  • Hammersmith all cleaned up and demo working again.
  • Added some visual changes to map view list boxes to denote sold properties.

Here are the details of the Sold Data map that is currently working on http://172.20.0.133/ (Bob’s Machine)

Do a search for zip code 98107.  This is in Ballard.  You can either check both the active and sold checkboxes on the home page under More Options, or you can add the sold checkbox on the Map view page. Because there are over 100 active listings in this zip code, you won’t see any Sold Data unless you click the arrow to go to page two, or zoom in to a smaller part of Ballard, or update your search criteria to narrow the results.

You should see 4 different Icons – Blue & Red houses and Blue & Red Condo buildings. The sold data is hard-coded to this zip code and property types of Houses and Condos.

I also changed some of the summary details on the map page for solds: red background, larger font, "Sold Price". /js/map/lib.js is where the summary gets built.

Tried to Clean up Hammersmith

  • A bunch of files have "S" designation.
  • Delete and update to get rid of S's. Many files would not delete. Morgan rebooted jetty to remove locks.
  • remove and up do not resolve the S - Bob is now logged into my server with bobtemp1 as the password to try and clean up stuff. Worried that he will global delete and get rid of CFIDE folder.
12/2/10Arrow, Red Houses and Condos!
  • Added #URLStatus# to the arrows on /Views/vListing/dspListView.cfm. And at the top:
    <cfset URLStatus = "">
    <cfif isDefined("URL.statusActive")>
        <cfset URLStatus = URLStatus & "&amp;statusActive=1">
    </cfif>
    <cfif isDefined("URL.statusSold")>
        <cfset URLStatus = URLStatus & "&amp;statusSold=1">
    </cfif>
    <cfif isDefined("URL.soldtime")>
        <cfset URLStatus = URLStatus & "&amp;soldtime=#URL.soldtime#">
    </cfif>
  • New Zip codes to try:
    95720 - clustered and zoomed out, but best of bunch
    93727 - none inside boundary
    92544 - over 100
  • In /js/map/map.js, line 740, to view data for each fix:
    console.log("id: " + id + " fixFound: " + fixFound + " fixScheme: " + fixScheme + " fixProvider: " + fixProvider + " fixPositionX: " + fixPositionX + " fixPositionY: " + fixPositionY + " fixLatitude: " + fixLatitude + " fixLongitude: " + fixLongitude + " locPid: " + locPid + " locAddress: " + locAddress + " locBedBath: " + locBedBath + " locPrice: " + locPrice + " locPtyp: " + locPtyp + " locUrl: " + locUrl + " locFull: " + locFull + " locThumb: " + locThumb + " locAttributes: " + locAttributes + " locMls: " + locMls + " locCompany: " + locCompany);
  • locAttributes contains flags for open house, premeire listing, and photo gallery. Can I add Sold to this? The firebug output has all these functions, but the cfm file just has this:
    <cfoutput>#CreateObject("java","com.windermere.listing.ListingAttribute").toJavaScript()#</cfoutput>
12/1/10Found Dumps
  • JP showed me "for ( var i = 0; i < FIX_ARRAY.length; i++ ) {"  IN  "function buildSummary () {"  IN  "/js/map/lib.js" as the place where the points on the map get looped and built. FALSE: it is where the right-side boxes get built (summary-container).
  • George checked in a new version of the JSON data that includes default data - all the problems from yesterday magically fixed themselves.
  • Solds how on map using zip code 97343
11/30/10JAVA is out Ruby is in
  • Bob came back from a meeting and said, "JAVA is out Ruby is in"
  • Ran into a problem where CF didn't believe that ptyp = ptyp in all 7 instances. It would only bring back 6.
11/29/10Found Dumps
  • If I put a dump in the selSearch_ViewGeo, the map just sits and spins, but If I look at firebug HTML tab, I can see the dump.
  • if there is no dump and the page processes completely, the tab changes to xml and contains a listingcount and a set of listings.
  • /CustomTags/setEnvironment.cfm - Line 19 - set the IP address to yours and the paths beome local and the error page gets better.
  • /CustomTags/error.cfm - line 19 - set to 0 <cfif request.isProduction><cfset attributes.showErrorPage = 0>
  • In Firebug, in the Console, click on the GET hyperlink to open the XML page. Add &debug=1& in the URL and reload. Now you can see the query in the CF debug window and any Dumps in the main window. http://172.20.0.74/index.cfm?debug=1&fuseaction=Listing.SearchPropertyMapV3GetListingLocationXML
  • Searching our database or the Sold database, you can use a combintaion of the LN (MLS listing number) and MLS (the ID of which MLS database) to ensure a unique record.
  • Bob: if the REST data is suddenly unresponsive, ask Bob to Bounce Tomcat
11/24/10Documentation / Property List View
  • Got dspSearchForm.cfm to keep the main page Active/Sold selection.
  • Remove RESTFul call from bottom of selSearch_View and make it it's own thing.
  • Discovered /CustomTags/error.cfm which sends you to www.windermere.com/errorMessage.html
11/23/10Documentation / Property List View

sold data web page was getting too large - created word documents with screen shots of interfaces and wireframes of layouts and all the notes from the other page for each of the pages relating to property search criteria - Home page, Search Landing (Map), Property List View (List), and Detail page. The files are in my Documents folder on my desktop.

Added Active and Sold checkboxes to dspSearchForm.cfm The dates jquery reveal works, but it does not keep the main page selection.
11/22/10Where does the map search come from?

Checked in changes so far on Sold Data

Where does the mapped page get it's data?

Bob: Do "svn up" then "svn ci" from the local machine. Then do a "svn up" from hammersmith to get local changes. Never Check in from Hammersmith.

Added functionality to Location search, List view to only show Active if the checkbox is Active, Show both, if they are both checked, and show only Sold if only sold. If niether are checked, it defaults back to Active.
11/19/10Custom Tags

Helped Bob with taking the column mapping subroutine and converted it into a Custom Tag. Created a custom tag to test that functionality. Took George's javascript function and massaged it into cfscript.

  • W/RESTServices/restListingAppendSold.cfm
  • W/RESTServices/SoldSearchDataNotes.xlsx
  • W/Views/vListing/dspListView.cfm
  • W/Query/sel/selSearch_View.cfm
  • CustomTags/mapColumns.cfm
11/18/10Branching

Active/Sold

  • Adding checkboxes in advanced options of home page, top section of Search Landing (PropertyCriteria)
  • Helped Bob with Combining Sold query data with existing query. QueryAddRow and QuerySetCell
  • Set conditionals on /Views/vListing/dspListView.cfm to hide stuff on non-sold properties.

Branching

  • Reverted my copy of Tortoise and Collabnet Subversion to 1.5.5
  • Switch to Sold Data branch
    • Be in the root in Putty slloyd@hammersmith:/cf-instance/root$
    • svn switch https://vc.wretech.com/repos/cf/branches/soldsearch
11/17/10Branching

Revert

  • svn revert path/filename all the files having to do with sold data

Commit (Check In)

  • svn ci path/filename the modified and new MLS Listing files
    svn ci MLSListingData.cfc -m "bugsid:155386; query for listing number. Returns address, city, state and listing ID"
  • but it gave me this error:
    Commit failed ( svn: '/cf-instance/root/W/CFC/MLSListingData.cfc' is not under version control)
    You have to svn add before you can check in.
11/14-16/10JSON/AJAX MLS Listings

Project: Duplicate MLS Number Chooser
11/12/10Pair Programming
  • George asked me if I was interested in Pair Programming, I should read about it, and if so, let him know. XP

TO DO TODAY:

  1. Add time span to search boxes for Sold Data
  2. JSON tutorial to move ahead mls search box functionality
  3. Visit Shoe Guy

Every week Cass and Kendri get a status report of what we do all week. Bob will send me an example of his.
11/11/10All Hands on Deck Meeting
  • Technology has to fund itself / Make money.
  • We have been in maintenance mode for years.
  • We can operate as a separate software development company. There is Windermere Services and possibly Windermere Solutions.
  • Semantic Web: push data to the consumer before they know they need it.
  • CMA - Comparative Market Analysis
  • Windermere 2.0 - "Katana" (a type of japanese knife)
  • Four Deliverables
    1. Sold Data
    3. Tierd Web Structure
At the end of the day, Cass asked how the mls search function was coming and when it would be ready for testing. "We would like to launch bothe the sold dat and the mls thing mid-December."
11/10/10ColdFusion Mappings / Website Building Technologies
Logical Path Directory Path
/ /cf-instance/root
/cfc /cf-instance/root/W/CFC
/CFIDE /cf-instance/root/W/CFIDE
/cms /cf-instance/root/X/CMS
/EmailCMARoot /cf-instance/root/W/WORC/prospector/cma/EmailCMA
/gateway /cf-instance/WEB-INF/cfusion/gateway/cfc
/worcRoot /cf-instance/root/W/WORC
/wqroot /cf-instance/root/W/Query

Popular technology to build a website in a pie chart: trends.builtwith.com/framework
11/10/10Sold Data

Radio buttons for Active and Sold

Stephen to Bob: What browser do you target when you are developing? Bob: Firefox, then QA'ed in IE and others.
11/09/10Convert Case CF Function

Guys were having conversation about what to do with the ALL CAPS info that comes out of the RESTful Services "Sold" databases. Dave asked if there was an initial caps function in ColdFusion. Something that could change SEATTLE to Seattle? or mount vernon to Mount Vernon.?" I said, not that I have ever used." Cass said, let's look for one. He found a regex script that would do it and asked me to check it out on CF. So I put the code from his tutorial on my server, tested a few things and said to Cass, "Yep, it works." He then later said to the other three as the conversation continued, "Steve got this thing working that I think will fix our issue..."

NOTES PAGE: Convert Case CF Function
11/08/10Listing Data Query

Cass: Please send me the query that pulls listing data from pub_data.
Try: Search local files in Textpad for the string "pub_data"

Found: /Query/sel/selSearch_View.cfm

Dump Attributes

  • Try: There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment. There is a commented out dump/abort in the code. Uncomment.
  • Result: There is no dump, the page renders, but the page does not load houses.

Middle School

  • Try: Find a Laurelhurst, WA listing with no middle school, add "PostonJH" to the default in selSearchView.cfm and see if it adds it.
  • Result: jhs is not listed with the defaults.

To Do

  • SQL - find the zip code with the smallest number of listing. Neighborhood.
  • Make a table of all the abbr. Column names in table pub_data and their meanings. Is it on the other side of the map? Is it in the wiki?
11/01/10RESTful Services  (REpresentational State Transfer)

Wiki: ajaxpatterns.org/RESTful_Service
10/29/10Scripts / Styles not Updating
  • /CustomTags/resource/srcScripts.cfm
  • /CustomTags/resource/srcStyles.cfm

The above scripts add script and style include code to the head, but prefixes the addresses with "http://dist-www.windermere.com/..."

Comment out the variable, and hardcode the directory for development:

<!---<cfparam name="attributes.path" default="#request.page.jssourcefilepath#">--->
<cfparam name="attributes.path" default="js/">
10/28/10JSON  (JavaScript Object Notation)

The JSON format is often used for serializing and transmitting structured data over a network connection. It is primarily used to transmit data between a server and web application, serving as an alternative to XML.

10/27/10Listing Number Disambiguator Search

When we have two or more listings with the same listing number, we do not give the user a choice. ( FogBugs: 155386 )

 


Stephen Lloyd 06/25/2013