ASP/SQL Development/enhancement of existing FoodFit.com site
$500-5000 USD
Completed
Posted about 20 years ago
$500-5000 USD
Paid on delivery
Project: “My Plan?? Area of the FoodFit Club
Platform: ASP/SQL Server
Overview: The [login to view URL] club is being redesigned to enhance usability. The FoodFit club offers its members a personalized diet and fitness plan, and online tools to manage it. The project will involve debugging and enhancing existing pages to increase personalization, ease of use, and flexibilty, as well as adding some significant new functionality. The My Plan area includes a club member’s meal plan page, food and exercise diary, progress report of weigh-ins, tools pages (diet profile quiz, food analyzer, calorie burn calculator), and a preferences area. These pages will use tabbed navigation. There will be significant enhancements to the diet plan page and associated shopping list page, including some database modification. Existing JavaScript bugs in the diary page need to be corrected or moved to server side code, and the interface between the diet plan page and the diary page needs to be improved (copying data from your diet plan into your diary). The layout of the diet plan and diary pages will be modified to have a one day at a time page and a weekly overview page. The progress report page will need to be created, it will show an overview of a club member’s progress based on weigh-ins, diary entries, and assigned diet. The main graphic design will be provided by an outside vendor, the project team will also include an on-staff designer and programmer to integrate results.
Environment: Off-site work will need to be done using PC Anywhere as there’s no other way to access the development database, FTP access can be granted for the ASP code. The existing system has been worked on by several different developers and is largely undocumented. If you're located near Washington DC, onsite work at the beginning would be preferred.
Skills: ASP, SQL Server, HTML, CSS, Javascript. The recipe database makes extensive use of complex self-joins, you must be comfortable working with this.
## Deliverables
**FoodFit Diet & Fitness Club Plan**
**My Plan Redesign/Re-Launch**
1. The main My Plan page should only show that day’s plan (meal and exercise) with easy navigation to view the entire week or a specific day. This is a new page that should draw from the existing [login to view URL] page.
[login to view URL] navigation will be used so that you can use the tab to see the week’s view (see [login to view URL] for example).
1.2.A calendar widget should also be available so that you can click easily to a specific day.
2. Each meal should list the calorie count and total pre/cooking time for that meal so that members can easily make substitutions and changes
3. Substitutions and choices
[login to view URL] should be able to easily change each meal with one click.
[login to view URL] they click the “edit?? or “substitute?? link, a window should appear that offers members four choices for substitutions:
3.2.1. Ability to search for another recipe that is the same calorie range as that meal (search through recipe database for recipes with calories equal to or lower than current total meal that are the same meal type (e.g. lunch, dinner).
3.2.2. A pre-set substitution for that meal. A list of these will be provided by our nutritionist and should be placed in a database table.
3.2.3. A convenience packaged food item that is nutritionally similar.
3.2.4. Any meals that the user has saved using the meal planner that have an equal or lower total calorie count.
[login to view URL] should provide guidelines and tips that help members make smart substitutions (e.g. when choosing packaged food, choose those that are lower in sodium, etc.). We should have a database table of these tips that rotate on the meal plan page that address substitutions and dining out.
4. It was agreed that the default for breakfast meals should be meals that don’t involve cooking. Cooking will only be suggested for weekend breakfasts. This will be addressed by our nutritionist, no programming required.
4.1. Breakfast is a special case. There will be a separate area for breakfast preferences (most people eat the same thing every day). In that area they will be able to specify their favorite breakfast.
[login to view URL] a user has specified a favorite breakfast, that breakfast will appear everyday for the user (M-F).
[login to view URL] the user doesn’t have a favorite breakfast defined, use the meal plan recommendation.
4.4 To store the customized meal plan, either a new database table will need to be developed, or the existing diary table will need to be repurposed.
5. Increased personalization
[login to view URL] was agreed that members should answer a brief series of questions upfront to determine if they would prefer meals without dairy, meat, poultry and/or fish. We should also ask if they are cooking for 2 or under or 4+ and how often they cook. This will help us personalize the meal plan more for their needs.
5.1.1. Food exclusions: If the user has selected that they want no beef in their meal plan and a meal in the plan has beef, then that meal will be replaced with one drawn randomly from the preconfigured list of safe meals. The substitute must also be compatible with their food exclusion and be of the same meal type.
... Continued in attached file
## Platform
ASP files should run on either Windows NT or Windows 2000 (the production site is Win2K).
The database is SQL Server 7.
All HTML and JavaScript should be cross-browser compatible in IE 5.x+ and Netscape 7.x+