Project Detail

Description

Please adopt design from our webpage www.bodyfriend.at . Kindly advise also if programming as Joomla 1.0 component would be feasible.




Project Part 1:
Online Menu Catering – Company Version
Due Date July 20th, programming language PHP/MySQL


An administrator backend to the following web site should be added: http://lunchbox.bodyfriend.at/bestellung2/.
The only needed addition to the above frontend would be customer email adress.
Orders should be summarized in MySQL based on the submitted company name. Customers should receive an email containing log-in information and link to an online summary of his/her companies collected orders.

If the customers company is not yet registered to the database the customer should receive information that the order can not be processed and would require company registration first.
Otherwise if the company is already registered, in the case of invalid form fields, an alert message should appear to remind of potential typo errors.

The online order collections should be structured as follows. List view of weekdays (MO-FR). Each day should summarize ordered menus and assigned customers.


MO TUE WED THU FR
Sabine Mayr Beef Stake
Emma Watts Curry
Oliver Sugar Pasta
Sum of menus 1 1 1

For each day the number of menus should be shown. Further cost per day and per week should be presented. Costs of each order are calculated from the amount of ordered menus plus delivery costs. Data for the list view illustrated above should be taken from MySQL. Through the backend the cost per menu, delivery cost per delivery(which is the same as per day) and minimum order quantity for delivery should be customizable on individual company basis. Please note we only have one standard price for all different sorts of menus.

Minimum order quantity: = quantity of menus per day that needs to be reached so we can proceed delivery. If collected orders for this day are below value defined in the database information should be shown in the online list that delivery can not be processed.

Each customer has a different delivery cost per day independent from the amount of menus ordered. We would also like to have the opportunity to enter a defined amount of menus per day or per week that automatically triggers free delivery.

E.g EXAMPLE 1
Minimum order quanitiy 5 menus per day, delivery costs € 3, „free of charge-trigger“ 10 menus per day

• 1 – 4 menus: no delivery possible
• 5 – 9 menus: delivery cost = 3 € per delivery
• 10 menus: free delivery


E.g EXAMPLE 2
Minimum order quanitiy 5 menus per day, delivery costs € 3, „free of charge-trigger“ 20 menus per week

• 1 – 4 menus: no delivery possible
• 5 – 9 menus: delivery cost = 3 € per delivery
• 6 menus on Monday, 14 menus on Tuesday: = 20 menus per week: free delivery

Backend should contain a „finalize orders“ button that submits the current order collection including invoice data to all customers email adresses and copy to us.



Project Part 2:
Online Menu Catering – Single Customer Version
Due Date July 27th, programming language PHP/MySQL


An online order form should contain 7 days (MO – SO). Each day 8 different menus are offered. Customers should be able to pick menus and change quantities of menus. In the backend we would like to have the option to change the nummer of different menus offered per day.
Customers are required to fill in a similar form like http://lunchbox.bodyfriend.at/bestellung2/ including name and email adress. New customers are asked to fill in our order form (This form exists already).

2 interactive elements should be included next to the choice of menus.

a) Each menu has a defined kcal (calorie) value which should show up next to the respective menu. Both, name and respective kcal value should be customizable through a backend. The total value of calories per day should be summed up based on the menus selected.
b) Similar to the kcal values for each menu we would like to enter credit points through the backend. Customers usually pay in advance for a certain amount of credit points. Points are deducted for each ordered menu. Here again the total amount of points per day as well as for the entire week (of the selected menus) should be shown.
c) In addition to the credit points for menus delivery costs per day are also charged as credit points. Once again please allow administration of credit points for delivery in the backend.
d) The number of total available credit points should also be visible to the customer and will change with every additional menu selected (click on menu).
e) Customer data (name, number of credit points etc.) should be stored in MySQL and updated with every single order submission. Please allow us the possiblity to change points.

Orders should be summarized in MySQL based on the submitted customer name.
If the customer is not yet registered to the database the customer should receive information that the order can not be processed and would require registration first.
Otherwise if the customer is already registered, in the case of invalid form fields, an alert message should appear to remind of potential typo errors.
If the credit points of the registered customer do not cover the present order he/she should receive information that order cant be expected and credit points need to be purchased first (link to already existing order form).

Upon order submission customers and we should receive an email confirmation containing choice of menus, kcal and credit point values ordered as well as remaining credit points for his/her account.

Order data from all customers should be collected in MySQL.

Backend should contain a „report“ button that submits the summary of all orders received in a timeframe to be defined. The structure should be as follows:
Orders per day as the primary structure.
Each day in the report should contain:
• Total number of different menus ordered e.g. 30 Beef Steaks, 20 Lasagne etc.
• Total number and list of customers
• Per menu: names of customers ordering this specific menue
• Per customer: List of menus ordered by this specific customer

In the event of an order change after submission we would like to have the option to change customer orders in the database directly.