- This system is for Application Development and Event-Driven Programming final output.
- This system allows user / clerk to book passenger in their chosen vessel name and trip date/ time.
- The passeger will have the option to either have their ticket printed or sent to their email address.
This is the page that will appear upon opening the application, this is where the user will input his login credentials.
This page is will show when the label link Forgot password is click, this page is when the user forgets his login credential , password in particular and want a reset.
This page will appear after logging in. The displays here includes , time and date , total sales ,number of bookings , number of cancelled bookings , and the number of trips for each of the affiliate shipping lines (within the day).
This page is where the user/clerk books the trip of a passenger. He can search trip by selecting trip date , origin and destination and a list of available trips will be displayed.
This page is where he can view previous bookings. Here is where he can cancel a booking and an email notifying the passenger regarding the cancellation will be sent.
In this page the user can generate sales report. He just choose what date to generate on the datetime picker and a display will show. He has the option to print the report is he like.
For data storage,i used mysql database , with the following credentials:
Username : Jhanez28 , Password : @Sur1nga123 , server : LOCALHOST , database : bookingsystem
contains passenger booking information
- booking_id (primary key)
- username (foreign key reference user Username)
- passenger_id (foreign key reference passenger passenger_id
- trip_id (foreign key reference trip trip_id)
- booking_amount
- booking_date
- booking_status
- date_cancelled
stores user/clerk private information
- Username (primary key)
- Password
- Email_Address
- Contact_Number
- Fname
- Lname
Stores passenger information
- passenger_id (primary key)
- passenger_fname
- passenger_lname
- passenger_age
- passenger_gender
- passenger_contactNum
- passenger_email
- passenger_ticket_number
- passenger_accomodation
contains vessel information
- boat_id (primary key)
- boat_name
- shipping_line
this contains all trip information
- trip_id (primary key)
- boat_id (foreign key reference boat boat_id)
- origin
- destination
- date_departure
- availableSeat
- trip_ETA
stores all accomodation for each of the trips
- acc_trip_id (foreign key reference trip trip_id)
- accomodation_id (primary key)
- accomodation_name
- accomodation_price
- seatAvailable
To view the whole list of events, download document here
To view the presentation , click here