Demonstration of a mod for DBman

D E M O of ORDERnary

Description of the mod.

ORDERnary - a simple shopping cart mod

No cookies, no online payment.

The identity of the user is kept in $order_mail, which is initiated when the customer creates the order and is then passed along all the time till the order has been sent or cancelled.

Requirement

This mod is based on JPDenis excellent mod User-friendly html.pl with the addition of the short/long mod, another of JPDenis excellent mods, at http://www.gossamer-threads.com/scripts/resources/DBMan/Modifications/more2.html

Functional description

  1. When a new customer does a search and a result record is displayed there is also a form to fill in to prepare the order: The user must enter his/hers e-mail address. The e-mail address is then used both as a name of a temporary file and as an identification that is passed along until the order is sent or cancelled. The user must confirm the address

  2. When the form has been approved the customer is returned to the same record where he/she now can fill in the number he/she wants of this specific item. This is at submit appended to the MAIL_ADDRESS.txt file.

  3. Then the customer comes to a confirmation page where the order so far is displayed (total number of items, total cost) and buttons for ORDER MORE ITEMS, CHECK ORDER, EDIT ORDER, SEND ORDER and CANCEL ORDER.

  4. At SEND ORDER the customer has to fill in the complete addressing details before the order file is sent to the shop keeper (with some additional tracing info). A copy is sent to the customer. If you set $auto_delete=1 in .cfg the file will be deleted when sent.

  5. CANCEL of course deletes the file without sending.

  6. EDIT makes it possible to delete marked items from the order (Not change number of items, I'm afraid)
For sake of demonstration the mail with the order that should be sent to the shop keeper has been diverted to the customer/tester.

In the demo the login function has been disabled.

This shopping cart mod is primarily for searching. The ADD/MODIFY/DELETE features have not been touched since the database is to be uploaded when it's time for an update. The shop-keeper upload the complete data base (an Excel file wich has been saved as a text file with | delimiters, see http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=85537;search_string=excel;guest=7717791#85537)

The discussion on this mod is http://www.gossamer-threads.com/perl/forum/showflat.pl?Cat=&Board=DBCust&Number=15399&page=3&view=collapsed&sb=5

The mod code can be found at http://tangokites.org/dbman/ORDERnary/order_mod.txt, with an included change history.

A simple example of the help file can be found at http://tangokites.org/dbman/ORDERnary/help.html