*** PLEASE NO AUTO BIDS - PLEASE READ THE DESCRIPTION COMPLETELY AND OFFER YOUR SUGGESTION ON ITEM #3 BELOW SO WE KNOW YOU UNDERSTAND THE REQUIREMENT
CURRENT DESIGN: We have an existing Intranet application that gives users a way to generate label data into a MySQL database using an online form. Users have the choice of choosing two different pages. One page is for their own product labels and the other page is for private labeling. Both pages are nearly identical with nearly the same form fields to be filled out. We use two different pages so that users can easily tell which type of label they are printing. The two pages have different coloring to easily identify them.
There is a requirement to add another type of label. Under the current design, this would also require a new web page with the same form fields. This obviously is redundant work and is creating more pages to build, administer and maintain.
FUTURE DESIGN: We would like to consolidate all pages into a single page and provide a dynamic way to add new label types in the future without needing to build additional separate pages.
NOTE: We will use one of the current pages to start from so the steps below are simply enhancements to the existing page. There is no requirement to build this page as it already exists. Only the features below need to be added to it.
We will design and supply a MySQL table that will store the label names for the drop down as well as the color that will be displayed in the header when each selection is made.
1. Add a drop down value to one of the existing pages that will allow selection the type of label. These label type values will be stored in the MySQL table mentioned above. The drop down should pull its values from this table.
2. Based on that selection, the screen header would change color to signify that a different label has been selected. Each label selection will have its own assigned color. These color values (HTML HEX color codes) will be stored in the MySQL table mentioned above. The HTML color for the header should be pulled from this table.
3. Based on the selection, the form fields required for that label would be displayed. All other form fields would be empty and hidden from the form... Freelancer will suggest some methods for this. Possible options:
b. An additional value can be stored in the table with the label types and colors with an array of ids that represent which form fields to display
The option chosen in #3 should be as dynamic as possible to allow for easy future administration so that when we add new label values and form field to the database and page, we can easily decide which form fields to show/hide.