Final
Project Lab 7 - Progress Report 1
Name: Bryan Bibb
Instructions:
Answer the following
questions honestly about your CPT283 Final Project. Submit your completed Final
Project Lab via Blackboard.
Please enter your responses in BLUE so your instructor can
see them better. Thanks.
1.
How
many tables do you have in your Final Project database? What are the names and
purpose of each table?
I have 5 tables:
fuel fuel
records
maintenance maintenance
records
maintenance_type maintenance type
codes
users registered
users
vehicles vehicle
information
2.
What
are your plans for your admin directory as detailed in the Final Project
instructions? Have you started working on your project’s admin directory? Is
your admin directory password protected at this point in your project
development?
I do not yet have an admin directory. However, I
coded a login system that draws username and password from the users directory.
I can use this to define which pages users are allowed to access. My next major
step is to build administrative pages and deal with the "admin" user.
3.
Do you
have PHP pages coded to manage all the tables in your Final Project database?
Explain.
Yes, there are pages for fuel records, maintenance,
maintenance types, and vehicles. Also, each user has their own
"profile" page. When I do the admin pages, there will be a table of
all users and data regarding them.
4.
At this
point in the semester, does your Final Project work? Explain to what extent it
works.
Everything I have is working. There are currently a
couple of bugs that I need to hammer out but the basic functionality is solid.
5.
In your
opinion, will you have a CPT283 Final Project that meets the minimum
requirements specified in the assignment by the end of this semester?
Yes
6.
Is your
Final Project “user friendly”? Have you had someone beta (alpha) test your
project? What was their honest feedback?
I would say that it is very user friendly. There is
a menu bar with immediate access to all options, and on the main table pages
there are links to edit and add information.
My friend looked through the site, and reported that everything was clear. He
did have some confusion about the list of functions in the center pane,
thinking they were buttons, so I am going to reframe that it's clear.
7.
Have
you included any of the “Extras” in your Final Project? Which ones?
Have:
Bootstrap
Authentication using PHP code
Use of MVC pattern
Will (hopefully):
Coded reports for maintenance and fuel
consumption
Coded reports for user, vehicles, and
maintenance_types
Additional: Import/Export/Backup of
all data
Additional: Integration of photos in
vehicle reports
8.
What do
you need to do to complete this Final Project?
- write search routine and integrate it into the
filtering of tables and adding records for particular vehicles.
- write page for vehicle report that collates all information for a specific
vehicle_id.
- write admin pages for reports and and an interface for importing/exporting
data and deleting information
- set up database users (normal and admin) that have permission to select,
modify, and delete as appropriate.
- configure the uploading of photos and presenting as part of the vehicle
report