Layout changes and minor updates to the tracking system that has been previously developed.
## Deliverables
Allow for some extra time for tweaking that may arise from unforseen circumstances. Inside the ZIP file is the site as it currently sits. A SQL is provided to create the table on the testing server. Edit [login to view URL] with your credentials.
[login to view URL]
- Fix "Column 'mls_status' cannot be null" and any other errors when importing new spreadsheet to a new or existing county
[login to view URL]:
- Create a new layout for the [login to view URL] page (flist [login to view URL])
- Add digit grouping to the new layout
- Add "Today" button next to "Reviewed" field in each record in layout
- Alternate row colors
- Keep popup calendar for date fields.
- Keep current filters
- Limit sorting features to: City, County, Sold Type, and Win Bidder
Create new "[login to view URL]" page
- Model page after the new [login to view URL] layout with the data from [login to view URL], with all text fields the same
- Have same [login to view URL] filters available
[login to view URL] pages (#1 and #2)
- Fix Auction to MLS days calculation (currently shows as a date)
[login to view URL] (a, b, & c)
- Remove list_date, list_price, mls_num, mls_status, mls_sold_amt, mls_sold_date, sold_type columns
- Add filter for "sold_type"
[login to view URL]
- Remove list_date, list_price, mls_num, mls_status, mls_sold_amt, mls_sold_date, sold_type columns
- Make sure data being shows is does not have "mls" checked and is of sold_type "L"
[login to view URL]
- Shows data from sold_type "L" but "mls" is not checked. Switch to checking if "mls_num" is not null to be included in report
- Add sort for "((list_price - win_bid) / win_bid ) * 100" calculation