 |
|
Application
allows the users to search the foods table for a specific criteria e.g. food’s
name, food’s ingredients, food’s computer code, description. The results are
shown in a table format and can be easily printed.
Patient’s
daily food intake information is gathered and entered into the system for
further analysis. From the administrative section, the user can enter patient
information (name, age, gender, mrn, etc.) along with their daily food intake
information. Then, the average consumption of an food ingredient like Na, Ca,
P, Water can be calculated for the general population and/or for different age
groups, and/or gender. Age groups are determined as follows:
Group
11-14
Group
215-24
Group
325-34
Group
425 and more
To
make the application flexible, we have provided an option for the users to
enter the age lower and higher limits for a specific food ingredient analysis.
The
administrative section allows users to do the following operations
- Add
new food items, view and update the existing ones.
- Add
new categories, view and update the existing ones.
- Add
new users, view and update the existing ones.
- Add
new patients to the application, along with their daily food intake
information.
- Search
for an existing Patient and then see and/or update the related Daily
Food Intake information.
- Search
the database to see the daily food intakes of patients according to age and
gender.
The
Logical Flow of the Application
This
is mainly a search application. It is username and password protected. The
opening page (default.asp) includes a login form. The first step of using the
application is to successfully login. After then, the user is redirected to
main.asp where he/she can find the search form. The search results are shown
to the user in a table format, ready for a printout.
Administrative
part consists of links to different operations. Their flow is explained below:
- Add
new food items, view and update the existing ones :Food_list.asp is
used to search for a food item and view the results in a table. Table has
links to the details pages of these foods (Foods_maint.asp). Detail pages
allow users to update the food information and after updating the user is
redirected to Food_list.asp page. In order to add a new food, the user
clicks onAdd Newlink on this page, at the bottom of the food list
table. This link takes the user to Foods_maint.asp page. After adding the
new food item, the user is redirected to Foods_list.asp page.
- Add
new categories, view and update the existing ones:Add new food
items, view and update the existing ones : Categories_list.asp is used to
search for category and view the results in a table. Table has links to the
details pages of these categories (Categories_maint.asp). Detail pages allow
users to update category and after updating the user is redirected to
Categories_list.asp page. In order to add a category, the user clicks onAdd
Newlink on this page, at the bottom of the category list table. This
link takes the user to Categories_maint.asp page. After adding the new
category, the user is redirected to Categories_list.asp page.
- Add
new users, view and update the existing ones:Add new users, view
and update the existing ones : users_list.asp is used to search for users
and view the results in a table. Table has links to the details pages of
these users (users_maint.asp). Detail pages allow users to update users and
after updating the user is redirected to users_list.asp page. In order to
add a new user, click onAdd Newlink on this page, at the bottom of
the users list table. This link takes you to users_maint.asp page. After
adding the new user, you will be redirected to Categories_list.asp page.
- Add
new patients to the application, along with their daily food intake
information:AddPatient.asp is the page where the user enters
patient information. After that the user is redirected to
DailyIntakeList.asp along with PatientID in the querystring. The daily food
intake information will be written to the database table Diasly Intake along
with this Patient ID for each different food item. Here, the user can enter
new food items to patients’ daily intake information from Add New Food Item
form on the page. After adding the food, the user will be presented this
food item in the table form on the same page with their corresponding
nutritional food information calculated using the weight of the food.
- Search
for an existing Patient and then see and/or update the related Daily
Food Intake information:PatientList.asp is the page where the user
can search for a Patient in the database; view the matching records in a
table. From this listing, the user can go to the Patient’s details record on
the same page. There the patient information can be updated. In order to see
the patient Daily Intake information, the user needs to click on the GO link
for the corresponding Patient. That link will take the user to
DailyIntakeList.asp for that user.
- Analysis
of the data:Analysis.asp page consists of links for different kinds
of analysis of the data at hand.
- Average
of food items grouped by gender:
Lists all the food ingredients and their average consumption values
grouped by gender, i.e. for male and female patients.
- Average
of food items grouped by age groups and gender:
Lists all the food ingredients and their average consumption values
grouped by gender, i.e. for male and female patients and 4 different age
groups.
- Daily
Intake Search by Gender and Age Group:
Allows the user to see the list of foods for each Patient based on gender
and Age Group.
- Analysis
of food ingredient consumption:Allows
the user to define the criteria for the analysis of the data. The user can
select for which food ingredient the analysis should be based on. Also,
the lower and upper age limit can be entered from the corresponding text
boxes. And then, the user decides if he/she wants to see the data based on
gender or over all population. The resuls are shown on the PARAMETRIC.asp
page.
|
