3 tier system that integrates into database tables and presents it in a user friendly manor to the user.
1st Tier - List of areas. The areas have a list of offices associated to them.
- areas will be sorted alphabetically, along with a number next to the area showing how many offices there are in that area that still need editing (if a certain office field is null, it needs editing).
You can select the area, which takes you to tier 2.
2nd Tier - List of offices in that specific area with brief data pertaining to each office.
- the offices will be sorted by ones that need editing to be at the top of the list. There will be a filtering option here, which will highlight offices in the list that meet that filter. The filter will be based on which fields in the table are empty or not.
You can select an office to edit, taking you to tier 3.
3rd Tier - All data pertaining to that office, with options to re-write specific data fields and save them to the database.
In addition to the 3 tiers, there is a quick search box, where you can enter the office ID, search, a list of possible matches will be shown, you click a match, it takes you to tier 3.
Mysql 5, PHP 5 and AJAX, operating on a Windows 2008 Server.