A Complete Web  Application: "Super Store"

Top  Previous  Next

The "Super Store" is a web application where a product catalog is presented, orders are created and tracked.

The users of the system are mainly the Sales Representatives that can

1.Browse the products stored in the database
2.Maintain a customer list. (Add/Delete/Update Customers)
3.Create orders
4.Execute view the completed orders and change their order statuses.

 

The Database

The database of the "Super Store" Application will store the products, the customers and the orders. This tutorial was prepared to support Apache Derby, MySQL, MS SQL Server and Oracle databases.

The Application

We will explore "the developing without coding" capability of the MMAS by utilizing the RelDB and Mailer components in Process Management Framework. The pages of the application and the provided functionality will be as follows.

Page Name

Function

Customers

Insert / Delete / Update Customers existing in the "customers" table

Products

Display the products existing in the "products" table and let the user filter the product list on the page by selecting one of the product categories existing in the "product_categories" table.

Let the user to select one or more products from the list and add to the order.

CurrentOrder

Display the content of an order being prepared and let the user make changes on it.

If the order is submitted by the user create records in the database tables "orders" and "order_details".

OrderList

Display the list of the created orders.

The user can click on a order to see its details in "OrderDetails" page.

OrderDetails

Display the details of an Order. Let the user to change the status of the order or delete the order together with its ordered products.

Administration / Users

Display the list of the users of the system, add new users, update or delete existing users. Add / Remove roles to / from users.

Administration / Roles

Administer the roles and the checkpoints (user authorities) of the system.

 
Note: You can refer to the sample project (SuperStore) provided with the package to see the application as a whole.