Find Jobs
Hire Freelancers

Parts MAP Phase I

$250-750 USD

Đã đóng
Đã đăng vào gần 15 năm trước

$250-750 USD

Thanh toán khi bàn giao
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: [login to view URL] 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: [login to view URL] iii. Make. After entering the Part Categories, the administrator will then enter the vehicle makes. Example: [login to view URL] 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: [login to view URL] 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. [login to view URL] 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: [login to view URL] 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: [login to view URL] Example of a template for Model Year 2009 Make Acura Model TSX Category Automotive Light Bulbs [login to view URL] 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: [login to view URL] 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: [login to view URL] 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. [login to view URL] viii. Manage Banner Ads Example: [login to view URL] 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: [login to view URL] 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: [login to view URL] 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.
Mã dự án: 426599

Về dự án

9 đề xuất
Dự án từ xa
Hoạt động 15 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc

Về khách hàng

Cờ của UNITED STATES
Gilbert, United States
5,0
2
Phương thức thanh toán đã xác thực
Thành viên từ thg 9 5, 2008

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.