Changes are required within the Virtuemart

[amanda mc donald]

For the purpose of this quote assume a standard site exist ( complete ) with Virtuemart 2.0.4 and Joomla 2.5 - for as far as the standard functionality allow. 

Changes are required within the Virtuemart Sources.  This project has several phases and this document serves as a summary of phases 1a and 1b.

We can make the location of the site known, but first want a quotation for budgetary purposes. ( Phase 1a and 1b )

Summary

By basically adding a "stock" field to the "product_categories" table and a "type" field to the "Categories" table in Virtuemart the application is to "buy" stock from a specific "location" ( a category type ) and alter the corresponding "stock" field.

Phase 1a ( Basic stock changes )

General Note:
( Create a SQL file for all database changes - so it can be applied & managed easier )

The solution must be able to handle a traffic flow of 360 transactions/hour.

Change the "Product_Category" table in Viruemart to have a "Stock" field ( Integer ) Change the Category table in Viruemart to have a field ( Integer ) for "Category Type". A Type "0" will be "standard" and "1" will be a "location" & a field for an email address. ( Hard Coded at this stage ) All "location" categories  will also be "hidden" ( standard virtuemart ).  ( Location fields will be edited manually )

There is a page that "shows" all the products of a particular "non hidden" category.  On the particular page add a control ( Combobox Selector ) which lists all the "location" type categories ( including "All" ) and on selection will sort  the "product" further & display the subset of product belonging to the particular category. Provide another Combobox selector containing the items ( "All", "In stock" and "Not In Stock" ) - On selection will filter the displayed product even further based on the "Stock" field in the "category" table. ( This selection should only be available if the "category" is not selected as "All" )

By clicking on a product the "product details" page appears. On this page the "Add to cart" button also apprears.  Now: ( To add ) Add a Combobox selector for all "Location" categories.  Only allow "Add to cart" if a particular "location" has been selected, bear in mind that ( the default ) selection of the "location" Combobox should be either "All" or the specific "location" depending if this is known at time of loading the page.

Add a "column" to the cart which will show the "location" field ( as per the Combobox selector at the time of "Adding to cart".

When finally clicking "Check Out Now" do a check whether stock exist ( final check ) before creating an order - else warn user. ( against appropriate field in the categories table )

When an order is placed it should also indicate the "location" ( This will also involve making a change to the database to store the corresponding field )

The email which is sent to the "store" ( on placement of order ) must be sent to the "email address" as per the corresponding field in the "category" table for the particular "location".   

Phase 1b ( GUI minor )

Write an application in C# using Microsoft Visual Studio to illustrate making a connection to a Virtuemart ( MySQL )  database & changing a sample field over a secure connection, where database "connection details" are also transmitted in a secure manner.

Other Phases: ( major )
Involves consultancy with respect to the following:
(a) SEO
(b) Strategy to keep this "in line" with Virtuemart & Joomla
    future "upgrades"
(c) Security
(d) Query Optimizations

Please reply to smartfamilysa@gmail.com if you can help and please provide a quote.

Regards
Amanda