• An eCommerce Site Backed by Web Services
• Due Date: <hi>Thu November 22</hi>
• Team Size: min=2, max=3 students
• Technological Platform to be used: JEE

The Foods R Us Company is a consolidating retailer. It specializes in selling exotic food items but it does not stock inventory. Instead, it takes purchase orders (P/O's) from its clients, consolidates them, and then procures them from business partners who stock the items and provide them wholesale; i.e. the partners do not venture into the retail market. In this business model, Foods R Us makes money by benefiting from volume discounts (due to consolidation) and by marking up wholesale prices. The latter factor, however, can backfire: if the markup is too high, the Company will not be competitive, and if it is too low, it becomes vulnerable to market fluctuations and this may lead to a net loss (by under-selling the suppliers). The Company has to deal with, and attempt to mitigate, this risk, and hence the need for sophisticated eCommerce technologies.

The sought system consists of two parts, one is B2C and the other B2B. Part 1 enables the Company's (human) clients to browse its catalog, add items to a shopping cart, and place orders. This part culminates in several P/O files stored on disk. Part 2 is non-interactive and runs as a scheduled job on a nightly or weekly basis depending on volume. Its input is the set of P/O files created by Part 1. It consolidates them by forming the union of the P/O's such that each item appears only once with a quantity equal to the sum of its quantities in all the P/O's. After creating the combined order, this part of the system connects to several web services and determines who supplies each item and at what price, optimizes the procurement, and places one or more order.

The relevant URL is red.cse.yorku.ca:port/eFnnnnnn/servlet/Catalog (where eF stands for eFoods and nnnnnn is the rightmost 6 characters of the cs# of a team member (designate one team member to be the liaison contact person). The Catalog servlet displays the catalog of the Company. It is up to you to determine how this display is done based on the amount of time available for this task. For example, you can at one extreme display all the items in one page; you can show the hierarchy by displaying only the categories and then the selected items; you can enable both direct and category-based access; you can have a search facility; you can have an express order form for those who know the item numbers; etc. Whatever you do, the client must be able to see the item's number, name, quantity per unit, and price. The client must also able to add an item to an initially empty shopping cart.

The Cart servlet must react by displaying the content of the shopping cart. The display should be tabular with one item per row. The table columns display the number, name, and price of each item in a read-only fashion. In addition, there should be a writable column for the desired quantity and a read-only one for the extended price. The display should also indicate a total, PST and GST (based on Ontario), a shipping cost ($5 that is waived for orders of $100 or more before taxes), and a grand total. The page has three buttons: Update (to refresh the calculated fields after editing a quantity), Continue Shopping, and Checkout. Notice that if the entered quantity of an item is zero then it should be removed from the cart. You need to also handle the case of negative or non-numeric quantities.

Upon checkout, the servlet must normally switch to https and prompt for the client name, shipping address, and payment details. We are not going to do that for this project. Instead, we will continue to use http and we will assume that all clients have already established accounts with the Company, i.e. each client has a profile that contains the shipping address and payment preferences. Hence, we will serve a login screen that displays the total amount and prompts for the client's account number and password. Upon authentication (based on accounts.txt) a confirmation screen is displayed to indicate that the P/O has been accepted and to provide a URL that the client can visit at any time to view the created P/O. See the next use case for details.

Upon confirmation of a P/O, the system stores its content in an XML file based on the PO.xsd schema. The name of the P/O file is derived from the account number of the client and the P/O number (a per-client serial number that starts at 1). For example, the URL of the 3rd P/O of account number 1234B555, is: http://red.cse.yorku.ca:port/eFnnnnnn/po1234B55503.xml. Since this is an XML file, it needs to be transformed to XHTML before the client can see it. You can do this at the server or (preferably) at the client side. Note that this use case does not involve authentication.

In addition to the above use cases, it is recommended that your site supports the following uses: the ability to view the shopping cart from the catalog screen (i.e. without having to add an item); the ability to checkout from the catalog screen; the ability to cancel an order from the login screen.

This off-line, non-interactive system is ran nightly when the web server is down. It consolidates all the P/Os of the day to generate a procurement order: a list of all the needed items and the overall quantity needed for each. Next, it connects to the web services of three major Canadian wholesalers, one in Toronto, one in Vancouver, and one in Halifax. For each procurement item, it determines who has it, chooses the one with the lowest price, and places an order. No shipping charges or taxes are in scope here. When procurement is completed, it generates a procurement report (HTML) detailing the ordered items, the chosen wholesaler of each, and the winning bid price.

Placing an order requires a key. A unique key will be given to each team.

• The catalogue of the company as an XML data source

• The catalogue's schema

• The purchase order's schema

• The clients' profiles as a tab-delimited file. The profile fields are: account number, name, street address, city, province, postal code, pin.

Note These files must be stored in a protected location. In order to keep your webapp portable, make sure you never refer to these files via their absolute paths. Use the getRealPath(“/”) instead.

The following files describe the web services from which the company procures its products:

• The WSDL of the Toronto Wholesaler

• The WSDL of the Vancouver Wholesaler

• The WSDL of the Halifax Wholesaler

You need to deliver three things by the due date of this project:

• Hand in a paper report

This can be done after class or to the Department Office

• Submit the report and source files

The report file (in pdf, doc, or html formats) and the Java files. These can be submitted using: submit 4413 proj files

• Upload a WAR webapp

Create a war file of your webapp and upload it to the project's port number.

The report is meant to describe your execution of the project to someone who is familiar with the project, e.g. a fellow student who is also executing the same project and writing a similar report. Hence, the report should focus on your own experience and efforts, i.e. what you actually did, rather than on general description. It is expected to be very brief, to the point, and made up of at most five typed pages (excluding the source listing). The report should include the following sections:

1. Design

During the execution of this project, several design decisions had to be made, e.g. file formats, algorithms, representations, etc. Describe in this sections the key decisions that were made and why they were made the way they did. For example, how many servlets are there, what is the function of each, and how does data flow among them.

1. Implementation

Indicate here how data is represented and any java classes that are used in addition to the main servlets. Indicate also whether the project (as submitted) is fully functional or not. If it is, indicate the type of testing that was done. If it is not, indicate clearly any parts of it that are functional. If certain parts could not be implemented, describe the problems that were encountered.

1. The Team

Provide the cs# and name of each member of the team and indicate the contact person in case there are questions. Describe how the project was executed by the team, e.g. who did what.

1. The XML Order

Include a printout of the XML order file that was generated for one of the orders.

1. The Source Code

Provide listing of all programs. Partition this section into subsections and provide a title for each. Make sure the code is properly formatted. Some editors do not format properly because they use spaces instead of tabs or use proportional fonts. Do not delay printing your code to the last minute; resolve this issue early on.

The project will be evaluated based primarily (80%) on what your team achieved (report; design; correctness, quality, and style of implementation; and the interface) and partly (20%) on how your project compares with those of other teams.