Suljettu

Changes in Virtuemart

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 if you can help and please provide a quote

Regards

Amanda

Taidot: Apache, Joomla, MySQL, PHP, Virtuemart

Näytä lisää: show product categories virtuemart combobox, product categories combobox virtuemart, mysql database buy, in n out application, hour change 2012, email application in php, buy email traffic, quote to illustrate, product selector, microsoft visual studio, in stock, filter sort, d secure transactions, combobox, joomla default document, filter product joomla, joomla user location, mysql sort field, add sample cart, visual studio mysql, mysql stock control database, using mysql stock control, mysql change connection, mysql selector, mysql create table sort

About the Employer:
( 0 reviews ) South Africa

Projektin tunnus: #1725761

8 freelanceria on tarjonnut keskimäärin 1547 R tähän työhön

graphicaa

Good day, I can assist you. Thanks.

1999 R ZAR 15 päivässä
(206 arvostelua)
7.4
joomextensions

Hello, We are ready for that job. Please check Private Message. Regards.

1750 R ZAR 6 päivässä
(81 arvostelua)
7.3
WebBizSolution

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Lisää

1777 R ZAR 15 päivässä
(76 arvostelua)
7.3
sat12

Please see PMB

1500 R ZAR 5 päivässä
(115 arvostelua)
5.9
squaresoftware

We are a central india based a renown software company. Wroking from last 8 years, some very strong web based secured .net application for refrence.. [url removed, login to view](Complete social networking portal like Face Lisää

1200 R ZAR 25 päivässä
(0 arvostelua)
0.0
nancywhite4

Hello It is our pleasure to work with you on your project. We are willing to provide you quality services,please look further for the expertise on our work. Kind Regards

1200 R ZAR 25 päivässä
(0 arvostelua)
0.0
jkadziola

Hi. I'm Joomla developer. I can give the best result in shortest time. I am sure you will be satisfied with my work. Thanks and have a nice day.

1200 R ZAR 6 päivässä
(0 arvostelua)
0.0
J95ZunRH8

Custom software development - <b><i>Removed by Admin</i></b>

1750 R ZAR 1 päivässä
(0 arvostelua)
0.0