Change two files:
[login to view URL]
[login to view URL]
make changes as documented.
## Deliverables
NEW ADMIN WORK OsCommerce
**SCOPE OF WORK**
A. Make changes to [login to view URL]
B. Make changes to [login to view URL]
NO DB CHANGES NEEDED
**DESCRIPTION OF WORK**
** **
Please refer to three attached jpegs:
* [login to view URL] - how my new product page appears now
* [login to view URL] - how my new product page will appear
* [login to view URL] - how my Product Info page will appear
Please refer to "[login to view URL]" for corresponding **Red Circles with White Letters**:
**X** - Currently "Date Available". CHANGE TO: "Date Added" (redirect to Date_Added db table). Products will now appear in the "New Products" list when date is selected.
**A** - This will be a PULL_DOWN MENU with the following TEXT values:
Chelsea Gallery
57th Street Gallery
Lower East Side Gallery
Upper East Side Gallery
SoHo Gallery
NoHo Gallery
Village Gallery
DUMBO Gallery
Brooklyn Gallery
Long Island City Gallery
TriBeca Gallery
Hudson Square Gallery
Meatpacking Gallery
Other Area Gallery
These need to be able to be changed (not in Admin, just in the code)
**B** - This is an INPUT FIELD with INTEGER VALUES (10 character limit) and commas for thousands, no decimals
**C** - This INPUT FIELD will echo the result of a MATH FUNCTION that multiplies Input-field "**B**" times **0.0929**, rounded to one decimal. (Real world: displaying square feet to square meters.)
**A, B** and **C** become an array that loads the PRODUCT NAME table in the db. The static characters "RSF" "|" and "m2" should become part of the PRODUCT NAME.
This is displayed as the product name on all front-end locations, as it does now.
Example display: **Chelsea Gallery 1,000 RSF | 92.9 m2**
**D** - Currently PRODUCTS PRICE before tax. This does not change and is loaded in products_price table in the db.
**E** - This is currently PRODUCTS MODEL. Change this to an INPUT FIELD that echos the result of multiplying the values entered above for **B** times **D** (above) and dividing by 12. This result then loads the PRODUCTS_MODEL table of the db.
The static characters "$" before the field and "pm" after the field are arrayed with value for **E**.
Example array: ' $' . 'B * D / 12' . "pm' loads to PRODUCT_MODEL
In the real world, this yields monthly rent, by multiplying price per square foot (**D**) times total square feet (**B**) and dividing by 12 months.
**F** - This entire area is new.
Please see **[login to view URL]**. Now I need to enter in the INPUT-BOX html that creates a simple table to convey these specifications, which are always the same values, but in different combinations.
I want to make a series of INPUT BUTTONS, *exactly as shown on **[login to view URL]***, that are arrayed into the PRODUCTS_DESCRIPTION table of the db, along with G below (explained next).
They should be preceded by the static text as shown.
Only one selection is possible, and no selection is allowed.
These will display as shown in [login to view URL] (see **[login to view URL]**).
**G** - These INPUT BOXES exist now and currently load PRODUCT_DESCRIPTION. This should not change, except that the output is added to the back of the output in F (above) when displayed in Product Info.
All breaks and spacing as shown in **Product_info_Sample.jpg.**
** **
**That's it!** No database mods are needed, basically just make a series on input-fields and input-buttons that are arrayed together and display AS SHOWN on the Admin back-end and on the Product Info front-end.
NOTE and CAUTION: I have added several OsCommerce Community Contributions to both of these pages (SEO and multiple images upload contributions) so please do not disturb them. Also, I would like the ability to change the static text in the code if need be.