Suljettu

Parts MAP Phase I

Scope of Work- Auto Bulb Parts Selection Site

Date: 4/29/2009

Revision: A

CL (CL):

Chris Bacon (Ctlumination LLC)

Service SP (SP):

TBD

Summary of overall Goals:

Develop a new website that incorporates vehicular parts reference data for each model year, model and make.

1. This website will allow users to look up a list of parts for their vehicle by selecting as follows:

1. Part Category

2. Make and Model Year

3. Model

The parts categories will be selectable.

2. After these selections are made, a list of the correct parts for that combination of Part Category, Make, Model Year and Model will be displayed using a graphic image.

3. Each page will display frames to allow the administrator to display links to other pages and banner advertisements. The main data frame showing the search results will be static, but the administrator can change and update the frames by changing a single file. Other frames will be dynamic and display up to 10 banner advertisements that appear randomly from a master list that is controlled by the administrator.

4. IMPORTANT: ** All webpages pages must appear in HTML format so that they can be crawled by the search engines for content.

5. The initial phases (Phase I, II and III) of the project will only set up the Automotive Light Bulbs Data. This scope shall set up the framework to look up other part categories, but it will not populate the data for other part categories, such as Automotive Oil Filters, etc…

The initial bid (Phase I) shall only include work on the back-end MYSQK data base and admin panel interface for data entry and populating the data for model year 2007. Phase II and III shall be a separate project and shall be bid after the completion of phase I. Phase II shall be to populate all data for the remaining light bulbs used in all models and makes for 1950-2006 and 2008-09 model years. Phase III shall be to complete the front end. The front end will allow visitors to the site to enter their vehicle Part Category, Make, Model Year and Model. A page will then be displayed to show all of the parts for their vehicle.

6. Phase I of the project shall require an elegant use of various forms of data entry to make the entry, editing and display of data easy and quick

7. Data accuracy for this project is extremely important. Extra emphasis must be placed to assure that the data that is looked up accurately, thoroughly precisely and translated into the new website

Overview:

Master Administration Panel (MAP)

The back-end shall consist of a Master Administration Panel (MAP) that will serve as the interface to enter, edit and view all of the data. The data entered from the MAP shall be stored in an SQL database. Phase I of the project shall be to develop the MAP interface, SQL database and enter all data for the 2007 model year ( to prove functionality).

i. LOGIN

The initial MAP page shall be a login page. The login page shall be username and password protected and allow for standard username and password retrieval.

Example:

[url removed, login to view]

ii. Part Categories.

The next page will allow the user to establish the Part Categories as follows:

A. Automotive Light Bulbs

B. Automotive Oil Filters

C. Automotive Air Filters

D. Etc…

The initial phase of the project will only set up the Automotive Light Bulbs Data Base (back end). This scope shall set up the framework to enter other part categories, but it will not populate the data for other part categories, such as Automotive Oil Filters, etc…

This page will allow the administrator to add, delete or edit an infinite number of Part Categories.

Example:

[url removed, login to view]

iii. Make.

After entering the Part Categories, the administrator will then enter the vehicle makes.

Example:

[url removed, login to view]

This page will allow the administrator to add, delete or edit an infinite number of Makes.

iv. Model.

After entering the Makes, the administrator will then enter the Models for each model year.

Example:

[url removed, login to view]

This page will allow the administrator to add, delete or edit an infinite number of Models and assign the model years associate with each model.

[url removed, login to view]

The model years for each model shall be selectable from a drop down menu using SHIFT / CTRL keys.

v. Part Location Names.

After entering the Models and model years, the administrator will enter the Part Location Names.

Example:

[url removed, login to view]

This page will allow the administrator to add, delete or edit an infinite number of part location names for each part category.

The page shall be dynamic so that when the part category is changed the lower display shall dynamically change to show the current list of part location names for the category selected.

vi. Templates

In order to aid data entry, a templates section shall be created. The templates section shall allow the administrator to create a parts list template. These templates may be used later to pre-populate data for a particular make, model and model year. Due to symmetry of many parts lists, this feature will be invaluable to allow phase II (data entry) to be completed more easily.

Example of the Template page:

[url removed, login to view]

Example of a template for Model Year 2009 Make Acura Model TSX Category Automotive Light Bulbs

[url removed, login to view]

This page will allow the administrator to add, delete or edit an infinite number of templates and parts lists.

vii. Master Parts List

A master parts list shall be used to create a master list of part numbers that are used on any or all vehicles. Each parts list shall be unique for a given part category. Also specific details associated with each part shall be entered (see example below). The page shall be dynamic so that when the part category is changed the lower display shall dynamically change to show the current master parts list for the category selected.

The Master Parts List shall contain data fields as shown in this example:

[url removed, login to view]

In order to aid data entry and improve graphic display, the text boxes shall be dynamic to allow the text box to open for editing and then appear as text for display on the same page. This shall be done either using a mouse click or by hovering the mouse over the data.

viii. Master Part Lists (Not to be confused with Master Parts List)

The Master Part Lists shall be where the parts for each Make, Model and Model Year are entered. This page is where all of the previous data entered is married up for each Make, Model and Model Year. Also this is where the templates may be used to pre-populate the date fields.

Example:

[url removed, login to view]

IMPORTANT: The page shall be dynamic so that the page will update automatically as the user enters the Category, Make, Model and Year. Both the drop down boxes and the lower display shall update dynamically as each selection is made.

[url removed, login to view]

viii. Manage Banner Ads

Example:

[url removed, login to view]

A page shall be created to allow the administrator to manage banner advertisement that shall be displayed in the front end when the website is completed in Phase III.

x. Configuration

A configuration page shall be set up to configure the back end and front end with basic information.

Example:

[url removed, login to view]

Example of Phase II data entry and phase III front-end:

The 2007 BMW 500 series Automotive Bulbs Page to be used for data lookup in Phase II looks like this:

2007 BMW 500 Series (With replaceable halogen capsules)

Low beam headlamp

H7LL

H7SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen

H7ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen

H7XV XtraVision Halogen - The Brighter Light

H7CB Cool Blue Halogen - The Whiter Light

High beam headlamp

H7LL

H7SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen

H7ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen

H7XV XtraVision Halogen - The Brighter Light

H7CB Cool Blue Halogen - The Whiter Light

Parking light

2825LL

Front turn signal

7507

7507AST Silverstar Signal Lighting: Complete the Look: Crisp, Clean, Style

7507LL Long Life Upgrade: Up to twice the life of the standard lamp

2827

Rear turn signal

7507

7507AST Silverstar Signal Lighting: Complete the Look: Crisp, Clean, Style

7507LL Long Life Upgrade: Up to twice the life of the standard lamp

Tail light

7506LL

Stop light

7506LL

High mount stop light

Assembly

Fog/Driving light

9006

9006SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen

9006ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen

9006XV XtraVision Halogen - The Brighter Light

9006CB Cool Blue Halogen - The Whiter Light

License plate

6418

6418LL Long Life Upgrade: Up to twice the life of the standard lamp

Back up light

921LL

Glove box

6418

6418LL Long Life Upgrade: Up to twice the life of the standard lamp

Map light

6486X

Dome light

6486X

Step/Courtesy light

6411

6418

6418LL Long Life Upgrade: Up to twice the life of the standard lamp

6486X

Trunk/Cargo area

6411

Instead, the new front-end page will have three frames:

· Header

· Banners

· Data

It may look like this:

Tabular display:

[url removed, login to view]

The admin panel shall be set up to operate as follows:

1. Each location shall have the identical Locations identified as follows:

Bulb Location

Low beam headlamp

High beam headlamp

Low/High beam headlamp

Parking light

Front turn signal 1

Front turn signal 2

Rear turn signal 1

Rear turn signal 2

Front side marker

Rear side marker

Tail Light 1

Tail Light 2

Stop Light 1

Stop Light 2

High mount stop light

Fog/Driving light

License plate

Back up light

Glove box

Map light 1

Map light 2

Dome light 1

Dome light 2

Step/Courtesy light 1

Step/Courtesy light 2

Step/Courtesy light 3

Trunk/Cargo area

Ash Tray

Under hood light

Instrument-general 1

Instrument-general 2

Instrument-general 3

Instrument-general 4

Instrument-general 5

Directional signal indicator

Radio Dial

Clock

Hi-beam indicator

Seat belt indicator

Brake warning

Ignition switch

Automatic transmission indicator

Check engine indicator

2. For each bulb location for each model, model year, and make, a bulb part number shall be entered.

3. The remaining columns shall be automatically populated from a lookup table that is keyed from the bulb part number.

Example:

Only the part numbers are entered like this:

Bulb Location Part Number

Low beam headlamp H7

High beam headlamp H7

Low/High beam headlamp N/A

Parking light 2825

Front turn signal 1 7507

Front turn signal 2 N/A

Rear turn signal 1 7507

Rear turn signal 2 N/A

Front side marker 2827

Rear side marker N/A

Tail Light 1 7506

Tail Light 2 N/A

Stop Light 1 7506

Stop Light 2 N/A

High mount stop light Assembly

Fog/Driving light 9006

License plate 6418

Back up light 921

Glove box 6418

Map light 1 6486X

Map light 2 N/A

Dome light 1 6486X

Dome light 2 N/A

Step/Courtesy light 1 6411

Step/Courtesy light 2 6418

Step/Courtesy light 3 6486X

Trunk/Cargo area 6411

Ash Tray N/A

Under hood light N/A

Instrument-general 1 N/A

Instrument-general 2 N/A

Instrument-general 3 N/A

Instrument-general 4 N/A

Instrument-general 5 N/A

Directional signal indicator N/A

Radio Dial N/A

Clock N/A

Hi-beam indicator N/A

Seat belt indicator N/A

Brake warning N/A

Ignition switch N/A

Automatic transmission indicator N/A

Check engine indicator N/A

From this information, the remaining fields shall be populated from the lookup table.

For example: Entering Part Number H7 calls up the remaining columns associated with Part Number H7:

Bulb Location Part Number Common Part Number & Description Part Number Cross References Image (click to enlarge) Link to Specs. Purchase Bulbs

Low beam headlamp H7 H7 H7 PX26d Specifications Buy Now

The entire list for a model, model year, and make may look like this:

Bulb Location Part Number Common Part Number & Description Part Number Cross References Image (click to enlarge) Link to Specs. Purchase Bulbs

Low beam headlamp H7 H7 H7 PX26d Specifications Buy Now

High beam headlamp H7 H7 H7 PX26d Specifications Buy Now

Low/High beam headlamp N/A N/A N/A N/A N/A N/A

Parking light 2825 194 194 W5W 147 152 158 159 161 168 184 192 193 259 280 285 447 464 555 558 585 655 656 657 1250 1251 1252 2450 2652 2921 2825 Specifications Buy Now

Front turn signal 1 7507 7507 7507 Bau15s PY21W Specifications Buy Now

Front turn signal 2 N/A N/A N/A N/A N/A N/A

Rear turn signal 1 7507 7507 7507 Bau15s PY21W Specifications Buy Now

Rear turn signal 2 N/A N/A N/A N/A N/A N/A

Front side marker 2827 194 194 W5W 147 152 158 159 161 168 184 192 193 259 280 285 447 464 555 558 585 655 656 657 1250 1251 1252 2450 2652 2921 2825 Specifications Buy Now

Rear side marker N/A N/A N/A N/A N/A N/A

Tail Light 1 7506 1156 1156 P21W 1073 1093 1129 1141 1159 1295 1459 1619 1651 1680 7506 7527 Specifications Buy Now

Tail Light 2 N/A N/A N/A N/A N/A N/A

Stop Light 1 7506 1156 1156 P21W 1073 1093 1129 1141 1159 1295 1459 1619 1651 1680 7506 7527 Specifications Buy Now

Stop Light 2 N/A N/A N/A N/A N/A N/A

High mount stop light Assembly N/A N/A N/A N/A N/A

Fog/Driving light 9006 9006 9006 Specifications Buy Now

License plate 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now

Back up light 921 921 579 901 904 908 909 912 914 915 916 917 918 920 921 922 923 926 927 928 939 Specifications Buy Now

Glove box 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now

Map light 1 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now

Map light 2 N/A N/A N/A N/A N/A N/A

Dome light 1 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now

Dome light 2 N/A N/A N/A N/A N/A N/A

Step/Courtesy light 1 6411 41mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now

Step/Courtesy light 2 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now

Step/Courtesy light 3 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now

Trunk/Cargo area 6411 41mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now

Ash Tray N/A N/A N/A N/A N/A N/A

Under hood light N/A N/A N/A N/A N/A N/A

Instrument-general 1 N/A N/A N/A N/A N/A N/A

Instrument-general 2 N/A N/A N/A N/A N/A N/A

Instrument-general 3 N/A N/A N/A N/A N/A N/A

Instrument-general 4 N/A N/A N/A N/A N/A N/A

Instrument-general 5 N/A N/A N/A N/A N/A N/A

Directional signal indicator N/A N/A N/A N/A N/A N/A

Radio Dial N/A N/A N/A N/A N/A N/A

Clock N/A N/A N/A N/A N/A N/A

Hi-beam indicator N/A N/A N/A N/A N/A N/A

Seat belt indicator N/A N/A N/A N/A N/A N/A

Brake warning N/A N/A N/A N/A N/A N/A

Ignition switch N/A N/A N/A N/A N/A N/A

Automatic transmission indicator N/A N/A N/A N/A N/A N/A

Check engine indicator N/A N/A N/A N/A N/A N/A

Additional requirements:

The Service SP (SP) shall be responsible to provide the CL (CL) the following:

Software to accomplish the following tasks:

1. Software for the MAP for PHASE I as defined above.

2. MYSQL database.

3. Populate the automotive bulb section for model year 2007 by manually looking up the data using the existing site as a reference (as shown above).

The software and database will be provided so that it is easily transferable to any hosting service and can be transferred anytime with no restrictions.

Confidentiality Agreement:

The software and all data be provided to the CL and become the sole property of the CL. In order to complete the project the CL must give the SP certain data

The SP must assure that CL that the software and data provided and generated shall not be sold of offered to any other CL. The data to be provided is considered proprietary, and is the sole possession of the CL.

The CCES will not require any licensing agreements, monthly fees or copy write protections applied.

The SP shall provide any consulting service required to assure that the CCES is functioning on the SP’s hosting service.

The SP shall identify all files and directories required to be transferred so that the CL is able to transfer, backup, restore or propagate the required CCES and all customer and order data to allow any hosted server to function using this software.

The SP shall provide support and training to the CL on how to propagate, backup and transfer the CCES and all customer and order data to each of the CL’s hosted servers for use on each of the CL’s websites.

The SP agrees to provide free technical support for one year after completion of the project.

The project shall consist of two phases:

Phase I:

Complete software and MAP including full data population for all light bulbs used in all models and makes for 2007 model year only.

Payment terms and milestones for Phase I:

50% escrow to GAF to start project.

50% payment released upon demonstration of all software, and functionality of the administration panel on the SP’s server.

25% payment released upon demonstration of all, data entry for model year 2007 accuracy verification and functionality on the SP’s server.

25% payment released upon demonstration of all software and functionality on the CL’s server.

Other Basic Project Requirements (Please Read and Agree or DO NOT BID):

· A written progress or status update report must be sent 2 times per week. If the status is not updated regularly, the project shall be considered to be in default.

· Progress must be seen at least on two occasions each week. If one week passes with no significant progress on the project, the project shall be considered abandoned and in default.

· Contact may be made to you at any time. Any request for status or information shall be answered within 48 hours or the project shall be considered to be in default.

· Regular business days are considered Monday – Friday. If for any reason you will be unavailable for 3 or more consecutive business days, you must notify me in advance, or the project shall be considered to be in default.

· I expect this project to be taken seriously and work to progress regularly. If you do not have time to dedicate to this project, please do not bid.

Phase II:

Populate all data for the remaining light bulbs used in all models and makes for 1950-2006 and 2008-09 model years.

Phase II shall be considered a separate project. The SP can provide a bid for that work after the completion of phase I.

Phase III:

Create the Front END Final Website.

Phase III shall be considered a separate project. The SP can provide a bid for that work after the completion of phase I.

Taidot: tiedonsyöttö, Javascript, PHP

Näytä lisää: written service agreement, write templates, restrictions, week end update, websites templates free, websites template free, websites free templates, websites created free, website models templates, website contact technical support, website clock template, vehicle service data, vehicle graphic templates, user specifications template, user requirements specifications template, unique banner ads, times standard, time map template, three model, text consulting agreement, terms service agreement example, terms agreement example, terms agreement template, template websites work free, template websites free

About the Employer:
( 2 reviews ) Gilbert, United States

Projektin tunnus: #426599