I need? administrative pages and code developed by monday march 23. I would be willing to contract a team to acomplish this.
The code will have to be delivered by monday the 23rd at 8 am.
I do not need everything skinned just functional Admin.
After a briefing Monday the 23rd. The project would have 2 an additional weeks to complete, including search capability and skinning.
## Deliverables
I need Part 2 and To Be Done 3 completed in rough form by monday the 23rd and the remaining within 2 weeks.
The? website is a PHP/MYSQL website to be run on a Linux/Apache server.?
The two main coding sections are the product search and the administration
functionality to maintain the data for the product search.?
DATABASE
The Database is made up of 8 primary tables associated together by primary keys.
The PDF document lays out the tables and their associations.
htApplications -? This table is the header table for the all of the data associated
? ? ? ? ? to a vehicle.? It contains all of the necessary ids from the other
? ? ? ? ? tables to create a vehicle data component.
? ? ? ? ?
htParts - ? ? ? This table contains the part number, price and the product id.
? ? ? ? ?
htVehicleMakes -? This table is a lookup table for the make of the vehicle.? It contains
? ? ? ? ? simple id and text fields.
? ? ? ? ?
htVehicleModels -? This table is also a lookup table for the model of the vehicle.? ? ?
? ? ? ? ? It contains simple id and text fields.
? ? ? ? ?
htVehicleEngines -? This table contains the various properties of the engine, such as
? ? ? ? ? name, fuel delivery, fuel type, liters, type, and aspiration.
? ? ? ? ?
htVehicleTransmissions - ? This table is a lookup table that describes the transmission
? ? ? ? ? ? ? of the vehicle.? It contains simple id and text fields.
? ? ? ? ? ? ?
htVehicleCompLocations -? This table is a lookup table that contains the description
? ? ? ? ? ? ? and the symbol of the location associated to the vehicle.
? ? ? ? ? ? ?
htMedia -? ? ? This table is an associative table that relates the part data to the
? ? ? ? ? media content for the product, ie. video, images, and documentation.
REQUIREMENTS
Part 1
The requirements for this project is to produce the functionality for searching product
data and deliver it to the main page in table format.? The data returned should return
the part information with all media content with the capability for the user to execute
the media, such as video.
Part 2
Administration pages must be developed to maintian the data and allow for inserts, updates,
and deletions.? A screen to allow multiple deletions is prefered.? The administration pages
also need the capability of uploading media content to the server and associate that content
to the part.
PROJECT STATUS
The database has been created with test data. A view was created to serve up complete vehicles
with all necessary datafields to attach a where clause.? PHP code has been written to connect
to the database and execute this view.? Problems with the HTML markup controls prevented the
completion of this task.
TO BE DONE
1.? The media content tables have yet to be developed along with the necessary lookup tables.? A
? satisfactory design has not bee created as of yet.
?
2.? The search capablilites have yet to be connected with the code to execute the view and deliver
? the results to the page.
?
3.? All administrative pages and code have yet to be developed.