Objectives:
To build a Cargo Booking System
The Web App must include, but not limit to the below functions.
Development Environmental Requirements:
1. Web Programming Language: PHP 7.0.13 or above
2. Database Server: Oracle 11g Release 2 Express Edition**
3. Web Server: XAMPP 7.0.13
4. OS: Windows 7 64-bit
**Object-Relational Database (ORDBMS) must be used within the project.
~~Minimal UI is required.
Four categories of functions and one reporting function:
1. Customer
a) Perform. customer registration.
b) Submit, change and cancel customer's own shipping and delivery quotes.
c) Book and reject schedule notification from the logistics company.
Basic customer operations:
a) Perform. customer registration.
The Web App should have a customer registration page to let the customer to
register.
Eg. https://www.cargo-booking.com/index.php?page=register
b) Submit, change and cancel customer's own shipping and delivery quotes.
c) Book and reject schedule notification from the logistics company.
After Customers log in, they should select the "From country" "Loading Date",
"To country" "Unloading Date" and "Container Type" "Number of
Containers". Then, the customers should submit, change or cancel the shipping
delivery order to the company. Afterwards, the company (Logistics staff) should
conduct the shipping schedule ("Loading Date" "Unloading Date") or do re-
scheduling. Finally, the customers should accept or reject that booking order.
Examples (Partial similar):
https://www.cargo-booking.com/
http://envato.bestsoftinc.net/car-rental/
2. Logistics Staff
a) Conduct shipping scheduling and re-scheduling.
b) Assign and change delivery jobs to truckers in ports of origin and destination.
c) Updates the changes of the shipping schedule from vessel delay reports of
shipping
companies.
Basic logistics staff member operations:
a) Conduct shipping scheduling and re-scheduling
2 | P a g e
Once the customer submits a quote, the logistics staff should be able to conduct
shipping scheduling. For example, the logistics staff can follow the quotes to
arrange delivery. Also staff member can renew the delivery.
For example, the system should show the booking order statues. If shipping
companies have problem, the staff member can reschedule the delivery.
b) Assign and change delivery jobs to truckers in ports of origin and destination
The logistics staff should assign the delivery jobs to truckers to transport. The
truckers can login their page and will see the jobs.
Also the logistics staff can change the job to truckers in ports of origin and
destination because of some problem such as the ports have ship problem,
weather problem.
c) Updates the changes of the shipping schedule from vessel delay reports of
shipping companies.
Inside the webpage, there should be a link to the following page.
http://www.molpower.com/VLCWeb/UIHelp/VesselDelayReportHelp/Vessel_Delay_Report.htm
The logistics staff can see the page show this vessel delay reports. And the staff
can manually update the shipping schedule based on the vessel delay reports.
3. Truck Driver
a) Perform. trucker registration, submit and change trucker availability for delivery in
the next three months.
b) Accept and reject delivery assignment, input and change delivery status.
c) View past and future delivery assignments.
Basic tractor truck driver operations:
a) Perform. truck driver registration.
The Web App should have a customer registration page to let the truck driver to
register.
b) Submit, change and cancel truck driver's own order.
Accept or reject order notification from the logistics company.
After truck driver log in, he can accept or reject the new order from logistic
company. He can change the availability date and notify the logistic company to
do re-scheduling. Finally, the truck driver should accept or reject that booking
order.
c) The truck driver can view the past three-month and future three-month delivery
order.
4. Administrator
a) Create and delete the account for a staff member.
b) Archive trucker/staff member/customer records.
c) View present tracking records for shipping and delivery status.
Basic administrator operations:
a) when login to administrator page, the administrator can create the account to
new staff in create account page
Administrator need to input the username, password, confirm password, email
address to reset the password and the real name
Example:
b) The administrator can click the people function to edit the user account
(trucker/staff member/customer) and can sort by group like staff group, trucker
group, customer group and administrator group.
Also administrator can search by username to find the user.
When click the edit, administrator can edit the user information like password
and email address also they can blocked, active or delete the account. If
administrators delete the account, it should double confirm.
4 | P a g e
c) The function of tracking records can list all goods tracking records can show all
goods records and can sort by delivery status. The goods should have the ID,
destination, customer name and who is shipping the goods. If the administrator
chick any record, it can show more detail like delivery status, consignee, contact
number, address, email. So they can find the customer if there are any problem
of shipping
5 | P a g e
5. Reporting Function Page
1. Rank the shipping routes in ascending order of the average time needed to ship from a
given origin and to a given destination 3 months before a particular date of a year (e. g. New
Year).
2. Show the top five busiest months in the past five years in terms of the total monthly
number
of containers used.
3. Show the top five busiest destinations in the past five years in terms of the total monthly
number of service orders from the customers.
4. Show a list of customers by name who booked the service in the past five years in
descending order of the number of containers used during the summer seasons at a given
port of origin.
5. Find the peak and the average number of standard one TEU containers that were used in
a
given shipping route for the last six months.
6. List the yearly total number of services that the service missed the arrival date at a given
destination for the last five years.
7. Find the top five customers by name who used the shipping and delivery service the most
in terms of the number of completed services for the last five years.
8. Find the number of the most and the least used type of containers in a given port for the
last three years.
9. Show the current shipping departure status of all the services for a given customer.
10. Show the total number of and the type of containers that were delivered to a given port
of destination for the last two weeks.
11. List the ports sorted in descending order by the number of vessel delays within three
days in the last three months.
12. List all the delivery services that are booked by customers at an arrival port for the next
two months.
13. List all the delivery services that have not yet been assigned to a trucker in the next two
months.
14. Group the number of one TEU containers booked on a bi-weekly basis for the next three
months and group the number of all types of containers completed delivery on a bi -weekly
basis for the past three months.
15. Show the total number of booked services that were not canceled by customers
originated in a given port for the last five weeks.
16. List all the current delivery services that are being trucked away from a given port of
arrival.