/    Sign up×
Community /Pin to ProfileBookmark

Submitting to Database and Emailing?

Greetings All,
A friend has asked my help with building him a purchase order form that he is going to use for his clients.

He wishes to have clients fill out the quantity of the products they desire from a product list. The product list is pulled from a database and has a price associated with it.

When the user enters a quantity, the total automatically multiplies the quantity entered by the price associated with that product and outputs it to the total field for the client to see. I am guessing this step requires javascript/ajax

After the client has selected the products he desires from the list (the products are selected based on the quantity you entered, if quantity=0, then the product is not chosen, else it is), he then clicks a preview button to revise his purchase order. The client should ONLY see products that he entered a quantity for. The client can then choose to edit the PO (purchase order) or submit to to be stored in both a database and emailed.

The next step is when the client submits the form, it is emailed to both the client and the store admin. He would either like it possible that the email comes as a .pdf, listing the purchase order products, quantity, total and master total (master total = all of the totals added) as a professional purchase order. The other solution would be to email the purchase order in a table format using html in the email. I personally prefer the option where the purchase order is turned into a professionally laid out .pdf file listing the product fields and the totals. This would allow the admin to print it out and process it.

Finally, the admin would like to be able to view all the client’s history purchase orders. So if a client made any purchase orders in the past, it would display in their history.

Oh, and every client has their own login, password and history (obviously).

[INDENT][B]Step 1:
Client Logs into system using their username and password

Step 2:
Client goes to the product listing page and fills out the quantity field for each product he wishes to make a purchase of.

Step 3:
On clicking revise, the clients revises the purchase orders for accuracy.

Step 4:
The client then submits the PO which is emailed to both himself and store admin AND the PO is stored in the client’s order history

Step 5:
Admin recieves the PO in the form as an attached .pdf file via email and processes it.

Step 6:
Admin can log into the control panel to create and edit users and view past users purchase order history. [/B]
[/INDENT]

Anyone want to point me in the right direction starting from the top. I plan to finish this within one week.

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @gc40 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...