Changes to a database manipulation system

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